Optimistic versus pessimistic concurrency control mechanisms in database management systems

@article{Menasc1982OptimisticVP,
  title={Optimistic versus pessimistic concurrency control mechanisms in database management systems},
  author={Daniel A. Menasc{\'e} and Tatuo Nakanishi},
  journal={Inf. Syst.},
  year={1982},
  volume={7},
  pages={13-27}
}
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

Citations

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

References

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
  • ACM TODS
  • 1979

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

  • Lipsky, D. J.
  • Proc .

Similar Papers

Loading similar papers…