Study of database buffer management approaches: Towards the development of a data mining based strategy

Ling Feng,Hongjun Lu,Allan Wong
DOI: https://doi.org/10.1109/ICSMC.1998.725071
1998-01-01
Abstract:The problem of buffer management in database systems is concerned with efficient main memory allocation and replacement for answering database queries. The goal is to reduce disk operations and enhance the system throughput by utilizing a dedicated buffer pool for caching database pages. Buffer management problems have been extensively studied, and this paper provides an in-depth study of current buffer management techniques for database systems. Through surveying existing work, we propose a data mining based approach to buffer management. Different from previous approaches where limited knowledge of user access patterns is used, the proposed approach discovers knowledge from database access sequences and uses it to guide buffer management. To assess the performance of the proposed approach, we have constructed a simulation model and conducted a series of experiments. The results show that with the help of the discovered knowledge, the buffer hit ratio can be improved significantly, about 69% achievement in the best case.
What problem does this paper attempt to address?