News

Habilitation of Assist.-Prof. Mag. Dr. Christoph Georg Schütz


IT-Project Data Souvereignty in winter termin 2021/22


Business Intelligence: Washing Gold in Times of Information Overload


See all news.


Campusplan

campusplan_image

You can find us here.




From Federated Databases to a Federated Data Warehouse System

Authors: S. Berger, M. Schrefl
Paper: Berg08a (2008)
Citation: Proceedings of the 41st Hawaii International Conference on System Sciences (HICSS-41 2008) - Organizational Systems and Technology Track, Data Warehousing and Business Intelligence Minitrack, Waikoloa, Big Island, Hawaii, January 7-10, 10 pages, ISSN 1530-1605, pp. 394, 2008.
Resources: Copy  (In order to obtain the copy please send an email with subject  Berg08a  to dke.win@jku.at)


Abstract:

Although Data Warehousing is regarded as a mature technology now, the definition of a federated architecture for Data Warehouse (DW) integration remains an open research question. This paper identifies requirements on a Federated DW System and proposes an architecture supporting the tightly coupled integration of heterogeneous data marts into a global, logical schema. In order to enable the processing of queries in the federation, our approach provides a Dimension Algebra (DA) and Fact Algebra (FA) to define the mappings between the global and local schemas. Moreover, we demonstrate how to apply DA and FA expressions for dimension and fact integration and explain the benefits of such an approach.