Accéder directement au contenu Accéder directement à la navigation
Article dans une revue

Guaranteeing the quality of multidimensional analysis in data warehouses of simulation results: application to pesticide transfer data produced by the MACRO Model

Kamal Boulil 1 François Pinet 2 Sandro Bimonte 3 Nadia Carluer 4 Claire Lauvernet 5 Bruno Cheviron 6 André Miralles 2, 7 Jean-Pierre Chanet 3
1 BDTLN - Bases de données et traitement des langues naturelles
LIFAT - Laboratoire d'Informatique Fondamentale et Appliquée de Tours
5 MOISE - Modelling, Observations, Identification for Environmental Sciences
Inria Grenoble - Rhône-Alpes, LJK [2007-2015] - Laboratoire Jean Kuntzmann [2007-2015], Grenoble INP [2007-2019] - Institut polytechnique de Grenoble - Grenoble Institute of Technology [2007-2019]
7 MAREL - Models And Reuse Engineering, Languages
LIRMM - Laboratoire d'Informatique de Robotique et de Microélectronique de Montpellier
Abstract : Currently, the vital impact of environmental pollution on economic, social and health dimensions has been recognized. The need for theoretical and implementation frameworks for the acquisition, modeling and analysis of environmental data as well as tools to conceive and validate scenarios is becoming increasingly important. For these reasons, different environmental simulation models have been developed. Researchers and stakeholders need efficient tools to store, display, compare and analyze data that are produced by simulation models. One common way to manage simulation results is to use text files; however, text files make it difficult to explore the data. Spreadsheet tools (e.g., OpenOffice, MS Excel) can help to display and analyze model results, but they are not suitable for very large volumes of information. Recently, some studies have shown the feasibility of using Data Warehouse (DW) and On-Line Analytical Processing (OLAP) technologies to store model results and to facilitate model visualization, analysis and comparisons. These technologies allow model users to easily produce graphical reports and charts. In this paper, we address the analysis of pesticide transfer simulation results by warehousing and OLAPing data, for which the data results from the MACRO simulation model. This model simulates hydrological transfers of pesticides at the plot scale. We demonstrate how the simulation results can be managed using DW technologies. We also demonstrate how the use of integrity constraints can improve OLAP analysis. These constraints are used to maintain the quality of the warehoused data as well as to maintain the aggregations and queries, which will lead to better analysis, conclusions and decisions.
Mots-clés : Entrepôt de données
Type de document :
Article dans une revue
Liste complète des métadonnées

Littérature citée [2 références]  Voir  Masquer  Télécharger
Déposant : Import Ws Irstea <>
Soumis le : mardi 3 septembre 2013 - 14:18:41
Dernière modification le : vendredi 17 juillet 2020 - 11:38:57
Document(s) archivé(s) le : mercredi 4 décembre 2013 - 04:18:51


Fichiers produits par l'(les) auteur(s)



Kamal Boulil, François Pinet, Sandro Bimonte, Nadia Carluer, Claire Lauvernet, et al.. Guaranteeing the quality of multidimensional analysis in data warehouses of simulation results: application to pesticide transfer data produced by the MACRO Model. Ecological Informatics, Elsevier, 2013, 16, pp.41-52. ⟨10.1016/j.ecoinf.2013.04.004⟩. ⟨hal-00857371⟩



Consultations de la notice


Téléchargements de fichiers