Visual display of information using historical condition support and event profiles

• US 20060294066A1
• Filed: 06/23/2005
• Published: 12/28/2006
• Est. Priority Date: 06/23/2005
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kolz, Daniel P., Dettinger, Richard D., Tenner, Jeffrey W.
• Application Number:
  US11/165,387
• Publication Number:
  US 20060294066A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

A method, system and article of manufacture for providing a visual display of information that quickly conveys how information, as represented by data retrieved for a set of queries, may have changed over time is disclosed. By animating information retrieved for a plurality of queries, a visual display is created that conveys how a data in a database has changed over time. Users compose a query template specifying a plurality of queries. The query template further specifies a time period and frequency range over which the queries in the query template should be executed. After executing a query to retrieve data corresponding to each point in time, a snapshot of the database is available to generate the visual display of information.

Claims

1. A method of providing a visual display of data in a database, comprising:

receiving a query template, wherein the query template specifies;

a plurality of database queries; and

a temporal data sampling specification specifying a set of points in time for which at least one query should be executed to retrieve data, consistent with the state of the database at each point in time;

executing the at least one query to retrieve data corresponding to the state of the database for each of the points in time; and

generating a visual display from the retrieved data, wherein the visual display conveys how the data retrieved for the plurality of individual queries has changed over a time period defined by the points in time.

2. The method of claim 1, wherein the temporal data sampling specification specifies time period and frequency data.

3. The method of claim 1, wherein the plurality of database queries are selected from a repository of existing queries.

4. The method of claim 1, wherein each of the plurality of individual queries comprises an abstract query composed according to a database abstraction model, wherein the database abstraction model defines a plurality of logical fields, and wherein each logical field specifies an access method for accessing data in the database corresponding to the logical field.

5. The method of claim 4, wherein executing the plurality of individual queries comprises:

transforming each abstract query into a query consistent with the particular physical data representation used by the database; and

issuing the transformed queries against the database.

6. The method of claim 4, wherein at least one logical field included in the at least one query specifies a conditional modifier indicating that the at least one logical field should access a value for the logical field corresponding to the value for the logical field that existed in the database, at a point in time specified by the conditional modifier.

7. The method of claim 1, wherein the visual display comprises an animated display that conveys how data retrieved for the plurality of queries has changed, relative to one another, over the time period covered by the specific points in time.

8. A method for processing a database query, comprising:

prompting a user to identify (i) a plurality of queries to include in a query template, (ii) which queries, from the plurality of queries, to execute for a plurality of specific points in time; and

(iii) the specific points in time;

generating, from the query template, database queries, wherein each database query is configured to retrieve data from the database consistent with one of the specific points in time;

executing the generated queries to retrieve data values that existed in the database for the specific points in time; and

generating, from the retrieved data, a visual display, wherein the visual display conveys how the data has changed, over the time period covered by the specific points in time.

9. The method of claim 8, wherein the plurality of queries are selected from a repository of existing queries.

10. The method of claim 8, wherein each of the plurality of queries comprises an abstract query composed according to a database abstraction model, wherein the database abstraction model defines a plurality of logical fields, and wherein each logical field specifies an access method for accessing data in the database corresponding to the logical field.

11. The method of claim 10, wherein executing the generated queries comprises:

transforming each abstract query into a query consistent with a particular physical data representation used by the database; and

issuing the transformed queries against the database.

12. The method of claim 10, wherein at least one logical field included in one of the plurality of query specifies a conditional modifier indicating that the at least one logical field should access a value for the logical field corresponding to a prior value for the logical field that existed in the database, at a point in time specified by the conditional modifier.

13. The method of claim 8, wherein the visual display comprises an animated display that conveys how data retrieved for the plurality of queries has changed, relative to one another, over the time period covered by the specific points in time.

14. A computer-readable medium containing a program, which when executed on a computer system performs an operation for accessing data stored in an underlying physical database, comprising:

receiving a query template, wherein the query template specifies;

a plurality of database queries; and

a temporal data sampling specification specifying a set of points in time for which at least one query should be executed to retrieve data, consistent with the state of the database at each point in time;

executing the at least one query to retrieve data corresponding to the state of the database for each of the points in time; and

generating a visual display from the retrieved data, wherein the visual display conveys how the data retrieved for the plurality of individual queries has changed over a time period defined by the points in time.

15. The computer-readable medium of claim 14, wherein the plurality of database queries are selected from a repository of existing queries.

16. The computer-readable medium of claim 14, wherein each of the plurality of database queries comprises an abstract query composed according to a database abstraction model, wherein the database abstraction model defines a plurality of logical fields, and wherein each logical field specifies an access method for accessing data in the database corresponding to the logical field.

17. The computer-readable medium of claim 16, wherein executing the generated queries comprises:

transforming each abstract query into a query consistent with a particular physical data representation used by the database; and

issuing the transformed queries against the database.

18. The computer-readable medium of claim 16, wherein at least one logical field included in one of the plurality of query specifies a conditional modifier indicating that the at least one logical field should access a value for the logical field corresponding to a prior value for the logical field that existed in the database, at a point in time specified by the conditional modifier.

19. The computer-readable medium of claim 14, wherein the visual display comprises an animated display that conveys how data retrieved for the plurality of queries has changed, relative to one another, over the time period covered by the specific points in time.

20. A system for presenting a visual display of information that shows how data in a database has changed over time, comprising:

a physical database, wherein the physical database includes a data source that may be queried to determine the state of the database that existed at different points in time;

a database query application comprising;

a user interface configured to generate a query template by prompting a user to identify (i) a plurality of queries to include in a query template, (ii) which queries, from the plurality of queries, to execute for a plurality of specific points in time; and

(iii) the specific points in time;

a runtime component configured to generate, from the query template, a plurality of queries configured to retrieve data values that existed in the database corresponding to the points in time, and to execute the generated queries of the database to retrieve data for the points in time; and

a user display generator configured to generate, from the retrieved data, a visual display, wherein the visual display conveys how the data has changed over a time period defined by the points in time.

21. The system of claim 20, wherein the plurality of queries each comprise an abstract query composed according to a database abstraction model, wherein the database abstraction model defines a plurality of logical fields, and wherein each logical field specifies an access method for accessing data in the database corresponding to the logical field.

22. The system of claim 20, wherein executing the plurality of queries comprises transforming each abstract query into a query consistent with the particular physical data representation used by the database, and issuing the transformed queries against the database.