Cell optical splitter port number evaluation method, device and equipment

Abstract

The application provides a cell splitter port quantity evaluation method, device and equipment, the method comprises the following steps: obtaining user information of at least one to-be-planned cell; in the case that the to-be-planned cell is a cell covered by a splitter port, determining the expansion quantity of the splitter port of the to-be-planned cell according to the user quantity, income, current port quantity and current port occupancy rate of the to-be-planned cell; in the case that the to-be-planned cell is a cell not covered by a splitter port, evaluating the value of each to-be-planned cell according to the user characteristics of the to-be-planned cell to obtain an evaluation value of each to-be-planned cell; and determining the planning quantity of the splitter port of the to-be-planned cell according to the evaluation value and port conversion characteristics. Thus, the accuracy of the planning quantity of the splitter port is improved, and accurate and efficient resource allocation is achieved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of Internet, and particularly relates to a cell optical splitter port quantity evaluation method, device and equipment. BACKGROUND

[0002] In the telecommunication industry, the optical fiber access technology realizes data transmission by installing an optical splitter in a splitter box and leading optical fibers from the ports of the optical splitter to directly access optical modems in user homes. The optical splitter, as an important node in the tree structure of the optical fiber network, distributes the backbone optical fiber signal to multiple user ends, and its ports are the starting point of the last mile connecting the backbone network and user homes. Without the optical splitter ports, the optical signal cannot be distributed from the backbone network to specific user homes, and the user's optical modem cannot be connected to the network. Therefore, the coverage of the optical splitter ports not only reflects the construction of the network infrastructure, but also directly determines the capacity and coverage range of the network, and is a necessary condition for providing fiber-to-the-home broadband services.

[0003] However, in the traditional broadband network construction planning, the construction site is selected and the number of optical splitter ports is determined depending on manual experience, and there are problems of inaccuracy. SUMMARY

[0004] The present application aims to solve the above problems in the prior art, and provides a cell optical splitter port quantity evaluation method, device and equipment to improve the accuracy of the construction quantity of the optical splitter ports.

[0005] In a first aspect, the present application provides a cell optical splitter port quantity evaluation method, which comprises:

[0006] obtaining user information of at least one to-be-planned cell;

[0007] In the case that the to-be-planned cell is an optical splitter port covered cell, determining the expansion quantity of the optical splitter port of the to-be-planned cell according to the user quantity, the income of the account, the current port quantity and the current port occupancy rate of the to-be-planned cell;

[0008] In the case that the to-be-planned cell is an optical splitter port uncovered cell, performing value evaluation on each to-be-planned cell according to user features of the to-be-planned cell to obtain an evaluation value of each to-be-planned cell, wherein the user features include multi-dimensional attributes such as user behavior in mobile network services, consumption habits and contract relationships;

[0009] determining the planning quantity of the optical splitter port of the to-be-planned cell according to the evaluation value and port conversion features, wherein the port conversion features are used to represent the efficiency and value realization degree in the process from planning to use of the optical splitter port in the cell.

[0010] In a second aspect, the present application provides a splitter port quantity evaluation device, comprising:

[0011] An acquisition module is configured to acquire user information of at least one to-be-planned cell;

[0012] A first determination module is configured to, in a case where the to-be-planned cell is a splitter port covered cell, determine an expansion quantity of a splitter port of the to-be-planned cell according to a user quantity, an accounting income, a current port quantity and a current port occupancy rate of the to-be-planned cell.

[0013] An evaluation module is configured to, in a case where the to-be-planned cell is a splitter port uncovered cell, perform value evaluation on each to-be-planned cell according to user features of the to-be-planned cell, to obtain an evaluation value of each to-be-planned cell, wherein the user features include multi-dimensional attributes such as a use behavior, a consumption habit and a contract relationship of the user in a mobile network service.

[0014] A second determination module is configured to determine a planning quantity of a splitter port of the to-be-planned cell according to the evaluation value and a port conversion feature, wherein the port conversion feature is used to represent an efficiency and a value realization degree in a process from planning to use of the splitter port in the cell.

[0015] In a third aspect, the present application provides a computer readable storage medium, wherein the computer readable storage medium stores a computer program, and the computer program is executed by a processor to implement the splitter port quantity evaluation method of the first aspect.

[0016] In a fourth aspect, the present application provides a storage device, comprising a processor, the splitter port quantity evaluation device of the second aspect and a program or instruction stored on the storage and executable on the processor, wherein the program or instruction is executed by the processor to implement the splitter port quantity evaluation method of the first aspect.

[0017] The splitter port quantity evaluation method, device and storage device provided by the present application can comprehensively analyze user quantity, accounting income, current port quantity and occupancy rate and other key indicators to determine a reasonable expansion port quantity and ensure maximum resource utilization efficiency for a cell covered by an existing splitter port. For a cell not yet covered, multi-dimensional features of users, including a mobile network service use behavior, a consumption habit and a contract relationship, are analyzed in depth to perform detailed value evaluation, so as to assign a quantitative evaluation value to each to-be-planned cell. The evaluation value and a port conversion feature are combined to more accurately predict and plan a quantity of splitter ports. Therefore, the accuracy of a planning quantity of a splitter port is improved, and accurate and efficient resource allocation is realized. BRIEF DESCRIPTION OF DRAWINGS

[0018] Figure 1 A flow chart of a cell optical splitter port number evaluation method provided for an embodiment of the present application is shown in FIG. 1.

[0019] Figure 2 A flow chart of another cell optical splitter port number evaluation method provided for an embodiment of the present application is shown in FIG. 2.

[0020] Figure 3 A geographical range limiting map provided for an embodiment of the present application is shown in FIG. 3.

[0021] Figure 4 A structural schematic diagram of a cell optical splitter port number evaluation device provided for an embodiment of the present application is shown in FIG. 4.

[0022] Figure 5 A structural schematic diagram of an optical splitter port number evaluation device provided for an embodiment of the present application is shown in FIG. 5. DETAILED DESCRIPTION

[0023] In order to make the skilled in the art better understand the technical solutions of the present application, the embodiments of the present application will be further described in detail below with reference to the accompanying drawings.

