Ontologies with Semantic Web/Grid in Data Integration for OLAP

Ontologies with Semantic Web/Grid in Data Integration for OLAP

Tapio Niemi (Helsinki Institute of Physics, CERN, Switzerland), Santtu Toivonen (VTT Technical Research Centre of Finland, Finland), Marko Niinimaki (University of Tampere, Finland) and Jyrki Nummenmaa (University of Tampere, Finland)
Copyright: © 2007 |Pages: 25
DOI: 10.4018/jswis.2007100102
OnDemand PDF Download:
$37.50

Abstract

Traditionally, data used in OLAP (online analytical processing) have been limited to the contents of the data warehouse of a company. However, the needs for analysis are often more demanding and data are needed from different sources. In this article, we study how the semantics of data sources can be described to allow combining data from several sources into an OLAP cube. We apply Semantic Web technologies for defining an OWL/RDF ontology for OLAP data sources and OLAP cubes. These definitions are then utilised in OLAP cube formation by posing an OWL/RDF ontology-based query against them. We use Grid technologies to enhance the efficiency of processing and ensuring security. Our primary interest is in the cube construction (i.e., ETL process), and we assume that standard OLAP methods can be used for the actual analysis. Our tests show that the proposed approach can speed up the construction of an OLAP cube for ad hoc queries by supporting a high-level query language and reducing the amount of required data.

Complete Article List

Search this Journal:
Reset
Open Access Articles
Volume 13: 4 Issues (2017): 1 Released, 3 Forthcoming
Volume 12: 4 Issues (2016)
Volume 11: 4 Issues (2015)
Volume 10: 4 Issues (2014)
Volume 9: 4 Issues (2013)
Volume 8: 4 Issues (2012)
Volume 7: 4 Issues (2011)
Volume 6: 4 Issues (2010)
Volume 5: 4 Issues (2009)
Volume 4: 4 Issues (2008)
Volume 3: 4 Issues (2007)
Volume 2: 4 Issues (2006)
Volume 1: 4 Issues (2005)
View Complete Journal Contents Listing