容错存储的电力系统监测数据查询优化技术-电网技术.pdfVIP

39 卷 11 期 电 网 技 术 Vol. 39 No. 11 20 15 年11 月 Power System Technology Nov. 2015 文章编号：1000-3673 （20 15）11-322 1-07 中图分类号：TM 73 文献标志码：A 学科代码：470 40 容错存储的电力系统监测数据查询优化技术 屈志坚，陈阁 （华东交通大学 电气工程学院，江西省 南昌市 330013 ） Query Optimization for Power System Monitoring Data With Fault-Tolerant Storage QU Zhijian, CHEN Ge (School of Electrical Engineering, East China Jiaotong University, Nanchang 330013, Jiangxi Province, China) ABSTRACT: In order to solve massive time series data DOI 10.13335/j.1000-3673.pst.2015.11.031 storage and query problem in power system monitoring, a new 0 引言 classified partition query optimization method of fault tolerant storage is proposed using cloud computing framework and 目前的电力自动化监控系统多采用关系库支 HQL query engine. Fault tolerant storage model of power [1-2] 撑数据平台 ，但越来越多的数据传感设备、移动 system monitoring data is designed through redundancy 物联设备、新能源与电动储能设备等的联网接入， replication mechanism, and loading test and query optimization [3-6] 使现代电网运行和监测的数据量呈指数倍增 。关 test of monitoring data are carried out by coordinating HQL query plan generation, conversion from HQL to Map/Reduce 系数据库主要依赖更快速、更昂贵的大型服务器向 and partition pruning process. Results show that HQL 上纵向扩展，由于数据增长速度远大于关系存储能 performance is better than SQL when amounts of loading data 力的增长，终将使监测系统面临扩展上限。如美国 exceed two millions or amounts of query data exceed three 田纳西河流域管理局(Tennessee Valley Authority， hundred and eighty thousand, and the bigger the data volume is, TVA)在智能电网项目中安装相量测量单元(phasor the more obvious the performance advanta