Bernd Neumayr, Michael Schrefl, Bernhard Thalheim,
"Hetero-Homogeneous Hierarchies in Data Warehouses"
, in Sebastian Link, Aditya K. Ghose: Proceedings of the Seventh Asia-Pacific Conference on Conceptual Modelling (APCCM 2010), Brisbane, Australia, January 2010, Serie Conferences in Research and Practice in Information Technology, Vol. 110, Springer Verlag, Publication received Best Paper and Best Student Paper Award., Seite(n) 61-70, 1-2010, ISBN: 978-3-642-17505-3
Hetero-Homogeneous Hierarchies in Data Warehouses
Sprache des Titels:
Proceedings of the Seventh Asia-Pacific Conference on Conceptual Modelling (APCCM 2010), Brisbane, Australia, January 2010
Data Warehouses facilitate multi-dimensional analysis of data from various data sources. While the original data sources are often heterogeneous, current modeling and implementation techniques discard and, thus, cannot exploit these heterogeneities.
In this paper we introduce Hetero-Homogeneous Hierarchies to model dimension hierarchies and cubes with inherent heterogeneities. Hetero-homogeneous hierarchies are hierarchies that are heterogeneous in regard to the schema of sub-hierarchies and homogeneous in regard to a minimal common schema shared by all sub-hierarchies.
Sub-dimension-hierarchies can be specialized to contain additional levels and additional non-dimensional attributes. Sub-cubes can be specialized towards additional measures, more fine-grained facts, and differing units of measure. We show how scale differences and conflicts due to multi-dimensional inheritance can be avoided and solved. We provide a formal definition of our approach together with a query/cube algebra.
Sprache der Kurzfassung:
Publication received Best Paper and Best Student Paper Award.
Conferences in Research and Practice in Information Technology
Anzahl der Seiten:
Notiz zur Publikation:
If you are interested in the paper, you may receive a copy (PDF) by sending an e-mail to our office (firstname.lastname@example.org). Please include the paper-no. (Neum10a) and agree to use the paper for scientific purposes and private use only!