Latitude and longitude backfilling method and device for measurement report data, equipment and storage medium

Abstract

The invention provides a latitude and longitude backfilling method and device for measurement report data, equipment and a storage medium, and the method comprises the steps: obtaining the to-be-backfilled measurement report data, and determining the target cell data of the measurement report data; wherein the target cell data comprises a cell identifier and cell merging fingerprint data, and the cell merging fingerprint data comprises a plurality of pieces of cell raster data and adjacent cell data corresponding to each piece of cell raster data; determining target cell raster data of the measurement report data in the cell combined fingerprint data; and performing latitude and longitude backfilling on the measurement report data based on the raster data of the target cell. Through the target cell data with only two columns of data contents, the situation of data Cartesian product is avoided, data inclination is prevented, the CPU utilization rate is further improved, memory use is reduced, and the latitude and longitude backfilling efficiency is improved.

Description

Technical Field

[0001] The present invention relates to the field of communication technology, and in particular to a method, device, equipment and storage medium for backfilling longitude and latitude of measurement report data. Background Art

[0002] As operators' 4G and 5G networks mature, network coverage expands, and the number of users continues to grow, continuously optimizing the user experience and addressing frequently problematic areas are becoming increasingly important. Measurement Report Data (MR) reflects users' true network perception and truly reflects the depth of network coverage. This data can be used to accurately locate network issues such as coverage holes and areas of poor quality and interference. However, only a small number of users currently report their latitude and longitude in measurement reports. Most report empty latitude and longitude due to terminal power saving, protection restrictions, or GPS signal loss. Therefore, backfilling of empty latitude and longitude data is necessary.

[0003] The current mainstream backfilling method has a slow backfill efficiency for longitude and latitude data due to the large number of cell fingerprints and the large amount of sampling point data in the measurement report data. Generally, the hourly sampling point data is about 1 billion to 4 billion, and each cell corresponds to thousands of fingerprints. The calculation level is at the trillion level. Summary of the Invention

[0004] The present invention provides a method, device, equipment and storage medium for backfilling the latitude and longitude of measurement report data, which are used to solve the defects in the prior art.

[0005] The present invention provides a method for backfilling latitude and longitude of measurement report data, comprising: Obtaining measurement report data to be backfilled, and determining target cell data of the measurement report data; wherein the target cell data includes a cell identifier and cell merge fingerprint data, and the cell merge fingerprint data includes multiple cell grid data and adjacent cell data corresponding to each of the cell grid data; Determining target cell grid data of the measurement report data in the cell merged fingerprint data; The measurement report data is backfilled with longitude and latitude based on the target cell grid data.

[0006] According to a method for backfilling longitude and latitude of measurement report data provided by the present invention, before obtaining the measurement report data to be backfilled and determining target cell data of the measurement report data, the method further includes: Obtain at least one of original minimized drive test data and OTT service data; Determining original sampling points including longitude and latitude from the original minimization of drive test data and / or the OTT service data; Based on the latitude and longitude of the original sampling point, rasterizing the cell to obtain a plurality of cell grids, and determining a grid ID and cell grid data of each cell grid; Determining adjacent cells of each of the cell grids and obtaining adjacent cell data; Aggregating the grid ID and the cell grid data of the cell grids of the same cell, and the adjacent cell data of each cell grid; The data collected from each cell is processed, and the processed data is converted into a Json format to obtain a plurality of cell data.

[0007] According to a method for backfilling longitude and latitude of measurement report data provided by the present invention, determining target cell grid data of the measurement report data in the cell merged fingerprint data includes: The target cell grid data of the measurement report data is determined in the cell merged fingerprint data through a preset database; wherein the preset database supports vectorized engine accelerated calculation.

[0008] According to a method for backfilling longitude and latitude of measurement report data provided by the present invention, determining the target cell grid data of the measurement report data in the cell merged fingerprint data through a preset database includes: Calculating the similarity between the measurement report data and the grid data of each cell by using a custom function in the preset database; The target cell grid data of the measurement report data is determined according to the similarity.

[0009] According to a method for backfilling longitude and latitude of measurement report data provided by the present invention, the preset database includes a Starrocks database or a Doris database.

