Selection of Materialized Views: A Cost-Based Approach - LIRMM - Laboratoire d’Informatique, de Robotique et de Microélectronique de Montpellier
Conference Papers Year : 2003

Selection of Materialized Views: A Cost-Based Approach

Abstract

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 and versions

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

Identifiers

Cite

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⟩
68 View
0 Download

Altmetric

Share

More