Systems and methods for proactive caching utilizing OLAP variants
US7269581B2 · kind B2 · utility
3Cited by
7References
38Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Mar 28, 2003 |
| Grant date | Sep 11, 2007 |
| Priority date | — |
| Expiry date | May 26, 2024 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99933
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
The present invention leverages MOLAP performance for ROLAP objects (dimensions, partitions and aggregations) by building, in a background process, a MOLAP equivalent of that object. When the background processing completes, queries are switched from ROLAP queries to MOLAP queries. When changes occur to relevant relational objects (such as tables that define content of OLAP objects), an OLAP object is switched back to a ROLAP mode, and all relevant caches are dropped while, as a background process, a new MOLAP equivalent is created.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.