Development of a database for water supply systems aiming for hydro energy efficiency using R and EPANET

Desenvolvimento de banco de dados para sistemas de abastecimento de água visando eficiência hidroenergética usando R e EPANET

ABSTRACT

Currently, many water supply systems collect and monitor data daily, among which we can highlight values of reservoir levels, pressures, and consumption demands, in addition to electrical data. The data generated is transformed into information, providing the necessary knowledge to guide the manager in planning actions and making decisions in general. The R program is a programming language widely used for statistical analysis and, recently, in some R works coupled to EPANET. Thus, this work aimed to evaluate the potential of the R program interconnected to EPANET for the database of water supply systems. For this purpose, the methodology of proposing a simulation in R of a theoretical water distribution network created in EPANET was considered to evaluate the results of daily consumption demand. The proposed network was simulated by varying consumption demands with reservoir levels, obtaining several results in 24 hours. Consequently, it was possible to automate the process of statistical analysis, generating tables and graphs referring to the dispersion of demands, node pressures, and outflows of the stretches arising from each variation in consumption and reservoir levels. The results obtained proved the compatibility and practicality of the mathematical model of the water distribution project in the EPANET program, simulated in R and stored in the SQL SERVER database.

Keywords
statistical analysis; database; EPANET; R software; distribution networks