Executing filter subqueries using a parallel single cursor...

Details Executing filter subqueries using a parallel single cursor... Executing filter subqueries using a parallel single cursor...

2011-06-07

2011-06-07

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Database and data structure management

C707S769000

Reexamination Certificate

active

07958160

ABSTRACT:
Techniques are provided for generating execution plans for, and executing, database statements that contain filter subqueries. Upon receiving a database statement that contains a filter subquery, the database server builds an execution plan that includes a filter operation that is fed by a subtree that corresponds to the subquery. The database server performs a cost analysis to determine whether (1) the filter operation should be parallelized, and (2) the subquery tree should be parallelized. Techniques are also described for generating plans and executing queries where (1) both the filter operation and the subquery subtree are parallelized, (2) the filter operation is parallelized but the subquery subtree operation is performed serially, and (3) the filter operation is performed serially but the subquery subtree operation is parallelized.

REFERENCES:
patent: 4769772 (1988-09-01), Dwyer
patent: 4860201 (1989-08-01), Stolfo et al.
patent: 5325525 (1994-06-01), Shan et al.
patent: 5765146 (1998-06-01), Wolf et al.
patent: 5822750 (1998-10-01), Jou et al.
patent: 5835755 (1998-11-01), Stellwagen, Jr.
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 5864839 (1999-01-01), Bourgoin
patent: 5937401 (1999-08-01), Hillegas
patent: 6081801 (2000-06-01), Cochrane et al.
patent: 6085189 (2000-07-01), Pirahesh et al.
patent: 6112198 (2000-08-01), Lohman et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6411951 (2002-06-01), Galindo-Legaria et al.
patent: 6430550 (2002-08-01), Leo et al.
patent: 6466931 (2002-10-01), Attaluri et al.
patent: 6529901 (2003-03-01), Chaudhuri et al.
patent: 6622138 (2003-09-01), Bellamkonda et al.
patent: 6625593 (2003-09-01), Leung et al.
patent: 6721724 (2004-04-01), Galindo-Legaria et al.
patent: 6910032 (2005-06-01), Carlson et al.
patent: 6928451 (2005-08-01), Mogi et al.
patent: 6954776 (2005-10-01), Cruanes et al.
patent: 6968335 (2005-11-01), Bayliss et al.
patent: 7020661 (2006-03-01), Cruanes et al.
patent: 7051034 (2006-05-01), Ghosh et al.
patent: 7089356 (2006-08-01), Chen et al.
patent: 7234112 (2007-06-01), Brown et al.
patent: 2002/0038300 (2002-03-01), Iwata et al.
patent: 2003/0055813 (2003-03-01), Chaudhuri et al.
patent: 2003/0065644 (2003-04-01), Horman et al.
patent: 2003/0187831 (2003-10-01), Bestgen et al.
patent: 2003/0208489 (2003-11-01), Todd
patent: 2003/0229640 (2003-12-01), Carlson et al.
patent: 2004/0172626 (2004-09-01), Jalan et al.
patent: 2005/0004907 (2005-01-01), Bruno et al.
patent: 2005/0049996 (2005-03-01), Srinivasan et al.
patent: 2005/0131890 (2005-06-01), Cruanes et al.
patent: 2005/0132383 (2005-06-01), Ghosh et al.

Affiliated with

Also associated with

Rating

Executing filter subqueries using a parallel single cursor... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Executing filter subqueries using a parallel single cursor..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Executing filter subqueries using a parallel single cursor... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2623988