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

Inverted index query technique of non-primary key for mass dispatch and monitoring information of distribution network

作　　者：屈志坚[1] 范明明 周锐霖 王汉林 朱丹 QU Zhijian;FAN Mingming;ZHOU Ruilin;WANG Hanlin;ZHU Dan(School of Electrical and Automation Engineering,East China Jiaotong University,Nanchang 330013,China)

机构地区：[1]华东交通大学电气工程学院,江西南昌330013

出　　处：《电力系统保护与控制》2018年第23期162-168,共7页Power System Protection and Control

基　　金：国家自然科学基金项目资助(51567008;51867009);江西省杰出青年人才计划项目资助(20162BCB23045);江西省自然科学基金项目资助(20171BAB206044);江西省科技厅应用培育计划项目资助(20181BBE58010)~~

摘　　要：为解决配电网调度监控系统数据体量不断增大导致数据检索速度越来越慢的问题,结合数据同步技术与倒排索引机制,提出了一种二级索引架构。使用数据库的同步组件与索引器生成非主行键索引,在搜索时先获得数据主行键,再根据主行键检索到需要的数据,完成非主行键检索,再利用倒排索引技术改变数据的信息结构,缩短检索时间。以某铁路局10 kV供电调度监控信息为算例,进行非主行键检索测试。结果表明:完成非主行键检索所用时间为161 ms,满足在配电网调度监控系统中对数据进行快速检索的工程应用需求。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.It 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.Inverted index technique is used to change the information structure of data and shorten the query time.The non-primary key query test is based on the 10 kV dispatch and monitoring information of a railway bureau.The results show that the time for the query of non-primary key is 161 ms,meeting the requirement of the engineering application for the fast query of data in the dispatch and monitoring system of the distribution network.

关 键 词：调度监控 快速查询 非主行键 二级索引 倒排索引 

分 类 号：TM73[电气工程—电力系统及自动化]