[0010] According to a method for backfilling longitude and latitude of measurement report data provided by the present invention, the method further includes: Based on the measurement report data with longitude and latitude, the network coverage of cells and cell grids is analyzed from multiple time granularities, and the analysis results are displayed on a geographic information system.

[0011] According to a method for backfilling longitude and latitude of measurement report data provided by the present invention, the method further includes: Based on the measurement report data with longitude and latitude and the cell data, the network coverage of different network operators is determined.

[0012] The present invention also provides a device for backfilling latitude and longitude of measurement report data, comprising: a first determination module configured to obtain measurement report data to be backfilled and determine target cell data of the measurement report data; wherein the target cell data includes a cell identifier and cell merge fingerprint data, and the cell merge fingerprint data includes multiple cell grid data and adjacent cell data corresponding to each of the cell grid data; A second determining module is configured to determine the target cell grid data of the measurement report data in the cell merged fingerprint data; The backfill module is configured to backfill the longitude and latitude of the measurement report data based on the target cell grid data.

[0013] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the method for backfilling the longitude and latitude of the measurement report data as described above is implemented.

[0014] The present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the method for backfilling the longitude and latitude of the measurement report data as described above is implemented.

[0015] The present invention also provides a computer program product, comprising a computer program, which, when executed by a processor, implements any of the above-mentioned methods for backfilling the longitude and latitude of measurement report data.

[0016] The method, apparatus, device, and storage medium for backfilling longitude and latitude of measurement report data provided by the present invention determine target cell data of the measurement report data, determine target cell raster data of the measurement report data in cell merged fingerprint data, and backfill the longitude and latitude of the measurement report data based on the target cell raster data. The cell merged fingerprint data in the target cell data of the present invention is obtained by merging fingerprint data of the same cell, so that the target cell data contains only two columns of data content, avoiding the Cartesian product of data and preventing data skew. At the same time, the avoidance of Cartesian product and data skew improves CPU utilization, reduces memory usage, and improves the efficiency of backfilling longitude and latitude. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the technical solutions in the present invention or the prior art, a brief introduction is given below to the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0018] Figure 1 It is a flow chart of the method for backfilling the latitude and longitude of measurement report data provided by the present invention.

[0019] Figure 2 It is a structural schematic diagram of the latitude and longitude backfilling device for measurement report data provided by the present invention.

[0020] Figure 3 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION

[0021] To make the objectives, technical solutions, and advantages of the present invention more clear, the technical solutions of the present invention will be clearly and completely described below in conjunction with the accompanying drawings. Obviously, the embodiments described are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts shall fall within the scope of protection of the present invention.

[0022] Existing technologies use latitude and longitude data from Minimization of Drive-Tests (MDT) data, or latitude and longitude data from signaling and OTT (Over the Top) services, to generate signature fingerprints. The Reference Signal Received Power (RSRP) of the serving cell in the original sampling point data from the Measurement Report Data (MR) is matched with the RSRP characteristics of neighboring cells, and the closest matching data is used to backfill the longitude and latitude of the sampling point. However, due to the large volume of cell fingerprint data and the large number of original MR sampling points, the matching calculation logic is complex and cannot be performed on a single server. Using Spark or Hive with a big data cluster results in slow backfilling, making it unsuitable for daily use.

[0023] The existing solution for fingerprint backfilling using big data clusters is to collect and parse the underlying Mobility Robustness Optimization (MRO) data into files, which are stored in a compressed format in HDFS. The fingerprint data is stored row by row using the cell unique identifier and grid ID as the key. The row content is the cell identifier, grid ID, main cell frequency band, main cell frequency point, main cell RSRP, and the frequency bands and frequencies of the eight neighboring cells, and RSRP, which takes up a lot of storage space. The number of grids corresponding to a cell varies depending on the grid size, ranging from hundreds to thousands. The backfill process uses spark or hivesql for calculation and backfilling. The two use different technologies, but the principles are basically the same and currently have the same problems and shortcomings. At the same time, the mode of storing data by row using the cell unique identifier and grid ID as the key will cause Cartesian products in associated queries, and is the main cause of data skew. In existing technology, the sampling point includes a cell ID, which is compared with the fingerprint cell ID. If the cell IDs match, data association calculation is performed. Matching calculations are performed based on the primary cell frequency and RSRP of the sampling point to be backfilled, as well as the neighboring cell frequency and RSRP. The backfill results are sorted in descending order of matching, and the top-ranked data is selected as the backfill result. Due to the large amount of sampling point data, typically between 1 billion and 4 billion hourly sampling point data, each cell corresponds to thousands of fingerprint data items, and the computational effort is at the mega-level.

