关系数据库在高炉数据采集系统中的应用  

Application of Relational Database in Blast Furnace Data Acquisition System

作　　者：赵树民[1] 祁建伟[2] 刘宪云 ZHAO Shumin;QI Jianwei;LIU Xianyun(Shandong Taishan Steel Group Co.,Ltd.,Jinan 271100,China)

机构地区：[1]山东泰山钢铁集团有限公司技术研发中心,山东济南271100 [2]山东泰山钢铁集团有限公司,山东济南271100

出　　处：《山东冶金》2022年第2期54-55,共2页Shandong Metallurgy

摘　　要：依托于高炉数据采集系统,在数据采集力控7.2组态软件中通过SQL语句将实时数据库中的数据存到关系数据库中,在系统报表中可以通过SQL语句实时提取关系数据库中的数据,查询数据更加快捷、方便,解决了高炉数据采集系统中高炉上料报表易出错、查找慢的问题,消除了市场化系统数据丢数的隐患,提升了炼铁市场化核算效率。Relying on the data acquisition system of the blast furnace(BF),the data in the real-time database is stored in the relational database through SQL statements in the data acquisition force control 7.2 configuration software.The data in the relational database can be extracted in real time through SQL statements in the system report,and the data query is more fast and convenient.The problem of error-prone and slow searching in BF feeding statements in BF data acquisition system is solved,the hidden danger of data loss in market system is eliminated,and the market accounting efficiency of ironmaking is improved.

关 键 词：关系数据库 组态软件 高炉数采 报表 

分 类 号：TP273[自动化与计算机技术—检测技术与自动化装置]