Implementación de una arquitectura distribuida para almacenar y procesar datos hidro-meteorológicos en tiempo real.

Abstract

In the field of hydrometeorology, the acquisition and analysis of real-time data are fundamental for various critical applications. However, the increasing volume of data poses challenges in terms of storage and processing. Ergo, this work presents the solution of a distributed database architecture aimed at managing large sets of hydrometeorological data from the National Institute of Meteorology and Hydrology of Ecuador. To address this issue, the current architecture conditions were analyzed and a distributed architecture was implemented using PostgreSQL and Citus. This approach allowed for the efficient distribution and handling of data, facilitating its storage, retrieval, and real-time analysis, through multiple processing nodes. The implementation results showed a notable improvement in terms of scalability, speed, and reliability of the data storage and processing system. It especially highlights the ability to effectively handle demand peaks and large volumes of data, ensuring quick response times. This innovation in the management of hydrometeorological data emphasizes the importance of adopting distributed architectures and real-time processing technologies, setting a significant precedent for future research and applications in the field.