Policy-Based Coordination of Best-Practice Oriented Autonomic Database Tuning

In the last decades databases have been growing rapidly in scale and complexity. High performance, availability and further service level agreements need to be satisfied under any circumstances to please customers. Achieved database management system’s (DBMS) performance highly depends on individual skills of expensive database administrators (DBAs) who need to have deep knowledge about the DBMS itself, the application stack on top of the DBMS, and the application domain in general. Our goal, therefore, is to develop a framework enabling administrators to formalize and exchange their tuning knowledge in a community and let the system act autonomously according to this knowledge. This contribution proposes a Tuning Policy Language and gives an insight into the underlying policy model. This model is a basis for a tuning coordination component that is responsible for an advanced tuning control and provides an interface for the administrator.