Model driven data warehouse using MDA and 2TUP

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.