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.




Incremental Integration of Data Warehouses: The Hetero-Homogeneous Approach

Authors: C. Schütz, M. Schrefl, B. Neumayr, D. Sierninger
Paper: Schu11a (2011)
Citation: Proceedings of the ACM Fourteenth International Workshop on Data Warehousing and OLAP (DOLAP 2011), Glasgow, Scotland, U.K., October 28, 2011, ISBN 978-1-4503-0963-9, pp. 25-30, 2011.
Resources: Copy  (In order to obtain the copy please send an email with subject  Schu11a  to dke.win@jku.at)


Abstract:

As organizations grow, decision support systems face a surging demand for information; information that must be integrated into the corporate data warehouse. Incremental integration allows for a gradual evolution of data warehouse schemas.

Heterogeneous schemas complicate the integration task. Traditional modeling approaches require heterogeneities in the data warehouse schema to be eliminated, or they lack expressiveness when capturing heterogeneous information. When dwelling on homogeneous schemas, however, valuable information is lost. In contrast, the hetero-homogeneous modeling approach preserves the clarity of homogeneous schemas while offering the flexibility that is needed to model large companies with diverse sub-entities.

In this paper, we demonstrate the application of well-accepted object-oriented design principles to data warehousing. We examine the incremental integration of data warehouses, and we sketch the fundamentals of our prototype implementation. Following the hetero-homogeneous approach, we preserve schema heterogeneities as much as possible while avoiding common pitfalls of heterogeneous data warehouse modeling.