Query transformation for queries involving correlated...

Details Query transformation for queries involving correlated... Query transformation for queries involving correlated...

2007-02-20

2007-02-20

Rimell, Sam (Department: 2161)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

10764286

ABSTRACT:
A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization is performed by identifying a correlated subquery in the query that qualifies for transformation, transitively closing a local filtering predicate within the identified correlated subquery that is on a same column as a correlation join predicate within the identified correlated subquery, and pulling out or bubbling up the transitively closed predicate from the correlated subquery to a parent query block of the query.

REFERENCES:
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5761657 (1998-06-01), Hoang
patent: 5822750 (1998-10-01), Jou et al.
patent: 5855012 (1998-12-01), Bhargava et al.
patent: 6385603 (2002-05-01), Chen et al.
patent: RE37965 (2003-01-01), Jhingran et al.
patent: 6529896 (2003-03-01), Leung et al.
patent: 6560595 (2003-05-01), Sanders et al.
patent: 6571233 (2003-05-01), Beavin et al.
patent: 6826562 (2004-11-01), Leung et al.
patent: 2003/0088558 (2003-05-01), Zaharioudakis et al.
patent: 2003/0120682 (2003-06-01), Bestgen et al.
patent: 2003/0167258 (2003-09-01), Kou et al.

Affiliated with

Also associated with

Rating

Query transformation for queries involving correlated... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query transformation for queries involving correlated..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query transformation for queries involving correlated... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3880126