Systems and methods for proactive caching utilizing olap variants

• US 20060112137A1
• Filed: 01/11/2006
• Published: 05/25/2006
• Est. Priority Date: 03/28/2003
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Petculescu, Cristian, Conlon, Thomas P., Netz, Amir
• Granted Patent: US 7,689,605 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/957 Multidimensional
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

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.

Claims

1. A data packet transmitted between two or more computer components that facilitates data analysis, the data packet comprising dynamic multidimensional analysis data, based, in part, on a proactive caching structure.

2. The data packet of claim 1, the dynamic multidimensional analysis data comprising at least one selected from the group consisting of a multidimensional object data derived from a database and a dynamic multidimensional analysis data derived from at least one multidimensional object.

3. The data packet of claim 2, the dynamic multidimensional analysis data derived from at least one multidimensional object comprising data from a MOLAP cache.

4. The data packet of claim 2, the multidimensional object data comprising data from an OLAP object.

5. The data packet of claim 4, the OLAP object comprising a ROLAP object.

6. The data packet of claim 2, the database comprising a relational database.