The Indonesian Journal of Computer Science
Vol. 14 No. 6 (2025): The Indonesian Journal of Computer Science

Concurrency Control in Distributed Databases: A Systematic Review

Lloyd Moluma, Tshidiso (Unknown)
Esiefarienrhe, Bukohwo Michael (Unknown)



Article Info

Publish Date
17 Dec 2025

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.

Copyrights © 2025






Journal Info

Abbrev

ijcs

Publisher

Subject

Computer Science & IT Electrical & Electronics Engineering Engineering

Description

The Indonesian Journal of Computer Science (IJCS) is a bimonthly peer-reviewed journal published by AI Society and STMIK Indonesia. IJCS editions will be published at the end of February, April, June, August, October and December. The scope of IJCS includes general computer science, information ...