Method for aggregation subquery join elimination

Details Method for aggregation subquery join elimination Method for aggregation subquery join elimination

2003-04-30

2008-11-18

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07454416

ABSTRACT:
A method for use with an information retrieval system, in which the method is used for transforming a database statement containing a first subquery and a second subquery joined together, the first subquery including a group by operation over a child subquery, the method comprising removing the first subquery from the database statement thereby removing the join between the first subquery and the second subquery.

REFERENCES:
patent: 5412804 (1995-05-01), Krishna
patent: 6341281 (2002-01-01), MacNicol et al.
patent: 6370524 (2002-04-01), Witkowski
patent: 6775681 (2004-08-01), Ballamkonda et al.
patent: 6826562 (2004-11-01), Leung et al.
patent: 6847962 (2005-01-01), Cochrane et al.
patent: 2002/0059203 (2002-05-01), Witkowski et al.
Yan, et al. “Easy Aggregation and Lazy Aggregation”, Morgan Kaufmann Publishers Inc, Proceedings of the 21th International Conference on Very Large Data Bases, pp. 345-357.

Affiliated with

Also associated with

Rating

Method for aggregation subquery join elimination does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for aggregation subquery join elimination, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for aggregation subquery join elimination will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4022545