WCSE

Using Periodic Patterns for Dynamic Estimation of Future Database Workloads

Abstract— Analysis of historical database workloads can be used to improve the future performance of database systems. This work investigates a problem how to use information about periodic processing of database applications recorded in the past for static and dynamic estimation of the future database workloads. The new concepts of anchor events and event expressions are used to create the mappings of past periodic patterns in data processing into the future database workloads. We show that event expressions allow for both static and dynamic estimation of future database workloads. The paper presents the algorithms for static a dynamic estimation of future database workloads from information about time distributions of periodic processing of database applications and information about the events that trigger processing of the applications.

Index Terms— mining periodic patterns, database workloads, automated performance tuning process mining.

Janusz R. Getta
School of Computing and Information Technology, University of Wollongong, AUSTRALIA
Marcin Zimniak
Faculty of Computer Science, TU Chemnitz, GERMANY

[Download]

Cite: Janusz R. Getta, Marcin Zimniak, "Using Periodic Patterns for Dynamic Estimation of Future Database Workloads," Proceedings of 2016 6th International Workshop on Computer Science and Engineering, pp. 79-87, Tokyo, 17-19 June, 2016.