摘要
数据仓库技术对操作型数据转化成全面、集成的信息,以及对海量数据的查询和统计提供了有效的途径。文章在介绍数据仓库、联机分析处理概念和技术的基础上,分析了面向主题的多维数据库的建立和多维视图的展现等技术,针对昆明电网负荷管理系统,基于微软的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.
出处
《电网技术》
EI
CSCD
北大核心
2005年第14期40-44,共5页
Power System Technology
基金
国家自然科学基金资助项目(50347026
50467002)
云南省科技攻关项目(2003GG10)
云南省应用基础研究项目(2002E0025M
2004E0020M)~~
关键词
数据仓库
电量管理
联机分析
多维视图
数据挖掘
电力系统
Circuit theory
Data mining
Electric power systems
Energy utilization
Online systems
Query languages
Servers
Statistical methods