Abstract
A common taxonomy of data warehouse architectures comprises five basic approaches: Centralized, Independent Data Mart, Federated, Hub-and-Spoke and Data Mart Bus. However, for many real world cases, an applied data warehouse architecture can be their combination. In this paper we propose a Data Warehouse Architecture Reference Model (DWARM), which unifies known architectural styles and provides options for adaptation to fit particular purposes of a developed data warehouse system. The model comprises 11 layers grouping containers (data stores, sources and consumers), as well as processes, covering typical functional groups: ETL, data storage, data integration and delivery. Actual data warehouse architecture can be obtained by tailoring (removing unnecessary components) and instantiating (creating required layers and components of a given type).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Alsqour, M., Matouk, K., Owoc, M.L.: A survey of data warehouse architectures - preliminary results. In: 2012 Federated Conference on Computer Science and Information Systems (FedCSIS), pp. 1121–1126. IEEE (2012)
Ariyachandra, T., Watson, H.J.: Which data warehouse architecture is most successful? Business Intelligence Journal 11(1), 4 (2006)
Ariyachandra, T., Watson, H.J.: Key organizational factors in data warehouse architecture selection. Decision Support Systems 49(2), 200–212 (2010)
Connolly, T.M., Begg, C.E.: Database Systems: A Practical Approach to Design, Implementation, and Management. International computer science series. Addison-Wesley (2005), http://books.google.pl/books?id=jJbnDxiJ4joC
Dymek, D., Komnata, W., Kotulski, L., Szwed, P.: Data Warehouse Architectures. Reference model and formal architecture description. In: Polish: Architektury Hurtowni Danych. Model referencyjny i formalny opis architektury. AGH University of Science and Technology Press (2015)
Finlay, P.N.: Introducing decision support systems. NCC Blackwell (1994), http://books.google.pl/books?id=RhBPAAAAMAAJ
Golfarelli, M., Rizzi, S.: Data Warehouse Design: Modern Principles and Methodologies. Mcgraw-hill (2009), http://books.google.pl/books?id=VVRLa0dYmxoC
Inmon, W.H.: Building the Data Warehouse. Wiley (2005), http://books.google.pl/books?id=QFKTmh5IFS4C
Kimball, R., Margy, R.: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling. Wiley (2013), http://books.google.pl/books?id=WMEqTf2lK84C
Ponniah, P.: Data Warehousing Fundamentals. Wiley India Pvt. Limited (2006), http://books.google.pl/books?id=z4QjAw1YmxgC
Power, D.J.: A brief history of decision support systems (2007), http://dssresources.com/history/dsshistoryv28.html
Reeves, L.: A Manager’s Guide to Data Warehousing. Wiley (2009), http://books.google.pl/books?id=aCNxzTV0U3UC
Szmuc, T., Kotulski, L., Wojszczyk, B., Sedziwy, A.: Green AGH campus. In: SMARTGREENS 2012 - Proceedings of the 1st International Conference on Smart Grids and Green IT Systems, Porto, Portugal, April 19 - 20, pp. 159–162 (2012)
Szwed, P.: Belief propagation during data integration in a P2P network. In: Rutkowski, L., Korytkowski, M., Scherer, R., Tadeusiewicz, R., Zadeh, L.A., Zurada, J.M. (eds.) ICAISC 2014, Part I. LNCS (LNAI), vol. 8467, pp. 805–816. Springer, Heidelberg (2014), http://dx.doi.org/10.1007/978-3-319-07173-2_69
Turban, E.: Decision Support and Expert Systems: Management Support Systems. MacMillan Series in Information Systems. Macmillan (1990), http://books.google.pl/books?id=k2ZaAAAAYAAJ
Yourdon, E.: Modern Structured Analysis, 2nd edn. Prentice Hall PTR, Upper Saddle River (2000)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Dymek, D., Komnata, W., Szwed, P. (2015). Proposal of a New Data Warehouse Architecture Reference Model. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. BDAS 2015. Communications in Computer and Information Science, vol 521. Springer, Cham. https://doi.org/10.1007/978-3-319-18422-7_19
Download citation
DOI: https://doi.org/10.1007/978-3-319-18422-7_19
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-18421-0
Online ISBN: 978-3-319-18422-7
eBook Packages: Computer ScienceComputer Science (R0)