海量配电网调度监测信息的非主行键倒排索引查询技术.PDFVIP

第 46 卷 第 23 期 电力系统保护与控制 Vol.46 No.23 2018 年 12 月 1 日 Power System Protection and Control Dec. 1, 20 18 DO : 10.7667/PSPC17 1742 海量配电网调度监测信息的非主行键倒排索引查询技术 屈志坚，范明明，周锐霖，王汉林，朱 丹 (华东交通大学电气工程学院，江西 南昌 001 ) 摘要：为解决配电网调度监控系统数据体量不断增大导致数据检索速度 来 慢的问题，结合数据同步技术与倒 排索引机制，提出了一种二级索引架构。使用数据库的同步组件与索引器生成非主行键索引，在搜索时先获得数 据主行键，再根据主行键检索到需要的数据，完成非主行键检索，再利用倒排索引技术改变数据的信息结构，缩 短检索时间。以某铁路局 10 kV 供电调度监控信息为算例，进行非主行键检索测试。结果表明：完成非主行键检 索所用时间为 161 ms，满足在配电网调度监控系统中对数据进行快速检索的工程应用需求。 关键词：调度监控；快速查询；非主行键；二级索引；倒排索引 Inverted index query technique of non-primary key for mass dispatch and monitoring information of distribution network QU Zhij ian, FAN Mingming, ZHOU Ruilin, WANG Hanlin, ZHU Dan (School of Electrical and Automation Engineering, East China Jiaotong University, Nanchang 330013, China) Abstract: Power distribution network data volume for the monitoring system is increasing, which results in the difficulty in fast retrieval of data. Therefore this paper proposes a secondary index structure by using the data replication technology and mechanism of inverted index structure. t generates the non-primary key index by using the replication component of the database and the indexer. The primary key of data is obtained first in the search. Then the data is retrieved according to the primary key to complete the non-primary key query. nverted index technique is used to change the information structure of data and shorten the query time. The non-primary