5G cell service rate processing method, platform, server and media

Abstract

The present application provides a method, platform, server and medium for processing the service rate of 5G cells. The method obtains the alarm data and 5G cell resource table in the network management alarm system through the Hive data warehouse platform, and stores the alarm data and 5G cell resource table in the ODS layer; stores the alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or 5G base station disconnection judgment strategy in the cell decommissioning intermediate table or base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform; based on this, obtains the 5G base station disconnection conversion cell intermediate table; and then creates a 5G cell decommissioning broadband table in the DWD layer, and creates a 5G cell decommissioning index summary table in the ADS layer, thereby obtaining the 5G cell service rate. Compared with the existing technology, the method provided by the present application can improve the accuracy and processing efficiency of the 5G cell service rate.

Description

Technical Field

[0001] The present application relates to the field of mobile communication technology, and in particular to a method, platform, server and medium for processing the service rate of a 5G cell. Background Art

[0002] With the advent of the 5G era, more and more communities are gaining 5G coverage, allowing users to access the internet at even faster speeds. However, network equipment failures can affect 5G cell signals, and in severe cases, even prevent users from accessing the internet, significantly impacting their daily lives. Therefore, analyzing the nationwide 5G cell service rate is crucial.

[0003] Currently, the process for analyzing 5G cell availability nationwide is as follows: Alarm data from 5G cells at each provincial level is manually analyzed and reported to headquarters. Headquarters technicians then process this data to determine the national 5G cell availability rate. Furthermore, maintenance is then performed on equipment in each province based on this analysis.

[0004] However, due to the inconsistent standards for whether cells are in service at different provincial levels and the need for manual processing by technical personnel, the obtained 5G cell service rate indicator is not accurate enough and is inefficient. Summary of the Invention

[0005] This application provides a method, platform, server and medium for processing 5G cell service rate, which is used to solve the problem in the existing technology that manual analysis of the national 5G cell service rate is not accurate and efficient.

[0006] In a first aspect, the present application provides a method for processing a 5G cell service rate, comprising:

[0007] The Hive data warehouse platform obtains the alarm data and the 5G cell resource table from the network management alarm system, and stores the alarm data and the 5G cell resource table in the ODS layer of the Hive data warehouse platform;

[0008] The Hive data warehouse platform obtains alarm data that meets the pre-configured 5G cell deservice judgment policy or the pre-configured 5G base station disconnection judgment policy, and stores the alarm data that meets the pre-configured 5G cell deservice judgment policy or the pre-configured 5G base station disconnection judgment policy in the cell deservice intermediate table or the base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform;

[0009] The Hive data warehouse platform analyzes and obtains the 5G base station disconnection conversion cell intermediate table based on the base station disconnection intermediate table in the MID layer and the 5G cell resource table in the ODS layer; and integrates the base station disconnection intermediate table and the 5G base station disconnection conversion cell intermediate table and stores them in the 5G cell decommissioning broadband table created by the DWD layer of the Hive data warehouse platform;

[0010] The Hive data warehouse platform integrates and processes the data in the 5G cell deservice broadband table in the DWD layer, and stores the integrated data in the 5G cell deservice index summary table created in the ADS layer of the Hive data warehouse platform. According to the 5G cell deservice index summary table and a preset assessment interval, the 5G cell service rate is obtained.

[0011] In an optional implementation, the Hive data warehouse platform obtains alarm data that meets a preconfigured 5G cell deservice judgment policy or a preconfigured 5G base station disconnection judgment policy, and stores the alarm data that meets the preconfigured 5G cell deservice judgment policy or the preconfigured 5G base station disconnection judgment policy in a cell deservice intermediate table or a base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform, including:

[0012] The Hive data warehouse platform determines whether the manufacturer information, alarm object type, and alarm title in the alarm data meet the pre-configured 5G cell decommissioning judgment policy. If so, the satisfied alarm data is stored in the cell decommissioning intermediate table created by the MID layer in the Hive data warehouse platform;

[0013] The Hive data warehouse platform determines whether the manufacturer information, alarm object type and alarm title in the alarm data meet the pre-configured 5G base station disconnection judgment strategy. If so, the satisfied alarm data is stored in the base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform.

[0014] In an optional embodiment, the preconfigured alarm titles in the preconfigured 5G cell decommissioning judgment strategy include one or more of the following combinations: NR cell unavailable alarm, NR distribution unit cell unavailable alarm, DU cell decommissioning, service unavailable, cell decommissioning, and X2 link unavailable.

[0015] In an optional embodiment, the preconfigured alarm titles in the preconfigured 5G base station disconnection judgment strategy include one or more of the following combinations: network element connection interruption, gNodeB decommissioning alarm, network element link disconnection, NEA and network element disconnection and base station decommissioning.

[0016] In an optional implementation, the Hive data warehouse platform integrates the data in the 5G cell out-of-service broadband table in the DWD layer, and stores the integrated data in a 5G cell out-of-service indicator summary table created in the ADS layer of the Hive data warehouse platform. The 5G cell service rate is obtained based on the 5G cell out-of-service indicator summary table and a preset assessment interval, including:

[0017] The Hive data warehouse platform calculates the total number of cell IDs in the 5G cell decommissioning broadband table according to the 5G cell decommissioning broadband table in the DWD layer, obtains the total number of 5G cells, and stores the total number of 5G cells in the 5G cell decommissioning indicator summary table created in the ADS layer of the Hive data warehouse platform;

[0018] The Hive data warehouse platform obtains, based on each cell ID in the 5G cell decommissioning broadband table in the DWD layer, a first difference between the alarm clearing time and the alarm occurrence time of each cell ID, and obtains, based on the first difference of each cell ID, a fault duration corresponding to each cell ID;

[0019] The sum of the fault duration corresponding to each cell ID is obtained respectively, and based on the sum of the fault duration corresponding to each cell ID, the 5G cell fault deservice duration corresponding to the cell ID in the preset assessment interval is obtained, so as to store the 5G cell fault deservice duration in the 5G cell deservice indicator summary table created by the ADS layer of the Hive data warehouse platform.

[0020] In an optional implementation manner, obtaining the 5G cell service rate according to the 5G cell out-of-service indicator summary table and a preset assessment interval includes:

[0021] Calculate the product of the number of all 5G cells in the 5G cell decommissioning index summary table and the total number of minutes corresponding to the preset assessment interval to obtain the 5G cell assessment duration;

