| 基于数据仓库和OLAP的电力决策支持系统的设计 |
| |
| 引用本文： | 李帅,祁利刚,李中,苑津莎.基于数据仓库和OLAP的电力决策支持系统的设计[J].电力系统通信,2007,28(7):58-61,72. |
| |
| 作者姓名： | 李帅 祁利刚 李中 苑津莎 |
| |
| 作者单位： | 1. 北京超高压公司,北京,100045
2. 华北电力大学电子与通信工程系,河北,保定,071003 |
| |
| 摘 要： | 数据仓库(Data Warehouse)和联机分析处理(OLAP,On-Line Analytical Processing)是构建决策支持系统(DSS,Decision and Support System)的关键技术。文章首先以电力系统为研究背景,分析了目前电力系统中企业信息化建设的不足,提出了构建DSS的解决方案;然后简要介绍了数据仓库和OLAP的基本概念、特点及其体系结构;最后针对电力系统中的电力变压器运行负载情况,设计出一种电力决策支持系统,具体实现了系统的体系结构、数据仓库以及OLAP设计,为电力系统的决策分析提供有效手段。
|
| 关 键 词： | 数据仓库 联机分析处理 星型结构 电力系统 决策支持系统 |
| 文章编号： | 1005-7641（2007）07-0058-04 |
| 修稿时间： | 2006-12-142007-01-12 |
Design of DSS in power system based on Data Warehouse and OLAP |
| |
| LI Shuai,QI Li-gang,LI Zhong,YUAN Jin-sha.Design of DSS in power system based on Data Warehouse and OLAP[J].Telecommunications for Electric Power System,2007,28(7):58-61,72. |
| |
| Authors: | LI Shuai QI Li-gang LI Zhong YUAN Jin-sha |
| |
| Affiliation: | 1. Beijing Extra High Voltage Transmission Company, Beijing 100045, China; 2. Dept. of Electronic and Communication Engineering, North china electric power university, Baoding 071003, China |
| |
| Abstract: | 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. |
| |
| Keywords: | Data Warehouse On-Line Analytical Processing (OLAP) star structure power system Decision and Support System (DSS) |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
