Evolutionary Multiobjective Query Workload Optimization of Cloud Data Warehouses

Date

2014

Author

Dokeroglu, Tansel
Sert, Seyyit Alper
Cinar, Muhammet Serkan

Metadata

Show full item record

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Item Usage Stats

15
views

27
downloads

Cite This

<jats:p>With the advent of Cloud databases, query optimizers need to find paretooptimal solutions in terms of response time and monetary cost. Our novel approach minimizes both objectives by deploying alternative virtual resources and query plans making use of the virtual resource elasticity of the Cloud. We propose an exact multiobjective branch-and-bound and a robust multiobjective genetic algorithm for the optimization of distributed data warehouse query workloads on the Cloud. In order to investigate the effectiveness of our approach, we incorporate the devised algorithms into a prototype system. Finally, through several experiments that we have conducted with different workloads and virtual resource configurations, we conclude remarkable findings of alternative deployments as well as the advantages and disadvantages of the multiobjective algorithms we propose.</jats:p>

Subject Keywords

General Biochemistry, Genetics and Molecular Biology, General Environmental Science, General Medicine

URI

https://hdl.handle.net/11511/51460

Collections

Department of Computer Engineering, Article