[0024] Therefore, existing backfilling solutions have three shortcomings: 1. They involve large amounts of data, complex matching calculations, and high resource consumption in big data clusters. 2. They are time-consuming. Because matching calculations and the need to sort intermediate results are involved, backfilling one hour of data typically takes more than five hours, and backfilling one day of data takes a week, making them unsuitable for daily use. 3. Due to the uneven distribution of users in residential communities, with more users in urban areas and fewer in rural areas, data associations can skew during backfilling, leading to problems such as Hive reducer freezes, single executor execution failures when using Spark, and container OOM (Out of Memory) errors. Therefore, to address these shortcomings, the present invention provides a method, device, equipment, and storage medium for backfilling longitude and latitude data from measurement reports.

[0025] Figure 1 FIG. 1 is a flow chart showing a method for backfilling the latitude and longitude of measurement report data according to an exemplary embodiment. Figure 1 As shown, in an exemplary embodiment, the method for backfilling the latitude and longitude of measurement report data includes steps 110 to 130, which are described in detail as follows.

[0026] Step 110: Obtain measurement report data to be backfilled, and determine target cell data of the measurement report data; wherein the target cell data includes a cell identifier and cell merge fingerprint data, and the cell merge fingerprint data includes multiple cell grid data and adjacent cell data corresponding to each of the cell grid data.

[0027] In the embodiments of the present invention, measurement report data refers to wireless environment measurement data reported by terminal devices (such as mobile phones and IoT terminals) either proactively or upon request from a base station. This data reflects information such as the signal quality received at the terminal device's current location, the strength of neighboring cell signals, and network interference, and serves as a key basis for network optimization, coverage analysis, and fault location. However, since not all terminal devices have positioning enabled, a significant amount of measurement report data lacks location information, specifically longitude and latitude.

[0028] The present invention obtains measurement report data without longitude and latitude, and the measurement report data carries the service cell to which the terminal device is currently connected. The target cell data of the measurement report data is determined based on the service cell. The target cell data is pre-set data. On the basis of the original fingerprint data, the data is merged according to the cell identifier. The merged cell data is two columns, including the cell identifier and the cell merged fingerprint data. The cell merged fingerprint data includes multiple cell grid data and adjacent cell data corresponding to each cell grid data.

[0029] Step 120: Determine target cell grid data of the measurement report data in the cell combined fingerprint data.

[0030] In this embodiment of the present invention, the target cell grid data for the measurement report data is determined within the cell merged fingerprint data. Since the target cell data contains only two columns of data, the association is adjusted from the original sampling point × fingerprint Cartesian product to sampling point × corresponding cell merged fingerprint data, optimizing m × n to m × 1, thus avoiding the risk of data skew.

[0031] Step 130: Backfill the longitude and latitude of the measurement report data based on the target cell grid data.

[0032] In the embodiment of the present invention, the longitude and latitude of the measurement report data are backfilled based on the determined target cell grid data.

[0033] In an embodiment of the present invention, target cell data of the measurement report data is determined, target cell grid data of the measurement report data is determined in the cell merged fingerprint data, and latitude and longitude backfill is performed on the measurement report data based on the target cell grid data. The cell merged fingerprint data in the target cell data of the present invention is obtained by merging the fingerprint data of the same cell, so that there are only two columns of data content in the target cell data, avoiding the situation of Cartesian product of data and preventing data skew. At the same time, the avoidance of Cartesian product and data skew improves CPU utilization, reduces memory usage, and improves the efficiency of backfilling longitude and latitude.

[0034] In an exemplary embodiment of the present invention, before obtaining the measurement report data to be backfilled and determining the target cell data of the measurement report data, the method further includes: Obtain at least one of original minimized drive test data and OTT service data; Determining original sampling points including longitude and latitude from the original minimization of drive test data and / or the OTT service data; Based on the latitude and longitude of the original sampling point, rasterizing the cell to obtain a plurality of cell grids, and determining a grid ID and cell grid data of each cell grid; Determining adjacent cells of each of the cell grids and obtaining adjacent cell data; Aggregating the grid ID and the cell grid data of the cell grids of the same cell, and the adjacent cell data of each cell grid; The data collected from each cell is processed, and the processed data is converted into a Json format to obtain a plurality of cell data.

