Model entity operations in query results
View Patent ↗The present invention provides methods, systems and articles of manufacture that enhance the capability of a database abstraction model and query application constructed for an underlying physical database. Typically, the query application is used to compose and execute an abstract query. Once an initial query result is presented to a user, a user may select to execute a model entity operation by interacting with a query interface of the query application. A model entity operation allows the user to retrieve additional information from the underlying database, based on information included in the initial query result, without having to create a new query or having to correlate the results of multiple queries.
1. A method for processing a data access request, comprising:
receiving a user request to perform a model entity operation, wherein the user request includes a user selection of a first instance of a model entity selected from a plurality of instances of the model entity included in a first query result and a selected query operation, wherein the model entity is defined by a database abstraction model logically describing an underlying database and wherein the model entity defines a focus for the selected query operation, and wherein instances of the model entity are distinguished by an identifier in an underlying database;
retrieving, in response to the user request, a linking function configured to identify instances of the model entity that are related to the first instance of the model entity, according to a predefined relationship; and
performing the model entity operation by:
invoking the linking function to retrieve any instances of the model entity that are related to the first instance of the model entity;
executing the selected query operation against the retrieved instances of the model entity; and
returning, as a second query result, at least a second instance of the model entity that satisfies any conditions specified by the selected query operation.
2. The method of claim 1 , wherein the first instance of the model entity is selected using a graphical user interface displaying the first query result which provides the plurality of instances of the model entity as user selectable options, which when selected, specifies the linking function and the selected query operation to initiate using the first instance of the model entity.
3. The method of claim 1 , wherein the first instance of the model entity is selected from a display of query results retrieved in response to executing an abstract query, wherein the abstract query is composed from a plurality of logical fields defined by the database abstraction model, wherein each logical field specifies a mapping for a logical field to data in the underlying physical database.
4. The method of claim 1 , wherein the identifier in the physical database comprises a primary key from a column of a relational table, and wherein the identifier used to distinguish instances of the model entity comprises values stored in the primary key column of the relational table.
5. The method of claim 4 , wherein the linking function comprises an SQL query configured to retrieve values stored in the primary key column of the relational table related to a primary key value input to the function.
6. The method of claim 1 , wherein the first instance of the model entity represents an individual, and wherein the linking function identifies additional instances of the model entity that represent individuals sharing a consanguineous relationship with the individual represented by the first instance of the model entity.
7. The method of claim 1 , wherein the model entity represents an individual, and wherein the linking function identifies additional instances of the model entity that represent individuals related to one another by geographic locations.