DocumentCode
1816413
Title
Autonomic Index Management
Author
Lifschitz, Sérgio ; Salles, Marcos Antonio Vaz
Author_Institution
Departamento de Informatica, Pontificia Univ. Catolica do Rio de Janeiro
fYear
2005
fDate
13-16 June 2005
Firstpage
304
Lastpage
305
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Autonomic Computing, 2005. ICAC 2005. Proceedings. Second International Conference on
Conference_Location
Seattle, WA
Print_ISBN
0-7965-2276-9
Type
conf
DOI
10.1109/ICAC.2005.13
Filename
1498075
Link To Document