Abstract record timeline rendering/display
First Claim
1. A method of displaying physical data retrieved from an underlying physical database, comprising:
- providing a database abstraction model defining;
(a) a plurality of logical fields each having an access method that specifies at least a method for accessing the physical data associated with the logical field; and
(b) a plurality of model entities, wherein each model entity identifies (i) a set of logical fields each mapping to logically related physical data; and
(ii) an identifier in the database used to identify instances of the model entity;
wherein, for each model entity, a first logical field of the corresponding set of logical fields includes a timeline attribute defining a timeline for the model entity and wherein a second logical field of the corresponding set of logical fields includes a timeline attribute defining where the physical data associated with the second logical field occurs on the timeline;
receiving a request to display data related to an instance of one of the plurality of model entities;
retrieving, from the database, physical data corresponding to the set of logical fields for the instance of the model entity;
displaying the timeline for the instance, based on the timeline attribute for the first logical field ; and
displaying an event on the timeline, based on the timeline attribute for the second logical field, wherein the event corresponds to the physical data associated with the second logical field.
1 Assignment
0 Petitions
Accused Products
Abstract
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 and displayed on a timeline. 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.
-
Citations
20 Claims
-
1. A method of displaying physical data retrieved from an underlying physical database, comprising:
-
providing a database abstraction model defining;
(a) a plurality of logical fields each having an access method that specifies at least a method for accessing the physical data associated with the logical field; and
(b) a plurality of model entities, wherein each model entity identifies (i) a set of logical fields each mapping to logically related physical data; and
(ii) an identifier in the database used to identify instances of the model entity;
wherein, for each model entity, a first logical field of the corresponding set of logical fields includes a timeline attribute defining a timeline for the model entity and wherein a second logical field of the corresponding set of logical fields includes a timeline attribute defining where the physical data associated with the second logical field occurs on the timeline;
receiving a request to display data related to an instance of one of the plurality of model entities;
retrieving, from the database, physical data corresponding to the set of logical fields for the instance of the model entity;
displaying the timeline for the instance, based on the timeline attribute for the first logical field ; and
displaying an event on the timeline, based on the timeline attribute for the second logical field, wherein the event corresponds to the physical data associated with the second logical field. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A system for accessing data in an underlying physical database, comprising:
-
a database abstraction model defining (i) a plurality of logical fields, wherein each logical field specifies at least an access method mapping the logical field to data in the physical database, and wherein at least one logical field includes a timeline attribute that indicates where data elements retrieved for the logical field occur on a timeline, and (ii) a plurality of model entities each specifying an item of data in the database used to identify an instance of the model entity and further specifying an abstract record associated with the model entity, wherein the abstract record specifies a set of logical fields that map to data related to the model entity;
a database query application configured to display data related to the instance of the model entity, including the display of at least some of the data rendered on a timeline, relative to the model entity; and
a runtime component configured (i) to receive, from the database query interface, a request to view the data related to the instance of the model entity, and in response, to generate and execute a physical query of the database, wherein executing the physical query retrieves a set of query results corresponding to the set of logical fields and (ii) to return the query results to the query building interface. - View Dependent Claims (11, 12, 13, 14)
-
-
15. A program product, comprising:
-
a computer readable medium containing a program, comprising;
(a) a plurality of logical fields each having an access method that specifies at least a method for accessing the physical data associated with the logical field;
(b) a plurality of model entities, wherein each model entity identifies (i) a set of logical fields, from the plurality of logical fields, that map to logically related physical data; and
(ii) an identifier in the underlying database used to identify instances of the model entity;
wherein a first logical field of each set of logical fields for each model entity includes a timeline attribute defining a timeline for the model entity and wherein a second logical field of each set of logical fields for each model entity defines where the physical data associated with the second logical field occurs on the timeline for the model entity; and
(c) a database query application configured to receive a request to display data related to an instance of one of the plurality of model entities, and in response to receiving the request;
retrieve, from a physical database, physical data corresponding to the set of logical fields for the instance model entity;
display the timeline for the instance, based on the timeline attribute for the first logical field; and
display an event on the timeline, based on the timeline attribute for the second logical field, wherein the event corresponds to the physical data associated with the second logical field. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification