Concurrency Control in Distributed Database

EasyChair Preprint no. 4211

Abstract

In a distributed database, uncontrolled concurrent execution of multiple transactions can lead to inconsistencies and can affect data integrity. So, there is requirement of controlling the concurrent execution of the transactions so that the consistency and integrity of the database systems can be ensured. The study presents the new breed of mechanism known as the SC-2PL concurrency control mechanism, which is a mixture of Strict-2PL and Conservative-2PL concurrency control mechanisms. Our proposal improves the performance of the distributed database through the elimination of blockages, cascading aborts and dirty reads and write.

Keyphrases: concurrency control, Conservative-2PL, Distributed Database, SC-2PL, Strict-2PL

@Booklet{EasyChair:4211,
  author = {Fatima Bara and Chaimae Saadi and Habiba Chaoui},
  title = {Concurrency Control in Distributed Database},
  howpublished = {EasyChair Preprint no. 4211},

  year = {EasyChair, 2020}}