Name
Abstract | ||
|---|---|---|
The tasks of configuring and tuning large database management systems (DBMSs) have always been both complex and time-consuming. They require knowledge of the characteristics of the system, the data, and the workload, and of the interrelationships between them. The buffer pools, because they exist to reduce the number of disk accesses performed by a transaction, are a key resource in a DBMS. Current DBMSs, such as DB2 Universal Database, divide the buffer area into a number of independent buffer pools and database objects (tables and indices) are assigned to a specific buffer pool. The size of each buffer pool is set by configuration parameters and page replacement is local to each buffer pool. Tuning the size of the buffer pools to a workload is crucial to achieving good performance. In this paper we describe a self-tuning algorithm, called the Dynamic Reconfiguration algorithm (DRF), for managing the buffer pools in a DBMS and we present the results of a set of experiments to investigate the performance of an implementation of the algorithm for DB2 Universal Database. |
Year | DOI | Venue |
|---|---|---|
2000 | 10.1007/3-540-44469-6_9 | DEXA |
Keywords | Field | DocType |
database object,buffer pool,dynamic reconfiguration algorithm,dynamically tuning multiple buffer,self-tuning algorithm,independent buffer pool,good performance,specific buffer pool,buffer area,db2 universal database,current dbmss,database management system | Information system,Workload,Computer science,Database transaction,Database,Reconfiguration algorithm,Distributed computing | Conference |
ISBN | Citations | PageRank |
3-540-67978-2 | 11 | 0.91 |
References | Authors | |
6 | 5 | |
Name | Order | Citations | PageRank |
|---|---|---|---|
| patrick martin | 1 | 148 | 18.22 |
| Hoi-ying Li | 2 | 21 | 1.67 |
| Min Zheng | 3 | 46 | 5.31 |
| Keri Romanufa | 4 | 74 | 4.28 |
| Wendy Powley | 5 | 329 | 28.43 |