A Knowledge-driven Data Warehouse Model for Analysis Evolution

  • Authors:
  • Cécile Favre;Fadila Bentayeb;Omar Boussaid

  • Affiliations:
  • ERIC Laboratory, University of Lyon 2, France;ERIC Laboratory, University of Lyon 2, France;ERIC Laboratory, University of Lyon 2, France

  • Venue:
  • Proceedings of the 2006 conference on Leading the Web in Concurrent Engineering: Next Generation Concurrent Engineering
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

A data warehouse is built by collecting data from external sources. Several changes on contents and structures can usually happen on these sources. Therefore, these changes have to be reflected in the data warehouse using schema updating or versioning. However a data warehouse has also to evolve according to new users' analysis needs. In this case, the evolution is rather driven by knowledge than by data. In this paper, we propose a Rule-based Data Warehouse (R-DW) model, in which rules enable the integration of users' knowledge in the data warehouse. The R-DW model is composed of two parts: one fixed part that contains a fact table related to its first level dimensions, and a second evolving part, defined by means of rules. These rules are used to dynamically create dimension hierarchies, allowing the analysis contexts evolution, according to an automatic and concurrent way. Our proposal provides flexibility to data warehouse's evolution by increasing users' interaction with the decision support system.