Performance Comparison of Static vs. Dynamic Two Phase Locking Protocols
Sheung-Lun Hung, Kam-Yiu Lam · Journal of Database Management · 1992
Queuing network models have been used extensively in the study of the performance of different concurrency control protocols in database systems. However, the results obtained are mostly qualitative in nature with few quantitative design rules which address performance issues such as data and resource contentions. In this paper, an attempt has been made to carry out comprehensive simulation studies of two well known locking protocols, namely the Static Two Phase Locking and the Dynamic Two Phase Locking, for database systems with the aim of obtaining practical design rules for such systems.Request access from your librarian to read this article's full text.