[0022] Calculate the second time difference between the 5G cell assessment duration and the 5G cell fault deservice duration within the assessment interval, and calculate the ratio of the second time difference to the 5G cell assessment duration to obtain the 5G cell service rate.

[0023] In an optional embodiment, the method further includes:

[0024] Obtaining a query request, wherein the query request includes an identifier of a cell to be queried;

[0025] According to the query request, the 5G cell decommissioning broadband table is queried to obtain the alarm data corresponding to the cell identifier to be queried, and the alarm data is analyzed and processed to obtain the fault cause data.

[0026] In a second aspect, the present application provides a Hive data warehouse platform, including:

[0027] A configuration module is used to obtain alarm data and a 5G cell resource table from a network management alarm system, and store the alarm data and the 5G cell resource table in the ODS layer of the Hive data warehouse platform;

[0028] The configuration module is further configured to obtain alarm data that satisfies a preconfigured 5G cell deservice judgment policy or a preconfigured 5G base station disconnection judgment policy, and store the alarm data that satisfies the preconfigured 5G cell deservice judgment policy or the preconfigured 5G base station disconnection judgment policy in a cell deservice intermediate table or a base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform;

[0029] The configuration module is further configured to analyze and obtain a 5G base station disconnection conversion cell intermediate table based on the base station disconnection intermediate table in the MID layer and the 5G cell resource table in the ODS layer; and integrate the base station disconnection intermediate table and the 5G base station disconnection conversion cell intermediate table and store them in the 5G cell decommissioning broadband table created in the DWD layer of the Hive data warehouse platform;

[0030] The processing module is used to perform data integration processing on the 5G cell decommissioning broadband table in the DWD layer, obtain a 5G cell decommissioning indicator summary table, and store it in the ADS layer of the Hive data warehouse platform; and obtain the 5G cell service rate according to the 5G cell decommissioning indicator summary table and a preset assessment interval.

[0031] In a third aspect, the present application provides a server, comprising: a processor, and a memory communicatively connected to the processor;

[0032] The memory stores computer-executable instructions;

[0033] The processor executes the computer-executable instructions stored in the memory to implement the method as described in any one of the preceding items.

[0034] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions. When a processor executes the computer-executable instructions, the method described in any of the preceding items is implemented.

[0035] The present application provides a method, platform, server and medium for processing the service rate of a 5G cell. The alarm data in the network management alarm system and the 5G cell resource table are obtained through the Hive data warehouse platform, and the alarm data and the 5G cell resource table are stored in the ODS layer of the Hive data warehouse platform; the Hive data warehouse platform obtains the alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or the pre-configured 5G base station disconnection judgment strategy, and stores the alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or the pre-configured 5G base station disconnection judgment strategy in the cell decommissioning intermediate table or the base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform; the Hive data warehouse platform obtains the alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or the pre-configured 5G base station disconnection judgment strategy according to the MID layer. The base station disconnection intermediate table in the ODS layer and the 5G cell resource table in the ODS layer are analyzed to obtain the 5G base station disconnection conversion cell intermediate table; and the base station disconnection intermediate table and the 5G base station disconnection conversion cell intermediate table are integrated and stored in the 5G cell decommissioning broadband table created by the DWD layer of the Hive data warehouse platform; the Hive data warehouse platform integrates and processes the data in the 5G cell decommissioning broadband table in the DWD layer, and stores the integrated data in the 5G cell decommissioning index summary table created by the ADS layer of the Hive data warehouse platform, and obtains the 5G cell service rate according to the 5G cell decommissioning index summary table and the preset assessment interval. Compared with the existing technology, this application is based on the Hive data warehouse platform, and automatically uses the various data layers (ODS, MID, DWD, ADS) in the data warehouse platform to perform data analysis and processing on the data in the network management alarm system and the 5G cell resource table layer by layer, and separates the 5G cell decommissioning data and the base station disconnection data from the network management alarm data and the 5G cell resource table data, and converts the base station disconnection data into 5G cell decommissioning data, and then integrates the 5G cell decommissioning data and the converted 5G cell decommissioning data and stores them in the ADS layer of the Hive data warehouse platform. Finally, according to the data table in the ADS layer, the technology of 5G cell service rate is performed. Using this method, it can solve the problem of slow efficiency and low accuracy of manual calculation of 5G cell service rate in the existing technology, and can also solve the problem of inconsistent standards for alarm data analysis indicators in various provinces in the existing technology, thereby improving the accuracy of 5G cell service rate. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0037] Figure 1 A schematic diagram of a 5G cell service rate processing method provided in this application:

[0038] Figure 2 A schematic diagram of another method for processing 5G cell service rate provided in this application;

[0039] Figure 3 A schematic diagram of another method for processing 5G cell service rate provided in this application;

[0040] Figure 4 A schematic diagram of the structure of a Hive data warehouse platform provided for this application;

[0041] Figure 5 A schematic diagram of the structure of another server provided in this application. DETAILED DESCRIPTION

[0042] To make the purpose, technical solutions, and advantages of the embodiments of the present application more clear, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments made by ordinary technicians in this field based on the inspiration of these embodiments fall within the scope of protection of this application.

[0043] The terms "first", "second", "third", "fourth", etc. (if any) in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequential order. It should be understood that the numbers used in this way are interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0044] With the advent of the 5G era, 5G networks have gradually entered people's daily lives thanks to their fast Internet access capabilities. People use 5G networks to live, work and study. However, when 5G network equipment fails, that is, the 5G cell is out of service, it will affect people's daily life, work and study. This has made technicians in this field pay special attention to the analysis of the 5G cell service rate.

[0045] In the existing technology, the analysis of 5G cell service rates, especially the analysis of the national 5G cell service rates, is all manually performed by relevant technical personnel. That is, the technical personnel first use the provincial level as the basis for analysis, find the corresponding alarm data in the provincial network management alarm system according to the alarm indicators, and then use Excel to analyze the alarm data to calculate the provincial 5G cell service rate. Similarly, the service rates of 5G cells in each province can be obtained, and then the sum of the 5G cell service rates in each province is calculated to obtain the national 5G cell service rate.

