Query processing system that computes GROUPING SETS, ROLLUP, and

Details Query processing system that computes GROUPING SETS, ROLLUP, and Query processing system that computes GROUPING SETS, ROLLUP, and

1997-06-30

1999-10-05

Fetting, Anton

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 707 5, G06F 1730

Patent

active

059639369

ABSTRACT:
Method and apparatus for detecting and stacking grouping sets to support GROUP BY operations with GROUPING SETS, ROLLUP and CUBE extensions in relational database management systems, with greatly reduced numbers of grouping sets. A first GROUP BY (element-list1) is input to a second GROUP BY (element-list2), resulting in the GROUP BY of the intersection of the two lists. This intersection property is then useable to reduce the number of GROUP BYs required to implement the grouping by GROUPING SETS, ROLLUPs, and CUBEs required for the online analytical processing of data contained in the database.

REFERENCES:
patent: 5511190 (1996-04-01), Sharma et al.
patent: 5537589 (1996-07-01), Dalal
patent: 5546576 (1996-08-01), Cochrane et al.
patent: 5590324 (1996-12-01), Leung et al.
patent: 5598559 (1997-01-01), Chaudhuri
patent: 5713020 (1998-01-01), Reiter et al.
patent: 5724570 (1998-03-01), Zeller et al.
patent: 5761653 (1998-06-01), Schiefer et al.
patent: 5781896 (1998-07-01), Dalal
patent: 5794229 (1998-08-01), French et al.

Affiliated with

Also associated with

Rating

Query processing system that computes GROUPING SETS, ROLLUP, and does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query processing system that computes GROUPING SETS, ROLLUP, and, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query processing system that computes GROUPING SETS, ROLLUP, and will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1183483