Multidimensional modeling and analysis of large and complex watercourse data: an OLAP-based solution - INRAE - Institut national de recherche pour l’agriculture, l’alimentation et l’environnement Accéder directement au contenu
Article Dans Une Revue Ecological Informatics Année : 2014

Multidimensional modeling and analysis of large and complex watercourse data: an OLAP-based solution

Résumé

This paper presents the application of Data Warehouse (DW) and On-Line Analytical Processing (OLAP) technologies to the field of water quality assessment. The European Water Framework Directive (DCE, 2000) underlined the necessity of having operational tools to help in the interpretation of the complex and abundant information regarding running waters and their functioning. Several studies have exemplified the interest in DWs for integrating large volumes of data and in OLAP tools for data exploration and analysis. Based on free software tools, we propose an extensible relational OLAP system for the analysis of physicochemical and hydrobiological watercourse data. This system includes: (i) two data cubes; (ii) an Extract, Transform and Load (ETL) tool for data integration; and (iii) tools for OLAP exploration. Many examples of OLAP analysis (thematic, temporal, spatiotemporal, and multiscale) are provided. We have extended an existing framework with complex aggregate functions that are used to define complex analysis indicators. Additional analysis dimensions are also introduced to allow their calculation and also for purposes of rendering information. Finally, we propose two strategies to address the problem of summarizing heterogeneous measurement units by: (i) transforming source data at the ETL tier, and (ii) introducing an additional analysis dimension at the OLAP server tier.
Fichier principal
Vignette du fichier
boulil et al. 2014.pdf (1.96 Mo) Télécharger le fichier
Origine : Fichiers produits par l'(les) auteur(s)
Loading...

Dates et versions

hal-01057105 , version 1 (20-11-2019)

Identifiants

Citer

Kamal Boulil, Florence Le Ber, Sandro Bimonte, Corinne Grac, Flavie Cernesson. Multidimensional modeling and analysis of large and complex watercourse data: an OLAP-based solution. Ecological Informatics, 2014, 24, pp.30. ⟨10.1016/j.ecoinf.2014.07.001⟩. ⟨hal-01057105⟩
192 Consultations
369 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More