Design and Development of SIPADMA: A Software Engineering Approach for Water Consumption Anomaly Detection in Public Water Utilities
DOI:
https://doi.org/10.26877/asset.v8i3.4219Keywords:
software engineering, SDLC, waterfall, information system, flask, anomaly detectionAbstract
Water utilities continuously face challenges in identifying abnormal customer water consumption caused by pipe leakage, illegal connections, meter reading errors, and unusual consumption behavior. Conventional manual inspection requires considerable time and often delays corrective actions. This study presents the design and development of SIPADMA (Sistem Deteksi Anomali Pemakaian Air), a web-based information system developed using Software Engineering principles to automate anomaly detection and support operational decision making. The system was developed following the Waterfall Software Development Life Cycle (SDLC), beginning with requirement analysis, UML-based system modeling, implementation using Flask, and functional testing. SIPADMA integrates statistical anomaly detection using Z-Score combined with rule-based scoring and provides interactive dashboards, anomaly filtering, customer history visualization, and automatic report generation. Evaluation using 3,996 billing records representing 666 customers demonstrated that the system successfully identified 163 anomalous accounts requiring further inspection. The developed system improves operational efficiency by automating data analysis and prioritizing field verification, demonstrating the effectiveness of software engineering practices in developing intelligent decision-support systems for public utilities.
References
[1] B. R. . Pressman, R. S., & Maxim, Software Engineering: A Practitioner’s Approach (9th ed.). McGraw-Hill., 2020.
[2] I. Sommerville, Software Engineering (10th ed.). Pearson, 2016.
[3] T. S. Farley M, Losses in Water Distribution Networks. London: IWA Publishing, 2005.
[4] W. A. Liemberger R, “Quantifying the global non-revenue water problem.,” Water Supply, vol. 19(3), pp. 831–837, 2019, doi: https://doi.org/10.2166/ws.2018.129.
[5] Rogers D, “Leaking water networks: an economic and environmental disaster,” Procedia Eng, vol. 70, pp. 1421–1429, 2014, doi: https://doi.org/10.1016/j.proeng.2014.02.157.
[6] American Water Works Association, “M36 Water Audits and Loss Control Programs. 4th ed,” 2016.
[7] C. J. Kim GH, Trimi S, “Big-data applications in the government sector,” Commun ACM, vol. 57(3), pp. 78-85., 2014, doi: https://doi.org/10.1145/2500873.
[8] K. V. Chandola V, Banerjee A, “Anomaly detection: A survey,” ACM Comput Surv, vol. 41(3), pp. 1–58, 2009, doi: https://doi.org/10.1145/1541880.1541882.
[9] S. J. L. Breunig MM, Kriegel HP, Ng RT, “Identifying density-based local outliers,” SIGMOD Rec, vol. 29(2), pp. 93–104, 2000, doi: https://doi.org/10.1145/335191.335388.
[10] Z. Z. Liu FT, Ting KM, “Isolation Forest,” IEEE Int Conf Data Min., pp. 413–422, 2008, doi: https://doi.org/10.1109/ICDM.2008.17.
[11] H. Y. Wu ZY, “Time series data decomposition-based anomaly detection and evaluation framework for operational management of smart water grid,” J Water Resour Plan Manag, vol. 147(9), 2021, doi: https://doi.org/10.1061/(ASCE)WR.1943-5452.0001433.
[12] X. Y. Jian C, Gao J, “Anomaly detection and classification in water distribution networks integrated with hourly nodal water demand forecasting models and feature extraction technique,” Water Resour Plan Manag, vol. 148(11), 2022, doi: https://doi.org/10.1061/(ASCE)WR.1943-5452.0001616.
[13] K. D. Nicholaus IT, Park JR, Jung K, Lee JS, “Anomaly detection of water level using deep autoencoder,” Sensors, vol. 21(19), 2021, doi: https://doi.org/10.3390/s21196679.
[14] A. S, Information systems: Foundation of e-business. 4th ed. Pearson Education, 2019.
[15] C. D. Virtanen P, Gommers R, Oliphant TE, Haberland M, Reddy T, “Fundamental algorithms for scientific computing in Python,” Nat Methods, vol. 17, pp. 261–272, 2020, doi: https://doi.org/10.1038/s41592-019-0686-2.
[16] urii D. Oleg Melnikov and V. Degeler, “SIAM: Statistical Identification of Anomalies via Mahalanobis metrics: an open-source framework for identifying anomalies in water distribution networks,” Softw. Impacts, 2026, doi: https://doi.org/10.1016/j.simpa.2026.100842.
[17] OMG, Unified Modeling Language (UML) Version 2.5.1. Object Management Group, 2017.
[18] K. R. Bass L, Clements P, Software Architecture in Practice. 4th ed. Boston: Addison-Wesley, 2022.
[19] Montgomery DC, Introduction to Statistical Quality Control. 8th ed. Hoboken: Wiley, 2020.
[20] McKinney W, “Data structures for statistical computing in Python,” Proc Python Sci Conf, pp. 56–61, 2010, doi: https://doi.org/10.25080/Majora-92bf1922-00a.
[21] Harris CR, Millman KJ, van der Walt SJ, Gommers R, Virtanen P, Cournapeau D, “Array programming with NumPy,” Nature, pp. 357–362, 2020, doi: https://doi.org/10.1038/s41586-020-2649-2.
[22] W. U. M. Rahmadoni J, Akbar R, “Web-Based Cooperation Information System at The Science Techno Park Technology Business Development Center,” J Appl Eng Technol Sci, vol. 3(2), pp. 156–167, 2022, doi: https://doi.org/10.37385/jaets.v3i2.806.
[23] R. K. Rikiti MZA, Kusmayanto E, “Design and Development of Help Patient Data Management Information System at Sinergi Atap Negeri Foundation Web-Based Using Codeigniter,” J Appl Eng Technol Sci, vol. 3(2), pp. 235–245, 2022, doi: https://doi.org/10.37385/jaets.v3i2.792.
[24] M. N. Kanyama, F. B. Shava, A. M. Gamundani, and A. Hartmann, “Machine learning applications for anomaly detection in Smart Water Metering Networks: A systematic review,” Phys Chem Earth, vol. 134, 2024, doi: https://doi.org/10.1016/j.pce.2024.103558.
[25] M. N. Kanyama, F. B. Shava, A. M. Gamundani, and A. Hartmann, “AI-driven anomaly detection in smart water metering systems using ensemble learning,” Water, vol. 17(13), 2025, doi: https://doi.org/10.3390/w17131933.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Advance Sustainable Science Engineering and Technology
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