[0046] However, due to the different labeling of provincial alarm indicators in the existing technology, there are certain differences in the alarm data of each province, and the 5G cell service rate obtained is not accurate enough; secondly, relying on manual acquisition of the 5G cell service rate is affected by the experience of technicians, so that the accuracy of the 5G cell service rate obtained by analysis is not high, and the efficiency of manual processing by technicians is not high.

[0047] Based on the above technical problems, the inventive concept of this application is: how to realize a method for processing the 5G cell service rate that is automated, highly efficient, highly accurate and has consistent analysis standards.

[0048] The technical solution of the present application is described in detail below through specific embodiments. It should be noted that the following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments.

[0049] Figure 1 A schematic diagram of a 5G cell service rate processing method provided in this application is shown as follows: Figure 1 As shown, the method includes:

[0050] Step 101: The Hive data warehouse platform obtains the alarm data and the 5G cell resource table from the network management alarm system, and stores the alarm data and the 5G cell resource table in the ODS layer of the Hive data warehouse platform.

[0051] It should be noted that the processing method of the 5G cell service rate provided in this application can analyze the 5G cell service rate according to a certain period, and the period can be set according to dimensions such as days, months and years. Secondly, according to the processing method provided in this application, not only the national 5G cell service rate can be analyzed, but also the 5G cell service rate at the provincial, municipal and county levels. For the convenience of explanation, this application takes the national 5G cell service rate as an example, but does not rule out that this application can be used for analysis of the provincial 5G cell service rate, as well as analysis and processing of relevant parameters of the 4G network.

[0052] In this embodiment, the Hive data warehouse platform is a widely used data warehouse for big data platforms. Compared to traditional relational databases, Hive can process data at scales exceeding petabytes, making it suitable for batch computing on large data volumes, such as massive data migration, filtering, cleaning, and mining. Furthermore, Hive provides a SQL-like data query language, enabling the construction of data analysis models tailored to different business scenarios.

[0053] It can be understood that the SQL data query language in the Hive data warehouse contains not only relevant statements for calculating the 5G cell service rate, but also relevant statements used to analyze other indicators of 5G network equipment, such as utilization.

[0054] It's also worth noting that each provincial-level network management system includes a network management alarm system, which collects detailed information about network equipment failures so that technical personnel can take appropriate action based on this data, ensuring the network remains stable. The alarm data in the network management alarm system includes: alarm ID, cell ID, cell unique identifier, base station ID, base station unique identifier, alarm occurrence time, alarm clearing time, alarm status, device type, alarm title, alarm target type, and alarm target identifier.

[0055] In this embodiment, the Hive data warehouse can collect alarm data from each provincial network management alarm system in real time or according to a preset cycle, and classify the collected alarm data into two categories according to the alarm status: cleared alarm status and uncleared alarm status. The alarm data corresponding to the cleared alarm status is stored in the cleared alarm table created by the ODS layer aggregated by the Hive data warehouse platform, and the corresponding data corresponding to the uncleared alarm status is stored in the active alarm table created by the ODS layer. Alarm data is classified and processed according to the alarm status so that relevant data can be directly found based on the alarm status, thereby improving the efficiency of alarm data search.

[0056] Furthermore, to calculate the national 5G cell service rate, it is necessary to obtain the 5G cells corresponding to the relevant alarm data. Therefore, the Hive data warehouse platform collects data from the 5G cell resource table according to a preset collection cycle or in real time. The data in the 5G cell resource table includes information such as base station ID, cell ID, base station unique identifier, cell unique identifier, base station status, and the province, city, district, and county name where the base station is located. Similarly, the Hive data warehouse platform stores the collected 5G cell resource table in the 5G cell resource table created by the ODS layer.

[0057] Among them, the above-mentioned base station unique identifier and cell unique identifier specifically refer to: being used to distinguish from base stations that have the same base station ID value or cell ID value and are located in other provinces, cities and counties.

[0058] In order to facilitate subsequent analysis and processing, the alarm data stored in the ODS layer needs to be cleaned and the time format of the data needs to be unified into the form of "year-month-day, hour: minute: second" so that the time calculation of the alarm data can be performed.

[0059] Based on this, the ODS layer of the Hive data warehouse platform can be regarded as the original data layer, so as to facilitate the configuration of the next layer MID.

[0060] Step 102: The Hive data warehouse platform obtains the alarm data that meets the pre-configured 5G cell deservice judgment strategy or the pre-configured 5G base station disconnection judgment strategy, and stores the alarm data that meets the pre-configured 5G cell deservice judgment strategy or the pre-configured 5G base station disconnection judgment strategy in the cell deservice intermediate table or the base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform.

[0061] In this embodiment, it is considered that the 5G cell out-of-service can be classified according to the following two situations, that is, the base station is good but the corresponding 5G cell fails, resulting in the 5G cell being out of service, or the base station is faulty, resulting in all the 5G cells under it being out of service.

[0062] To facilitate calculations, the Hive data warehouse platform needs to calculate the data corresponding to the two aforementioned 5G cell decommissioning situations. Optionally, the Hive data warehouse platform pre-stores a pre-configured 5G cell decommissioning judgment strategy or a pre-configured 5G base station disconnection strategy. These two judgment strategies are cell decommissioning or base station disconnection strategies customized by technical personnel based on the alarm issues provided by equipment manufacturers at various provincial levels. Based on this, the Hive data warehouse platform searches for data that meets the pre-configured 5G cell decommissioning judgment strategy in the active alarm table and cleared alarm table of the ODS layer based on the alarm object type and alarm title, and stores the found data in the cell decommissioning intermediate table created by the MID layer in the Hive data warehouse platform. At the same time, the Hive data warehouse platform also needs to search for alarm data that meets the pre-configured 5G base station disconnection strategy in the active alarm table and cleared alarm table, and similarly store this data that meets the base station disconnection judgment strategy in the base station disconnection intermediate table created by the MID layer.

[0063] Among them, the cell out-of-service intermediate table mainly includes: alarm unique identifier, alarm status, alarm occurrence time, alarm clearing time, alarm duration (minutes), alarm object type, alarm title, alarm manufacturer, alarm object identifier, cell ID, cell unique identifier, whether it is a station outage equivalent calculation, whether the alarm occurred in the early morning and was restored, and other information, and the field value of whether it is a station outage equivalent calculation is "no"; the base station outage intermediate table mainly includes: alarm ID, alarm status, alarm occurrence time, alarm clearing time, base station ID, base station unique identifier, whether the alarm occurred in the early morning and was restored, and other information.

