Abstract
Water is an essential resource that is increasingly scarce. Existing water supply networks are highly stressed due the increasing water consumption and the high quantity of water losses. In order to reduce water losses and improve water consumption management, EAmb—Esposende Ambiente, E.M. is implementing a data warehouse for storing water supply and consumption data. The available data will be used to monitor and analyze water supply and consumption in Esposende county.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Babovic, V., Drécourt, J.-P., Keijzer, M., & Friss Hansen, P. (2002). A data mining approach to modelling of water supply assets. Urban Water, 4(4), 401–414. https://doi.org/10.1016/S1462-0758(02)00034-1.
Bougadis, J., Adamowski, K., & Diduch, R. (2005). Short-term municipal water demand forecasting. Hydrological Processes, 19(1), 137–148. https://doi.org/10.1002/hyp.5763.
ERSAR. (2017). Caraterização do setor de águas e resíduos (volume 1). Relatório Anual dos Serviços de Águas e Resíduos em Portugal. Retrieved from http://www.ersar.pt/pt/publicacoes/relatorio-anual-do-setor.
González-Gómez, F., García-Rubio, M. A., & Guardiola, J. (2011). Why is non-revenue water so high in so many cities? International Journal of Water Resources Development, 27(2), 345–360. https://doi.org/10.1080/07900627.2010.548317.
Güngör-Demirci, G., Lee, J., Keck, J., Guzzetta, R., & Yang, P. (2018). Determinants of non-revenue water for a water utility in California. Journal of Water Supply: Research and Technology - Aqua, 67(3), 270–278. https://doi.org/10.2166/aqua.2018.152.
Jarke, M., Lenzerini, M., Vassiliou, Y., & Vassiliadis, P. (2000). Fundamentals of Data Warehouses. Heidelberg: Springer. https://doi.org/10.1007/978-3-662-04138-3.
Kanakoudis, V., Tsitsifli, S., Samaras, P., & Zouboulis, A. (2013). Assessing the performance of urban water networks across the EU Mediterranean area: The paradox of high NRW levels and absence of respective reduction measures. Water Science and Technology: Water Supply, 13(4), 939–950. https://doi.org/10.2166/ws.2013.044.
Kimball, R., & Caserta, J. (2004). The Data Warehouse ETL toolkit: Practical techniques for extracting, cleaning conforming, and delivering data. Hoboken: Wiley. ISBN: 978-0764567575.
Kimball, R., & Ross, M. (2013). The data warehouse toolkit: The complete guide to dimensional modeling (3rd ed.), Wiley. ISBN: 978-1118530801.
Mounce, S. R., Boxall, J. B., & Machell, J. (2010). Development and verification of an online artificial intelligence system for detection of bursts and other abnormal flows. Journal of Water Resources Planning and Management, 136(3), 309–318. https://doi.org/10.1061/(ASCE)WR.1943-5452.0000030.
Mounce, S. R., & Machell, J. (2006). Burst detection using hydraulic data from water distribution systems with artificial neural networks. Urban Water Journal, 3(1), 21–31. https://doi.org/10.1080/15730620600578538.
Vilanova, M. R. N, Filho, P. M., & Balestieri, J. A. P. (2014, March 1). Performance measurement and indicators for water supply management: Review and international cases. Renewable and Sustainable Energy Reviews. Pergamon. http://doi.org/10.1016/j.rser.2014.11.043.
OECD. (2016). Water governance in cities. OECD Publishing. http://doi.org/10.1787/9789264251090-en.
Puust, R., Kapelan, Z., Savic, D. A., & Koppel, T. (2010). A review of methods for leakage management in pipe networks. Urban Water Journal, 7(1), 25–45. https://doi.org/10.1080/15730621003610878.
Thornton, J., Sturm, R., & Kunkel, G. A. (2008). Water loss control. New York: McGraw-Hill. ISBN: 978-0071499187.
Wang, H. C., & Guo, J. L. (2013). Constructing a water quality 2.0 OLAP system in Taiwan. Journal of Cleaner Production, 40, 40–45. https://doi.org/10.1016/j.jclepro.2011.04.019.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Soares, J., Leite, P., Teixeira, P., Lopes, N., Silva, J.P. (2019). Data Warehouse for the Monitoring and Analysis of Water Supply and Consumption. In: Ramos, I., Quaresma, R., Silva, P., Oliveira, T. (eds) Information Systems for Industry 4.0. Lecture Notes in Information Systems and Organisation, vol 31. Springer, Cham. https://doi.org/10.1007/978-3-030-14850-8_1
Download citation
DOI: https://doi.org/10.1007/978-3-030-14850-8_1
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-14849-2
Online ISBN: 978-3-030-14850-8
eBook Packages: Business and ManagementBusiness and Management (R0)