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

摘要

A corporate data warehouse is 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 marts focused 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 engineering techniques. 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.