A study of Preventing Concurrency’s Problems using 2-Phase Locking Protocols (2-PL)
DOI:
https://doi.org/10.26438/ijcse/v6i11.3942Keywords:
2-PL, Growing, Shrinking, Locks, Concurrency, Dirty Read, Lost Update, inconsistent analysisAbstract
Now days every organization has importance of time in its day to day working. To save time, the task should be executed in distributed manner and also to adopt the procedure to perform, parallel or concurrent execution method. Concurrency means, more than one transactions are performing at the same time then they are interleaving to each other. When the transactions are inter-leaving for short span they cause the different types of problems like lost update, dirty read etc. To control these types of problems, there are several methods like Locking Methods, Time-stamp Methods and Optimistic Methods. In this paper we will study the 2-Phase Locking Protocol which comes under locking method. With the help of 2-PL, we shall reveal how to prevent the problem arise due to concurrency with the help of suitable examples. It will help the students and research scholars to understand that how to prevent the concurrency problems with the help of 2-Phase Locking Protocol (2-PL) method
References
[1] Kedeml C.et. al., “An Efficient Deadlock Removal Scheme for Non-Two-Phase LockingProtocols”, Proceedings of the Eighth International Conference on Very Large Data Bases, Mexico City, September, 1982.
[2] C. MOHAN et. al., “Lock Conversion in Non-Two-Phase Locking Protocols”, IEEE Transactions on Software Engineering, vol. se-11, No. 1, p.p. 15-22, January 1985
[3] Stefano Ceri, Giuseppe Pelagatti, “ Distributed Database Principles and Systems”, Tata McGraw-Hill Edition, ISBN 0-07-026511-9, p.p. 195
[4] M. Tamer Ozsu, Patrick Valduriez, “Principles of Distributed Database Systems”,Pearson Education, 2nd Editions, ISBN 81-7758-177-5, p.p. 262 , 2008
[5] Singh Anil Kumar, “A study of Concurrent transaction execution and their problems in Distributed Database System”, International Journal ofComputer Sciences and Engineering, Volume-6 , Issue-10, Page no. 810-813, ISSN 2347-2693(E), Oct-2018
Downloads
Published
How to Cite
Issue
Section
License
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors contributing to this journal agree to publish their articles under the Creative Commons Attribution 4.0 International License, allowing third parties to share their work (copy, distribute, transmit) and to adapt it, under the condition that the authors are given credit and that in the event of reuse or distribution, the terms of this license are made clear.
