Dimensional database to support water resources decisions
Banco de dados dimensional para apoiar decisões de recursos hídricos
DOI:
https://doi.org/10.34117/bjdv8n12-029Keywords:
decision support system, dimensional model, hydrological databaseAbstract
This paper aims to demonstrate that the dimensional database model has great potential for use in water resources due to its generalization in the input and output of data and facilitates the aggregation of data for information generation. In addition, the proposed model was applied to PostgreSQL software, which is a powerful and free database engine, as it does not generate license costs for its implementation and can be even implemented in small server environments, the model is capable of performing complex queries on huge databases (billions of data) with very fast response times, reaching speeds in excess of 300,000 processed data per second. As a consequence of being generic, high performing and its low cost, so, the same methodology was applied to the monitoring module of the PCJ Basin Decision Support System (SSDPCJ), which has the function of disseminating data from the telemetry monitoring stations and it can be replicated for other cases that need to store and disseminate information on water resources.
References
ANA, Agência Nacional de Águas. “HIDRO: Sistema de Informações Hidrológicas Versão 1.0”. 2010
ANA, Agência Nacional de Águas. “Inventario de Estacoes Hidrometeorologicas”. Disponível em: < https://www.snirh.gov.br/hidroweb/rest/api/documento/download? documentos =220 >. Acesso em: 26 mar. 2022.
GARCIA, Joaquin Ignacio Bonnecarrère; SCHARDONG, Andre; PORTO, Rubem La Laina. Decision support system for optimization of permits for wastewater discharge. RBRH, v. 23, n. 0, 2018.
JONOSKI AND ABDULKARIM Real-world decision support systems. New York, NY: Springer Berlin Heidelberg, 2016.
KIMBALL, R. e ROSS, M.. “The data warehouse toolkit: The definitive guide to dimensional modeling”. John Wiley & Sons. 2013.
LIU, Jiahong; GAO, Xuerui; SHAO, Weiwei; et al. Water Resources Monitoring System Construction in Shanxi Province, China. Procedia Engineering, v. 154, p. 326–333, 2016.
PostgreSQL. “PostgreSQL Documentation”. Disponível em: <https://www.postgresql.org/docs>. Acesso em: 26 mar. 2022.
SIMONOVIC, Slobodan P.; SCHARDONG, Andre; SANDINK, Dan; et al. A web-based tool for the development of Intensity Duration Frequency curves under changing climate. Environmental Modelling & Software, v. 81, p. 136–153, 2016.
Terakawa, A. (2003). “Hydrological data management: Present state and trends”. Secretariat of the World Meteorological Organization. WMO.
