Two-Phase Commit Processing with Restructured Commit Tree

Extensive research has been carried out in search for an efficient atomic commit protocol and many optimizations have been suggested to improve the basic two-phase commit protocol, either for the normal or failure case. Of these optimizations, the read-only optimization is the best known and most widely used, whereas the flattening of-the-commit-tree optimization is the most recent one proposed for Internet transactions. In this paper, we study in depth the combined use of these two optimizations and show the limitations of the flattening-of-the-commit-tree method in committing large trees. Further, we propose a new restructuring method of the commit tree and show using simulation that it performs better than flattening method even when dealing with large trees.

[1]  Panos K. Chrysanthis,et al.  An atomic commit protocol for gigabit-networked distributed database systems , 2000, J. Syst. Archit..

[2]  Butler W. Lampson,et al.  Atomic Transactions , 1980, Advanced Course: Distributed Systems.

[3]  Brian Randell,et al.  Operating Systems, An Advanced Course , 1978 .

[4]  Panos K. Chrysanthis,et al.  Dealing with incompatible presumptions of commit protocols in multidatabase systems , 1996, SAC '96.

[5]  Yoav Raz The Dynamic Two Phase Commitment (D2PC) Protocol , 1995, ICDT.

[6]  Steven P. Levitan,et al.  An argument in favor of the presumed commit protocol , 1997, Proceedings 13th International Conference on Data Engineering.

[7]  Steven P. Levitan,et al.  An Argument in Favour of Presumed Commit Protocol , 1997, ICDE 1997.

[8]  Peter M. Spiro,et al.  Designing an Optimized Transaction Committ Protocol , 1991, Digit. Tech. J..

[9]  Jayant R. Haritsa,et al.  Revisiting commit processing in distributed database systems , 1997, SIGMOD '97.

[10]  Panos K. Chrysanthis,et al.  Enhancing the performance of presumed commit protocol , 1997, SAC '97.

[11]  Butler W. Lampson,et al.  Distributed Systems - Architecture and Implementation, An Advanced Course , 1981, Advanced Course: Distributed Systems.

[12]  Butler W. Lampson,et al.  Distributed Systems — Architecture and Implementation , 1982, Lecture Notes in Computer Science.

[13]  Daniel James Duchamp Transaction management , 1988 .

[14]  Jim Gray,et al.  Notes on Data Base Operating Systems , 1978, Advanced Course: Operating Systems.

[15]  Andreas Reuter,et al.  Transaction Processing: Concepts and Techniques , 1992 .

[16]  Flaviu Cristian,et al.  A low-cost atomic commit protocol , 1990, Proceedings Ninth Symposium on Reliable Distributed Systems.

[17]  C. Mohan Generalized Presumed Abort: Marrying Presumed Abort and SNA LU6.2 Commit Protocols , 1993, HPTS.

[18]  Bruce G. Lindsay,et al.  Transaction management in the R* distributed database management system , 1986, TODS.

[19]  Butler W. Lampson,et al.  A New Presumed Commit Optimization for Two Phase Commit , 1993, VLDB.

[20]  Panos K. Chrysanthis,et al.  Atomicity with incompatible presumptions , 1999, PODS.