Integrated Model-Driven Development of Goal-Oriented Data Warehouses and Data Marts

  • Authors:

  • Jesús Pardillo;Juan Trujillo

  • Affiliations:

  • Lucentia Research Group, Department of Software and Computing Systems, University of Alicante, Spain;Lucentia Research Group, Department of Software and Computing Systems, University of Alicante, Spain

  • Venue:
  • ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

A corporate data warehouseis a repository that provides decision makers with a large amount of historical data concerning the overall enterprise strategy. In order to customize the data warehouse, many organizations develop concrete data martsfocused on a particular department or business process. However, their integrated development is still an open problem for many organizations due to the technical and organizational challenges involved during the design of these repositories as a complete solution. Therefore, we present here a design approach in order to build both the corporate data warehouse and data marts from user's requirements in an integrated way. Our approach consists on linking information requirements to specific data marts elicited by using the goal-oriented requirement engineering, which are automatically translated into the implementation of the corresponding data repositories by means of model-driven engineeringtechniques. Its great advantage is that user's requirements are captured since the very-early development stages of a data-warehousing project in order to automatically translate them into the entire data-warehousing platform.