Available from: psu.edu
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.
Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative Research, September 30 - October 3, 2002, Toronto, Ontario, Canada; 01/2002