罗睿,何清,陈丰,王毅,田晨,李小波,韩秀清

• 1:西安热工研究院有限公司
• 2:华能国际电力股份有限公司

摘要(Abstract)：

生产数据的查询统计功能始终是各生产管理业务分析决策的基础，多年信息化建设及其应用效果显示，数据查询的模式、功能和性能仍不能满足实际需求。基于此，提出并开发了基于监控画面软件的数据查询统计组件，通过对组件的数据链路架构的设计、数据读取和统计机制的优化、数据资源的共享和备份等方面的开发和思考，实现了对生产实时数据的个性化管理、轻量级分析、灵活性读取的良好效果。所开发的画面标签组件和数据链路模式经过测试和实际应用表明，基于画面的数据查询统计功能与数据库实现了松耦合，支持C/S和B/S 2种部署模式和国产化替代需求，支持集成多数据源和多层级机构下的画面数据统一查询。其数据查询效率和趋势查询效率达到或接近数据库原生管理工具的水平，优于常规监控信息系统（supervisory information system,SIS）网站的查询效率。最后，提出了监控画面标签组件功能与SIS数据查询、报表系统的整合共享机制，有助于降低数据使用的重复工作成本。

关键词(KeyWords)： 实时数据;数据查询;厂级监控信息系统;组件;生产画面

Abstract:

Keywords:

基金项目(Foundation): 西安热工研究院有限公司科技项目（TT-22-SAK04）~~

作者(Author): 罗睿,何清,陈丰,王毅,田晨,李小波,韩秀清

DOI: 10.19666/j.rlfd.202306084

参考文献(References)：

