Concurrency Control Performance Modeling: Alternatives and Implications.
Rakesh Agrawal, Michael J. Carey, Miron Livny:
Concurrency Control Performance Modeling: Alternatives and Implications.
ACM Trans. Database Syst. 12(4): 609-654(1987)@article{DBLP:journals/tods/AgrawalCL87,
author = {Rakesh Agrawal and
Michael J. Carey and
Miron Livny},
title = {Concurrency Control Performance Modeling: Alternatives and Implications},
journal = {ACM Trans. Database Syst.},
volume = {12},
number = {4},
year = {1987},
pages = {609-654},
ee = {http://doi.acm.org/10.1145/32204.32220, db/journals/tods/AgrawalCL87.html},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
A number of recent studies have examined the performance of
concurrency control algorithms for database management systems.
The results reported to date, rather than being definitive,
have tended to be contradictory. In this paper, rather than
presenting "yet another algorithm performance study," we
critically investigate the assumptions made in the models used
in past studies and their implications. We employ a fairly
complete model of a database environment for studying the
relative performance of three different approaches to the
concurrency control problem under a variety of modeling
assumptions. The three approaches studied represent different
extremes in how transaction conflicts are dealt with, and the
assumptions addressed pertain to the nature of the database
system's resources, how transaction restarts are modeled, and
the amount of information available to the concurrency control
algorithm about transactions' reference strings. We show that
differences in the underlying assumptions explain the seemingly
contradictory performance results. We also address the question
of how realistic the various assumptions are for actual
database systems.
Copyright © 1987 by the ACM,
Inc., used by permission. Permission to make
digital or hard copies is granted provided that
copies are not made or distributed for profit or
direct commercial advantage, and that copies show
this notice on the first page or initial screen of
a display along with the full citation.
CDROM Version: Load the CDROM "Volume 3 Issue 1, TODS 1976-1990" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 2" and ...
BibTeX
Conference Version
Rakesh Agrawal, Michael J. Carey, Miron Livny:
Models for Studying Concurrency Control Performance: Alternatives and Implications.
SIGMOD Conference 1985: 108-121 BibTeX
References
- [1]
- ...
- [2]
- Rakesh Agrawal, David J. DeWitt:
Integrated Concurrency Control and Recovery Mechanisms: Design and Performance Evaluation.
ACM Trans. Database Syst. 10(4): 529-564(1985) BibTeX
- [3]
- Rakesh Agrawal, Michael J. Carey, David J. DeWitt:
Deadlock Detection is Cheap.
SIGMOD Record 13(2): 19-34(1983) BibTeX
- [4]
- Rakesh Agrawal, Michael J. Carey, Lawrence W. McVoy:
The Performance of Alternative Strategies for Dealing with Deadlocks in Database Management Systems.
IEEE Trans. Software Eng. 13(12): 1348-1363(1987) BibTeX
- [5]
- ...
- [6]
- R. Balter, P. Berard, Paul Decitre:
Why Control of the Concurrency Level in Distributed Systems is More Fundamental Than Deadlock Management.
PODC 1982: 183-193 BibTeX
- [7]
- ...
- [8]
- Philip A. Bernstein, Nathan Goodman:
Timestamp-Based Algorithms for Concurrency Control in Distributed Database Systems.
VLDB 1980: 285-300 BibTeX
- [9]
- Philip A. Bernstein, Nathan Goodman:
Concurrency Control in Distributed Database Systems.
ACM Comput. Surv. 13(2): 185-221(1981) BibTeX
- [10]
- Philip A. Bernstein, Nathan Goodman:
A Sophisticate's Introduction to Distributed Concurrency Control (Invited Paper).
VLDB 1982: 62-76 BibTeX
- [11]
- 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
- [12]
- Michael J. Carey:
Modeling and Evaluation of Database Concurrency Control Algorithms.
Ph.D. thesis, College of Engineering, University of California, Berkeley 1983
BibTeX
- [13]
- Michael J. Carey:
An Abstract Model of Database Concurrency Control Algorithms.
SIGMOD Conference 1983: 97-107 BibTeX
- [14]
- Michael J. Carey, Waleed A. Muhanna:
The Performance of Multiversion Concurrency Control Algorithms.
ACM Trans. Comput. Syst. 4(4): 338-378(1986) BibTeX
- [15]
- Michael J. Carey, Michael Stonebraker:
The Performance of Concurrency Control Algorithms for Database Management Systems.
VLDB 1984: 107-118 BibTeX
- [16]
- ...
- [17]
- Stefano Ceri, Susan S. Owicki:
On the Use of Optimistic Methods for Concurrency Control in Distributed Databases.
Berkeley Workshop 1982: 117-129 BibTeX
- [18]
- Klaus Elhardt, Rudolf Bayer:
A Database Cache for High Performance and Fast Restart in Database Systems.
ACM Trans. Database Syst. 9(4): 503-525(1984) BibTeX
- [19]
- 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
- [20]
- Peter A. Franaszek, John T. Robinson:
Limitations of Concurrency in Transaction Processing.
ACM Trans. Database Syst. 10(1): 1-28(1985) BibTeX
- [21]
- ...
- [22]
- Nathan Goodman, Rajan Suri, Y. C. Tay:
A Simple Analytic Model for Performance of Exclusive Locking in Database Systems.
PODS 1983: 203-215 BibTeX
- [23]
- Jim Gray:
Notes on Data Base Operating Systems.
Advanced Course: Operating Systems 1978: 393-481 BibTeX
- [24]
- Jim Gray, Pete Homan, Henry F. Korth, Ron Obermarck:
A Straw Man Analysis of the Probability of Waiting and Deadlock in a Database System.
Berkeley Workshop 1981: 125 BibTeX
- [25]
- Theo Härder, Peter Peinl:
Evaluating Multiple Server DBMS in General Purpors Operating System Environments.
VLDB 1984: 129-140 BibTeX
- [26]
- Keki B. Irani, Hing-Lung Lin:
Queuing Network Models for Concurrent Transaction Processing in a Database System.
SIGMOD Conference 1979: 134-142 BibTeX
- [27]
- H. T. Kung, John T. Robinson:
On Optimistic Methods for Concurrency Control.
ACM Trans. Database Syst. 6(2): 213-226(1981) BibTeX
- [28]
- ...
- [29]
- Wen-Te K. Lin, Jerry Nolte:
Performance of Two Phase Locking.
Berkeley Workshop 1982: 131-160 BibTeX
- [30]
- Wen-Te K. Lin, Jerry Nolte:
Basic Timestamp, Multiple Version Timestamp, and Two-Phase Locking.
VLDB 1983: 109-119 BibTeX
- [31]
- ...
- [32]
- Daniel A. Menascé, Richard R. Muntz:
Locking and Deadlock Detection in Distributed Databases.
Berkeley Workshop 1978: 215-232 BibTeX
- [33]
- Christos H. Papadimitriou:
The serializability of concurrent database updates.
J. ACM 26(4): 631-653(1979) BibTeX
- [34]
- Peter Peinl, Andreas Reuter:
Empirical Comparison of Database Concurrency Schemes.
VLDB 1983: 97-108 BibTeX
- [35]
- Dominique Potier, Ph. Leblanc:
Analysis of Locking Policies in Database Management Systems.
Commun. ACM 23(10): 584-593(1980) BibTeX
- [36]
- ...
- [37]
- ...
- [38]
- Andreas Reuter:
Performance Analysis of Recovery Techniques.
ACM Trans. Database Syst. 9(4): 526-559(1984) BibTeX
- [39]
- ...
- [40]
- Daniel R. Ries, Michael Stonebraker:
Effects of Locking Granularity in a Database Management System.
ACM Trans. Database Syst. 2(3): 233-246(1977) BibTeX
- [41]
- Daniel R. Ries, Michael Stonebraker:
Locking Granularity Revisited.
ACM Trans. Database Syst. 4(2): 210-227(1979) BibTeX
- [42]
- John T. Robinson:
Design of Concurrency Controls for Transaction Processing Systems.
Ph.D. thesis, Carnegie Mellon University 1982
BibTeX
- [43]
- ...
- [44]
- Daniel J. Rosenkrantz, Richard Edwin Stearns, Philip M. Lewis II:
System Level Concurrency Control for Distributed Database Systems.
ACM Trans. Database Syst. 3(2): 178-198(1978) BibTeX
- [45]
- ...
- [46]
- ...
- [47]
- ...
- [48]
- Michael Stonebraker:
Concurrency Control and Consistency of Multiple Copies of Data in Distributed INGRES.
IEEE Trans. Software Eng. 5(3): 188-194(1979) BibTeX
- [49]
- Michael Stonebraker, Lawrence A. Rowe:
The Design of Postgres.
SIGMOD Conference 1986: 340-355 BibTeX
- [50]
- ...
- [51]
- Y. C. Tay, Nathan Goodman, Rajan Suri:
Locking Performance in Centralized Databases.
ACM Trans. Database Syst. 10(4): 415-462(1985) BibTeX
- [52]
- Robert H. Thomas:
A Majority Consensus Approach to Concurrency Control for Multiple Copy Databases.
ACM Trans. Database Syst. 4(2): 180-209(1979) BibTeX
- [53]
- ...
- [54]
- ...
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
TODS, ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Fri May 16 16:52:31 2008