[0064] In this way, the cases where the 5G cell is out of service due to a fault problem and the cases where the cell covered by the base station is out of service due to a base station outage are distinguished. This makes the consideration of the 5G cell out of service more comprehensive, thereby improving the accuracy of the 5G cell service rate.

[0065] Step 103: The Hive data warehouse platform analyzes and obtains the 5G base station disconnection conversion cell intermediate table based on the base station disconnection intermediate table in the MID layer and the 5G cell resource table in the ODS layer; and integrates the base station disconnection intermediate table and the 5G base station disconnection conversion cell intermediate table and stores them in the 5G cell decommissioning broadband table created by the DWD layer of the Hive data warehouse platform.

[0066] In this embodiment, the Hive data warehouse platform performs cell decommissioning conversion processing on the base station disconnection intermediate table obtained in the above steps.

[0067] Optionally, the Hive data warehouse platform first determines the associated cell information in the base station disconnection intermediate table of the MID layer for subsequent processing. Specifically, the base station ID and base station unique identifier in the base station disconnection intermediate table can be associated with the base station ID and base station unique identifier in the 5G cell resource table of the ODS layer to obtain the associated cell ID and cell unique identifier information, and then obtain the 5G base station disconnection conversion cell intermediate table. Among them, the 5G base station disconnection conversion cell intermediate table mainly includes: alarm ID, alarm status, alarm occurrence time, alarm clearing time, base station name, base station ID, base station unique identifier, cell ID, cell unique identifier, cell name, equipment type, alarm object type, alarm object identifier, whether it is a disconnection equivalent calculation, etc., and the field value of whether it is a disconnection equivalent calculation is "yes".

[0068] The obtained 5G base station outage conversion cell intermediate table is then stored in the MID layer of the Hive data warehouse platform. Simultaneously, the 5G base station outage conversion cell intermediate table and the cell decommissioning intermediate table are combined based on the "whether it is a station outage equivalent calculation" field to obtain the 5G cell decommissioning broadband table. This 5G cell decommissioning broadband table is then stored in the DWD layer of the Hive data warehouse platform to facilitate subsequent calculation of the 5G cell service rate.

[0069] Among them, the 5G cell service withdrawal table mainly includes: cell ID, cell unique identifier, base station ID, base station unique identifier, alarm ID, alarm title, alarm occurrence time, alarm clearing time and other information.

[0070] Step 104: The Hive data warehouse platform integrates and processes the data in the 5G cell deservice broadband table in the DWD layer, and stores the integrated data in the 5G cell deservice index summary table created in the ADS layer of the Hive data warehouse platform. According to the 5G cell deservice index summary table and the preset assessment interval, the 5G cell service rate is obtained.

[0071] In this embodiment, the Hive data warehouse platform integrates and processes the data in the 5G cell deservice broadband table in the DWD layer, that is, based on the alarm occurrence time and alarm clearing time in the 5G cell deservice broadband table, it calculates the total number of 5G cells in the deservice state, and the deservice duration corresponding to each cell ID and cell unique identifier, as well as the cell ID and cell unique identifier corresponding to the alarm accumulated for more than 60s, and stores the integrated data in the 5G cell deservice indicator summary table created in the ADS layer of the Hive data warehouse platform, so that corresponding processing can be performed later according to business needs.

[0072] The Hive data warehouse platform has pre-set assessment intervals and cycles, which are used to assess 5G cell decommissioning. The assessment period is set from 6:00 AM to 12:00 AM, considering that resource cutovers and equipment repairs may occur between 12:00 AM and 6:00 AM. The assessment cycle can be set by day, week, month, or year.

[0073] Then, the Hive data warehouse platform obtains the alarm data related to the assessment period at the ADS layer according to the corresponding assessment period, and calculates the service rate of the 5G cell based on the number of 5G cells in the out-of-service state within the preset assessment time, the out-of-service duration of the 5G cells in the out-of-service state, and the assessment duration within the assessment interval.

[0074] In this embodiment, a method for processing the service rate of a 5G cell is provided, wherein the alarm data in the network management alarm system and the 5G cell resource table are obtained through the Hive data warehouse platform, and the alarm data and the 5G cell resource table are stored in the ODS layer of the Hive data warehouse platform; the Hive data warehouse platform obtains the alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or the pre-configured 5G base station disconnection judgment strategy, and stores the alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or the pre-configured 5G base station disconnection judgment strategy in the cell decommissioning intermediate table created by the MID layer in the Hive data warehouse platform, or the base station disconnection intermediate table; Hi The Hive data warehouse platform analyzes and obtains the intermediate table of 5G base station disconnection conversion cells based on the base station disconnection intermediate table in the MID layer and the 5G cell resource table in the ODS layer; and integrates the intermediate table of base station disconnection and the intermediate table of 5G base station disconnection conversion cells and stores them in the 5G cell decommissioning broadband table created by the DWD layer of the Hive data warehouse platform; the Hive data warehouse platform integrates and processes the data in the 5G cell decommissioning broadband table in the DWD layer, and stores the integrated and processed data in the 5G cell decommissioning index summary table created by the ADS layer of the Hive data warehouse platform, and obtains the 5G cell service rate based on the 5G cell decommissioning index summary table and the preset assessment interval. Compared with the existing technology, the method provided by this application uses a unified standard to automatically filter out alarm data from each provincial level, and then uniformly calculates the 5G cell service rate and other business indicators, which can improve both accuracy and processing efficiency.

[0075] Figure 2 This is a schematic diagram of another method for processing the 5G cell service rate provided by this application. Based on the above embodiment, Figure 2 As shown, this embodiment specifically illustrates the specific processing steps of step 102, which include:

[0076] Step 201: The Hive data warehouse platform determines whether the manufacturer information, alarm object type, and alarm title in the alarm data meet the pre-configured 5G cell decommissioning judgment strategy. If so, execute step 202; if not, execute step 205.

[0077] Step 202: Store the satisfied alarm data in the cell decommissioning intermediate table created by the MID layer in the Hive data warehouse platform.

