Sciweavers

Share
ICDE
2007
IEEE

Improved Buffer Size Adaptation through Cache/Controller Coupling

11 years 6 months ago
Improved Buffer Size Adaptation through Cache/Controller Coupling
Database workloads seldom remain static. A system tuned by an expert for the current environment, might not always remain optimal. To deal with this situation, database systems have been incorporating self tuning features. An important component is self tuning memory or bufferpools. These often work on a feedback loop and take some time to converge to an optimal state. The transition to the optimal state could be accelerated if future access patterns could be taken into account when making decisions on the bufferpool size. In this paper, we describe a caching algorithm for scans on bufferpools, which keeps track of ongoing scans and the state of each scan. The proposed algorithm results in a better hit ratio and, more importantly, provides a way to predict future access patterns. This property is beneficial for providing feedback to a self-tuning memory controller to make better allocation decisions.
Christian A. Lang, Bishwaranjan Bhattacharjee, Tim
Added 03 Jun 2010
Updated 03 Jun 2010
Type Conference
Year 2007
Where ICDE
Authors Christian A. Lang, Bishwaranjan Bhattacharjee, Timothy Malkemus, Ioana Stanoi
Comments (0)
books