Basic Timestamp, Multiple Version Timestamp, and Two-Phase Locking.
Wen-Te K. Lin, Jerry Nolte:
Basic Timestamp, Multiple Version Timestamp, and Two-Phase Locking.
VLDB 1983: 109-119@inproceedings{DBLP:conf/vldb/LinN83,
author = {Wen-Te K. Lin and
Jerry Nolte},
editor = {Mario Schkolnick and
Costantino Thanos},
title = {Basic Timestamp, Multiple Version Timestamp, and Two-Phase Locking},
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 = {109-119},
ee = {db/conf/vldb/LinN83.html},
crossref = {DBLP:conf/vldb/83},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
Using simulation, we compare the performance
of the Basic Timestamp, the Multiple Version
Timestamp, and the Two-Phase Locking concurrency
control algorithms. We find that in
every system configuration we have simulated the
Multiple Version Timestamp algorithm performs
only marginally better than the Basic Timestamp
algorithm. In addition, we find that when the
average transaction size is small, both timestamp
algorithms outperform the Two-Phase Locking algorithm. But when the average transaction
size is large, the Two-Phase Locking algorithm
outperforms both timestamp algorithms.
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 ...
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
References
- [Bad-1]
- Dushan Z. Badal, Gerald J. Popek:
A Proposal for Distributed Concurrency Control for Partially Redundant Distributed Data Base Systems.
Berkeley Workshop 1978: 273-285
- [Bg-1]
- Philip A. Bernstein, Nathan Goodman:
Concurrency Control in Distributed Database Systems.
ACM Comput. Surv. 13(2): 185-221(1981)
- [Co-1]
- Stefano Ceri, Susan S. Owicki:
On the Use of Optimistic Methods for Concurrency Control in Distributed Databases.
Berkeley Workshop 1982: 117-129
- [El-1]
- Clarence A. Ellis:
A Robust Algorithm for Updating Duplicate Databases.
Berkeley Workshop 1977: 146-158
- [Gal-1]
- ...
- [Gar-1]
- ...
- [GS-1]
- Erol Gelenbe, Kenneth C. Sevcik:
Analysis of Update Synchronization for Multiple Copy Data-Bases.
Berkeley Workshop 1978: 69-90
- [GW-1]
- Hector Garcia-Molina, Gio Wiederhold:
Read-Only Transactions in a Distributed Database.
ACM Trans. Database Syst. 7(2): 209-234(1982)
- [Gra-1]
- 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
- [KR-1]
- H. T. Kung, John T. Robinson:
On Optimistic Methods for Concurrency Control.
ACM Trans. Database Syst. 6(2): 213-226(1981)
- [KP-1]
- H. T. Kung, Christos H. Papadimitriou:
An Optimality Theory of Concurrency Control for Databases.
SIGMOD Conference 1979: 116-126
- [Lin-1]
- Wen-Te K. Lin:
Performance Evaluation of Two Concurrency Control Mechanisms in a Distributed Database System.
SIGMOD Conference 1981: 84-92
- [LIN-2]
- ...
- [LIN-3]
- Wen-Te K. Lin:
Concurrency Control in a Multiple Copy Distributed Database System.
Berkeley Workshop 1979: 207-220
- [LN-1]
- Wen-Te K. Lin, Jerry Nolte:
Performance of Two Phase Locking.
Berkeley Workshop 1982: 131-160
- [LN-2]
- ...
- [LN-3]
- ...
- [LN-4]
- ...
- [Pap-1]
- Christos H. Papadimitriou:
On the Power of Locking.
SIGMOD Conference 1981: 148-154
- [Rie-1]
- ...
- [Ros-1]
- 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)
- [Sev-1]
- Kenneth C. Sevcik:
Data Base System Performance Prediction Using an Analytical Model (Invited Paper).
VLDB 1981: 182-198
- [SK-1]
- Abraham Silberschatz, Zvi M. Kedem:
A Family of Locking Protocols for Database Systems that Are Modeled by Directed Graphs.
IEEE Trans. Software Eng. 8(6): 558-562(1982)
- [SR-1]
- Richard Edwin Stearns, Daniel J. Rosenkrantz:
Distributed Database Concurrency Controls Using Before-Values.
SIGMOD Conference 1981: 74-83
- [Sto-1]
- Michael Stonebraker:
Concurrency Control and Consistency of Multiple Copies of Data in Distributed INGRES.
IEEE Trans. Software Eng. 5(3): 188-194(1979)
- [Tha-1]
- Costantino Thanos, Carlo Carlesi, Elisa Bertino:
Performance Evaluation of Two Concurrency Control Mechanisms in a Distributed Database System.
ECI 1981: 266-279
- [Tho-1]
- Robert H. Thomas:
A Majority Consensus Approach to Concurrency Control for Multiple Copy Databases.
ACM Trans. Database Syst. 4(2): 180-209(1979)
Copyright © Tue Mar 16 02:21:57 2010
by Michael Ley (ley@uni-trier.de)