摘要
本文以某县电力局电力设备决策系统为研究背景,在对原有的数据源进行分析和重新组织的基础上,构建电力设备数据仓库,并建立多维星型模式的数据立方体。运用OLAP技术,从多角度、多层次快速地分析和查询数据仓库的数据,实现设备管理和预测的科学化,并说明OLAP数据仓库能够为电力系统管理人员提供有效的决策信息。
Based on the electric equipment in power system of a prefecture as the research background, on the basis of the original data analysis and reorganization, the paper builds electric equipment data warehouse and constructs multi -dimensional star pattern data cube. Using OLAP technology, from different angles, multilevel fast data analysis and query of the data warehouse, equipment management and scientific prediction and OLAP data warehouse to provide effective decision - making information for the power system management are achieved.
出处
《安徽电气工程职业技术学院学报》
2010年第1期118-121,共4页
Journal of Anhui Electrical Engineering Professional Technique College
基金
安徽省电力公司2008年度重点科技项目(项目编号:2008362)
关键词
数据仓库
OLAP
电力设备
data warehouse
online analytical processing
power equipment