@inproceedings{1ccd6ad4fe0741bb9677c99eb0d4cf9d,
title = "OPTIMISTIC VS PESSIMISTIC CONCURRENCY CONTROL ALGORITHM: A COMPARATIVE STUDY.",
abstract = "The behavior and performance of two fundamentally different concurrency control algorithms (CCAs) for single-site databases has been investigated. These are the dynamic two-phase locking (2PL) and the commit-time validation (CTV) algorithms. 2PL represents a pessimistic approach to concurrency control whereas CTV is an optimistic approach. For each algorithm a performance model has been constructed and a simulation has been performed. Three parameters affecting data contention are studied: the degree of multiprogramming (the load effect), the read/write mix (ratio of query to update) and the database granularity. Unlike previous studies, the combined effect of these three parameters has been considered, providing insight into their composite impact.",
author = "Nagi, {M. H.} and Helal, {A. A.} and Elmagarmid, {A. K.}",
year = "1986",
language = "English",
isbn = "0818607246",
series = "Proceedings of the International Conference on Parallel Processing",
publisher = "IEEE",
pages = "131--138",
editor = "Kai Hwang and Jacobs, {Steven M.} and Swartzlander, {Earl E.}",
booktitle = "Proceedings of the International Conference on Parallel Processing",
}