A Review on Concurrency Control Techniques in Database Management Systems

Abstract

: Conflicts, deadlock and rolled-back transactions are being considered as the most recent challenges related to executing the transaction concurrently on different environments of Database Management Systems (DBMS). More precisely, in distributed database systems, to handle and avoid these challenges, there are different techniques and protocols are utilized. In this paper, we highlight some of these techniques which includes Two-Phase Commit (2PC) protocol and Three-Phase Commit (3PC) protocol) as well as and Deadlock-Free Cell lock (DFCL) algorithm. Moreover, the paper surveys all these protocols and demonstrate the pros and cons of each techniques. Afterwards, we proposed the solution of some important problems related to concurrency control techniques in DBMS