Skip to main content
SpringerLink
Log in

Management Report Engineering — A Swiss Re Business Case

  • Conference paper
Vom Data Warehouse zum Corporate Knowledge Center

Zusammenfassung

Defining and structuring management views is a fundamental task of the specification of data marts and reporting systems. Today such systems are based on data warehouses. A data warehouse stores materialized views on business processes to support the management’s information requirements (cf. Inmon 1996; Inmon, Hackathorn 1994; Inmon et al. 1997). It is located on a central layer of an idealized layer oriented architecture connecting online transaction processing (OLTP) systems and components enabling online analytical processing (OLAP) (cf. Becker, Holten 1998; Chaudhuri, Dayal 1997). The latter components are intended to support navigations adequate for management users through so called multi dimensional information spaces. OLTP systems directly support the business processes and are the sources of data used by OLAP systems. Typically, the integration of OLTP systems and the data warehouse is based on tools performing so called extraction, transformation and loading tasks (ETL) (cf. Inmon 1996; Widom 1995)

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 69.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 119.00
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 89.99
Price excludes VAT (USA)
  • Durable hardcover 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.

Reference

  • 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 

  • Bauer, A.; Huemmer, W.; Lehner, W.: An Alternative Relational OLAP Modeling Approach. Second International Conference on Data Warehousing and Knowledge Discovery (DAWAK 2000, London, U.K., September 4–6), pp. 189–198

    Google Scholar 

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

    Google Scholar 

  • Blaschka, M.; Sapia, C.; Höfling, G.; Dinter, B.: Finding Your Way through Multidimensional Data Models. Proceedings of the International Workshop on Data Warehouse Design and OAP Technology (DWDOT 1998), Vieanna, Austria, August 28, 1998, pp. 198–203

    Google Scholar 

  • Böhnlein, M.: Konstruktion semantischer Data-Warehouse-Schemata. Deutscher Universitäts-Verlag, Wiesbaden 2001

    Book  Google Scholar 

  • Borgman, H.P.: Manager’s information search behaviour using Management Support Systems. Wirtschaftsinformatik 40 (1998), 6, pp. 527–535

    Google Scholar 

  • Brealey, R.A.; Myers, S.C.: Principles of Corporate Finance. 5th ed. McGraw-Hill Companies, Inc., New York et al. 1996

    Google Scholar 

  • Bulos, D.: OLAP Database Design. A New Dimension. Database Programming & Design (DBPD), Vol. 9, No. 6, June 1996, pp. 33–37

    Google Scholar 

  • Cabibbo, L.; Torlone, R.: An Architecture for Data Warehousing Supporting Data Independence and Interoperability. International Journal of Cooperative Information Systems, Vol. 10, No. 3 (2001), pp. 377–397

    Article  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.; 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 

  • Copeland T.; Koller, T.; Murrin, J.: Valuation: Measuring and Managing the Value of Companies. John Wiley&Sons, New York et al. 1990

    Google Scholar 

  • Eccles, R.G.: The performance measurement manifesto. Harvard Business Review, 69 (1991) January-February, pp. 131–137

    Google Scholar 

  • Ferstl, O.K.; Sinz, E. J.: Grundlagen der Wirtschaftsinformatik. Band 1. 4. Aufl., Oldenbourg, München 2001

    Google Scholar 

  • Golfarelli, M.; Maio, D.; Rizzi, S. (A): The Dimensional Fact Model: A Conceptual Model for Data Warehouses. International Journal of Cooperative Information Systems, vol. 7, n. 2–3, 1998

    Article  Google Scholar 

  • Golfarelli, M.; Maio, D.; Rizzi, S. (B): 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 

  • Golfarelli, M.; Rizzi, S.: A Methodological Framework for Data Warehouse Design. In Proceedings ACM First International Workshop on Data Warehousing and OLAP (DOLAP), Washington, 1998

    Google Scholar 

  • Golfarelli, M.; Rizzi, S: Designing the data warehouse: Key steps and crucial issues. Journal of Computer Science and Information Management, vol. 2, n. 3, 1999

    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.: Framework and Method for Information Warehouse Development Processes. In: Jung, R.; Winter, R. (Hrsg.): Data Warehousing 2000 — Methoden, Anwendungen, Strategien. Heidelberg 2000, S. 135–163

    Chapter  Google Scholar 

  • Holten, R.: The MetaMIS Approach for the Specification of Management Views on Business Processes. In: Becker, J.; Grob, H.L.; Müller-Funk, U.; Klein, S.; Kuchen, H.; Vossen, G.: Arbeitsberichte des Instituts fir Wirtschaftsinformatik Nr. 84, Münster 2001

    Google Scholar 

  • Holten, R.: Specification of Management Views in Information Warehouse Projects. In: Becker, J.; Grob, H.L.; Müller-Funk, U.; Vossen, G.: Arbeitsberichte des Instituts für Wirtschaftsinformatik Nr. 87, Münster 2002

    Google Scholar 

  • Holten, R.; Dreiling, A.: Specification of Fact Calculations within the MetaMIS Approach. In: Becker, J.; Grob, H.L.; Müller-Funk, U.; Vossen, G.: Arbeitsberichte des Instituts fir Wirtschaftsinformatik Nr. 88, Münster 2002

    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 

  • Inmon, W.H.; Zachman, J.A.; Geiger, J.G.: Data Stores, Data Warehousing and the Zach-man Framework. Managing Enterprise Knowledge. New York et al. 1997

    Google Scholar 

  • Jarke, M.; Jeusfeld, M.A.; Quix, C.; Vassiliadis, P.: Architecture and Quality in Data Warehouses: An extended Repository Approach. Information Systems 24 (1999) 3, pp. 229–253

    Article  Google Scholar 

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

    Google Scholar 

  • Kaplan, R.S.; Norton, D.P.: The Balanced Score Card. Measures that Drive Business Performance. Harvard Business Review, 70 (1992) January-February, pp. 71–79

    Google Scholar 

  • Kaplan, R.S.; Norton, D.P.: Translating Strategy into Action. The Balanced Scorecard. Boston, Mass. 1996

    Google Scholar 

  • Kaplan, R.S.; Norton, D.P.: Why Does Business Need a Balanced Scorecard? Journal of Cost Management, 11 (1997) 3, pp. 5–10

    Google Scholar 

  • Lapsley, I.; Mitchel, F.: The Accounting Challenge: Accounting and Performance Measurement. London 1996

    Google Scholar 

  • Lechtenbörger, J.: Data Warehouse Schema Design. Akademische Verlagsgesellschaft Aka. Berlin 2001

    Google Scholar 

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

    Google Scholar 

  • Riebel, P.: Einzelerlös-, Einzelkosten-und Deckungsbeitragsrechung als Kern einer ganzheitlichen Führungsrechung. In: Männel, W. (Hrsg.): Handbuch Kostenrechnung. Wiesbaden 1992, S. 247–299

    Chapter  Google Scholar 

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

    Google Scholar 

  • Sapia, C.; Blaschka, M.; Höfling, G.; Dinter, B.: Extending the E/R Model for the Multidimensional Paradigm. Proceedings of the International Workshop on Data Warehouse and Data Mining (DWDM 1998) Singapore, November 19–20 1998, Springer 1998, pp. 105–116

    Google Scholar 

  • Vassiliadis, P.: 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), Stockholm, Sweden, June 5–6, 2000, http://SunSITE.Informatik.RWTH-Aachen.DE/Publications/CEUR-WSNol-28/

    Google Scholar 

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

    Article  Google Scholar 

  • Wedekind, H.; Albrecht, J.; Günzel, H.; Lehner, W.: Repositories for Data Warehouse Systems in a Middleware Environment. Fifth International Conference on Information Systems Analysis and Synthesis (ISAS’99, Orlando, Florida, July 31 — August 4 1999)

    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

  1. Universität Münster, UK

    Roland Holten & Alexander Dreiling

Authors
  1. Roland Holten
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Alexander Dreiling
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Benedikt Schmid
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institut für Wirtschaftsinformatik, Universität St. Gallen, Müller-Friedberg-Straße 8, 9000, St. Gallen, Schweiz

    Eitel von Maur  & Robert Winter  & 

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Holten, R., Dreiling, A., Schmid, B. (2002). Management Report Engineering — A Swiss Re Business Case. In: von Maur, E., Winter, R. (eds) Vom Data Warehouse zum Corporate Knowledge Center. Physica, Heidelberg. https://doi.org/10.1007/978-3-642-57491-7_24

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-57491-7_24

  • Publisher Name: Physica, Heidelberg

  • Print ISBN: 978-3-642-63276-1

  • Online ISBN: 978-3-642-57491-7

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation