数据仓库技术在昆明电网电量分析中的应用  

APPLICATION OF DATA WAREHOUSE TECHNOLOGY IN POWER CONSUMPTION ANALYSIS OF KUNMING POWER NETWORK

作　　者：张文英[1] 束洪春[1] 张叶[2] 

机构地区：[1]昆明理工大学电力工程学院,云南省昆明市650093 [2]昆明供电局,云南省昆明市650011

出　　处：《电网技术》2005年第14期40-44,共5页Power System Technology

基　　金：国家自然科学基金资助项目(50347026;50467002);云南省科技攻关项目(2003GG10);云南省应用基础研究项目(2002E0025M;2004E0020M)~~

摘　　要：数据仓库技术对操作型数据转化成全面、集成的信息,以及对海量数据的查询和统计提供了有效的途径。文章在介绍数据仓库、联机分析处理概念和技术的基础上,分析了面向主题的多维数据库的建立和多维视图的展现等技术,针对昆明电网负荷管理系统,基于微软的SQLServer2000和SQLAnalysisServices2000构建了面向电量主题的数据仓库,在数据可视化方面弥补了AnalysisServices2000的不足。同时讨论了数据仓库技术在完成电量数据的查询、统计、分析、生成各种统计报表方面的具体应用。Data warehouse technology offers effective solutions to transforming operating type of data into comprehensive and integrated information and to the query and statistics of mass data. On the basis of introducing the concepts and technique of data warehouse and online analysis the technologies of building up subject oriented multi-dimension database and revealing multi-dimensional views are analyzed. For Kunming load management system a power consumption subject oriented data warehouse is established based on Microsoft SQL Server 2000 and SQL Analysis Services 2000, and the insufficiency of Analysis Services 2000 in data visualization is remedied. In addition, the concrete application of data warehouse technology in the query, statistics and analysis of power consumption data and that in the generation of various statistical forms are discussed.

关 键 词：数据仓库 电量管理 联机分析 多维视图 数据挖掘 电力系统 

分 类 号：TM734[电气工程—电力系统及自动化]