Data warehouse methodology: A process driven approach

Abstract

The current methods of the development and implementation of a Data Warehouse don't consider the integration with the organizationalprocesses 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. © Springer - Verlag 2004.