A modeling study of the TPC-C benchmark
SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
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: concepts and techniques
Data mining: concepts and techniques
DB 2: High Performance Design and Tuning
DB 2: High Performance Design and Tuning
Characterization of database access pattern for analytic prediction of buffer hit probability
The VLDB Journal — The International Journal on Very Large Data Bases
Performance Analysis of Affinity Clustering on Transaction Processing Coupling Architecture
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
Automated Selection of Materialized Views and Indexes in SQL Databases
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
Configuring buffer pools in DB2 UDB
CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
Managing Distributed Memory to Meet Multiclass Workload Response Time Goals
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
Goal-oriented dynamic buffer pool management for data base systems
ICECCS '95 Proceedings of the 1st International Conference on Engineering of Complex Computer Systems
Configuring buffer pools in DB2 UDB
CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
Techniques for automatically sizing multiple buffer pools in DB2
CASCON '03 Proceedings of the 2003 conference of the Centre for Advanced Studies on Collaborative research
| Hi-index | 0.00 |
Database Management Systems (DBMSs) use a main memory area as a buffer to reduce the number of disk accesses performed by a transaction. DB2 Universal Database 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. The tasks of configuring the buffer pools, which defines the mapping of database objects to buffer pools and setting a size for each of the buffer pools, is crucial for achieving optimal performance.Mapping database objects to buffer pools, which we refer to as the "buffer pool configuration problem", is the focus of this paper. Mapping database objects to buffer pools can be viewed as a partitioning problem, that is, we partition the database objects into groups where each group is assigned a separate buffer pool. The partitioning of objects is based on how the objects are used and on the inherent properties of objects. We present an approach to the configuration problem based on analyzing the access behaviour of a given database workload to the set of database objects. The approach is demonstrated with a typical OLTP workload.