Performance of Concurrency Control Methods in Distributed Database Management Systems (Timestamp Ordering, Two-Phase Locking, Optimistic Scheme, Restart, Transaction Blocking)

The effects of transaction restart overhead on the performance of concurrency control methods (CCMs) have been studied using the simulation approach. In order to do this, detailed simulation models for a representative sample of concurrency control mechanisms, namely Basic Timestamp Ordering (BTO), Basic Optimistic scheme (BOPT), Basic Two-Phase Locking (B2PL), and Conservative Timestamp Ordering (CoTO), were developed, and the performances of those CCMs in distributed database management system (DDBMS) were simulated with some care to get statistically significant results. The performances of the CCMs were then compared with respect to several measures. This study systematically investigated effects of major factors on CCM performance in a quantitative manner, whereas few quantitative results have been obtained in the past work on CCM performance.

Name thesis:degree_name

Ph.D.

Level thesis:degree_level

Dissertation

Discipline thesis:degree_discipline

Computer Science

Grantor

University of Illinois at Urbana-Champaign

Year dc:date

2014

Author dc:creator

• Moon, Song Chun

• Computer Science

Identifier

(UMI)AAI8521839

OAI identifier oai:identifier

oai:www.ideals.illinois.edu:2142/69543