Union all rewrite for aggregate queries with grouping sets

Details Union all rewrite for aggregate queries with grouping sets Union all rewrite for aggregate queries with grouping sets

2002-11-27

2008-05-27

Pham, Hung Q (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07379933

ABSTRACT:
Query rewrite techniques are provided for rewriting an aggregate query with multiple groupings using multiple summary tables. The rewrite is accomplished by expanding the aggregate query into an equivalent UNION ALL query with multiple subqueries, each containing a single grouping. One or more of the subqueries is then rewritten to reference a summary table. Thus, a grouping of an aggregate query is derived by executing a subquery that either scans the summary table for the grouping, like in the exact-match mode, or by performing a roll-up operation, like in the roll-up mode. In addition, if the grouping of some of the subqueries cannot be derived from a summary table, subqueries are combined into another subquery that computes groupings from the base tables of the aggregate query.

REFERENCES:
patent: 5897632 (1999-04-01), Dar et al.
patent: 6438537 (2002-08-01), Netz et al.
patent: 6493699 (2002-12-01), Colby et al.
patent: 6560594 (2003-05-01), Cochrane et al.
patent: 6574623 (2003-06-01), Leung et al.
patent: 6691101 (2004-02-01), MacNicol et al.
patent: 6847962 (2005-01-01), Cochrane et al.
patent: 2002/0091707 (2002-07-01), Keller
patent: 2002/0168621 (2002-11-01), Cook et al.

Affiliated with

Also associated with

Rating

Union all rewrite for aggregate queries with grouping sets does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Union all rewrite for aggregate queries with grouping sets, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Union all rewrite for aggregate queries with grouping sets will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3987398