[0035] In an embodiment of the present invention, original sampling points containing longitude and latitude are screened out from the acquired original minimized drive test data and / or OTT service data, a grid size is predefined, and the cell is rasterized based on the longitude and latitude of the original sampling points to obtain a plurality of cell grids, and then the longitude and latitude of each cell grid can be determined, and a corresponding grid ID is determined for each cell grid. Since the network signal coverage ranges between geographically adjacent cells overlap, terminal devices located in the same cell grid may have different cells providing networks for them. Therefore, cells with other network signals covering the cell grid are regarded as adjacent cells of the cell grid, and adjacent cell data is obtained, including the frequency, frequency band, signal strength, etc. of the adjacent cells.

[0036] The grid ID and grid data of the cell grids in the same cell, as well as the adjacent cell data of each cell grid, are aggregated. The aggregated data is processed on a cell-by-cell basis to remove abnormal and duplicate data. The processed data is converted into JSON format to obtain multiple cell data and stored.

[0037] In an exemplary embodiment of the present invention, determining the target cell grid data of the measurement report data in the cell combined fingerprint data includes: The target cell grid data of the measurement report data is determined in the cell merged fingerprint data through a preset database; wherein the preset database supports vectorized engine accelerated calculation.

[0038] In the embodiment of the present invention, the target cell grid data of the measurement report data is determined in the cell merge fingerprint data by supporting the preset database of the vectorized engine accelerated calculation. The preset database supporting the vectorized engine accelerated calculation can process batch data at the same time, reduce the number of loop and function calls, and improve the CPU pipeline efficiency. In this embodiment of the present invention, a vectorized algorithm fully utilizes SIMD (Single Instruction Multiple Data) instructions and AVX2 within a pre-set database. SIMD instructions provided by the CPU can perform more data operations with fewer instructions. Verified by standard test suites, this engine can improve operator execution performance by 3-10 times. Furthermore, using the "Operation on Encoded Data" technology, operators can be executed directly based on encoded fields without decoding, enabling calculations of join operators, aggregation operators, and expression operators, reducing computational complexity. SIMD fully leverages server CPU performance to improve machine utilization.

[0039] AVX2 is an extension of the AVX instruction set, providing more advanced functions and performance improvements. AVX2 is mainly used to enhance the performance of the processor in handling floating-point and integer operations, especially when large amounts of data are involved. It is widely used in high-performance computing tasks, graphics processing, scientific computing, and machine learning. The existing backfill method is to perform associated calculations on a single row of data, and the calculation results of each processing sampling point are limited. The present invention uses the AVX2 instruction set to give full play to the performance of the X86 server and perform data calculations concurrently. The same time is 5-8 times the original processing speed, reducing time and giving full play to the CPU performance, solving the current architecture's high memory consumption and low CPU utilization.

[0040] In an exemplary embodiment of the present invention, determining the target cell grid data of the measurement report data in the cell merged fingerprint data through a preset database includes: Calculating the similarity between the measurement report data and the grid data of each cell by using a custom function in the preset database; The target cell grid data of the measurement report data is determined according to the similarity.

[0041] In an embodiment of the present invention, a custom function is registered in a database that supports vectorized engine accelerated calculations, and the measurement report data to be calculated and the cell merged fingerprint data in the target cell data are passed to the custom function. The similarity between the measurement report data and the grid data of each cell is calculated, the calculated similarities are arranged in descending order, and the grid ID corresponding to the maximum similarity is returned, and the longitude and latitude of the cell grid corresponding to the grid ID are used as the longitude and latitude of the measurement report data.

[0042] The prior art method for calculating similarity is to calculate by comparing cell sampling points with fingerprint data, return the similarity, and match the cell sampling points with the fingerprint data corresponding to all cells. After all similarity calculations are completed, they are sorted and the fingerprint with the highest similarity is taken to backfill the longitude and latitude. The present invention transforms the cell merged fingerprint data so that the original fingerprint data consists of more than 20 fields, but after optimization, it is reduced to only one complex JSON field. The Json field is split internally into multiple small fingerprint data in the preset database, and multiple threads perform calculations on the same sampling point data. The calculation results of the small fingerprint data are bubble sorted, and the longitude and latitude corresponding to the highest return value are returned. The technical solution provided by the present invention reduces the sorting steps and the storage of intermediate data to disk, thereby speeding up the calculation speed.

