Partial pre-aggregation in relational database queries

Details Partial pre-aggregation in relational database queries Partial pre-aggregation in relational database queries

2006-11-07

2006-11-07

Coby, Frantz (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07133858

ABSTRACT:
A partial pre-aggregation database operation improves processing efficiency of database queries by reducing the number of records input into a subsequent database operation, provided the query includes a final aggregation. A query optimizer is provided to determine when it is economical to partially pre-aggregate data records and when it is not. The partial pre-aggregation creates a record store in memory as input records are received. The record store is then used by another database operator, which saves the other database operator from having to re-create the record store.

REFERENCES:
patent: 5511190 (1996-04-01), Sharma et al.
patent: 5781896 (1998-07-01), Dalal
patent: 5832475 (1998-11-01), Agrawal et al.
patent: 6032144 (2000-02-01), Srivastava et al.
patent: 6115705 (2000-09-01), Larson
patent: 6199063 (2001-03-01), Colby et al.
patent: 6282541 (2001-08-01), Hoa et al.
patent: 6397204 (2002-05-01), Liu et al.
patent: 6430550 (2002-08-01), Leo et al.
patent: 6480836 (2002-11-01), Colby et al.
patent: 6493699 (2002-12-01), Colby et al.
patent: 2001/0013030 (2001-08-01), Colby et al.
patent: 2002/0077997 (2002-06-01), Colby et al.

Affiliated with

Also associated with

Rating

Partial pre-aggregation in relational database queries does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Partial pre-aggregation in relational database queries, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Partial pre-aggregation in relational database queries will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3626947