OLAP技术在电气设备在线监测数据处理中的应用

APPLICATION OF OLAP TO ON-LINE MONITORING DATA PROCESSING FOR MAINTENANCE OF POWER EQUIPMENT

指出了当前电气设备在线监测数据处理与分析存在的问题,提出应用联机分析处理(OLAP)技术实现在线监测数据的快速访问和分析。介绍了OLAP技术的相关内容,基于客户/服务器(C/S)结构,建立了一个具有星形和雪花形数据模型的在线监测OLAP系统,该系统已投入运行,可以对在线监测数据进行分析,为进一步实现在线监测数据规律性挖掘奠定了基础。

Current problems in the processing and analysis of on-line monitoring data for the maintenance of power equipment are pointed out. The idea of using on-line analytical processing (OLAP) to access and analyze on-line monitoring data is presented. The outline of OLAP is briefly introduced. Based on Client/Server (C/S) structure, an OLAP system with star and snowflake data patterns is developed to access on-line monitoring data. The system is already in operation and is capable of analyzing the on-line monitoring data, laying a foundation for mining the regularity of on-line monitoring data.