Title
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.
Year
DOI
Venue
2017
10.1016/j.envsoft.2017.07.019
Environmental Modelling & Software
Keywords
Field
DocType
Multidimensional modeling,Simulation data,Data warehouse,OLAP,Water quality,Nitrogen,Catchment,Distributed agro-hydrological model
USable,Data science,Data warehouse,Data mining,Drainage basin,Computer science,Cropping,Online analytical processing
Journal
Volume
Issue
ISSN
97
C
1364-8152
Citations 
PageRank 
References 
1
0.43
22
Authors
6
Name
Order
Citations
PageRank
Tassadit Bouadi183.64
m o cordier247353.82
Pierre Moreau3222.00
René Quiniou410014.23
Jordy Salmon-Monviola5162.09
Chantal Gascuel-Odoux6304.34