数据仓库技术在电力营销中的应用研究

The Application of Data Warehouse for Power Supplying Market Management

本文在对原有的数据源进行分析和重新组织的基础上,构建电力营销数据仓库,并建立多维星型模式的数据立方体。运用OLAP和数据挖掘技术,从多角度、多层次快速地分析和查询数据仓库的数据,实现营销管理和预测的科学化,并说明电力营销决策支持系统能够为电力系统管理人员提供有效的决策信息。

A real power system of Electricity Power Bureau is selected as the research background. Based on analysing and reorganising the originally existing data sources, the Power Supply Marketing data warehouse is formed and snowflake and star mode cubes for multi-dimension data are established. By using OLAP and data mining technology, forecasting load analysing and inquiring data warehouse are realized fi＇om different point view and multi-layers. It shows that Power Supply Marketing DSS is able to provide the valid decision-making information for the managers in power system.