ABSTRACT
Information requirements analysis for data warehouse systems differs significantly from requirements analysis for conventional information systems. Based on interviews with project managers and information systems managers, requirements for a methodological support of information requirements analysis for data warehouse systems are derived. Existing approaches are reviewed with regard to these requirements. Using the method engineering approach, a comprehensive methodology that supports the entire process of determining information requirements of data warehouse users, matching information requirements with actual information supply, evaluating and homogenizing resulting information requirements, establishing priorities for unsatisfied information requirements, and formally specifying the results as a basis for subsequent phases of the data warehouse development (sub)project has been proposed. The most important sources for methodology components were four in-depth case studies of information requirements analysis practices observed in data warehousing development projects of large organizations. In this paper, these case studies are presented and the resulting consolidated methodology is summarized. While an application of the proposed methodology in its entirety is still outstanding, its components have been successfully applied in actual data warehouse development projects.
- Beiersdorf, H.: Informationsbedarf und Informationsbedarfsermittlung im Problemlösungsprozess, Strategische Unternehmungsplanung" (vol. 5). Hampp: München, Mering 1995.Google Scholar
- Böhnlein, M., Ulbrich-vom Ende, A.: Business Process Oriented Development of Data Warehouse Structures, in: Jung, R., Winter, R. (Eds.): Data Warehousing 2000 - Methoden, Anwendungen, Strategien; Physica: Heidelberg 2000, 3--21.Google Scholar
- Brinkkemper, S., Lyytinen K. and Welke R.: Method Engineering, Chapman & Hall, London 1996.Google Scholar
- Connelly, R. A., McNeill, R., Mosimann, R. P.: The Multidimensional Manager. Cognos Inc.: Ottawa 1999.Google Scholar
- Finkelstein, C.: An Introduction to Information Engineering. Addison Wesley: Sydney etc. 1989. Google ScholarDigital Library
- Gardner, S.: Building the Data Warehouse. Communications of the ACM, 41 (1998), 9, 52--60. Google ScholarDigital Library
- Garzotto, A.: MASY - Ein Praxisbericht; Informatik /Informatique, 1999, 1, 16--19.Google Scholar
- Garzotto, A.:MASY - Ein Erfahrungsbericht zum Thema Data Warehouse, in: Jung, R., Winter, R. (Eds.): Data Warehousing Strategie. Springer: Berlin etc. 2000, 161--167.Google Scholar
- Grütter, G.: Data Warehouse-Strategie in der Logistik der Schweizer Armee, in: Jung, R., Winter, R. (Eds.): Data Warehousing Strategie. Springer: Berlin etc. 2000, 181--195.Google Scholar
- Hansen, W.-R.: Vorgehensmodell zur Entwicklung einer Data Warehouse-Lösung, in: Mucksch, H., Behme, W. (Eds.): Das Data Warehouse-Konzept. 2nd ed.; Gabler: Wiesbaden 1997, 311--328.Google Scholar
- IBM Corp.: Business Systems Planning - Information Systems Planning Guide. 4th ed., IBM-Form GE20-0527-4, Atlanta 1984.Google Scholar
- List, B., Schiefer, J., Tjoa, A. M.: Use Case Driven Requirements Analysis for Data Warehouse Systems, in: Jung, R., Winter, R. (Eds.): Data Warehousing 2000 - Methoden, Anwendungen, Strategien; Physica: Heidelberg 2000, 23--39.Google Scholar
- Rockart, J. F.: Chief executives define their own data needs; Harvard Business Review, 57 (1979) 2, 81--93.Google Scholar
- Schneider, D. H.: Führung & Darstellung der Logistik im 21. Jahrhundert, http://www.vbs.admin.ch/internet/GST/Uglog/d/projekte/IMAGES/it_logistikXXI. pdf, downloaded 2001-03-20.Google Scholar
- Strauch, B.: Entwicklung einer Methode für die Informationsbedarfsanalyse im Data Warehousing. Doctoral Thesis. University of St. Gallen, 2002.Google Scholar
- Winter, R.; Strauch, B.: A Method for Demand-driven Information Requirements Analysis in Data Warehousing Projects. Proceedings of the 36th Hawaii International Conference on System Sciences, IEEE 2003 Google ScholarDigital Library
Index Terms
- Information requirements engineering for data warehouse systems
Recommendations
MOQARE: misuse-oriented quality requirements engineering
This work presents MOQARE (misuse-oriented quality requirements engineering), a method to explore quality requirements. The aim of MOQARE is to support intuitive and systematic identification of quality requirements. It was developed by integrating and ...
Data warehouse requirements engineering: an emerging discipline
Though the origins of requirements engineering lie in software/information systems engineering, our study shows that requirements engineering in data warehouse systems is beginning to emerge as a stand-out, independent discipline. We show that failure ...
Comments