A Layered Architecture for Enterprise Data Warehouse Systems

  • Thorsten Winsemann
  • Veit Köppen
  • Gunter Saake
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 112)


The architecture of Data Warehouse systems is described on basis of so-called reference architectures. Today’s requirements to Enterprise Data Warehouses are often too complex to be satisfactorily achieved by the rather rough descriptions of this reference architecture. We describe an architecture of dedicated layers to face those complex requirements, and point out additional expenses and resulting advantages of our approach compared to the traditional one.


Data Warehouse Head Data Layered Architecture Reference Architecture Propagation Layer 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. 1.
    Devlin, B.A., Murphy, P.T.: An architecture for a business and information system. IBM Systems Journal 27(1), 60–80 (1988)CrossRefGoogle Scholar
  2. 2.
    Watson, H.J., Ariyachandra, T.: Data Warehouse Architectures: Factors in the Selection and the Success of the Architectures (2005), (call April 01, 2012)
  3. 3.
    Hajmoosaei, A., Kashfi, M., Kailasam, P.: Comparison plan for data warehouse system architectures. In: 3rd ICMiA Proceedings, pp. 290–293 (2011)Google Scholar
  4. 4.
    Golfarelli, M., Rizzi, S.: Data Warehouse Design: Modern Principles and Methodologies. McGraw-Hill (2009)Google Scholar
  5. 5.
    Poe, V.: Building a Data Warehouse for decision support. Prentice Hall (1996)Google Scholar
  6. 6.
    Chamoni, P., Gluchowski, P. (eds.): Analytische Informationssysteme. Springer (2006)Google Scholar
  7. 7.
    Muksch, H., Behme, W. (eds.): Das Data-Warehouse-Konzept. Gabler (2000)Google Scholar
  8. 8.
    Zeh, T.: Referenzmodell für die Architektur von Data-Warehouse-Systemen (Referenzarchitektur) (2008), (call April 01, 2012)
  9. 9.
    Lehmann, P.: Meta-Datenmanagement in Data-Warehouse-Systemen. PhD Thesis, University of Magdeburg (2001)Google Scholar
  10. 10.
    Leser, U., Naumann, F.: Informationsintegration. dpunkt (2007)Google Scholar
  11. 11.
    SAP AG: Layered, Scalable Architecture (LSA) for BW, Training Material (2009)Google Scholar
  12. 12.
    Lehner, W.: Datenbanktechnologie für Data-Warehouse-Systeme. dpunkt (2003)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2012

Authors and Affiliations

  • Thorsten Winsemann
    • 1
    • 2
  • Veit Köppen
    • 2
  • Gunter Saake
    • 2
  1. 1.SAP Deutschland AG & Co. KGHamburgGermany
  2. 2.Otto-von-Guericke UniversitätMagdeburgGermany

Personalised recommendations