Home > Archive > 2014 > Volume 4 Number 4 (Aug. 2014) >
IJIET 2014 Vol.4(4): 313-318 ISSN: 2010-3689
DOI: 10.7763/IJIET.2014.V4.420

Performance Analysis of Concurrency Control Mechanisms for OLTP Databases

Samuel Kaspi and Sitalakshmi Venkatraman

Abstract—Concurrency control (CC) in distributed and multidimensional databases is becoming more important due to recent increase in high-volume data storage with increasing online transaction processing (OLTP) requirements for medium and large organisations. This paper examines three concurrency control mechanisms commonly adopted and analyses their performance in distributed databases for OLTP operational systems of enterprises. The three CC mechanisms investigated are, two phase locking (2PL), wait depth limited (WDL) and optimistic concurrency control. These CC mechanisms have been studied well in disk-based systems. However, with the recent advances of cost-effective main memory or in-memory storage that can support much higher transaction rates than disk-based systems, there is sufficient motivation to re-investigate the performance of such CC mechanisms in diverse processor configurations. This paper presents a comparison of their behaviour and performance in terms of throughput rates achieved with varying transaction size and contention. The outcome of this study has resulted in further research proposals for improving the performance of these CC mechanisms for OLTP databases.

Index Terms—Concurrency control, online transaction processing (OLTP), in-memory databases, performance.

The authors are with the Department of Higher Education (IT) - Business, Northern Melbourne Institute of TAFE, VIC 3066 Australia (e-mail: SamKaspi@nmit.edu.au, SitaVenkat@nmit.edu.au).


Cite: Samuel Kaspi and Sitalakshmi Venkatraman, "Performance Analysis of Concurrency Control Mechanisms for OLTP Databases," International Journal of Information and Education Technology vol. 4, no. 4, pp. 313-318, 2014.

General Information

  • ISSN: 2010-3689 (Online)
  • Abbreviated Title: Int. J. Inf. Educ. Technol.
  • Frequency: Monthly
  • DOI: 10.18178/IJIET
  • Editor-in-Chief: Prof. Dr. Steve Thatcher
  • Executive Editor: Ms. Nancy Y. Liu
  • Abstracting/ Indexing: Scopus (CiteScore 2022: 2.0), INSPEC (IET), UGC-CARE List (India), CNKI, EBSCO, Google Scholar
  • E-mail: ijiet@ejournal.net


Article Metrics in Dimensions