油气混输管道数据库管理平台开发

Development of a Database Management Platform of Oil-Gas Multiphase Transportation Pipeline

采用SQL Server 2005和Visual C#.NET软件建立了油气混输管道数据库,并开发了数据库管理平台,能够实现管道数据的录入、修改、删除、查询,温度、压力的计算和修正等功能。该数据库管理平台在工程实际管道和实验环道装置的数据基础上,对已有模型进行修正,使之适用于现场,并提出了查询插值的新方法,成为实现混输管道压降预测的有效途径。同时,该数据库可应用于工程设计建设及混输管道压降计算方法的研究。

The database of oil-gas multiphase transportation pipeline is established in this paper by using SQL Server 2005 and Visual C#.NET software,and the database management platform is developed,which will realize multiple purposes such as input,modification,deletion,inquiry of pipeline data,calculation and amendment for temperature and pressure.On the base of the data from project pipeline and experimental loop devices in this project,the database management platform amends those models that has existed,and applies the amended model to the scene.A new method of inquiry and interpolation is proposed,which is an effective way to solve the pressure drop prediction for multiphase transportation pipeline.At the same time,the database can be applied to engineering design and construction and to the research on the drop calculation methods of any multiphase transportation pipeline.