Compilation and processing a parallel single cursor model

Details Compilation and processing a parallel single cursor model Compilation and processing a parallel single cursor model

2004-04-13

2011-12-27

Hwa, Shyue Jiunn (Department: 2163)

Data processing: database and file management or data structures

Database design

Database and data structure management

C719S312000

Reexamination Certificate

active

08086645

ABSTRACT:
Techniques are provided for executing query statements, or portions thereof, in parallel without using slave SQL to communicate to each slave the operations to be performed by the slave. Instead of generating one cursor for the query coordinator (QC) based on the original statement, and separate cursors for each DFO based on the slave SQL, the techniques involve sharing the cursor that is generated from the original statement among the various participants involved in the parallel execution of the operations specified in the original statement.

REFERENCES:
patent: 4769772 (1988-09-01), Dwyer
patent: 4860201 (1989-08-01), Stolfo et al.
patent: 5325525 (1994-06-01), Shan et al.
patent: 5495606 (1996-02-01), Borden 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: 6601064 (2003-07-01), Nag 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: 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: 2004/0268227 (2004-12-01), Brid
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.
Dayco related U.S. Appl. No. 10/865,178, filed on Jun. 9, 2004.
Dayco related U.S. Appl. No. 10/841,991, filed on May 6, 2004.
Office Action dated Apr. 23, 2008 for U.S. Appl. No. 11/202,453, filed Aug. 11, 2005.
Notice of Allowance dated Jul. 22, 2008 for U.S. Appl. No. 10/930,433, filed Aug. 30, 2004.
Examiner's Answer dated Sep. 3, 2008 for U.S. Appl. No. 10/841,991, filed May 6, 2004.
Advisory Action dated Mar. 11, 2009 for U.S. Appl. No. 10/944,175, filed Sep. 16, 2004.
Office Action dated Jan. 5, 2009 for U.S. Appl. No. 10/944,175, filed Sep. 16, 2004.

Affiliated with

Also associated with

Rating

Compilation and processing a parallel single cursor model does not yet have a rating. At this time, there are no reviews or comments for this patent.

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4313960