Federal University of Sao Carlos
One way to boost the performance of a DataBase Management System (DBMS) is by fetching data in advance of their use, a technique known as pre-fetching. However, depending on the resource being used (file, disk partition, memory, etc.), the way pre-fetching is done might be different or even not necessary, forcing a DBMS to be aware of the underlying storage system. In this paper the authors propose a storage system that frees the DBMS of this task by exposing the database through a unique interface, no matter what kind of resource hosts it. They have implemented a file resource that recognizes and exploits sequential access patterns that emerge over time to pre-fetch adjacent blocks to the requested ones.