发明申请
- 专利标题: INDIRECT DATABASE QUERIES WITH LARGE OLAP CUBES
- 专利标题(中): 使用大型OLAP CUBES进行间接数据库查询
-
申请号: US12403501申请日: 2009-03-13
-
公开(公告)号: US20100235345A1公开(公告)日: 2010-09-16
- 发明人: Celestine Joseph , Joyce Behrendt , Joshua Chait Caplan
- 申请人: Celestine Joseph , Joyce Behrendt , Joshua Chait Caplan
- 申请人地址: US WA Redmond
- 专利权人: MICROSOFT CORPORATION
- 当前专利权人: MICROSOFT CORPORATION
- 当前专利权人地址: US WA Redmond
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
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.
公开/授权文献
- US08219547B2 Indirect database queries with large OLAP cubes 公开/授权日:2012-07-10