基于电力生产画面的时序数据查询统计组件开发及应用  

Development and application of time-series data query and statistic component based on supervisory graph

作　　者：罗睿 何清[1] 陈丰[2] 王毅[1] 田晨 李小波 韩秀清 LUO Rui;HE Qing;CHEN Feng;WANG Yi;TIAN Chen;LI Xiaobo;HAN Xiuqing(Xi’an Thermal Power Research Institute Co.,Ltd.,Xi’an 710054,China;Huaneng Power International Inc.,Beijing 100031,China)

机构地区：[1]西安热工研究院有限公司,陕西西安710054 [2]华能国际电力股份有限公司,北京100031

出　　处：《热力发电》2023年第11期165-172,共8页Thermal Power Generation

基　　金：西安热工研究院有限公司科技项目(TT-22-SAK04)。

摘　　要：生产数据的查询统计功能始终是各生产管理业务分析决策的基础,多年信息化建设及其应用效果显示,数据查询的模式、功能和性能仍不能满足实际需求。基于此,提出并开发了基于监控画面软件的数据查询统计组件,通过对组件的数据链路架构的设计、数据读取和统计机制的优化、数据资源的共享和备份等方面的开发和思考,实现了对生产实时数据的个性化管理、轻量级分析、灵活性读取的良好效果。所开发的画面标签组件和数据链路模式经过测试和实际应用表明,基于画面的数据查询统计功能与数据库实现了松耦合,支持C/S和B/S 2种部署模式和国产化替代需求,支持集成多数据源和多层级机构下的画面数据统一查询。其数据查询效率和趋势查询效率达到或接近数据库原生管理工具的水平,优于常规监控信息系统(supervisory information system,SIS)网站的查询效率。最后,提出了监控画面标签组件功能与SIS数据查询、报表系统的整合共享机制,有助于降低数据使用的重复工作成本。The function of query and statistics of data is always the basis of production management and decisionmaking businesses.According to the results of information construction and applications for many years,the mode,function and performance of data query and statistics still do not satisfy the actual needs.A component for data query and statistics based on supervisory graph software is proposed and developed.Through the design of data path architecture,the optimization of query and statistics mechanism,the developed component has achieved personalized management,lightweight analysis and flexible query of real-time data.The query and statistic component and data link mode developed in this study have been tested and applied in practice.The results show that the function of data query and statistics achieves loose coupling with database.The component can support both the operation modes of C/S and B/S,and provide unified query and statistics of data through supervisory graph from multi-data sources and multi-level organizations.The efficiency of data query and trend query reaches or approaches the level of database native management tools,and is better than that of conventional supervisory information system(SIS)websites.The integration mechanism of data components based on graph with SIS data query and report system is proposed,which helps to reduce the repetitive cost of data use.

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

分 类 号：TM73[电气工程—电力系统及自动化] TP311.52[自动化与计算机技术—计算机软件与理论]