View Selection and Materialization

Zohra Bellahsene 1
1 ZENITH - Scientific Data Management
LIRMM - Laboratoire d'Informatique de Robotique et de Microélectronique de Montpellier, CRISAM - Inria Sophia Antipolis - Méditerranée
Abstract : There are many motivations for investigating the view selection problem. At first, materialized views are increasingly being supported by commercial database systems and are used to speed up query response time. Therefore, the problem of choosing an appropriate set of views to materialize in the database is crucial in order to improve query processing cost. Another application of the view selection issue is selecting views to materialize in data warehousing systems to answer decision support queries. The problem addressed in this paper is similar to that of deciding which views to materialize in data warehousing. However, most existing view selection methods are static. Moreover, none of these methods have considered the problem of de-materializing the already materialized views. Yet it is a very important issue since the size of storage space is usually restricted. This chapter deals with the problem of dynamic view selection and with the pending issue of removing materialized views in order to replace less beneficial views with more beneficial views. We propose a view selection method for deciding which views to materialize according to statistic metadata. More precisely, we have designed and implemented our view selection method, including a polynomial algorithm, to decide which views to materialize.
Type de document :
Chapitre d'ouvrage
Dr. Ladjel Bellatreche. Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction, pp.N/C, 2009, Advances in Data Warehousing and Mining Book, 〈www.igi-global.com/ADWM)〉
Liste complète des métadonnées

https://hal-lirmm.ccsd.cnrs.fr/lirmm-00326843
Contributeur : Zohra Bellahsene <>
Soumis le : lundi 6 octobre 2008 - 11:00:12
Dernière modification le : jeudi 24 mai 2018 - 15:59:21

Identifiants

  • HAL Id : lirmm-00326843, version 1

Collections

Citation

Zohra Bellahsene. View Selection and Materialization. Dr. Ladjel Bellatreche. Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction, pp.N/C, 2009, Advances in Data Warehousing and Mining Book, 〈www.igi-global.com/ADWM)〉. 〈lirmm-00326843〉

Partager

Métriques

Consultations de la notice

71