A GRASP Heuristic to Optimize the Materialization of Views in the Cloud - Université Clermont Auvergne Accéder directement au contenu
Communication Dans Un Congrès Année : 2013

A GRASP Heuristic to Optimize the Materialization of Views in the Cloud

Résumé

This paper studies the problem of materializing views for a database stored in the cloud, in order to improve the response time of queries on the database under a budget limit. Views are subsets of the database, also stored in the cloud, that act like caches to accelerate the access to data. In a cloud, CPU usage and data storage have to be paid, meaning that a trade-off between speed gain and storage cost has to be found. The problem has been formulated as a mixed integer program (MIP) and identified as NP-hard. To solve the problem a GRASP heuristic is proposed. The quality and speed of this algorithm is compared with the results of a MIP solver. Numerical experiments on many randomly generated instances of the problem show that the proposed approach is able to efficiently solve large instances of the problem.
Fichier principal
Vignette du fichier
sbpo_2013.pdf (1.11 Mo) Télécharger le fichier
Origine : Fichiers éditeurs autorisés sur une archive ouverte
Loading...

Dates et versions

hal-01704151 , version 1 (15-02-2018)

Identifiants

  • HAL Id : hal-01704151 , version 1

Citer

Vilmar Jefté Rodrigues de Sousa, Michael David de Souza Dutra, Bruno Bachelet, Laurent d'Orazio. A GRASP Heuristic to Optimize the Materialization of Views in the Cloud. XLV Brazilian Symposium of Operational Research (SBPO), Sep 2013, Natal, Brazil. pp.1825-1834. ⟨hal-01704151⟩
92 Consultations
21 Téléchargements

Partager

Gmail Facebook X LinkedIn More