Performance of B-Tree Concurrency Algorithms.
V. Srinivasan, Michael J. Carey:
Performance of B-Tree Concurrency Algorithms.
SIGMOD Conference 1991: 416-425@inproceedings{DBLP:conf/sigmod/SrinivasanC91,
author = {V. Srinivasan and
Michael J. Carey},
editor = {James Clifford and
Roger King},
title = {Performance of B-Tree Concurrency Algorithms},
booktitle = {Proceedings of the 1991 ACM SIGMOD International Conference on
Management of Data, Denver, Colorado, May 29-31, 1991},
publisher = {ACM Press},
year = {1991},
pages = {416-425},
ee = {http://doi.acm.org/10.1145/115790.115860, db/conf/sigmod/SrinivasanC91.html},
crossref = {DBLP:conf/sigmod/91},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
A number of algorithms have been proposed for accessing
B-trees concurrently, but the performance of these
algorithms is not yet well understood. In this paper, we
study the performance of various concurrency control
algorithms using a detailed simulation model of B-tree
operations in a centralized DBMS. Our study considers
a wide range of data contention situations and resource
conditions. Results from our experiments indicate that
algorithms in which updaters lock-couple using exclusive
locks perform poorly as compared to those that
permit more optimistic index descents. In particular,
the B-link algorithms provide the most concurrency and
the best overall performance.
Copyright © 1991 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
James Clifford, Roger King (Eds.):
Proceedings of the 1991 ACM SIGMOD International Conference on Management of Data, Denver, Colorado, May 29-31, 1991.
ACM Press 1991 BibTeX
,
SIGMOD Record 20(2),
June 1991
Contents
[Index Terms]
[Full Text in PDF Format, 1060 KB]
References
- [Agra87]
- Rakesh Agrawal, Michael J. Carey, Miron Livny:
Concurrency Control Performance Modeling: Alternatives and Implications.
ACM Trans. Database Syst. 12(4): 609-654(1987) BibTeX
- [Baye77]
- Rudolf Bayer, Mario Schkolnick:
Concurrency of Operations on B-Trees.
Acta Inf. 9: 1-21(1977) BibTeX
- [Bili85]
- ...
- [Bili87]
- Alexandros Biliris:
Operation Specific Locking in B-Trees.
PODS 1987: 159-169 BibTeX
- [Care84]
- ...
- [Come79]
- Douglas Comer:
The Ubiquitous B-Tree.
ACM Comput. Surv. 11(2): 121-137(1979) BibTeX
- [Good85]
- Nathan Goodman, Dennis Shasha:
Semantically-based Concurrency Control for Search Structures.
PODS 1985: 8-19 BibTeX
- [Gary79]
- Jim Gray:
Notes on Data Base Operating Systems.
Advanced Course: Operating Systems 1978: 393-481 BibTeX
- [Guib78]
- Leonidas J. Guibas, Robert Sedgewick:
A Dichromatic Framework for Balanced Trees.
FOCS 1978: 8-21 BibTeX
- [John89]
- Theodore Johnson, Dennis Shasha:
Utilization of B-trees with Inserts, Deletes and Modifies.
PODS 1989: 235-246 BibTeX
- [John90]
- Theodore Johnson, Dennis Shasha:
A Framework for the Performance Analysis of Concurrent B-tree Algorithms.
PODS 1990: 273-287 BibTeX
- [John91]
- ...
- [Kell88]
- Arthur M. Keller, Gio Wiederhold:
Concurrent Use of B-trees with Variable-Length Entries.
SIGMOD Record 17(2): 89-90(1988) BibTeX
- [Kwon82]
- Yat-Sang Kwong, Derick Wood:
A New Method for Concurrency in B-Trees.
IEEE Trans. Software Eng. 8(3): 211-222(1982) BibTeX
- [Lani86]
- Vladimir Lanin, Dennis Shasha:
A Symmetric Concurrent B-Tree Algorithm.
FJCC 1986: 380-389 BibTeX
- [Lehm81]
- Philip L. Lehman, S. Bing Yao:
Efficient Locking for Concurrent Operations on B-Trees.
ACM Trans. Database Syst. 6(4): 650-670(1981) BibTeX
- [Livn90]
- ...
- [Mill78]
- ...
- [Moha89]
- C. Mohan, Frank E. Levine:
ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging.
SIGMOD Conference 1992: 371-380 BibTeX
- [Mond85]
- Yehudit Mond, Yoav Raz:
Concurrency Control in B+-Trees Databases Using Preparatory Operations.
VLDB 1985: 331-334 BibTeX
- [Sagi85]
- Yehoshua Sagiv:
Concurrent Operations on B-Trees with Overtaking.
PODS 1985: 28-37 BibTeX
- [Sama76]
- Behrokh Samadi:
B-Trees in a System with Multiple Users.
Inf. Process. Lett. 5(4): 107-112(1976) BibTeX
- [Shas85]
- Dennis Shasha:
What Good are Concurrent Search Structure Algorithms for databases Anyway?
IEEE Database Eng. Bull. 8(2): 84-90(1985) BibTeX
- [Srin91]
- ...
- [Weih90]
- ...
- [Yao78]
- Andrew Chi-Chih Yao:
On Random 2-3 Trees.
Acta Inf. 9: 159-170(1978) BibTeX
Referenced by
- Haruo Yokota, Yasuhiko Kanemasa, Jun Miyazaki:
Fat-Btree: An Update-Conscious Parallel Directory Structure.
ICDE 1999: 448-457
- Tei-Wei Kuo, Chih-Hung Wei, Kam-yiu Lam:
Real-Time Data Access Control on B-Tree Index Structures.
ICDE 1999: 458-467
- Vigyan Singhal, Alan Jay Smith:
Analysis of Locking Behavior in Three Real Database Systems.
VLDB J. 6(1): 40-52(1997)
- Georgios Evangelidis, David B. Lomet, Betty Salzberg:
The hB-Pi-Tree: A Multi-Attribute Index Supporting Concurrency, Recovery and Node Consolidation.
VLDB J. 6(1): 1-25(1997)
- Marcel Kornacker, C. Mohan, Joseph M. Hellerstein:
Concurrency and Recovery in Generalized Search Trees.
SIGMOD Conference 1997: 62-72
- Marcel Kornacker, Douglas Banks:
High-Concurrency Locking in R-Trees.
VLDB 1995: 134-145
- Brajesh Goyal, Jayant R. Haritsa, S. Seshadri, V. Srinivasan:
Index Concurrency Control in Firm Real-Time Database Systems.
VLDB 1995: 146-157
- Georgios Evangelidis, David B. Lomet, Betty Salzberg:
The hBP-tree: A Modified hB-tree Supporting Concurrency, Recovery and Node Consolidation.
VLDB 1995: 551-561
- V. Srinivasan, Michael J. Carey:
Performance of B+ Tree Concurrency Algorithms.
VLDB J. 2(4): 361-406(1993)
- Theodore Johnson, Dennis Shasha:
The Performance of Current B-Tree Algorithms.
ACM Trans. Database Syst. 18(1): 51-101(1993)
- Goetz Graefe:
Query Evaluation Techniques for Large Databases.
ACM Comput. Surv. 25(2): 73-170(1993)
- John K. Lee:
B-Tree Concurrency Control Algorithm for Nested Transaction Systems.
DASFAA 1993: 205-215
- David B. Lomet, Betty Salzberg:
Access Method Concurrency with Recovery.
SIGMOD Conference 1992: 351-360
- John Turek, Dennis Shasha, Sundeep Prakash:
Locking without Blocking: Making Lock Based Concurrent Data Structure Algorithms Nonblocking.
PODS 1992: 212-222
- V. Srinivasan, Michael J. Carey:
Performance of On-Line Index Construction Algorithms.
EDBT 1992: 293-309
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:40:07 2009