Open Access   Article Go Back

Concurrency control by Multiple Granularity of Locks in Multiusers Database Environment

Anil Kumar Singh1

Section:Research Paper, Product Type: Journal Paper
Volume-6 , Issue-12 , Page no. 106-108, Dec-2018

CrossRef-DOI:   https://doi.org/10.26438/ijcse/v6i12.106108

Online published on Dec 31, 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

XML View
PDF Download

How to Cite this Paper

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

IEEE Style Citation: Anil Kumar Singh, “Concurrency control by Multiple Granularity of Locks in Multiusers Database Environment,” International Journal of Computer Sciences and Engineering, Vol.6, Issue.12, pp.106-108, 2018.

MLA Style Citation: Anil Kumar Singh "Concurrency control by Multiple Granularity of Locks in Multiusers Database Environment." International Journal of Computer Sciences and Engineering 6.12 (2018): 106-108.

APA Style Citation: Anil Kumar Singh, (2018). Concurrency control by Multiple Granularity of Locks in Multiusers Database Environment. International Journal of Computer Sciences and Engineering, 6(12), 106-108.

BibTex Style Citation:
@article{Singh_2018,
author = {Anil Kumar Singh},
title = {Concurrency control by Multiple Granularity of Locks in Multiusers Database Environment},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {12 2018},
volume = {6},
Issue = {12},
month = {12},
year = {2018},
issn = {2347-2693},
pages = {106-108},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=3301},
doi = {https://doi.org/10.26438/ijcse/v6i12.106108}
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
DO = {https://doi.org/10.26438/ijcse/v6i12.106108}
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=3301
TI - Concurrency control by Multiple Granularity of Locks in Multiusers Database Environment
T2 - International Journal of Computer Sciences and Engineering
AU - Anil Kumar Singh
PY - 2018
DA - 2018/12/31
PB - IJCSE, Indore, INDIA
SP - 106-108
IS - 12
VL - 6
SN - 2347-2693
ER -

VIEWS PDF XML
607 447 downloads 303 downloads
  
  
           

Abstract

Concurrency control is a big problem in shared database system. The management of the concurrent execution of transactions in a multiuser database system is recognized as concurrency control. The aim of concurrency control is to confirm the serializability of transactions in a multiuser database situation. It is significant because the simultaneous execution of transactions over a shared database can create several data integrity and consistency problems i.e. problem of summarization and problem of maintaining statistics. Multiple granularity means which level lock will apply, if we apply the lock on exact level of database, then definitely we may control the concurrency. In this paper we shall reveal in which level lock should apply for prevent above mentioned problems. With the help of Multiple Granularity, 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 Multiple Granularity Locking Protocol method.

Key-Words / Index Term

Multiple Granularity, Implicit Lock, Explicit Lock, Concurrency, Tuples, Database, Table, Record, Attribute

References

[1]. Philip A. Bernstein and Eric Newcomer, “Locking”, Chapter 6, p.p. 6-1 to 6.35, 2001
[2]. GeeksforGeetks, a computer science Portal for geeks, https://www.geeksforgeeks.org /dbms-concurrency-control-protocol-multiple-granularity-locking/
[3]. Dr. Anil Kumar Singh, “A study of Concurrent transaction execution and their problems in Distributed Database System”, International Journal of Computer Sciences and Engineering Vol.6(10), p.p.767-769, E-ISSN: 2347-2693, Oct 2018
[4]. JavaTpoint, Multiple Granularity, https://www.javatpoint.com/dbms-multiple-granularity
[5]. Goetz Graefe, “Hierarchical locking in B-tree indexes”, HP Labs 1 Goetz.Graefe@HP.com p.p. 18-42.
[6]. Dr. 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(11), p.p. 39-42, E-ISSN: 2347-2693, November 2018