SIMULATION STUDIES ON CONCURRENCY-CONTROL IN PARALLEL TRANSACTION PROCESSING SYSTEMS

Parallel transaction processing (TP) systems have great potential to s erve the ever-increasing demands for high transaction processing rate. This potential, however, may not be reached due to the concurrency co ntrol (CC) requirements. In this paper a simulation system for shared- nothing parallel TP systems was presented, which aims at, but is not r estricted to, the studies of the CC methods. A distributed locking-bas ed CC method called LW DCk (local wait-depth control) was also propose d for overcoming the drawbacks of the widely-used two-phase locking (2 PL) CC method. LW DCk was compared with 2PL and the well-known DWDL (d istributed wait-depth limited) CC methods based on the presented simul ation system. The application of this simulation system demonstrated i ts effectiveness, Simulation studies indicated also that the proposed method outperforms 2PL and DWDL.