Abstract

In this article, our research aims to set up a geo-decisional system, more precisely we are particularly interested in the spatial analysis system of agricultural production in Madagascar. For this, we used the spatial data warehouse technique based on the SOLAP spatial analysis tool. After having defined the concepts underlying these systems, we propose to address the research issues related to them from four points of view: needs study of the Malagasy Ministry of Agriculture, modeling of a multidimensional conceptual model according to the MultiDim model and the implementation of the system studied using GeoKettle, PostGIS, GeoServer, SPAGO BI and Geomondrian technologies. This new system helps improve the decision-making process for agricultural production in Madagascar.

Highlights

  • Agriculture is one of the important issues for Madagascar’s economy and it needs breakthrough techniques in this century

  • Our research aims to set up a geo-decisional system, more precisely we are interested in the spatial analysis system of agricultural production in Madagascar

  • After having defined the concepts underlying these systems, we propose to address the research issues related to them from four points of view: needs study of the Malagasy Ministry of Agriculture, modeling of a multidimensional conceptual model according to the MultiDim model and the implementation of the system studied using GeoKettle, PostGIS, GeoServer, SPAGO BI and Géomondrian technologies

Read more

Summary

Introduction

Agriculture is one of the important issues for Madagascar’s economy and it needs breakthrough techniques in this century. In addition to data warehouse method, decision-makers need another perspective on the visualization of spatially distributed data, the integration of the Geographic Information System (GIS) The combination of these two systems brings out a new concept: Spatial On-Line Analytical Processing (SOLAP), which is a DSS [4]. The implementation of the first SOLAP tool, JMap, is carried out by the geomatics research team of the University of Laval, Quebec, Canada [6] that is the creator of the SOLAP acronym and the first to commercialize SOLAP technology In his works, [7] proposes the use of Geobrowser Google Earth which implements the flexible SOLAP Web system, GoOlap, combining both OLAP functionalities and advanced geovisualization features. We will design a data warehouse for agricultural production and implement a spatial analysis tool for decision support

Decision Support System
Spatial Data Warehouse
Spatial Analysis System
Modeling a Spatial Data Warehouse
Synthesis on the Basic Concepts
MultiDim Model
Requirements Analysis
Analysis and Criticism of Existing System
Conceptual Model for a Decisional System for Spatial Analysis
Extraction Transformation Load Tools
Database Management Software
Map Server
Spatial Analysis Tools
Realization with SpagoBI Tool
Realization with GeoMondrian and JPivot
Findings
Conclusions and Perspectives
Full Text
Paper version not known

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call