基于开源Postgresql构建高性能管网分析服务  

Building High-performance Pipe Network Analysis Service Based on Open Source PostgreSQL

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

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

出　　处：《城市勘测》2023年第6期175-177,共3页Urban Geotechnical Investigation & Surveying

摘　　要：传统管网分析一般基于后端开发,数据通过数据库和后端服务之间流转加工才能提供管网分析结果,流转过程中分析性能大打折扣。基于开源Postgresql数据库结合postgis插件,采用Postgresql数据库存储过程实现常用管网分析功能,可以有效地发挥数据库自身查询访问性能优势,缩短管网空间分析及网络分析时间。采用存储过程函数实现了(包括垂直净距分析、大管接小管、倒坡、覆土、横断面、开挖、上下游追踪、水平净距、连通性及纵断面分析功能),基本满足管网分析常规需求。Traditional pipe network analysis is generally based on back-end development.Data can only be provided with pipe network analysis results through the flow processing between the database and back-end services,and the analysis performance is greatly reduced in the process of flow.Based on the open source PostgreSQL database and the PostGIS plug-in,the PostgreSQL database stored procedure is used to realize the common pipe network analysis function,which can effectively give play to the query and access performance advantages of the database itself,and shorten the time of pipe network spatial analysis and network analysis.The stored procedure function is used to realize(including the functions of vertical clearance analysis,large pipe connecting small pipe,reverse slope,soil covering,cross section,excavation,upstream and downstream tracking,horizontal clearance,connectivity and profile analysis),which basically meets the routine requirements of pipe network analysis.

关 键 词：管网 分析 空间 网络 

分 类 号：P209[天文地球—测绘科学与技术]