Building Data Warehouses Using the Enterprise Modeling Framework

This paper proposes an enterprise modeling framework for the deployment of data warehouses. The framework provides the information roadmap coordinating source data and different data warehouses across the business enterprise. The paper introduces a solution to address data warehousing issues at the enterprise level while avoiding the pitfalls of creating enterprise data warehouses and universal data marts. It further proposes a change of paradigm from point solutions focus to a methodology driven by enterprise requirements to meet the challenges of the new economy. The proposed framework emphasizes the separation of the conceptual construct from the physical and operational constructs of an enterprise. It points out the differences and dependencies of analytic and operational processes and how data warehouses and operational data stores respectively support their information requirements. This paper will demonstrate how the enterprise modeling framework for data warehousing can produce business benefits.