Open Access   Article Go Back

A study of Preventing Concurrency’s Problems using 2-Phase Locking Protocols (2-PL)

Anil Kumar Singh1

Section:Research Paper, Product Type: Journal Paper
Volume-6 , Issue-11 , Page no. 39-42, Nov-2018

CrossRef-DOI:   https://doi.org/10.26438/ijcse/v6i11.3942

Online published on Nov 30, 2018

Copyright © Anil Kumar Singh . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: Anil Kumar Singh, “A study of Preventing Concurrency’s Problems using 2-Phase Locking Protocols (2-PL),” International Journal of Computer Sciences and Engineering, Vol.6, Issue.11, pp.39-42, 2018.

MLA Style Citation: Anil Kumar Singh "A study of Preventing Concurrency’s Problems using 2-Phase Locking Protocols (2-PL)." International Journal of Computer Sciences and Engineering 6.11 (2018): 39-42.

APA Style Citation: Anil Kumar Singh, (2018). A study of Preventing Concurrency’s Problems using 2-Phase Locking Protocols (2-PL). International Journal of Computer Sciences and Engineering, 6(11), 39-42.

BibTex Style Citation:
@article{Singh_2018,
author = {Anil Kumar Singh},
title = {A study of Preventing Concurrency’s Problems using 2-Phase Locking Protocols (2-PL)},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {11 2018},
volume = {6},
Issue = {11},
month = {11},
year = {2018},
issn = {2347-2693},
pages = {39-42},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=3122},
doi = {https://doi.org/10.26438/ijcse/v6i11.3942}
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
DO = {https://doi.org/10.26438/ijcse/v6i11.3942}
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=3122
TI - A study of Preventing Concurrency’s Problems using 2-Phase Locking Protocols (2-PL)
T2 - International Journal of Computer Sciences and Engineering
AU - Anil Kumar Singh
PY - 2018
DA - 2018/11/30
PB - IJCSE, Indore, INDIA
SP - 39-42
IS - 11
VL - 6
SN - 2347-2693
ER -

VIEWS PDF XML
617 541 downloads 286 downloads
  
  
           

Abstract

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.

Key-Words / Index Term

2-PL, Growing, Shrinking, Locks, Concurrency, Dirty Read, Lost Update, inconsistent analysis

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