Implementation of an Agent Architecture for Automated Index Tuning

Authors:
Rogerio Luis de Carvalho Costa;Sergio Lifschitz;Maira Ferreira de Noronha;Marcos Antonio Vaz Salles
Affiliations:
Pontificia Universidade Catolica do Rio de Janeiro (PUC-Rio) - Brazil;Pontificia Universidade Catolica do Rio de Janeiro (PUC-Rio) - Brazil;Pontificia Universidade Catolica do Rio de Janeiro (PUC-Rio) - Brazil;Pontificia Universidade Catolica do Rio de Janeiro (PUC-Rio) - Brazil
Venue:
ICDEW '05 Proceedings of the 21st International Conference on Data Engineering Workshops
Year:
2005

Citing 0
Cited 2

Lightweight Data Mining Based Database System Self-optimization: A Case Study

APWeb/WAIM '09 Proceedings of the Joint International Conferences on Advances in Data and Web Management
Autonomous re-indexing

Proceedings of the 27th Annual ACM Symposium on Applied Computing

Quantified Score

Hi-index	0.00

Visualization

Abstract

It has been important to extend database management systems to support new requirements of applications and administration. We focus in this paper on the automatic tuning feature, particularly manipulation of indexes. The architectural approach considered here is based on software agents. We briefly present the heuristics involved in the decision upon creation, dropping and the exact moment to proceed with either action. Then we discuss our agentbased database architecture, with its layers and coupling within an actual DBMS. Finally, we explain the way our hypothetical indexes are integrated in PostgreSQL and how they can be used in practice for automated index tuning.