Invention Grant
- Patent Title: Indirect database queries with large OLAP cubes
- Patent Title (中): 使用大型OLAP多维数据集的间接数据库查询
-
Application No.: US12403501Application Date: 2009-03-13
-
Publication No.: US08219547B2Publication Date: 2012-07-10
- Inventor: Celestine Joseph , Joyce Behrendt , Joshua Chait Caplan
- Applicant: Celestine Joseph , Joyce Behrendt , Joshua Chait Caplan
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Ogilvie Law Firm
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
A large OLAP cube includes data and dimensions not required for a particular query, or for a collection of queries. A response to a query is generated by using the large OLAP cube rather than using an OLAP cube tailored to the query, and rather than querying the relational database directly. The large OLAP cube may be created after identifying a set of frequently sought data and/or filters used in queries to the relational database. Data may be staged by creating a smaller OLAP cube with data extracted from the large OLAP cube. The cubes may then be queried, browsed, and used to prepare reports or generate flat files.
Public/Granted literature
- US20100235345A1 INDIRECT DATABASE QUERIES WITH LARGE OLAP CUBES Public/Granted day:2010-09-16
Information query