PDF下载
分享
[1]高海康,刘亮,郭磊,等.管道完整性数据库的优化策略[J].油气储运,2016,35(9):932-935.[doi:10.6047/j.issn.1000-8241.2016.09.005]
　GAO Haikang,LIU Liang,GUO Lei,et al.Optimization strategies on pipeline integrity database[J].Oil & Gas Storage and Transportation,2016,35(9):932-935.[doi:10.6047/j.issn.1000-8241.2016.09.005]
点击复制

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

《油气储运》[ISSN:1000-8241/CN:13-1093/TE] 卷: 35 期数: 2016年第9期 页码: 932-935 栏目: 出版日期: 2016-09-25
Title:

Optimization strategies on pipeline integrity database

作者:

高海康;  刘亮;  郭磊;  韩文超;  徐杰

中国石油管道科技研究中心/中国石油天然气集团公司油气储运重点实验室

Author(s):

GAO Haikang;  LIU Liang;  GUO Lei;  HAN Wenchao;  XU Jie

PetroChina Pipeline R & D Center/CNPC Key Laboratory of Oil & Gas Storage and Transportation

关键词:

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

Keywords:

oil and gas pipeline; integrity management; database; optimization strategies; stored procedure; pipeline integrity management system

分类号:
TE88
DOI:
10.6047/j.issn.1000-8241.2016.09.005
摘要:

随着管道完整性管理系统不断推广应用，系统的数据量和用户访问量与日剧增，数据库性能已逐渐成为制约系统性能提升的瓶颈之一。为了提高管道完整性管理系统的性能，缩短系统响应时间，节省网络带宽资源，针对管道完整性管理系统并发性强、数据量大、业务逻辑复杂的特点，提出了一套基于索引、高效SQL、存储过程算法、物化视图的数据库优化策略。实际应用效果表明：管道完整性数据库优化策略使系统运行效率平均提升60%，为中国石油管道完整性管理的数据维护与管理提供了有效的技术保障。

Abstract:

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.

参考文献/References:

[1] 杨祖佩,艾慕阳,冯庆善,等. 管道完整性管理研究的最新进展[J]. 油气储运,2008,27(7):1-5. YANG Z P,AI M Y,FENG Q S,et al. The latest progress on the study of pipeline integrity management[J]. Oil & Gas Storage and Transportation,2008,27(7):1-5.
[2] 税碧垣,燕冰川,冯庆善,等. 油气管道完整性管理技术[M]. 北京:石油工业出版社,2010:124-149. SHUI B Y,YAN B C,FENG Q S,et al. Oil & gas pipeline integrity management technology[M]. Beijing:Petroleum Industry Press, 2010:124-149.
[3] 金海丰. 船舶与海洋工程管理信息系统数据库优化研究[D]. 天津:天津大学,2012:1-3. JIN H F. The study of naval architecture and marine engineering management information system database[D]. Tianjin:Tianjin University,2012:1-3.
[4] 范聪杭. 电信ODS系统中的Oracle数据库优化研究[D]. 成都:成都理工大学,2014:17-34. FAN C H. The research of Oracle database performance optimization in ODS system of telecom[D]. Chengdu:Chengdu University of Technology, 2014:17-34.
[5] 张斌. 民航气象oracle数据库优化探讨[J]. 科技资讯,2011(7):17-18. ZHANG B. Optimization of aviation weather oracle database[J]. Science & Technology Information,2011(7):17-18.
[6] 顾云锋,杨素霞,王智钢,等. Oracle数据库中存储过程开发研究[J]. 计算机与现代化,2011(7):138-142. GU Y F,YANG S X,WANG Z G,et al. Research on development of stored procedures in oracle DB[J]. Computer and Modernization,2011(7):138-142.
[7] 吴洁明,周锦. 基于Oracle数据库SQL查询语句优化规则的研究[J]. 陕西理工学院学报(自然科学版),2013(6):41-43. WU J M,ZHOU J. Optimization rule based on Oracle database SQL query[J]. Journal of Shaanxi University of Technology (Natural Science Edition),2013(6):41-43.
[8] 马汉. 数据库SQL优化大总结[J]. 计算机与网络,2014(14):119-121. MA H. Summary of optimizing SQL in database[J]. Computer & Network,2014(14):119-121.
[9] 林小静,薛永生. 数据仓库中物化视图选择策略[J]. 计算机工程与设计,2007,28(13):3056-3059. LIN X J,XUE Y S. Selection strategy of materialized views in data warehouse[J]. Computer Engineering and Design,2007, 28(13):3056-3059.
[10] 孙娜,曹君. 存储过程的数据库安全性应用研究[J]. 计算机与数字工程,2009,37(3):154-156. SUN N,CAO J. Study on stored procedure database security application[J]. Computer & Digital Engineering,2009,37(3):154-156.
[11] 郭磊,许芳霞,周利剑,等. 管道完整性系统数据集成与应用[J]. 油气储运,2014,33(6):593-597. GUO L,XU F X,ZHOU L J,et al. Data integration and application of pipeline integrity management system[J]. Oil & Gas Storage and Transportation,2014,33(6):593-597.
[12] 魏东吼,董绍华,梁伟. 地下储气库完整性管理体系及相关技术应用研究[J]. 油气储运,2015,34(2):115-121. WEI D H,DONG S H,LIANG W. Applied research of integrity management system and related technologies of underground gas storage[J]. Oil & Gas Storage and Transportation,2015,34(2):115-121.

