Models for Studying Concurrency Control Performance: Alternatives and Implications.
Rakesh Agrawal, Michael J. Carey, Miron Livny:
Models for Studying Concurrency Control Performance: Alternatives and Implications.
SIGMOD Conference 1985: 108-121@inproceedings{DBLP:conf/sigmod/AgrawalCL85,
author = {Rakesh Agrawal and
Michael J. Carey and
Miron Livny},
editor = {Shamkant B. Navathe},
title = {Models for Studying Concurrency Control Performance: Alternatives
and Implications},
booktitle = {Proceedings of the 1985 ACM SIGMOD International Conference on
Management of Data, Austin, Texas, May 28-31, 1985},
publisher = {ACM Press},
year = {1985},
pages = {108-121},
ee = {http://doi.acm.org/10.1145/318898.318909, db/conf/sigmod/AgrawalCL85.html},
crossref = {DBLP:conf/sigmod/85},
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 "complete" model of a database
environment to study the relative performance of three different
approaches to the concurrency control problem
under a variety of modeling assumptions. We show how
differences in the underlying assumptions explain the seemingly
contradictory performance results. We also examine
how realistic the various assumptions would be for "real"
database systems.
Copyright © 1985 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.
Online Version (ACM WWW Account required): Full Text in PDF Format
CDROM Version: Load the CDROM "Volume 1 Issue 2, SIGMOD '75-'92" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Shamkant B. Navathe (Ed.):
Proceedings of the 1985 ACM SIGMOD International Conference on Management of Data, Austin, Texas, May 28-31, 1985.
ACM Press 1985 BibTeX
,
SIGMOD Record 14(4)
Contents
Journal Version
Rakesh Agrawal, Michael J. Carey, Miron Livny:
Concurrency Control Performance Modeling: Alternatives and Implications.
ACM Trans. Database Syst. 12(4): 609-654(1987) BibTeX
References
- [Agra83a]
- 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
- [Agra83b]
- ...
- [Bada79]
- ...
- [Balt82]
- 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
- [Bern80a]
- ...
- [Bern80b]
- Philip A. Bernstein, Nathan Goodman:
Timestamp-Based Algorithms for Concurrency Control in Distributed Database Systems.
VLDB 1980: 285-300 BibTeX
- [Bern81]
- Philip A. Bernstein, Nathan Goodman:
Concurrency Control in Distributed Database Systems.
ACM Comput. Surv. 13(2): 185-221(1981) BibTeX
- [Bern82]
- Philip A. Bernstein, Nathan Goodman:
A Sophisticate's Introduction to Distributed Concurrency Control (Invited Paper).
VLDB 1982: 62-76 BibTeX
- [Care83a]
- Michael J. Carey:
Modeling and Evaluation of Database Concurrency Control Algorithms.
Ph.D. thesis, College of Engineering, University of California, Berkeley 1983
BibTeX
- [Care83b]
- Michael J. Carey:
An Abstract Model of Database Concurrency Control Algorithms.
SIGMOD Conference 1983: 97-107 BibTeX
- [Care84]
- Michael J. Carey, Michael Stonebraker:
The Performance of Concurrency Control Algorithms for Database Management Systems.
VLDB 1984: 107-118 BibTeX
- [Casa79]
- ...
- [Ceri82]
- Stefano Ceri, Susan S. Owicki:
On the Use of Optimistic Methods for Concurrency Control in Distributed Databases.
Berkeley Workshop 1982: 117-129 BibTeX
- [Fran83]
- Peter A. Franaszek, John T. Robinson:
Limitations of Concurrency in Transaction Processing.
ACM Trans. Database Syst. 10(1): 1-28(1985) BibTeX
- [Gall82]
- ...
- [Good83]
- Nathan Goodman, Rajan Suri, Y. C. Tay:
A Simple Analytic Model for Performance of Exclusive Locking in Database Systems.
PODS 1983: 203-215 BibTeX
- [Gray79]
- Jim Gray:
Notes on Data Base Operating Systems.
Advanced Course: Operating Systems 1978: 393-481 BibTeX
- [Gray81]
- 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
- [Iran79]
- Keki B. Irani, Hing-Lung Lin:
Queuing Network Models for Concurrent Transaction Processing in a Database System.
SIGMOD Conference 1979: 134-142 BibTeX
- [Kung81]
- H. T. Kung, John T. Robinson:
On Optimistic Methods for Concurrency Control.
ACM Trans. Database Syst. 6(2): 213-226(1981) BibTeX
- [Lin82a]
- ...
- [Lin82b]
- Wen-Te K. Lin, Jerry Nolte:
Performance of Two Phase Locking.
Berkeley Workshop 1982: 131-160 BibTeX
- [Lin83]
- Wen-Te K. Lin, Jerry Nolte:
Basic Timestamp, Multiple Version Timestamp, and Two-Phase Locking.
VLDB 1983: 109-119 BibTeX
- [Lind79]
- ...
- [Mena78]
- Daniel A. Menascé, Richard R. Muntz:
Locking and Deadlock Detection in Distributed Databases.
Berkeley Workshop 1978: 215-232 BibTeX
- [Pein83]
- Peter Peinl, Andreas Reuter:
Empirical Comparison of Database Concurrency Schemes.
VLDB 1983: 97-108 BibTeX
- [Poti80]
- Dominique Potier, Ph. Leblanc:
Analysis of Locking Policies in Database Management Systems.
Commun. ACM 23(10): 584-593(1980) BibTeX
- [Reed78]
- ...
- [Reut83]
- ...
- [Ries77]
- Daniel R. Ries, Michael Stonebraker:
Effects of Locking Granularity in a Database Management System.
ACM Trans. Database Syst. 2(3): 233-246(1977) BibTeX
- [Ries79a]
- Daniel R. Ries:
The Effects of Concurrency Control on the Performance of a Distributed Data Management System.
Berkeley Workshop 1979: 75-112 BibTeX
- [Ries79b]
- Daniel R. Ries, Michael Stonebraker:
Locking Granularity Revisited.
ACM Trans. Database Syst. 4(2): 210-227(1979) BibTeX
- [Robi82a]
- ...
- [Robi82b]
- ...
- [Rose78]
- 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
- [Sarg76]
- ...
- [Spit76]
- ...
- [Ston79]
- Michael Stonebraker:
Concurrency Control and Consistency of Multiple Copies of Data in Distributed INGRES.
IEEE Trans. Software Eng. 5(3): 188-194(1979) BibTeX
- [Tay84a]
- ...
- [Tay84b]
- Y. C. Tay, Rajan Suri:
Choice and Performance in Locking for Databases.
VLDB 1984: 119-128 BibTeX
- [Thom79]
- Robert H. Thomas:
A Majority Consensus Approach to Concurrency Control for Multiple Copy Databases.
ACM Trans. Database Syst. 4(2): 180-209(1979) BibTeX
- [Thom83]
- ...
- [Wulf81]
- ...
Referenced by
- Kaushik Chakrabarti, Sharad Mehrotra:
Efficient Concurrency Control in Multidimensional Access Methods.
SIGMOD Conference 1999: 25-36
- Tadashi Ohmori, Mamoru Hoshi:
Gaming-Simulations of Multi-Agent Information Systems using Large Databases: The Concept and Database Algorithms.
DASFAA 1995: 95-106
- Edward Omiecinski, Liehuey Lee, Peter Scheuermann:
Performance Analysis of a Concurrent File Reorganization Algorithm for Record Clustering.
IEEE Trans. Knowl. Data Eng. 6(2): 248-257(1994)
- Shun Yan Cheung, Mostafa H. Ammar, Mustaque Ahamad:
The Grid Protocol: A High Performance Scheme for Maintaining Replicated Data.
IEEE Trans. Knowl. Data Eng. 4(6): 582-592(1992)
- Vibby Gottemukkala, Tobin J. Lehman:
Locking and Latching in a Memory-Resident Database System.
VLDB 1992: 533-544
- Edward Omiecinski, Liehuey Lee, Peter Scheuermann:
Concurrent File Reorganization for Record Clustering: A Performance Study.
ICDE 1992: 265-272
- Yongdong Wang, Lawrence A. Rowe:
Cache Consistency and Concurrency Control in a Client/Server DBMS Architecture.
SIGMOD Conference 1991: 367-376
- Tadashi Ohmori, Masaru Kitsuregawa, Hidehiko Tanaka:
Scheduling Batch Transactions on Shared-Nothing Parallel Database Machines: Effects of Concurrency and Parallelism.
ICDE 1991: 210-219
- Maurice Herlihy:
Apologizing Versus Asking Permission: Optimistic Concurrency Control for Abstract Data Types.
ACM Trans. Database Syst. 15(1): 96-124(1990)
- Yin-Fu Huang, Yeh-Hao Chin:
A New Methodology to Evaluate Locking Protocols.
IEEE Trans. Knowl. Data Eng. 2(4): 431-435(1990)
- W. Kevin Wilkinson, Marie-Anne Neimat:
Maintaining Consistency of Client-Cached Data.
VLDB 1990: 122-133
- Tadashi Ohmori, Masaru Kitsuregawa, Hidehiko Tanaka:
Concurrency Control of Bulk Access Transactions on Shared Nothing Parallel Database Machines.
ICDE 1990: 476-485
- Alok N. Choudhary:
Cost of Distributed Deadlock Detection: A Performance Study.
ICDE 1990: 174-181
- Shun Yan Cheung, Mostafa H. Ammar, Mustaque Ahamad:
The Grid Protocol: A High Performance Scheme for Maintaining Replicated Data.
ICDE 1990: 438-445
- Jeffrey D. Ullman:
Principles of Database and Knowledge-Base Systems, Volume II.
Computer Science Press 1989, ISBN 0-7167-8162-X
Contents - Margaret H. Eich, David L. Wells:
Database Concurrency Control Using Data Flow Graphs.
ACM Trans. Database Syst. 13(2): 197-227(1988)
- Thanasis Hadzilacos:
Serialization Graph Algorithms for Multiversion Concurrency Control.
PODS 1988: 135-141
- William Perrizo, Min Luo, Donald A. Varvel:
Ordering Accesses to Improving Transaction Processing Performance.
ICDE 1988: 58-63
- Edward Omiecinski:
Concurrent Storage Structure Conversion: from B+ Tree to Linear Hash File.
ICDE 1988: 589-596
- Anupam Bhide, Michael Stonebraker:
A Performance Comparison of Two Architectures for Fast Transaction Processing.
ICDE 1988: 536-545
- Ouri Wolfson:
The Overhead of Locking (and Commit) Protocols in Distributed Databases.
ACM Trans. Database Syst. 12(3): 453-471(1987)
- Michael Stonebraker:
The Design of the POSTGRES Storage System.
VLDB 1987: 289-300
- Akhil Kumar, Michael Stonebraker:
Performance Evaluation of an Operating System Transaction Manager.
VLDB 1987: 473-481
- Kazuo Sugihara:
Concurrency Control Based on Distributed Cycle Detection.
ICDE 1987: 267-274
- Amit P. Sheth, Anoop Singhal, Ming T. Liu:
Performance Analysis of Resiliency Mechanisms in Distributed Datbase Systems.
ICDE 1987: 419-428
- Bao-Chyuan Jenq, Walter H. Kohler, Donald F. Towsley:
A Queueing Network Model for a Distributed Database Testbed System.
ICDE 1987: 62-71
- Mohan Ahuja, James C. Browne:
Concurrency Control by Pre-Ordering Entities in Databases with Multi-Versioned Entities.
ICDE 1987: 312-321
- 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
- Y. C. Tay, Nathan Goodman, Rajan Suri:
Locking Performance in Centralized Databases.
ACM Trans. Database Syst. 10(4): 415-462(1985)
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
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:39:41 2009