[1]孙铁良,张群,刘飞,等.一种在SCADA 系统增加PostgreSQL 支持的数据库开发[J].油气储运,2017,36(10):1201-1205.[doi:10.6047/j.issn.1000-8241.2017.10.017]
 SUN Tieliang,ZHANG Qun,LIU Fei,et al.One database developed by adding PostgreSQL support into SCADA system[J].Oil & Gas Storage and Transportation,2017,36(10):1201-1205.[doi:10.6047/j.issn.1000-8241.2017.10.017]
点击复制

一种在SCADA 系统增加PostgreSQL 支持的数据库开发

参考文献/References:

[1] 田洪波,姜波,武建宏. SCADA 系统在长输管道中的应用和发展[J]. 石油化工自动化,2008,44(4):10-12.TIAN H B,JIANG B,WU J H. The application anddevelopment of the SCADA system in long-distance pipeline[J].
Automation in Petro-chemical Industry,2008,44(4):10-12.
[2] 陈秀丽. 长输管道SCADA 系统选型及应用[J]. 石油化工自动化,2012,48(3):26-29.
CHEN X L. Type selection and application of SCADA system oflong transportation pipeline[J]. Automation in Petro-chemicalIndustry,2012,48(3):26-29.
[3] 陈鹏,李永缙,张伟. 油气管道 SCADA 系统分区分域安全防护方法[J]. 油气储运,2014,33(11):1244-1249.
CHEN P,LI Y J,ZHANG W. Safety protection of oil/gaspipeline SCADA system by partition[J]. Oil & Gas Storage andTransportation,2014,33(11):1244-1249.
[4] 梁现华. 天然气长输管道SCADA 系统建设与改进[J]. 油气储运,2014,33(10):1113-1116.
LIANG X H. Construction and improvement of SCADAsystem in long-distance gas pipeline[J]. Oil & Gas Storage andTransportation,2014,33(10):1113-1116.
[5] 王良,王彤,杨尚. PostgreSQL 存储过程移植方法[J]. 计算机应用,2010,30(增刊1):220-224.WANG L,WANG T,YANG S. Transplanting storedprocedure from Oracle to PostgreSQL[J]. Journal of ComputerApplications,2010,30(S1):220-224.
[6] 刘鑫. MySQL 和PostgreSQL 的对比选择[J]. 沈阳工程学院学报(自然科学版),2011,7(2):171-173.
LIU X. Contrast selection between MySQL and PostgreSQL[J].
Journal of Shenyang Institute of Engineering(Natural Science),2011,7(2):171-173.
[7] 陈文星,付继宗. Linux 下数据库PostgreSQL 分析与应用[J].
电脑开发与应用,2006,19(11):56-57.
CHEN W X,FU J Z. Analysis and application of PostgreSQLdatabase based on Linux[J]. Computer Development &Applications,2006,19(11):56-57.
[8] 蒋亚琴,王红罡,李沁. Postgresql 的TPM 实现和改进[J]. 计算机技术与发展,2013,23(1):21-24.
JIANG Y Q,WANG H G,LI Q. Implementation andimprovement of TPM for Postgresql[J]. Computer Technologyand Development,2013,23(1):21-24.
[9] 张启颜. 跨平台的电力监控系统可视化制表组件实现[J]. 工业控制计算机,2012,25(8):75-78.
ZHANG Q Y. Implementation of cross-platform visualizationreport component of power supervisory and control system[J].
Industrial Control Computer, 2012,25(8):75-78.
[10] 苏燕强. Oracle 分布式数据库及其应用研究[J]. 计算机应用与软件,2004,21(8):36-37,121.
SU Y Q. Reaserch on Oracle distributed database and it’sapplications[J]. Computer Applications and Software,2004,21(8):36-37,121.
[11] MULLINS C S. A quick look at the open source DBMSmarket[J]. Database Trends and Applications,2010,24(1):27-28.
[12] 林河水,程伟,孙玉芳. PostgreSQL 存储管理机制研究[J]. 计算机科学,2004,31(12):76-80.LIN H S,CHENG W,SUN Y F. Research on the storagesystem of the PostgreSQL[J]. Journal of ComputerApplication,2004,31(12):76-80.[13] 古锐,亓伟,叶晓俊. 表空间存储策略在PostgreSQL 中的研究与实现[J]. 计算机工程,2006,32(16):38-40.GU R,QI W,YE X J. Research and implementation oftablespace storage strategy in PostgreSQL[J]. ComputerEngineering,2006,32(16):38-40.[14] 杜庆峰,张卫山. Oracle 的中大型应用系统性能优化分析[J].
计算机工程,2005,31(14):91-93.
DU Q F,ZHANG W S. Performance optimization analysisbased on Oracle database application system[J]. ComputerEngineering,2005,31(14):91-93.
[15] 赵大力,靳其兵,赵梅. Oracle 数据库优化解决方案[J]. 石油化工自动化,2005,41(3):44-46.
ZHAO D L,JIN Q B,ZHAO M. Oracle database optimizationscheme[J]. Automation in Petro-chemical Industry,2005,41(3):44-46.
[16] 姚文琳,王存刚,刘世栋,等. 基于Oracle 的分布式数据库设计与技术[J]. 计算机工程,2006,32(20):89-91.YAO W L,WANG C G,LIU S D,et al. Design andtechnologies of distributed database based on Oracle[J].
Computer Enginnering,2006,32(20):89-91.[17] 刘欣,沈昌祥. 基于PostgreSQL 强制访问控制的实现[J]. 计算机工程,2006,32(2):50-52.LIU X,SHEN C X. Implementation of mandatory access controlbased on PostgreSQL[J]. Computer Engineering,2006,32(2):50-52.[18] 纪鹏程,丁治明,陈滨,等. 基于交通路网的移动对象数据库系统的研究和设计[J]. 计算机应用研究,2007,24(8):278-280.JI P C,DING Z M,CHEN B,et al. research and design oftransportation network based moving object database system[J].
Application Research of Computers,2007,24(8):278-280.[19] 任伟建,王子维,霍凤财,等. 基于Oracle 数据库的油田数据库实时监控系统[J]. 化工自动化及仪表,2015,42(12):1344-1347,1352.
REN W J,WANG Z W,HUO F C,et al. Realtime monitoringsystem for oilfield database based on Oracle database[J]. Controland Instruments in Chemical Industry,2015,42(12):1344-1347,1352.
[20] 萧美阳,叶晓俊. 并发控制实现方法的比较研究[J]. 计算机应用研究,2006,23(6):19-22.XIAO M Y,YE X J. Comparative study on concurrencycontrol[J]. Application Research of Computers,2006,23(6):19-22.

