Model driven data warehouse using MDA and 2TUP

  • Authors:
  • Moez Essaidi;Aomar Osmani

  • Affiliations:
  • (Correspd. Tel.: +33 6 23 55 50 74/ E-mail: moez.essaidi@lipn.univ-paris13.fr) LIPN - UMR CNRS 7030, Université/ Paris-Nord, 99 Avenue Jean-Baptiste Clé/ment, 93430 Villetaneuse, France;LIPN - UMR CNRS 7030, Université/ Paris-Nord, 99 Avenue Jean-Baptiste Clé/ment, 93430 Villetaneuse, France

  • Venue:
  • Journal of Computational Methods in Sciences and Engineering - Special Supplement Issue in Section A and B: Selected Papers from the ISCA International Conference on Software Engineering and Data Engineering, 2009
  • Year:
  • 2010

Quantified Score

Hi-index 0.02

Visualization

Abstract

The data warehousing architecture is defined through several heterogeneous and interrelated layers. Each layer contains different components, using different modeling profiles, and depends on several technologies. Data Warehouse (DW) projects are also exposed to several technical risks and require more knowledge about the underlying business domain. These aspects increase the costs and the time of DW development and make it a very difficult and challenging task. Several Data Warehouses (DWs) design frameworks and engineering processes have been proposed during the last few years. However, the framework-oriented approaches fail to provide an integrated and standard framework that addresses the design of all DW layers. The process-oriented approaches fail also to define an engineering process that address the whole development cycle of DW with an iterative and incremental manner while considering both the business and the technical requirements. In addition, not much effort was devoted to unify the two into a single integrated approach. In this paper, we address this issue by proposing a unified method for developing DWs based on the Model Driven Architecture (MDA) and the 2 Track Unified Process (2TUP) standards. Finally, we introduce the architecture of a tool that implements the proposed model-driven data warehouse approach.