Multidimensional Reference Models for Data Warehouse Development

In the area of Data Warehousing the importance of conceptual modelling increases as it gains the status of a critical success factor. Nevertheless the application of conceptual modelling in practice often remains undone, due to time and cost restrictions. Reference models seem to be a suitable solution for this problem as they provide generic models which can be easily adapted to specific problems and thus decrease the modelling outlay. This paper identifies the requirements for multidimensional modelling techniques whose fulfillment are a prerequisite for the construction of reference models. Referring to the ME/RM, the concrete implementation of these requirements will be illustrated.

[1]  E. Ziegel,et al.  The Balanced Scorecard , 1998 .

[2]  Markus Blaschka,et al.  FIESTA: A Framework for Schema Evolution in Multidimensional Databases (Abstract) , 2000, Datenbank Rundbr..

[3]  Arie Shoshani,et al.  SUBJECT: A Directory Driven System for Organizing and Accessing Large Statistical Databases , 1981, VLDB.

[4]  Barbara Wixom,et al.  An Empirical Investigation of the Factors Affecting Data Warehousing Success , 2001, MIS Q..

[5]  Walid G. Aref,et al.  Digital government security infrastructure design challenges , 2001 .

[6]  R. Kaplan,et al.  The Balanced Scorecard: Translating Strategy into Action , 1996 .

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

[8]  Ian Sommerville,et al.  Cooperative Systems Engineering Group , 1998 .

[9]  OLAP Ideas MDDM.  A Data Warehouse Multidimensional Data Models Classiication , and F Elix Saltor (a) , 2007 .

[10]  Chris Adamson,et al.  Data Warehouse Design Solutions , 1998 .

[11]  Panos Vassiliadis,et al.  Towards Quality-oriented Data Warehouse Usage and Evolution , 2000, Inf. Syst..

[12]  Matthias Goeken,et al.  Anforderungsmanagement bei der Entwicklung von Data Warehouse-Systemen — Ein sichtenspezifischer Ansatz , 2005 .

[13]  Michael Rosemann,et al.  Application Reference Models and Building Blocks for Management and Control (ERP Systems) , 2003 .

[14]  Jörg Becker,et al.  Configurative Process Modeling - Outlining an Approach to Increased Business Process Model Usability , 2004 .

[15]  R. Eccles.  The performance measurement manifesto. , 1991, Harvard business review.

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

[17]  Bashar Nuseibeh,et al.  A Multi-Perspective Framework for Method Integration , 2001 .

[18]  Debasish Mukherjee,et al.  Think Phased Implementation for Successful Data Warehousing , 2003, Inf. Syst. Manag..

[19]  A Min Tjoa,et al.  The Entity-Relationship Model for Multilevel Security , 1993, ER.

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

[21]  Manuel Palomar,et al.  Designing Data Warehouses with OO Conceptual Models , 2001, Computer.

[22]  Jeffrey D. Ullman,et al.  Introduction to Automata Theory, Languages and Computation , 1979 .

[23]  Arie Shoshani,et al.  STORM: A Statistical Object Representation Model , 1990, IEEE Data Eng. Bull..

[24]  Ralf Knackstedt,et al.  Configurative Reference Model-Based Development of Data Warehouse Systems , 2005 .

[25]  T. F. Verhoef,et al.  Meta‐CASE: Is the game worth the candle? , 1996, Inf. Syst. J..

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

[27]  Erik Thomsen,et al.  OLAP Solutions - Building Multidimensional Information Systems , 1997 .

[28]  Ian Sommerville,et al.  Requirements engineering with viewpoints , 1996, Softw. Eng. J..

[29]  Klaus Pohl,et al.  Communicating the variability of a software-product family to customers , 2004, Informatik Forschung und Entwicklung.

[30]  Graeme G. Shanks,et al.  Stakeholder viewpoints in requirements definition: A framework for understanding viewpoint development approaches , 1996, Requirements Engineering.

[31]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

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

[33]  Thilini Ariyachandra,et al.  Data warehouse governance: best practices at Blue Cross and Blue Shield of North Carolina , 2004, Decis. Support Syst..

[34]  Panos Vassiliadis,et al.  Gulliver in the land of data warehousing: practical experiences and observations of a researcher , 2000, DMDW.

[35]  Peter Mertens,et al.  Integrierte Informationsverarbeitung 1 , 1997 .

[36]  Michael Rosemann,et al.  Extension and Configuration of Reference Models for Enterprise Resource Planning Systems , 2001 .

[37]  Matthias Goeken,et al.  Method for User Oriented Modelling of Data Warehouse Systems , 2006, ICEIS.

[38]  Matthias Goeken,et al.  Referenzmodellbasierte Einführung von Führungsinformationssystemen Grundlagen, Anforderungen, Methode , 2004, Wirtschaftsinf..

[39]  Christian Janiesch,et al.  Configuring Reference Models - An Integrated Approach for Transaction Processing and Decision Support , 2006, ICEIS.

[40]  Christian Wagner,et al.  Critical success factors revisited: success and failure cases of information systems for senior executives , 2001, Decis. Support Syst..

[41]  Management ™ are Trademarks of SAP AG. The Management Cockpit ™ is a Trademark of SAP AG, originally created by Prof. , 2022 .

[42]  Mike Bourne,et al.  Translating strategy into action , 1998 .

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

[44]  Gabor Karsai,et al.  Metamodeling-rapid design and evolution of domain-specific modeling environments , 1999, Proceedings ECBS'99. IEEE Conference and Workshop on Engineering of Computer-Based Systems.

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

[46]  P. Mertens,et al.  Integrierte Informationsverarbeitung 2 , 1993 .

[47]  Matthias Jarke,et al.  Managing Multiple Requirements Perspectives with Metamodels , 1996, IEEE Softw..

[48]  Thorsten Spitta.  Wiederverwendbare Attribute als Ausweg aus dem Datenchaos , 1997, HMD Prax. Wirtsch..

[49]  Maurizio Rafanelli,et al.  The aggregate data problem: a system for their definition and management , 1996, SGMD.