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

G - Physics

06

F

G06F 17/30 (2006.01)

Patent

CA 2534066

Techniques are provided for handling distributed transaction in shared-nothing database system 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 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.

L'invention concerne des techniques pour le traitement de transactions distribuées dans des systèmes de base de données sans partage, un ou plusieurs noeuds ayant accès à une mémoire persistante partagée. Plutôt que de coordonner la transaction distribuée avec un protocole d'exécution biphasé, le coordinateur de ladite transaction utilise un protocole d'exécution monophasé, avec les participants accédant à l'information d'état de transaction maintenue par le coordinateur. L'information en question peut résider par exemple dans les fichiers redo-log du coordinateur. Si le coordinateur échoue, ces participants peuvent déterminer l'état de la transaction distribuée sur la base de l'information enregistrée dans le disque partagé par les participants, sans obligation pour eux d'établir un état <=préparé>= formel.

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: LFCA-PAI-O-1760252