摘要
数据仓库(Data Warehouse)和联机分析处理(OLAP,On-Line Analytical Processing)是构建决策支持系统(DSS,Decision and Support System)的关键技术。文章首先以电力系统为研究背景,分析了目前电力系统中企业信息化建设的不足,提出了构建DSS的解决方案;然后简要介绍了数据仓库和OLAP的基本概念、特点及其体系结构;最后针对电力系统中的电力变压器运行负载情况,设计出一种电力决策支持系统,具体实现了系统的体系结构、数据仓库以及OLAP设计,为电力系统的决策分析提供有效手段。
Data Warehouse and On-Line Analytical Processing （OLAP） are the key technologies in building Decision and Support System （DSS）. Taking power system as a research background, this paper firstly analyses the deficiency of enterprise informatization, proposes the solutions for building DSS. Then briefly introduces basic concept, characteristics and architecture of Data Warehouse and OLAP. Finally, based on the loads of transformer in power system, the paper designs a DSS which can realize the designs of system architecture, Data Warehouse and OLAP. The DSS provides useful means for decision making in power system.
出处
《电力系统通信》
2007年第7期58-61,72,共5页
Telecommunications for Electric Power System
关键词
数据仓库
联机分析处理
星型结构
电力系统
决策支持系统
Data Warehouse
On-Line Analytical Processing （OLAP）
star structure
power system
Decision and Support System（DSS）
