Title
Using economic models to capture importance policy for tuning in autonomic database management systems.
Abstract
A key advantage of autonomic database management systems will be their ability to manage according to business policies. Translating high-level business policies into low-level tuning actions and parameters is, however, a non-trivial problem as there is little similarity in the metrics used for measuring database performance and business performance. These translations can be simplified, however, by having a model that reflects the business policies. In this paper, we utilise an economic model to implement importance policy as a parameter for the allocation of system resources. The relative importance of the workloads can therefore be utilised in allocating system resources, such as main memory for buffer space and shares of the CPU. We simulate the model in order to demonstrate the effectiveness of the approach. We present experiments to show the impact of the relative importance of workloads on the allocation of resources, specifically buffer area and CPU.
Year
Venue
Field
2016
Int. J. Auton. Comp.
Autonomic computing,Central processing unit,Database tuning,Economic model,Computer science,Policy-based management,Workload,Resource allocation,Systems management,Database
DocType
Volume
Issue
Journal
2
2
Citations 
PageRank 
References 
0
0.34
0
Authors
6
Name
Order
Citations
PageRank
Harley Boughton1141.07
Mingyi Zhang283.83
Wendy Powley332928.43
patrick martin414818.22
Paul Bird51198.78
Randy Horman6724.77