Transaction management in the R* distributed database management system
ACM Transactions on Database Systems (TODS)
Concurrency control for distributed real-time databases
ACM SIGMOD Record - Special Issue on Real-Time Database Systems
Data access scheduling in firm real-time database systems
Real-Time Systems - Special issue: real-time databases
Two-phase locking performance and its thrashing behavior
ACM Transactions on Database Systems (TODS)
Concurrency control in real-time database systems
Concurrency control in real-time database systems
Distributed and Parallel Databases - Special issue: Research topics in distributed and parallel databases
A study of two transaction-processing architectures for distributed real-time data base systems
Journal of Systems and Software
A real-time concurrency control protocol for main-memory database systems
Information Systems
Priority Scheduling of Transactions in Distributed Real-TimeDatabases
Real-Time Systems
The PROMPT Real-Time Commit Protocol
IEEE Transactions on Parallel and Distributed Systems
Transaction Processing: Concepts and Techniques
Transaction Processing: Concepts and Techniques
Ordered shared locks for real-time databases
The VLDB Journal — The International Journal on Very Large Data Bases
A taxonomy of correctness criteria in database applications
The VLDB Journal — The International Journal on Very Large Data Bases
On Using Similarity for Resolving Conflicts at Commit in Mixed Distributed Real-Time Databases
RTCSA '98 Proceedings of the 5th International Conference on Real-Time Computing Systems and Applications
Commit processing in distributed real-time database systems
RTSS '96 Proceedings of the 17th IEEE Real-Time Systems Symposium
More optimism about real-time distributed commit processing
RTSS '97 Proceedings of the 18th IEEE Real-Time Systems Symposium
Real-Time Commit Protocol For Distributed Real-Time Database Systems
ICECCS '96 Proceedings of the 2nd IEEE International Conference on Engineering of Complex Computer Systems
Adaptive Commitment for Real-Time Distributed Transactions
Adaptive Commitment for Real-Time Distributed Transactions
Task synchronization in real-time systems
Task synchronization in real-time systems
High performance distributed real-time commit protocol
Journal of Systems and Software
| Hi-index | 0.00 |
Most of the existing commit protocols try to improve the system performance by allowing a committing cohort to lend its data to an executing cohort, thus reducing data inaccessibility. However, these protocols block the borrower when it tries to send WORKDONE/PREPARED message (Qin & Liu 2003, Haritsa, Ramamritham & Gupta 2000, Gupta, Haritsa, Ramamritham & Seshadri 1996, Gupta, Haritsa, & Ramamritham 1997), thus increasing the transactions commit time. This paper first analyzes all kind of dependencies that may arise due to data access conflicts in executing-committing transaction when a committing cohort is allowed to lend its data to an executing cohort, and then proposes a static two phase locking based optimistic commit protocol i.e. OCP. In OCP, the execution phase of a cohort is divided into two parts locking phase and processing phase and then, in place of WORKDONE message, WORKSTARTED message is sent just before the start of processing phase of the cohort. Again, in case of dependency, borrower with only commit dependency is allowed to send WORKSTARTED message instead of being blocked. This reduces the time needed for commit processing and is free from cascaded aborts. To ensure non-violation of ACID properties, checking of completion of processing and removal of dependency of cohort are required before sending the Yes-Vote message. The performance of the OCP is also analyzed for partial read-only optimization.