Lloyd Moluma, Tshidiso
Unknown Affiliation

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

Concurrency Control in Distributed Databases: A Systematic Review Lloyd Moluma, Tshidiso; Esiefarienrhe, Bukohwo Michael
The Indonesian Journal of Computer Science Vol. 14 No. 6 (2025): The Indonesian Journal of Computer Science
Publisher : AI Society & STMIK Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33022/ijcs.v14i6.5045

Abstract

This paper provides a comprehensive review of concurrency control techniques used in distributed database systems. It focuses on recent developments by examining articles and other academic documents published between 2016 and 2025. Using PRISMA 2020 guidelines, 197 scientific and academic studies were screened across major databases, and 10 articles met the final criteria for detailed analysis. The review classifies concurrency control approaches into four areas: types of locks, performance, accuracy, and efficiency. Each classification is then evaluated based on throughput, latency, detection accuracy, scalability, and technique applied to enhance these metrics. The findings demonstrate that traditional algorithms maintain consistent performance in general conditions but often struggle under heavy contention. Contrastingly, multi-version concurrency control and optimistic techniques improve scalability but introduce high abortion rates. Emerging adaptive techniques that depend on workload profiling show increasing promises for dynamic environments. The review highlights these trends and outlines future research direction for resilient distributed systems.