scholarly journals An overview of Concurrency Control Techniques in Distributed Database

Author(s):  
Rajdeep Singh Solanki
Author(s):  
Monika Patel ◽  
Dhiren B. Patel

Concurrency Control entails the synchronization of accesses to the distributed database, such that the integrity of the database is maintained. Devising an efficient concurrency control technique is challenging. There is a need for improvised concurrency control technique to coordinate the simultaneous execution of transactions in a multi-processing database system. Traditionally, concurrency control techniques are locking, timestamp ordering and optimistic. These techniques have been evaluated by analytical modeling. In this undertaken work, the analytical modeling has been investigated and evaluated. The concurrency control in order to improve optimistic validation method with the traditional techniques, a new technique has been proposed.


Author(s):  
Manoj Kumar Gupta . ◽  
Rakesh Kumar Arora . ◽  
Bhoopesh Singh Bhati .

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.


Sign in / Sign up

Export Citation Format

Share Document