Improving Performance in a DBaaS Environment through the use of Resource Reservation

Resource reservation provides a user with the requested resource (usually, CPU, memory, space in disk and bandwidth) at the requested time, allowing the user to have the expected performance in a defined time interval. In the context of databases systems, applications with long running time queries represent a big challenge when there is a requirement to know approximately how long a query will take to execute. This is a prediction that might be relevant for several reasons. For instance, by knowing that a query will take longer than expect to execute, resource reservation can be performed, which means reserving more resources in order to execute this query in a shorter time in a future execution. This paper presents an approach that conceives an advance reservation mechanism in a DBaaS environment using machine learning techniques. In a general way, the proposal is to use a prediction mechanism based on machine learning to give the user a resource recommendation regarding time and cost. In this paper, we present the proposed model, the machine learning configuration, as well as some experiments to indicate benefits and efficiency from our proposal.