Predictive Load Control for Flexible Buffer Allocation.
Christos Faloutsos, Raymond T. Ng, Timos K. Sellis:
Predictive Load Control for Flexible Buffer Allocation.
VLDB 1991: 265-274@inproceedings{DBLP:conf/vldb/FaloutsosNS91,
author = {Christos Faloutsos and
Raymond T. Ng and
Timos K. Sellis},
editor = {Guy M. Lohman and
Am\'{\i}lcar Sernadas and
Rafael Camps},
title = {Predictive Load Control for Flexible Buffer Allocation},
booktitle = {17th International Conference on Very Large Data Bases, September
3-6, 1991, Barcelona, Catalonia, Spain, Proceedings},
publisher = {Morgan Kaufmann},
year = {1991},
isbn = {1-55860-150-3},
pages = {265-274},
ee = {db/conf/vldb/FaloutsosNS91.html},
crossref = {DBLP:conf/vldb/91},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
Existent buffer allocation methods are precalculated parameters to make buffer allocation decisions. The main idea proposed here is to design an adaptable buffer allocation algorithm that will automatically optimize itself for thespecific query workload. To achieve this adaptability, we propose using run-time information, such as the load of the system, in our buffer allocation decisions. In particular, based on a simple queueing model, we use predictors to estimate whether a buffer allocation will improve the performance of the system. Simulation results show that the proposed method consistently outperforms existent algorithms.
Copyright © 1991 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 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Guy M. Lohman, Amílcar Sernadas, Rafael Camps (Eds.):
17th International Conference on Very Large Data Bases, September 3-6, 1991, Barcelona, Catalonia, Spain, Proceedings.
Morgan Kaufmann 1991, ISBN 1-55860-150-3
BibTeX
References
- [1]
- Hong-Tai Chou, David J. DeWitt:
An Evaluation of Buffer Management Strategies for Relational Database Systems.
VLDB 1985: 127-141 BibTeX
- [2]
- Stavros Christodoulakis:
Implications of Certain Assumptions in Database Performance Evaluation.
ACM Trans. Database Syst. 9(2): 163-186(1984) BibTeX
- [3]
- Douglas W. Cornell, Philip S. Yu:
Integration of Buffer Management and Query Optimization in Relational Database Environment.
VLDB 1989: 247-255 BibTeX
- [4]
- Wolfgang Effelsberg, Theo Härder:
Principles of Database Buffer Management.
ACM Trans. Database Syst. 9(4): 560-595(1984) BibTeX
- [5]
- ...
- [6]
- 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
- [7]
- Raymond T. Ng, Christos Faloutsos, Timos K. Sellis:
Flexible Buffer Allocation Based on Marginal Gains.
SIGMOD Conference 1991: 387-396 BibTeX
- [8]
- 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
- [9]
- Stephen W. Sherman, Richard S. Brice:
Performance of a Database Manager in a Virtual Memory System.
ACM Trans. Database Syst. 1(4): 317-343(1976) BibTeX
- [10]
- ...
- [11]
- S. Bing Yao:
Approximating the Number of Accesses in Database Organizations.
Commun. ACM 20(4): 260-261(1977) BibTeX
Referenced by
- Nick Roussopoulos:
Materialized Views and Data Warehouses.
SIGMOD Record 27(1): 21-26(1998)
- Yannis E. Ioannidis, Raymond T. Ng, Kyuseok Shim, Timos K. Sellis:
Parametric Query Optimization.
VLDB J. 6(2): 132-151(1997)
- Asit Dan, Philip S. Yu, Jen-Yao Chung:
Characterization of Database Access Pattern for Analytic Prediction of Buffer Hit Probability.
VLDB J. 4(1): 127-154(1995)
- Nick Roussopoulos, Chung-Min Chen, Stephen Kelley, Alex Delis, Yannis Papakonstantinou:
The ADMS Project: View R Us.
IEEE Data Eng. Bull. 18(2): 19-28(1995)
- Kun-Lung Wu, Philip S. Yu, Jen-Yao Chung, James Z. Teng:
A Performance Study of Workfile Disk Management for Concurrent Mergesorts in a Multiprocessor Database System.
VLDB 1995: 100-109
- Diane L. Davison, Goetz Graefe:
Dynamic Resource Brokering for Multi-User Query Execution.
SIGMOD Conference 1995: 281-292
- Serge Abiteboul, Richard Hull, Victor Vianu:
Foundations of Databases.
Addison-Wesley 1995, ISBN 0-201-53771-0
Contents - Theodore Johnson, Dennis Shasha:
2Q: A Low Overhead High Performance Buffer Management Replacement Algorithm.
VLDB 1994: 439-450
- Kun-Lung Wu, Philip S. Yu, James Z. Teng:
Data Placement and Buffer Management for Concurrent Mergesorts with Parallel Prefetching.
ICDE 1994: 418-427
- Goetz Graefe:
Query Evaluation Techniques for Large Databases.
ACM Comput. Surv. 25(2): 73-170(1993)
- Manish Mehta, David J. DeWitt:
Dynamic Memory Allocation for Multiple-Query Workloads.
VLDB 1993: 354-367
- Chung-Min Chen, Nick Roussopoulos:
Adaptive Database Buffer Allocation Using Query Feedback.
VLDB 1993: 342-353
- Kurt P. Brown, Michael J. Carey, Miron Livny:
Managing Memory to Meet Multiclass Workload Response Time Goals.
VLDB 1993: 328-341
- 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
- Asit Dan, Philip S. Yu, Jen-Yao Chung:
Database Access Characterization for Buffer Hit Prediction.
ICDE 1993: 134-143
- Hanxiong Chen, Jeffrey Xu Yu, Kazunori Yamaguchi, Hiroyuki Kitagawa, Nobuo Ohbo, Yuzuru Fujiwara:
LRU-S: A New Buffer Allocation Approach for OODBMS.
DASFAA 1993: 73-80
- Axel Mönkeberg, Gerhard Weikum:
Performance Evaluation of an Adaptive and Robust Load Control Method for the Avoidance of Data-Contention Thrashing.
VLDB 1992: 432-443
- Yannis E. Ioannidis, Raymond T. Ng, Kyuseok Shim, Timos K. Sellis:
Parametric Query Optimization.
VLDB 1992: 103-114
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:45:48 2009