Real-time geo-decisional system for risk and disaster management in Madagascar
Climate change is intensifying extreme phenomena, and the world is increasingly vulnerable to a variety of disasters whose impacts are considerable and varied over time, from one place to another and from one community to another. Due to its geographical location, Madagascar is the most cyclone-pron...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Sciendo
2025-06-01
|
| Series: | Reports on Geodesy and Geoinformatics |
| Subjects: | |
| Online Access: | https://doi.org/10.2478/rgg-2025-0002 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1823860451170058240 |
|---|---|
| author | Rakotoarison Tsiorinantenaina René Hajalalaina Aimé Richard |
| author_facet | Rakotoarison Tsiorinantenaina René Hajalalaina Aimé Richard |
| author_sort | Rakotoarison Tsiorinantenaina René |
| collection | DOAJ |
| description | Climate change is intensifying extreme phenomena, and the world is increasingly vulnerable to a variety of disasters whose impacts are considerable and varied over time, from one place to another and from one community to another. Due to its geographical location, Madagascar is the most cyclone-prone country in Africa and the ninth most vulnerable country in the world. Almost every year, Madagascar is hit by cyclones, causing loss of life and property for the population. In terms of prevention, Madagascar already has an early warning system to inform the population, but during a crisis, it still lacks a decision support system for rapid, real-time intervention to minimize damage. In this paper, we propose a real-time geo-decision support system based on real-time data integration, real-time ETL and real-time cube building. In the proposed architecture, continuous data ˚ow is required for real-time data integration. The proposed real-time ETL unit is composed of the capitalization of risk analysis experiments to ensure their reusability, as well as the insertion of processing parallelization to optimize the processing time of voluminous data. The real-time SOLAP unit consists of real-time cube formation using a spatial database that stores spatio-temporal data from a given point in time, with query optimization using materialized query technology. Our prototype uses NASA’s weather data streaming service via an API. The ETL is written in a Matlab script and loads the data into a spatial database in Postgresql after processing. A web mapping application queries the constitution of a cube and displays the result for visualization. |
| format | Article |
| id | doaj-art-b8efd10282f84b6db0bf23ffd824c998 |
| institution | Kabale University |
| issn | 2391-8152 |
| language | English |
| publishDate | 2025-06-01 |
| publisher | Sciendo |
| record_format | Article |
| series | Reports on Geodesy and Geoinformatics |
| spelling | doaj-art-b8efd10282f84b6db0bf23ffd824c9982025-02-10T13:26:09ZengSciendoReports on Geodesy and Geoinformatics2391-81522025-06-01119171310.2478/rgg-2025-0002Real-time geo-decisional system for risk and disaster management in MadagascarRakotoarison Tsiorinantenaina René0Hajalalaina Aimé Richard1School of Management and Technological Innovation, University of Fianarantsoa, Andrainjato, Fianarantsoa, zip code 301, MadagascarSchool of Management and Technological Innovation, University of Fianarantsoa, Andrainjato, Fianarantsoa, zip code 301, MadagascarClimate change is intensifying extreme phenomena, and the world is increasingly vulnerable to a variety of disasters whose impacts are considerable and varied over time, from one place to another and from one community to another. Due to its geographical location, Madagascar is the most cyclone-prone country in Africa and the ninth most vulnerable country in the world. Almost every year, Madagascar is hit by cyclones, causing loss of life and property for the population. In terms of prevention, Madagascar already has an early warning system to inform the population, but during a crisis, it still lacks a decision support system for rapid, real-time intervention to minimize damage. In this paper, we propose a real-time geo-decision support system based on real-time data integration, real-time ETL and real-time cube building. In the proposed architecture, continuous data ˚ow is required for real-time data integration. The proposed real-time ETL unit is composed of the capitalization of risk analysis experiments to ensure their reusability, as well as the insertion of processing parallelization to optimize the processing time of voluminous data. The real-time SOLAP unit consists of real-time cube formation using a spatial database that stores spatio-temporal data from a given point in time, with query optimization using materialized query technology. Our prototype uses NASA’s weather data streaming service via an API. The ETL is written in a Matlab script and loads the data into a spatial database in Postgresql after processing. A web mapping application queries the constitution of a cube and displays the result for visualization.https://doi.org/10.2478/rgg-2025-0002geo-decisionalreal-timeriskdisastermadagascar |
| spellingShingle | Rakotoarison Tsiorinantenaina René Hajalalaina Aimé Richard Real-time geo-decisional system for risk and disaster management in Madagascar Reports on Geodesy and Geoinformatics geo-decisional real-time risk disaster madagascar |
| title | Real-time geo-decisional system for risk and disaster management in Madagascar |
| title_full | Real-time geo-decisional system for risk and disaster management in Madagascar |
| title_fullStr | Real-time geo-decisional system for risk and disaster management in Madagascar |
| title_full_unstemmed | Real-time geo-decisional system for risk and disaster management in Madagascar |
| title_short | Real-time geo-decisional system for risk and disaster management in Madagascar |
| title_sort | real time geo decisional system for risk and disaster management in madagascar |
| topic | geo-decisional real-time risk disaster madagascar |
| url | https://doi.org/10.2478/rgg-2025-0002 |
| work_keys_str_mv | AT rakotoarisontsiorinantenainarene realtimegeodecisionalsystemforriskanddisastermanagementinmadagascar AT hajalalainaaimerichard realtimegeodecisionalsystemforriskanddisastermanagementinmadagascar |