LUO Rui, HE Qing, CHEN Feng, et al. Development and application of time-series data query and statistic component based on supervisory graph[J]. Thermal power generation, 2023, 52(11): 165-172.
LUO Rui, HE Qing, CHEN Feng, et al. Development and application of time-series data query and statistic component based on supervisory graph[J]. Thermal power generation, 2023, 52(11): 165-172. DOI: 10.19666/j.rlfd.202306084.
基于电力生产画面的时序数据查询统计组件开发及应用
摘要
生产数据的查询统计功能始终是各生产管理业务分析决策的基础,多年信息化建设及其应用效果显示,数据查询的模式、功能和性能仍不能满足实际需求。基于此,提出并开发了基于监控画面软件的数据查询统计组件,通过对组件的数据链路架构的设计、数据读取和统计机制的优化、数据资源的共享和备份等方面的开发和思考,实现了对生产实时数据的个性化管理、轻量级分析、灵活性读取的良好效果。所开发的画面标签组件和数据链路模式经过测试和实际应用表明,基于画面的数据查询统计功能与数据库实现了松耦合,支持C/S和B/S 2种部署模式和国产化替代需求,支持集成多数据源和多层级机构下的画面数据统一查询。其数据查询效率和趋势查询效率达到或接近数据库原生管理工具的水平,优于常规监控信息系统(supervisory information system
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.