Using point-in-time views to provide varying levels of data freshness

• US 7,882,103 B2
• Filed: 03/28/2002
• Issued: 02/01/2011
• Est. Priority Date: 03/28/2002
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Brobst, Stephen A.
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US10/109,025
• Publication Number:
  US 20030187862A1
• Time in Patent Office: 3,232 Days
• Field of Search: 707 1- 3, 707/10, 707/102, 707/5, 707/109.1, 707/717, 707/718, 707/721, 707/723, 707/730
• US Class Current: 707/717
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor

Abstract

A data-warehousing system allows various areas of an enterprise to view data at varying levels of data freshness. The system acquires data that represents an event in the life of a business enterprise, such as a transaction between the enterprise and one of its customers, and loads this data into a database table. The system then makes the data available for retrieval from the table and stores information indicating when the data was made available for retrieval. In some embodiments, the system also acquires data that is related to and more current than the data representing the event and stores the more current data in the database. The system then stores information indicating when the more current data was stored in the database. Such a data warehouse allows decision-makers in the business to see some information (e.g., customer transaction or account data) up-to-the-moment and other information as it stood at some specific point-in-time, such as at the end of the previous month. The data-warehousing system does this without requiring duplication of data, i.e., without requiring the replication of data in multiple databases or tables. The system allows the enterprise to maintain all of its data in a single database with refresh periods as short as the enterprise wishes. Departments that demand data that changes less frequently can view the data as it stood at some point prior to the last refresh.

Claims

1. A method for use in allowing the user of a database to view data representing events in the life of a business enterprise, where the data is stored in one or more database tables that include a first set of records indicating when the events occurred and a second set of records indicating when the data was made available for retrieval from the database, the method comprising:

receiving a request for data representing one or more events that occurred at or before a selected point-in-time, where the request occurs at some point after the selected point-in-time has passed;

accessing the information stored in the first and second sets of records to identify when the events occurred and when data corresponding to the events was made available for retrieval;

selecting from the table data for which;

(a) the first set of records indicates that a corresponding one of the events occurred at or before the selected point-in-time; and

(b) the second set of records indicates that the data was made available for retrieval at or before the selected point-in-time; and

delivering the selected data to for presentation to the user.

4. The method of claim 1, where the step of delivering the selected data for presentation to the user includes creating a database view through which the data is displayed.

5. The method of claim 1, where the step of delivering the selected data for presentation to the user includes creating another database table and extracting the selected data into that table.

6. The method of claim 1, where receiving a request from the user includes receiving input that does not include database-query code.

12. The method of claim 6, where receiving input from the user includes receiving only information that identifies the selected point-in-time.

2. A database system comprising:

a database that includes one or more tables of data stored on one or more storage facilities and managed by one or more processing units, where the one or more tables include;

entries that store data representing one or more events in the life of a business enterprise;

a first set of records that stores information indicating when the events occurred; and

a second set of records that stores information indicating when the data was loaded into the database; and

a data-management component configured to;

receive a request for data representing one or more of the events that occurred at or before a selected point-in-time, where the request occurs at some point after the selected point-in-time has passed;

access the information stored in the first and second sets of records to identify when the events occurred and when data corresponding to the events was loaded into the table;

select from the table data for which;

(a) the first set of records indicates that a corresponding one of the events occurred at or before the selected point-in-time; and

(b) the second set of records indicates that the data was loaded into the database at or before the selected point-in-time; and

deliver the selected data for presentation to the user.

7. The system of claim 2, where the database also stores newer data that is related to and more current than the data representing one or more of the events, and where the one or more tables include a third set of records indicating when the newer data was stored in the database.

3. A computer program, stored on a tangible storage medium, for use in allowing the user of a database to view data representing events in the life of a business enterprise, where the data is stored in one or more database tables that include a first set of records indicating when the events occurred and a second set of records indicating when the data was made available for retrieval from the database, the program comprising executable instructions that cause a computer to:

receive a request for data representing one or more events that occurred at or before a selected point-in-time, where the request occurs at some point after the selected point- in-time has passed;

access the information stored in the first and second sets of records to identify when the events occurred and when data corresponding to the events was made available for retrieval;

select from the table data for which;

(a) the first set of records indicates that a corresponding one of the events occurred at or before the selected point-in-time; and

(b) the second set of records indicates that the data was made available for retrieval at or before the selected point-in-time; and

deliver the selected data for presentation to the user.

8. The program of claim 3, where, in delivering the selected data for presentation to the user, the computer creates a database view through which the data is displayed.

9. The program of claim 3, where, in delivering the selected data for presentation to the user, the computer creates another database table and extracts the selected data into that table.

10. The program of claim 3, where, in receiving a request from the user, the computer receives input that does not include database-query code.

11. The program of claim 10, where, in receiving input from the user, the computer receives only information that identifies the selected point-in-time.