Concurrency control by Multiple Granularity of Locks in Multiusers Database Environment
DOI:
https://doi.org/10.26438/ijcse/v6i12.106108Keywords:
Multiple Granularity, Implicit Lock, Explicit Lock, Concurrency, Tuples, Database, Table, Record, AttributeAbstract
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.
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
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2018 Singh AK
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.
