PostgreSQL实现的管网网络分析方法研究  

Research on methods of pipe network analysis implemented by PostgreSQL

作　　者：赵雅鹏 江彬 樊伟平 齐迹 ZHAO Yapeng;JIANG Bin;FAN Weiping;QI Ji(China Coal(Xi’an)Underground Space Tchnology Development Co.,Ltd.,Xi’an,Shaanxi 710054,China)

机构地区：[1]中煤(西安)地下空间科技发展有限公司,陕西西安710054

出　　处：《测绘技术装备》2024年第3期46-51,共6页Geomatics Technology and Equipment

摘　　要：针对传统空间管网网络分析基于后端开发模式,其数据在数据库与后端服务流转导致的分析性能低下问题,本文提出了基于开源PostgreSQL数据库存储过程函数实现管网网络分析的方法。该方法函数与数据库高度集成,SQL查询即为分析结果,管网网络分析的性能显著提升。另外,本文还采用数据库存储过程方式实现了djkstra函数、自定义函数和递归函数3种管网网络分析方法,并给出了3种方法的优缺点和使用场景,便于用户结合实际应用灵活选择。For the problem that the traditional spatial pipe network analysis is based on the back-end development mode,and the data flow between the database and the back-end services leads to poor efficiency,this paper proposes a method to realize the pipe network analysis based on the open-source PostgreSQL database stored procedure function.The method function is highly integrated with the database,and the SQL query is the analyzing results,so the efficiency of the pipe network analyzing is significantly improved.Three kinds of pipe network analyzing methods,namely djkstra function,user-defined function and recursive function,are implemented in the way of database stored procedure in this paper,and the advantages and disadvantages of the three methods and their use scenarios are given,so that users can easilly choose any one in accordance with practical applications.

关 键 词：管网 网络分析 POSTGRESQL 过程函数 

分 类 号：P208[天文地球—地图制图学与地理信息工程]