Journal of Computer and Communications

Volume 4, Issue 5 (May 2016)

ISSN Print: 2327-5219   ISSN Online: 2327-5227

Google-based Impact Factor: 1.12  Citations  

Automated Performance Tuning of Data Management Systems with Materializations and Indices

HTML  XML Download Download as PDF (Size: 261KB)  PP. 46-52  
DOI: 10.4236/jcc.2016.45007    1,695 Downloads   3,513 Views  Citations

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.

 

Share and Cite:

Noon, N. and Getta, J. (2016) Automated Performance Tuning of Data Management Systems with Materializations and Indices. Journal of Computer and Communications, 4, 46-52. doi: 10.4236/jcc.2016.45007.

Copyright © 2024 by authors and Scientific Research Publishing Inc.

Creative Commons License

This work and the related PDF file are licensed under a Creative Commons Attribution 4.0 International License.