Inverted index query technique of non-primary key for mass dispatch and monitoring information of distribution network
DOI：10.7667/PSPC171742
Key Words:dispatch and monitoring  fast query  non-primary key  secondary index  inverted index
Author NameAffiliationE-mail
QU Zhijian School of Electrical and Automation Engineering, East China Jiaotong University, Nanchang 330013, China  
FAN Mingming School of Electrical and Automation Engineering, East China Jiaotong University, Nanchang 330013, China  
ZHOU Ruilin School of Electrical and Automation Engineering, East China Jiaotong University, Nanchang 330013, China 1628939785@qq.com 
WANG Hanlin School of Electrical and Automation Engineering, East China Jiaotong University, Nanchang 330013, China  
ZHU Dan School of Electrical and Automation Engineering, East China Jiaotong University, Nanchang 330013, China  
Hits: 3113
Download times: 1267
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. 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).
View Full Text  View/Add Comment  Download reader