摘要:
A preferred path between two selected entities is determined. Initially, there is provided a representation of the data structure in the form of a plurality of entities having relations between them indicative of roles and the relations reflecting a cardinality of one of a one-to-one, one-to-many and a many-to-one relationship between the entities. A query is entered that provides an indication of a first selected entity and a second selected entity. A preferred path is selected through the entities and relations that couples the first selected entity to the second selected entity. The preferred path is selected from a plurality of paths as a function of the number of changes in cardinality along the plurality of paths and a indicator indicative of a preferred role relating two entities.
摘要:
A graphical user interface and method of use thereof that allows users to interact with an entity relationship model. The user interface includes zones that allow users to navigate among the entities, roles and fields to create queries that are run against the model. Clicking on an entity in the shows the available fields for the entity. Users can drag and drop entities and fields onto a design surface to quickly and easily build queries. Rules are applied when either an entity or a field is dropped onto the design surface based upon the item being dropped (either an entity or a field), the position of the drop and also the properties that are associated with the item. Entities may be grouped and filtered to sort and limit the results of the query. After query is run, the results may be displayed in a separate area to the user.
摘要:
A data query and reporting method and system are provided. The method and system allow non-technical computer users to build and execute complex database queries. The method and system accommodate the need for a simple, easy-to-understand interactive and iterative means for generating and validating database queries. The method and system reduce the complexity and costs associated with retrieving useful information for organizations of all sizes, especially smaller businesses. The method and system support a robust security model, enabling organizations to protect sensitive data while providing broad data access.
摘要:
A method and system for creating and following drill links in a report are disclosed. A relational abstraction of a data store is defined, the definition including a plurality of views, scalar or aggregate fields associated with the views, and relations between the views. A report is generated that includes at least one drill link associated with a sequence of one or more relations originating at a base view of the relational abstraction. Upon selecting a drill link contained in a first report, information about the drill link is extracted from the report, and the extracted information and the destination view associated with the drill link are used to create a second report.
摘要:
A method and system for displaying a relational abstraction data store are disclosed. A relational abstraction of a data store is defined, the definition including a plurality of views, scalar or aggregate fields associated with the views, and relations between the views. The fields and relations associated with views are displayed and related to a base view through a sequence of relations. The fields displayed are constrained based upon the sequence of relations from the base view. Scalar fields are displayed where the sequence of relations does not contain a to-many relation. Aggregate fields are displayed where the sequence of relations contains at least one to-many relation. Distinct aggregate fields are displayed where the relation path sequence contains a to-many relation followed by a many-to-one relation. A field may be displayed with additional information indicating how, or whether, the fields may be used. The display of fields may be constrained in predetermined ways. The display of relations may be displayed with additional information about the nature of the relations and the sequence of the relation path. Fields and relations may be displayed using a hierarchical means of display such as in trees structures or lists, or may be displayed using a natural language description.
摘要:
A weighted multitube fluid dispenser designed to allow a user to efficiently dispense fluid stored in a bottle regardless of how they tilt the bottle. The weighted multitube fluid dispenser includes a bottle having an opening at a top end disposed opposite a bottom end and in communication with an interior designed to store liquid therein. A spray head is designed to secure overtop the opening via a rim. A hose extends from the spray head and splits into a plurality of tubes, each tube having an aperture at one end with a weight affixed. The spray head includes a nozzle in communication with the hose, and a trigger in communication with the nozzle. Thus, activating the trigger causes fluid in the bottle to traverse the plurality of tubes and exit through the nozzle, allowing the user to dispense the fluid regardless of how the bottle is tilted.
摘要:
A magnetic sensing apparatus includes a first magnetic transducer separated spatially from a second magnetic transducer and proximate to a target and a direction decoding circuit associated with the first and second magnetic transducers, wherein the direction decoding circuit produces output pulses that provide data indicative of a rotation of the target while rejecting rotational vibration signals associated with the target during a rotational detection of the target utilizing the first and second magnetic transducers without producing erroneous output pulses or missing an excessive number of the output pulses during speed and rotational detection operations thereof.
摘要:
A weighted multitube fluid dispenser designed to allow a user to efficiently dispense fluid stored in a bottle regardless of how they tilt the bottle. The weighted multitube fluid dispenser includes a bottle having an opening at a top end disposed opposite a bottom end and in communication with an interior designed to store liquid therein. A spray head is designed to secure overtop the opening via a rim. A hose extends from the spray head and splits into a plurality of tubes, each tube having an aperture at one end with a weight affixed. The spray head includes a nozzle in communication with the hose, and a trigger in communication with the nozzle. Thus, activating the trigger causes fluid in the bottle to traverse the plurality of tubes and exit through the nozzle, allowing the user to dispense the fluid regardless of how the bottle is tilted.
摘要:
A sensor is associated with a mounting surface. An O-ring is then positioned between the sensor and the mounting surface, such that the O-ring is compressible when the sensor is fixed to the mounting surface. A fixing mechanism is generally provided for permanently fixing the sensor to the mounting surface, such that the O-ring located between the sensor and the mounting surface provides a proper tension thereof which prevents the sensor from being adversely affected by vibration resulting from a harsh vibration environment in which the sensor operates. The fixing mechanism can be implemented as a fixing joint between the sensor and the mounting surface. Additionally, the O-ring and the sensor are configured with respect to one another and the mounting surface to maintain tension in the fixing joint.