Buffer Management in Relational Database Systems.
Giovanni Maria Sacco, Mario Schkolnick:
Buffer Management in Relational Database Systems.
ACM Trans. Database Syst. 11(4): 473-498(1986)@article{DBLP:journals/tods/SaccoS86,
author = {Giovanni Maria Sacco and
Mario Schkolnick},
title = {Buffer Management in Relational Database Systems},
journal = {ACM Trans. Database Syst.},
volume = {11},
number = {4},
year = {1986},
pages = {473-498},
ee = {http://doi.acm.org/10.1145/7239.7336, db/journals/tods/SaccoS86.html},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
The hot-set model, characterizing the buffer requirements of
relational queries, is presented. This model allows the system
to determine the optimal buffer space to be allocated to a
query; it can also be used by the query optimizer to derive
efficient execution plans accounting for the available buffer
space, and by a query scheduler to prevent thrashing. The
hot-set model is compared with the working-set model.
A simulation study is presented.
Copyright © 1986 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
References
- [1]
- Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Kapali P. Eswaran, Jim Gray, Patricia P. Griffiths, W. Frank King III, Raymond A. Lorie, Paul R. McJones, James W. Mehl, Gianfranco R. Putzolu, Irving L. Traiger, Bradford W. Wade, Vera Watson:
System R: Relational Approach to Database Management.
ACM Trans. Database Syst. 1(2): 97-137(1976) BibTeX
- [2]
- Rudolf Bayer:
Database System Design for High Performance.
IFIP Congress 1983: 147-155 BibTeX
- [3]
- Rudolf Bayer, Edward M. McCreight:
Organization and Maintenance of Large Ordered Indices.
Acta Inf. 1: 173-189(1972) BibTeX
- [4]
- Philip A. Bernstein, Nathan Goodman, Eugene Wong, Christopher L. Reeve, James B. Rothnie Jr.:
Query Processing in a System for Distributed Databases (SDD-1).
ACM Trans. Database Syst. 6(4): 602-625(1981) BibTeX
- [5]
- Mike W. Blasgen, Kapali P. Eswaran:
Storage and Access in Relational Data Bases.
IBM Systems Journal 16(4): 362-377(1977) BibTeX
- [6]
- Haran Boral, David J. DeWitt:
A Methodology for Database System Performance Evaluation.
SIGMOD Conference 1984: 176-185 BibTeX
- [7]
- ...
- [8]
- Hong-Tai Chou, David J. DeWitt:
An Evaluation of Buffer Management Strategies for Relational Database Systems.
VLDB 1985: 127-141 BibTeX
- [9]
- Stavros Christodoulakis:
Implications of Certain Assumptions in Database Performance Evaluation.
ACM Trans. Database Syst. 9(2): 163-186(1984) BibTeX
- [10]
- E. F. Codd:
A Relational Model of Data for Large Shared Data Banks.
Commun. ACM 13(6): 377-387(1970) BibTeX
- [11]
- ...
- [12]
- Douglas Comer:
The Ubiquitous B-Tree.
ACM Comput. Surv. 11(2): 121-137(1979) BibTeX
- [13]
- Peter J. Denning:
The Working Set Model for Program Behaviour.
Commun. ACM 11(5): 323-333(1968) BibTeX
- [14]
- Wolfgang Effelsberg, Theo Härder:
Principles of Database Buffer Management.
ACM Trans. Database Syst. 9(4): 560-595(1984) BibTeX
- [15]
- Wolfgang Effelsberg, Mary E. S. Loomis:
Logical, Internal, and Physical Reference Behavior in CODASYL Database Systems.
ACM Trans. Database Syst. 9(2): 187-213(1984) BibTeX
- [16]
- Eduardo B. Fernández, Tomás Lang, Christopher Wood:
Effect of Replacement Algorithms on a Paged Buffer Database System.
IBM J. Res. Dev. 22(2): 185-196(1978) BibTeX
- [17]
- ...
- [18]
- Jim Gray:
Notes on Data Base Operating Systems.
Advanced Course: Operating Systems 1978: 393-481 BibTeX
- [19]
- ...
- [20]
- Won Kim:
A New Way to Compute the Product and Join of Relations.
SIGMOD Conference 1980: 179-187 BibTeX
- [21]
- Donald E. Knuth:
The Art of Computer Programming, Volume III: Sorting and Searching.
Addison-Wesley 1973, ISBN 0-201-03803-X
BibTeX
- [22]
- Tomás Lang, Christopher Wood, Eduardo B. Fernández:
Database Buffer Paging in Virtual Storage Systems.
ACM Trans. Database Syst. 2(4): 339-351(1977) BibTeX
- [23]
- Raymond A. Lorie:
Physical Integrity in a Large Segmented Database.
ACM Trans. Database Syst. 2(1): 91-104(1977) BibTeX
- [24]
- W. S. Luk:
On Estimating Block Accesses in Database Organizations.
Commun. ACM 26(11): 945-947(1983) BibTeX
- [25]
- ...
- [26]
- ...
- [27]
- David D. Redell, Yogen K. Dalal, Thomas R. Horsley, Hugh C. Lauer, William C. Lynch, Paul R. McJones, Hal G. Murray, Stephen C. Purcell:
Pilot: An Operating System for a Personal Computer.
Commun. ACM 23(2): 81-92(1980) BibTeX
- [28]
- ...
- [29]
- Giovanni Maria Sacco:
Fragmentation: A Technique for Efficient Query Processing.
ACM Trans. Database Syst. 11(2): 113-133(1986) BibTeX
- [30]
- ...
- [31]
- 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
- [32]
- ...
- [33]
- Patricia G. Selinger, Morton M. Astrahan, Donald D. Chamberlin, Raymond A. Lorie, Thomas G. Price:
Access Path Selection in a Relational Database Management System.
SIGMOD Conference 1979: 23-34 BibTeX
- [34]
- Michael Stonebraker, Eugene Wong, Peter Kreps, Gerald Held:
The Design and Implementation of INGRES.
ACM Trans. Database Syst. 1(3): 189-222(1976) BibTeX
- [35]
- Michael Stonebraker:
Operating System Support for Database Management.
Commun. ACM 24(7): 412-418(1981) BibTeX
- [36]
- Kyu-Young Whang, Gio Wiederhold, Daniel Sagalowicz:
Estimating Block Accesses in Database Organizations: A Closed Noniterative Formula.
Commun. ACM 26(11): 940-944(1983) BibTeX
- [37]
- 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]
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: Tue Jun 24 20:11:48 2008