• [1]杨新民,曾卫东,肖勇.火电站智能化现状及展望[J].热力发电, 2019, 48(9):1-8.YANG Xinmin, ZENG Weidong, XIAO Yong. Present situation and prospect of thermal power plant intelligentization[J]. Thermal Power Generation, 2019,48(9):1-8.
• [2]赖晨捷.数据挖掘技术在电厂厂级监控信息系统中的应用实施[D].上海:上海交通大学, 2014:1-3.LAI Chenjie. The application of data mining technology in power plant supervisory information system[D].Shanghai:Shanghai Jiaotong University, 2014:1-3.
• [3]任天昊.燃煤电厂环保监控系统关键技术研究与实现[D].郑州:郑州大学, 2020:14-16.REN Tianhao. Design and implementation of environmental monitoring system for coal-fired power plants[D].Zhengzhou:Zhengzhou University, 2020:14-16.
• [4]侯子良.电厂监管信息系统发展困境和曙光[J].自动化博览, 2019, 310(7):8-11.HOU Ziliang. Dilemma and dawn about supervisory information system in power plant[J]. Automation Panorama, 2019, 310(7):8-11.
• [5]王林童,赵腾,张焰,等.基于Hadoop的风力发电监测大数据存储优化及并行查询方法[J].电测与仪表,2018, 55(11):1-6.WANG Lintong, ZHAO Teng, ZHANG Yan, et al. Storage optimization and parallel query method for big data of wind power monitoring based on Hadoop[J]. Electrical Measurement&Instrumentation, 2018, 55(11):1-6.
• [6]孙壮志,张人千,夏国平.利用ActiveX技术实现B/S模式的电厂实时数据综合查询[J].计算机应用研究,2002(5):95-96.SUN Zhuangzhi, ZHANG Renqian, XIA Guoping. The implementation of real-time data comprehensive query browser/server model in power plant using by ActiveX technology[J]. Application Research of Computers,2002(5):95-96.
• [7]王睿.火力发电厂厂级监控系统的设计与实现[D].成都:电子科技大学, 2015:10-14.WANG Rui. The design and development of electricity information acquisition and management system[D].Chengdu:University of Electronic Science and Technology of China, 2015:10-14.
• [8]胡波,陈俊,杨柳,等.全国产分散控制系统开发与应用[J].热力发电, 2022, 51(3):159-165.HU Bo, CHEN Jun, YANG Liu, et al. Development and application of fully domestic distributed control system[J]. Thermal Power Generation, 2022, 51(3):159-165.
• [9]张雄,肖平,郭赉佳,等.高可用厂级监控信息系统设计和应用[J].计算机应用与软件, 2022, 39(10):35-41.ZHANG Xiong, XIAO Ping, GUO Laijia, et al. The design and application of the high available network of supervisory information system[J]. Computer Applications and Software, 2022, 39(10):35-41.
• [10]汤利民,王大鹏,吕佩哲,等.基于厂级监控信息系统的火电厂数据传输监测系统的开发应用[J].热力发电,2022, 51(9):111-118.TANG Limin, WANG Dapeng, LYU Peizhe, et al.Development and application of thermal power plant data transmission monitoring system based on plant-level supervisory information system[J]. Thermal Power Generation, 2022, 51(9):111-118.
• [11]于治国. PI实时数据库系统在电厂厂级信息监控系统中的应用[J].山东师范大学学报(自然科学版), 2017,32(2):40-44.YU Zhiguo. Application of PI real-time database in supervisory information system[J]. Journal of Shandong Normal University(Natural Science), 2017, 32(2):40-44.
• [12]杜石存.信息集成系统在电厂的应用研究[D].保定:华北电力大学, 2017:1-4.DU Shicun. Research on application of information integrated system in power plant[D]. Baoding:North China Electric Power University, 2017:1-4.
• [13]庞武华,王智微,王毅,等.电力企业实时数据治理框架研究及设计[J].电力信息与通信技术, 2022, 20(5):47-53.PANG Wuhua, WANG Zhiwei, WANG Yi, et al. Research and design of real-time data governance framework for power enterprises[J]. Electric Power Information and Communication Technology, 2022, 20(5):47-53.
• [14]黄克成.基于键值数据库的电力数据实时管理系统设计和实现[D].济南:山东大学, 2021:10-11.HUANG Kecheng. Design and implementation for a keyvalue store based real-time smart grid data management system[D]. Jinan:Shandong University, 2021:10-11.
• [15]张帅,胡卉芪,徐尧强,等.面向异常检测的时序数据库查询优化[J].华东师范大学学报(自然科学版),2023, 228(2):119-131.ZHANG Shuai, HU Huiqi, XU Yaoqiang, et al. Time series database query optimization for anomaly detection[J]. Journal of East China Normal University(Natural Science), 2023, 228(2):119-131.
• [16]赵鑫,万英格,刘英博.一种时序数据模式演化的跟踪与查询方法[J].计算机研究与发展, 2022, 59(9):1869-1886.ZHAO Xin, WAN Yingge, LIU Yingbo. Tracking and querying over timeseries data with schema evolution[J].Journal of Computer Research and Development, 2022,59(9):1869-1886.
• [17]沈赫男. SIS系统在火力发电厂的应用研究[D].保定:华北电力大学, 2014:30-32.SHEN Henan. Application research of SIS system in thermal power plant[D]. Baoding:North China Electric Power University, 2014:30-32.
• [18]袁德争.基于PI数据库的核电厂工业数据系统的研究与设计[D].上海:上海交通大学, 2017:52-53.YUAN Dezheng. Nuclear power plant industrial data systems research and design based on PI database[D].Shanghai:Shanghai Jiaotong University, 2017:52-53.
• [19]高雁.厂级监控系统在冶金热电企业中的应用[J].电力学报, 2013, 28(1):69-73.GAO Yan. Plant-level supervisory system application in a metallurgical thermo industry[J]. Journal of Electric Power, 2013, 28(1):69-73.
• [20]吕立军.基于OpenPlant实时数据库的发电厂SIS设计与实现[D].保定:华北电力大学, 2010:27-30.LYU Lijun. Design and implementation of power plant’s SIS based on OpenPlant real-time database[D]. Baoding:North China Electric Power University, 2010:27-30.
• [21]韩建民,吴米兰,岑婷婷,等.基于PI-API的PI数据库访问技术的研究[J].浙江师范大学学报(自然科学版), 2008, 92(4):424-427.HAN Jianmin, WU Milan, CEN Tingting, et al. PI database access technology based on PI-API[J]. Journal of Zhejiang Normal University(Natural Science), 2008,92(4):424-427.
• [22]冯乙伦.基于OpenPlant实时数据库的厂级监控信息系统的实现[D].大连:大连理工大学, 2013:17-25.FENG Yilun. Implementation of SIS based on openplant real time database[D]. Dalian:Dalian University of Technology, 2013:17-25.
• [23]杨新民,陈丰,曾卫东,等.智能电站的概念及结构[J].热力发电, 2015, 44(11):10-13.YANG Xinmin, CHEN Feng, ZENG Weidong, et al.Concept and structure of intelligent power stations[J].Thermal Power Generation, 2015, 44(11):10-13.
• [24]胡跃伟.大数据在智慧电厂监控信息系统SIS的应用[J].电子技术, 2021, 50(12):22-23.HU Yuewei. Application of big data in intelligent power plant supervisor information system SIS[J]. Computer Engineering, 2021, 50(12):22-23.
• [25]盛家,房俊,郭晓乾,等.时序数据多维聚合查询服务的实现[J].重庆大学学报, 2020, 43(7):121-128.SHENG Jia, FANG Jun, GUO Xiaoqian, et al.Implementation of multidimensional aggregate query service for time series data[J]. Journal of Chongqing University, 2020, 43(7):121-128.