Bernd Neumayr, Christoph Georg Schütz, Michael Schrefl,
"Semantic Enrichment of OLAP Cubes: Multi-dimensional Ontologies and their Representation in SQL and OWL"
, in Pieter De Leenheer, Deijing Dou: Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013, Serie Lecture Notes in Computer Science (LNCS), Vol. 8186, 9-2013, ISBN: 978-3-642-41032-1
Original Titel:
Semantic Enrichment of OLAP Cubes: Multi-dimensional Ontologies and their Representation in SQL and OWL
Sprache des Titels:
Englisch
Original Buchtitel:
Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013
Original Kurzfassung:
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