Using point-in-time views in a database
US10740283B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Jan 31, 2011 |
| Grant date | Aug 11, 2020 |
| Priority date | — |
| Expiry date | Jan 31, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/00
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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…
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.