摘要:
An apparatus and method modify a saved query based on a change in a query value meaning that changes over time. In preferred embodiments a graphical query interface displays an option to adjust query values of a saved database query. A query adjustment mechanism then adjusts the value of the query to compensate for the change in the meaning of the query value since the query was created such that the adjusted query will have the same basic meaning as when the query was originally created. Preferred Embodiments allow the user to specify to adjust the query to the current date or to a specified date in the past.
摘要:
A method and apparatus for representing a continuum of data as a rolling column within a relational model is disclosed. Data from a continuous data source may be used to populate a rolling column. Metadata defining the rolling column specifies the correct portion of data from the continuum of data that should be used to populate the rolling column. Whenever data from the rolling column is included in a data access request, such as a database query, a database management system may be configured to update the rolling column, according to the metadata.
摘要:
A method, system and article of manufacture for processing rule sets and, more particularly, for processing abstract rule sets. One embodiment provides a computer-implemented method of managing execution of an analysis routine configured to process one or more inputs. The analysis routine is defined by at least one abstract rule set having one or more abstract rules each having a conditional statement and a consequential statement. The method comprises determining, from the retrieved analysis routine, a predefined validating condition that needs to be satisfied by at least one of the inputs, and validating a particular data value defining the at least one of the inputs on the basis of the predefined validating condition. If the particular data value is not validated, a predefined action configured to avoid execution of the analysis routine on invalid inputs is performed.
摘要:
A method, apparatus, and article of manufacture are provided to optimize the time and effort required to locate all data on a given entity that may span multiple data nodes in a distributed environment. For example, embodiments of the invention may be used to locate nodes within the distributed environment that store electronic healthcare records. A poll request from a first node to a second node may include electronic records existence data indicating data nodes known to have, or not have, records related to a given individual. This information is used to minimize the number of nodes that need to be polled to arrive at the complete aggregation of patient records that exist within a given set of nodes.
摘要:
Embodiments of the invention provide methods, systems and articles of manufacture for constructing a database abstraction model over an underlying physical database. Typically, queries of the database abstraction model are directed to queries of a model entity defined for the database abstraction model. To compose an abstract query, users select conditions evaluated using data associated with instances of the model entity. Using the database abstraction model, users may compose an abstract query according to logical or intuitive relationships among data elements stored in the underlying database. One addition to the database abstraction model is the ability to apply query criteria against related instances of a model entity. Because model entities may share a predefined relationship, embodiments of the invention allow for users to specify query criteria applied against related instances. Related instances may be identified by invoking a path function provided by the database abstraction model. A path function may be configured to return instances of the model entity that are related to an instance input to the path function.
摘要:
Embodiments of the invention provide techniques for constructing a database abstraction model over an underlying physical database. Once constructed, users may interact with the database abstraction model, rather than the underlying physical database representation, to query the database and view query results. In one embodiment, information is retrieved from the underlying physical database that is related to a model entity. Generally, a model entity identifies the logical focus, or the central entity, being queried by user interacting with a query application. An abstract record identifies what data about each model entity is available to query using the database abstraction model. In addition, once presented with data for an instance of a first model entity, embodiments of the invention provide for a user to switch the display presented to an instance of a second model entity. A conversion function may be used to map between model entities.
摘要:
A method, system and article of manufacture for managing access to a data abstraction model abstractly describing physical data and, more particularly, for creating a logical security model for a data abstraction model abstractly describing data in a database. One embodiment provides a computer-implemented method for creating a logical security model based on a physical security model defining user access rights to physical data. The method comprises, for each of the user access rights defined by the physical security model, creating a logical access right definition for a logical model. The logical model comprises a plurality of logical field definitions each comprising a field name and access information for accessing a field of the physical data. The logical access right definitions are applied to the logical model so that the logical model reflects the user access rights to the physical data.
摘要:
Embodiments of the present invention provide methods for constructing a database abstraction model that includes logical fields that map to a logical table. The logical table is constructed using data extracted from multiple, differently formatted physical tables. The logical table allows logically related data stored in multiple databases to appear as data from a single table. Relationships between data stored in multiple, differently formatted databases are maintained and logical fields that include multiple access methods that map to the multiple databases are replaced with a single access method that maps to the logical table. Data relationships that are defined for the database abstraction model are modified to reflect the logical table.
摘要:
An apparatus and method for a graphical user interface allow performing operations simply by dragging a first object over a second object. One or more attributes of the second object are effectively “picked up” by virtue of dragging over the second object. In this manner, the user interface is more friendly, more intuitive, and reduces the number of pointer clicks to implement a particular function, thereby enhancing the efficiency of the user.
摘要:
A method, system and article of manufacture for managing interdependent data objects and, more particularly, for managing modifications to at least one of a plurality of interdependent data objects. One embodiment provides a computer-implemented method of managing modifications to at least one of a plurality of interdependent data objects. The method comprises receiving a request for modification of a given data object having at least one dependent data object. The method further comprises accessing a directory of dependencies containing at least one record for each of the plurality of interdependent data objects including the at least one dependent data object. Each record describes an interdependency between at least two of the interdependent data objects. A record for the at least one dependent data object describes an interdependency between the given data object and the at least one dependent data object. Using the accessed directory of dependencies, the interdependency between the given data object and the at least one dependent data object is identified. On the basis that the identified interdependency presents a possible undesired consequence if the requested modification is performed, a predefined action is performed.