Skip to main content

Framework and Method for Information Warehouse Development Processes

  • Conference paper
Data Warehousing 2000

Abstract

Management’s information requirements must be the focus of interest in any Data Warehouse based ROLAP system development process. For that reason the concepts required for the conceptual specification of ROLAP systems defining management’s information requirements and suitable representation formalisms supporting these concepts must be provided. Additionally an integrated framework is needed that depicts how these concepts and representations can be used in the sense of a methodically integrated development process focussing on both conceptual and implementational development phases. This framework is then used as basis for the implementation of tools supporting the methodical approach presented.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 54.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  • Agarwal, S.; Agrawal, R.; Deshpande, P. M.; Gupta, A.; Naughton, J. F.; Ramakrishnan, R., Sarawagi; S.: On the computation of multidimesnional aggregates. Proc. 22nd International Conference on Very Large Data Bases, San Francisco, CA, Morgan Kaufmann, 1996, pp. 506–521.

    Google Scholar 

  • Agrawal, R.; Gupta, A.; Sarawagi, S.: Modeling multidimensional databases. Proc. 13th International Conference on Data Engineering, Los Alimatos, CA, IEEE Computer Society Press, 1997, pp. 232-243.

    Google Scholar 

  • Balzert, H. (1996a): Lehrbuch der Software-Technik. Software Entwicklung. Heidelberg et al. 1996.

    Google Scholar 

  • Balzert, H. (1996b): From OOA to GUIs: The JANUS system. Journal of Object-Oriented Programming, (1996) 2, pp. 43–47.

    Google Scholar 

  • Becker, J.; Holten, R.: Fachkonzeptuelle Spezifikation von Führungsinformationssystemen. Wirtschaftsinformatik 40 (1998) 6, pp. 483–492.

    Google Scholar 

  • Boehm, B.: Software-Engineering Economics. Pretnice Hall 1981.

    Google Scholar 

  • Chamoni, P.; Gluchowski, P.: Analytische Informationssysteme. Einordnung und Ãœberblick. In: P. Chamoni, P. Gluchowski (Hrsg.), Analytische Informationssysteme. Berlin, Heidelberg 1998, S. 3-25.

    Google Scholar 

  • Chaudhuri, S.; Dayal, U.: An overview of data warehousing and OLAP technology. ACM SIGMOD Record, 26 (1997) 1, pp. 65–74.

    Article  Google Scholar 

  • Codd, E. F.: The Relational Model for Database Management. Version 2. Reading, MA, Addison-Wesley, 1990.

    Google Scholar 

  • Codd, E. F.; Codd, S. B.; Salley, C. T.: Providing OLAP (On-Line Analytical Processing) to User Analysts: An IT Mandate. White Paper, E. F. Codd & Asociates, 1993. http://www.arborsoft.com/essbase/wht_ppr/coddTOC.html, downloaded 1998-06-05.

    Google Scholar 

  • Colliat, G.: OLAP, relational, and multidimensional database systems. ACM SIGMOD Record 25 (3), pp.64-69.

    Google Scholar 

  • Date, C. J.: An Introduction to Database Systems. Volume 1. 5th ed. Reading, MA, Addison-Wesley, 1990.

    Google Scholar 

  • Davis, A. M.: The Analysis and Specification of Systems and Software Requirements. In: R. H. Thayer, M. Dorfman (Eds.): Systems and Software Requirements Engineering, IEEE Computer Society Press-Tutorial 1990, pp.119-134.

    Google Scholar 

  • Davis, A. M.; Bersoff, E. H.; Comer, E. R.: A Strategy for Comparing Alternative Software Development Life Cycle Models. IEEE Transactions on Software Engineering 10(14) 1988, pp. 1453–1461.

    Article  Google Scholar 

  • Embley, D. W.: Object Database Development. Concepts and Principles. Reading, MA. Addison-Wesley, 1998.

    Google Scholar 

  • ETI: In-Depth. Meeting the challange of EAI with the ETI EXTRACT FX Tool Suite. http://www.eti.com/infocenter/pdf/indepth_eai_and_fax.pdf. Download 1999.08.23.

    Google Scholar 

  • Golfarelli, M.; Maio, D.; Rizzi, S.: Conceptual Design of Data Warehouses from E/R Schemes. Proceedings of the Hawaii International Conference On Systems Science, January 6–9, IEEE 1998.

    Google Scholar 

  • Gupta, A.; Horowitz, E.: Object-Oriented Databases with Applications to CASE, Networks, and VLSI CAD. Englewood-Cliffs, NJ. Prentice-Hall 1991.

    Google Scholar 

  • Gyssens, M.; Lakshmanan, L. V. S.: A foundation for multi-dimensional databases. Proc. 23th International Conference on Very Large Data Bases, San Francisco, CA, Morgan Kaufmann, 1997, pp. 106–115.

    Google Scholar 

  • Holten, R.: Entwicklung von Führungsinformationssystemen. Ein methodenorientierter Ansatz. Wiesbaden 1999.

    Google Scholar 

  • Holten, R.; Knackstedt, R.: Fachkonzeptuelle Modellierung von Führungsinformationssystemen am Beispiel eines filialisierenden Einzelhandelsunternehmens. In: E.J. Sinz et al. (Hrsg.): Tagungsband MobIS’ 99 Rundbrief Informationssystem-Architekturen des FA 5.2. Oktober 1999.

    Google Scholar 

  • IEEE-830: Guide to Software Requirements Specification. ANSI/IEEE Std. 830, 1984.

    Google Scholar 

  • Informatica: PowerMart 4.6 PowerCenter 1.6: Getting Started, Transformation Language References, Administration Guide, User Guide. Informatica Corporation 1996–1999.

    Google Scholar 

  • Inmon, W. H.: Building the Data Warehouse. 2nd ed., Wiley, New York et al. 1996.

    Google Scholar 

  • Inmon, W. H.; Hackathorn, R. D.: Using the Data Warehouse. Wiley, New York et al. 1994.

    Google Scholar 

  • Inmon, W. H.; Welch, J. D.; GlAsey, K. L.: Managing the Data Warehouse. New York et al. 1997.

    Google Scholar 

  • ISO: ISO/IEC 10027: Information Technology. Information Resource Dictionary Systems (IRDS)-Framework. ISO/IEC Intl. Standard, 1990.

    Google Scholar 

  • Jacobs, S.; Holten, R.: Goal Driven Business Modeling. Supporting Decision Making within Information Systems Development. In: N. Comstock, C. Ellis, R. Kling, J. Mylopoulos, S. Kaplan (Hrsg.): Conference on Organizational Computing Systems, August 13–16, 1995, Milipatis, California, U.S.A. acm Press 1995, S. 96-105.

    Google Scholar 

  • Jarke, M.; Pohl, K.; Jacobs, S.; Bubenko, J.; Asenova, P.; Holm, P.; Wangler, B.; Rolland, C.; Plihon, V.; Schmitt, R.; Sutcliffe, A.; Jones, S.; Maiden, N, Till, D.; Vasiliou, Y.; Constantopoulos, P.; Spanoudakis, G.: Requirements Engineering. An Integrated View of Representation, Process and Domain. Proc. of the Fourth European Software Engineering Conference, Garmisch-Partenkirchen, Germany, Springer-Verlag 1993, pp. 100–114.

    Google Scholar 

  • Jarke, M.; Lenzerini, M.; Vassiliou Y.; Vassiliadis, P.: Fundamentals of Data Warehouse. Berlin et al. 2000.

    Google Scholar 

  • Kambartel, F.: Stufe (Level) In: Mittelstraß (Ed.): Enzyklopädie Philosophie und Wissenschaftstheorie, Band 4. Stuttgart, Weimar 1996, p. 116.

    Google Scholar 

  • Kimbal, R.: The Data Warehouse Toolkit. Wiley, New York et al. 1996.

    Google Scholar 

  • Lorenz, K. (Meta Language): Metasprache. In: J. Mittelstraß (Ed.): Enzyklopädie Philosophie und Wissenschaftstheorie, Band 2. Stuttgart, Weimar 1995, p. 875.

    Google Scholar 

  • Lorenz, K. (Object Language): Objektsprache. In: J. Mittelstraß (Ed.): Enzyklopädie Philosophie und Wissenschaftstheorie, Band 2. Stuttgart, Weimar 1995, pp. 1054–1055.

    Google Scholar 

  • McMenamin, S. M.; Palmer, J. F.: Essential System Analysis. Yourdon Press, Prentice Hall. Englewood Cliffs, NY, 1984.

    Google Scholar 

  • MicroStrategy: Data Warehouse and DSS Management Tools. DSSAdministrator-User Guide. Version 5.0. MicroStrategy Inc. 1997.

    Google Scholar 

  • MicroStrategy: Relational OLAP Interface. DSSAgent-User Guide. Version 5.6. MicroStrategy Inc. 1999.

    Google Scholar 

  • MicroStrategy: Relational OLAP Interface. DSSAgent-Advanced Topics. Version 5.6. MicroStrategy Inc. 1999.

    Google Scholar 

  • MicroStrategy: DSS Design Tool. DSSArchitect — User Guide. Version 5.6. MicroStrategy Inc. 1999.

    Google Scholar 

  • MicroStrategy: EIS Design Tool. DSSExecutive — User Guide. Version 5.5. MicroStrategy Inc. 1998.

    Google Scholar 

  • MicroStrategy: Relational OLAP Server. DSSServer-User Guide. Version 5.6. MicroStrategy Inc. 1999.

    Google Scholar 

  • MicroStrategy: Relational OLAP Interface for the Web. DSSWeb — User Guide. Version 5.5. MicroStrategy Inc. 1999.

    Google Scholar 

  • Mucksch, H.; Behme, W.: Das Data Warehouser-Konzept als Basis einer unternehmensweiten Informationslogistik. In: H. Mucksch, W. Behme (Hrsg.), Das Data Warehouse-Konzept. 3. Aufl. Wiesbaden 1998, S. 33-100.

    Google Scholar 

  • Nagl, M.: Softwaretechnik. Methodisches Programmieren im Großen. Berlin, Heidelberg 1990.

    Google Scholar 

  • Nissen, H. W.; Jeusfeld, M.; Jarke, M.; Zemanek, G. V.; Huber, H.: Managing Multiple Requirements Perspectives with Metamodels. IEEE Software, 13 (1996) 3, pp. 37–48.

    Article  Google Scholar 

  • OLAP Council: OLAP and OLAP Server Definitions. http://www.olapcouncil.org/research/glossaryly.htm 1997, downloaded 1998-06-03.

    Google Scholar 

  • Paller, A.; Laska, R.: The EIS-Book. Information Systems for Top-Managers, Homewood, Ill. 1990.

    Google Scholar 

  • Pohl, K.: Process-Centered Requirements Engineering. Research Studies Press, Taunton, Somerset 1996.

    Google Scholar 

  • Riebel, P.: Gestaltungsprobleme einer zweckneutralen Grundrechnung. In: ZfbF 31 (1979), S. 863–893.

    Google Scholar 

  • Rockart, J. F.; De Long, D. W.: Executive Support Systems: The Emergence of Top Management Computer Use, Homewood, Ill. 1988.

    Google Scholar 

  • Rockart, J. F.; Treacy, M. E.: The CEO goes On-Line. HBR 60 (1982). reprint: H. J. Watson; R. K. Rainer; G. Houdeshel (Hrsg.), Executive Information Systems: Emergence Development Impact. New York et al. 1992. S. 3-12.

    Google Scholar 

  • Sapia, C.; Blaschka, M.; Höfling, G.: GraMMi: Using a Standard Repository Management System to Build a Generic Graphical Modeling Tool. Proceedings 33rd Hawaii International Conference on System Sciences (HICSS-33), Maui, Hawaii, USA 2000.

    Google Scholar 

  • Schinzer, H.; Bange, C.; Mertens, H.: Data Warehouse und Data Mining. Marktführende Produkte im Vergleich. 2. Aufl., München 1999.

    Google Scholar 

  • Stöhr, T.; Müller, R.; Rahm, E.: An Integrative and Uniform Model for Metadata Management in Data Warehousing Environments. In.: S. Gatztiu, M. Jeusfeld, M. Staudt, Y-VAsiliou (Hrsg.): Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW’99). http://sunsite.informatik.rwth-aachen.de/Publications/CEUR-WS/Vol-19, downloaded 1999-07-12.

    Google Scholar 

  • Vassiliadis, P.; Sellis, T.: A Survey of Logical Models for OLAP Databases. Sigmod Record 28(4), S. 64–69, 1999.

    Article  Google Scholar 

  • Weske, M.; Goesmann, T.; Holten, R.; Striemer, R.: A Reference Model for Workflow Application Development Processes. Proc. of International Joint Conference on Work Activities Coordination and Collaboration (WACC), San Francisco, CA 1999. ACM, pp. 1-10.

    Google Scholar 

  • Widom, J.: Research problems in data warehousing. Proc. 4th International Conference on Information and Knowledge Management. New York: ACM 1995.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Holten, R. (2000). Framework and Method for Information Warehouse Development Processes. In: Jung, R., Winter, R. (eds) Data Warehousing 2000. Physica, Heidelberg. https://doi.org/10.1007/978-3-642-57681-2_8

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-57681-2_8

  • Publisher Name: Physica, Heidelberg

  • Print ISBN: 978-3-642-63326-3

  • Online ISBN: 978-3-642-57681-2

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics