News

Student tutors for the course Data Modelling wanted (winter term 2021/22)


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.




Federated Data Warehouses

Authors: S. Berger, M. Schrefl
Paper: Berg09a (2009)
Citation: Nguyen Manh Tho (Ed.): Complex Data Warehousing and Knowledge Discovery for Advanced Retrieval Development: Innovative Methods and Applications, IGI Publishing, Hershey, PA, ISBN 978-1605667485, pp. 82-107, July 2009.
Resources: Copy  (In order to obtain the copy please send an email with subject  Berg09a  to dke.win@jku.at)


Abstract:

Federated Data Warehouses are a collection of autonomous and often heterogeneous Data Marts (DM). When attemping to integrate autonomous DMs, data designers commonly face numerous conflicts that must be repaired. This book chapter analyzes and classifies the conflicts at the schema and instance level among dimensions and cubes in a systematic way, based on a formal data model. It shows the dependencies between dimension and cube integration and presents a methodological DM integration approach. A running example demonstrates how to repair the various heterogeneities. Moreover, the chapter introduces a Federated DW reference architecture enabling tightly coupled integration of autonomous DMs.