Using domain ontologies as semantic dimensions in data warehouses

  • Authors:
  • Stefan Anderlik;Bernd Neumayr;Michael Schrefl

  • Affiliations:
  • Department of Business Informatics - Data & Knowledge Engineering, Johannes Kepler University Linz, Austria;Department of Business Informatics - Data & Knowledge Engineering, Johannes Kepler University Linz, Austria;Department of Business Informatics - Data & Knowledge Engineering, Johannes Kepler University Linz, Austria

  • Venue:
  • ER'12 Proceedings of the 31st international conference on Conceptual Modeling
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

More and more transaction systems collect records that reference concepts of domain ontologies in so-called semantic attributes. This paper investigates how such semantic attributes together with their referenced domain ontology can be best exploited for data analysis in data warehouses. This gives rise to two challenges: first, exploit the rich knowledge represented in domain ontologies for targeted analysis and, second, aggregate data along the subsumption hierarchy of concepts and ensuring summarizability in the absence of predefined aggregation levels. To meet these challenges, the paper extends OLAP (OnLine Analytical Processing) by integrating concept expressions and proper level definitions over domain ontologies into OLAP operations. A prototype demonstrates the feasibility of the approach.