System for aggregation subquery join elimination

Details System for aggregation subquery join elimination System for aggregation subquery join elimination

2011-06-21

2011-06-21

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S714000

Reexamination Certificate

active

07966314

ABSTRACT:
A system for use with an information retrieval system, in which system 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 information retrieval system comprising means for removing the first subquery from the database statement thereby eliminating 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: 7454416 (2008-11-01), Zuzarte et al.
patent: 2002/0059203 (2002-05-01), Witkowski et al.
Yan, et al., “Eager Aggregation and Lazy Aggregation”, Morgan Kaufmann Publishers Inc., Proceedings of the 21st VLDB Conference on Very Large Data Bases,1995, pp. 345-357.

Affiliated with

Also associated with

Rating

System 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 System for aggregation subquery join elimination, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System for aggregation subquery join elimination will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2727319