MULTIDIMENSIONAL REFERENCE MODELS FOR DATA WAREHOUSE DEVELOPMENT

Matthias Goeken, Ralf Knackstedt

Abstract

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.

References

  1. Abello, A.; Samos, J.; Saltor, F. (2000). A Data Warehouse Multidimensional Data Models Classification. Technical Report LSI-2000-6. Dept. Llenguages y Sistemas Informáticos (Universidad de Granada), 2000.
  2. Adamson, C.; Venerable, M. (1998). Data Warehouse Design Solutions. New York 1998.
  3. Becker, J.; Delfmann, P.; Dreiling, A.; Knackstedt, R.; Kuropka, D. (2004). Configurative Process Modeling - Outlining an Approach to Increased Business Process Model Usability. In: Khosrow-Pour, M. (Eds.): Information Through Information Technology. 2004 Information Resources Management Association. International Conference. New Orleans, Louisiana, USA. May 23-36, 2004. Hershey et al. 2004, pp. 615-619.
  4. Blaschka, M. (2000). FIESTA. A Framework for Schema Evolution in Multidimensional Databases. PhDThesis, München 2000.
  5. Bulos, D. (1996). A New Dimension. OLAP Database Design. Database Programming & Design, 9 (1996) 6, pp. 33-37.
  6. Burmester, L.; Goeken, M. (2006). Method for User Oriented Modelling of Data Warehouse Systems. In: Manolopoulos, Y. et al. (ed.): Proceedings of the 8th International Conference on Enterprise Information Systems, ICEIS 2006, May 2006 Paphos/ Zypern.
  7. Chan, P.; Shoshani, A. (1981). SUBJECT - A Directory Driven System for Organizing and Accessing Large Statistical Databases. In: IEEE Computer Society: Proceedings of the 7th International Conference on Very Large Data Bases (VLDB'81). Cannes, France, 9.-11. September 1981. Cannes 1981, pp. 553-563.
  8. Chen, P. P.-S. (1976). The Entity-Relationship Model - Toward a Unified View of Data. ACM Transactions on Database Systems, 1 (1976) 1, pp. 9-36.
  9. Copeland, T. Koller, T.; Murrin, J. (1990). Valuation: Measuring and Managing the Value of Companies. New York et al. John Wiley & Sons, 1990.
  10. Darke, P.; Shanks, G. (1996). Stakeholder Viewpoints in Requirements Definition. Requirements Engineering, 1 (1996) 1, pp. 88-105.
  11. Delfmann, P.; Janiesch, C.; Knackstedt, R.; Rieke, T.; Seidel, S. (2006). Towards Tool Support for Configurative Reference Modeling - Experiences from a Meta Modeling Teaching Case. Erscheint in: Proceedings of the 2nd Workshop on Meta-Modelling and Ontologies (WoMM 2006). Karlsruhe, Germany. 2006.
  12. Eccles, R. G. (1991). The performance measurement manifesto. In: Harvard Business Review, 69 (1991) 1- 2, pp. 131-137.
  13. Goeken, M. (2006). Entwicklung von Data-WarehouseSystemen. Anforderungsmanagement, Modellierung, Implementierung. Wiesbaden 2006 [in german].
  14. Goeken, M. (2004). Referenzmodellbasierte Einführung von Führungsinformationssystemen. Grundlagen, Anforderungen, Methode. In: Wirtschaftsinformatik 46 (2004) 5, S. 353 - 365. [in german]
  15. Golfarelli, M.; Maio, D.; Rizzi, S. (1998a). The Dimensional Fact Model - A Conceptual Model for Data Warehouse. International Journal of Cooperative Information Systems, 7 (1998) 2-3, pp. 215-246.
  16. Golfarelli, M.; Maio, D.; Rizzi, S. (1998b). Conceptual Design of Data Warehouses from E/R-Schemes. In: H. El-Rewini (ed.): Proceedings of the 31st Hawaii International Conference on System Sciences). 6.-9. Januar 1998. Los Alamitos et al. 1998. pp. 334-343.
  17. Hahn, K.; Sapia, C.; Blaschka, M. (2000). Automatically Generating OLAP Schemata from Conceptual Graphical Models. In: Proceedings of the ACM Third International Workshop on Data Warehousing and OLAP (DOLAP 2000). Washington D. C., USA, 10. November 2000.
  18. Halmans, G., Pohl, K. (2004). Communicating the Variability of a Software-Product Family to Customers. Informatik - Forschung und Entwicklung, 18, 113-131.
  19. Harren, A; Herden, O. (1999). MML and mUML - Language and Tool for Supporting Conceptual Data Warehouse Designs. In: Proceedings 2.GI-Workshop Data Mining und Data Warehousing (DMDW99), pp. 57-68, Magdeburg (Germany), September 1999. LWA99. Papers in edited volumes. [in german].
  20. Hofstede, A.H.M., Verhoef, T.F. (1996). Meta-CASE: Is the game worth the candle? In: Info Systems Journal, (6), 1996, pp. 41-68.
  21. Holten, R. (2003). Specification of management views in information warehouse projects. Information Systems, 28 (2003) 7, pp. 709-751.
  22. Hopcroft, J. E.; Motwani, R.; Ullman, J. D. (2000). Introduction to Automata Theory, Languages, and Computation. 2 ed. Boston, MA, USA: Addison-Wesley Longman Publishing.
  23. Kaplan, R. S.; Norton, D. P. (1996). Translating Strategy into Action. The Balanced Scorecard. Boston, MA, 1996.
  24. Kimball, R. (1996). Data Warehouse Toolkit - Practical Techniques for Building Dimensional Data Warehouses. New York 1996.
  25. Knackstedt, R.(2006). Fachkonzeptionelle Referenzmodellierung einer Managementunterstützung mit quantitativen und qualitativen Daten. Methodische Konzepte zur Konstruktion und Anwendung. PhD-Thesis, Berlin 2006. [in german]
  26. Knackstedt, R.; Janiesch, C.; Rieke, T. (2006). Configuring Reference Models - An Integrated Approach for Transaction Processing and Decision Support. In: Manolopoulos, Y. et al. (ed.): Proceedings of the 8th International Conference on Enterprise Information Systems, ICEIS 2006, May 2006 Paphos/ Zypern.
  27. Knackstedt, R.; Klose, K. (2005). Configurative Reference Model-Based Development of Data Warehouse Systems. In: Khosrow-Pour, M. (Hrsg.): Managing Modern Organizations with Information Technology. IRMA, San Diego, California, USA. May 15-18, 2005. Hershey et al. 2005, S. 32-39.
  28. Kotonya, G.; Sommerville, I. (1995). Requirements Engineering With Viewpoints. Technical Report: CS EG/10/1995. Cooperative Systems Engineering Group. Computing Department. Lancaster 1995.
  29. Lapsley, I.; Mitchel, F. (1996). The Accounting Challenge: Accounting and Performance Measurement. London, 1996.
  30. Mertens, P.; Griese, J. (2002). Integrierte Informationsverarbeitung. (Integrated Information Processing) 9. eds, Wiesbaden 2002. [in german].
  31. Mukherjee, D.; D'Souza. D. (2003). Think phased Implementation for successful Data Warehousing. In: Information Systems Management, 20, 82 -90.
  32. Nissen, H. W.; Jeusfeld, M.; Jarke, M.; Zemanek, G. V.; Huber, H. (1996). Managing Multiple Requirements Perspectives with Metamodels, IEEE Software, 13 (1996) 3, pp. 37-48.
  33. Nordstrom, G.; Sztipanovits, J; Karsai, G.; Ledeczi, A. (1998). Metamodeling - Rapid Design and Evolution of Domain-Specific Modeling Environments. In: Proceedings of the IEEE ECBS'98 Conference. Nashville, Tennessee, April 1998. Nashville 1998, pp. 68-74.
  34. Nuseibeh, B. A. (1994). A Multi-Perspective Framework for Method Integration. Dissertation, University of London 1994.
  35. Poon, P.; Wagner, C. (2001). Critical success factors revisited: success and failure cases of information systems for senior executives. In: Decision Support Systems, 30, 393-418.
  36. Rafanelli, M.; Bezenchek, A.; Tininini, L. (1996): The Aggregate Data Problem - A System for their Definition and Management. Sigmod Record, 25 (1996) 1, pp. 8-13.
  37. Rafanelli, M.; Shoshani, A. (1990). STORM - A Statistical Object Representation Model. In: Z. Michaelewicz (Eds.): Proceedings of the 5th International Conference on Statistical and Scientific Database Management (SSDBM'90). Charlotte, USA, 3.-5. April 1990, pp. 14-29.
  38. Rosemann, M. (2003). Application Reference Models and Building Blocks for Management and Control. In: Handbook of Enterprise Architecture. Eds.: P. Bernus, L. Nemes, G. Schmidt. Berlin et al. 2003, pp. 595-615.
  39. Rosemann, M.; Shanks, G. (2001). Extension and Configuration of Reference Models for Enterprise Resource Planning Systems. Proceedings of the 12th Australasian Conference on Information Systems (ACIS 2001). G. Finnie, D. et al. (Eds.). Harbour, 4-7 December, pp. 537-546.
  40. Sapia, C.; Blaschka, M.; Höfling, G.; Dinter, B. (1998). Extending the E/R Model for the Multidimensional Paradigm. In: Proceedings of the International Workshop on Data Warehouse and Data Mining (DWDM'98). Lecture Notes in Computer Science. Singapur, 19.-20. November 1998, pp. 105-116.
  41. Spitta, T. (1997). Wiederverwendbare Attribute als Ausweg aus dem Datenchaos. In: HMD, 34 (1997) 195, pp. 38-55. [in german].
  42. Thomsen, E. (1997). OLAP Solutions - Building Multidimensional Information Systems. New York 1997.
  43. Trujillo, J., Palomar, M., Gómez, J., Song, I.-Y. (2001). Designing Data Warehouses with OO Conceptual Models. IEEE Computer 34, 66-75
  44. Vassiliadis, P. (2000). Gulliver in the land of data warehousing: practical experiences and observations of a researcher, Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'2000), June 5-6, Stockholm, Sweden.
  45. Vassiliadis, P.; Bouzeghoub, M.; Quix, C. (2000). Towards Quality-Oriented Data Warehouse Usage and Evolution, Information Systems 25 (2000) 2, pp. 89- 115.
  46. Watson H., Fuller C., Ariyachandra T. (2004). Data warehouse governance: best practices at Blue Cross and Blue Shield of North Carolina. Decision Support Systems, 38, 435-450.
  47. Wixom, B. H.; Watson, H. J. (2001). An Empirical Investigation of the Factors Affecting Data Warehousing Success. In: MIS Quarterly, 25, 17 - 41.
Download


Paper Citation


in Harvard Style

Goeken M. and Knackstedt R. (2007). MULTIDIMENSIONAL REFERENCE MODELS FOR DATA WAREHOUSE DEVELOPMENT . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 3: ICEIS, ISBN 978-972-8865-90-0, pages 347-354. DOI: 10.5220/0002366803470354


in Bibtex Style

@conference{iceis07,
author={Matthias Goeken and Ralf Knackstedt},
title={MULTIDIMENSIONAL REFERENCE MODELS FOR DATA WAREHOUSE DEVELOPMENT},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 3: ICEIS,},
year={2007},
pages={347-354},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002366803470354},
isbn={978-972-8865-90-0},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 3: ICEIS,
TI - MULTIDIMENSIONAL REFERENCE MODELS FOR DATA WAREHOUSE DEVELOPMENT
SN - 978-972-8865-90-0
AU - Goeken M.
AU - Knackstedt R.
PY - 2007
SP - 347
EP - 354
DO - 10.5220/0002366803470354