TITLE:
Automated Performance Tuning of Data Management Systems with Materializations and Indices
AUTHORS:
Nan N. Noon, Janusz R. Getta
KEYWORDS:
Automated Performance Tuning, Query Processing, Materialization, Indexing, Data Management Systems
JOURNAL NAME:
Journal of Computer and Communications,
Vol.4 No.5,
May
26,
2016
ABSTRACT: Automated
performance tuning of data management systems offer various benefits such as improved
performance, declined administration costs, and reduced workloads to database
administrators (DBAs). Currently, DBAs tune the performance of database systems
with a little help from the database servers. In this paper, we propose a new
technique for automated performance tuning of data management systems. Firstly,
we show how to use the periods of low workload time for performance
improvements in the periods of high workload time. We demonstrate that extensions
of a database system with materialised views and indices when a workload is low
may contribute to better performance for a successive period of high workload.
The paper proposes several online algorithms for continuous processing of
estimated database workloads and for the discovery of the best plan for
materialised view and index database extensions and of elimination of the
extensions that are no longer needed. We present the results of experiments
that show how the proposed automated performance tuning technique improves the
overall performance of a data management system.