Cost models for view materialization in the cloud - INRAE - Institut national de recherche pour l’agriculture, l’alimentation et l’environnement Accéder directement au contenu
Communication Dans Un Congrès Année : 2012

Cost models for view materialization in the cloud

Modèles de couts pour les vues matérialisées dans le Cloud

Résumé

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.
Fichier non déposé

Dates et versions

hal-02597014 , version 1 (15-05-2020)

Identifiants

Citer

V. Nguyen, L. d'Orazio, S. Bimonte, J. Darmont. Cost models for view materialization in the cloud. DANAC, Mar 2012, Berlin, Germany. pp.8. ⟨hal-02597014⟩
11 Consultations
0 Téléchargements

Partager

Gmail Facebook X LinkedIn More