[0024] It can be understood that the specific embodiments and the accompanying drawings described herein are only used to explain the present application, but not to limit the present application.

[0025] It can be understood that the embodiments in the present application and the features in the embodiments can be combined with each other without conflict.

[0026] It can be understood that, for the convenience of description, only the parts related to the present application are shown in the drawings of the present application, and the parts unrelated to the present application are not shown in the drawings.

[0027] It can be understood that each unit and module involved in the embodiments of the present application can only correspond to one entity structure, or can be composed of multiple entity structures, or multiple units and modules can be integrated into one entity structure.

[0028] It can be understood that the terms "first", "second" and the like in the embodiments of the present application are used to distinguish different objects, or to distinguish different treatments of the same object, but not to describe a specific order of the objects.

[0029] It can be understood that the functions and steps marked in the flow charts and block diagrams of the present application can occur in an order different from that marked in the drawings without conflict.

[0030] It can be understood that the flowcharts and block diagrams of the present application show the possible implementation architecture, function and operation of the system, device, equipment and method according to the embodiments of the present application. Each block in the flowchart or block diagram can represent a unit, module, program segment, code, which contains executable instructions for implementing the specified function. Moreover, each block or combination of blocks in the block diagram and flowchart can be implemented by a hardware-based system for implementing the specified function, or by a combination of hardware and computer instructions.

[0031] It can be understood that the units and modules involved in the embodiments of the present application can be implemented by software or hardware, for example, the units and modules can be located in a processor.

[0032] It should be noted that the scene diagrams described in the embodiments of the present application are used to more clearly illustrate the technical solutions of the embodiments of the present application, and do not constitute a limitation on the technical solutions provided by the embodiments of the present application. Those skilled in the art can know that, with the evolution of network architecture and the appearance of new business scenarios, the technical solutions provided by the embodiments of the present application are also applicable to similar technical problems.

[0033] In the telecommunications industry, fiber to the home (a fiber is drawn from the splitter port in the splitter box and connected to the optical modem in the user's home) is the mainstream broadband access method, so whether the splitter port covers the residential area, village is the prerequisite for broadband installation. The infrastructure cost of the splitter port is high, and the average price in the city is about 230 yuan per port; in rural areas, due to the reason of pole road construction, the average price is higher, about 260 yuan per port. In a batch of construction investment in the telecommunications industry, the number of ports involved is usually about 500,000, and the total investment is about 100 million yuan according to the average price of the port, so the accurate construction of the splitter port (selecting high-value residential areas for construction) is very important, which can effectively save construction costs and promote market development.

[0034] In the existing practice method, the planning of the splitter port construction is made by experience, that is, the number of to-be-built cells and to-be-built ports is manually reported by local staff, and lacks the guidance of big data analysis.

[0035] Based on the problems existing in the prior art, the present application provides a cell splitter port quantity evaluation method to improve the accuracy of the splitter port planning quantity.

[0036] Embodiment 1:

[0037] The embodiment provides a cell splitter port quantity evaluation method, as shown in Figure 1 The method comprises the following steps S101-S104:

[0038] S101: Obtain user information of at least one to-be-planned cell.

[0039] Among them, the to-be-planned cell can be a cell covered by the optical splitter port but needing capacity expansion, a newly-built or reconstructed cell not yet covered by the optical splitter port, a densely-populated high-demand residential area, a commercial prosperous office area, an educational or industrial park with special network demand, and different types of cells located in the city center, suburbs or remote areas. These cells can be in different development stages, have different user groups and network use characteristics, and thus need to be individually evaluated and planned in terms of the number of optical splitter ports according to their specific conditions.

[0040] The user information can include basic demographic characteristics (such as age, occupation, income level, etc.), network use behavior (including broadband usage, traffic pattern, main service type accessed, etc.), consumption habits (such as ARPU value, package selection, payment ability, etc.), contract relationship (contract type, term, history of renewal, etc.), customer satisfaction and complaint record, and potential demand and value-added service preference of the user, etc. The collection of specific information can be selected according to actual conditions. These multi-dimensional user information can comprehensively reflect the characteristics and needs of the user, and provide key basis for accurately evaluating the number of optical splitter ports in the cell.

[0041] S102: In the case that the to-be-planned cell is an optical splitter port covered cell, the number of optical splitter port expansion of the to-be-planned cell is determined according to the number of users, the revenue, the current number of ports and the current port occupancy rate of the to-be-planned cell.

[0042] Specifically, according to the number of users, economic benefits (revenue), existing infrastructure (current number of ports) and usage (port occupancy rate) of the optical splitter port covered cell, a reasonable number of optical splitter port expansion is determined. The network capacity demand and economic benefits can be balanced to ensure that the expansion decision can meet the growth of user demand and also realize efficient use of resources.

[0043] S103: In the case that the to-be-planned cell is an optical splitter port uncovered cell, the value of each to-be-planned cell is obtained by performing value evaluation on each to-be-planned cell according to the user characteristics of the to-be-planned cell.

[0044] Among them, the user characteristics include multi-dimensional attributes such as the user's use behavior, consumption habits and contract relationship in the mobile network service. For example: the user's network use behavior (such as monthly traffic, main use period, commonly used application type, etc.), consumption habits (such as monthly consumption amount, package selection, value-added service subscription situation, etc.), and contract relationship with the operator (such as online time, contract type, renewal history, etc.).

[0045] Specifically, based on the multi-dimensional attribute data of users, including mobile network usage behavior, consumption habits, and contract relationships, etc., a comprehensive value assessment of the uncovered cell is conducted. By analyzing these user characteristics, the potential value and network demand of the cell can be predicted. The final assessment value reflects the overall value of the cell. The value assessment method based on user characteristics can help operators more accurately identify high-value cells, optimize resource allocation, and maximize investment returns.

[0046] S104: Determine the planning number of optical splitter ports for the to-be-planned cell based on the assessment value and port conversion characteristics.

[0047] The port conversion characteristics are used to represent the efficiency and value realization degree of the optical splitter ports in the cell from planning to use. The port conversion characteristics are a comprehensive index for measuring the efficiency and value realization degree of the optical splitter ports from planning to actual use. It covers efficiency dimensions (such as port activation rate and usage saturation), value realization dimensions (such as income conversion rate and user satisfaction), prediction factors (such as historical conversion patterns and market demand prediction), and operational efficiency (such as maintenance cost and upgrade flexibility), etc. By analyzing these characteristics, operators can more accurately assess the actual value and usage efficiency of planned ports, optimize resource allocation and investment decisions.

[0048] Specifically, the value assessment results of the cell and the port conversion characteristics are combined to determine the optimal number of optical splitter ports. The assessment value reflects the overall value and potential of the cell, while the port conversion characteristics provide a prediction of the actual usage efficiency of the planned ports. By analyzing these two key factors, operators can find a balance between meeting expected demand and avoiding resource waste. This method not only considers the current value of the cell, but also incorporates the prediction of future development potential and actual usage efficiency, thus achieving more accurate and cost-effective network planning, optimizing resource allocation and improving investment returns.

[0049] In one example, the port conversion characteristics can include the following parameters: Assuming that a cell plans to plan 100 optical splitter ports, after 6 months, the following data is obtained: 80 ports are activated and used (port activation rate 80%); the average activation time is 2 months (activation speed); the average bandwidth usage rate of activated ports is 70% (usage saturation); the monthly income per activated port is 100 yuan (income conversion rate); the user satisfaction survey score is 4.2 / 5 (user satisfaction); 90% of users still use the service after one year (long-term retention rate); the annual maintenance cost per port is 50 yuan (maintenance cost); the failure rate is 5% per year (failure rate); 60% of target customers in marketing activities successfully converted into actual users (marketing success rate 60%); 85% of newly built ports are occupied within 3 months (newly built port occupancy rate 85%).

[0050] In the embodiment of the present application, for the cells covered by the existing optical splitter ports, the method comprehensively analyzes the key indicators such as the number of users, the accounting income, the current port number and the occupancy rate, to determine the reasonable expansion port number, and to ensure the maximum resource utilization efficiency. For the cells not yet covered, through in-depth analysis of the multi-dimensional characteristics of users, including mobile network service usage behavior, consumption habits and contract relationship, etc., detailed value evaluation is carried out, so as to give each to-be-planned cell a quantitative evaluation value. By combining the evaluation value with the port conversion characteristics, the number of optical splitter ports can be more accurately predicted and planned. Thus, the accuracy of the number of optical splitter ports planned is improved, and accurate and efficient resource allocation is realized.

[0051] By comprehensively analyzing the cell user information, network usage and economic benefits, and adopting differentiated strategies for the covered and uncovered cells, accurate evaluation of the number of optical splitter ports is realized.

[0052] Optionally, the above S102 can include the following steps:

[0053] In the case where the to-be-planned cell meets the first preset condition, it is determined to expand the optical splitter ports for the to-be-planned cell;

[0054] According to the number of cell users, the preset port utilization rate and the current port number of the to-be-planned cell, the expansion number of optical splitter ports of the to-be-planned cell is determined,

[0055] The first preset condition includes: the current port occupancy rate is higher than the first preset threshold, the to-be-planned cell has not been expanded with optical splitter ports in the preset time, the number of users of the to-be-planned cell has continuously increased in the preset time, and the accounting income of the to-be-planned cell has continuously increased in the preset time.

[0056] Specifically, first, it is confirmed whether the to-be-planned cell is a cell covered by the existing optical splitter ports; for the cell covered by the existing optical splitter ports, the number of users, the accounting income, the current port number and the current port occupancy rate of the cell are obtained; the expansion conditions are evaluated: a) whether the current port occupancy rate is higher than the first preset threshold, b) whether the optical splitter port expansion has not been performed in the preset time, c) whether the number of users has continuously increased in the preset time, and d) whether the accounting income has continuously increased in the preset time; if all the conditions of the cell are met, the expansion decision is made; finally, the expansion number is calculated according to the number of cell users, the preset port utilization rate and the current port number of the to-be-planned cell.

[0057] In the embodiment, by comprehensively considering multiple factors (such as port occupancy rate, expansion history, user growth and income growth, etc.) of the cell covered by the existing optical splitter ports, accurate expansion demand evaluation and number calculation are realized.

[0058] Optionally, the expansion quantity of the optical splitter port of the to-be-planned cell is determined according to the quantity of cell users, the preset port utilization rate and the current port quantity of the to-be-planned cell, and includes:

[0059] The expansion quantity of the optical splitter port of the to-be-planned cell is calculated by formula (1):

[0060]

[0061] Wherein, N is the expansion quantity of the optical splitter port of the to-be-planned cell, u is the quantity of cell users, η is the preset port utilization rate, and p is the current port quantity of the to-be-planned cell.

[0062] Specifically, the theoretical port quantity required to meet the demand of all users of the cell can be obtained by dividing the quantity of users by the preset port utilization rate; and the port quantity to be expanded is obtained by subtracting the current port quantity (p) from the ideal port quantity.

[0063] In the embodiment, scientific and efficient expansion planning of the optical splitter port is realized through accurate mathematical calculation. The operator can realize optimal configuration of resources while guaranteeing network quality, improve the return on investment, and reserve appropriate space for future business growth.

[0064] Optionally, the user features include: total number of users, average consumption amount, average excess traffic fee, number of 5G users, average call duration, average downlink traffic, number of mobile mobile fusion, number of contract users, and average number of months in network.

[0065] Specifically, 8 key features of each mobile network user can be extracted from the business system of the operator, including consumption amount, traffic usage, call duration, contract status, etc., covering multiple dimensions such as user consumption ability, usage behavior and loyalty. Then, the individual user data is summarized to the cell level to generate the above-mentioned 9 representative feature indicators for each cell, including the total number of users and the average value or total amount of each feature.

[0066] In one example, the user features of the cell are analyzed by using big data. Based on the business system data, 8 features of each mobile network user are matched, including consumption amount, excess traffic fee, whether 5G, call duration, downlink traffic, whether mobile mobile fusion, whether contract, and number of months in network. Then, the cells to which the users belong are summarized, and the following 9 features of mobile network users are obtained for each cell: total number of users, average consumption amount, average excess traffic fee, number of 5G users, average call duration, average downlink traffic, number of mobile mobile fusion, number of contract users, and average number of months in network. Each feature takes the median of the cell.

