Displaying relevant abstract database elements
First Claim
Patent Images
1. A computer-implemented method for displaying a collection of logical fields used to compose an abstract query, comprising:
- identifying a selection of a model entity by use of one or more computer processors, wherein the model entity specifies a logical focus for the abstract query and wherein the model entity is defined by a database abstraction model as a set of database relations, wherein each relation specifies a first database structure and a second database structure of a physical database underlying the database abstraction model, and wherein the first database structure and the second database structure store data related to the model entity;
identifying the first database structure and second database structure referenced by each of the one or more relations in the definition of the model entity in the database abstraction model;
for each database structure referenced by the one or more relations, identifying one or more logical fields defined by the database abstraction model which reference a respective one of the database structures; and
outputting, for display in a query interface, the identified one or more of logical fields relevant to the selected model entity.
2 Assignments
0 Petitions
Accused Products
Abstract
Embodiments of the invention enable users of an abstract database to use logical fields that are relevant to a given model entity. In one embodiment, a user may be presented with a query interface that includes relevant fields, and which may be used to compose abstract queries. In another embodiment, the query interface may include an initial query result, and may include relevant fields for model entities included in the initial query result. The query interface may be configured to enable a user to perform subsequent query operations using the included relevant fields.
-
Citations
21 Claims
-
1. A computer-implemented method for displaying a collection of logical fields used to compose an abstract query, comprising:
-
identifying a selection of a model entity by use of one or more computer processors, wherein the model entity specifies a logical focus for the abstract query and wherein the model entity is defined by a database abstraction model as a set of database relations, wherein each relation specifies a first database structure and a second database structure of a physical database underlying the database abstraction model, and wherein the first database structure and the second database structure store data related to the model entity; identifying the first database structure and second database structure referenced by each of the one or more relations in the definition of the model entity in the database abstraction model; for each database structure referenced by the one or more relations, identifying one or more logical fields defined by the database abstraction model which reference a respective one of the database structures; and outputting, for display in a query interface, the identified one or more of logical fields relevant to the selected model entity. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer-readable storage medium containing a program which, when executed, performs an operation, comprising:
-
identifying a selection of a model entity, wherein the model entity specifies a logical focus for the abstract query and wherein the model entity is defined by a database abstraction model as a set of database relations, wherein each relation specifies a first database structure and a second database structure of a physical database underlying the database abstraction model, and wherein the first database structure and the second database structure store data related to the model entity; identifying the first database structure and second database structure referenced by each of the one or more relations in the definition of the model entity in the database abstraction model; for each database structure referenced by the one or more relations, identifying one or more logical fields defined by the database abstraction model which reference a respective one of the database structures; and outputting, for display in a query interface, the identified one or more of logical fields relevant to the selected model entity. - View Dependent Claims (9, 10, 11, 12, 13)
-
-
14. The computer-readable storage medium 8, wherein the operation of identifying one or more logical fields is performed each time the query interface is displayed for a given model entity.
-
15. A system, comprising:
-
a processor; and a memory containing a program configured to perform an operation, comprising; identifying a selection of a model entity, wherein the model entity specifies a logical focus for the abstract query and wherein the model entity is defined by a database abstraction model as a set of database relations, wherein each relation specifies a first database structure and a second database structure of a physical database underlying the database abstraction model, and wherein the first database structure and the second database structure store data related to the model entity; identifying the first database structure and second database structure referenced by each of the one or more relations in the definition of the model entity in the database abstraction model; for each database structure referenced by the one or more relations, identifying one or more logical fields defined by the database abstraction model which reference a respective one of the database structures; and outputting, for display in a query interface, the identified one or more of logical fields relevant to the selected model entity. - View Dependent Claims (16, 17, 18, 19, 20, 21)
-
Specification