OATAO - Open Archive Toulouse Archive Ouverte Open Access Week

Graph-Based ETL Processes For Warehousing Statistical Open Data

Berro, Alain and Megdiche-Bousarsar, Imen and Teste, Olivier Graph-Based ETL Processes For Warehousing Statistical Open Data. (2015) In: 17th International Conference on Enterprise Information Systems, 27 April 2015 - 30 April 2015 (Barcelona, Spain).

(Document in English)

PDF (Author's version) - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader

Official URL: http://dx.doi.org/10.5220/0005363302710278


Warehousing is a promising mean to cross and analyse Statistical Open Data (SOD). But extracting structures, integrating and defining multidimensional schema from several scattered and heterogeneous tables in the SOD are major problems challenging the traditional ETL (Extract-Transform-Load) processes. In this paper, we present a three step ETL processes which rely on RDF graphs to meet all these problems. In the first step, we automatically extract tables structures and values using a table anatomy ontology. This phase converts structurally heterogeneous tables into a unified RDF graph representation. The second step performs a holistic integration of several semantically heterogeneous RDF graphs. The optimal integration is performed through an Integer Linear Program (ILP). In the third step, system interacts with users to incrementally transform the integrated RDF graph into a multidimensional schema.

Item Type:Conference or Workshop Item (Paper)
Additional Information:Thanks to Scitepress editor. The definitive version is available at http://www.scitepress.org The original PDF of the article can be found at : http://www.scitepress.org/DigitalLibrary/Link.aspx?doi=10.5220/0005363302710278
HAL Id:hal-01310725
Audience (conference):International conference proceedings
Uncontrolled Keywords:
Institution:Université de Toulouse > Institut National Polytechnique de Toulouse - Toulouse INP (FRANCE)
French research institutions > Centre National de la Recherche Scientifique - CNRS (FRANCE)
Université de Toulouse > Université Toulouse III - Paul Sabatier - UT3 (FRANCE)
Université de Toulouse > Université Toulouse - Jean Jaurès - UT2J (FRANCE)
Université de Toulouse > Université Toulouse 1 Capitole - UT1 (FRANCE)
Laboratory name:
Deposited On:03 May 2016 07:57

Repository Staff Only: item control page