loading...
Goal-oriented dynamic buffer pool management for data base systems
Ft. Lauderdale, Florida November 06-November 10
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICECCS.1995.479328First IEEE International Conference o ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
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
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.
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, pp.191, First IEEE International Conference on Engineering of Complex Computer Systems (ICECCS'95), 1995
Usage of this product signifies your acceptance of the Terms of Use.


Suggestions