Process Reference Model for Data Warehouse Development - A Consensusoriented Approach

A structured conceptual design of reporting systems is a crucial task that has to precede implementation and monitoring. A basic challenge can be seen in information requirements engineering. On the one hand, users need certain information to successfully accomplish their tasks. On the other hand, it has to be avoided to supply them with too much and potentially irrelevant information. Information requirements engineering has to support the conceptual specification of information requirements. Thus, there is need for conceptual languages and appropriate procedure models. We propose a procedure model for the analysis and conceptual design of reporting systems as well as a conceptual modelling language that can be used for both as-is analysis and to-be modelling. It has been developed in an iterative approach based on multiple case studies. Due to the fact that different projects and different basic conditions require the use of different approaches of information requirements engineering, within the procedure model different approaches can be used. In this paper we introduce both procedure model and conceptual modelling language and present findings of a case study in which they were used.

[1]  Roland Holten,et al.  The MetaMIS approach for the specification of management views on business processes , 2001 .

[2]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[3]  Matteo Golfarelli,et al.  Designing the Data Warehouse: Key Steps and Crucial Issues , 1999 .

[4]  W. W. Royce,et al.  Managing the development of large software systems , 1970 .

[5]  Carsten Sapia,et al.  Automatically generating OLAP schemata from conceptual graphical models , 2000, DOLAP '00.

[6]  Christian Janiesch,et al.  Konfigurative Referenzmodellierung zur Fachkonzeption von Data Warehouse-Systemen mit dem H2-Toolset , 2006, Data Warehousing.

[7]  Jörg Becker,et al.  Business Process-driven Information Requirements Engineering , 2004 .

[8]  Douglas Hackney.  Understanding and Implementing Successful Data Marts , 1997 .

[9]  Björn Niehaves,et al.  Epistemological Perspectives on IS-Development - A Consensus-Oriented Approach on Conceptual Modeling , 2005, Wissensmanagement.

[10]  M. P. Carter.  Determining Information Needs , 1983 .

[11]  John A. Zachman,et al.  Business Systems Planning and Business Information Control Study: A Comparison , 1982, IBM Syst. J..

[12]  Hugh J. Watson,et al.  Determining Information Requirements for an EIS , 1993, MIS Q..

[13]  Beate List,et al.  A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse , 2002, DEXA.

[14]  J. Rockart.  Chief executives define their own data needs. , 1979, Harvard business review.

[15]  Vidette Poe.  Building a Data Warehouse for Decision Support , 1995 .

[16]  Thomas C. Hammergren.  Data Warehousing; Building the Corporate Knowledge Base , 1996 .

[17]  Jörg Becker,et al.  Evolutionary Method Engineering: Towards a Method for the Analysis and Conception of Management Information Systems , 2006, AMCIS.

[18]  Roland Gabriel,et al.  Grafische Notationen für die semantische Modellierung multidimensionaler Datenstrukturen in Management Support Systemen , 1998, Wirtschaftsinf..

[19]  Barbara Dinter,et al.  Extending the E/R Model for the Multidimensional Paradigm , 1998, ER Workshops.

[20]  Alan Ewert,et al.  A New Dimension , 1986 .

[21]  Robert Winter,et al.  Information requirements engineering for data warehouse systems , 2004, SAC '04.

[22]  Alexander Dreiling,et al.  Management Report Engineering — A Swiss Re Business Case , 2002 .

[23]  Matteo Golfarelli,et al.  A methodological framework for data warehouse design , 1998, DOLAP '98.

[24]  E. W. Martin.  Information Needs of Top MIS Managers , 1983, MIS Q..

[25]  Roland Holten,et al.  Specification of management views in information warehouse projects , 2003, Inf. Syst..

[26]  Jörg Becker,et al.  Using Management Objectives to Specify Management Information Systems - A Contribution to MIS Success , 2003, Wirtschaftsinformatik.

[27]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

[28]  Peter G. W. Keen,et al.  Mis Research: Reference disciplines and a Cumulative Tradition , 1980, ICIS.

[29]  John Mingers,et al.  Combining IS Research Methods: Towards a Pluralist Methodology , 2001, Inf. Syst. Res..

[30]  Paul Riebel,et al.  Gestaltungsprobleme einer zweckneutralen Grundrechnung , 1982 .

[31]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[32]  Peter Aiken,et al.  Information systems development and data modeling: Conceptual and philosophical foundations , 1997 .

[33]  Patrick Delfmann,et al.  Towards Tool Support for Configurative Reference Modeling - Experiences from a Meta Modeling Teaching Case , 2006, WoMM.