Improving performance in a DBaaS environment through the use of resource reservation

作者: Vinicius da S. Segalin , Carina F. Dorneles , Mario A. R. Dantas

DOI: 10.1145/3151759.3151796

关键词: Running timeReservationSpace (commercial competition)Bandwidth (signal processing)Computer scienceOrder (business)Interval (mathematics)Context (language use)Resource (project management)Database

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

参考文章(21)
Eliza Gomes, Mario Antonio Ribeiro Dantas, An Advance Reservation Mechanism to Enhance Throughput in an Opportunistic High Performance Computing Environment network computing and applications. pp. 221- 228 ,(2014) , 10.1109/NCA.2014.40
David Bernstein, Containers and Cloud: From LXC to Docker to Kubernetes IEEE Cloud Computing. ,vol. 1, pp. 81- 84 ,(2014) , 10.1109/MCC.2014.51
Jennifer Ortiz, Victor Teixeira de Almeida, Magdalena Balazinska, A vision for personalized service level agreements in the cloud international conference on management of data. pp. 21- 25 ,(2013) , 10.1145/2486767.2486772
Mumtaz Ahmad, Songyun Duan, Ashraf Aboulnaga, Shivnath Babu, None, Predicting completion times of batch query workloads using interaction-aware models and simulation Proceedings of the 14th International Conference on Extending Database Technology - EDBT/ICDT '11. pp. 449- 460 ,(2011) , 10.1145/1951365.1951419
Rakebul Hasan, Fabien Gandon, A Machine Learning Approach to SPARQL Query Performance Prediction Proceedings of the 2014 IEEE/WIC/ACM International Joint Conferences on Web Intelligence (WI) and Intelligent Agent Technologies (IAT) - Volume 01. ,vol. 1, pp. 266- 273 ,(2014) , 10.1109/WI-IAT.2014.43
S.K. Pal, S. Mitra, Multilayer perceptron, fuzzy sets, and classification IEEE Transactions on Neural Networks. ,vol. 3, pp. 683- 697 ,(1992) , 10.1109/72.159058
Archana Ganapathi, Harumi Kuno, Umeshwar Dayal, Janet L Wiener, Armando Fox, Michael Jordan, David Patterson, None, Predicting Multiple Metrics for Queries: Better Decisions Enabled by Machine Learning international conference on data engineering. pp. 592- 603 ,(2009) , 10.1109/ICDE.2009.130
Wentao Wu, Yun Chi, Hakan Hacígümüş, Jeffrey F. Naughton, Towards predicting query execution time for concurrent and dynamic database workloads Proceedings of the VLDB Endowment. ,vol. 6, pp. 925- 936 ,(2013) , 10.14778/2536206.2536219
Wentao Wu, Yun Chi, Shenghuo Zhu, J. Tatemura, H. Hacigumus, J. F. Naughton, Predicting query execution time: Are optimizer cost models really unusable? international conference on data engineering. pp. 1081- 1092 ,(2013) , 10.1109/ICDE.2013.6544899