By Topic

Goal-oriented dynamic buffer pool management for data base systems

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$33 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

5 Author(s)
Jen-Yao Chwng ; IBM Thomas J. Watson Res. Center, Yorktown Heights, NY, USA ; D. Ferguson ; G. Wang ; C. Nikolaou
more authors

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

Published in:

Engineering of Complex Computer Systems, 1995. Held jointly with 5th CSESAW, 3rd IEEE RTAW and 20th IFAC/IFIP WRTP, Proceedings., First IEEE International Conference on

Date of Conference:

6-10 Nov 1995