Index and Materialized View Selection in Data Warehouses

Kamel Aouiche (1) , Jérôme Darmont (2)

1 Centre LICEF - TÉLUQ - Laboratoire d'Informatique Cognitive et d'Environnements de Formation - Téluq, l'université à distance de l'UQAM
2 ERIC - Equipe de Recherche en Ingénierie des Connaissances

The aim of this article is to present an overview of the major families of state-of-the-art index and materialized view selection methods; and to discuss the issues and future trends in data warehouse performance optimization. We particularly focus on data mining-based heuristics we developed to reduce the selection problem complexity and target the most pertinent candidate indexes and materialized views.

Domaines: Base de données [cs.DB]

Kamel Aouiche, Jérôme Darmont. Index and Materialized View Selection in Data Warehouses. Handbook of Research on Innovations in Database Technologies and Applications, II, pp.693-700, 2009. ⟨hal-01447936v2⟩