Selection of Materialized Views: A Cost-Based Approach - LIRMM - Laboratoire d’Informatique, de Robotique et de Microélectronique de Montpellier Accéder directement au contenu
Communication Dans Un Congrès Année : 2003

Selection of Materialized Views: A Cost-Based Approach

Résumé

Recently, multi-query optimization techniques have been considered as beneficial in view selection setting. The main interest of such techniques relies in detecting common sub expressions between the different queries of workload. This feature can be exploited for sharing updates and space storage. However, due to the reuse a query change may entail an important reorganization of the multi query graph. In this paper, we present an approach that is based on multi-query optimization for view selection and that attempts to reduce the drawbacks resulting from these techniques. Finally, we present a performance study using workloads consisting of queries over the schema of the TPC-H benchmark. This study shows that our view selection provides significant benefits over the other approaches.

Dates et versions

lirmm-00269645 , version 1 (03-04-2008)

Identifiants

Citer

Xavier Baril, Zohra Bellahsene. Selection of Materialized Views: A Cost-Based Approach. CAiSE 2003 - 15th Conference on Advanced Information Systems Engineering, Jun 2003, Klagenfurt, Austria. pp.665-680, ⟨10.1007/3-540-45017-3_44⟩. ⟨lirmm-00269645⟩
64 Consultations
0 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More