相似文献/References:

[1]董绍华 韩忠晨 杨毅 曹兴.物联网技术在管道完整性管理中的应用[J].油气储运,2012,31(12):906.[doi:10.6047/j.issn.1000-8241.2012.12.008]
　Dong Shaohua,Han Zhongchen,Yang Yi,et al.The application of Internet of Things technology in the integrity management of pipeline[J].Oil & Gas Storage and Transportation,2012,31(9):906.[doi:10.6047/j.issn.1000-8241.2012.12.008]
[2]赵永起 刘国群 张文东 路遥.城市燃气管网完整性管理实施流程[J].油气储运,2012,31(12):909.[doi:10.6047/j.issn.1000-8241.2012.12.009]
　Zhao Yongqi,Liu Guoqun,Zhang Wendong,et al.The implementation flow process of integrity management for urban gas networks[J].Oil & Gas Storage and Transportation,2012,31(9):909.[doi:10.6047/j.issn.1000-8241.2012.12.009]
[3]陈健峰,税碧垣,沈煜欣,等.储罐与工艺管道的完整性管理[J].油气储运,2011,30(04):259.[doi:10.6047/j.issn.1000-8241.2011.04.005]
　Chen Jianfeng,Shui Biyuan,Shen Yuxin,et al.Integrity management of storage tank and process pipeline[J].Oil & Gas Storage and Transportation,2011,30(9):259.[doi:10.6047/j.issn.1000-8241.2011.04.005]
[4]陈健峰,陈次昌,税碧垣,等.管道完整性管理技术集成与应用[J].油气储运,2011,30(02):81.[doi:10.6047/j.issn.1000-8241.2011.02.001]
　Chen Jianfeng,Chen Cichang,Shui Biyuan,et al.The integration and application of pipeline integrity management technologies [J].Oil & Gas Storage and Transportation,2011,30(9):81.[doi:10.6047/j.issn.1000-8241.2011.02.001]
[5]郑洪龙,许立伟,谷雨雷,等.管道完整性管理效能评价指标体系[J].油气储运,2012,31(1):8.[doi:10.6047/j.issn.1000-8241.2012.02.002]
　Zheng Honglong,Xu Liwei,Gu Yulei,et al.Preliminary study on the index system of pipeline integrity management performance valuation[J].Oil & Gas Storage and Transportation,2012,31(9):8.[doi:10.6047/j.issn.1000-8241.2012.02.002]
[6]张华兵 程五一 周利剑 冯庆善 郑洪龙 戴联双 项小强 曹涛 刘悦.管道公司管道风险评价实践[J].油气储运,2012,31(2):96.[doi:10.6047/j.issn.1000-8241.2012.02.004]
　Zhang Huabing,Cheng Wuyi,Zhou Lijian,et al.Pipeline risk assessment practice of PetroChina Pipeline Company[J].Oil & Gas Storage and Transportation,2012,31(9):96.[doi:10.6047/j.issn.1000-8241.2012.02.004]
[7]姚安林,徐涛龙,李又绿,等.国内油气管道完整性管理应予重视的问题[J].油气储运,2010,29(10):721.[doi:10.6047/j.issn.1000-8241.2010.10.001]
　Yao Anlin,Xu Taolong,Li Youlv.Top Priority of Pipeline Integrity Management for Domestic Oil and Gas Pipelines[J].Oil & Gas Storage and Transportation,2010,29(9):721.[doi:10.6047/j.issn.1000-8241.2010.10.001]
[8]余海冲,冯庆善,周利剑,等.优化APDM模型提高管道定位精度[J].油气储运,2009,28(10):76.[doi:10.6047/j.issn.1000-8241.2009.10.021]
　YU Haichong,FENG Qingshan.Optimizing APDM Model to Increase Location Accuracy of Pipeline[J].Oil & Gas Storage and Transportation,2009,28(9):76.[doi:10.6047/j.issn.1000-8241.2009.10.021]
[9]税碧垣,艾慕阳,冯庆善.油气站场完整性管理技术思路[J].油气储运,2009,28(7):11.[doi:DOI:10.6047/j.issn.1000-8241.2009.07.004]
　SHUI Biyuan,AI Muyang.Technology Route to Integrity Management of Pipeline Facilities[J].Oil & Gas Storage and Transportation,2009,28(9):11.[doi:DOI:10.6047/j.issn.1000-8241.2009.07.004]
[10]杨祖佩,艾慕阳,冯庆善,等.管道完整性管理研究的最新进展[J].油气储运,2008,27(7):1.[doi:10.6047/j.issn.1000-8241.2008.07.001]
　YANG Zupei,AI Muyang.The Latest Progress on the Study of Pipeline Integrity Management[J].Oil & Gas Storage and Transportation,2008,27(9):1.[doi:10.6047/j.issn.1000-8241.2008.07.001]
[11]刘亮 　高海康 　徐杰 　王梓力 　韩文超 　欧新伟 　张展.基于管道完整性管理的管道巡检闭环平台的设计[J].油气储运,2016,35(预出版):1.
　LIU Liang,GAO Haikang,XU Jie,et al.Design of closed-loop pipeline inspection platform based on pipeline integrity management[J].Oil & Gas Storage and Transportation,2016,35(9):1.
[12]刘亮,高海康,徐杰,等.基于完整性管理的管道巡检闭环平台的设计[J].油气储运,2016,35(9):924.[doi:10.6047/j.issn.1000-8241.2016.09.003]
　LIU Liang,GAO Haikang,XU Jie,et al.Design of closed-loop pipeline inspection platform based on integrity management[J].Oil & Gas Storage and Transportation,2016,35(9):924.[doi:10.6047/j.issn.1000-8241.2016.09.003]
[13]董绍华.中国油气管道完整性管理20年回顾与发展建议[J].油气储运,2020,39(01):1.
　DONG Shaohua.Review of China’s oil and gas pipeline integrity management in the past 20 years and development suggestions[J].Oil & Gas Storage and Transportation,2020,39(9):1.

备注/Memo

收稿日期:2015-09-14;改回日期:2016-05-27。
基金项目:中国石油集团公司投资项目“管道完整性管理系统”，计划2010-12。
作者简介:高海康,男,助理工程师,1987年生,2013年硕士毕业于中国石油大学(华东)计算机科学与技术专业,现主要从事管道完整性数据管理、系统建设等信息化技术的研究工作。地址:河北省廊坊市金光道51号,065000。电话:0316-2175143,Email:gaohk@petrochina.com.cn

更新日期/Last Update: 1900-01-01