[0067] In this embodiment, user characteristics cover multiple key dimensions such as user scale, consumption behavior, service usage, and loyalty, providing operators with a comprehensive user portrait. By analyzing these data, operators can gain a deep understanding of user needs and optimize network planning.

[0068] Optionally, the above S103 can specifically include the following steps:

[0069] The evaluation value of the to-be-planned cell is calculated by formula (2):

[0070]

[0071] wherein S j is the evaluation value, is an activation function, is a user characteristic parameter value, k is a user characteristic number, j is a cell number, and D is the number of cells.

[0072] Specifically, the above formula (2) calculates the standardized score by comparing the differences of the 9 key characteristics of each cell with the overall median; an activation function is used to handle nonlinear relationships, and a relative evaluation method is used to obtain a final score of 0-100. It can consider multiple user characteristics, not only the performance of a single cell, but also evaluate based on the overall network environment, accurately identify high-value cells, optimize resource allocation, and provide data support for network planning and upgrade decisions, ultimately improving network efficiency.

[0073] Optionally, the port conversion feature includes marketing success rate and new port occupancy rate,

[0074] The above S104 can include:

[0075] In the case where the evaluation value of the to-be-planned cell meets the second preset condition, the number of planned splitters ports of the to-be-planned cell is calculated by formula (3):

[0076]

[0077] wherein N j is the number of planned splitters ports, is the total number of cell users, P is the marketing success rate, and Q is the new port occupancy rate. The second preset condition is that the ranking of the evaluation value is the top preset percentage of the evaluation value of the at least one to-be-planned cell.

[0078] Marketing success rate (P): reflects the ratio of successfully converting potential users into actual users. The higher it is, the better the marketing effect is, and more ports need to be planned. New port occupancy rate (Q): indicates that the higher the proportion of newly built ports actually used, the higher the port utilization efficiency, and the fewer redundant ports can be reduced.

[0079] In this embodiment, formula (3) takes into account the marketing success rate (P), the new port occupancy rate (Q), and the total number of users in the cell. It can dynamically balance user demand and resource utilization, and predict the actual number of ports required by adjusting the factor (P / Q). Not only does it consider the current user base, but also incorporates market performance and resource utilization efficiency, thus achieving precise planning and risk management. This data-driven approach provides operators with a tool that is flexible in adapting to market changes, optimizes resource allocation, improves investment efficiency, and also reserves reasonable space for future network expansion. By regularly updating parameters and potential improvements (such as considering time factors and user segmentation), its accuracy and applicability can be continuously improved, becoming a powerful support for telecommunications network planning.

[0080] Optionally, S101 can include:

[0081] Obtain the latitude and longitude information of each cell to be planned;

[0082] Obtain user coordinate information within the range of each cell to be planned through resident base station positioning and MR positioning;

[0083] Locate users to the nearest cell according to user coordinate information to determine users of each cell to be planned.

[0084] Specifically, first, obtain the accurate latitude and longitude information of the cell as a geographic reference point, then combine resident base station positioning and MR positioning technology to obtain the accurate coordinates of users, and finally match users to the corresponding cell based on the "nearest principle". It has high accuracy and data-driven nature, not only can dynamically reflect the changes of user distribution, but also provides detailed and reliable data basis for network planning and optimization. Through the user information acquisition process, operators can more accurately determine the number of users in each cell, thereby optimizing resource allocation.

[0085] Optionally, locating users to the nearest cell according to user coordinate information to determine users of each cell to be planned includes:

[0086] The coordinates of the cell to be planned and the coordinates of the users within the cell belong to the same administrative division;

[0087] The difference between the coordinates of the cell to be planned and the coordinates of the users within the cell is less than a second preset threshold.

[0088] Specifically, first, complete cell set information is acquired (such as which cells need to be planned, and the latitude and longitude information of the cells is acquired), and coordinate system conversion (S210) can also be performed, the publicly acquired Baidu coordinate system (BD09) data is uniformly converted into the globally common WGS84 coordinate system, to ensure the consistency and comparability of the data; then, the accurate coordinates of the user are acquired through the resident base station positioning and MR positioning technology; the users within the range of all cells to be planned are divided, and the users are allocated to the closest cell on the geographical location. Two key strategies are adopted to optimize the calculation efficiency: (1) limiting the calculation range to the same administrative division to avoid unnecessary cross-zone calculation; (2) setting a second preset threshold (0.1°, about 7 kilometers) of the latitude and longitude difference threshold, and screening out the user-cell pairing.

[0089] In the embodiment, accurate user positioning and cell matching are realized, so that the user information of each cell can be accurately acquired.

[0090] In one specific embodiment, as shown in Figure 2 The splitter port number evaluation method can include the following steps:

[0091] S21, selecting a to-be-built cell (i.e., a cell to be planned).

[0092] S22, determining whether the to-be-built cell is a splitter-uncovered cell.

[0093] The determination is made as to whether the to-be-built cell is a splitter port-uncovered cell. If not (already covered), steps S23 to S28 are performed, and if yes (not covered), steps S29 to S14 are performed.

[0094] S23, acquiring a cell-port-user table.

[0095] A cell-splitter port-user correspondence table T is acquired from the number resource system: T (t1, t2, t3, t4, t5), wherein t1 represents the cell code, t2 represents the last-stage splitter device code, t3 represents the last-stage splitter port code, t4 represents the user broadband number, and t5 represents the data account period (in the year-month format, for example, 202309). The structure of table T is shown in Table 1.

[0096]

[0097] Table 1

[0098] S24, acquiring a user apportioned account income table S.

[0099] Get the user's share of the post-billing income information table S: S (s1, s2, s3) from the data platform, where s1 represents the user's broadband number, s2 represents the user's post-billing income (in yuan), and s3 represents the data billing period (in the format of year and month, such as 202309). The structure of table S is shown in Table 2 below.

[0100]

[0101] Table 2

[0102] S25, associate table S, T to get tables R1, R2 and R3.

