Simulating DB2 buffer pool management

Authors:
Wenguang Wang;Richard B. Bunt
Affiliations:
Department of Computer Science, University of Saskatchewan, 57 Campus Drive, Saskatoon, SK S7N 5A9, Canada;Department of Computer Science, University of Saskatchewan, 57 Campus Drive, Saskatoon, SK S7N 5A9, Canada
Venue:
CASCON '00 Proceedings of the 2000 conference of the Centre for Advanced Studies on Collaborative research
Year:
2000

Citing 5
Cited 1

Logical, internal, and physical reference behavior in CODASYL database systems

ACM Transactions on Database Systems (TODS)
Principles of database buffer management

ACM Transactions on Database Systems (TODS)
Diversity in database reference behavior

SIGMETRICS '89 Proceedings of the 1989 ACM SIGMETRICS international conference on Measurement and modeling of computer systems
The working set model for program behavior

Communications of the ACM
Flexible and Adaptable Buffer Management Techniques for Database Management Systems

IEEE Transactions on Computers

An analytical model for buffer hit rate prediction

CASCON '01 Proceedings of the 2001 conference of the Centre for Advanced Studies on Collaborative research

Quantified Score

Hi-index	0.00

Visualization

Abstract

Storage management is an important part of any DBMS. The buffer pool in DB2 is used to cache the disk pages of the database, and its management algorithm can significantly affect performance. In order to investigate performance issues relating to the buffer pool management algorithm, a trace of buffer pool requests was collected and a trace-driven simulator was developed so that the impact of various parameters of the buffer pool management algorithm could be investigated under controlled circumstances. Relationships among different activities competing for storage space and the I/O channel are examined, and some issues affecting performance are identified.