WASET
	%0 Journal Article
	%A X. Gumara Rigol and  I. Martínez de Apellaniz Anzuola and  A. Garcia Serrano and  A. Franzi Cros and  O. Vidal Calbet and  A. Al Maruf
	%D 2018
	%J International Journal of Computer and Information Engineering
	%B World Academy of Science, Engineering and Technology
	%I Open Science Index 142, 2018
	%T Big Brain: A Single Database System for a Federated Data Warehouse Architecture
	%U https://publications.waset.org/pdf/10009587
	%V 142
	%X Traditional federated architectures for data warehousing work well when corporations have existing regional data warehouses and there is a need to aggregate data at a global level. Schibsted Media Group has been maturing from a decentralised organisation into a more globalised one and needed to build both some of the regional data warehouses for some brands at the same time as the global one. In this paper, we present the architectural alternatives studied and why a custom federated approach was the notable recommendation to go further with the implementation. Although the data warehouses are logically federated, the implementation uses a single database system which presented many advantages like: cost reduction and improved data access to global users allowing consumers of the data to have a common data model for detailed analysis across different geographies and a flexible layer for local specific needs in the same place.
	%P 805 - 808