管道完整性数据库的优化策略  

Optimization strategies on pipeline integrity database

作　　者：高海康[1] 刘亮[1] 郭磊[1] 韩文超[1] 徐杰 GAO Haikang LIU Liang GUO Lei HAN Wenchao XU Jie(PetroChina Pipeline R ＆ D Center/CNPC Key Laboratory of Oil ＆ Gas Storage and Transportatio)

机构地区：[1]中国石油管道科技研究中心/中国石油天然气集团公司油气储运重点实验室

出　　处：《油气储运》2016年第9期932-935,共4页Oil & Gas Storage and Transportation

基　　金：中国石油集团公司投资项目"管道完整性管理系统";计划2010-12

摘　　要：随着管道完整性管理系统不断推广应用,系统的数据量和用户访问量与日剧增,数据库性能已逐渐成为制约系统性能提升的瓶颈之一。为了提高管道完整性管理系统的性能,缩短系统响应时间,节省网络带宽资源,针对管道完整性管理系统并发性强、数据量大、业务逻辑复杂的特点,提出了一套基于索引、高效SQL、存储过程算法、物化视图的数据库优化策略。实际应用效果表明:管道完整性数据库优化策略使系统运行效率平均提升60%,为中国石油管道完整性管理的数据维护与管理提供了有效的技术保障。With the increasing promotion and application of pipeline integrity management system（PIS）, its data bulk and user visits are growing day by day. However, the database performance is now one of the bottlenecks restricting the system＇s performance improvement. In order to improve the performance of the pipeline integrity management system, shorten system response time and save network bandwidth resources, a set of database optimization strategies based on index, efficient SQL, stored procedure algorithm and materialized view were proposed by taking into account the high concurrency, large data bulk and complex business logic of the pipeline integrity management system. Practical application results show that the database optimization strategy increases the operating efficiency of the pipeline integrity management system by 60% and provides effective technical support for the data maintenance and management of PetroChina＇s pipeline integrity management system.

关 键 词：油气管道 完整性管理 数据库 优化策略 存储过程 PIS 

分 类 号：TE88[石油与天然气工程—油气储运工程]