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.
Kopie  (Senden Sie ein Email mit  Neum13a  als Betreff an um diese Kopie zu erhalten)

Kurzfassung (Englisch)

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