• May 14, 2019 News!IJIET Vol. 7, No. 9-Vol. 8, No. 8 have been indexed by EI (Inspec).   [Click]
  • Apr 15, 2019 News![Call for Papers] Special Issue on Education, Research and Innovation   [Click]
  • May 22, 2019 News!Vol. 9, No. 5 has been indexed by Crossref.
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 (Since 2019), EI(INSPEC, IET), EBSCO, Electronic Journals Library, Google Scholar, Crossref, etc.
    • E-mail: ijiet@ejournal.net
Prof. Dr. Steve Thatcher
QUniversity, Australia
It is my honor to be the editor-in-chief of IJIET. The journal publishes good-quality papers which focous on the advanced researches in the field of information and education technology. Hopefully, IJIET will become a recognized journal among the scholars in the related fields.

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.

Copyright © 2008-2019. International Journal of Information and Education Technology. All rights reserved.
E-mail: ijiet@ejournal.net