GHOST: Fine Granularity Buffering of Indexes.
Cheng Hian Goh, Beng Chin Ooi, D. Sim, Kian-Lee Tan:
GHOST: Fine Granularity Buffering of Indexes.
VLDB 1999: 339-350@inproceedings{DBLP:conf/vldb/GohOST99,
author = {Cheng Hian Goh and
Beng Chin Ooi and
D. Sim and
Kian-Lee Tan},
editor = {Malcolm P. Atkinson and
Maria E. Orlowska and
Patrick Valduriez and
Stanley B. Zdonik and
Michael L. Brodie},
title = {GHOST: Fine Granularity Buffering of Indexes},
booktitle = {VLDB'99, Proceedings of 25th International Conference on Very
Large Data Bases, September 7-10, 1999, Edinburgh, Scotland,
UK},
publisher = {Morgan Kaufmann},
year = {1999},
isbn = {1-55860-615-7},
pages = {339-350},
ee = {db/conf/vldb/GohOST99.html},
crossref = {DBLP:conf/vldb/99},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
Buffering has all along been an important
strategy for exploiting the cost/performance
ratio of disk versus random-access memory.
The buffering of disk pages belonging to a
database has been well-studied, but literature
that deals specifically with index buffering is
scare. This is surprising given the significance
of indexes (especially B+-tree like indexes)
in modern DBMSs. In this paper, we
describe a dual buffering scheme for indexes,
called GHOST, in which part of the buffer is
used to maintain popularly used "paths" of
the B+-tree index, while the remainder is devoted
to maintaining a Splay-tree with pointers
to leaf pages containing frequently used
leaf pages. This scheme allows us to maintain
pointers to leaf nodes long after the paths
leading to the leaf nodes have been replaced,
thus maintaining "ghost" paths to the nodes.
In addition to describing the search and maintenance
operations for the GHOST buffering
scheme, we also conduct a series of experiments
in which it is shown that GHOST outperforms
the best existing schemes (ILRU and
OLRU) by impressive margins for almost all
pragmatic query workloads.
Copyright © 1999 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
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Malcolm P. Atkinson, Maria E. Orlowska, Patrick Valduriez, Stanley B. Zdonik, Michael L. Brodie (Eds.):
VLDB'99, Proceedings of 25th International Conference on Very Large Data Bases, September 7-10, 1999, Edinburgh, Scotland, UK.
Morgan Kaufmann 1999, ISBN 1-55860-615-7
Contents BibTeX
References
- [1]
- ...
- [2]
- Rudolf Bayer, Edward M. McCreight:
Organization and Maintenance of Large Ordered Indices.
Acta Inf. 1: 173-189(1972) BibTeX
- [3]
- Stefan Berchtold, Christian Böhm, Hans-Peter Kriegel:
The Pyramid-Technique: Towards Breaking the Curse of Dimensionality.
SIGMOD Conference 1998: 142-153 BibTeX
- [4]
- Chee Yong Chan, Beng Chin Ooi, Hongjun Lu:
Extensible Buffer Management of Indexes.
VLDB 1992: 444-454 BibTeX
- [5]
- Hong-Tai Chou, David J. DeWitt:
An Evaluation of Buffer Management Strategies for Relational Database Systems.
VLDB 1985: 127-141 BibTeX
- [6]
- Douglas Comer:
The Ubiquitous B-Tree.
ACM Comput. Surv. 11(2): 121-137(1979) BibTeX
- [7]
- Wolfgang Effelsberg, Theo Härder:
Principles of Database Buffer Management.
ACM Trans. Database Syst. 9(4): 560-595(1984) BibTeX
- [8]
- Leonidas J. Guibas, Robert Sedgewick:
A Dichromatic Framework for Balanced Trees.
FOCS 1978: 8-21 BibTeX
- [9]
- Antonin Guttman:
R-Trees: A Dynamic Index Structure for Spatial Searching.
SIGMOD Conference 1984: 47-57 BibTeX
- [10]
- Elizabeth J. O'Neil, Patrick E. O'Neil, Gerhard Weikum:
The LRU-K Page Replacement Algorithm For Database Disk Buffering.
SIGMOD Conference 1993: 297-306 BibTeX
- [11]
- Beng Chin Ooi, Cheng Hian Goh, Kian-Lee Tan:
Fast High-Dimensional Data Search in Incomplete Databases.
VLDB 1998: 357-367 BibTeX
- [12]
- Giovanni Maria Sacco:
Index Access with a Finite Buffer.
VLDB 1987: 301-309 BibTeX
- [13]
- Giovanni Maria Sacco, Mario Schkolnick:
A Mechanism for Managing the Buffer Pool in a Relational Database System Using the Hot Set Model.
VLDB 1982: 257-262 BibTeX
- [14]
- Daniel Dominic Sleator, Robert Endre Tarjan:
Self-Adjusting Binary Search Trees.
J. ACM 32(3): 652-686(1985) BibTeX
- [15]
- S. Bing Yao:
Approximating the Number of Accesses in Database Organizations.
Commun. ACM 20(4): 260-261(1977) BibTeX
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
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:46:27 2009