Accéder directement au contenu Accéder directement à la navigation
Article dans une revue

Cost Models for Selecting Materialized Views in Public Clouds

Abstract : Data warehouse performance is usually achieved through physical data structures such as indexes or materialized views. In this context, cost models can help select a relevant set ofsuch performance optimization structures. Nevertheless, selection becomes more complex in the cloud. The criterion to optimize is indeed at least two-dimensional, with monetary cost balancing overall query response time. This paper introduces new cost models that fit into the pay-as-you-go paradigm of cloud computing. Based on these cost models, an optimization problem is defined to discover, among candidate views, those to be materialized to minimize both the overall cost of using and maintaining the database in a public cloud and the total response time ofa given query workload. We experimentally show that maintaining materialized views is always advantageous, both in terms of performance and cost.
Type de document :
Article dans une revue
Liste complète des métadonnées

https://hal.archives-ouvertes.fr/hal-01436056
Déposant : Jérôme Darmont <>
Soumis le : lundi 16 janvier 2017 - 10:34:52
Dernière modification le : mardi 26 mai 2020 - 03:15:11
Document(s) archivé(s) le : lundi 17 avril 2017 - 14:24:23

Fichiers

14ijdwm.pdf
Fichiers produits par l'(les) auteur(s)

Identifiants

  • HAL Id : hal-01436056, version 1
  • ARXIV : 1701.05099

Citation

Romain Perriot, Jérémy Pfeifer, Laurent D 'Orazio, Bruno Bachelet, Sandro Bimonte, et al.. Cost Models for Selecting Materialized Views in Public Clouds. International Journal of Data Warehousing and Mining (JDWM), IGI Global, 2014, 10 (4), pp.1-25. ⟨hal-01436056⟩

Partager

Métriques

Consultations de la notice

295

Téléchargements de fichiers

273