[0078] Specifically, the Hive data warehouse platform pre-stores a pre-configured 5G cell service withdrawal judgment strategy. The 5G cell service withdrawal judgment strategy may be composed of information such as manufacturer, alarm object type, and alarm title. Table 1 is a schematic table of the 5G cell service withdrawal judgment strategy provided by this application. As shown in Table 1, the manufacturer indicates the manufacturer of the equipment used in the 5G network; the alarm object type NRCellDU indicates the 5G cell alarm; the alarm title indicates various situations of cell service withdrawal.

[0079] Table 1

[0080] factory Alarm object type Alarm title Huawei NRCellDU NR cell unavailable Huawei NRCellDU NR distribution unit cell is unavailable ZTE NRCellDU DU community service withdrawal Tang Dynasty NRCellDU Community service withdrawal

[0081] More specifically, the Hive data warehouse platform compares the data in the active alarm table and the cleared alarm table in the ODS layer with the 5G cell deservice judgment strategy one by one, filters out the data that matches the 5G cell deservice judgment strategy, and stores these matching data in the cell deservice intermediate table created by the MID layer of the Hive data warehouse platform.

[0082] Step 203: The Hive data warehouse platform determines whether the manufacturer information, alarm object type, and alarm title in the alarm data meet the pre-configured 5G base station disconnection judgment strategy. If so, execute step 204; if not, execute step 205.

[0083] Step 204: Store the satisfied alarm data in the base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform.

[0084] Specifically, the Hive data warehouse platform has a pre-configured 5G base station disconnection judgment strategy. The 5G base station disconnection strategy can be composed of information such as manufacturer, alarm object type and alarm title. Table 2 is a schematic table of the 5G base station disconnection strategy provided by this application. As shown in Table 2, the manufacturer indicates the manufacturer of the equipment used in the 5G network; the alarm object type Gnodeb indicates the 5G base station; the alarm title indicates various situations in which the cell is out of service.

[0085] Table 2

[0086] factory Alarm object type Alarm title Huawei Gnodeb Network element connection interruption Huawei Gnodeb gNodeB decommissioning ZTE Gnodeb NE link disconnection Tang Dynasty Gnodeb NEA and network element disconnection Tang Dynasty Gnodeb Base station decommissioning

[0087] More specifically, the Hive data warehouse platform compares the data in the active alarm table and the cleared alarm table in the ODS layer with the 5G base station disconnection judgment strategy one by one, filters out the data that matches the 5G base station disconnection strategy, and stores these matching data in the base station disconnection intermediate table created by the MID layer of the Hive data warehouse platform.

[0088] Step 205: No processing is performed on the unsatisfied alarm data.

[0089] It should be noted that Table 1 and Table 2 in this embodiment are only examples, but are not limited to other alarm situations. Optionally, the pre-configured alarm titles in the pre-configured 5G cell decommissioning judgment strategy include one or more of the following combinations: NR cell unavailable alarm, NR distribution unit cell unavailable, DU cell decommissioning, service unavailable, cell decommissioning, and X2 link unavailable; and the pre-configured alarm titles in the pre-configured 5G base station disconnection judgment strategy include one or more of the following combinations: network element connection interruption, gNodeB decommissioning alarm, network element link disconnection, NEA and network element disconnection and base station decommissioning.

[0090] In this embodiment, it is specifically explained how the Hive data warehouse platform filters and processes alarm data based on the pre-configured 5G cell decommissioning judgment strategy and 5G base station disconnection strategy to obtain the 5G cell decommissioning intermediate table and the 5G base station disconnection intermediate table, so as to subsequently obtain the 5G cell service rate. This embodiment uses an automated method to classify and process alarm data, and at the same time filters out data related to 5G cell decommissioning, freeing technicians from the heavy data screening work, reducing their workload, and improving the processing efficiency of the 5G cell service rate. In addition, based on the formulation of the judgment measurement strategy, the standards of the alarm data can be unified, thereby improving the processing efficiency of the 5G cell service rate.

[0091] Figure 3 This is a schematic diagram of another method for processing the 5G cell service rate provided in this application. Based on the above embodiment, this embodiment specifically explains the specific processing process of the above step 104, such as Figure 3 As shown, the processing process is as follows:

[0092] Step 301: The Hive data warehouse platform calculates the total number of cell IDs in the 5G cell decommissioning broadband table according to the 5G cell decommissioning broadband table in the DWD layer, obtains the total number of 5G cells, and stores the total number of 5G cells in the 5G cell decommissioning indicator summary table created by the ADS layer of the Hive data warehouse platform.

[0093] Specifically, considering that the IDs of cells in different provinces may be the same, the cell unique identifiers are now distinguished. Therefore, the Hive data warehouse platform finds out 5G cells with inconsistent cell IDs and cell unique identifiers based on the cell IDs and cell unique identifiers in the 5G cell decommissioning broadband table in the DWD layer, and calculates the number of these cell IDs and cell unique identifiers to obtain the total number of 5G cells of the 5G decommissioning cells, and writes the total number of 5G cells into the 5G cell decommissioning indicator summary table created by the ADS layer.

[0094] Step 302: The Hive data warehouse platform obtains the first difference between the alarm clearing time and the alarm occurrence time of each cell ID in the 5G cell decommissioning broadband table in the DWD layer, and obtains the fault duration corresponding to each cell ID based on the first difference of each cell ID.

[0095] Specifically, the Hive data warehouse platform calculates the first difference between the alarm clearing time and the alarm occurrence time for each cell ID in the 5G cell decommissioning broadband table. Considering that the alarm occurrence time and the alarm clearing time may occur on alternate days, according to the aforementioned assessment period of 6:00-24:00 every day, the first difference can be calculated according to the following situations:

[0096] 1) If the alarm occurs and the recovery time occurs on the same day, and the alarm occurs between 0:00 and 6:00, and the recovery time is after 6:00, then the first difference is: recovery time - 6:00:00 on the same day;

[0097] 2) If the alarm occurrence time and recovery time occur on the same day, and the alarm occurrence time is after 6:00 and the recovery time is after 6:00, then the first difference is: recovery time - occurrence time;

[0098] 3) If the alarm occurs between 0:00 and 6:00 on the same day, and the alarm recovery time is between 0:00 and 6:00 the next day, the first difference is: 23:59:59 on the same day - 6:00:00 on the same day;

[0099] 4) If the alarm occurs between 0:00 and 6:00 on the same day, and the alarm recovery time is after 6:00 the next day, the first difference is: recovery time - 6:00:00 on the same day - 6 hours;

