Concurrency Control Protocol for Main Memory Database Systems 


Vol. 3,  No. 7, pp. 1687-1696, Dec.  1996
10.3745/KIPSTE.1996.3.7.1687


PDF
  Abstract

Most of the main memory database systems use two-phase locking(2PL) for concurrency control. the 2PL method is preferred over other methods for concurrency control because of its simplicity and common usage. However, conventional concurrency control solution will function poorly when the data are memory resident. In this paper, we propose a new optimistic concurrency control protocol for a main memory database system. In our proposed protocol, transaction conflict information is used in validation phase to improve data conflict resolution decisions. Our experiments show that the proposed protocol performs better than 2PL in term of throughput for main memory database system environments.

  Statistics


  Cite this article

[IEEE Style]

S. J. Ik and B. H. Young, "Concurrency Control Protocol for Main Memory Database Systems," The Transactions of the Korea Information Processing Society (1994 ~ 2000), vol. 3, no. 7, pp. 1687-1696, 1996. DOI: 10.3745/KIPSTE.1996.3.7.1687.

[ACM Style]

Shim Jong Ik and Bae Hae Young. 1996. Concurrency Control Protocol for Main Memory Database Systems. The Transactions of the Korea Information Processing Society (1994 ~ 2000), 3, 7, (1996), 1687-1696. DOI: 10.3745/KIPSTE.1996.3.7.1687.