|
Published Articles >> Table of Contents >> Abstract
First IEEE International Conference on Engineering of Complex Computer Systems (ICECCS'95)
p. 191
Goal-oriented dynamic buffer pool management for data base systems
Jen-Yao Chwng, IBM Thomas J. Watson Res. Center, Yorktown Heights, NY, USA
D. Ferguson, IBM Thomas J. Watson Res. Center, Yorktown Heights, NY, USA
G. Wang, IBM Thomas J. Watson Res. Center, Yorktown Heights, NY, USA
C. Nikolaou, IBM Thomas J. Watson Res. Center, Yorktown Heights, NY, USA
J. Teng, IBM Thomas J. Watson Res. Center, Yorktown Heights, NY, USA
Full Article Text:
  
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICECCS.1995.479328
Send link to a friend
| Abstract |
|
The paper presents a technique for performing dynamic goal-oriented buffer pool management for database management systems. To dynamically adjust the buffer pool sizes for the multiple buffer pools provided by database management systems is a complex constrained optimization problem. In the goal-oriented approach, the user specifies each buffer pool's random access response time goal and the total available number of buffers for all buffer pools. The problem is to dynamically expand or contract the buffer pool sizes based on the database workload to achieve these pre-defined response time goals for each buffer pool while maintaining the same total number of buffers in the database system. Our goal satisfaction algorithm monitors goal satisfaction of each buffer pool and periodically changes buffer pool sizes to improve goal satisfaction. The expansion and contraction process does not allocate new or free up existing virtual storage. We demonstrate that dynamic tuning can greatly improve buffer pool goal satisfaction through trace driven simulations.
|
 Additional Information
|
Index Terms- relational databases; buffer storage; optimisation; transaction processing; storage management; goal-oriented dynamic buffer pool management; database management systems; dynamic buffer pool size adjustment; multiple buffer pools; complex constrained optimization problem; random access response time goal; database workload; pre-defined response time goals; goal satisfaction algorithm; virtual storage; dynamic tuning; trace driven simulations
Citation:
Jen-Yao Chwng, D. Ferguson, G. Wang, C. Nikolaou, J. Teng,
"Goal-oriented dynamic buffer pool management for data base systems,"
iceccs,
p. 191,
First IEEE International Conference on Engineering of Complex Computer Systems (ICECCS'95),
1995
|
|