[0100] 5) If the alarm occurs after 6:00 on the same day and the alarm recovery time is between 0:00 and 6:00 the next day, the first difference is: 23:59:59 on the same day - the occurrence time;

[0101] 6) If the alarm occurs after 6:00 am on the same day and the alarm recovery time is after 6:00 am the next day, the first difference is: recovery time - occurrence time - 6 hours;

[0102] 7) If the alarm occurrence time and alarm recovery time are greater than or equal to 2 days, and the alarm occurs between 0:00 and 6:00 on the first day and the alarm recovery time occurs between 0:00 and 6:00 on the last day, then the first difference is: fault days * 18 * 60;

[0103] 8) If the alarm occurrence time and alarm recovery time are greater than or equal to 2 days, the alarm occurs between 0:00 and 6:00 on the first day, and the alarm recovery time occurs after 0:00 and 6:00 on the last day, then the first difference is: fault days * 18 * 60 + (recovery time - 6:00:00 on the last day);

[0104] 9) If the alarm occurrence time and alarm recovery time are greater than or equal to 2 days, the alarm occurs after 0:00-6:00 on the first day, and the alarm recovery time occurs after 0:00-6:00 on the last day, then the first difference is: (fault days - 1) * 18 * 60 + (23:59:59 on the first day - occurrence time);

[0105] 10) If the alarm occurrence time and alarm recovery time are greater than or equal to 2 days, the alarm occurs after 0-6:00 on the first day, and the alarm recovery time occurs after 0-6:00 on the last day, then the first difference is: (fault days - 1) * 18 * 60 + (recovery time - 6:00:00 on the last day) + (23:59:59 on the first day - occurrence time).

[0106] The number of days of failure is the date of recovery time minus the date of occurrence time, and the first difference is the duration of the failure when each cell ID is out of service.

[0107] Step 303: Obtain the sum of the fault duration corresponding to each cell ID respectively, and obtain the 5G cell fault deservice duration corresponding to the cell ID in the preset assessment interval based on the sum of the fault duration corresponding to each cell ID, so as to store the 5G cell fault deservice duration in the 5G cell deservice indicator summary table created by the ADS layer of the Hive data warehouse platform.

[0108] Specifically, by accumulating the first difference corresponding to each cell ID, the 5G cell fault deservice duration in the preset assessment interval can be obtained, thereby obtaining the relevant indicator of the 5G cell service rate, and storing the indicator in the 5G cell deservice indicator summary table created by the ADS layer of the Hive data warehouse platform for subsequent processing in steps 304 and 305.

[0109] Step 304: Calculate the product of the total number of 5G cells in the 5G cell decommissioning index summary table and the total number of minutes corresponding to the preset assessment interval to obtain the 5G cell assessment duration.

[0110] Step 305: Calculate the second time difference between the 5G cell assessment duration and the 5G cell fault de-service duration within the assessment interval, and calculate the ratio of the second time difference to the 5G cell assessment duration to obtain the 5G cell service rate.

[0111] Specifically, in order to obtain the 5G cell service rate during the assessment period, the Hive data warehouse platform also needs to calculate the 5G cell assessment duration corresponding to the pre-stored assessment interval, which can be calculated according to the following formula:

[0112] 5G cell assessment duration = 18 * 60 minutes * total number of 5G cells

[0113] In this way, the 5G cell assessment duration can be obtained.

[0114] Then, the Hive data warehouse platform needs to obtain the 5G cell service rate according to the following formula:

[0115] 5G cell service rate = (5G cell assessment duration - 5G cell fault outage duration) / 5G cell assessment duration * 100%

[0116] Furthermore, the Hive data warehouse platform obtains the 5G cell service rate.

[0117] In this embodiment, the specific processing process of how the Hive data warehouse platform obtains the 5G cell service rate is specifically explained. Compared with the existing technology, the situation of 5G cell out of service caused by base station disconnection is taken into consideration, and the 5G cell out of service situation can be analyzed more comprehensively. At the same time, the alarm data is hierarchically processed based on each level of the Hive data warehouse platform, which can improve the processing efficiency of the 5G cell service rate.

[0118] In an optional embodiment, the Hive data warehouse platform can also query the alarm status of 5G cells in various regions in real time and perform corresponding processing based on the alarm status. Specifically, a query request is obtained, which includes the cell identifier to be queried; based on the query request, the 5G cell decommissioning broadband table is queried to obtain the alarm data corresponding to the cell identifier to be queried, and the alarm data is analyzed and processed to obtain the fault cause data.

[0119] Specifically, technicians can query the alarm status of 5G cells in various places in real time through the Hive data warehouse platform. Optionally, technicians can enter the 5G cell identifier to be queried through the Hive data warehouse platform to query the alarm status of the 5G cell identifier.

[0120] Correspondingly, after the Hive data warehouse platform obtains the 5G cell identifier, it can query the 5G cell identifier in the 5G cell decommissioning broadband table in the ADS layer to obtain information such as the alarm title, alarm occurrence time, and alarm clearing time corresponding to the 5G cell identifier. Based on this information, it can be checked whether the alarm has been processed, or if the alarm has not been cleared, corresponding processing measures can be taken according to the alarm title to ensure that the 5G cell corresponding to the 5G cell identifier remains in service.

[0121] In this embodiment, the flexibility of the Hive data warehouse platform operation is specifically explained, and corresponding processing can be performed according to different business needs, making the Hive data warehouse platform more flexible and more convenient for processing business.

[0122] Figure 4 A schematic diagram of the structure of a Hive data warehouse platform provided for this application is shown in FIG. Figure 4 As shown, the platform 40 includes: a configuration module 41 and a processing module 42.

[0123] Among them, the configuration module 41 is used to obtain the alarm data in the network management alarm system and the 5G cell resource table, and store the alarm data and the 5G cell resource table in the ODS layer of the Hive data warehouse platform; the configuration module 41 is also used to obtain the alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or the pre-configured 5G base station disconnection judgment strategy, and store the alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or the pre-configured 5G base station disconnection judgment strategy in the cell decommissioning intermediate table created by the MID layer in the Hive data warehouse platform, or the base station disconnection intermediate table; the configuration module 41 is also used to According to the base station disconnection intermediate table in the MID layer and the 5G cell resource table in the ODS layer, the 5G base station disconnection conversion cell intermediate table is analyzed and obtained; and the base station disconnection intermediate table and the 5G base station disconnection conversion cell intermediate table are integrated and stored in the 5G cell decommissioning broadband table created by the DWD layer of the Hive data warehouse platform; the processing module 42 is used to perform data integration processing on the 5G cell decommissioning broadband table in the DWD layer, obtain the 5G cell decommissioning index summary table, and store it in the ADS layer of the Hive data warehouse platform, and obtain the 5G cell service rate according to the 5G cell decommissioning index summary table and the preset assessment interval.

