International Journal For Multidisciplinary Research

E-ISSN: 2582-2160     Impact Factor: 9.24

A Widely Indexed Open Access Peer Reviewed Multidisciplinary Bi-monthly Scholarly International Journal

Call for Paper Volume 8, Issue 1 (January-February 2026) Submit your research before last 3 days of February to publish your research paper in the issue of January-February.

High-performance Hybrid Concurrency Control for Database Systems with Multiple Users-A New Dynamic Framework.

Author(s) Ms. Neha . Chahal
Country India
Abstract Abstract- The growing use of data-centric applications has increased the need for efficient, consistent, scalable data management systems. While ensuring high performance, the data management system must also maintain strong consistency even under heavy concurrent access. Traditional concurrency control technologies like Two-Phase Locking, Timestamp Ordering, and Optimistic Concurrency Control are simply not adequate for cloud-native, distributed and in-memory database applications that are seen in the modern world. This research paper proposes a dynamic hybrid concurrency control algorithm that implements Fine-Grained 2PL for write-intensive applications and Timestamp Ordering, based on Multi-Version Concurrency Control methods, for read-intensive applications. We introduce a new technique to detect deadlocks based on Wait-Die to minimize the number of transaction stalls without using any overheads. We performed extensive experiments on synthetic databases and the TPC-C benchmark, and our results show that our system improves throughput by 45%, reduces abort rates by 25% and improves scalability compared to traditional concurrency control methods. Our approach provides good support for legacy systems, and it can be used as the basis for building next-generation data management systems that cater to multi-user, real-time environments. Our future work involves integrating Machine Learning models to automatically select the optimal concurrency control method and extending the support to geo-distributed databases.
Keywords Hybrid Concurrency Control, Two-Phase Locking, Timestamp Ordering, Optimistic Concurrency Control, Wait-Die protocol.
Field Computer
Published In Volume 7, Issue 4, July-August 2025
Published On 2025-08-30
DOI https://doi.org/10.36948/ijfmr.2025.v07i04.54670

Share this