Principles of database buffer management
ACM Transactions on Database Systems (TODS)
The LRU-K page replacement algorithm for database disk buffering
SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
The COMFORT automatic tuning project
Information Systems
Goal-oriented buffer management revisited
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
The Asilomar report on database research
ACM SIGMOD Record
Data Mining: An Overview from a Database Perspective
IEEE Transactions on Knowledge and Data Engineering
Database Access Characterization for Buffer Hit Prediction
Proceedings of the Ninth International Conference on Data Engineering
Rethinking Database System Architecture: Towards a Self-Tuning RISC-Style Database System
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Managing Memory to Meet Multiclass Workload Response Time Goals
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
A Mechanism for Managing the Buffer Pool in a Relational Database System Using the Hot Set Model
VLDB '82 Proceedings of the 8th International Conference on Very Large Data Bases
Configuring buffer pools in DB2 UDB
CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
Goal-oriented dynamic buffer pool management for data base systems
ICECCS '95 Proceedings of the 1st International Conference on Engineering of Complex Computer Systems
SMART: making DB2 (more) autonomic
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
A study of replacement algorithms for a virtual-storage computer
IBM Systems Journal
Adaptive self-tuning memory in DB2
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more
A new approach to dynamic self-tuning of database buffers
ACM Transactions on Storage (TOS)
| Hi-index | 0.00 |
DB2 Universal Database (DB2/UDB) divides the buffer area into a number of independent buffer pools and each database object (table or index) is assigned to a specific buffer pool. Buffer pool sizing, which sets an appropriate size for each of the buffer pools is crucial for achieving optimal performance.In this paper, we investigate the buffer pool sizing problem. Two cost models, which are based on page fault and data access time, are examined. A greedy algorithm is proposed to search for the optimal solution. We study the effectiveness of the above techniques using experiments with the TPC-C benchmark database. The results show that the data access time based cost model is more effective for optimizing the buffer pool sizes than the page fault based cost model.