Publications of the ERIC lab
|Cost Models for View Materialization in the Cloud |
Author(s): Nguyen Thi-Van-Anh, D'Orazio Laurent, Bimonte Sandro, DARMONT J.
Proceedings: Conference: Workshop on Data Analytics in the Cloud (EDBT-ICDT/DanaC 2012) (Berlin, DE, 2012-03) Published: Proceedings of the Workshop on Data Analytics in the Cloud (EDBT-ICDT/DanaC 2012), vol. (2012) p.http://www.edbt.org/Proceedings/2012-Berlin/papers/workshops/danac2012/a2-nguyen.pdf
Ref HAL: hal-00686027_v2
Abstract: In classical databases, query performance is casually achieved through physical data structures such as caches, indexes and materialized views. In this context, many cost models help select a "best set'' of such data structures. However, this selection task becomes more complex in the cloud. The criterion to optimize is indeed at least two-dimensional, with the monetary cost of using the cloud balancing query response time. Thus, we define in this paper new cost models that fit into the pay-as-you-go paradigm of cloud computing. These cost models help achieve a multi-criteria optimization of the view materialization vs. CPU power consumption problem, under budget constraints. Finally, we present experimental results that provide a first validation of our contribution and show that cloud view materialization is always desirable.