OATAO - Open Archive Toulouse Archive Ouverte Open Access Week

Designing Multidimensional Cubes from Warehoused Data and Linked Open Data

Ravat, Franck and Song, Jiefu and Teste, Olivier Designing Multidimensional Cubes from Warehoused Data and Linked Open Data. (2016) In: 10th International IEEE Conference on Research Challenges in Information Science (RCIS 2016) co-located witht the 34th French Conference INFORSID, 1 June 2016 - 3 June 2016 (Grenoble, France).

(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.1109/RCIS.2016.7549337


A Data Warehouse (DW) is widely used as a consistent and integrated data repository in Business Intelligence systems. Under today's dynamic and competitive business context, warehoused data alone no longer provide enough information for decision-making processes. Business analyses should be enhanced by including Linked Open Data (LOD) to offer multiple perspectives to decision-makers. This paper provides a new multidimensional model, named Unified Cube, which offers a generic representation for both warehoused data and LOD at the conceptual level. A two-stage process is proposed to build a Unified Cube according to decision-makers' needs. As a first step, schemas published with specific modeling languages are transformed into a common conceptual representation. The second step is to associate together related data to form a Unified Cube containing all useful information about an analysis subject. A high-level declarative language is provided to enable nonexpert users to define the relevance between data according to their analysis needs. To demonstrate the feasibility of the proposed concepts, we show how analyses over data from different sources can be carried out through a Unified Cube.

Item Type:Conference or Workshop Item (Paper)
Additional Information:Thanks to IEEE editor. The definitive version is available at http://ieeexplore.ieee.org This papers appears in Proceedings of IEEE RCIS 2016. Electronic ISBN: 978-1-4799-8710-8 Electronic ISBN: 978-1-4799-8710-8 The original PDF of the article can be found at: http://ieeexplore.ieee.org/document/7549337/ Personal use of this material is permitted. Permission from IEEE must be obtained for all other uses, in any current or future media, including reprinting/republishing this material for advertising or promotional purposes, creating new collective works, for resale or redistribution to servers or lists, or reuse of any copyrighted component of this work in other works.
HAL Id:hal-01474899
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:01 Feb 2017 09:16

Repository Staff Only: item control page