The storage system for a multimedia data manager kernel
MetadataShow full item record
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 prefetching. However, depending on the resource being used (file, disk partition, memory, etc.), the way prefetching is done might be different or even not necessary, forcing a DBMS to be aware of the underlying Storage System. In this paper we 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. We have implemented a file resource that recognizes and exploits sequential access patterns that emerge over time to prefetch adjacent blocks to the requested ones. Our approach is speculative because it considers past accesses, but it also considers hints from the upper layers of the DBMS, which must specify the access context in which a read operation takes place. The informed access context is then mapped to one of the available channels in the file resource, which is equipped with a set of internal buffers, one per channel, for the management of fetched and prefetched data. Prefetched data are moved to the main cache of the DBMS only if really requested by the application, which helps to avoid cache pollution. So, we slightly introduced a two level cache hierarchy without any intervention of the DBMS kernel. We ran the tests with different buffer settings and compared the results against the OBL policy, which showed that it is possible to get a read time up to two times faster in a highly concurrent environment without sacrificing the performance when the system is not under intensive workloads.
How to cite this document
Showing items related by title, author, creator and subject.
Pinho, Sheila Zambello de ; Oliveira, José Brás Barreto de ; Gazola, Rodrigo José Cristiano ; Mazotti, Adriano César ; Molero, Camila Schimite ; Mendes, Carolina Borghi ; Mello, Denise Fernandes de ; Marques, Emilia de Mendonça Rosa ; Talamoni, Jandira Liria Biscalquini ; Silva, José Humberto Dias da et al. (Coleção PROGRAD (UNESP), 2011) [Livro]
Pinho, Sheila Zambello de ; Oliveira, José Brás Barreto de ; Pontes, Sueli Rodrigues ; Almeida, Djanira Soares de Oliveira e ; Godoy, Kathya Maria Ayres de ; Rosa, Claudia de Souza ; Nunes, Julianus Araújo ; Salvador, Sérgio Azevedo ; David, Célia Maria ; Vilche Peña, Angel Fidel et al. (Coleção PROGRAD (UNESP), 2011) [Livro]
Pinho, Sheila Zambello de ; Spazziani, Maria de Lourdes ; Mendonça, Sueli Guadelupe de Lima ; Rubo, Elisabete Aparecida Andrello ; Villarreal, Dalva Maria de Oliveira ; Duarte, Camila ; Okamoto, Mary Yoko ; Souza, Thais R. ; Garms, Gilza Maria Zauhy ; Marin, Fátima Aparecida Dias Gomes et al. (Coleção PROGRAD (UNESP), 2012) [Livro]