Research on methods of pipe network analysis implemented by PostgreSQL
For the problem that the traditional spatial pipe network analysis is based on the back-end de-velopment mode,and the data flow between the database and the back-end services leads to poor effi-ciency,this paper proposes a method to realize the pipe network analysis based on the open-source Post-greSQL 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 signifi-cantly 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.
pipe networknetwork analysisPostgreSQLprocess function
万方数据
维普
