Adding PEP to real-time distributed commit processing

One-phase commit protocols substantially reduce the overheads of transaction commit processing, making them attractive for incorporation in distributed real-time databases. A major obstacle, however is that these protocols significantly increase the occurrence of priority inversions. This arises from the cohorts of each distributed transaction being in a prepared state for extended periods of time, during which their data locks cannot be pre-empted. We present a new one-phase real-time commit protocol, called PEP (short for PROMPT-EP, where PROMPT = "Permits Reading Of Modified Prepared-data for Timeliness", which is a real-time commit protocol, and EP = "Early Prepare", which is a one-phase commit protocol). PEP addresses the above-mentioned problem by suitably utilizing our previously proposed prepared data-borrowing technique. A simulation-based evaluation of PEP for real-time applications with firm deadlines demonstrates that, for a variety of environments, it substantially reduces the number of killed transactions as compared to its multi-phase counterparts. In fact, PEP often provides better performance than even an equivalent centralized system.

[1]  Dale Skeen,et al.  Nonblocking commit protocols , 1981, SIGMOD '81.

[2]  J. Doug Tygar,et al.  Atomicity in electronic commerce , 1996, NTWK.

[3]  James W. Layland,et al.  Scheduling Algorithms for Multiprogramming in a Hard-Real-Time Environment , 1989, JACM.

[4]  Michael Stonebraker,et al.  Concurrency Control and Consistency of Multiple Copies of Data in Distributed Ingres , 1979, IEEE Transactions on Software Engineering.

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

[6]  Donald F. Towsley,et al.  On using priority inheritance in real-time databases , 1991, [1991] Proceedings Twelfth Real-Time Systems Symposium.

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

[8]  Hector Garcia-Molina,et al.  Scheduling real-time transactions: a performance evaluation , 1988, TODS.

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

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

[11]  Lui Sha,et al.  Priority Inheritance Protocols: An Approach to Real-Time Synchronization , 1990, IEEE Trans. Computers.

[12]  Jayant R. Haritsa,et al.  The PROMPT Real-Time Commit Protocol , 2000, IEEE Trans. Parallel Distributed Syst..

[13]  Panos K. Chrysanthis,et al.  The Implicit-Yes Vote Commit Protocol with Delegation of Commitment , 1996 .