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.
This research is supported by IBM Canada Ltd., NSERC (National Science and Engineering Research Council) and CITO (Communications and Information Technology Ontario).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
L. Belady. A Study of Replacement Algorithms for a Virtual-Storage Computer, IBM Systems Journal 5(2), July 1966.
K. Brown, M. Carey and M. Livny. Managing Memory to Meet Multiclass Workload Response Time Goals, Proc. of 19 th Int. Conf. on Very Large Databases, Dublin, August 1993, pp. 328–341.
K. Brown, M. Carey and M. Livny. Goal-Oriented Buffer Management Revisited, Proc. of the 1996 ACM SIGMOD Int. Conf. on Management of Data, Montreal, June 1996, pp. 353–364.
J.-Y. Chung, D. Ferguson, G. Wang, C. Nikolaou and J. Teng. Goal-oriented dynamic buffer pool management for data base systems, Proc. of Int. Conf. on Engineering of Complex Systems (ICECCS’95), November 1995.
IBM. DB2 Universal Database, http://www.software.ibm.com/data/db2/udb.
E. Isaacson and H. Keller. Analysis of Numerical Methods, John Wiley and Sons Inc., New York, 1966.
S.T. Leutenegger and D. Dias. A Modeling Study of the TPC-C Benchmark, Proc. of the 1993 ACM SIGMOD International Conference on Management of Data, Washington D.C., 1993, pp. 22–31.
C. Nikolaou, D. Ferguson and P. Constantopoulos. Towards Goal-Oriented Resource Management, IBM Research Report RC17019, April 1992.
Transaction Processing Performance Council, http://www.tpc.org.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Martin, P., Li, HY., Zheng, M., Romanufa, K., Powley, W. (2000). Dynamic Reconfiguration Algorithm: Dynamically Tuning Multiple Buffer Pools. In: Ibrahim, M., Küng, J., Revell, N. (eds) Database and Expert Systems Applications. DEXA 2000. Lecture Notes in Computer Science, vol 1873. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44469-6_9
Download citation
DOI: https://doi.org/10.1007/3-540-44469-6_9
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67978-3
Online ISBN: 978-3-540-44469-5
eBook Packages: Springer Book Archive