| Titre : | Optimization of Water Distribution in Biskra Using Mathematical Modeling and Statistical Analysis |
| Auteurs : | Aya LEKSOUR, Auteur ; Nacer Rahmani, Directeur de thèse |
| Type de document : | Mémoire magistere |
| Editeur : | Biskra [Algérie] : Faculté des Sciences Exactes et des Sciences de la Nature et de la Vie, Université Mohamed Khider, 2026 |
| Format : | 1vol.(138.p) / 30 CM |
| Langues: | Anglais |
| Mots-clés: | drinking water distribution, mathematical optimisation, ARIMA forecast- ing, EPANET simulation, decision support system, Biskra. |
| Résumé : |
This dissertation addresses the optimisation of drinking water distribution in the wilaya of Biskra through an integrated methodology combining statistical analysis, mathe- matical optimisation, and hydraulic simulation. The study covers two independent distribution zones — Biskra Centre (direct injection, 11 boreholes, Qmob = 268 L/s) and El Alia (storage-based, 11 boreholes, Qmob = 298 L/s) — serving approximately 85 500 inhabitants. A production deficit of 410 L/s and a global exploitation rate of only 27.56% were identified as the main operational dysfunctions. The proposed methodology integrates ARIMA demand forecasting, a multi-criteria weighted scor- ing algorithm for borehole rehabilitation priority (P1/P2/P3), and the EPANET 2.2 hydraulic simulation engine. The decision-support software AEP Biskra v5.0, devel- oped in Node.js with a PostgreSQL backend, implements nine functional modules and achieves a conformity rate of 86% with respect to the technical requirements of the study. Hydraulic validation shows that the priority rehabilitation scenario raises the minimum network pressure from 8.2 m to 13.1 m in Biskra Centre and from 7.8 m to 12.4 m in El Alia, restoring the DRE standard of Pmin ? 10 m in both zones. |
| Sommaire : |
Dedication i
Acknowledgment ii Abstract / R´esum´e iii Notations and Symbols v Table of Contents viii List of Figures xiii List of Tables xv Introduction 1 1 Drinking water supply systems and management challenges 5 1.1 Introduction to Water Supply Systems (AEP) . . . . . . . . . . . . . . 6 1.2 Graph Theory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 1.2.1 Graph Representation of the Hydraulic Network . . . . . . . . . 9 1.2.2 Definition of a Water Supply Network . . . . . . . . . . . . . . . 12 1.2.3 Elements of a Hydraulic Network . . . . . . . . . . . . . . . . . 12 1.2.4 Fundamental hydraulic equations . . . . . . . . . . . . . . . . . 13 1.3 Hydraulic Classification of Potable Water Distribution Systems . . . . . 16 ix 1.3.1 Research Summary . . . . . . . . . . . . . . . . . . . . . . . . . 17 1.4 Diagnosis of Dysfunctions and Constraints . . . . . . . . . . . . . . . . 18 1.4.1 Production Dysfunctions . . . . . . . . . . . . . . . . . . . . . 19 1.4.2 Transport and Distribution Constraints . . . . . . . . . . . . . 19 1.4.3 Storage and Regulation Deficiencies . . . . . . . . . . . . . . . 19 1.4.4 Management and Operational Challenges . . . . . . . . . . . . 19 1.4.5 Impacts on Water Supply Service . . . . . . . . . . . . . . . . . 20 1.4.6 Critical Analysis of the Existing Network . . . . . . . . . . . . . 21 1.4.7 Quantitative Synthesis of the Diagnosis . . . . . . . . . . . . . . 21 2 The Threefold Methodology for Improving Network Performance 23 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 2.1 Integration of Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 2.2 Explanation of the Relationship Between Statistical Data, Mathematical Models, and Hydraulic Simulation . . . . . . . . . . . . . . . . . . . . . 26 2.2.1 Statistical Data as the Informational Foundation of the Method- ological Framework . . . . . . . . . . . . . . . . . . . . . . . . . 26 2.2.2 Mathematical Models and Optimization Process . . . . . . . . . 30 2.2.3 Performance Evaluation Indicators . . . . . . . . . . . . . . . . 35 2.2.4 Hydraulic Simulation and Technical Validation . . . . . . . . . . 35 2.2.5 Operational Scenario Analysis . . . . . . . . . . . . . . . . . . . 36 2.3 Time Series Analysis and Demand Forecasting . . . . . . . . . . . . . . 38 2.3.1 Introduction to Time Series Forecasting . . . . . . . . . . . . . 38 2.3.2 Mathematical Formulation of Operational Indicators . . . . . . 40 2.3.3 Hydraulic Risk Classification . . . . . . . . . . . . . . . . . . . . 42 x 2.3.4 Components of Time Series . . . . . . . . . . . . . . . . . . . . 43 2.3.5 Demand Pattern Construction . . . . . . . . . . . . . . . . . . . 44 2.3.6 Forecasting Models . . . . . . . . . . . . . . . . . . . . . . . . . 48 2.3.7 Empirical Application to the Biskra Demand Series . . . . . . . 51 3 Topographic Diagnosis, Hydraulic Modeling, and Software Integra- tion 54 3.1 Overall Architecture and Algorithmic Chain . . . . . . . . . . . . . . . 55 3.2 Statistical Diagnosis Module (Algorithms 1 and 2) . . . . . . . . . . . . 56 3.3 Time-Series Analysis Module (Algorithm 3) . . . . . . . . . . . . . . . 57 3.4 Prioritisation Module (Algorithm 4) . . . . . . . . . . . . . . . . . . . . 58 3.5 Mathematical Optimisation Module (Algorithm 5) . . . . . . . . . . . . 59 3.6 Scenario Construction and EPANET Simulation (Algorithms 6 and 7) . 60 3.7 Scenario Comparison and Final Decision (Algorithm 8 and Final Algo- rithm) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 3.8 Operating Principle of the Software . . . . . . . . . . . . . . . . . . . . 62 3.8.1 Data Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 3.8.2 Real-Time Computation . . . . . . . . . . . . . . . . . . . . . . 64 3.8.3 Results and Decision . . . . . . . . . . . . . . . . . . . . . . . . 66 3.9 Application to the Biskra Network . . . . . . . . . . . . . . . . . . . . 70 3.9.1 Numerical Results of the Diagnosis . . . . . . . . . . . . . . . . 71 3.9.2 Numerical Results of the Scenarios . . . . . . . . . . . . . . . . 71 3.9.3 Hydraulic Verification of the Pipes . . . . . . . . . . . . . . . . 72 3.9.4 Validation of the Simplified Solver against the EPANET Method 72 General Conclusion 75 xi Annexes 80 Annexe A — Manuel Utilisateur AEP Biskra v5.0 98 Annexe B — Captures d’ecran du logiciel 118 Annexe C — Donnees hydrauliques du reseau 129 Annexe D — Cadre juridique des Start-up et PME 138 xii |
Disponibilité (1)
| Cote | Support | Localisation | Statut |
|---|---|---|---|
| MM/1409 | Mémoire master | bibliothèque sciences exactes | Consultable |