[0103] Associate table T and S by broadband number and data billing period, with the foreign key T.t4 = S.s1 and T.t5 = S.s3, to get the result table R: R (t1, t2, t3, t5, s2). The meanings of the symbols in parentheses are the same as defined above. In this method, the user and post-billing income of the last three consecutive months are considered, and each month corresponds to a table R, which is denoted as R1, R2 and R3 respectively. Among them, R3 is the most recent data billing period, and R1 is the most distant data billing period (for example, if the billing period of R3 is 202309, the billing period of R2 is 202308, and the billing period of R1 is 202307). The structure of table R is shown in Table 3 below.

[0104]

[0105] Table 3

[0106] S26, aggregate R1, R2, R3 to get U1, U2, U3.

[0107] Aggregate R1, R2, R3 according to cell code t1 to get result tables U1: U1 (t1, u1, p1, q1), U2 and U3 (the table structure of U2 and U3 is the same as U1, only the subscript values are different), where t1 is the cell code, u1 = ∑R1 (t4) represents the total number of users in each cell, p1 = |∪R1 (t3)| represents the number of end-stage optical splitters in each cell, and q1 = ∑R1 (s3) represents the sum of post-billing income of all broadband users in each cell. The calculation of each column of U2 and U3 is the same as that of U1. The structure of table U is shown in Table 4 below.

[0108]

[0109] Table 4

[0110] Associate U1, U2, U3 to get the final result data table V.

[0111] According to the cell code, U1, U2 and U3 are associated, and the associated foreign key is U1.t1=U2.t1, U2.t1=U3.t1, and the final result data table is obtained,

[0112] V(t, u1, p1, q1, u2, p2, q2, u3, p3, q3), wherein is a set of cell codes, u i ,p i ,s i are respectively from U i ,i∈{1,2,3}. The structure of table V is shown in table 4.

[0113]

[0114] Table 5

[0115] Through the above S22 value S27, the number of users of the cell to be planned, the income of the account, the current number of ports and the current port occupancy rate can be obtained.

[0116] S28, calculate the number of ports N that each cell should expand

[0117] Calculate the number of ports N that each cell should expand:

[0118]

[0119] wherein, is an indicator function, η is the port utilization rate after expansion, and the commonly used value range is η≥0.4. Among them, the meaning of p1=p2=p3 is that the current cell has not been expanded in the past three months (equivalent to the preset time in the above); the meaning of u1<u2<u3 is that the number of users of the current cell has increased continuously for three months; the meaning of q1<q2<q3 is that the income of the current cell has increased continuously for three months, represents the number of ports that need to be expanded under the condition of meeting the above four conditions.

[0120] S29, obtain a set of uncovered cells D.

[0121] Acquiring the latitude and longitude information of the cell which needs to be built broadband splitter port: there are two ways to acquire the cell information, (i) acquiring the cell layer electronic fence table in the number line system, the key fields are: city, cell name and cell center point latitude and longitude, this cell set is recorded as A; (ii) writing a Python program (mainly using urllib library) to acquire the public cell information on the Internet, the key contents are: city, cell name and cell center point latitude and longitude, this cell set is recorded as B; (iii) combining the cells acquired in the above steps, excluding the cell set C which already exists in the number line system broadband resource, acquiring the cell set D = (A∪B)\C which is not covered by broadband resources, and the total number of cells not covered by broadband resources is recorded as |D|.

[0122] S210, latitude and longitude coordinate system conversion.

[0123] The latitude and longitude of the public cell acquired on the Internet is in the Baidu coordinate system (BD09), in order to unify all latitude and longitude data to the WGS84 (World Geodetic System 1984) coordinate system, the BD09 coordinate needs to be converted. Let x be the longitude in the BD09 coordinate system and y be the latitude in the BD09 coordinate system, then the WGS84 coordinates s and t (s is the WGS84 longitude and t is the WGS84 dimension) are obtained according to the following approximate formulas (5) to (13):

[0124] α=x-0.0065,β=y-0.006 (5)

[0125]

[0126] u=zcosθ,v=zsinθ (8)

[0127] p=u-105,q=v-35 (9)

[0128]

[0129]

[0130] Where the constant F = 0.00669342, R = 6378245 is the radius of the earth (meters).

[0131] S211, acquiring the cell which the mobile network user resides in.

[0132] Acquiring the latitude and longitude of the mobile network user in the WGS84 coordinate system through the resident base station positioning and MR positioning (both are commonly used methods, which will not be repeated here), and using the following formula to locate the user i to the nearest cell j * :

[0133]

[0134] Wherein, the user set is denoted as K is the total number of users, a i b is the longitude of user i. i Let be the dimension of user i; let be the set of cells. M is the total number of cells, c j Let d be the longitude of cell j. j Let be the dimension of cell j, and argmin{f(X)} represent the element in set X whose function value is the smallest under the mapping of a single real-valued function f. Without measures to reduce computational complexity, equation (14) will be calculated KM times, resulting in high complexity. The following measures can be used to reduce computational complexity.

[0135] (i) If the user and the community belong to the same administrative division (such as a prefecture-level city), cross-administrative division calculations will not be performed.

[0136] (ii) Only users and cells with an absolute difference in latitude and longitude less than 0.1° are counted; combinations where the distance between users and cells is more than 7 kilometers are discarded. For example... Figure 3 As shown, assuming A is a user, cells outside the bounding box can be ignored, and the user will not fall into the cell represented by point B, thus reducing computational complexity.

[0137] Using the above two measures, equation (15) can be expressed as:

[0138]

[0139] Measure (i) can reduce the complexity to ε = ∑ p e p f p , where e p f is the proportion of users in the p-th administrative region out of the total number of users. p This represents the proportion of neighborhoods in the p-th administrative division out of the total number of neighborhoods. In practice, ε ≈ 12%.

[0140] Measure (ii) can reduce the complexity to:

[0141]

[0142] In this context, we assume the user's longitude is a random variable X1, the user's latitude is a random variable X2, the cell's longitude is a random variable X3, and the cell's latitude is a random variable X4. i ,1≤i≤4 follow mutually independent normal distributions, X i The mean and variance of 1≤i≤4 are u. i and In practice, α≈2×10 -4 .