相似文献/References:

[1]黄春芳 陈燕 周芳 黄月 吴州阳 杨松 王自发. 石油天然气管道站内管道爆破吹扫[J].油气储运,2012,31(12):934.[doi:10.6047/j.issn.1000-8241.2012.06.016]
 Huang Chunfang,Chen Yan,Zhou Fang,et al. Bursting purge method in stations of oil and gas pipeline[J].Oil & Gas Storage and Transportation,2012,31(10):934.[doi:10.6047/j.issn.1000-8241.2012.06.016]
[2]戴联双,汤长江,冯治中,等.油气管道恐怖袭击风险评估方法与应用[J].油气储运,2011,30(05):337.[doi:10.6047/j.issn.1000-8241.2011.05.004]
 Dai Lianshuang,Tang Changjiang,Feng Zhizhong,et al.Risk assessment methodology and application for oil and gas pipelines’ terrorist attack[J].Oil & Gas Storage and Transportation,2011,30(10):337.[doi:10.6047/j.issn.1000-8241.2011.05.004]
[3]王乾坤,张争伟,石悦,等.埋地油气管道并行敷设技术发展现状[J].油气储运,2011,30(01):1.[doi:10.6047/j.issn.1000-8241.2011.01.001]
 Wang Qiankun,Zhang Zhengwei,Shi Yue,et al.Development status of the parallel laying technology in underground oil & gas pipelines[J].Oil & Gas Storage and Transportation,2011,30(10):1.[doi:10.6047/j.issn.1000-8241.2011.01.001]
