An evaluation of buffer management strategies for relational database systems

In this paper we present a new algorithm, DBMIN, for managing the buffer pool of a relational database management system. DBMIN is based on a new model of relational query behavior, thequery locality set model (QLSM). Like the hot set model, the QLSM has an advantage over the stochastic models due to its ability to predict future reference behavior. However, the QLSM avoids the potential problems of the hot set model by separating the modeling of reference behavior from any particular buffer management algorithm. After introducing the QLSM and describing the DBMIN algorithm, we present a performance evaluation methodology for evaluating buffer management algorithms in a multiuser environment. This methodology employed a hybrid model that combines features of both trace-driven and distribution-driven simulation models. Using this model, the performance of the DBMIN algorithm in a multiuser environment is compared with that of the hot set algorithm and four more traditional buffer replacement algorithms.

[1]  Wesley W. Chu,et al.  Performance of the Page Fault Frequency Replacement Algorithm in a Multiprogramming Environment , 1974, IFIP Congress.

[2]  Giovanni Maria Sacco,et al.  Buffer management in relational database systems , 1986, TODS.

[3]  David J. DeWitt,et al.  Design and implementation of the wisconsin storage system , 1985, Softw. Pract. Exp..

[4]  William G. Tuel.  An Analysis of Buffer Paging in Virtual Storage Systems , 1976, IBM J. Res. Dev..

[5]  A. Palmboom,et al.  Analysis of Demand Paging Algorithms , 1972, GI Jahrestagung.

[6]  Tomás Lang,et al.  Effect of Replacement Algorithms on a Paged Buffer Database System , 1978, IBM J. Res. Dev..

[7]  Michael Stonebraker,et al.  The design and implementation of INGRES , 1976, TODS.

[8]  Wolfgang Effelsberg,et al.  Principles of database buffer management , 1984, TODS.

[9]  Michael Stonebraker,et al.  Operating system support for database management , 1981, CACM.

[10]  J. David Irwin,et al.  An Adaptive Replacement Algorithm for Paged-Memory Computer Systems , 1972, IEEE Transactions on Computers.

[11]  Peter J. Denning,et al.  Optimal multiprogramming , 2004, Acta Informatica.

[12]  M. W. Blasgen,et al.  Storage and Access in Relational Data Bases , 1977, IBM Syst. J..

[13]  Peter J. Denning,et al.  The working set model for program behavior , 1968, CACM.

[14]  E. Gelenbe.  B73-10 Time Sharing Systems , 1973, IEEE Transactions on Computers.

[15]  Setsuo Ohsuga,et al.  INTERNATIONAL CONFERENCE ON VERY LARGE DATA BASES , 1977 .

[16]  David J. DeWitt,et al.  The Crystal Multicomputer: Design and Implementation Experience , 1987, IEEE Transactions on Software Engineering.

[17]  Stephen W. Sherman,et al.  Performance of a database manager in a virtual memory system , 1976, TODS.

[18]  Robert G. Sargent,et al.  Statistical analysis of simulation output data , 1976, SIML.

[19]  Tomás Lang,et al.  Database buffer paging in virtual storage systems , 1977, TODS.

[20]  Michael Stonebraker,et al.  Performance enhancements to a relational database system , 1983, TODS.

[21]  David J. DeWitt,et al.  Benchmarking Database Systems A Systematic Approach , 1983, VLDB.

[22]  Irving L. Traiger,et al.  System R: relational approach to database management , 1976, TODS.

[23]  Erol Gelenbe,et al.  A Unified Approach to the Evaluation of a Class of Replacement Algorithms , 1973, IEEE Transactions on Computers.

[24]  Allen Reiter.  A Study of Buffer Management Policies for Data Management Systems. , 1976 .

[25]  Irving L. Traiger,et al.  System R: A Relational Approach to Data Base Management , 1976, Berkeley Workshop.

[26]  S. B. Yao,et al.  Approximating block accesses in database organizations , 1977, CACM.

[27]  Marc H. Fogel,et al.  The VMOS paging algorithm: a practical implementation of the working set model , 1974, OPSR.

[28]  Stephen W. Sherman,et al.  I/O buffer performance in a virtual memory system , 1976, ANSS '76.

[29]  David J. DeWitt,et al.  A methodology for database system performance evaluation , 1984, SIGMOD '84.

[30]  Giovanni Maria Sacco,et al.  A Mechanism for Managing the Buffer Pool in a Relational Database System Using the Hot Set Model , 1982, VLDB.