Systems and methods for proactive caching utilizing OLAP...

Details Systems and methods for proactive caching utilizing OLAP... Systems and methods for proactive caching utilizing OLAP...

2007-09-11

2007-09-11

Rimell, Sam (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

10402000

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.

REFERENCES:
patent: 5878223 (1999-03-01), Becker et al.
patent: 5926818 (1999-07-01), Malloy
patent: 5978796 (1999-11-01), Malloy et al.
patent: 6205447 (2001-03-01), Malloy
patent: 6216212 (2001-04-01), Challenger et al.
patent: 6493718 (2002-12-01), Petculescu et al.
patent: 6763357 (2004-07-01), Deshpande et al.
patent: 2002/0129032 (2002-09-01), Bakalash et al.
Albrecht et al. Building a Real Data Warehouse for Market Research IEEE 1997 p. 651-656.
Roy et al. “Query Result Caching in Data Warehouses and Data Marts” IIT Bombay Apr. 16, 1999, pp. 1-13.
Kalnis et al. “Proxy-Server Architectures for OLAP” ACM Sigmond 2001, pp. 367-378.
Panos Kalnis and Dimitris Papadias. Proxy-Server Architectures for OLAP. Proceedings of the 2001 ACM SIGMOD Conference, pp. 367-378.
Dennis Shasha. The Emergence of the Data Warehouse. Department of Computer Science, New York University, Aug. 2000, 13 pages.
Yihong Zhao, Kristin Tufte, and Jeffrey R. Naughton. On the Performance of an Array-Based ADT for OLAP Workloads. Technical Report CS-TR-96-1313, University of Wisconsin-Madison, CS Department, May 1996. 20 pages.
Volker Markl Frank Ramsak, and Rudolf Bayer, Improving OLAP Performance by Multidimensional Hierarchical Clustering. IEEE Proceedings of IDEAS'99. 13 pages.
EP Search Report dated Mar. 23, 2006; mailed Mar. 27, 2006: EP Patent Application No. 04 00 6401; 2 pages.
Loukopoulos et al.; Active Caching of On-Line Analytical-Processing Queries in WWW Proxies; 2001; 8 pages.
Shin'ichirou, et al.; Parallel Generation of Base Relation Snapshots for Materialized View Maintenance in Data Warehouse Environment; 2002; 8 pages.
Kalnis, et al.; An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results; 2002; 12 pages.
Deshpande, et al.; Caching Multidimensional Queries Using Chunks; 1998; 12 pages.

Affiliated with

Also associated with

Rating

Systems and methods for proactive caching utilizing OLAP... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Systems and methods for proactive caching utilizing OLAP..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems and methods for proactive caching utilizing OLAP... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3773649