Maintaining views of cube-based operations in a database system

Data processing: database and file management or data structures – File or database maintenance – Synchronization

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

Reexamination Certificate

active

07933867

ABSTRACT:
A database system includes a storage to store a view containing results of a cube-based operation on at least one base table, with the view containing a first result set for a group-by on a first grouping set, and a second result set for a group-by on a second grouping set. In response to a change to the at least one base table, a controller updates the first result set by computing a change to the first result set based on a change in the at least one base table, and updates the second result set by computing a change to the second result set based on the change to the first result set.

REFERENCES:
patent: 6775662 (2004-08-01), Witkowski et al.
patent: 7035843 (2006-04-01), Bellamkonda et al.
patent: 7058640 (2006-06-01), Le
patent: 7111020 (2006-09-01), Gupta et al.
patent: 7158994 (2007-01-01), Smith et al.
patent: 7181450 (2007-02-01), Malloy et al.
patent: 7181452 (2007-02-01), Luo et al.
patent: 2003/0093407 (2003-05-01), Cochrane et al.
patent: 2004/0260684 (2004-12-01), Agrawal et al.
Jose A. Blakeley , Per-Ake Larson , Frank Wm Tompa, Efficiently updating materialized views, Proceedings of the 1986 ACM SIGMOD international conference on Management of data, p. 1-11, May 28-30, 1986, Washington, D.C., United States.
Segev, A.; Park, J.; , “Updating distributed materialized views,” Knowledge and Data Engineering, IEEE Transactions on , vol. 1, No. 2, pp. 173-184, Jun. 1989.
Cubetree: Organization of and Bulk Incremental Updates on the Data Cube (1997) by Nick Roussopoulos , Yannis Kotidis , Mema Roussopoulos Proceedings of the 1997 ACM SIGMOD Conference.
Inderpal Singh Mumick et al., “Maintenance of Data Cubes and Summary Tables in a Warehouse,” Proceedings of SIGMOD '97, AZ, USA, pp. 100-111 (1997).
Frank Dehne et al., “Computing Partial Data Cubes for Parallel Data Warehousing Applications,” 8 pages (2001).
Sunita Sarawagi, “On Computing the Data Cube,” pp. 1-18 (1996).
Jim Gray et al., “Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals,” pp. 1-9 (1995).
Rajiv Tewari, “Optimizing Cube Performance with OLAP Services: Processing times for each storage type,” pp. 1-4, printed from http://www.sqlmag.com (as early as Sep. 2000).
Rajiv Tewari, “Optimizing Cube Performance with OLAP Services: These test results reveal concrte steps you can take to improve multidimensional database performance,” pp. 1-3,(as early as Sep. 2000).
IBM Redbooks, “DB2 OLAP Server Theory and Pratices,” pp. 1-263 (2001).

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Maintaining views of cube-based operations in a database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Maintaining views of cube-based operations in a database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Maintaining views of cube-based operations in a database system will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-2706164

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.