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

Bernd Neumayr; Christoph Georg Schütz; Michael Schrefl

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

Institute of Business Informatics - Data & Knowledge Engineering

Research output: Chapter in Book/Report/Conference proceeding › Conference proceedings › peer-review

Abstract

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

Original language	English
Title of host publication	Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013
Editors	Pieter De Leenheer, Deijing Dou
Number of pages	18
Volume	8186
Publication status	Published - Sept 2013

Publication series

Name	Lecture Notes in Computer Science (LNCS)

Fields of science

102 Computer Sciences
102015 Information systems
502 Economics
509 Other Social Sciences

JKU Focus areas

Computation in Informatics and Mathematics
Management and Innovation

Cite this

Neumayr, B., Schütz, C. G., & Schrefl, M. (2013). Semantic Enrichment of OLAP Cubes: Multi-dimensional Ontologies and their Representation in SQL and OWL. In Pieter De Leenheer, Deijing Dou (Ed.), Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013 (Vol. 8186). (Lecture Notes in Computer Science (LNCS)).

Neumayr, Bernd ; Schütz, Christoph Georg ; Schrefl, Michael. / Semantic Enrichment of OLAP Cubes: Multi-dimensional Ontologies and their Representation in SQL and OWL. Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013. editor / Pieter De Leenheer, Deijing Dou. Vol. 8186 2013. (Lecture Notes in Computer Science (LNCS)).

@inproceedings{af316edb8f52485d9f47b14e7f4cc275,

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

abstract = "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",

author = "Bernd Neumayr and Sch{\"u}tz, \{Christoph Georg\} and Michael Schrefl",

year = "2013",

month = sep,

language = "English",

isbn = "978-3-642-41032-1",

volume = "8186",

series = "Lecture Notes in Computer Science (LNCS)",

editor = "\{Pieter De Leenheer, Deijing Dou\}",

booktitle = "Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013",

}

Neumayr, B, Schütz, CG & Schrefl, M 2013, Semantic Enrichment of OLAP Cubes: Multi-dimensional Ontologies and their Representation in SQL and OWL. in Pieter De Leenheer, Deijing Dou (ed.), Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013. vol. 8186, Lecture Notes in Computer Science (LNCS).

Semantic Enrichment of OLAP Cubes: Multi-dimensional Ontologies and their Representation in SQL and OWL. / Neumayr, Bernd; Schütz, Christoph Georg ; Schrefl, Michael.
Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013. ed. / Pieter De Leenheer, Deijing Dou. Vol. 8186 2013. (Lecture Notes in Computer Science (LNCS)).

Research output: Chapter in Book/Report/Conference proceeding › Conference proceedings › peer-review

TY - GEN

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

AU - Neumayr, Bernd

AU - Schütz, Christoph Georg

AU - Schrefl, Michael

PY - 2013/9

Y1 - 2013/9

N2 - 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

AB - 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

UR - http://www.dke.jku.at/index.html?/research/index.html

M3 - Conference proceedings

SN - 978-3-642-41032-1

VL - 8186

T3 - Lecture Notes in Computer Science (LNCS)

BT - Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013

A2 - Pieter De Leenheer, Deijing Dou, null

ER -

Neumayr B, Schütz CG , Schrefl M. Semantic Enrichment of OLAP Cubes: Multi-dimensional Ontologies and their Representation in SQL and OWL. In Pieter De Leenheer, Deijing Dou, editor, Proceedings of the 12th International Conference on Ontologies, DataBases, and Applications of Semantics (ODBASE 2013), Graz, Austria, September 10-12, 2013. Vol. 8186. 2013. (Lecture Notes in Computer Science (LNCS)).

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

Abstract

Publication series

Fields of science

JKU Focus areas

Other files and links

SemCockpit - An Ontology-Driven, Interactive Business Intelligence Tool for Comparative Data Analysis

Cite this

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

Abstract

Publication series

Fields of science

JKU Focus areas

Other files and links

Projects

SemCockpit - An Ontology-Driven, Interactive Business Intelligence Tool for Comparative Data Analysis

Cite this