A data warehouse to explore multidimensional simulated data from a spatially distributed agro-hydrological model to improve catchment nitrogen management

Abstract : Spatially distributed agro-hydrological models allow researchers and stakeholders to represent, understand and formulate hypotheses about the functioning of agro-environmental systems and to predict their evolution. These models have guided agricultural management by simulating effects of landscape structure, farming system changes and their spatial arrangement on stream water quality. Such models generate many intermediate results that should be managed, analyzed and transformed into usable information. We describe a data warehouse (N-Catch) built to store and analyze simulation data from the spatially distributed agro-hydrological model TNT2. We present scientific challenges to and tools for building data warehouses and describe the three dimensions of N-Catch: space, time and an original hierarchical description of cropping systems. We show how to use OLAP to explore and extract all kinds of useful high-level information by aggregating the data along these three dimensions and how to facilitate exploration of the spatial dimension by coupling N-Catch with GIS. Such tool constitutes an efficient interface between science and society, simulation remaining a research activity, exploration of the results becoming an easy task accessible for a large audience.
Complete list of metadatas

Cited literature [45 references]  Display  Hide  Download

https://hal.inria.fr/hal-01597840
Contributor : Tassadit Bouadi <>
Submitted on : Friday, September 29, 2017 - 2:39:58 PM
Last modification on : Thursday, February 7, 2019 - 5:06:24 PM
Long-term archiving on : Saturday, December 30, 2017 - 2:04:35 PM

File

EMS_T.Bouadi_Submission.pdf
Files produced by the author(s)

Identifiers

Citation

Tassadit Bouadi, Marie-Odile Cordier, Pierre Moreau, René Quiniou, Jordy Salmon-Monviola, et al.. A data warehouse to explore multidimensional simulated data from a spatially distributed agro-hydrological model to improve catchment nitrogen management. Environmental Modelling and Software, Elsevier, 2017, 97, pp.229 - 242. ⟨10.1016/j.envsoft.2017.07.019⟩. ⟨hal-01597840⟩

Share

Metrics

Record views

559

Files downloads

452