Method for rapidly improving MR neighbor cell backfilling efficiency based on SQLite database

Abstract

The invention provides a method for rapidly improving MR neighbor cell backfilling efficiency based on an SQLite database, and the method comprises the steps: obtaining original MR data uploaded by a terminal from a base station, and carrying out the analysis of the MR data; according to the work parameter file, the distances between all adjacent cells and the main service cell are calculated through longitude and latitude, the cell closest to the main service cell under the same frequency point and PCI is found, and a nearest neighbor cell table is constructed; and reading the ID of the main service cell and the PCI and the frequency point of the neighbor cell to be backfilled from the analyzed MR data, and directly searching the ID of the neighbor cell to be backfilled from the nearest neighbor cell table. According to the method, the SQLite database is adopted, and the SQLite has the characteristics of no need of installation, file-based, no network communication overhead and high query efficiency and performance of a system, so that the time complexity of searching the target neighbor cell can be reduced, the steps of repeatedly calculating the distance and sequencing are reduced, and the MR neighbor cell backfilling efficiency is quickly improved.

Description

Technical field [0001] The present invention relates to the field of communication testing technology, in particular to a method based on a SQLite database to quickly improve the efficiency of MR neighborhood backfill. Background [0002] The common method of backfilling the existing MR neighborhood is to load the parsed MR data file and the parameter file into memory in the program, traverse each line of MR record, find all the cells in the same PCI and frequency point through the PCI (cell physical identification code) and frequency point of the neighbor area, calculate the distance between these cells and the main service cell and sort, and the smallest cell is the neighborhood that needs to be backfilled. When the MR data volume is relatively large and there are more cells in the working parameters, the efficiency of backfilling neighboring areas is relatively low. [0003] Therefore, it is urgent to find a way to improve the efficiency of MR neighborhood backfill. Contents...

AI Technical Summary

Problems solved by technology

[0004] The object of the present invention is to provide a kind of method based on SQLite database to improve the backfill efficiency of MR neighbor area rapidly, thus solve the foregoing problems existing in the prior art

Images