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

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 metadata

Cited literature [2 references]  Display  Hide  Download

https://hal.archives-ouvertes.fr/hal-00857371
Contributor : Import Ws Irstea Connect in order to contact the contributor
Submitted on : Tuesday, September 3, 2013 - 2:18:41 PM
Last modification on : Tuesday, November 23, 2021 - 1:56:13 PM
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

1144

Files downloads

2032