Exploring Concurrency Control Techniques in Multi-User Database Systems: A Comprehensive Review

Author(s)	Rupali Banerjee
Country	India
Abstract	Multi-user database systems require concurrency control techniques in order to maintain data consistency and integrity while handling concurrent transactions. Four important concurrency control techniques are examined in this paper: timestamp-based, validation-based, lock-based (including the popular Two-Phase Locking (2PL) protocols). Lock-based protocols use locks to control access to shared resources; on the other hand, two-phase logic (2PL) guarantees transaction serialization. Timestamp-based protocols provide a consistent execution order by scheduling and ordering transactions according to distinct timestamps.Optimistic concurrency control, or validation-based protocols, validate transactions after they are executed in order to reduce conflicts without first obtaining locks. By means of an extensive investigation of various protocols, the principles, methods, benefits, and drawbacks are clarified, assisting in the well-informed choice and application of concurrency control techniques that are customized to meet particular database system needs.
Keywords	DDBMS, 2PL, Time stamp, Validation based protocol
Field	Computer > Data / Information
Published In	Volume 6, Issue 3, May-June 2024
Published On	2024-06-28
DOI	https://doi.org/10.36948/ijfmr.2024.v06i03.23286
Short DOI	https://doi.org/gt2427

About IJFMR Fees & Payment Current Issue Publication Archive	Submit Research Paper Track Submission Status Publication Guidelines Publication Ethics Peer Review & Plagiarism	Join as a Reviewer Editors & Reviewers Reviewer Referral Program Get Reviewer Membership Certi.	Website/Journal Policies Usage Policy Content Policies Privacy Policy

Contact Us		+91-9687-828-838	editor@ijfmr.com

International Journal For Multidisciplinary Research