Network planning index calculation method, device and system
Through intelligent methods and microservice technology, the network planning indicators are automatically calculated, which solves the problems of low computing efficiency and high personnel requirements in the existing technology, and realizes efficient and low-latency indicator query.
Patent Information
- Application Number
- CN202510371319.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-03-26
- Publication Date
- 2025-06-27
AI Technical Summary
In the prior art, the calculation efficiency of network planning indicators is low, the data volume is large and complex, and differences in different regions need to be considered, resulting in higher requirements for network planners.
Intelligent methods are used to automatically calculate network planning indicators, obtain basic data through multiple database servers, and use multiple microservices to perform isolation calculations to improve computing efficiency.
Automatic network planning indicator calculation is realized, computing efficiency is improved, the requirements for network planners are reduced, and the latency of indicator query is low.
Smart Images
Figure CN120223544A_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of communications, and in particular, to a method, apparatus, and system for calculating network planning metrics. Background Art
[0002] The calculation of network planning metrics involves a large amount of data and frequent calculations, and the requirement for metric queries is low latency. For network planning metrics on a national scale, the number of data records can reach hundreds of millions. Moreover, the calculation of network planning metrics needs to consider the metric calculations in different regions, which can be divided into differences between the north and the south, as well as differences between provinces, cities, and districts and counties. Therefore, the calculation of network planning metrics is relatively complex.
[0003] Currently, the calculation of network planning metrics mainly relies on network planning personnel using tools such as Excel for calculation, with low calculation efficiency and high requirements for network planning personnel. Summary of the Invention
[0004] This application provides a method, apparatus, and system for calculating network planning metrics. It can automatically calculate network planning metrics in an intelligent manner and perform isolated calculations for different categories of network planning metrics, improving the calculation efficiency and reducing the requirements for network planning personnel.
[0005] In a first aspect, this application provides a method for calculating network planning metrics, which includes: obtaining basic network planning data of multiple parameter types in a first region from multiple database servers; each database server is used to store basic network planning data of one parameter type; calculating the basic network planning data of multiple parameter types through multiple microservices to obtain network planning metrics of multiple parameter types in the first region; and the multiple microservices correspond one-to-one with the multiple parameter types.
[0006] Optionally, obtaining basic network planning data of multiple parameter types in a first region from multiple database servers includes: in response to the difference between the basic network planning data of at least one parameter type in the multiple parameter types in the first region and the historical basic network planning data being greater than a difference threshold, obtaining basic network planning data of multiple parameter types in the first region from multiple database servers.
[0007] Optionally, obtaining basic network planning data of multiple parameter types in a first region from multiple database servers includes: in response to a network planning metric calculation instruction from a user, obtaining basic network planning data of multiple parameter types in the first region from multiple database servers.
[0008] Optionally, for any first parameter type among multiple parameter types, calculate the basic network planning data of multiple parameter types through multiple microservices to obtain the network planning metrics of multiple parameter types in a first region, including: obtaining the calculation script corresponding to the first parameter type from the metric calculation script table through the first microservice corresponding to the first parameter type; generating a first calculation task based on the calculation script corresponding to the first parameter type and the basic network planning data of the first parameter type in the first region, and adding the first calculation task to the end of the calculation queue; when the first calculation task moves to the head of the calculation queue and there are idle threads in the thread pool, execute the first calculation task through the idle threads to obtain the network planning metrics of the first parameter type in the first region.
[0009] Optionally, there are multiple first regions; the method further includes: when the network planning metrics of multiple parameter types in each first region among the multiple first regions are all calculated, determining the network planning metrics of multiple parameter types in a second region based on the network planning metrics of multiple parameter types in each first region; the second region is the region composed of the multiple first regions.
[0010] Optionally, the method further includes: when the network planning metrics of multiple parameter types in the multiple first regions are not calculated and the calculation duration of the network planning metrics of multiple parameter types in the multiple first regions exceeds a preset duration threshold, determining the network planning metrics of multiple parameter types in the second region based on the network planning metrics of multiple parameter types in each first region that have been calculated.
[0011] Optionally, determining the network planning metrics of multiple parameter types in the second region based on the network planning metrics of multiple parameter types in each first region that have been calculated includes: determining the network planning metrics of multiple parameter types in the first regions that have not been calculated among the multiple first regions based on the average value of the network planning metrics of each parameter type that have been calculated, to obtain the network planning metrics of multiple parameter types in each first region; determining the network planning metrics of multiple parameter types in the second region based on the network planning metrics of multiple parameter types in each first region.
[0012] The network planning metric calculation method provided by this application can obtain the basic network planning data of multiple parameter types in a first region from multiple database servers, and calculate the basic network planning data of multiple parameter types through multiple microservices corresponding to them to obtain the network planning metrics of multiple parameter types in the first region, providing an intelligent and automatic way to calculate network planning metrics. Compared with the current method of manual calculation by network planning personnel, it improves the calculation efficiency and reduces the requirements for network planning personnel.
[0013] In addition, in the network planning index calculation method provided by the present application, each database server is used to store the basic network planning data of a corresponding parameter type, and multiple microservices correspond one-to-one with multiple parameter types. In this way, the basic network planning data of different parameter types can be stored and calculated separately, so that isolated calculations can be performed for different types of network planning indexes, avoiding the mutual influence of the calculations of different types of network planning indexes.
[0014] Moreover, the network planning index calculation method provided by the present application adopts the microservice method to calculate network planning indexes, and decouples different types of network planning indexes.
[0015] Then, in the network planning index calculation method provided by the present application, a detailed producer-consumer mode is designed for the calculation of network planning indexes, which can save computing resources. The method also adopts the multi-threaded concurrency method to calculate network planning indexes, accelerating the calculation speed of network planning indexes.
[0016] In a second aspect, the present application provides a network planning index calculation device, which includes each functional module for the method described in the first aspect above.
[0017] In a third aspect, the present application provides a computer program product, including: computer instructions; when the computer instructions run on the network planning index calculation device, the network planning index calculation device is enabled to implement the method described in the first aspect above.
[0018] In a fourth aspect, the present application provides a network planning index calculation device, which includes: a processor and a memory; the memory stores instructions executable by the processor; when the processor is configured to execute the instructions, the network planning index calculation device is enabled to implement the method described in the first aspect above.
[0019] In a fifth aspect, the present application provides a readable storage medium, which includes: software instructions; when the software instructions run in the network planning index calculation device, the network planning index calculation device is enabled to implement the method described in the first aspect above.
[0020] In a sixth aspect, the present application provides a network planning index calculation system, which includes: multiple database servers, each of which is used to store the basic network planning data of a corresponding parameter type; a backend server, which is used to obtain the basic network planning data of multiple parameter types in a first area from the multiple database servers; calculating the basic network planning data of multiple parameter types through multiple microservices to obtain the network planning indexes of multiple parameter types in the first area; the multiple microservices correspond one-to-one with the multiple parameter types; a front-end server, which is used to send the network planning indexes of multiple parameter types in the first area to a client.
[0021] The beneficial effects of the second to sixth aspects described above can be referred to those described in the first aspect, and will not be elaborated here. BRIEF DESCRIPTION OF THE DRAWINGS
[0022] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings required for the description of the embodiments or the prior art. Obviously, the drawings in the following description are only some embodiments of the present application. For those of ordinary skill in the art, without creative efforts, other drawings can be obtained based on these drawings.
[0023] Figure 1 Schematic diagram of the composition of the network planning index calculation system provided by the embodiment of the present application;
[0024] Figure 2 Schematic diagram of the composition of the network planning index calculation device provided by the embodiment of the present application;
[0025] Figure 3 Schematic flow chart of the network planning index calculation method provided by the embodiment of the present application;
[0026] Figure 4 Schematic flow chart of the network planning index calculation process provided by the embodiment of the present application;
[0027] Figure 5 Schematic flow chart of the sub-region calculation process provided by the embodiment of the present application;
[0028] Figure 6 Schematic diagram of the composition of another network planning index calculation device provided by the embodiment of the present application. DETAILED DESCRIPTION OF THE EMBODIMENTS
[0029] The following will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only some embodiments of the present application, rather than all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts belong to the scope of protection of the present application.
[0030] It should be noted that in the embodiments of the present application, words such as "exemplarily" or "for example" are used to represent examples, illustrations or explanations. Any embodiment or design solution described as "exemplarily" or "for example" in the embodiments of the present application should not be construed as being more preferred or having more advantages than other embodiments or design solutions. Rather, the use of words such as "exemplarily" or "for example" is intended to present relevant concepts in a specific manner.
[0031] For the convenience of clearly describing the technical solutions of the embodiments of the present application, in the embodiments of the present application, terms such as "first" and "second" are used to distinguish identical or similar items with basically the same functions and roles. Those skilled in the art can understand that terms such as "first" and "second" do not limit the quantity and execution order.
[0032] The calculation of network planning indicators involves a large amount of data and frequent calculations. The requirement for index query latency is low. For network planning indicators on a national scale, the number of data entries can reach hundreds of millions. Moreover, the calculation of network planning indicators needs to consider the index calculations in different regions. Different regions can be divided into differences between the north and the south, and further divided into differences between provinces, cities, and districts, as well as differences between counties and districts. Therefore, the calculation of network planning indicators is relatively complex.
[0033] Currently, the calculation of network planning indicators mainly relies on network planning personnel using tools such as Excel for calculation, with relatively low calculation efficiency and high requirements for network planning personnel.
[0034] Based on this, the embodiments of the present application provide a network planning indicator calculation method, device, and system. It can automatically calculate network planning indicators in an intelligent manner and perform isolated calculations for different categories of network planning indicators, improving the calculation efficiency and reducing the requirements for network planning personnel.
[0035] The following is an introduction in conjunction with the accompanying drawings.
[0036] Figure 1 It is a schematic diagram of the composition of the network planning indicator calculation system provided by the embodiments of the present application. As Figure 1 shown, the system includes: a database server 100, a backend server 200, a frontend server 300, and a client 400.
[0037] There can be multiple database servers 100, and each database server 100 can be used to store basic network planning data of a corresponding parameter type.
[0038] For example, the types of parameters may specifically include: coverage parameters, capacity parameters, quality parameters, and data service capability parameters, etc. The basic network planning data of the coverage parameters may specifically include: the location of the base station, the coverage radius, and the signal strength, etc. The basic network planning data of the capacity parameters may specifically include: the number of terminals that the network can accommodate, the concurrency rate (the proportion of terminals using the network at the same time to the total number of terminals), and the network bandwidth requirements of the terminals, etc. The basic network planning data of the quality parameters may specifically include: the bit error rate, the signal-to-noise ratio, the network latency, and the packet loss rate, etc. The basic network planning data of the data service capability parameters may specifically include: the access network bandwidth and the backbone network bandwidth, the network protocol, and the quality of service (QoS) parameters, etc.
[0039] As an example, the database server 100 may be a PostGIS database server.
[0040] The backend server 200 may be a single server, or may also be a server cluster composed of multiple servers. In some embodiments, the server cluster may also be a distributed cluster. Optionally, the server may also be implemented on a cloud platform. For example, the cloud platform may include a private cloud, a public cloud, a hybrid cloud, a community cloud, a distributed cloud, an inter-cloud, and a multi-cloud, etc., or any combination thereof. The embodiments of the present application do not limit this.
[0041] As an example, the backend server 200 may be an Apche tomcat server.
[0042] The backend server 200 may calculate network planning metrics based on the basic network planning data stored in the database server 100. The specific process may refer to that described in the following embodiments and will not be elaborated here.
[0043] In some embodiments, the backend server 200 may build a microservice system through Spring Cloud. The microservice system includes multiple microservices. Each microservice may be quickly built using Spring Boot, and then the cooperation and management between multiple microservices are realized through various components of SpringCloud. The multiple microservices correspond one-to-one with the multiple types of parameters. Or rather, each microservice may be used to calculate the network planning metrics of a type of parameter.
[0044] In some embodiments, the backend server 200 may also send the calculated network planning metrics to the frontend server 300.
[0045] The front-end server 300 can send the calculated network planning metrics to the client 400.
[0046] As an example, the front-end service 300 can adopt the antd framework.
[0047] In some embodiments, as Figure 1 shown, the network planning metric calculation system may further include a layer server 500. For example, the layer server 500 may specifically be a GeoServer server.
[0048] The front-end server 300 can obtain map information from the layer server 500, fuse the calculated network planning metrics with the map information, and then send the result to the client 400, so that the client 400 can visually display the network planning metrics on the map information.
[0049] The execution subject of the network planning metric calculation method provided by the embodiments of the present application is a network planning metric calculation device. The network planning metric calculation device may be a back-end server (such as the aforementioned back-end server 200); alternatively, the network planning metric calculation device may also be a processor in the aforementioned back-end server (such as a central processing unit (CPU)); or, the network planning metric calculation device may also be a platform or software system deployed in the aforementioned back-end server; or, the network planning metric calculation device may also be a functional module in the aforementioned back-end server for executing the network planning metric calculation method, etc. The embodiments of the present application do not limit this.
[0050] For ease of introduction, hereinafter, the execution subject of the network planning metric calculation method provided by the embodiments of the present application is taken as the network planning metric calculation device as an example for introduction.
[0051] Figure 2 This is a schematic diagram of the composition of the network planning metric calculation device provided by the embodiments of the present application. As Figure 2 shown, the device includes: a processor 10, a memory 20, a communication line 30, a communication interface 40, and an input / output interface 50.
[0052] Among them, the processor 10, the memory 20, the communication interface 40, and the input / output interface 50 can be connected through the communication line 30.
[0053] The processor 10 is configured to execute the instructions stored in the memory 20 to implement the network planning metric calculation method provided by the following embodiments of the present application.
[0054] The processor 10 may be a CPU, a general-purpose processor, a network processor (NP), a digital signal processor (DSP), a microprocessor, a micro control unit (MCU) / single-chip microcomputer / microcontroller, a programmable logic device (PLD), or any combination thereof. The processor 10 may also be any other device with processing capabilities, such as a circuit, a device, or a software module. The embodiments of the present application do not limit this. In one example, the processor 10 may include one or more CPUs, such as Figure 2 the CPU0 and CPU1 in Figure 2 shown by the dashed line. As an alternative implementation, the network planning metric calculation device may include multiple processors. For example, in addition to the processor 10, it may also include a processor 60 (
[0055] The memory 20 is used to store instructions. For example, the instructions may be computer programs. Optionally, the memory 20 may be a read-only memory (ROM) or other types of static storage devices that can store static information and / or instructions, or it may be a random access memory (RAM) or other types of dynamic storage devices that can store information and / or instructions. It may also be an electrically erasable programmable read-only memory (EEPROM), a compact disc read-only memory (CD-ROM), or other optical disc storage, optical disc storage (including compact discs, laser discs, optical discs, digital versatile discs, Blu-ray discs, etc.), magnetic disk storage media, or other magnetic storage devices. The embodiments of the present application do not limit this.
[0056] It should be noted that the memory 20 may exist independently of the processor 10 or may be integrated with the processor 10. The memory 20 may be located inside the network planning metric calculation device or outside the network planning metric calculation device. The embodiments of the present application do not limit this.
[0057] The communication line 30 is used to transmit information between the various components included in the network planning metric calculation device.
[0058] A communication interface 40 for communicating with other devices or other communication networks. The other communication network can be an Ethernet, a radio access network (RAN), a wireless local area network (WLAN), etc. The communication interface 40 can be a module, a circuit, a transceiver, or any device capable of implementing communication.
[0059] An input / output interface 50 for implementing human-computer interaction between a user and the network planning index calculation device. For example, to implement action interaction or information interaction between the user and the network planning index calculation device.
[0060] Exemplarily, the input / output interface 50 can be a mouse, a keyboard, a display screen, or a touch display screen, etc. Action interaction or information interaction between the user and the network planning index calculation device can be achieved through a mouse, a keyboard, a display screen, or a touch display screen, etc.
[0061] It should be noted that Figure 2 the structure shown in Figure 2 does not constitute a limitation on the network planning index calculation device. In addition to
[0062] the components shown, the network planning index calculation device may include more or fewer components than those shown in the figure, or a combination of certain components, or a different component arrangement.
[0062] The network planning index calculation method provided by the embodiments of the present application will be introduced below with reference to the accompanying drawings.
[0063] Figure 3 is a schematic flowchart of the network planning index calculation method provided by the embodiments of the present application. As Figure 3 shown, the method includes the following steps:
[0064] S101. Obtain the basic network planning data of multiple parameter types in a first area from multiple database servers.
[0065] Among them, each database server is used to correspondingly store the basic network planning data of one parameter type. The parameter type and the basic network planning data can be referred to as described above Figure 1 and will not be elaborated here.
[0066] In a possible implementation manner, the calculation of the network planning index can be automatically triggered by changes in the basic network planning data. In this case, the above S101 can specifically include: in response to the difference between the basic network planning data of at least one parameter type among multiple parameter types in the first area and the historical basic network planning data being greater than a difference threshold, obtain the basic network planning data of multiple parameter types in the first area from multiple database servers.
[0067] Exemplarily, taking the location of the base station in the above coverage parameters as an example, assume that there are 100 base station locations in the first area in the historical basic network planning data, and the difference threshold is 5. If some base stations are newly added in the first area and there are 110 base stations in the basic network planning data, at this time, the difference between the 110 base stations in the basic network planning data and the 100 base stations in the historical basic network planning data is 10 base stations, which is greater than the difference threshold of 5. At this time, the calculation of network planning indicators can be triggered.
[0068] In another possible implementation manner, the calculation of network planning indicators can also be triggered manually. In this case, step S101 may specifically include: in response to a user's network planning indicator calculation instruction, obtaining basic network planning data of multiple parameter types in the first area from multiple database servers.
[0069] For example, as described above, the network planning indicator calculation device may include an input / output interface, and the input / output interface may be a mouse, a keyboard, or a touch display screen, etc. The network planning indicator calculation device may receive a user-input network planning indicator calculation instruction through an input / output interface such as a mouse, a keyboard, or a touch display screen.
[0070] S102. Calculate the basic network planning data of multiple parameter types through multiple microservices to obtain network planning indicators of multiple parameter types in the first area.
[0071] Among them, multiple microservices correspond one-to-one with multiple parameter types. The first area can be understood as a district or county, a city, or a province, etc. The specific scope of the first area is not limited in the embodiments of the present application.
[0072] In some embodiments, before calculating the network planning indicators of multiple parameter types, the network planning indicator calculation device may also pre-create multiple microservices. For example, the network planning indicator calculation device may build a microservice system through the above-mentioned SpringCloud, and the microservice system includes multiple microservices.
[0073] In some possible embodiments, the network planning indicator calculation device may specifically control the calculation of network planning indicators through the producer and consumer mode. In this case, taking any first parameter type among multiple parameter types as an example, step S102 may specifically include the following steps:
[0074] Step 1a. Obtain the calculation script corresponding to the first parameter type from the indicator calculation script table through the first microservice corresponding to the first parameter type.
[0075] For example, a first correspondence between parameter types and microservices is preset in the network planning index calculation device. Specifically, the network planning index calculation device can use the parameter type as an index to traverse and search for the first correspondence, and use the microservice corresponding to the first parameter type in the first correspondence as the first microservice.
[0076] For another example, a second correspondence between parameter types and calculation scripts is preset in the first microservice. Specifically, the first microservice can use the parameter type as an index to traverse and search for the second correspondence, and determine the calculation script corresponding to the first parameter type in the second correspondence.
[0077] In some embodiments, after determining the calculation script, the network planning index calculation device or the first microservice can also perform professional adaptation on the calculation script. For example, if the calculation script itself is for calculating the network planning index of area A, and if the trigger for calculating the network planning index is area B, then the network planning index calculation device or the first microservice can also replace the variable characters in the calculation script from area A to area B to facilitate the calculation of the network planning index of area B.
[0078] Step 2a: Generate a first calculation task based on the calculation script corresponding to the first parameter type and the basic network planning data of the first parameter type in the first area, and add the first calculation task to the end of the calculation queue.
[0079] In some embodiments, after generating the first calculation task, the network planning index calculation device or the first microservice can also set the calculation status of the first calculation task to not started yet.
[0080] Step 3a: When the first calculation task moves to the head of the calculation queue and there are idle threads in the thread pool, execute the first calculation task through the idle threads to obtain the network planning index of the first parameter type in the first area.
[0081] It should be noted that when the first calculation task does not move to the head of the calculation queue and / or there are no idle threads in the thread pool, the first calculation task can continue to wait, and the calculation status remains not started yet.
[0082] In some embodiments, when executing the first calculation task through the idle threads, the network planning index calculation device or the first microservice can set the calculation status of the first calculation task to in progress.
[0083] In some embodiments, the network planning index calculation device or the first microservice can also determine whether the first calculation task is successfully calculated. If it is successfully calculated, set the calculation status of the first calculation task to successfully calculated; if it fails, set the calculation status of the first calculation task to failed, and record the error log in the calculation log table.
[0084] In some embodiments, after the network planning index calculation device finishes executing the first calculation task by occupying an idle thread, it can also return the occupied thread to the thread pool.
[0085] In the network planning index calculation method provided by the embodiments of the present application, the network planning index calculation device can obtain the basic network planning data of multiple parameter types in the first area from multiple database servers, and calculate the basic network planning data of multiple parameter types through multiple microservices to obtain the network planning indexes of multiple parameter types in the first area, providing an intelligent and automatic way to calculate network planning indexes. Compared with the current manual calculation method of network planning personnel, the calculation efficiency is improved, and the requirements for network planning personnel are reduced.
[0086] In addition, in the network planning index calculation method provided by the embodiments of the present application, each database server is used to store the basic network planning data of one parameter type correspondingly, and multiple microservices correspond to multiple parameter types one by one. In this way, the basic network planning data of different parameter types can be stored and calculated separately, so as to perform isolated calculations for different types of network planning indexes and avoid the mutual influence of the calculations of different types of network planning indexes.
[0087] Moreover, the network planning index calculation method provided by the embodiments of the present application adopts the microservice method to calculate network planning indexes, and decouples different types of network planning indexes.
[0088] Then, in the network planning index calculation method provided by the embodiments of the present application, a detailed producer-consumer mode is designed for network planning index calculation, which can save computing resources, and the multi-threaded concurrency method is also adopted to calculate network planning indexes, accelerating the calculation speed of network planning indexes.
[0089] Finally, the network planning index calculation method provided by the embodiments of the present application can also record the calculation status at different stages during the calculation process, perform a traceability process, which is convenient for network planning personnel to find problems in the network planning index calculation process and search for calculation history.
[0090] In some possible embodiments, the above-mentioned first area may include multiple ones. When the network planning indexes of multiple first areas are all calculated, the network planning index calculation device can further calculate the network planning indexes within the scope of the upper-level area. In this case, the method may further include the following steps:
[0091] Step 1b. When the network planning metrics of multiple parameter types in each of the multiple first regions have been calculated, determine the network planning metrics of multiple parameter types in the second region based on the network planning metrics of multiple parameter types in each first region.
[0092] Among them, the second region is the region composed of multiple first regions. For example, the first region can be understood as a district or county, and the second region can be understood as a city including multiple districts or counties; or, the first region can also be understood as a city, and the second region can be understood as a province including multiple cities; or, the first region can further be understood as a province, and the second region can be understood as a national region including multiple provinces, etc. The embodiments of the present application do not limit this.
[0093] Optionally, in order to avoid the calculation error of some first regions affecting the calculation of the network planning metrics of the entire second region, if the calculation time of the network planning metrics of a certain first region is too long, the network planning metrics calculation device can directly calculate the network planning metrics of the second region. In this case, the method may further include the following steps:
[0094] Step 1c. When the network planning metrics of multiple parameter types in the multiple first regions have not been calculated and the calculation duration of the network planning metrics of multiple parameter types in the multiple first regions exceeds a preset duration threshold, determine the network planning metrics of multiple parameter types in the second region based on the network planning metrics of multiple parameter types in each of the first regions that have been calculated.
[0095] Among them, the duration threshold can be preset in the network planning metrics calculation device. For example, the duration threshold can be set to 12 hours, 24 hours, 48 hours, or 72 hours, etc. The embodiments of the present application do not limit the specific value of the duration threshold.
[0096] In a possible implementation manner, for the first region whose network planning metrics have not been calculated when the calculation duration exceeds the preset duration threshold, the network planning metrics calculation device can temporarily replace the network planning metrics of the first region whose network planning metrics have not been calculated with the average value, minimum value, maximum value, or median value, etc. of the network planning metrics of other first regions. In this case, taking the average value as an example, the step of determining the network planning metrics of multiple parameter types in the second region based on the network planning metrics of multiple parameter types in each of the first regions that have been calculated may specifically include:
[0097] Step 1.1c. Based on the average value of the network planning metrics of each parameter type that has been calculated, determine the network planning metrics of multiple parameter types in the first regions that have not been calculated among the multiple first regions, and obtain the network planning metrics of multiple parameter types in each first region.
[0098] Step 1.2c: Determine the network planning indicators of multiple parameter types in the second region based on the network planning indicators of multiple parameter types in each first region.
[0099] In the network planning indicator calculation method provided by the embodiments of the present application, the network planning indicator calculation device can calculate the network planning indicators for multiple first regions respectively. By adopting a multi-branch method, it realizes the intelligent calculation of network planning indicators, isolates and separates incorrect calculations, thereby avoiding the delay of the overall network planning indicator calculation progress caused by incorrect calculations.
[0100] Based on the understanding of the above embodiments, Figure 4 This is a schematic diagram of the network planning indicator calculation process provided by the embodiments of the present application. As Figure 4 shown, after receiving the calculation instruction and calculation information (i.e., the above basic network planning data), the network planning indicator calculation device can obtain the information to be calculated from the indicator calculation script table, process the variable characters in the script with the calculation information (such as replacing the province and city), set the calculation status to not started, then insert the generated calculation task into the calculation queue, and determine whether there is an idle thread. If there is no idle thread, it waits and the status remains not started; if there is an idle thread, it performs the calculation, sets the calculation status to in progress, determines whether the calculation is successful. If the calculation fails, the status is set to calculation failed, and the error log is recorded in the calculation log table. If successful, the status is set to calculation successful.
[0101] Based on the understanding of the above embodiments, Figure 5 This is a schematic diagram of the regional calculation process provided by the embodiments of the present application. As Figure 5 shown, the network planning indicator calculation device can traverse the calculations of cities in the whole province ( Figure 5 taking the whole province including City 1, City 2, …, and City n as an example). After each city finishes the execution, it sends a calculation instruction for the whole province, and then determines whether all cities have finished the execution. If all cities have finished the execution, it performs the province calculation. If all addresses have not finished the execution, it determines the calculation time. If the calculation time has timed out, it performs the province calculation. If the calculation time has not timed out, it waits for the next province calculation instruction.
[0102] The above mainly introduces the solution provided by the embodiments of the present application from the perspective of methods. To implement the above functions, the network planning index calculation device includes the corresponding hardware structure and / or software module for executing each function. Those skilled in the art should easily realize that, combining the units and algorithm steps of each example described in the embodiments disclosed in this article, the present application can be implemented in the form of hardware or a combination of hardware and computer software. Whether a certain function is executed in the way of hardware or computer software driving hardware depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods for each specific application to implement the described function, but such implementation should not be considered to exceed the scope of the present application.
[0103] In an exemplary embodiment, the embodiments of the present application further provide a network planning index calculation device in the form of a virtual device. Figure 6 It is a schematic diagram of the composition of another network planning index calculation device provided by the embodiments of the present application. As Figure 6 shown, the device includes: an acquisition module 601 and a processing module 602.
[0104] The acquisition module 601 is configured to obtain the basic network planning data of multiple parameter types in the first area from multiple database servers; each database server is used to store the basic network planning data of one parameter type correspondingly.
[0105] The processing module 602 is configured to calculate the basic network planning data of multiple parameter types through multiple microservices to obtain the network planning indexes of multiple parameter types in the first area; the multiple microservices correspond to the multiple parameter types one by one.
[0106] In some possible embodiments, the acquisition module 601 is specifically configured to, in response to that the difference between the basic network planning data of at least one parameter type in the multiple parameter types in the first area and the historical basic network planning data is greater than the difference threshold, obtain the basic network planning data of multiple parameter types in the first area from multiple database servers.
[0107] In some other possible embodiments, the acquisition module 601 is specifically configured to, in response to the network planning index calculation instruction of the user, obtain the basic network planning data of multiple parameter types in the first area from multiple database servers.
[0108] In some other possible embodiments, for any first parameter type among multiple parameter types, the processing module 602 is specifically configured to obtain a calculation script corresponding to the first parameter type from the index calculation script table through a first microservice corresponding to the first parameter type; generate a first calculation task based on the calculation script corresponding to the first parameter type and the basic network planning data of the first parameter type in the first area, and add the first calculation task to the end of the calculation queue; when the first calculation task moves to the head of the calculation queue and there are idle threads in the thread pool, execute the first calculation task through the idle threads to obtain the network planning index of the first parameter type in the first area.
[0109] In some other possible embodiments, there are multiple first areas; the processing module 602 is further configured to, when the network planning indexes of multiple parameter types in each first area among the multiple first areas are all calculated, determine the network planning indexes of multiple parameter types in a second area based on the network planning indexes of multiple parameter types in each first area; the second area is an area composed of the multiple first areas.
[0110] In some other possible embodiments, the processing module 602 is further configured to, when the network planning indexes of multiple parameter types in the multiple first areas are not calculated and the calculation duration of the network planning indexes of multiple parameter types in the multiple first areas exceeds a preset duration threshold, determine the network planning indexes of multiple parameter types in the second area based on the network planning indexes of multiple parameter types in each first area that have been calculated.
[0111] In some other possible embodiments, the processing module 602 is specifically configured to determine the network planning indexes of multiple parameter types in the uncalculated first areas among the multiple first areas based on the average value of the network planning indexes of each parameter type that have been calculated, to obtain the network planning indexes of multiple parameter types in each first area; and determine the network planning indexes of multiple parameter types in the second area based on the network planning indexes of multiple parameter types in each first area.
[0112] It should be noted that Figure 6 The division of modules in [the previous text] is illustrative, merely a logical function division, and there may be other division methods in actual implementation. For example, two or more functions can also be integrated into one processing module. The above integrated module can be implemented in the form of hardware or in the form of a software function module.
[0113] In an exemplary embodiment, the embodiments of the present application further provide a computer program product, which includes computer instructions. When the computer instructions run in the network planning index calculation device, the network planning index calculation device is enabled to implement the method in the foregoing method embodiments.
[0114] In an exemplary embodiment, the embodiment of the present application further provides a readable storage medium, which includes software instructions. When the software instructions run in the network planning index calculation device, the network planning index calculation device is enabled to implement the method in the foregoing method embodiment. The computer-readable storage medium may be a non-transitory computer-readable storage medium. For example, the non-transitory computer-readable storage medium may be ROM, random access memory (RAM), CD-ROM, magnetic tape, floppy disk, and optical data storage device, etc.
[0115] In the above embodiment, it may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented using a software program, it may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer-executable instructions. When the computer-executable instructions are loaded and executed on a computer, the processes or functions according to the embodiments of the present application are generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices. The computer-executable instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer-executable instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center in a wired manner (such as coaxial cable, optical fiber, digital subscriber line (DSL)) or a wireless manner (such as infrared, wireless, microwave, etc.).
[0116] Although the present application has been described in conjunction with various embodiments herein, however, in the process of implementing the claimed present application, those skilled in the art can understand and implement other variations of the disclosed embodiments by viewing the drawings, the disclosure, and the appended claims. In the claims, the word "comprising" does not exclude other components or steps, and "a" or "one" does not exclude a plurality. A single processor or other unit may implement several functions recited in the claims. Certain measures are recited in mutually different dependent claims, but this does not mean that these measures cannot be combined to produce good results.
[0117] Although the present application has been described in connection with specific features and their embodiments, it is obvious that various modifications and combinations can be made without departing from the spirit and scope of the present application. Accordingly, this specification and the drawings are merely exemplary illustrations of the present application defined by the appended claims, and are considered to have covered any and all modifications, variations, combinations or equivalents within the scope of the present application. Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalent technologies, the present application is also intended to include these changes and modifications.
[0118] As described above, the above is only the specific implementation manner of the present application, but the protection scope of the present application is not limited thereto. Any changes or substitutions within the technical scope disclosed in the present application should be covered within the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the protection scope of the claims.
Claims
1. A method for calculating network planning indicators, characterized in that: The method comprises: Acquire basic network planning data of multiple parameter types in the first area from multiple database servers; each database server is used to store basic network planning data of one parameter type; The basic network planning data of the multiple parameter types are calculated by multiple microservices to obtain network planning indicators of the multiple parameter types in the first area; the multiple microservices correspond to the multiple parameter types one by one.
2. The method according to claim 1, characterized in that The obtaining basic network planning data of multiple parameter types in the first area from multiple database servers includes: In response to the fact that the difference between basic network planning data and historical basic network planning data of at least one parameter type among multiple parameter types in the first area is greater than a difference threshold, basic network planning data of multiple parameter types in the first area are obtained from multiple database servers.
3. The method according to claim 1, characterized in that The obtaining basic network planning data of multiple parameter types in the first area from multiple database servers includes: In response to a user's network planning indicator calculation instruction, basic network planning data of multiple parameter types in a first area are obtained from multiple database servers.
4. The method according to claim 1, characterized in that: For any first parameter type among the multiple parameter types, calculating the basic network planning data of the multiple parameter types through multiple microservices to obtain network planning indicators of the multiple parameter types in the first area includes: Obtaining a calculation script corresponding to the first parameter type from an indicator calculation script table through a first microservice corresponding to the first parameter type; Based on the calculation script corresponding to the first parameter type and the basic network planning data of the first parameter type in the first area, generate a first calculation task and add the first calculation task to the end of the calculation queue; When the first computing task is moved to the head of the computing queue and there are idle threads in the thread pool, the first computing task is executed by the idle threads to obtain a network planning indicator of the first parameter type in the first area.
5. The method according to claim 1, characterized in that The first area includes a plurality of areas; and the method further includes: When the network planning indicators of multiple parameter types in each of the multiple first areas are calculated, the network planning indicators of multiple parameter types in the second area are determined based on the network planning indicators of multiple parameter types in each of the first areas; the second area is an area composed of the multiple first areas.
6. The method according to claim 5, characterized in that The method further comprises: When the network planning indicators of multiple parameter types in multiple first areas have not been calculated, and the calculation time of the network planning indicators of multiple parameter types in multiple first areas exceeds a preset time threshold, the network planning indicators of multiple parameter types in the second area are determined based on the network planning indicators of multiple parameter types in each first area that have been calculated.
7. The method according to claim 6, characterized in that The determining of the network planning indicators of multiple parameter types in the second area based on the calculated network planning indicators of multiple parameter types in each of the first areas comprises: Based on the average value of the network planning index of each parameter type that has been calculated, determine the network planning index of multiple parameter types of the first areas that have not been calculated in the multiple first areas, and obtain the network planning index of multiple parameter types in each first area; Based on the network planning indicators of multiple parameter types in each first area, the network planning indicators of multiple parameter types in the second area are determined.
8. A network planning index calculation device, characterized in that: The device comprises: An acquisition module, used for acquiring basic network planning data of multiple parameter types in the first area from multiple database servers; each database server is used for storing basic network planning data of one parameter type; The processing module is used to calculate the basic network planning data of the multiple parameter types through multiple microservices to obtain the network planning indicators of the multiple parameter types in the first area; the multiple microservices correspond to the multiple parameter types one by one.
9. A network planning index calculation device, characterized in that: include: Processor and memory; The memory stores instructions executable by the processor; When the processor is configured to execute the instruction, the network planning indicator calculation device implements the method according to any one of claims 1 to 7.
10. A network planning index calculation system, characterized in that: The system comprises: A plurality of database servers, each database server being used to store basic network planning data of a corresponding parameter type; A backend server is used to obtain basic network planning data of multiple parameter types in the first area from multiple database servers; calculate the basic network planning data of the multiple parameter types through multiple microservices to obtain network planning indicators of the multiple parameter types in the first area; the multiple microservices correspond to the multiple parameter types one by one; The front-end server is used to send network planning indicators of the multiple parameter types in the first area to the client.