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.



You can find us here.

Semantic Enrichment of OLAP Cubes: Multi-dimensional Ontologies and their Representation in SQL and OWL

Authors: B. Neumayr, C. Schütz, M. Schrefl
Paper: Neum13a (2013)
Citation: On the Move to Meaningful Internet Systems, OTM 2013 Conferences, Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013, Pieter De Leenheer, Deijing Dou (eds.), Springer Verlag, Lecture Notes in Computer Science (LNCS Vol. 8185), ISBN 978-3-642-41032-1, pp. 624-641, 2013.
Resources: Copy  (In order to obtain the copy please send an email with subject  Neum13a  to

Abstract (English):

A multi-dimensional ontology (MDO) enriches an OLAP cube with concepts that represent business terms in the context of data analysis. The formal representation of the meaning of business terms facilitates the unambiguous interpretation of query results as well as the sharing of knowledge among business analysts. In contrast to traditional ontologies, an MDO captures the multi-dimensional, hierarchical world view of business analysts. In this paper, we introduce a translation of MDO concepts to SQL in order to allow for the querying of a closedworld OLAP cube. We introduce a representation in OWL in order to determine subsumption hierarchies of MDO concepts using off-the-shelf reasoners.

Keywords: Business Intelligence, OLAP, Data Warehouse, Knowledge Representation and Reasoning