Towards Autonomic Index Maintenance

Marcos Antonio Vaz SallesEduardo Terra MorelliSérgio Lifschitz

Automatic index selection has received significant attention in the autonomic computing field. Previous works have focused on providing tools and algorithms to help the DBA in the choice of indices for a given static workload. We present an approach for indexing management that works for workloads that may dynamically change with no human intervention at all. We automatically monitor statements submitted to the database with a built-in component, that interacts directly with the DBMS, creating and dropping indices on-the-fley. This paper presents a mechanism to integrate automatic index management com- ponents in relational databases. We discuss the heuristics considered and the observed experimental results for a PostgreSQL implementation.

Caso o link acima esteja inválido, faça uma busca pelo texto completo na Web: Buscar na Web

Biblioteca Digital Brasileira de Computação - Contato:
     Mantida por: