Toward propagating the evolution of data warehouse on data marts

  • Authors:
  • Saïd Taktak;Jamel Feki

  • Affiliations:
  • Miracl Laboratory, University of Sfax, FSEGS Faculty, Sfax, Tunisia;Miracl Laboratory, University of Sfax, FSEGS Faculty, Sfax, Tunisia

  • Venue:
  • MEDI'12 Proceedings of the 2nd international conference on Model and Data Engineering
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

Modern Decision Support Systems (DSS) are composed of a Data Warehouse (DW) which stores all data necessary for decisional purposes, and a several Data Marts (DMs). A DM is a subject oriented extract of the DW data; it facilitates evaluating the performances of a business process. However, in practice, business processes may evolve as well as new ones may be created, consequently the DW model evolves in order to capture the changes. The maintenance of DMs due to the evolution of their DW is time-consuming, expensive and error-prone process. This paper studies the evolution of DM schemas in the case of a new table is added to the DW.