![]() |
![]() |
![]() |
@inproceedings{DBLP:conf/cikm/HelalKF94, author = {Abdelsalam Helal and Tung-Hui Ku and Judson Fortner}, title = {Quasi-Dynamic Two-Phase Locking}, booktitle = {Proceedings of the Third International Conference on Information and Knowledge Management (CIKM'94), Gaithersburg, Maryland, November 29 - December 2, 1994}, publisher = {ACM}, year = {1994}, pages = {211-218}, ee = {db/conf/cikm/HelalKF94.html, http://doi.acm.org/10.1145/191246.191281}, crossref = {DBLP:conf/cikm/94}, bibsource = {DBLP, http://dblp.uni-trier.de} }BibTeX
Among the plethora of concurrency control algorithms that have been proposed and analyzed, two-phase locking (2PL) has been adapted as the industry de facto standard concurrency control. In accord, current research in concurrency control is focusing on enhancing the scalability of 2PL performance in highly concurrent and contentious environments. This is especially needed in future on-line transaction processing systems, where thousand Transaction Per Second performance will be required.
Static locking (SL) and dynamic locking (DL) are two famous adaptations of 2PL that are used under different degrees of data contention. In this paper, we offer our observation that 2PL is indeed a family of methods, of which SL and DL are extreme case members. Further, we argue for and verify the existence of other 2PL member methods that, under variable conditions, outperform SL and DL. We propose two novel schemes which we categorize as quasi-dynamic two-phase locking on account of their behavior in comparison with dynamic/static two-phase locking. We present a simulation study of the performance of the proposed schemes and their comparison to dynamic and static locking methods.
Copyright © 1994 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.