Download PDFOpen PDF in browserConcurrency Control in Distributed DatabaseEasyChair Preprint 42115 pages•Date: September 19, 2020AbstractIn 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: Conservative-2PL, Distributed Database, SC-2PL, Strict-2PL, concurrency control
|