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

B. Neumayr, C. Schütz, M. Schrefl
Neum13a (2013)
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.
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