CN-115858607-B - Counter flow statistical method, device, equipment and computer readable storage medium

CN115858607BCN 115858607 BCN115858607 BCN 115858607BCN-115858607-B

Abstract

The invention discloses a counter flow statistical method, a device, equipment and a computer readable storage medium, wherein the desensitization method comprises the steps of obtaining table information of a target table, and constructing a first basic data table of an indoor cell and a second basic data table of an outdoor cell according to the table information; determining an indoor backflow flow statistical table according to a preset field template and the first basic data table, determining an outdoor backflow flow statistical table according to the field template and the second basic data table, and summarizing the indoor backflow flow statistical table and the outdoor backflow flow statistical table to obtain a sector backflow summary table. The invention improves the intelligence of the data content and format required by acquiring the sector-level backflow statistical table.

Inventors

HUANG HAONAN
LI HAIZHENG
YU YIDONG

Assignees

中国移动通信集团浙江有限公司
中国移动通信集团有限公司

Dates

Publication Date: 20260505
Application Date: 20210926

Claims (8)

1. The backflow flow counting method is characterized by comprising the following steps of: Acquiring table information of a target table, and constructing a first basic data table of an indoor cell and a second basic data table of an outdoor cell according to the table information; Determining an indoor backflow flow statistical table according to a preset field template and the first basic data table, and determining an outdoor backflow flow statistical table according to the field template and the second basic data table; Summarizing the indoor backflow flow statistics table and the outdoor backflow flow statistics table to obtain a sector backflow summary table; the step of obtaining the table information of the target table and constructing a first basic data table of the indoor cell and a second basic data table of the outdoor cell according to the table information comprises the following steps: Determining a storage path of an input target table, and reading all table information of the target table based on the storage path, wherein the target table comprises a 4G cell-level flow backflow data table, a 4G engineering parameter data table and a 4G cell and sector number corresponding table, the fields of the 4G engineering parameter data table comprise [ 'LTE cell CGI', 'cell Chinese name', 'frequency band', 'indoor and outdoor', 'LTE cell CGI', 'flow summation', '4G cell-level flow backflow data table, the fields of the 4G cell-level flow backflow data table comprise [' LTE cell CGI ',' sector number ',' 4G cell total section flow in a certain time period, and the sector number field represents the number of the sector where the 4G cell is located; And integrating the table information into a basic data table, and constructing a first basic data table of an indoor cell and a second basic data table of an outdoor cell according to the basic data table, wherein the table information of the 4G cell-level flow backflow data table, the 4G working parameter data table and the table corresponding to the 4G cell and the sector number is integrated into the basic data table by taking CGI as a main key.
2. The reverse flow rate statistical method as claimed in claim 1, wherein the step of determining the indoor reverse flow rate statistical table according to the preset field template and the first basic data table comprises: determining sector numbers in the first basic data table, and determining matching frequency bands matched with the sector numbers in a preset frequency band list; And determining the target backflow flow of the sector number based on the matched frequency band, and constructing an indoor backflow flow statistical table according to the target backflow flow and a preset field template.
3. The reverse flow rate statistics method as described in claim 2, wherein said step of determining the target reverse flow rate of the sector number based on the matched frequency band comprises: determining all cell identification codes corresponding to the matched frequency bands, counting the reverse flow rate of the cells corresponding to the cell identification codes, calculating the sum of the reverse flow rates, and taking the sum as a target reverse flow rate.
4. The reverse flow rate statistics method as described in claim 2, wherein the step of constructing the indoor reverse flow rate statistics table according to the target reverse flow rate and a preset field template comprises: constructing a new table according to a preset field template, filling the coverage type in the new table into a room, and filling the target backflow flow into the new table; and taking the new table which is indoor in the coverage type and has the target backflow flow as an indoor backflow flow statistical table.
5. The reverse flow statistical method of claim 1, wherein the step of constructing a first basic data table of an indoor cell and a second basic data table of an outdoor cell according to the basic data table comprises: acquiring a preset indoor cell type and an outdoor cell type, determining indoor data information matched with the indoor cell type in the basic data table, and constructing a first basic data table of an indoor cell according to the indoor data information; And determining outdoor data information matched with the outdoor cell type in the basic data table, and constructing a second basic data table of the outdoor cell according to the outdoor data information.
6. A reverse flow rate statistical device, characterized in that the reverse flow rate statistical device comprises: The system comprises an acquisition module, a storage path determining module and a control module, wherein the acquisition module is used for acquiring table information of a target table and constructing a first basic data table of an indoor cell and a second basic data table of an outdoor cell according to the table information, the table information of the target table is acquired, the table information of the first basic data table of the indoor cell and the second basic data table of the outdoor cell are constructed according to the table information, the storage path determining module is used for determining a storage path of an input target table and reading all table information of the target table based on the storage path, the target table comprises a 4G cell-level flow backflow data table, a 4G working parameter data table and a 4G cell and sector number corresponding table, fields of the 4G working parameter data table comprise a [ (LTE cell CGI ', ' cell Chinese name ', ' indoor and outdoor ' ], the 4G cell-level flow backflow data table comprises an [ (LTE cell CGI ', ' sector number ' ], the 4G cell and sector number corresponding table comprises a sector number [ (LTE cell CGI ', ' sector number ' ], the flow backflow data table is integrated in the basic data table of the 4G cell and the sector number corresponding to the total number of the table, and the 4G working parameter data table is integrated in the basic data table of the 4G cell; the determining module is used for determining an indoor backflow flow statistical table according to a preset field template and the first basic data table, and determining an outdoor backflow flow statistical table according to the field template and the second basic data table; and the summarizing module is used for summarizing the indoor backflow flow statistics table and the outdoor backflow flow statistics table to obtain a sector backflow summary table.
7. A reverse flow rate statistics device comprising a memory, a processor, and a reverse flow rate statistics program stored on the memory and executable on the processor, the reverse flow rate statistics program when executed by the processor implementing the steps of the reverse flow rate statistics method of any one of claims 1 to 5.
8. A computer-readable storage medium, wherein a reverse flow rate statistics program is stored on the computer-readable storage medium, and wherein the reverse flow rate statistics program, when executed by a processor, implements the steps of the reverse flow rate statistics method according to any one of claims 1 to 5.

Description

Counter flow statistical method, device, equipment and computer readable storage medium Technical Field The present invention relates to the field of data processing technologies, and in particular, to a method, an apparatus, a device, and a computer readable storage medium for counting backflow flows. Background At present, if the data content and format required by the sector-level backflow statistical table need to be obtained, the corresponding backflow flow can only be manually matched on the EXCEL table based on the CGI (Cell Global Identifier, global cell identification code) by manpower, and the coverage type is covered. However, the whole process is time-consuming and labor-consuming due to the numerous fields involved, and the intelligent degree is low. Disclosure of Invention The invention mainly aims to provide a backflow flow counting method, a backflow flow counting device, backflow flow counting equipment and a computer readable storage medium, and aims to solve the technical problem of how to improve the intelligence of data content and format required by obtaining a sector-level backflow counting table. In order to achieve the above object, the present invention provides a method for counting backflow flow, comprising the steps of: Acquiring table information of a target table, and constructing a first basic data table of an indoor cell and a second basic data table of an outdoor cell according to the table information; Determining an indoor backflow flow statistical table according to a preset field template and the first basic data table, and determining an outdoor backflow flow statistical table according to the field template and the second basic data table; And summarizing the indoor backflow flow statistics table and the outdoor backflow flow statistics table to obtain a sector backflow summary table. Optionally, the step of determining the indoor backflow flow statistics table according to the preset field template and the first basic data table includes: determining sector numbers in the first basic data table, and determining matching frequency bands matched with the sector numbers in a preset frequency band list; And determining the target backflow flow of the sector number based on the matched frequency band, and constructing an indoor backflow flow statistical table according to the target backflow flow and a preset field template. Optionally, the step of determining the target backflow flow of the sector number based on the matched frequency band includes: determining all cell identification codes corresponding to the matched frequency bands, counting the reverse flow rate of the cells corresponding to the cell identification codes, calculating the sum of the reverse flow rates, and taking the sum as a target reverse flow rate. Optionally, the step of constructing an indoor backflow flow statistics table according to the target backflow flow and a preset field template includes: constructing a new table according to a preset field template, filling the coverage type in the new table into a room, and filling the target backflow flow into the new table; and taking the new table which is indoor in the coverage type and has the target backflow flow as an indoor backflow flow statistical table. Optionally, the step of obtaining table information of the target table, and constructing a first basic data table of the indoor cell and a second basic data table of the outdoor cell according to the table information includes: determining a storage path of an input target table, and reading all table information of the target table based on the storage path; and integrating the table information into a basic data table, and constructing a first basic data table of the indoor cell and a second basic data table of the outdoor cell according to the basic data table. Optionally, the step of constructing a first base data table of the indoor cell and a second base data table of the outdoor cell according to the base data table includes: acquiring a preset indoor cell type and an outdoor cell type, determining indoor data information matched with the indoor cell type in the basic data table, and constructing a first basic data table of an indoor cell according to the indoor data information; And determining outdoor data information matched with the outdoor cell type in the basic data table, and constructing a second basic data table of the outdoor cell according to the outdoor data information. Optionally, the target table includes a reference table, a reverse flow table, and a sector table. In addition, in order to achieve the above object, the present invention also provides a reverse flow rate statistical device, including: the acquisition module is used for acquiring the table information of the target table and constructing a first basic data table of the indoor cell and a second basic data table of the outdoor cell according to the table information; the determining module is used for deter