Optimistic versus pessimistic concurrency control mechanisms in database management systems

  title={Optimistic versus pessimistic concurrency control mechanisms in database management systems},
  author={Daniel A. Menasc{\'e} and Tatuo Nakanishi},
  journal={Inf. Syst.},
A~~~onc~ency control rnec~~srns are necessary to preserve database inte~ty in a multi-user environment. Two kinds of concurrency control mechanisms are considered in this paper, namely optimistic and pessimistic ones. Optimistic concurrency control is based on the idea of conflicts and transaction restart while pessimistic concurrency control uses locking as the basic serialization mechanism. Analytic and simulation models of both mechanisms were developed in order to compare them as far as… CONTINUE READING
Highly Influential
This paper has highly influenced 15 other papers. REVIEW HIGHLY INFLUENTIAL CITATIONS


Publications citing this paper.
Showing 1-10 of 87 extracted citations


Publications referenced by this paper.
Showing 1-3 of 3 references

Queuein network model for concurrent transaction processing in a database system

  • H. L. Lin
  • 1979

Church : Application df a queueing network model for a computer system

  • Lipsky, D. J.
  • Proc .

Similar Papers

Loading similar papers…