EUVIMEDEUVIMED entdecken
Crossref

Cost Models for Selecting Materialized Views in Public Clouds

Romain Perriot, Jérémy Pfeifer, Laurent d'Orazio, Bruno Bachelet, Sandro Bimonte, Jérôme Darmont

International Journal of Data Warehousing and Mining · 2014

DOI: 10.4018/ijdwm.2014100101 ↗

Kurz gefasst

Fachartikel in der Zeitschrift International Journal of Data Warehousing and Mining, 2014. Verfasst von Romain Perriot und 5 weiteren Autor:innen. Die Arbeit wurde bisher 5-mal zitiert (Crossref) und nennt 33 Literaturangaben.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

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 of such 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 of a given query workload. It experimentally shows that maintaining materialized views is always advantageous, both in terms of performance and cost.

Zitieren

APA

Perriot, R., Pfeifer, J., d'Orazio, L., Bachelet, B., Bimonte, S., & Darmont, J. (2014). Cost Models for Selecting Materialized Views in Public Clouds. International Journal of Data Warehousing and Mining. https://doi.org/10.4018/ijdwm.2014100101

Vancouver

Perriot R, Pfeifer J, d'Orazio L, Bachelet B, Bimonte S, Darmont J. Cost Models for Selecting Materialized Views in Public Clouds. International Journal of Data Warehousing and Mining. 2014. doi:10.4018/ijdwm.2014100101

BibTeX
@article{Perriot2014,
  author = {Perriot, Romain and Pfeifer, Jérémy and d'Orazio, Laurent and Bachelet, Bruno and Bimonte, Sandro and Darmont, Jérôme},
  title = {Cost Models for Selecting Materialized Views in Public Clouds},
  journal = {International Journal of Data Warehousing and Mining},
  year = {2014},
  doi = {10.4018/ijdwm.2014100101}
}
Kostenlos starten →