Group pruning from cube, rollup, and grouping sets
US6775662B1 · kind B1 · utility
29Cited by
8References
24Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 21, 2001 |
| Grant date | Aug 10, 2004 |
| Priority date | — |
| Expiry date | Jul 1, 2022 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99935
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system rewrites queries so that they may be executed more efficiently. Queries that reference the result set of an aggregate query are rewritten to reference another aggregate query in the form of an inner query that omits groupings that can not possibly satisfy the criteria imposed by the predicates of the outer query. Thus, when the inner query is computed, only rows for groupings that satisfy the criteria are generated, conserving resources that would otherwise be wasted generating rows that could not possibly satisfy the criteria.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.