Data Warehouse Methodology: A Process Driven Approach

The current methods of the development and implementation of a Data Warehouse don’t consider the integration with the organizational-processes and their respective data. In addition to these current methods, based on demand- driven, data-driven and goal-driven, we will introduce in this paper a new approach to DW development and implementation. This proposal will be based on the integration of organizational processes and their data, denote by: Integrated-Process-Driven (IPD. The principles of this approach are founded on the relation-ships between business-processes and Entity-Relationship-Models (ERM), the Relational Database (RDB) data models. These relationships are originated in the Architecture of Integrated Information Systems (ARIS) methodology. IPD will use the information extracted from the data-driven, on the one side, to match (or define) the AS-IS business processes model. On the other hand, IPD will use the information returned from the demand-driven (required by the DW users) to define the TO-BE business process model based also on the AS-IS model. IPD will integrate the new data models, originated in the TO-BE business processes model, with the DW requirements. The aim of IPD is to define (or to redefine) the organizational processes which will supply the DW with data. The added-value of this approach will be the integration of the previous methods (demand-driven and data-driven) with organizational processes that will treat these sets of informations to be used by the DW. Our approach is also a trigger for business processes reengineering and optimization. Finally, the goal-driven will verify if the IPD achieves the business goals.