Method and apparatus for synchronizing cache with target tables in a data warehousing system
US6895471B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 22, 2000 |
| Grant date | May 17, 2005 |
| Priority date | — |
| Expiry date | Oct 8, 2022 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99952
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus for processing (transporting) data, such as in a data warehouse system. In one embodiment, the data are received from a source and compared to data in a lookup cache comprising a subset of data from a first data set (e.g., a dimension table). Instances of the data not present in a lookup cache (that is, new data) are identified. Information corresponding to these instances are generated (e.g., a unique identifier is associated with each of these instances), and the first data set is updated accordingly. The lookup cache is then updated with the new data and the unique identifiers. Accordingly, the information (data) in the lookup cache and in the first data set are in synchronization. The lookup cache does not need to be rebuilt (e.g., to update a second data set such as a fact table).
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.