ACM SIGMOD Anthology VLDB dblp.uni-trier.de

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}
}

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

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 4, VLDB '75-'88" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

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 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

References

[BEHR82]
Rudolf Bayer, Klaus Elhardt, Johannes Heigert, Angelika Reiser: Dynamic Timestamp Allocation for Transactions in Database Systems. DDB 1982: 9-20 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[BHR80]
Rudolf Bayer, Hans Heller, Angelika Reiser: Parallelism and Recovery in Database Systems. ACM Trans. Database Syst. 5(2): 139-156(1980) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[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) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[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) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[EH82]
Wolfgang Effelsberg, Theo Härder: Principles of Database Buffer Management. ACM Trans. Database Syst. 9(4): 560-595(1984) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[GLPT76]
...
[Gr78]
Jim Gray: Notes on Data Base Operating Systems. Advanced Course: Operating Systems 1978: 393-481 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Hä82]
Theo Härder: Observations on optimistic concurrency control schemes. Inf. Syst. 9(2): 111-120(1984) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[KL82]
...
[KR81]
H. T. Kung, John T. Robinson: On Optimistic Methods for Concurrency Control. ACM Trans. Database Syst. 6(2): 213-226(1981) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[MN82]
Daniel A. Menascé, Tatuo Nakanishi: Optimistic versus pessimistic concurrency control mechanisms in database management systems. Inf. Syst. 7(1): 13-27(1982) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[PSU82]
U. Prädel, Gunter Schlageter, Rainer Unland: Einige Verbesserungen optimistischer Synchronisationsverfahren. GI Jahrestagung 1982: 684-698 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Re82]
Andreas Reuter: Concurrency on High-trafic Data Elements. PODS 1982: 83-92 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[RS77]
Daniel R. Ries, Michael Stonebraker: Effects of Locking Granularity in a Database Management System. ACM Trans. Database Syst. 2(3): 233-246(1977) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[RS79]
Daniel R. Ries, Michael Stonebraker: Locking Granularity Revisited. ACM Trans. Database Syst. 4(2): 210-227(1979) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[Sc81]
Gunter Schlageter: Optimistic Methods for Concurrency Control in Distributed Database Systems. VLDB 1981: 125-130 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[UPS83]
...

Copyright © Tue Mar 16 02:21:57 2010 by Michael Ley (ley@uni-trier.de)