[0043] In an exemplary embodiment of the present invention, the preset database includes a Starrocks database or a Doris database.

[0044] In an embodiment of the present invention, StarRocks is an MPP (Massively Parallel Processing) large-scale parallel processing database that supports rapid analysis of massive data. It adopts a new generation of elastic MPP architecture and can efficiently support various data analysis scenarios such as multi-dimensional analysis, real-time analysis, and high-concurrency analysis of large data volumes.

[0045] Doris is a distributed online analytical processing (OLAP) database that features a column-based MPP architecture that supports fast interactive queries and highly concurrent random writes.

[0046] In another embodiment of the present invention, a custom function can be registered in both the Starrocks database and the Doris database. In this embodiment of the present invention, cross-validation can be performed using the two databases. For example, the measurement report data to be backfilled is used to determine the corresponding target cell grid data using the two databases. The two target cell grid data are then checked to see if they are identical. If they are not identical, the data is recorded and reported to the relevant operation and maintenance personnel.

[0047] In an exemplary embodiment of the present invention, the method for backfilling the latitude and longitude of measurement report data further includes: Based on the measurement report data with longitude and latitude, the network coverage of cells and cell grids is analyzed from multiple time granularities, and the analysis results are displayed on a geographic information system.

[0048] In this embodiment of the present invention, measurement report data is backfilled based on the latitude and longitude in the target cell grid data. Network coverage analysis is then performed based on the measurement report data with latitude and longitude at different time granularities, such as aggregation at 15-minute, hourly, and daily granularities. This completes the analysis of network coverage for cells and cell grids, and the analysis results are displayed on a Geographic Information System (GIS).

[0049] In an embodiment of the present invention, measurement report data with longitude and latitude are used to collect statistics on the distribution of serving cell reference signal received power or serving cell reference signal received quality (RSRQ) to identify weak coverage areas (weak coverage) and overcoverage (signal leakage) areas.

[0050] By analyzing the signal strength of neighboring cells through measurement report data with longitude and latitude, when it is detected that the reference signal receiving power of the neighboring cell of the terminal device is higher than that of the serving cell, but no handover is triggered, the handover parameters are optimized.

[0051] Interference can be located using measurement reports with longitude and latitude. For example, if a privately installed signal amplifier results in a high SINR (Signal to Interference plus Noise Ratio) but low throughput, the location of the interference can be determined based on the measurement report data with longitude and latitude, facilitating further investigation.

[0052] The measurement report data with longitude and latitude can be used to count the cell load and thus evaluate the cell's expansion needs.

[0053] Measurement report data with longitude and latitude can also be used to analyze user behavior, such as user density and movement trajectory, to optimize base station layout.

[0054] In an exemplary embodiment of the present invention, the method for backfilling the latitude and longitude of measurement report data further includes: Based on the measurement report data with longitude and latitude and the cell data, the network coverage of different network operators is determined.

[0055] In an embodiment of the present invention, the measurement report data includes the frequency points and frequency bands of adjacent cells, and the frequency points and frequency bands of different network operators are not exactly the same. Therefore, based on the measurement report data and cell data with longitude and latitude, the network coverage of different network operators can be determined, and the network coverage of the current network operator can be optimized.

[0056] The following describes the device for backfilling the longitude and latitude of measurement report data provided by the present invention. The device for backfilling the longitude and latitude of measurement report data described below can be referenced in correspondence with the method for backfilling the longitude and latitude of measurement report data described above. It should be noted that the device provided in the following embodiments and the method provided in the above embodiments are based on the same concept. The specific manner in which each module and unit performs operations has been described in detail in the method embodiments and will not be repeated here.

[0057] In an exemplary embodiment of the present invention, see Figure 2 , Figure 2 A device for backfilling longitude and latitude of measurement report data according to an exemplary embodiment includes the following modules.

