Paper Info
Title
Improving Performance In A Dbaas Environment Through The Use Of Resource Reservation
Abstract
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.
Year
DOI
Venue
2017
10.1145/3151759.3151796
19TH INTERNATIONAL CONFERENCE ON INFORMATION INTEGRATION AND WEB-BASED APPLICATIONS & SERVICES (IIWAS2017)
Keywords
Field
DocType
Resource reservation, Query prediction, Machine Learning, PostgreSQL
Reservation,Computer science,Bandwidth (signal processing),Database
Conference
Citations 
PageRank 
References 
0
0.34
16
Authors
3
Name
Order
Citations
PageRank
Vinicius da S. Segalin100.34
Carina F. Dorneles26110.35
Mario A. R. Dantas36925.60