METHOD FOR USER ORIENTED MODELLING OF DATA WAREHOUSE SYSTEMS

Lars Burmester, Matthias Goeken

Abstract

The paper describes a method for data warehouse development. One critical success factor of data warehouse development is determining information requirements. Hence, the method focuses on gathering of requirements and information needs of the users first. An extended data warehouse architecture and a technique for decomposition of the system serve as a developing framework. On the one hand this framework is used to define releases (builds) of the system, which is indispensable for an incremental development process. On the other hand it defines intermediate and final work products (artifacts) that are produced and used during further development stages. Starting with information requirements elicitation, each increment is realized through a series of data models which successively are transformed from conceptual to logical level. These logical data models are then used for implementation as well as for the modelling of ETL processes.

References

  1. Abello, A., Samos, J. and Saltor F., 2000. A Data Warehouse Multidimensional Data Models Classification. Grenada: Technical Report LSI-2000-6, Dept. Llenguages y Sistemas Informáticos.
  2. Blaschka, M., 2000. FIESTA: A Framework for Schema Evolution in Multidimensional Databases. Dr. Technical University Munich.
  3. Bonifati, A. et al., 2001. Designing Data Marts for Data Warehouses. ACM Transactions on Software Engineering and Methodology, 10 (4), pp. 452483.
  4. Browne, G. and Rogich, M., 2001. An Empirical Investigation of User Requirements Elicitation: Comparing the Effectiveness of Prompting Techniques. Journal of Management Information Systems, 17 (4), pp. 223- 249.
  5. Bulos, D. and Forsman, S, 2002. Getting started ADAPT - OLAP Database Design. San Rafael: Symetry Corp, White Paper.
  6. Gilb, T., 1988. Principles of Software Engineering Management. Reading et al.: Addison-Wesley.
  7. Goguen, J. A. and Linde, C., 1993. Techniques for Requirements Elicitation. Proceedings of IEEE International Symposium on Requirements Engineering 1993 in San Diego.
  8. Golfarelli, M. and Rizzi, S., 1998. A Methodological Framework for Data Warehouse Design. Proceedings of the ACM first international Workshop on Data Warehousing and OLAP 1998 in Washington.
  9. Golfarelli, M., Maio, D. and Rizzi, S., 1998. Conceptual Design of Data Warehouses from E/R Schemes. Proceedings of the Hawaii International Conference On Systems Science 1998 in Kona.
  10. Hackney, D., 1998. Architectures and Approaches for Successful Data Warehouses. [Online]. http://datawarehouse.ittoolbox.com/documents/docum ent.asp?i=815 [Cited 19 January 2006].
  11. Hahne, M., 2002. Transformation mehrdimensionaler Modelle. In E von Maur and R Winter, eds. Vom Data Warehouse zum Corporate Knowledge Center. Heidelberg: Physica-Verlag, pp. 399-420.
  12. Herden, O., 2001. Eine Entwurfsmethodik für Data Warehouses. Dr. Universität Oldenburg.
  13. Holten, R., 1999. Entwicklung von Führungsinformationssystemen. Ein methodenorientierter Ansatz. Dr. Universität Münster.
  14. Jarke, M. et al., 1999. Architecture and Quality for Data Warehouses: An Extended Repository Approach. Information Systems, 24 (3), pp. 229-253.
  15. Kimball, R. and Ross, M., 2002. The Data Warehouse Toolkit. New York: John Wiley.
  16. Larman, C. and Basili, V. R., 2003. Iterative and Incremental Development: A Brief History. IEEE Computer, 36 (6), S. 4756.
  17. Lehner, W., 2003. Datenbanktechnologie für DataWarehouse-Systeme: Konzepte und Methoden. Heidelberg: dpunkt-Verlag.
  18. List, B. et al., 2002. A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse. Proceedings of the 13th international conference on Database and Expert Systems 2002 in Aix-en-Provence.
  19. Nordbotten, J. C. and Crosby, M. E., 1999. The effect of graphic style on data model interpretation. Information Systems Journal. 9 (2), pp. 139-155.
  20. Ong, H., 1999. The Evolution Of A Data Warehouse Architecture - One Size Fits All? [Online]. http://www.aurora-consult.com.au/white.html [Cited 19 January 2006].
  21. Ortner, E., 1995. Elemente einer methodenneutralen Konstruktionssprache für Informationssysteme. Informatik - Forschung und Entwicklung, 10 (3), pp. 148-160.
  22. Peralta, V. and Ruggia, R., 2003. Using Design Guidlines to improve Data Warehouse logical Design. [Online]. http://www.fing.edu.uy/inco/grupos/csi/esp/Cursos/cur sos_act/2003/DAP_SistDW/Material/DesGuidelinesVPRR.pdf [Cited 19 January 2006].
  23. Prakash, N. and Gosain, A., 2003. Requirements Driven Data Warehouse Development. Short Paper Proceedings of The 15th Conference on Advanced Information Systems Engineering 2003 in Klagenfurt / Velden.
  24. Quigley, E. J. and Debons, A., 1999. Interrogative Theory of Information and Knowledge. Proceedings of the ACM SIGCPR conference on Computer personnel research 1999 in San Diego.
  25. Quix, C. J., 2003. Metadatenverwaltung zur qualitätsorientierten Informationslogistik in DataWarehouse-Systemen. Dr. Technische Hochschule Aachen.
  26. Schelp, J., 2000. Modellierung multidimensionaler Datenstrukturen analyseorientierter Informationssysteme. Dr. Universität Bochum.
  27. Simitsis, A. and Vassiliadis, P., 2003. A Methodology for the Conceptual Modeling of ETL Processes. Decision Systems Engineering Workshop (DSE'03), in conjunction with the 15th Conference on Advanced Information Systems Engineering (CAiSE 7803) 2003 in Klagenfurt / Velden.
  28. Simitsis, A., 2003. Modeling and managing ETL Processes. Proceedings of the VLDB 2003 PHD Workshop 2003 in Berlin.
  29. Stahlknecht, P. and Hasenkamp, U., 2005. Einführung in die Wirtschaftsinformatik. 11. ed. Berlin et al.: Springer.
  30. Trujillo, J. and Lorán-Mora, S., 2003. A UML Based Approach for Modeling ETL Processes in Data Warehouses. Proceedings of the ER 2003 in Chicago.
  31. Valusek, J. R. and Fryback, D. G., 1985. Information requirements determination obstacles within, among and between participants. Proceedings of the twentyfirstannual conference on computer personnel research 1985 in Minneapolis.
  32. Vassiliadis, P., Simitsis, A. and Skiadopoulos, S., 2002a. Conceptual Modeling for ETL Processes. Proceedings of the 5th International Workshop on Data Warehousing and OLAP 2002 in McLean.
  33. Vassiliadis, P., Simitsis, A. and Skiadopoulos, S., 2002b. On the logical Modeling of ETL Processes. Proceedings of the 14th conference on advanced information Systems Engineering 2002 in Toronto.
  34. Vassiliou, Y. et al., 2000. Data Warehouse Research: Issues and Projects. In M Jarke et al., eds. Fundamentals of Data Warehouses. Berlin et al.: Springer, pp. 15- 21.
  35. Wand, Y. and Weber, R., 2002. Research Commentary: Information Systems and Conceptual Modeling - A Research Agenda. Information Systems Research, 13 (4), pp. 363-376.
  36. Winter, R. and Strauch, B., 2003. A Method for Demanddriven Information Requirements Analysis in Data Warehousing Projects. Proceedings of the 36th Hawai International Conference on Systems Science 2003 in Hawaii.
Download


Paper Citation


in Harvard Style

Burmester L. and Goeken M. (2006). METHOD FOR USER ORIENTED MODELLING OF DATA WAREHOUSE SYSTEMS . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 3: ICEIS, ISBN 978-972-8865-43-6, pages 366-374. DOI: 10.5220/0002456303660374


in Bibtex Style

@conference{iceis06,
author={Lars Burmester and Matthias Goeken},
title={METHOD FOR USER ORIENTED MODELLING OF DATA WAREHOUSE SYSTEMS},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 3: ICEIS,},
year={2006},
pages={366-374},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002456303660374},
isbn={978-972-8865-43-6},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 3: ICEIS,
TI - METHOD FOR USER ORIENTED MODELLING OF DATA WAREHOUSE SYSTEMS
SN - 978-972-8865-43-6
AU - Burmester L.
AU - Goeken M.
PY - 2006
SP - 366
EP - 374
DO - 10.5220/0002456303660374