基于数据仓库的多源监控告警数据集成系统  

Multi⁃source monitoring and alarm data integration system based on data warehouse

作　　者：陈晨 刘秀 李晋源 CHEN Chen;LIU Xiu;LI Jinyuan(Information center of Yunnan Power Grid Co.,Ltd.,Kunming 650200,China)

机构地区：[1]云南电网有限责任公司信息中心,云南昆明650200

出　　处：《电子设计工程》2023年第7期104-108,共5页Electronic Design Engineering

摘　　要：目前,数据集成系统通过数据融合的方式集成数据,会产生较高的数据集成时延,降低系统集成数据实时性,因此,设计基于数据仓库的多源监控告警数据集成系统。硬件方面,增加消息中间件、规则引擎服务器、数据资源管理器和任务管理器,构建系统硬件架构;设计系统服务器的主CPU模块、内存、CAN总线串口运行访问时序。软件方面,采用数据仓库建立数据集成模型;通过蚁群算法查询多源监控告警数据;设计多源监控告警数据处理步骤,处理多源监控告警数据;计算数据属性,完成数据集成,并在系统的用户界面中展示集成的多源监控告警数据。实验结果表明,设计系统集成多源监控告警数据和多并发任务数据,产生的时延均小于此次实验选择的两组对比系统,具有较优的数据集成实时性。At present,the data integration system integrates data through data fusion,which will produce high data integration delay and reduce the real⁃time performance of system integration data.Therefore,a multi⁃source monitoring and alarm data integration system based on data warehouse is designed.In terms of hardware,message middleware,rule engine server,data resource manager and task manager are added to build the system hardware architecture.Design the main CPU module,memory and CAN bus serial port operation access sequence of the system server.In terms of software,data warehouse is used to establish data integration model.Query multi⁃source monitoring alarm data through ant colony algorithm.Design multi⁃source monitoring alarm data processing steps to process multi⁃source monitoring alarm data.Calculate the data attributes,complete the data integration,and display the integrated multi⁃source monitoring alarm data in the user interface of the system.The experimental results show that the designed system integrates multi⁃source monitoring alarm data and multi concurrent task data,the resulting delay is less than the two groups of systems selected in this experiment,and has better real⁃time data integration.

关 键 词：数据仓库 多源监控 监控告警 数据集成 集成系统 时延 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]