Optimization of SQL queries involving aggregate expressions using a plurality of local and global aggregation operations
US5884299A · kind A · utility
243Cited by
1References
42Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Feb 6, 1997 |
| Grant date | Mar 16, 1999 |
| Priority date | — |
| Expiry date | Feb 6, 2017 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99933
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method, apparatus, and article of manufacture for optimizing SQL queries in a relational database management system involving aggregate and grouping functions. A local aggregation operation is performed on one or more processors of a massively parallel processor (MPP) computer system, wherein rows of the table that are local to each processor are locally aggregated to create one or more aggregate result rows. The aggregate result rows created by each of the local aggregation operations are then re-distributed to one or more processors and coalesced into a global aggregate result row by a global aggregation operation.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.