Designing Multidimensional Cubes from Warehoused Data and Linked Open Data

Franck Ravat (1, 2) , Jiefu Song (1) , Olivier Teste (1, 3)

1 IRIT-SIG - Systèmes d’Informations Généralisées
2 UT Capitole - Université Toulouse Capitole
3 UT2J - Université Toulouse - Jean Jaurès

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.

Mots clés: Conceptual multidimensional modeling; Linked open data; Unified business analyses

Domaines: Théorie de l'information [cs.IT]; Recherche d'information [cs.IR]

Franck Ravat, Jiefu Song, Olivier Teste. Designing Multidimensional Cubes from Warehoused Data and Linked Open Data. 10th International IEEE Conference on Research Challenges in Information Science (RCIS 2016) co-located witht the 34th French Conference INFORSID, Jun 2016, Grenoble, France. pp. 199-200. ⟨hal-01474899⟩