[0143] S212, Big Data Analysis of Community Characteristics.

[0144] Utilizing big data analytics to analyze cell characteristics. Based on business system data, each mobile network user is matched with eight characteristics: consumption amount, excessive data charges, 5G usage, call duration, downlink data usage, mobile-to-mobile convergence, contract status, and number of months on the network. Then, the characteristics of each user's cell are aggregated, and for each cell, the following nine characteristics of mobile network users are obtained: number of users. Average spending Average cost of exceeding data usage limits 5G user numbers Average call duration Average Downlink Flow Number of Shift-to-Fuse Number of contract users and average number of months online For each feature, the median of the paired cells is taken, corresponding to M respectively. k ,1≤k≤9.

[0145] S213, Obtain the expanded community.

[0146] Obtain the set of expanded communities. Based on the above 9 characteristics, use the following formula to perform a value normalization score for the j-th community (score between 0 and 100).

[0147]

[0148] in, It is the activation function, and the denominator serves as a normalization function. S j The higher the score, the higher the value of the community. In this plan, S is taken. j The top 10% of residential communities will be expanded, and the set of expanded communities will be denoted as Ω. The community value score calculation table shown in Table 6 below is obtained.

[0149]

[0150]

[0151] S214. Calculate the number of ports that should be added to the expanded community.

[0152] Calculate the number of broadband ports that should be built in each cell of the expanded community Ω. Where P represents the marketing success rate, with an empirical value of 2%, and Q represents the new port occupancy rate, with an empirical value of 15%.

[0153] In this embodiment:

[0154] (1) In the quantitative calculation method for the number of ports to be expanded in the cell already covered by the splitter port, the process of obtaining the cell-splitter port-user correspondence table T, billing revenue information table S, table R1, R2, R3, table U1, U2, U3 and table V based on the monthly time series analysis of the number of users, business revenue, number of ports and port occupancy rate.

[0155] (2) In the quantitative calculation method for the number of ports to be expanded in the cell already covered by the splitter port, after obtaining Table V, the number of ports to be expanded is calculated by judging factors such as whether the current port occupancy rate exceeds 50%, whether the number of users has increased in the past three months, whether the business revenue has increased in the past three months, and whether the ports have not been expanded in the past three months.

[0156] (3) In the quantitative calculation method for the number of newly built ports in cells not covered by the splitter port, the user is located in the cell with low complexity by using the method of the same prefecture-level city and the difference between the user's latitude and longitude and the cell center's latitude and longitude is less than 0.1°.

[0157] (4) In the quantitative calculation method for the number of newly built ports in cells not covered by the splitter port, the cell value score calculation table is obtained by calculating the total number of users, total revenue, total service usage (call duration, traffic, etc.), and service type (contract, mobile network convergence) of mobile network users in the cell, based on the total number of users, total revenue, total service usage, and total service type count of the cell-level summary, and using the activation function E.

[0158] (5) In the quantitative calculation method for the number of new ports in cells not covered by the splitter port, after obtaining the cell value score calculation table, the number of new ports to be built is calculated by combining the marketing success rate and the actual occupancy rate of the new splitter port.

[0159] Example 3:

[0160] like Figure 4 As shown, this embodiment provides a device 400 for evaluating the number of ports of a small-scale optical transceiver, used to perform the above-described method for evaluating the number of ports of a small-scale optical transceiver, including:

[0161] Module 401 is used to acquire user information for at least one community to be planned;

[0162] The first determining module 402 is used to determine the number of optical splitter ports to be expanded in the planned cell when the cell to be planned is a cell already covered by the optical splitter port, based on the number of users, billing revenue, current number of ports and current port occupancy rate of the planned cell.

[0163] The evaluation module 403 is configured to perform value evaluation on each of the to-be-planned cells according to user features of the to-be-planned cells, to obtain an evaluation value of each of the to-be-planned cells, when the to-be-planned cells are splitter port non-coverage cells, wherein the user features include multi-dimensional attributes such as user behaviors in mobile network services, consumption habits, and contract relationships.

[0164] The second determination module 404 is configured to determine a planning quantity of a splitter port of the to-be-planned cell according to the evaluation value and a port conversion feature, wherein the port conversion feature is used to represent an efficiency and a value realization degree in a process from planning to use of the splitter port in the cell.

[0165] Optionally, the first determination module 402 is configured to:

[0166] determine to perform splitter port expansion on the to-be-planned cell when the to-be-planned cell meets a preset condition.

[0167] determine the expansion quantity of the splitter port of the to-be-planned cell according to a cell user quantity, a preset port utilization rate, and a current port quantity of the to-be-planned cell,

[0168] wherein the preset condition includes that the current port occupancy rate is higher than a first preset threshold, the to-be-planned cell has not performed splitter port expansion within a preset time, the user quantity of the to-be-planned cell has continuously increased within the preset time, and the account income of the to-be-planned cell has continuously increased within the preset time.

[0169] Optionally, the determination of the expansion quantity of the splitter port of the to-be-planned cell according to the cell user quantity, the preset port utilization rate, and the current port quantity of the to-be-planned cell includes:

[0170] the expansion quantity of the splitter port of the to-be-planned cell is calculated by formula (1):

[0171] wherein N is the expansion quantity of the splitter port of the to-be-planned cell, u is the cell user quantity, η is the preset port utilization rate, and p is the current port quantity of the to-be-planned cell.

[0172] Optionally, the evaluation module 403 is configured to calculate the evaluation value of the to-be-planned cell by formula (2).

[0173] Optionally, the port conversion feature includes a marketing success rate and a newly-built port occupancy rate, and the second determination module 404 is configured to calculate the planning quantity of the splitter port of the to-be-planned cell by formula (3) when the evaluation value of the to-be-planned cell meets a second preset condition.

[0174] wherein N j is the planning quantity of the splitter port, P is the marketing success rate, Q is the new port occupancy rate,

[0175] The second preset condition is that the ranking of the evaluation value is in the front preset percentage of the evaluation value of the at least one to-be-planned cell.

[0176] Optionally, the acquisition module 401 is configured to acquire the longitude and latitude information of each to-be-planned cell.

