One-phase commit in a shared-nothing database system

Details One-phase commit in a shared-nothing database system One-phase commit in a shared-nothing database system

2005-01-18

2005-01-18

Mizrahi, Diane D. (Department: 2175)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06845384

ABSTRACT:
Techniques are provided for handling distributed transactions in shared-nothing database systems where one or more of the nodes have access to a shared persistent storage. Rather than coordinate the distributed transaction using a two-phase commit protocol, the coordinator of the distributed transaction uses a one-phase commit protocol with those participants that have access to the transaction status information maintained by the coordinator. The transaction status information may reside, for example, in the redo log of the coordinator. In the case that the coordinator fails, those participants can determine the state of the distributed transaction based on information stored on the shared disk. In addition, the coordinator is able to determine whether it is possible to commit the distributed transaction based on information that is stored on the shared disk by the participants, without those participants entering a formal “prepared” state.

REFERENCES:
patent: 4827411 (1989-05-01), Arrowood et al.
patent: 4873517 (1989-10-01), Baratz et al.
patent: 4914571 (1990-04-01), Baratz et al.
patent: 4972437 (1990-11-01), Citron et al.
patent: 5101348 (1992-03-01), Arrowood et al.
patent: 5109483 (1992-04-01), Baratz et al.
patent: 5313051 (1994-05-01), Brigida et al.
patent: 5319773 (1994-06-01), Britton et al.
patent: 5432926 (1995-07-01), Citron et al.
patent: 5613060 (1997-03-01), Britton et al.
patent: 5740362 (1998-04-01), Buickel et al.
patent: 5892754 (1999-04-01), Kompella et al.
patent: 6011918 (2000-01-01), Cohen et al.
patent: 6253229 (2001-06-01), Nielsen et al.
patent: 6311265 (2001-10-01), Beckerle et al.
patent: 6321238 (2001-11-01), Putzolu
patent: 6341340 (2002-01-01), Tsukerman et al.
patent: 6370619 (2002-04-01), Ho et al.
patent: 6438714 (2002-08-01), Canestaro et al.
patent: 6480895 (2002-11-01), Gray et al.
patent: 6567509 (2003-05-01), Gusler et al.
patent: 6567811 (2003-05-01), Edwards et al.
patent: 6636248 (2003-10-01), Christensen et al.
patent: 6711571 (2004-03-01), Putzolu
patent: 20040172422 (2004-09-01), Putzolu

Affiliated with

Also associated with

Rating

One-phase commit in a shared-nothing database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with One-phase commit in a shared-nothing database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and One-phase commit in a shared-nothing database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3404119