Transaction management in the R* distributed database management system
ACM Transactions on Database Systems (TODS)
Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
The Performance of Alternative Strategies for Dealing with Deadlocks in Database Management Systems
IEEE Transactions on Software Engineering
Conflict detection tradeoffs for replicated data
ACM Transactions on Database Systems (TODS)
Coordinator log transaction execution protocol
Distributed and Parallel Databases
The design of distributed database systems in the presence of failures
The design of distributed database systems in the presence of failures
System level concurrency control for distributed database systems
ACM Transactions on Database Systems (TODS)
Fail-stop processors: an approach to designing fault-tolerant computing systems
ACM Transactions on Computer Systems (TOCS)
The notions of consistency and predicate locks in a database system
Communications of the ACM
Recovering in large distributed systems with replicated data
PDIS '93 Proceedings of the second international conference on Parallel and distributed information systems
Computer Performance Modeling Handbook
Computer Performance Modeling Handbook
Simulation Modeling and Analysis
Simulation Modeling and Analysis
Transaction Processing: Concepts and Techniques
Transaction Processing: Concepts and Techniques
SIGMOD '81 Proceedings of the 1981 ACM SIGMOD international conference on Management of data
Two-Phase Commit Optimizations and Tradeoffs in the Commercial Environment
Proceedings of the Ninth International Conference on Data Engineering
Notes on Data Base Operating Systems
Operating Systems, An Advanced Course
Reducing the blocking in two-phase commit with backup sites
Information Processing Letters
On performance evaluation and design of atomic commit protocols for mobile transactions
Distributed and Parallel Databases
Performance evaluation of Atomic Commit Protocols for mobile transactions
International Journal of Intelligent Information and Database Systems
Agent based dynamic recovery protocol in distributed databases
ISPDC'03 Proceedings of the Second international conference on Parallel and distributed computing
Towards context-aware transaction services
DAIS'06 Proceedings of the 6th IFIP WG 6.1 international conference on Distributed Applications and Interoperable Systems
| Hi-index | 0.00 |
The two phase commit is an important protocol in distributeddatabase systems. Much of the existing literature on the protocol isrestricted to discussing and analyzing the protocol (and its variants) inthe absence of failures. Very little, especially in quantitative terms, hasbeen written about its performance in the presence of site failures. In thisstudy, we use a simulation testbed of a distributed database system toquantify the differences in the performances of four widely known variantsof the 2PC protocols (the generic 2PC, presumed commit, presumed abort, andearly prepare). Our study covers both the no-failure case and the case ofsite failures. We present a number of interesting results based on ourexperiments. One is that the performance of these protocols is highlydependent on the message-processing latency at the transaction coordinatorsite. Another is that the presumed abort protocol does not necessarily yieldbetter performance in the presence of site failures.