Optimization of SQL queries involving aggregate expressions usin

Details Optimization of SQL queries involving aggregate expressions usin Optimization of SQL queries involving aggregate expressions usin

1997-02-06

1999-03-16

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

707 3, 707 10, 39520031, G06F 1730

Patent

active

058842993

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.

REFERENCES:
patent: 5655080 (1997-08-01), Dias et al.
"Parallel Optimization of Large Join Queries with Set Operators and Aggregates in a Parallel Environment Supporting Pipeline" Myra Spiliopoulou et al., IEEE Transactions on Knowledge and Data Engineering, vol. 8, No. 3, pp. 429-445, Jun. 1996.

Affiliated with

Also associated with

Rating

Optimization of SQL queries involving aggregate expressions usin does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimization of SQL queries involving aggregate expressions usin, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimization of SQL queries involving aggregate expressions usin will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-827564