Back to Search
Start Over
A Prudent-Precedence Concurrency Control Protocol for High Data Contention Database Enviornments
- Source :
- International Journal of Database Management Systems (IJDMS), 8(5), 1-14 (2016)
- Publication Year :
- 2016
-
Abstract
- In this paper, we propose a concurrency control protocol, called the Prudent-Precedence Concurrency Control (PPCC) protocol, for high data contention database environments. PPCC is prudently more aggressive in permitting more serializable schedules than two-phase locking. It maintains a restricted precedence among conflicting transactions and commits the transactions according to the serialization order established in the executions. A detailed simulation model has been constructed and extensive experiments have been conducted to evaluate the performance of the proposed approach. The results demonstrate that the proposed algorithm outperforms the two-phase locking and optimistic concurrency control in all ranges of system workload.<br />Comment: 14 pages, 16 figures, 1 table
- Subjects :
- Computer Science - Databases
Subjects
Details
- Database :
- arXiv
- Journal :
- International Journal of Database Management Systems (IJDMS), 8(5), 1-14 (2016)
- Publication Type :
- Report
- Accession number :
- edsarx.1611.05557
- Document Type :
- Working Paper
- Full Text :
- https://doi.org/10.5121/ijdms.2016.8501