A Review on Concurrency Control Techniques in Database Management Systems | ||||
| Kafrelsheikh Journal of Information Sciences | ||||
| Article 2, Volume 3, Issue 1, June 2022, Page 1-10 PDF (803.31 K) | ||||
| Document Type: Original Article | ||||
| DOI: 10.21608/kjis.2022.246104 | ||||
 View on SCiNiTO | ||||
| Authors | ||||
Mahmoud Y. Shams1; Amr Abohany  2
| ||||
| 1Faculty of Artificial Intelligence, Kafrelsheikh University, Kafrelsheikh, 33516, Egypt. | ||||
| 2Faculty of Computers and Information, Kafrelsheikh University, Kafrelsheikh, Egypt, 33516, Egypt. | ||||
| 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. | ||||
| Keywords | ||||
| Distributed database; Concurrency control; 2PC; 3PC; Deadlock; 2phase locking | ||||
|
Statistics Article View: 853 PDF Download: 1,202 |
||||
