loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
28th Annual Simulation Symposium
Simulation analysis of early commit concurrency control protocols
Santa Barbara, California
April 25-April 28
ISBN: 0-8186-7091-6
P.J. Fortier, Dept. of Electr. & Comput. Eng., Massachusetts Univ., Dartmouth, MA, USA
J.C. Sieg, Jr., Dept. of Electr. & Comput. Eng., Massachusetts Univ., Dartmouth, MA, USA
This paper describes results of a simulation model for decomposition of concurrency control enforcement in databases. The database is partitioned into atomic data sets using constraints defined during database design. For each atomic data set A, the transaction writer declares a point in his transaction after which there will be no more accesses to A. This location is a candidate for early commitment. We present three new concurrency control protocols: early-commit versions of conventional locking, timestamp ordering, and optimistic protocols, and two new recovery protocols: merged-commit and replay. A simulation model used to model these protocols is described. The new protocols performance is compared to that of their conventional counterparts using the described simulator.
Index Terms:
concurrency control; database management systems; virtual machines; transaction processing; protocols; system recovery; simulation analysis; early commit concurrency control protocols; simulation model; concurrency control enforcement; databases; atomic data sets; database design; transaction writer; conventional locking; timestamp ordering; optimistic protocols; recovery protocols; merged-commit; replay; protocols performance
Citation:
P.J. Fortier, J.C. Sieg, Jr., "Simulation analysis of early commit concurrency control protocols," ss, pp.322, 28th Annual Simulation Symposium, 1995
Usage of this product signifies your acceptance of the Terms of Use.