[0177] The user coordinate information in the range of each to-be-planned cell is acquired through the resident base station positioning and the MR positioning.

[0178] The users of each to-be-planned cell are determined by locating the users to the nearest cell according to the user coordinate information.

[0179] Optionally, the method for locating the users to the nearest cell according to the user coordinate information and determining the users of each to-be-planned cell comprises:

[0180] The to-be-planned cell coordinate and the user coordinate in the cell belong to the same administrative division.

[0181] The difference between the to-be-planned cell coordinate and the user coordinate in the cell is less than a second preset threshold.

[0182] In the embodiments of the present application, for the cells covered by the existing optical splitter ports, the method comprehensively analyzes the key indicators such as the number of users, the income of the account, the number of current ports and the occupancy rate, to determine the reasonable number of expanded ports, and to ensure the maximum utilization efficiency of resources. For the cells that have not been covered, the method analyzes the multi-dimensional characteristics of the users in depth, including the mobile network service usage behavior, the consumption habit and the contract relationship, etc., to make a detailed value evaluation, so as to give each to-be-planned cell a quantitative evaluation value. By combining the evaluation value with the port conversion characteristics, the number of optical splitter ports can be more accurately predicted and planned. Therefore, the accuracy of the number of optical splitter ports planned is improved, and accurate and efficient resource allocation is realized.

[0183] Embodiment 4

[0184] Figure 5 A hardware structure schematic diagram of an electronic device provided by an embodiment of the present application is shown.

[0185] The electronic device can include a processor 501 and a memory 502 having computer program instructions stored therein.

[0186] Specifically, the processor 501 can include a central processing unit (CPU), or a specific integrated circuit (Application Specific Integrated Circuit, ASIC), or can be configured as one or more integrated circuits that implement one or more embodiments of the present application.

[0187] The memory 502 can include mass storage for data or instructions. As an example and not by way of limitation, the memory 502 can include a hard disk drive (HDD), a floppy disk drive, flash memory, an optical disc (e.g., a compact disc (CD) or a digital versatile disc (DVD)), a solid-state drive (SSD), a USB drive, or a combination of two or more of these. Where appropriate, the memory 502 can include removable or non-removable (or fixed) media, where appropriate. The memory 502 can be internal or external to the integrated gateway disaster recovery device. In particular embodiments, the memory 502 is non-volatile, solid-state memory.

[0188] The memory can include read-only memory (ROM), random-access memory (RAM), magnetic disk storage mediums, optical storage mediums, flash memory devices, electrical, optical, or other physical / tangible memory storage devices. Thus, in general, the memory includes one or more tangible (non-transitory) computer-readable storage media (e.g., a memory device) encoded with software that, when executed (by one or more processors), is operable to

[0189] The processor 501 implements any one of the above-mentioned splitter port number evaluation methods by reading and executing the computer program instructions stored in the memory 502.

[0190] In one example, the electronic device can further include a communication interface 504 and a bus 504. Wherein, as shown in the figure, the processor 501, the memory 502, the communication interface 504 are connected through the bus 504 and complete the communication between each other. Figure 5

[0191] The communication interface 504 is mainly used to realize the communication between each module, device, unit and / or equipment in the embodiments of the present application.

[0192] ​Bus 504 includes a hardware, software, or both that couples components of the online data traffic metering device to each other. As an example but not a limitation, the bus can include an Accelerated Graphics Port (AGP) or other graphics bus, an Enhanced Industry Standard Architecture (EISA) bus, a Front Side Bus (FSB), a HyperTransport (HT) interconnect, an Industry Standard Architecture (ISA) bus, an InfiniBand™ interconnect, a Low Pin Count (LPC) bus, a memory bus, a Micro Channel Architecture (MCA) bus, a Peripheral Component Interconnect (PCI) bus, a PCI-Express (PCI-X) bus, a Serial Advanced Technology Attachment (SATA) bus, a Video Electronics Standards Association Local (VLB) bus, or another suitable bus or a combination of two or more of these. Where suitable, bus 504 can include one or more buses. Although particular buses have been described and shown in the embodiments of the present application, the present application contemplates any suitable bus or interconnect.

[0193] In addition, in combination with the splitter port quantity evaluation method in the above-mentioned embodiments, the embodiments of the present application can provide a computer storage medium for implementation. The computer storage medium has computer program instructions stored thereon; the computer program instructions are executed by a processor to implement any one of the bar code recognition methods in the above-mentioned embodiments.

[0194] It needs to be made clear that the present application is not limited to the specific configurations and processes described above and shown in the drawings. For the sake of brevity, detailed descriptions of well-known methods are omitted herein. In the above-mentioned embodiments, several specific steps are described and shown as examples. However, the method processes of the present application are not limited to the specific steps described and shown, and those skilled in the art can make various changes, modifications and additions, or change the order between steps, after understanding the spirit of the present application.

[0195] The functional blocks shown in the above structural block diagram can be implemented as hardware, software, firmware or a combination thereof. When implemented in hardware, it can be, for example, an electronic circuit, an application specific integrated circuit (ASIC), appropriate firmware, a plug-in, a functional card, etc. When implemented in software, the elements of the present application are program or code segments used to perform the required tasks. The program or code segments can be stored in a machine-readable medium or transmitted through a data signal carried in a carrier wave over a transmission medium or communication link. The "machine-readable medium" can include any medium capable of storing or transmitting information. Examples of the machine-readable medium include an electronic circuit, a semiconductor memory device, a ROM, a flash memory, an erasable ROM (EROM), a floppy disk, a CD-ROM, an optical disk, a hard disk, an optical fiber medium, a radio frequency (RF) link, etc. The code segments can be downloaded via a computer network such as the Internet, an intranet, etc.

[0196] The computer program instructions can also be loaded onto a computer, other programmable data processing apparatus, or other programmable data processing devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other programmable devices to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide processes for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks.

[0197] The above is merely specific implementation of the present application, and those skilled in the art can clearly understand the specific working process of the system, module and unit described above for the convenience and brevity of description, which can refer to the corresponding process in the foregoing method embodiments, and will not be described herein. It should be understood that the protection scope of the present application is not limited to this, and any person skilled in the art can easily think of various equivalent modifications or replacements within the technical range disclosed in the present application, and these modifications or replacements shall be covered within the protection scope of the present application.