[4]马伟平,贾子麒,赵晋云,等.美国油气管道法规和标准体系的管理模式[J].油气储运,2011,30(01):5.[doi:10.6047/j.issn.1000-8241.2011.01.002]
 Ma Weiping,Jia Ziqi,Zhao Jinyun,et al.Oil and gas pipeline eegulations and management mode of standard system in America[J].Oil & Gas Storage and Transportation,2011,30(10):5.[doi:10.6047/j.issn.1000-8241.2011.01.002]
[5]李鹤林.油气管道失效控制技术[J].油气储运,2011,30(06):401.[doi:10.6047/j.issn.1000-8241.2011.06.001]
 Li Helin.Failure control technique of oil & gas pipeline[J].Oil & Gas Storage and Transportation,2011,30(10):401.[doi:10.6047/j.issn.1000-8241.2011.06.001]
[6]荆宏远,郝建斌,陈英杰,等.管道地质灾害风险半定量评价方法与应用[J].油气储运,2011,30(07):497.[doi:10.6047/j.issn.1000-8241.2011.07.005]
 Jing Hongyuan,Hao Jianbin,Chen Yingjie,et al.Technique and application of geologic hazard risk semi-quantitative assessment of pipeline[J].Oil & Gas Storage and Transportation,2011,30(10):497.[doi:10.6047/j.issn.1000-8241.2011.07.005]
[7]陈敬和.管道外腐蚀直接评价技术[J].油气储运,2011,30(07):523.[doi:10.6047/j.issn.1000-8241.2011.07.012]
 Chen Jinghe.Direct assessment technology of pipeline external corrosion[J].Oil & Gas Storage and Transportation,2011,30(10):523.[doi:10.6047/j.issn.1000-8241.2011.07.012]
[8]吴琋瑛.光缆与油气管道同沟敷设应用实践[J].油气储运,2011,30(07):547.[doi:10.6047/j.issn.1000-8241.2011.07.021]
 Wu Xiying.Technique application of laying in one ditch for fiber cable and oil or gas pipeline[J].Oil & Gas Storage and Transportation,2011,30(10):547.[doi:10.6047/j.issn.1000-8241.2011.07.021]
[9]焦中良,李志文,李志勇,等.油气管道波动压力的雨流计数与分析[J].油气储运,2011,30(08):624.[doi:10.6047/j.issn.1000-8241.2011.08.007]
 Jiao Zhongliang,Li Zhiwen,Li Zhiyong,et al.Rain-flow counting analysis of the fluctuation pressure for oil & gas pipelines[J].Oil & Gas Storage and Transportation,2011,30(10):624.[doi:10.6047/j.issn.1000-8241.2011.08.007]
[10]樊文斌,罗自治,张策.管内高压封堵器的研制[J].油气储运,2011,30(08):657.[doi:10.6047/j.issn.1000-8241.2011.08.015]
 Fan Wenbin,Luo Zizhi,Zhang Ce.Development of high-pressure pipeline isolation plug[J].Oil & Gas Storage and Transportation,2011,30(10):657.[doi:10.6047/j.issn.1000-8241.2011.08.015]
[11]王金柱,王泽根,张丙辰,等.基于SCADA和GIS的油气调控运行系统[J].油气储运,2011,30(12):902.[doi:10.6047/j.issn.1000-8241.2011.12.007]
 Wang Jinzhu,Wang Zegen,Zhang Bingchen,et al.Constitution and function of SCADA / GIS-based oil & gas control system[J].Oil & Gas Storage and Transportation,2011,30(10):902.[doi:10.6047/j.issn.1000-8241.2011.12.007]

备注/Memo

基金项目:中国石油天然气股份有限公司重大工程技术现场试验项目“国产油气管道SCADA 系统软件工业试验”,2015F-1501。
作者简介:孙铁良,男,1967 年生,高级工程师,1991 年毕业于石油大学生产过程自动化专业,现主要从事油气管道SCADA 系统的研究工作。地址:北京市东城区石油大厦,100007。电话:010-59983718,Email: scada_paper@163.com
通讯作者:张群,男,1982 年生,工程师,2009 年硕士毕业于北京化工大学控制理论与控制工程专业,现主要从事石油天然气长距离输送管道SCADA 系统软件的开发和研究工作。地址:北京市西城区广安门内大街311 号院1 号楼10 层,100053。电话:13811508487,Email:buctpest@126.com

更新日期/Last Update: 2017-10-15