Autonomic Computing, International Conference on (2005)
June 13, 2005 to June 16, 2005
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICAC.2005.13
S?rgio Lifschitz , Pontif?cia Universidade Catolica do Rio de Janeiro
Marcos Antonio Vaz Salles , Pontif?cia Universidade Catolica do Rio de Janeiro
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.
M. A. Vaz Salles and S. Lifschitz, "Autonomic Index Management," Autonomic Computing, International Conference on(ICAC), Seattle, Washington, 2005, pp. 304-305.