[0124] Optionally, the configuration module 41 is specifically configured to:

[0125] Determine whether the manufacturer information, alarm object type, and alarm title in the alarm data meet the pre-configured 5G cell decommissioning judgment policy. If so, store the satisfied alarm data in the cell decommissioning intermediate table created by the MID layer in the Hive data warehouse platform.

[0126] Determine whether the manufacturer information, alarm object type, and alarm title in the alarm data meet the pre-configured 5G base station disconnection judgment strategy. If so, store the satisfied alarm data in the base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform.

[0127] Optionally, the pre-configured alarm titles in the pre-configured 5G cell decommissioning judgment strategy include one or more of the following: NR cell unavailable alarm, NR distribution unit cell unavailable alarm, DU cell decommissioning, service unavailable, cell decommissioning, and X2 link unavailable.

[0128] Optionally, the preconfigured alarm titles in the preconfigured 5G base station disconnection judgment strategy include one or more of the following: network element connection interruption, gNodeB decommissioning alarm, network element link disconnection, NEA and network element disconnection and base station decommissioning.

[0129] Optionally, the processing module 42 is further configured to:

[0130] According to the 5G cell decommissioning broadband table in the DWD layer, calculate the total number of cell IDs in the table to obtain the total number of 5G cells. This total number of 5G cells is stored in the 5G cell decommissioning indicator summary table created in the ADS layer of the Hive data warehouse platform.

[0131] According to each cell ID in the 5G cell decommissioning broadband table in the DWD layer, obtain the first difference between the alarm clearing time and the alarm occurrence time of each cell ID, and obtain the fault duration corresponding to each cell ID according to the first difference of each cell ID;

[0132] The sum of the fault duration corresponding to each cell ID is obtained respectively, and based on the sum of the fault duration corresponding to each cell ID, the 5G cell fault deservice duration corresponding to the cell ID in the preset assessment interval is obtained, so as to store the 5G cell fault deservice duration in the 5G cell deservice indicator summary table created by the ADS layer of the Hive data warehouse platform.

[0133] Optionally, the processing module 42 is further configured to:

[0134] Calculate the product of the total number of 5G cells in the 5G cell decommissioning index summary table and the total number of minutes corresponding to the preset assessment interval to obtain the 5G cell assessment duration;

[0135] Calculate the second time difference between the 5G cell assessment duration and the 5G cell fault de-service duration within the assessment interval, and calculate the ratio of the second time difference to the 5G cell assessment duration to obtain the 5G cell service rate.

[0136] Optionally, the processing module 42 is further configured to:

[0137] Obtaining a query request, where the query request includes an identifier of a cell to be queried;

[0138] According to the query request, the 5G cell decommissioning broadband table is queried to obtain the alarm data corresponding to the cell identifier to be queried, and the alarm data is analyzed and processed to obtain the fault cause data.

[0139] The Hive data warehouse platform provided in the embodiment of the present application can execute the technical solution shown in the above method implementation. Its implementation principles and beneficial effects are similar and will not be repeated here.

[0140] This embodiment provides a Hive data warehouse platform, which includes a configuration module for obtaining alarm data in the network management alarm system and a 5G cell resource table, and storing the alarm data and the 5G cell resource table in the ODS layer of the Hive data warehouse platform; the configuration module is also used to obtain alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or the pre-configured 5G base station disconnection judgment strategy, and store the alarm data that meets the pre-configured 5G cell decommissioning judgment strategy or the pre-configured 5G base station disconnection judgment strategy in the cell decommissioning intermediate table created by the MID layer in the Hive data warehouse platform, or the base station disconnection intermediate table. In the table; the configuration module is also used to analyze and obtain the 5G base station disconnection conversion cell intermediate table based on the base station disconnection intermediate table in the MID layer and the 5G cell resource table in the ODS layer; and integrate the base station disconnection intermediate table and the 5G base station disconnection conversion cell intermediate table and store them in the 5G cell decommissioning broadband table created by the DWD layer of the Hive data warehouse platform; the processing module performs data integration processing on the 5G cell decommissioning broadband table in the DWD layer, obtains the 5G cell decommissioning index summary table, and stores it in the ADS layer of the Hive data warehouse platform, and obtains the 5G cell service rate based on the 5G cell decommissioning index summary table and the preset assessment interval. Compared with the existing technology, the method provided by this application uses a unified standard to automatically filter out alarm data from each provincial level, and then uniformly calculates the 5G cell service rate and other business indicators, which can improve both accuracy and processing efficiency.

[0141] Figure 5 This is a schematic diagram of the structure of a server provided by this application. Figure 5 As shown, the server 70 includes: a processor 71, a memory 72, and a communication interface 73; wherein the memory 72 is used to store executable computer-executable instructions of the processor 71; the processor 71 is configured to execute the technical solution in any of the aforementioned method embodiments by executing the executable computer-executable instructions.

[0142] Optionally, the memory 72 can be independent or integrated with the processor 71.

[0143] Optionally, when the memory 72 is a device independent of the processor 71 , the server 70 may further include: a bus for connecting the above devices.

[0144] The server is used to execute the technical solution in any of the aforementioned method embodiments, and its implementation principles and technical effects are similar and will not be repeated here.

[0145] An embodiment of the present application also provides a computer-readable storage medium, which stores computer-executable instructions. When a processor executes the computer-executable instructions, the method mentioned in any of the previous embodiments is implemented.

[0146] An embodiment of the present application also provides a computer program product, including a computer program, which, when executed by a processor, is used to implement the technical solution provided by any of the aforementioned method embodiments.

[0147] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present application.

Claims

