Using Domain Ontologies as Semantic Dimensions in Data Warehouses

S. Anderlik, B. Neumayr, M. Schrefl
Ande12a (2012)
Paolo Atzeni, David W. Cheung, Sudha Ram (Eds.): Proceedings of the 31st International Conference on Conceptual Modeling (ER 2012), Florence, Italy, October 15-18, Springer Verlag, Lecture Notes in Computer Science (LNCS Vol. 7532), ISBN 978-3-642-34001-7, pp. 88-101, 2012.
Copy  (In order to obtain the copy please send an email with subject  Ande12a  to

Abstract (English)

More and more transaction systems collect records that reference concepts of domain ontologies in so-called semantic attributes. This paper investigates how such semantic attributes together with their referenced domain ontology can be best exploited for data analysis in data warehouses. This gives rise to two challenges: first, exploit the rich knowledge represented in domain ontologies for targeted analysis and, second, aggregate data along the subsumption hierarchy of concepts and ensuring summarizability in the absence of predefined aggregation levels. To meet these challenges, the paper extends OLAP (OnLine Analytical Processing) by integrating concept expressions and proper level definitions over domain ontologies into OLAP operations. A prototype demonstrates the feasibility of the approach.