Analysis of distributed database access histories for buffer allocation

This paper studies the buffer size setting problem for distributed databased systems. The main goal is to minimize physical I/O while achieving better buffer utilization at the same time. Different from the traditional buffer management strategies where limited knowledge of user access patterns is analyzed and used, our buffer allocation mechanism extracts knowledge from historical reference streams, and then determines the optimal buffer space based on the discovered knowledge. Simulation experiments show that the proposed method can achieve an optimal buffer allocation solution for distributed database systems.