Empirical Comparison of Database Concurrency Schemes.
Peter Peinl, Andreas Reuter:
Empirical Comparison of Database Concurrency Schemes.
VLDB 1983: 97-108@inproceedings{DBLP:conf/vldb/PeinlR83,
author = {Peter Peinl and
Andreas Reuter},
editor = {Mario Schkolnick and
Costantino Thanos},
title = {Empirical Comparison of Database Concurrency Schemes},
booktitle = {9th International Conference on Very Large Data Bases, October
31 - November 2, 1983, Florence, Italy, Proceedings},
publisher = {Morgan Kaufmann},
year = {1983},
isbn = {0-934613-15-X},
pages = {97-108},
ee = {db/conf/vldb/PeinlR83.html},
crossref = {DBLP:conf/vldb/83},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
This paper presents an empirical comparison of
three classes of database concurrency control
schemes: classical (r,x)-protcols, (r,a,c)/(r,a,x)-protocols based on two temporary
object versions, and optimistic concurrency
control. evaluation is based on six different
real-life database reference strings recorded
with a network DBMS. Sizes of the underlying
databases vary between 60 MB and 2.9 GB. For
comparing the performance impacts of
synchronization protocols, we introduce a
quantitative measure which basically reflects
two parameters: First, number and length of
blocking situations, and second the overhead
incurred by repeated transaction execution due
to deadlocks and validation conflicts,
respectively. The results are highly sur-
prisinq compared to the expectations based on
qualitative considerations.
Copyright © 1983 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 4, VLDB '75-'88" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Mario Schkolnick, Costantino Thanos (Eds.):
9th International Conference on Very Large Data Bases, October 31 - November 2, 1983, Florence, Italy, Proceedings.
Morgan Kaufmann 1983, ISBN 0-934613-15-X
Contents BibTeX
References
- [BEHR82]
- Rudolf Bayer, Klaus Elhardt, Johannes Heigert, Angelika Reiser:
Dynamic Timestamp Allocation for Transactions in Database Systems.
DDB 1982: 9-20 BibTeX
- [BHR80]
- Rudolf Bayer, Hans Heller, Angelika Reiser:
Parallelism and Recovery in Database Systems.
ACM Trans. Database Syst. 5(2): 139-156(1980) BibTeX
- [BSW80]
- Philip A. Bernstein, David W. Shipman, Wing S. Wong:
Formal Aspects of Serializability in Database Concurrency Control.
IEEE Trans. Software Eng. 5(3): 203-216(1979) BibTeX
- [EGLT76]
- Kapali P. Eswaran, Jim Gray, Raymond A. Lorie, Irving L. Traiger:
The Notions of Consistency and Predicate Locks in a Database System.
Commun. ACM 19(11): 624-633(1976) BibTeX
- [EH82]
- Wolfgang Effelsberg, Theo Härder:
Principles of Database Buffer Management.
ACM Trans. Database Syst. 9(4): 560-595(1984) BibTeX
- [GLPT76]
- ...
- [Gr78]
- Jim Gray:
Notes on Data Base Operating Systems.
Advanced Course: Operating Systems 1978: 393-481 BibTeX
- [Hä82]
- Theo Härder:
Observations on optimistic concurrency control schemes.
Inf. Syst. 9(2): 111-120(1984) BibTeX
- [KL82]
- ...
- [KR81]
- H. T. Kung, John T. Robinson:
On Optimistic Methods for Concurrency Control.
ACM Trans. Database Syst. 6(2): 213-226(1981) BibTeX
- [MN82]
- Daniel A. Menascé, Tatuo Nakanishi:
Optimistic versus pessimistic concurrency control mechanisms in database management systems.
Inf. Syst. 7(1): 13-27(1982) BibTeX
- [PSU82]
- U. Prädel, Gunter Schlageter, Rainer Unland:
Einige Verbesserungen optimistischer Synchronisationsverfahren.
GI Jahrestagung 1982: 684-698 BibTeX
- [Re82]
- Andreas Reuter:
Concurrency on High-trafic Data Elements.
PODS 1982: 83-92 BibTeX
- [RS77]
- Daniel R. Ries, Michael Stonebraker:
Effects of Locking Granularity in a Database Management System.
ACM Trans. Database Syst. 2(3): 233-246(1977) BibTeX
- [RS79]
- Daniel R. Ries, Michael Stonebraker:
Locking Granularity Revisited.
ACM Trans. Database Syst. 4(2): 210-227(1979) BibTeX
- [Sc81]
- Gunter Schlageter:
Optimistic Methods for Concurrency Control in Distributed Database Systems.
VLDB 1981: 125-130 BibTeX
- [UPS83]
- ...
Referenced by
- Axel Mönkeberg, Gerhard Weikum:
Performance Evaluation of an Adaptive and Robust Load Control Method for the Avoidance of Data-Contention Thrashing.
VLDB 1992: 432-443
- Divyakant Agrawal, Amr El Abbadi, Richard Jeffers:
An Approach to Eliminate Transaction Blocking in Locking Protocols.
PODS 1992: 223-235
- Jiandong Huang, John A. Stankovic, Krithi Ramamritham, Donald F. Towsley:
Experimental Evaluation of Real-Time Optimistic Concurrency Control Schemes.
VLDB 1991: 35-46
- Axel Mönkeberg, Gerhard Weikum:
Conflict-driven Load Control for the Avoidance of Data-Contention Thrashing.
ICDE 1991: 632-639
- Sang Hyuk Son, Navid Haghighi:
Performance Evaluation of Multiversion Database Systems.
ICDE 1990: 129-136
- Cyril U. Orji, Leszek Lilien, Janusz Hyziak:
A Performance Analysis of an Optimistic and a Basic Timestamp-Ordering Concurrency Control Algorithm for Centralized Database Systems.
ICDE 1988: 64-71
- Rakesh Agrawal, Michael J. Carey, Miron Livny:
Concurrency Control Performance Modeling: Alternatives and Implications.
ACM Trans. Database Syst. 12(4): 609-654(1987)
- Philip A. Bernstein, Vassos Hadzilacos, Nathan Goodman:
Concurrency Control and Recovery in Database Systems.
Addison-Wesley 1987, ISBN 0-201-10715-5
Contents - U. Prädel, Gunter Schlageter, Rainer Unland:
Redesign of Optimistic Methods: Improving Performance and Applicability.
ICDE 1986: 466-473
- Rakesh Agrawal, David J. DeWitt:
Integrated Concurrency Control and Recovery Mechanisms: Design and Performance Evaluation.
ACM Trans. Database Syst. 10(4): 529-564(1985)
- Israel Gold, Oded Shmueli, Micha Hofri:
The Private Workspace Model Feasibility and Applications to 2PL Performance Improvements.
VLDB 1985: 192-208
- Rakesh Agrawal, Michael J. Carey, Miron Livny:
Models for Studying Concurrency Control Performance: Alternatives and Implications.
SIGMOD Conference 1985: 108-121
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:45:18 2009