Volume 7 Number 8 (Aug. 2012)
Home > Archive > 2012 > Volume 7 Number 8 (Aug. 2012) >
JSW 2012 Vol.7(8): 1855-1860 ISSN: 1796-217X
doi: 10.4304/jsw.7.8.1855-1860

Detecting Offline Transaction Concurrency Problems

Hao Luo1, Mehedi Masud2, and Hasan Ural1
1EECS, University of Ottawa, Ottawa, Canada
2Department of Computer Science, Taif University, Taif, Saudi Arabia

Abstract—When multiple instances of a database application (DBA) are executing concurrently, transactions from these instances interleave. Due to unintentional grouping of operations of the DBA into transactions, some interleavings of these transactions may cause offline concurrency problems. Although these problems are analogous to lost update, dirty read, non-repeatable read, and phantom problems, the concurrency controller of a DBMS cannot ensure ACID properties because from the DBMS’s point of view the transactions involved in the offline concurrency problems are executed successfully. This paper gives the enumeration of patterns of interleaving of operations which identify potential offline concurrency problems in a DBA.

Index Terms—database concurrency, transaction processing, consistency, database application testing


Cite: Hao Luo, Mehedi Masud, and Hasan Ural, "Detecting Offline Transaction Concurrency Problems," Journal of Software vol. 7, no. 8, pp. 1855-1860, 2012.

General Information

ISSN: 1796-217X (Online)
Frequency: Monthly
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, ProQuest, INSPEC, ULRICH's Periodicals Directory, WorldCat, CNKI,etc
E-mail: jsw@iap.org
  • Jun 25, 2019 News!

    Papers published in JSW Vol. 14, No. 1- Vol. 14 No. 6 have been indexed by DBLP.    [Click]

  • Jun 25, 2019 News!

    Vol.13, No.9 has been indexed by EI (Inspec).   [Click]

  • Aug 01, 2018 News!

    [CFP] 2019 the annual meeting of JSW Editorial Board, ICCSM 2019, will be held in Barcelona, Spain, July 14-16, 2019.   [Click]

  • Jul 10, 2019 News!

    Vol 14, No.8 has been published with online version 4 original aritcles from 2 countries are published in this issue.    [Click]

  • Jul 22, 2019 News!

    Welcome Prof Ferhat Khendek from Canada to join the Editorial board of JSW    [Click]