Use of Hybrid Mechanism of High Performance in Distributed Database Management System

Dr. Banita and Neha
Additional contact information
Dr. Banita: Baba Mastnath University Rohtak, India
Neha: Baba Mastnath University Rohtak, India

International Journal of Latest Technology in Engineering, Management & Applied Science, 2025, vol. 14, issue 5, 1088-1092

Abstract: The frantic carrying out of operations in a distributed database management system has to meet the joint contingent properties of an ACID (especially, consistency and isolation) in order that the present simultaneous transactions can fail or pass in any way. Techniques such as Two-Phase Locking, Timestamp Ordering, Optimistic Concurrency Control, and Multi-Version Concurrency Control (MVCC) have something different with advantages and disadvantages under various high contention or skewed workloads. This paper proposes a hybrid concurrency control model, which can intelligently select among these protocols based on real-time transaction attributes and workload conditions. In case of another transaction being blocked by an active one, a transaction classifier and protocol allocator is set to switch back and forth dynamically between strategies. With the help of PostgreSQL and Python, simulating and evaluating the system using metrics such as throughput, latency, abort rate, and occurrence of deadlock performance. Overall, hybrid models can exhibit performance improvements, especially with read-intensive and mixed workloads, by - reducing transaction aborts and giving a faster response time. Hybrid models will offer modern scalable DDBMS a good alternative.

Date: 2025
References: Add references at CitEc
Citations:

Downloads: (external link)
https://www.ijltemas.in/DigitalLibrary/Vol.14Issue5/1088-1092.pdf (application/pdf)
https://www.ijltemas.in/papers/volume-14-issue-5/1088-1092.html (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:bjb:journl:v:14:y:2025:i:5:p:1088-1092

Access Statistics for this article

International Journal of Latest Technology in Engineering, Management & Applied Science is currently edited by Dr. Pawan Verma

More articles in International Journal of Latest Technology in Engineering, Management & Applied Science from International Journal of Latest Technology in Engineering, Management & Applied Science (IJLTEMAS)
Bibliographic data for series maintained by Dr. Pawan Verma ().