Autonomous re-indexing

Authors:
Eduardo Morelli;Ana Almeida;Sérgio Lifschitz;José Maria Monteiro;Javam Machado
Affiliations:
PUC-Rio, Rio de Janeiro, Brazil;PUC-Rio, Rio de Janeiro, Brazil;PUC-Rio, Rio de Janeiro, Brazil;UFC, Fortaleza, Brazil;UFC, Fortaleza, Brazil
Venue:
Proceedings of the 27th Annual ACM Symposium on Applied Computing
Year:
2012

Citing 8
Cited 0

Database tuning: principles, experiments, and troubleshooting techniques

Database tuning: principles, experiments, and troubleshooting techniques
Autonomous Query-Driven Index Tuning

IDEAS '04 Proceedings of the International Database Engineering and Applications Symposium
Automatic physical database tuning: a relaxation-based approach

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Autonomic Index Management

ICAC '05 Proceedings of the Second International Conference on Automatic Computing
COLT: continuous on-line tuning

Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Implementation of an Agent Architecture for Automated Index Tuning

ICDEW '05 Proceedings of the 21st International Conference on Data Engineering Workshops
DB2 design advisor: integrated automatic physical database design

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Autonomous Management of Soft Indexes

ICDEW '07 Proceedings of the 2007 IEEE 23rd International Conference on Data Engineering Workshop

Quantified Score

Hi-index	0.00

Visualization

Abstract

This work proposes a solution for the problem of dealing, in an autonomous way, with fragmented indexes within relational DBMS. We propose monitoring the current state of existing indexes and, if they become fragmented but still useful, rebuild them automatically. Our approach is based on adhoc heuristics that have been implemented in the Post-greSQL DBMS. Practical tests are presented to show the applicability and effectiveness of our approach.