Using economic models to capture importance policy for tuning in autonomic database management systems
by Harley Boughton; Mingyi Zhang; Wendy Powley; Patrick Martin; Paul Bird; Randy Horman
International Journal of Autonomic Computing (IJAC), Vol. 2, No. 2, 2016

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.

Online publication date: Tue, 31-Jan-2017

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Autonomic Computing (IJAC):
Login with your Inderscience username and password:

    Username:        Password:         

Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email