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

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
Ecological Informatics, Elsevier, 2013, 16, pp.41-52. 〈10.1016/j.ecoinf.2013.04.004〉
Liste complète des métadonnées

Littérature citée [2 références]  Voir  Masquer  Télécharger

https://hal.archives-ouvertes.fr/hal-00857371
Contributeur : Import Ws Irstea <>
Soumis le : mardi 3 septembre 2013 - 14:18:41
Dernière modification le : samedi 17 novembre 2018 - 01:19:13
Document(s) archivé(s) le : mercredi 4 décembre 2013 - 04:18:51

Fichier

cf2013-pub00038438.pdf
Fichiers produits par l'(les) auteur(s)

Identifiants

Citation

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〉

Partager

Métriques

Consultations de la notice

522

Téléchargements de fichiers

335