Skip to Main content Skip to Navigation
Journal articles

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.
Keywords : Data Warehouse
Document type :
Journal articles
Complete list of metadatas

Cited literature [2 references]  Display  Hide  Download

https://hal.archives-ouvertes.fr/hal-00857371
Contributor : Import Ws Irstea <>
Submitted on : Tuesday, September 3, 2013 - 2:18:41 PM
Last modification on : Monday, September 21, 2020 - 11:54:04 AM
Long-term archiving on: : Wednesday, December 4, 2013 - 4:18:51 AM

File

cf2013-pub00038438.pdf
Files produced by the author(s)

Identifiers

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⟩

Share

Metrics

Record views

925

Files downloads

1439