Cost models for view materialization in the cloud

  • Authors:
  • Thi-Van-Anh Nguyen;Sandro Bimonte;Laurent d'Orazio;Jérôme Darmont

  • Affiliations:
  • Université de Caen Basse, Normandie, France;Irstea, UR TSCF, Clermont-Ferrand, France;Université Blaise Pascal, Clermont-Ferrand, France;Université de Lyon, France

  • Venue:
  • Proceedings of the 2012 Joint EDBT/ICDT Workshops
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

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.