Claims

1. A method for evaluating the number of ports of a cell splitter, characterized in that, The method comprises: acquiring user information of at least one to-be-planned cell; in the case that the to-be-planned cell is a splitter port covered cell, determining the expansion number of the splitter port of the to-be-planned cell according to the user quantity, the billing income, the current port quantity and the current port occupancy rate of the to-be-planned cell; in the case that the to-be-planned cell is a splitter port uncovered cell, performing value evaluation on each to-be-planned cell according to user features of the to-be-planned cell to obtain an evaluation value of each to-be-planned cell, wherein the user features include user usage behavior, consumption habits and contract relationship in a mobile network service; determining the planning number of the splitter port of the to-be-planned cell according to the evaluation value and port conversion features, wherein the port conversion features are used to represent the efficiency and value realization degree in the process from planning to use of the splitter port in a cell; the determination of the expansion number of the splitter port of the to-be-planned cell according to the user quantity, the billing income, the current port quantity and the current port occupancy rate of the to-be-planned cell comprises: in the case that the to-be-planned cell meets a first preset condition, determining to expand the splitter port of the to-be-planned cell, wherein the first preset condition includes that the current port occupancy rate is higher than a first preset threshold, the to-be-planned cell has not been expanded with the splitter port in a preset time, the user quantity of the to-be-planned cell has continuously increased in a preset time, and the billing income of the to-be-planned cell has continuously increased in a preset time; determining the expansion number of the splitter port of the to-be-planned cell according to the user quantity, the preset port utilization rate and the current port quantity of the to-be-planned cell comprises: the expansion number of the splitter port of the to-be-planned cell is calculated through formula (1): （1） Wherein, N is the expansion quantity of the planning cell optical splitter port, u is the cell user quantity, is the preset port utilization rate, and p is the current port quantity of the planning cell. the determination of the planning number of the splitter port of the to-be-planned cell according to the evaluation value and the port conversion features comprises: in the case that the evaluation value of the to-be-planned cell meets a second preset condition, the planning number of the splitter port of the to-be-planned cell is calculated through formula (3): （3） Wherein, is the planned number of ports of the optical splitter, is the total number of users of the cell, is the marketing success rate, is the new port occupancy rate.

2. The method of claim 1, wherein, the user features include total number of users, average consumption amount, average excess package flow fee, 5G user quantity, average call duration, average downlink flow, number of mobile mobile fusion, number of contract users and average in-network month.

3. The method of claim 1, wherein, the value evaluation on each to-be-planned cell according to the user features of the to-be-planned cell to obtain an evaluation value of each to-be-planned cell comprises: the evaluation value of the to-be-planned cell is calculated through formula (2): (2) wherein, is the evaluation value, is an activation function, k is a user feature number, and j is a cell number, is the kth user feature of the jth cell, M k is the kth user feature of all the cells not covered by the splitter ports, and |D| is the total number of cells not covered by the splitter ports, is the kth user feature of the jth cell, l is the kth user feature of the jth cell.

4. The method of claim 3, wherein, the port conversion features include marketing success rate and new port occupancy rate, the second preset condition is that the evaluation values of the to-be-planned cells are sorted from high to low, and the cells in the top preset percentage are taken.

5. The method of claim 2, wherein, the acquisition of the user information of at least one to-be-planned cell comprises: acquiring the latitude and longitude information of each to-be-planned cell; acquiring user coordinate information in the range of each to-be-planned cell through permanent base station positioning and MR positioning; locating the users to the nearest cell according to the user coordinate information to determine the users of each to-be-planned cell.

6. The method of claim 5, wherein, The user is positioned to the nearest cell according to the user coordinate information, and users in each of the to-be-planned cells are determined, including: The to-be-planned cell coordinate and the user coordinate in the cell belong to the same administrative division; The difference between the to-be-planned cell coordinate and the user coordinate in the cell is less than a second preset threshold.

7. A cell optical splitter port number evaluation apparatus, characterized by, The device comprises: An acquisition module is configured to acquire user information of at least one to-be-planned cell; A first determination module is configured to, in a case where the to-be-planned cell is a splitter port covered cell, determine an expansion number of a splitter port of the to-be-planned cell according to a user number, an account income, a current port number and a current port occupancy rate of the to-be-planned cell; An evaluation module is configured to, in a case where the to-be-planned cell is a splitter port uncovered cell, perform value evaluation on each of the to-be-planned cells according to user features of the to-be-planned cell to obtain an evaluation value of each to-be-planned cell, the user features including a use behavior, a consumption habit and a contract relationship of the user in a mobile network service; A second determination module is configured to determine a planning number of a splitter port of the to-be-planned cell according to the evaluation value and a port conversion feature, the port conversion feature being used to represent an efficiency and a value realization degree in a process from planning to use of the splitter port in the cell; The first determination module is configured to, in a case where the to-be-planned cell meets a first preset condition, determine to perform splitter port expansion on the to-be-planned cell, the first preset condition including that the current port occupancy rate is higher than a first preset threshold, the to-be-planned cell has not performed splitter port expansion in a preset time, a user number of the to-be-planned cell has continuously increased in the preset time, and an account income of the to-be-planned cell has continuously increased in the preset time; The expansion number of the splitter port of the to-be-planned cell is determined according to a cell user number, a preset port utilization rate and a current port number of the to-be-planned cell, including: The expansion number of the splitter port of the to-be-planned cell is calculated through formula (1): （1） Wherein, N is the expansion number of the planning cell optical splitter port, u is the cell user number, is the preset port utilization rate, and p is the current port number of the planning cell. The second determination module is configured to, in a case where the evaluation value of the to-be-planned cell meets a second preset condition, calculate the planning number of the splitter port of the to-be-planned cell through formula (3): （3） Wherein, is the planned number of optical splitter ports, is the total number of cell users, is the marketing success rate, is the new port occupancy rate.

8. An electronic device, comprising: The device comprises a processor and a memory storing computer program instructions; The processor executes the computer program instructions to implement the method in any one of claims 1-6.

Images