|本期目录/Table of Contents|

[1]荣莉莉,李群,于振.基于电网防台抗台系统的应急主题数据仓库分析与设计[J].中国安全生产科学技术,2018,14(9):18-23.[doi:10.11731/j.issn.1673-193x.2018.09.003]
　RONG Lili,LI Qun,YU Zhen.Analysis and design of emergency thematic data warehouse based on antityphoon system of power grid[J].JOURNAL OF SAFETY SCIENCE AND TECHNOLOGY,2018,14(9):18-23.[doi:10.11731/j.issn.1673-193x.2018.09.003]
点击复制

基于电网防台抗台系统的应急主题数据仓库分析与设计
分享到：

《中国安全生产科学技术》[ISSN:1673-193X/CN:11-5335/TB]

卷:
14
期数:
2018年9期
页码:
18-23
栏目:
学术论著
出版日期:
2018-09-30

文章信息/Info

Title:
Analysis and design of emergency thematic data warehouse based on antityphoon system of power grid
文章编号:
1673-193X(2018)-09-0018-06
作者:
荣莉莉1; 李群1; 于振2
（1.大连理工大学 系统工程研究所，辽宁 大连 116024；2.全球能源互联网研究院，北京 102209）
Author(s):
RONG Lili1;  LI Qun1;  YU Zhen2
(1. Institute of Systems Engineering, Dalian University of Technology, Dalian Liaoning 116024, China;2. Global Energy Interconnection Research Institute Co., Ltd., Beijing 102209, China)
关键词:
电网安全与应急; 台风; 数据仓库; 数据集成; 联机分析处理
Keywords:
power grid safety and emergency;  typhoon;  data warehouse;  data integration;  online analytical processing (OLAP)
分类号:
X913.4
DOI:
10.11731/j.issn.1673-193x.2018.09.003
文献标志码:
A
摘要:
为解决电网防台抗台过程中缺少应急辅助支持的问题，提出基于现有电网防台抗台系统中的业务数据，采用星型结构分析与设计“台风气象灾情”、“电网因灾（台风）损失”、“电网因灾（台风）应急资源投入”等应急主题数据仓库，充分利用、开发相关的数据探查与ETL工具实现相关的数据集成，构建相关应急主题下的多维数据模型，并开展联机分析处理（OLAP）研究工作，为相关企业和部门开展电网应急管理工作提供应急辅助支持。
Abstract:
To solve the problem of lacking the emergency ancillary support in the antityphoon process of power grid, it was proposed to analysis and design the emergency thematic data warehouse such as “typhoon meteorological disaster”, “disaster (typhoon) loss of power grid”, “ disaster (typhoon) emergency resource input of power grid” and others by using the star configuration based on the business data in the existing antityphoon system of power grid. The related data integration was realized by fully utilizing and developing the relevant data exploration and ETL tools, then the multidimensional data model under the related emergency themes was constructed, and the research on the online analytical processing (OLAP) was carried out. It can provide the emergency ancillary support for the relevant enterprises and departments to carry out the emergency management of power grid.

参考文献/References:

［1］崔明建, 孙元章, 杨军,等. 一种基于多层次灰色面积关联分析的电网安全综合评价模型［J］. 电网技术, 2013, 37(12):3453-3460. CUI Mingjian，SUN Yuanzhang，YANG Jun,et al.Power grid security comprehensive assessment based on multi-level grey area relational analysis［J］.Power System Technology,2013,37(12):3453-3460.
［2］徐鹏, 杨胜春, 李峰,等. 基于层次分析和变权重机制的电网安全指标计算及展示方法［J］. 电力系统自动化, 2015(8):133-140. XU Peng，YANG Shengchun，LI Feng，et al. Power grid security index calculation and display method based on AHP and variable weight mechanism［J］.Automation of Electric Power Systems, 2015(8):133-140.
［3］穆永铮, 鲁宗相, 乔颖,等. 基于多算子层次分析模糊评价的电网安全与效益综合评价指标体系［J］. 电网技术, 2015, 39(1):23-28. MU Yongzheng,LU Zongxiang,QIAO Ying,et al. A comprehensive evaluation index system of power grid security and benefit based on multi-operator fuzzy hierarchy evaluation method［J］.Power System Technology, 2015, 39(1):23-28.
［4］陈鹏云, 曹波, 罗弦,等. 中国电网主要自然灾害运行数据及特征分析［J］. 中国电力, 2014, 47(7):57-61. CHEN Pengyun,CAO Bo,LUO Xian,et al.Operation data and feature analysis of the main natural disasters of power network in China［J］.Electric Power,2014, 47(7):57-61.
［5］门永生, 朱朝阳, 于振,等. 电网重要基础设施自然灾害脆弱性评价研究［J］. 灾害学, 2014(4):16-19. MEN Yongsheng,ZHU Chaoyang,YU Zhen,et al. Natural disaster vulnerability assessment of important grid infrastructure［J］. Journal of Catastrophology, 2014(4):16-19.
［6］王兴发, 曹怀予, 肖军诗,等. 我国电网自然灾害预警系统研究［J］. 安全与环境工程, 2012, 19(6):38-44. WANG Xingfa,CAO Huaiyu,XIAO Junshi,et al.Research on the natural disaster early warning system of Chinese power grids［J］.Safety and Environmental Engineering, 2012, 19(6):38-44.
［7］刘玉红, 罗晓沛. 航空票务系统OLAP数据仓库设计与实现［J］. 计算机工程与设计, 2009, 30(2):345-347. LIU Yuhong,LUO Xiaopei. Design and realization of OLAP data warehouse in air ticket system［J］. Computer Engineering and Design,2009, 30(2):345-347.
［8］张耀丹. 仓储物流数据仓库的设计与实现［D］. 上海：东华大学, 2017.
［9］ 赵峰. 基于多维数据挖掘的电力营销决策支持系统研究［D］. 北京：华北电力大学(北京), 2006.
［10］黄天恩, 孙宏斌, 郭庆来,等. 基于电网运行仿真大数据的知识管理和超前安全预警［J］. 电网技术, 2015, 39(11):3080-3087. HUANG Tianen,SUN Hongbin,GUO Qinglai,et al. Knowledge management and security early warning based on big simulation data in power grid operation［J］. Power System Technology,2015, 39(11):3080-3087.
［11］科学百科.联机分析处理〔EB/OL〕.https://baike.baidu.com/item/%E8%81%94%E6%9C%BA%E5%88%86%E6%9E%90%E5%A4%84%E7%90%86/423874?fromtitle=OLAP&fromid=1049009&fr=aladdin.2018-06-05.

相似文献/References:

备注/Memo

备注/Memo:
收稿日期： 2018-05-18
基金项目： 国家电网公司总部科技项目（基于大数据的电力应急辅助决策关键技术研究）
作者简介： 荣莉莉，博士，教授，主要研究方向为系统工程、应急管理。
更新日期/Last Update: 2018-10-09