Towards Ontology-based OLAP: Datalog-based Reasoning over Multidimensional Ontologies

B. Neumayr, S. Anderlik, M. Schrefl
Neum12a (2012)
Il-Yeol Song, Matteo Golfarelli (Eds.): Proceedings of the ACM 15th International Workshop on Data Warehousing and OLAP (DOLAP 2012), Maui, Hawaii, U.S.A., November 2nd, 2012, ACM Press, ISBN 978-1-4503-1721-4, pp. 41-48, 2012.
Copy  (In order to obtain the copy please send an email with subject  Neum12a  to


Understandability, reuse, and maintainability of analytical queries belong to the key challenges of Data Warehousing, especially in settings where a large number of business analysts work together and need to share knowledge. To tackle these challenges we propose Ontology-based OLAP where an ontology acts as superimposed conceptual layer between business analysts and multidimensional data. In Ontology-based OLAP, dimensions and facts are enriched by concept definitions capturing the semantics of relevant business terms used to define measures and to formulate analytical queries. Using traditional ontology languages, it is, however, very difficult to capture the hierarchical and multidimensional conceptualizations of business analysts. In this paper, we propose hierarchical and multidimensional ontologies to better capture these structural specificities. We define and implement the abstract structure and semantics of multidimensional ontologies as rules and constraints in Datalog with negation and represent multidimensional ontologies as Datalog facts. In addition to reasoning over multidimensional ontologies (open-world) we discuss their grounding in Data Warehouses (closed-world) as the fundament of Ontology-based OLAP.