[0058] A first determining module 210 is configured to obtain measurement report data to be backfilled and determine target cell data of the measurement report data; wherein the target cell data includes a cell identifier and cell merge fingerprint data, and the cell merge fingerprint data includes multiple cell grid data and adjacent cell data corresponding to each of the cell grid data; A second determining module 220 is configured to determine target cell grid data of the measurement report data in the cell merged fingerprint data; The backfill module 230 is configured to backfill the longitude and latitude of the measurement report data based on the target cell grid data.

[0059] In an exemplary embodiment of the present invention, the device for backfilling the latitude and longitude of the measurement report data further includes: an acquisition module configured to acquire at least one of original minimization of drive test data and OTT service data; A third determining module is configured to determine original sampling points containing longitude and latitude from the original minimization of drive test data and / or the OTT service data; A rasterization processing module is configured to perform rasterization processing on the cell based on the latitude and longitude of the original sampling point to obtain multiple cell grids, and determine the grid ID and cell grid data of each cell grid; a fourth determining module configured to determine adjacent cells of each of the cell grids and obtain adjacent cell data; a summarizing module configured to summarize the grid ID and the cell grid data of the cell grids of the same cell, and the adjacent cell data of each cell grid; The data processing module is configured to process the data aggregated from each cell and convert the processed data into a Json format to obtain the cell data.

[0060] In an exemplary embodiment of the present invention, the second determining module includes: The determination submodule is configured to determine the target cell grid data of the measurement report data in the cell merged fingerprint data through a preset database; wherein the preset database supports vectorized engine accelerated calculation.

[0061] In an exemplary embodiment of the present invention, determining a submodule includes: a calculation unit configured to calculate the similarity between the measurement report data and the grid data of each cell using a custom function in the preset database; A determining unit is configured to determine the target cell grid data of the measurement report data according to the similarity.

[0062] In an exemplary embodiment of the present invention, the preset database includes a Starrocks database or a Doris database.

[0063] In an exemplary embodiment of the present invention, the device for backfilling the latitude and longitude of the measurement report data further includes: The analysis module is configured to analyze the network coverage of cells and cell grids from multiple time granularities based on the measurement report data with longitude and latitude, and display the analysis results on a geographic information system.

[0064] In an exemplary embodiment of the present invention, the device for backfilling the latitude and longitude of the measurement report data further includes: The fifth determining module is configured to determine the network coverage of different network operators based on the measurement report data with longitude and latitude and the cell data.

[0065] Figure 3 An example of a physical structure diagram of an electronic device is shown below. Figure 3As shown, the electronic device may include: a processor 310, a communications interface 320, a memory 330, and a communication bus 340, wherein the processor 310, the communications interface 320, and the memory 330 communicate with each other via the communication bus 340. The processor 310 may call logic instructions in the memory 330 to execute a method for backfilling the longitude and latitude of measurement report data, the method comprising: obtaining measurement report data to be backfilled, and determining target cell data of the measurement report data; wherein the target cell data comprises a cell identifier and cell merge fingerprint data, and the cell merge fingerprint data comprises a plurality of cell grid data and adjacent cell data corresponding to each of the cell grid data; Determining target cell grid data of the measurement report data in the cell merged fingerprint data; The measurement report data is backfilled with longitude and latitude based on the target cell grid data.

[0066] Furthermore, the logic instructions in the aforementioned memory 330 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the portion that contributes to the prior art, or a portion of the technical solution, can be embodied in the form of a software product. This computer software product, stored in a storage medium, includes several instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention. The aforementioned storage medium includes various media capable of storing program code, such as a USB flash drive, a mobile hard drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

[0067] On the other hand, the present invention also provides a computer program product, which includes a computer program. The computer program can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can execute the latitude and longitude backfill method of the measurement report data provided by the above methods, the method comprising: obtaining the measurement report data to be backfilled, and determining the target cell data of the measurement report data; wherein the target cell data includes a cell identifier and cell merge fingerprint data, and the cell merge fingerprint data includes multiple cell grid data and adjacent cell data corresponding to each of the cell grid data; Determining target cell grid data of the measurement report data in the cell merged fingerprint data; The measurement report data is backfilled with longitude and latitude based on the target cell grid data.

[0068] In another aspect, the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the latitude and longitude backfilling method for the measurement report data provided by the above methods, the method comprising: obtaining the measurement report data to be backfilled, and determining target cell data of the measurement report data; wherein the target cell data includes a cell identifier and cell merged fingerprint data, and the cell merged fingerprint data includes multiple cell grid data and adjacent cell data corresponding to each of the cell grid data; Determining target cell grid data of the measurement report data in the cell merged fingerprint data; The measurement report data is backfilled with longitude and latitude based on the target cell grid data.

