Title :
Autonomic Index Management
Author :
Lifschitz, Sérgio ; Salles, Marcos Antonio Vaz
Author_Institution :
Departamento de Informatica, Pontificia Univ. Catolica do Rio de Janeiro
Abstract :
This work presents the core ideas for an approach that enables index tuning with no human intervention at all. SQL statements submitted to the database are monitored and indices are created or dropped according to the benefits or overheads regarding the actual workload. We have implemented this strategy using a software agent architecture embedded in PostgreSQL. We discuss here some of the architecture core ideas and present initial experimental results
Keywords :
SQL; database indexing; embedded systems; software agents; software architecture; PostgreSQL; SQL statement monitoring; autonomic index management; database; embedded system; index tuning; software agent architecture; Application software; Computer architecture; Databases; Hardware; Humans; Indexes; Information retrieval; Monitoring; Software agents; Tuning;
Conference_Titel :
Autonomic Computing, 2005. ICAC 2005. Proceedings. Second International Conference on
Conference_Location :
Seattle, WA
Print_ISBN :
0-7965-2276-9
DOI :
10.1109/ICAC.2005.13
