Open AccessStudy of Concurrency Control Techniques in Distributed DBMS
Author(s) -
Manoj Kumar Gupta,
Rakesh Kumar Arora,
Bhoopesh Singh Bhati
Publication year - 2018
Publication title -
international journal of machine learning and networked collaborative engineering
Language(s) - English
Resource type - Journals
ISSN - 2581-3242
DOI - 10.30991/ijmlnce.2018v02i04.005
Subject(s) - multiversion concurrency control , non lock concurrency control , distributed concurrency control , concurrency control , computer science , optimistic concurrency control , timestamp based concurrency control , concurrency , lock (firearm) , database , isolation (microbiology) , consistency (knowledge bases) , serializability , distributed computing , distributed database , context (archaeology) , distributed transaction , database transaction , transaction processing , engineering , mechanical engineering , paleontology , microbiology and biotechnology , artificial intelligence , biology
Concurrency control focuses on maintaining consistency and integrity of database through synchronized access. The complexity relating to concurrency control in a distributed context is very high as compared to centralized framework due to maintaining consistency within the multiple fragments / copies of the database. This paper consolidates and discusses various lock based concurrency control techniques for Distributed DBMS. The paper also presents a comparative study of various two phase locking based concurrency control techniques.