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

为解决配电网调度监控系统数据体量不断增大导致数据检索速度越来越慢的问题,结合数据同步技术与倒排索引机制,提出了一种二级索引架构。使用数据库的同步组件与索引器生成非主行键索引,在搜索时先获得数据主行键,再根据主行键检索到需要的数据,完成非主行键检索,再利用倒排索引技术改变数据的信息结构,缩短检索时间。以某铁路局10 kV供电调度监控信息为算例,进行非主行键检索测试。结果表明:完成非主行键检索所用时间为161 ms,满足在配电网调度监控系统中对数据进行快速检索的工程应用需求。

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

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. This work is supported by National Natural Science Foundation of China (No. 51567008 and No. 51867009), Foundation Plan for Distinguished Young Scholars in Jiangxi Province (No. 20162BCB23045), Natural Science Foundation of Jiangxi Province (No. 20171BAB206044), and Application and Cultivation Plan of Jiangxi Provincial Science Department (No. 20181BBE58010).