[0069] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, i.e., they may be located in one location or distributed across multiple network units. Some or all of the modules may be selected based on actual needs to achieve the objectives of the present embodiment. Persons of ordinary skill in the art will be able to understand and implement the present invention without inventive effort.

[0070] Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented using software plus a necessary general-purpose hardware platform, or of course, hardware. Based on this understanding, the essence of the above technical solution, or the portion that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a magnetic disk, or an optical disk, and includes a number of instructions for causing a computer device (such as a personal computer, server, or network device) to execute the methods described in each embodiment or certain portions of the embodiments.

[0071] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the various embodiments of the present invention.

Claims

1. A method for backfilling latitude and longitude of measurement report data, characterized in that: include: Obtaining measurement report data to be backfilled, and determining target cell data of the measurement report data; wherein the target cell data includes a cell identifier and cell merge fingerprint data, and the cell merge fingerprint data includes multiple cell grid data and adjacent cell data corresponding to each of the cell grid data; Determining target cell grid data of the measurement report data in the cell merged fingerprint data; The measurement report data is backfilled with longitude and latitude based on the target cell grid data.

2. The method for backfilling the latitude and longitude of measurement report data according to claim 1, characterized in that: Before obtaining the measurement report data to be backfilled and determining the target cell data of the measurement report data, the method further includes: Obtain at least one of original minimized drive test data and OTT service data; Determining original sampling points including longitude and latitude from the original minimization of drive test data and / or the OTT service data; Based on the latitude and longitude of the original sampling point, rasterizing the cell to obtain a plurality of cell grids, and determining a grid ID and cell grid data of each cell grid; Determining adjacent cells of each of the cell grids and obtaining adjacent cell data; Aggregating the grid ID and the cell grid data of the cell grids of the same cell, and the adjacent cell data of each cell grid; The data collected from each cell is processed, and the processed data is converted into a Json format to obtain a plurality of cell data.

3. The method for backfilling the latitude and longitude of measurement report data according to claim 1, characterized in that: The determining the target cell grid data of the measurement report data in the cell combined fingerprint data includes: The target cell grid data of the measurement report data is determined in the cell merged fingerprint data through a preset database; wherein the preset database supports vectorized engine accelerated calculation.

4. The method for backfilling the latitude and longitude of measurement report data according to claim 3, characterized in that: The determining, by a preset database, the target cell grid data of the measurement report data in the cell merged fingerprint data includes: Calculating the similarity between the measurement report data and the grid data of each cell by using a custom function in the preset database; The target cell grid data of the measurement report data is determined according to the similarity.

5. The method for backfilling the latitude and longitude of measurement report data according to claim 3, characterized in that: The preset database includes the Starrocks database or the Doris database.

6. The method for backfilling the latitude and longitude of the measurement report data according to any one of claims 1 to 5, characterized in that: The method further comprises: Based on the measurement report data with longitude and latitude, the network coverage of cells and cell grids is analyzed from multiple time granularities, and the analysis results are displayed on a geographic information system.

7. The method for backfilling the latitude and longitude of the measurement report data according to any one of claims 1 to 5, characterized in that: The method further comprises: Based on the measurement report data with longitude and latitude and the cell data, the network coverage of different network operators is determined.

8. A device for backfilling longitude and latitude of measurement report data, characterized in that: include: a first determination module configured to obtain measurement report data to be backfilled and determine target cell data of the measurement report data; wherein the target cell data includes a cell identifier and cell merge fingerprint data, and the cell merge fingerprint data includes multiple cell grid data and adjacent cell data corresponding to each of the cell grid data; A second determining module is configured to determine the target cell grid data of the measurement report data in the cell merged fingerprint data; The backfill module is configured to backfill the longitude and latitude of the measurement report data based on the target cell grid data.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and running on the processor, characterized in that: When the processor executes the computer program, the method for backfilling the latitude and longitude of the measurement report data according to any one of claims 1 to 7 is implemented.

10. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method for backfilling the latitude and longitude of the measurement report data according to any one of claims 1 to 7 is implemented.

Images