Geodesic
ProRes: Proactive Re-Selection of Materialized Views
Computer Science and Information Systems, Tome 19 (2022) no. 2.

Voir la notice de l'article provenant de la source Computer Science and Information Systems website

Materialized View Selection is one of the most studied problems in the database field, covering SQL and NoSQL technologies as well as different deployment infrastructures (centralized, parallel, cloud). This problem has become more complex with the arrival of data warehouses, being coupled with the physical design phase that aims at optimizing query performance. Selecting the best set of materialized views to optimize query performance is a challenging task. Given their importance and the complexity of their selection, several research efforts both from academia and industry have been conducted. Results are promising – some solutions are being implemented by commercial and open-source DBMSs –, but they do not factor in the following properties of nowadays analytical queries: (i) largescale queries, (ii) their dynamicity, and (iii) their high interaction. Studies to date fail to consider that complete set of properties. Considering the three properties simultaneously is crucial regarding today’s analytical requirements, which involve dynamic and interactive queries. In this paper, we first present a concise state of the art of the materialized view selection problem (VSP) by analyzing its ecosystem. Secondly, we propose a proactive re-selection approach that considers the three properties concurrently. It features two main phases: offline and online. In the offline phase, we manage a set of the first queries based on a given threshold δ by selecting materialized views through a hypergraph structure. The second phase manages the addition of new queries by scheduling them, updates the structure of the hypergraph, and selects new views by eliminating the least beneficial ones. Finally, extensive experiments are conducted using the Star Schema Benchmark data set to evaluate the effectiveness and efficiency of our approach.
Keywords: Materialized Views, Hypergraphs, Query Sharing, large-scale of queries 
@article{CSIS_2022_19_2_a12,
     author = {Mustapha Chaba Mouna and Ladjel Bellatreche and Narhimene Boustia},
     title = {ProRes: {Proactive} {Re-Selection} of {Materialized} {Views}},
     journal = {Computer Science and Information Systems},
     publisher = {mathdoc},
     volume = {19},
     number = {2},
     year = {2022},
     url = {http://geodesic.mathdoc.fr/item/CSIS_2022_19_2_a12/}
}
TY  - JOUR
AU  - Mustapha Chaba Mouna
AU  - Ladjel Bellatreche
AU  - Narhimene Boustia
TI  - ProRes: Proactive Re-Selection of Materialized Views
JO  - Computer Science and Information Systems
PY  - 2022
VL  - 19
IS  - 2
PB  - mathdoc
UR  - http://geodesic.mathdoc.fr/item/CSIS_2022_19_2_a12/
ID  - CSIS_2022_19_2_a12
ER  - 
%0 Journal Article
%A Mustapha Chaba Mouna
%A Ladjel Bellatreche
%A Narhimene Boustia
%T ProRes: Proactive Re-Selection of Materialized Views
%J Computer Science and Information Systems
%D 2022
%V 19
%N 2
%I mathdoc
%U http://geodesic.mathdoc.fr/item/CSIS_2022_19_2_a12/
%F CSIS_2022_19_2_a12
Mustapha Chaba Mouna; Ladjel Bellatreche; Narhimene Boustia. ProRes: Proactive Re-Selection of Materialized Views. Computer Science and Information Systems, Tome 19 (2022) no. 2. http://geodesic.mathdoc.fr/item/CSIS_2022_19_2_a12/