Parallel single cursor model on multiple-server configurations

Details Parallel single cursor model on multiple-server configurations Parallel single cursor model on multiple-server configurations

2004-07-27

2008-03-04

Breene, John (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07340452

ABSTRACT:
A cursor that is generated from an original database statement includes a master plan that is shared among the various participants involved in the parallel execution of the operations specified in the original statement. For participants that cannot share the same cursor, such as slave processes on remote servers, a remote cursor is generated. Signatures are generated for both the master plan and the remote plans, and compared to ensure that the remote plans are equivalent to the master plans. Various parameters and statistics are provided to remote servers to increase the likelihood that the remote plans will be equivalent to the master plan.

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: 6466931 (2002-10-01), Attaluri et al.
patent: 6529901 (2003-03-01), Chaudhuri 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: 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

Parallel single cursor model on multiple-server configurations does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Parallel single cursor model on multiple-server configurations, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Parallel single cursor model on multiple-server configurations will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3980813