OLAP在电站生产过程数据分析中的应用研究  

Application Research of OLAP for Data Analysis in Power Plant Production Process

作　　者：田志强[1] 黄孝彬[2] 田苗[1] 李娜[1] 隋丽颖[1] 

机构地区：[1]华北电力大学,北京102206 [2]北京华电天仁电力控制技术有限公司,北京100085

出　　处：《自动化技术与应用》2010年第3期25-27,共3页Techniques of Automation and Applications

摘　　要：随着实时/历史数据库在电厂中的广泛应用,海量的生产数据得到长期地在线保存,如何分析这些数据所蕴含生产过程的运行规律,对于提高生产管理及决策水平具有重要意义。本文首先给出了电站机组联机分析处理(On-Line Analysis Processing,简称OLAP)系统结构,然后对电站运行机组的经济性、安全性、环保性主题进行设计;以经济性分析为例,给出了经济性工况分析主题数据仓库的建立、利用OLAP技术进行多维分析的实例。实例表明,利用OLAP技术能有效地展示数据间的关系,反映过程的运行状况及运行规律。With the wide use of the real/historical-time database in power plant,mass production process data is preserved online in a long time.How to analyze the running law of the process inherented in these data is of great significance for improving the running management and decision-making level of power units.This paper introduces the Business Intelligence OLAP technology into production/historical analysis.First of all,OLAP system structure of power plant units is given.Then the theme of economics,security,environmental protection are designed and an economic analysis example is made.At last,the examples of establishment of thematic data warehouse based on economic conditions analysis are given and OLAP technology to analyze multi-dimensional is used.Examples show that the usage of OLAP technology in power plant to the production process historical data analysis not only can demonstrate the relationship between the data effectively but also reflect the operation status and running law of the process.

关 键 词：OLAP 决策支持 数据仓库 电站机组 

分 类 号：TP319[自动化与计算机技术—计算机软件与理论]