Applying dynamic buffer allocation to predictive load control

Previous works on buffer management in the database area paid little attention to the dynamic buffer allocation involving reallocation of buffers of queries while exploiting the known access patterns of the database operations. This paper proposes a new buffer allocation technique to improve the system´s global performance. The main idea is to maximize the effectiveness of the buffer allocation. For this end, the less-utilized buffers of queries are partially preempted and reallocated to the other queries which can utilize them more effectively. The proposed technique reduces the waiting time portion of query processing through the flexible buffer allocation. The simulation results show that the proposed technique performs better than the conventional ones