1. A method for processing 5G cell service rate, characterized in that: include: The Hive data warehouse platform obtains the alarm data and the 5G cell resource table from the network management alarm system, and stores the alarm data and the 5G cell resource table in the ODS layer of the Hive data warehouse platform; The Hive data warehouse platform obtains alarm data that meets the pre-configured 5G cell deservice judgment policy or the pre-configured 5G base station disconnection judgment policy, and stores the alarm data that meets the pre-configured 5G cell deservice judgment policy or the pre-configured 5G base station disconnection judgment policy in the cell deservice intermediate table or the base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform; The Hive data warehouse platform analyzes and obtains the 5G base station disconnection conversion cell intermediate table based on the base station disconnection intermediate table in the MID layer and the 5G cell resource table in the ODS layer; The base station disconnection intermediate table and the 5G base station disconnection conversion cell intermediate table are integrated and stored in the 5G cell decommissioning broadband table created by the DWD layer of the Hive data warehouse platform; The Hive data warehouse platform integrates and processes the data in the 5G cell deservice broadband table in the DWD layer, and stores the integrated data in the 5G cell deservice index summary table created in the ADS layer of the Hive data warehouse platform. According to the 5G cell deservice index summary table and a preset assessment interval, the 5G cell service rate is obtained.

2. The method according to claim 1, characterized in that The Hive data warehouse platform obtains alarm data that meets the preconfigured 5G cell deservice judgment policy or the preconfigured 5G base station disconnection judgment policy, and stores the alarm data that meets the preconfigured 5G cell deservice judgment policy or the preconfigured 5G base station disconnection judgment policy in the cell deservice intermediate table or the base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform, including: The Hive data warehouse platform determines whether the manufacturer information, alarm object type, and alarm title in the alarm data meet the pre-configured 5G cell decommissioning judgment policy. If so, the satisfied alarm data is stored in the cell decommissioning intermediate table created by the MID layer in the Hive data warehouse platform; The Hive data warehouse platform determines whether the manufacturer information, alarm object type and alarm title in the alarm data meet the pre-configured 5G base station disconnection judgment strategy. If so, the satisfied alarm data is stored in the base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform.

3. The method according to claim 2, characterized in that The preconfigured alarm titles in the preconfigured 5G cell decommissioning judgment strategy include one or more of the following: NR cell unavailable alarm, NR distribution unit cell unavailable, DU cell decommissioning, service unavailable, cell decommissioning, and X2 link unavailable.

4. The method according to claim 2, characterized in that The preconfigured alarm titles in the preconfigured 5G base station disconnection judgment strategy include one or more of the following: network element connection interruption, gNodeB decommissioning, network element link disconnection, NEA and network element disconnection and base station decommissioning.

5. The method according to claim 1, wherein The Hive data warehouse platform integrates and processes the data in the 5G cell out-of-service broadband table in the DWD layer, and stores the integrated data in the 5G cell out-of-service indicator summary table created in the ADS layer of the Hive data warehouse platform. According to the 5G cell out-of-service indicator summary table and a preset assessment interval, the 5G cell service rate is obtained, including: The Hive data warehouse platform calculates the total number of cell IDs in the 5G cell decommissioning broadband table according to the 5G cell decommissioning broadband table in the DWD layer, obtains the total number of 5G cells, and stores the total number of 5G cells in the 5G cell decommissioning indicator summary table created in the ADS layer of the Hive data warehouse platform; The Hive data warehouse platform obtains, based on each cell ID in the 5G cell decommissioning broadband table in the DWD layer, a first difference between the alarm clearing time and the alarm occurrence time of each cell ID, and obtains, based on the first difference of each cell ID, a fault duration corresponding to each cell ID; The sum of the fault duration corresponding to each cell ID is obtained respectively, and based on the sum of the fault duration corresponding to each cell ID, the 5G cell fault deservice duration corresponding to the cell ID in the preset assessment interval is obtained, so as to store the 5G cell fault deservice duration in the 5G cell deservice indicator summary table created by the ADS layer of the Hive data warehouse platform.

6. The method according to claim 5, characterized in that The obtaining of the 5G cell service rate according to the 5G cell out-of-service indicator summary table and the preset assessment interval includes: Calculate the product of the number of all 5G cells in the 5G cell decommissioning index summary table and the total number of minutes corresponding to the preset assessment interval to obtain the 5G cell assessment duration; Calculate the second time difference between the 5G cell assessment duration and the 5G cell fault deservice duration within the assessment interval, and calculate the ratio of the second time difference to the 5G cell assessment duration to obtain the 5G cell service rate.

7. The method according to any one of claims 1 to 6, characterized in that: Also includes: Obtaining a query request, where the query request includes an identifier of a cell to be queried; According to the query request, the 5G cell decommissioning broadband table is queried to obtain the alarm data corresponding to the cell identifier to be queried, and the alarm data is analyzed and processed to obtain the fault cause data.

8. A Hive data warehouse platform, characterized in that: include A configuration module is used to obtain alarm data and a 5G cell resource table from a network management alarm system, and store the alarm data and the 5G cell resource table in the ODS layer of the Hive data warehouse platform; The configuration module is further configured to obtain alarm data that satisfies a preconfigured 5G cell deservice judgment policy or a preconfigured 5G base station disconnection judgment policy, and store the alarm data that satisfies the preconfigured 5G cell deservice judgment policy or the preconfigured 5G base station disconnection judgment policy in a cell deservice intermediate table or a base station disconnection intermediate table created by the MID layer in the Hive data warehouse platform; The configuration module is further configured to analyze and obtain a 5G base station disconnection conversion cell intermediate table based on the base station disconnection intermediate table in the MID layer and the 5G cell resource table in the ODS layer; The base station disconnection intermediate table and the 5G base station disconnection conversion cell intermediate table are integrated and stored in the 5G cell decommissioning broadband table created by the DWD layer of the Hive data warehouse platform; The processing module is used to perform data integration processing on the 5G cell decommissioning broadband table in the DWD layer, obtain a 5G cell decommissioning indicator summary table, and store it in the ADS layer of the Hive data warehouse platform; and obtain the 5G cell service rate according to the 5G cell decommissioning indicator summary table and a preset assessment interval.

9. A server, characterized in that: The server includes: a processor, and a memory communicatively connected to the processor; The memory stores computer-executable instructions; The processor executes the computer-executable instructions stored in the memory to implement the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that The computer-readable storage medium stores computer-executable instructions, and when a processor executes the computer-executable instructions, the method according to any one of claims 1 to 7 is implemented.

Images