Concurrency Control Algorithms for different databases: A review

Abstract

Concurrency control is one of the most very important component in managing a transaction, which ensures the correctness of shared data items. Most of the concurrency control techniques use locking mechanism to obtain concurrency control. Transaction processing, concurrency control and recovery issues have played a major role in conventional databases, and hence have been an important area of research for many decades. Concurrency control is a mechanism applied in concurrent operations of database so that all the operation complete successfully without interfering in the results of each other. Several research papers have been presented on concurrency control issues in nested transaction environments. There are several concurrency control techniques that are proposed to prevent data inconsistency. In this paper we are discussing the types of concurrency control techniques (lock based and lock free)
available. We are also comparing the lock based and lock-free techniques for concurrency control.