Name
Abstract | ||
|---|---|---|
Database management systems (DBMSs) use a main memory area as a buffer to reduce the number of disk accesses performed by a transaction. Some DBMSs divide 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 define the mapping of database objects to buffer pools and setting a size for each of the buffer pools, are crucial for achieving optimal performance. In this paper we describe an automated approach to multiple buffer pool configuration. Our approach, called BPCluster, analyses the characteristics of a given workload and partitions objects into buffer pools according to their access patterns and inherent characteristics. Similar objects are grouped into the same buffer pool, thus separating those objects that may conflict. A size configuration for the multiple buffer pools is determined using a greedy algorithm that attempts to minimize the cost of a logical read. A set of experimental results validate the approach and show that the configurations suggested by BPCluster outperform naïve configurations and, in most cases, perform as well as configurations suggested by an experienced database administrator. |
Year | DOI | Venue |
|---|---|---|
2006 | 10.1093/comjnl/bxl028 | Comput. J. |
Keywords | Field | DocType |
buffer pool,main memory area,automated configuration,multiple buffer pools,performance tuning,buffer area,database,multiple buffer pool configuration,automated approach,database object,automatic configuration,independent buffer pool,multiple buffer pool,specific buffer pool,experienced database administrator,database management system,indexation,greedy algorithm | Computer science,Workload,Circular buffer,Greedy algorithm,Database administrator,Database transaction,Performance tuning,Distributed computing | Journal |
Volume | Issue | ISSN |
49 | 4 | 0010-4620 |
Citations | PageRank | References |
3 | 0.42 | 16 |
Authors | ||
4 | ||
Name | Order | Citations | PageRank |
|---|---|---|---|
| patrick martin | 1 | 148 | 18.22 |
| Wendy Powley | 2 | 329 | 28.43 |
| Xiaoyi Xu | 3 | 18 | 2.32 |
| Wenhu Tian | 4 | 22 | 2.42 |