Authors:
Tansel Dökeroğlu
1
;
S. Alper Sert
1
;
M. Serkan Çinar
2
and
A. Coşar
1
Affiliations:
1
Middle East Technical University, Turkey
;
2
Hacettepe University, Turkey
Keyword(s):
Cloud, Multiobjective Data Warehouse Design, Virtualization, Elasticity.
Related
Ontology
Subjects/Areas/Topics:
Agents
;
Artificial Intelligence
;
Artificial Intelligence and Decision Support Systems
;
Cloud Computing
;
Computational Intelligence
;
Data Engineering
;
Databases and Data Security
;
Enterprise Information Systems
;
Evolutionary Computing
;
Informatics in Control, Automation and Robotics
;
Intelligent Control Systems and Optimization
;
Soft Computing
Abstract:
DataBase as a Service (DBaaS) providers need to improve their existing capabilities in data management and balance the efficient usage of virtual resources to multi-users with varying needs. However, there is still no existing method that concerns both with the optimization of the total ownership price and the performance of the queries of a Cloud data warehouse by taking into account the alternative virtual resource allocation and query execution plans. Our proposed method tunes the virtual resources of a Cloud to a data warehouse system, whereas most of the previous studies used to tune the database/queries to a given static resource setting. We solve this important problem with an exact Branch and Bound algorithm and a robust Multiobjective Genetic Algorithm. Finally, through several experiments we conclude remarkable findings of the algorithms we propose.