煤气平衡认证分析系统应用软件的研究与开发
|
摘要
煤气是工业生产中重要的产品和燃料，是宝贵的能源资源。因此，如何尽可能的减少煤气计量系统的的计量误差，当计量系统出现故障导致煤气的总发生量与总消耗量失去平衡时，如何合理的平衡各种煤气的总发生量与总消耗量，科学的认证各个煤气用户的煤气消耗量，成为一项意义重大的研究和开发课题。
本文以某钢铁集团公司为背景，建立了一个煤气平衡认证分析系统。该系统通过使用网络数据库采集各煤气用户的相关历史数据，建立了用户消耗模型；通过综合考虑消耗模型数据、历史数据、故障诊断设置和煤气计量管理文件，提出了一种新的煤气自动平衡认证的方法，实现了高炉煤气、焦炉煤气、混合煤气和转炉煤气的自动分类平衡；通过在线获取煤气检测点的实时数据，实现了煤气热值和密度的软测量；通过分析比较检测点的实时数据，建立了一种新颖的虚拟仪表，能够在线显示实时数据、检测流量计算公式的参数设置、检测测量装置的量程配置和辅助现场操作人员校正仪表量程；通过建立Web服务器，实现了煤气平衡认证过程的公开化和透明化。
Gas is not only an important product and fuel in industrial production, but also a valuable energy resource as well. Therefore, it has been a significant and important item in researching and developing mat how to minimize the error of the measure system and , when gas' total outputs and consumes lost balance resulting from errors occurring in the gas metering system , how to rationally balance all sorts gas' total outputs and consumes and scientifically attest of the amount of gas that users have consumed.
This paper presents an attestation and analysis system for the gas balance based on some steel company. In the system, by collecting the gas customers' relational historical data using a network-database, a consumption model is established. By comprehensive using the consumption model data, the historical data, the fault diagnosis and the files of gas measure management, a new technique of the automatic attestation for the gas balance is put forward, and then the automatic balances of blast furnace gas, burnt stove coal gas, mixed gas and converter coal gas are realized respectively adopting the technique. By collecting the on-line real time data, soft measurement of density and calorific value of gas is implemented. By analyzing and comparing the on-line real time data of each measure point, a original virtual instrument is be put up, which is capable of displaying the on-line real time data, verifying the formula of computing the flow of gas, testing the measure quantity one of the device , and helping the
on-the-spot operators to emend the measure quantity one of the device as well as. By setting up the Web server, the gas balance attestation process is provided into the open transparently.
本文以某钢铁集团公司为背景，建立了一个煤气平衡认证分析系统。该系统通过使用网络数据库采集各煤气用户的相关历史数据，建立了用户消耗模型；通过综合考虑消耗模型数据、历史数据、故障诊断设置和煤气计量管理文件，提出了一种新的煤气自动平衡认证的方法，实现了高炉煤气、焦炉煤气、混合煤气和转炉煤气的自动分类平衡；通过在线获取煤气检测点的实时数据，实现了煤气热值和密度的软测量；通过分析比较检测点的实时数据，建立了一种新颖的虚拟仪表，能够在线显示实时数据、检测流量计算公式的参数设置、检测测量装置的量程配置和辅助现场操作人员校正仪表量程；通过建立Web服务器，实现了煤气平衡认证过程的公开化和透明化。
Gas is not only an important product and fuel in industrial production, but also a valuable energy resource as well. Therefore, it has been a significant and important item in researching and developing mat how to minimize the error of the measure system and , when gas' total outputs and consumes lost balance resulting from errors occurring in the gas metering system , how to rationally balance all sorts gas' total outputs and consumes and scientifically attest of the amount of gas that users have consumed.
This paper presents an attestation and analysis system for the gas balance based on some steel company. In the system, by collecting the gas customers' relational historical data using a network-database, a consumption model is established. By comprehensive using the consumption model data, the historical data, the fault diagnosis and the files of gas measure management, a new technique of the automatic attestation for the gas balance is put forward, and then the automatic balances of blast furnace gas, burnt stove coal gas, mixed gas and converter coal gas are realized respectively adopting the technique. By collecting the on-line real time data, soft measurement of density and calorific value of gas is implemented. By analyzing and comparing the on-line real time data of each measure point, a original virtual instrument is be put up, which is capable of displaying the on-line real time data, verifying the formula of computing the flow of gas, testing the measure quantity one of the device , and helping the
on-the-spot operators to emend the measure quantity one of the device as well as. By setting up the Web server, the gas balance attestation process is provided into the open transparently.
引文
[1]熊永华，吴敏，曹卫华．煤气平衡认证分析系统的设计与实现．计算机应用研究．(已录用)．
[2]邓茂焕．节流式差压流量计的发展和现状．计量测试，2002，(6)：30-32
[3]陈尚恒，苏利平．强化计量检测管理提高煤气数据准确率．工业计量，2002，(1)：19-21
[4]杨庆堂．钢铁企业煤气平衡．莱钢科技．1994，000(005)：62-67
[5]张建良，王好．钢铁企业煤气系统的优化利用模型．包头钢铁学院院报．2002，21(3)：280-284
[6]孙贻公．对大型钢铁联合企业煤气平衡问题的探讨．钢铁．2003，38(6)：59-64
[7]孙国军，刘中兰．依靠技术进步实现煤气计量科学化管理．城市煤气．2001，313(3)：8-11
[8]B.M.Belyaev, V.G.Patrikeev, et al. Reduction The Balance In Gas Distribution Using The VMM Algorithm. Measurement Techniques. 2002,45(3):314-317
[9]Mylvaganam, Saba. Gas density metering in ultrasonic gas flowmeters using impedance measurements and chemometrics. Proceedings of the IEEE Ultrasonics Symposium. 1999,1:435-439
[10]Collings, Bignell, Hews-Taylor N, et al. Ultrasonic metering of gas flows. Proceedings of the Ultrasonics International Conference. 1993,6:205-208
[11]Warner, Kevin L. Transit time ultrasonic flow meters for natural gas measurement. Proceedings of the International Pipeline Conference, IPC. 1996,(2): 1049-1053
[12]王平，苗朋厚，邢建春．iFIX组态软件在钢铁厂生产调度监控系统中的应用．工业控制计算机2002，15(6)：51-54
[13]Hu Jing, Fang Yanjun. Communication between iFIX and relational database based on the ODBC technology. Control & Automation. 2003, (2):19-20
[14]韩志刚．结构随机变化系统的多层递阶预报．自动化学报．1990，16(5)：421-428
[15]张晓东，韩志刚．一种改进的多层递阶预报方法研究．哈尔滨工业大学学报，2002，34(3)：436-439
[16]吴为英，向阳，崔家保．改进的多层递阶回归算法在进出口贸易中的应用．山东科技大学学报(自然科学版)，2003，22(1)：54-57
[17]韩志刚．自适应控制系统设计的参数辨识途径．自动化学报．1992，9(4)：374-379
[18]汤兵勇．多层递阶规划方法．系统工程理论方法应用．1994，3(4)：16-20
[19]潘爱民．一致的数据访问技术ADO/OLE DB. 微电脑世界周刊，1999，(4)：16-19
[20]Blakeley, Jose A. Data access for the masses through OLE DB. SIGMOD Record(ACM Special Interest Group on Management of Data). 1996, 25(2): 161-172
[21]邹年圣，江国星．在VC++6.0下利用OLE DB访问关系数据库．计算机与现代化，2001，(2)：23-27
[22]Stanley B.Lippman, Josee Lajoie, 著．潘爱民，张丽，译．C++Primer第三版．北京：中国电力出版社，2002．503-572
[23]钱能．C++程序设计教程．北京：清华大学出版社，1999．232-257
[24]Eric Grancher, Maeiej Marczukajtis. An Evaluation of Oracle for Persistent Data Storage and Analysis of LHC Physics Data. Computing in High Energe and Nuclear Physics. 2001, 5: 258-262
[25]Oracle8 Documentation. Oracle Corporation. 2001, 55-64
[26]Carol McCullough-Dieter，Jatinder Prem，Ramesh Chandak，等著，张振奎，王元鹏，谢硕琴，等译．Oracle8实用大全．北京：中国水利水电出版社，1999．39-94
[27]Wen LP, Jesshope C, Zhang LJ, et al. Web Services technology and learning technology - A Web-Services model for constructing decentralized virtual learning environments. PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON WEB SERVICES. 2003, 21: 507-514
[28]Luo Jun, Li Renwang, Chen Liping. Constructing three-layer product development process system management using JSP/Servlet. Computer Engineering. 2002, 28(4): 44-48
[29]Ghosh A, Marples D, Moyer S. ASP perspectives on networked appliances. IEEE International Conference on Communications. 2001, 4:1299-1302
[30]晓通网络数据库研究所．Oracle WebDB Intemet应用开发技术．内蒙古：内蒙古人民出版社，2000．2-14
[31]Li Wen-Syan, Shim, Junho, et al. WebDB hyperrnedia database system. IEICE Transactions on Information and Systems. 1999, vE82-D(1): 266-277
[32]Vincent Ng, Mok Kwan Ho. An Intelligent Agent for Web Advertisements. International Journal of Foundations of Computer Science. 2002, 13(4): 8-15
[33]李文生，冯风娟，霍宇红，等．Oracle数据库系统——基础与工具．北京：人民邮电出版社，1999．130-200
[34]贾克斌．计算机网络技术对测控技术发展的促进作用[J]．测控技术，1998，17(4)： 22
[35]秦勇，陈伯金．基于虚拟仪表的状态监测与故障诊断系统．化工自动化及仪表．2003，30(2)：41-43
[36]温江涛，孙洁娣．基于虚拟仪器的测量网络研究．自动化与仪器仪表．2003，18(3)：13-16
[37]孙淮清，王建中．流量节流装置设计手册．北京：化学工业出版社，2000.60-180
[38]Chdstova, N.G. Soft computing method for fault measurement diagnosis and data reconciliation in industrial plants. Intelligent Engineering Systems Through Artificial Neural Networks. 2002, 12(10): 301-307
[39]刘辰，高月秋，等．Oracle数据库系统——管理与应用．北京：人民邮电出版社，1999．175-196
[40]Kevin Loney，Marlene Theriault，著，李纪松，周保太，等译．Oracle8i数据库管理员手册．北京：机械工业出版社，2000．262-308
[40]罗晓沛．数据库技术(中级)．北京：清华大学出版社，1999．156-187
[41]William, G.Page,Jr.Nathan, Hughes，著，吴玉平，吴晓蓓，等译．即学即用Oracle8．北京：电加工业出版社，1999．38-74
[42]Hoetque, Jerry. How to successfully protect Oracle database - and how not to. Storage Management Solutions. 1998, 3(5): 25-28
[43]萨师煊，王煤．数据库系统概论．北京：高等教育出版社，2000．169-203
[44]葛卫民，张钢，舒炎泰．基于Oracle高级复计的分布式数据库系统应用研究．计算机工程与应用．2003，039(021)：186-191
[45]BLACK, U.D. TCP/IP and Related Protocols. New York: McGrae-Hill, 1995.56-90
[46]王琴，宋顺林．Oracle数据库管理系统的备份策略及应用举例．计算机工程．2002，28(2)：262-264
[47] V S Subrahmanian. Principles of Multimedia Database Systems, Morgan Kaufmann. 1998
[48] J.Green，JoeGreene，著，王胜清，等译．Oracle8服务器技术精粹．北京：清华大学出版社，1999．203-256
[48] 陈松乔，任胜兵，王国军．现代软件工程．北京：北方交通大学出版社．2002．154-158
[49] Charles Petzold. Programming Windows(Fifth Edition). Microsoft Press, 1998.78-102
[2]邓茂焕．节流式差压流量计的发展和现状．计量测试，2002，(6)：30-32
[3]陈尚恒，苏利平．强化计量检测管理提高煤气数据准确率．工业计量，2002，(1)：19-21
[4]杨庆堂．钢铁企业煤气平衡．莱钢科技．1994，000(005)：62-67
[5]张建良，王好．钢铁企业煤气系统的优化利用模型．包头钢铁学院院报．2002，21(3)：280-284
[6]孙贻公．对大型钢铁联合企业煤气平衡问题的探讨．钢铁．2003，38(6)：59-64
[7]孙国军，刘中兰．依靠技术进步实现煤气计量科学化管理．城市煤气．2001，313(3)：8-11
[8]B.M.Belyaev, V.G.Patrikeev, et al. Reduction The Balance In Gas Distribution Using The VMM Algorithm. Measurement Techniques. 2002,45(3):314-317
[9]Mylvaganam, Saba. Gas density metering in ultrasonic gas flowmeters using impedance measurements and chemometrics. Proceedings of the IEEE Ultrasonics Symposium. 1999,1:435-439
[10]Collings, Bignell, Hews-Taylor N, et al. Ultrasonic metering of gas flows. Proceedings of the Ultrasonics International Conference. 1993,6:205-208
[11]Warner, Kevin L. Transit time ultrasonic flow meters for natural gas measurement. Proceedings of the International Pipeline Conference, IPC. 1996,(2): 1049-1053
[12]王平，苗朋厚，邢建春．iFIX组态软件在钢铁厂生产调度监控系统中的应用．工业控制计算机2002，15(6)：51-54
[13]Hu Jing, Fang Yanjun. Communication between iFIX and relational database based on the ODBC technology. Control & Automation. 2003, (2):19-20
[14]韩志刚．结构随机变化系统的多层递阶预报．自动化学报．1990，16(5)：421-428
[15]张晓东，韩志刚．一种改进的多层递阶预报方法研究．哈尔滨工业大学学报，2002，34(3)：436-439
[16]吴为英，向阳，崔家保．改进的多层递阶回归算法在进出口贸易中的应用．山东科技大学学报(自然科学版)，2003，22(1)：54-57
[17]韩志刚．自适应控制系统设计的参数辨识途径．自动化学报．1992，9(4)：374-379
[18]汤兵勇．多层递阶规划方法．系统工程理论方法应用．1994，3(4)：16-20
[19]潘爱民．一致的数据访问技术ADO/OLE DB. 微电脑世界周刊，1999，(4)：16-19
[20]Blakeley, Jose A. Data access for the masses through OLE DB. SIGMOD Record(ACM Special Interest Group on Management of Data). 1996, 25(2): 161-172
[21]邹年圣，江国星．在VC++6.0下利用OLE DB访问关系数据库．计算机与现代化，2001，(2)：23-27
[22]Stanley B.Lippman, Josee Lajoie, 著．潘爱民，张丽，译．C++Primer第三版．北京：中国电力出版社，2002．503-572
[23]钱能．C++程序设计教程．北京：清华大学出版社，1999．232-257
[24]Eric Grancher, Maeiej Marczukajtis. An Evaluation of Oracle for Persistent Data Storage and Analysis of LHC Physics Data. Computing in High Energe and Nuclear Physics. 2001, 5: 258-262
[25]Oracle8 Documentation. Oracle Corporation. 2001, 55-64
[26]Carol McCullough-Dieter，Jatinder Prem，Ramesh Chandak，等著，张振奎，王元鹏，谢硕琴，等译．Oracle8实用大全．北京：中国水利水电出版社，1999．39-94
[27]Wen LP, Jesshope C, Zhang LJ, et al. Web Services technology and learning technology - A Web-Services model for constructing decentralized virtual learning environments. PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON WEB SERVICES. 2003, 21: 507-514
[28]Luo Jun, Li Renwang, Chen Liping. Constructing three-layer product development process system management using JSP/Servlet. Computer Engineering. 2002, 28(4): 44-48
[29]Ghosh A, Marples D, Moyer S. ASP perspectives on networked appliances. IEEE International Conference on Communications. 2001, 4:1299-1302
[30]晓通网络数据库研究所．Oracle WebDB Intemet应用开发技术．内蒙古：内蒙古人民出版社，2000．2-14
[31]Li Wen-Syan, Shim, Junho, et al. WebDB hyperrnedia database system. IEICE Transactions on Information and Systems. 1999, vE82-D(1): 266-277
[32]Vincent Ng, Mok Kwan Ho. An Intelligent Agent for Web Advertisements. International Journal of Foundations of Computer Science. 2002, 13(4): 8-15
[33]李文生，冯风娟，霍宇红，等．Oracle数据库系统——基础与工具．北京：人民邮电出版社，1999．130-200
[34]贾克斌．计算机网络技术对测控技术发展的促进作用[J]．测控技术，1998，17(4)： 22
[35]秦勇，陈伯金．基于虚拟仪表的状态监测与故障诊断系统．化工自动化及仪表．2003，30(2)：41-43
[36]温江涛，孙洁娣．基于虚拟仪器的测量网络研究．自动化与仪器仪表．2003，18(3)：13-16
[37]孙淮清，王建中．流量节流装置设计手册．北京：化学工业出版社，2000.60-180
[38]Chdstova, N.G. Soft computing method for fault measurement diagnosis and data reconciliation in industrial plants. Intelligent Engineering Systems Through Artificial Neural Networks. 2002, 12(10): 301-307
[39]刘辰，高月秋，等．Oracle数据库系统——管理与应用．北京：人民邮电出版社，1999．175-196
[40]Kevin Loney，Marlene Theriault，著，李纪松，周保太，等译．Oracle8i数据库管理员手册．北京：机械工业出版社，2000．262-308
[40]罗晓沛．数据库技术(中级)．北京：清华大学出版社，1999．156-187
[41]William, G.Page,Jr.Nathan, Hughes，著，吴玉平，吴晓蓓，等译．即学即用Oracle8．北京：电加工业出版社，1999．38-74
[42]Hoetque, Jerry. How to successfully protect Oracle database - and how not to. Storage Management Solutions. 1998, 3(5): 25-28
[43]萨师煊，王煤．数据库系统概论．北京：高等教育出版社，2000．169-203
[44]葛卫民，张钢，舒炎泰．基于Oracle高级复计的分布式数据库系统应用研究．计算机工程与应用．2003，039(021)：186-191
[45]BLACK, U.D. TCP/IP and Related Protocols. New York: McGrae-Hill, 1995.56-90
[46]王琴，宋顺林．Oracle数据库管理系统的备份策略及应用举例．计算机工程．2002，28(2)：262-264
[47] V S Subrahmanian. Principles of Multimedia Database Systems, Morgan Kaufmann. 1998
[48] J.Green，JoeGreene，著，王胜清，等译．Oracle8服务器技术精粹．北京：清华大学出版社，1999．203-256
[48] 陈松乔，任胜兵，王国军．现代软件工程．北京：北方交通大学出版社．2002．154-158
[49] Charles Petzold. Programming Windows(Fifth Edition). Microsoft Press, 1998.78-102