5G communication signal testing system and method based on data analysis

Abstract

The present invention relates to the field of 5G communication signal testing technology, and discloses a 5G communication signal testing system and method based on data analysis, including a control module, a user management module, a test plan module, a signal acquisition module, a data storage module, a data processing module, a test result module, a report generation module, a device management module, a log management module, an announcement management module and a data analysis module. The system obtains information about testers and test equipment, supports fully automated formulation, execution and monitoring of test plans, configures signal acquisition parameters, analyzes the pass rate and average test time of different test plans, the signal transmission rate and signal strength fluctuation value of different devices, the signal coverage ratio and pass rate of different test plans, manages test results, securely stores and records logs, flexibly configures and has strong scalability, customizes the format of test result reports, manages announcement information, and provides a data overview, with efficient testing and strong traceability.

Description

Technical Field

[0001] The present invention relates to the technical field of 5G communication signal testing, and specifically to a 5G communication signal testing system and method based on data analysis. Background Art

[0002] The data-analysis-based 5G communication signal test system is a comprehensive tool designed specifically for 5G network testing and optimization. It integrates multifunctional modules such as signal acquisition, data storage, processing and analysis, and result presentation, providing users with a comprehensive testing solution. Through the collaborative work of these multifunctional modules, a one-stop solution is provided, covering signal acquisition, data storage, processing and analysis, and result presentation. The primary purpose of the 5G communication signal test system is to provide users with comprehensive data support and decision-making basis, significantly improving the efficiency and accuracy of 5G communication signal testing. Users can use the system to manage test plans and test equipment, flexibly configure acquisition parameters to ensure data accuracy, and extract useful information through a variety of data processing methods. The system supports customized and automated report generation, making it easy for users to view and analyze test results. Through this system, users can gain a more comprehensive and accurate understanding of the operation of 5G networks, providing a scientific basis for network optimization.

[0003] At present, when traditional 5G communication signal test systems deal with different test scenarios, they need to make multiple judgments based on human experience to determine whether the test configuration needs to be adjusted. The test efficiency is low, and the traditional test system lacks in-depth analysis capabilities. It can no longer meet the comprehensive testing requirements for high-speed, large capacity, low latency and other characteristics, and the test accuracy is low. Summary of the Invention

[0004] (1) Technical problems solved

[0005] In response to the shortcomings of the existing technology, the present invention provides a 5G communication signal testing system and method based on data analysis, which has the advantages of flexible configuration, strong scalability, efficient testing and strong traceability, and solves the problems of low testing efficiency and lack of in-depth analysis capabilities of traditional 5G communication signal testing systems.

[0006] (2) Technical solution

[0007] To achieve the above-mentioned object, the present invention provides the following technical solution: a 5G communication signal testing system based on data analysis, comprising a control module, a user management module, a test plan module, a signal acquisition module, a data storage module, a data processing module, a test result module, a report generation module, a device management module, a log management module, an announcement management module and a data analysis module;

[0008] The control module is used to provide platform overview and data analysis results;

[0009] The user management module is used to manage personal information and account settings;

[0010] The test plan module is used to formulate, execute and monitor test plans and form a plan data set;

[0011] The signal acquisition module is used to configure the signal acquisition parameters of the test equipment and form a signal data set;

[0012] The data storage module is used to manage the storage and security of test data and to form a storage data set;

[0013] The data processing module is used to process and analyze the collected signal data and form a processing data set;

[0014] The test result module is used to manage the test results generated during the test process and form a result data set;

[0015] The report generation module is used to customize the format and style of the test result report;

[0016] The device management module is used to uniformly manage various types of test equipment and form a device data set;

[0017] The log management module is used to record key information and events during system operation and form a log data set;

[0018] The announcement management module is used to manage announcement information in the system;

[0019] The data analysis module is used to analyze the pass rate Tgl and average test time Pcs of all test plans, the signal transmission rate C and signal strength Q of each device, the signal coverage ratio Fgb and pass rate Hgl of all test plans. The data analysis module is set with a fixed value time threshold PCY, rate threshold CY, and strength threshold QY, which are used to evaluate the execution progress of the test plan and the signal transmission status of the device, and generate corresponding early warning signals.

[0020] Preferably, the personal information includes user ID, user name, user avatar, mobile phone number, registration date, user status and system role, wherein the user status includes normal, disabled and frozen, and the system role includes general user, information reviewer and super administrator.

[0021] Preferably, the plan data set includes a test plan name, a test plan description, a test start date, a test end date, a test person in charge, a test priority, a test environment and a test tool, wherein the test priority includes low, medium and high, the test environment includes a laboratory environment, an outdoor urban area and an indoor experimental scene, and the test tools include a signal analyzer, a spectrum analyzer, a signal source generator, a power analyzer, a transmission rate tester, a multi-user access tester, a security tester, a signal coverage tester and a power distribution tester.

[0022] Preferably, the signal data set includes frequency, bandwidth, signal power, noise power, sampling rate, type, wireless configuration, device ID and acquisition time, and the stored data set includes data name, data description, data creation date, data type, data label, data owner and access rights, wherein the data type includes real-time data and historical data, the data labels include indoor, outdoor, low frequency and high frequency, and the access rights include private, public and partially shared.

[0023] Preferably, the processing data set includes processing name, processing description, processing creation date, data source type, processing method, enabled status and output format, wherein the data source type includes real-time data and batch data, the processing method includes automatic processing and manual processing, the output format includes CSV, JSON, XML, reports and charts, the result data set includes test name, test description, test date, tester, signal quality, transmission rate and delay, wherein signal quality includes poor, average, good and excellent, the test result report includes report title, author name, generation date, report description, report format and chart type, wherein the report format includes PDF, Word and Excel, and the chart type includes line chart, bar chart and pie chart.

[0024] Preferably, the device data set includes device name, device model, manufacturer, purchase date, device status, maintenance cycle and device location, wherein the device status includes normal and faulty, and the maintenance cycle includes 1 month, 3 months and 6 months. The log data set includes log title, log content, recording time, log level, recorder, module name and operation type, wherein the log level includes serious and general, and the operation type includes signal test, system upgrade and fault reporting. The announcement information includes announcement title, announcement text, announcement creation time, registration date and announcement status, wherein the announcement status includes unpublished and published.

[0025] Preferably, the calculation process of the pass rate Tgl and the average test time Pcs is as follows:

[0026] According to the plan data set, the total number of test plans N, the number of completed plans ys, the number of unfinished plans ns, and the test duration of all test plans {j1, j2, j3, ..., j N};

[0027]

[0028] In the formula, j1 to j N Indicates the test duration from the first test plan to the Nth test plan;

[0029] When the average test duration Pcs of the single test plan exceeds the duration threshold PCY, it indicates that there is a progress delay in the single test. While the test plan is displayed in red, a progress warning signal should be output in a timely manner to remind the test person in charge to follow up in a timely manner.

[0030] Preferably, the signal transmission rate C and signal strength Q calculation process are as follows:

[0031] According to the signal data set and the device data set, the signal acquisition parameters of the i-th device are extracted, and the bandwidth of the i-th device is marked as DK i , mark the signal power of the i-th device as XHL i , the noise power of the i-th device is marked as ZSL i ;

[0032]

[0033] In the formula, represents the average signal power of the i-th device, represents the average noise power of the i-th device, represents the signal-to-noise ratio of the i-th device, According to Shannon's theorem, the signal transmission rate C of the i-th device is calculated i ;

[0034]

[0035] In the formula, α1 represents the weight for signal power, α2 represents the weight for signal-to-noise ratio, α1 and α2 are both constants, and α1+α2=1. Indicates that the signal strength Q of the i-th device is calculated according to the weights α1 and α2 i ;

[0036] When the signal transmission rate C of the single device is lower than the rate threshold CY or the signal strength Q is lower than the strength threshold QY, it indicates that the signal transmission status of the single device is abnormal. While the device is marked in red, a device warning signal should be output in time to remind the test person in charge to check the device operation status in time.

[0037] Preferably, the calculation process of the signal coverage ratio Fgb and the pass rate Hgl is as follows:

[0038] According to the stored data set, the statistical data label is the number of indoor data SN, and the data label is the number of outdoor data SW;

[0039] Fgb=SN:SW

[0040] Based on the processed data set and the log data set, filter out all test plans that have completed data cleaning, data aggregation, data transformation, data analysis, data visualization, and logging, and mark the number of test plans that have completed data cleaning, data aggregation, data transformation, data analysis, data visualization, and logging as Z;

[0041] Based on the result dataset, the test plans with signal quality marked as good and excellent are divided into qualified tests, and the number of qualified tests is marked as hg;

[0042]

[0043] In the formula, The percentage of qualified tests to the number of test plans is the pass rate.

[0044] The 5G communication signal testing method based on data analysis includes the following steps:

[0045] Step 1: Obtain the personal information of all testers and all types of test equipment, and then formulate, execute and monitor the test plan;

[0046] Step 2: Configure the signal acquisition parameters of the test equipment, analyze the pass rate Tgl and average test time Pcs of different test plans, the signal transmission rate C and signal strength fluctuation value Qbd of different devices, the signal coverage ratio Fgb and pass rate Hgl of different test plans, manage the various test results generated during the test process, securely store and log them, evaluate the execution progress of the test plan and the signal transmission status of the device, and generate corresponding warning signals;

[0047] Step 3: Customize the format and style of the test result report, manage announcement information, and provide a data overview.

[0048] Compared with the prior art, the present invention provides a 5G communication signal testing system and method based on data analysis, which has the following beneficial effects:

[0049] 1. The present invention obtains the personal information of all testers and all types of test equipment through the user management module and the equipment management module, and then supports the fully automated formulation, execution and monitoring of test plans through the test plan module. The signal acquisition module configures the signal acquisition parameters of the test equipment. The data processing module and the data analysis module analyze the pass rate Tgl and average test time Pcs of different test plans, the signal transmission rate C and signal strength fluctuation value Qbd of different devices, the signal coverage range ratio Fgb and pass rate Hgl of different test plans. It can quickly adapt to different scenario requirements, reduce manual intervention, and improve test efficiency. The test result module manages the various test results generated during the test process, the data storage module stores them securely, and the log management module records the logs, evaluates the execution progress of the test plan and the signal transmission status of the equipment, and generates corresponding early warning signals. It can accurately locate equipment performance bottlenecks, guide maintenance and upgrades, and has flexible configuration and strong scalability.

[0050] 2. The present invention customizes the format and style of the test result report through the report generation module. The report formats include PDF, Word and Excel. The chart types include line charts, bar charts and pie charts. The test report is automatically generated to reduce the cost of manual sorting. The announcement management module manages the announcement information and provides a data overview through the control module. Real-time data and historical data are classified and stored. Private, public and partially shared access permission control is combined to ensure data security, record key events of system operation, provide operation tracing function, facilitate troubleshooting and responsibility identification, and have efficient testing with strong traceability. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] Figure 1 This is a flow chart of the system of the present invention;

[0052] Figure 2 It is a step diagram of the method of the present invention;

[0053] Figure 3 Schematic diagram of the system of the present invention. DETAILED DESCRIPTION

[0054] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0055] Because traditional 5G communication signal test systems need to make multiple judgments based on human experience to determine whether the test configuration needs to be adjusted when dealing with different test scenarios, the test efficiency is low. Traditional test systems lack in-depth analysis capabilities and can no longer meet the comprehensive testing requirements for high speed, large capacity, low latency and other characteristics. The test accuracy is low. Therefore, a 5G communication signal test system and method based on data analysis is provided. Please refer to Figure 1-Figure 3 , the 5G communication signal test system based on data analysis includes a control module, a user management module, a test plan module, a signal acquisition module, a data storage module, a data processing module, a test result module, a report generation module, a device management module, a log management module, an announcement management module and a data analysis module;

[0056] The control module provides a platform overview and data analysis results. Test plan management supports full process automation from formulation and execution to monitoring. By combining priority (low, medium, high) and environment classification (laboratory, outdoor, indoor), it can quickly adapt to different scenario requirements and reduce manual intervention.

[0057] The user management module is used to manage personal information and account settings. Personal information includes user ID, user name, user profile picture, mobile phone number, registration date, user status, and system role. User status includes normal, disabled, and frozen. System roles include general user, information reviewer, and super administrator.

[0058] The test plan module is used to develop, execute, and monitor test plans and form a plan data set. The plan data set includes the test plan name, test plan description, test start date, test end date, test person in charge, test priority, test environment, and test tools. Among them, the test priority includes low, medium, and high. The test environment includes laboratory environment, outdoor urban area, and indoor experimental scene. The test tools include signal analyzer, spectrum analyzer, signal source generator, power analyzer, transmission rate tester, multi-user access tester, security tester, signal coverage tester, and power distribution tester.

[0059] The signal acquisition module is used to configure the signal acquisition parameters of the test equipment and form a signal data set. The signal data set includes frequency, bandwidth, signal power, noise power, sampling rate, type, wireless configuration, device ID and acquisition time;

[0060] The data storage module is used to manage the storage and security of test data and form a storage data set. The storage data set includes data name, data description, data creation date, data type, data label, data owner, and access rights. Among them, data types include real-time data and historical data, data labels include indoor, outdoor, low frequency, and high frequency, and access rights include private, public, and partially shared.

[0061] The data processing module is used to process and analyze the collected signal data and form a processing data set. The processing data set includes the processing name, processing description, processing creation date, data source type, processing method, enabled status and output format. Among them, the data source type includes real-time data and batch data, the processing method includes automatic processing and manual processing, and the output format includes CSV, JSON, XML, reports and charts. The data processing module provides automatic and manual processing methods, supports efficient analysis of real-time data and batch data, and significantly improves the accuracy and timeliness of test results.

[0062] The test result module is used to manage the test results generated during the test process and form a result data set. The result data set includes the test name, test description, test date, tester, signal quality, transmission rate and delay. Among them, the signal quality includes poor, average, good and excellent.

[0063] The report generation module is used to customize the format and style of the test result report. The test result report includes the report title, author name, generation date, report description, report format and chart type. The report formats include PDF, Word and Excel, and the chart types include line charts, bar charts and pie charts. The test report is automatically generated to reduce manual compilation costs.

[0064] The equipment management module is used to centrally manage various types of test equipment and form equipment data sets. The equipment data sets include equipment name, equipment model, manufacturer, purchase date, equipment status, maintenance cycle, and equipment location. The equipment status includes normal and faulty, and the maintenance cycle includes 1 month, 3 months, and 6 months.

[0065] The log management module is used to record key information and events during system operation and form a log data set. The log data set includes log title, log content, recording time, log level, recorder, module name and operation type. The log level includes serious and general, and the operation type includes signal test, system upgrade and fault repair.

[0066] The announcement management module is used to manage the announcement information in the system. The announcement information includes the announcement title, announcement body, announcement creation time, registration date and announcement status. The announcement status includes unpublished and published;

[0067] The data analysis module is used to analyze the pass rate Tgl and average test time Pcs of all test plans, the signal transmission rate C and signal strength Q of each device, the signal coverage ratio Fgb and pass rate Hgl of all test plans. The data analysis module is set with fixed values ​​of time threshold PCY, rate threshold CY, and strength threshold QY, which are used to evaluate the execution progress of the test plan and the signal transmission status of the device, and generate corresponding early warning signals to provide a quantitative basis for optimizing the test strategy.

[0068] The 5G communication signal testing method based on data analysis includes the following steps:

[0069] Step 1: Obtain the personal information of all testers and all types of test equipment, and then formulate, execute and monitor the test plan;

[0070] Step 2: Configure the signal acquisition parameters of the test equipment, analyze the pass rate Tgl and average test time Pcs of different test plans, the signal transmission rate C and signal strength fluctuation value Qbd of different devices, the signal coverage ratio Fgb and pass rate Hgl of different test plans, manage the various test results generated during the test process, securely store and log them, evaluate the execution progress of the test plan and the signal transmission status of the device, and generate corresponding warning signals;

[0071] The calculation process of pass rate Tgl and average test time Pcs is as follows:

[0072] According to the plan data set, the total number of test plans N, the number of completed plans ys, the number of unfinished plans ns, and the test duration of all test plans {j1, j2, j3, ..., j N};

[0073]

[0074] In the formula, j1 to j N Indicates the test duration from the first test plan to the Nth test plan;

[0075] When the average test duration Pcs of a single test plan exceeds the duration threshold PCY, it indicates that there is a progress delay in the single test. While the test plan is displayed in red, a progress warning signal should be output in a timely manner to remind the test leader to follow up in time;

[0076] The calculation process of signal transmission rate C and signal strength Q is as follows:

[0077] According to the signal data set and the device data set, the signal acquisition parameters of the i-th device are extracted, and the bandwidth of the i-th device is marked as DK i , mark the signal power of the i-th device as XHL i, the noise power of the i-th device is marked as ZSL i ;

[0078]

[0079] In the formula, represents the average signal power of the i-th device, represents the average noise power of the i-th device, represents the signal-to-noise ratio of the i-th device, According to Shannon's theorem, the signal transmission rate C of the i-th device is calculated i ;

[0080]

[0081] In the formula, α1 represents the weight for signal power, α2 represents the weight for signal-to-noise ratio, α1 and α2 are both constants, and α1+α2=1. Indicates that the signal strength Q of the i-th device is calculated according to the weights α1 and α2 i ;

[0082] When the signal transmission rate C of a single device is lower than the rate threshold CY or the signal strength Q is lower than the strength threshold QY, it indicates that the signal transmission status of the single device is abnormal. While the device is displayed in red, a device warning signal should be output in time to remind the test person in charge to check the device operation status in time. This can accurately locate the performance bottleneck of the device, guide maintenance and upgrades, and has flexible configuration and strong scalability.

[0083] The calculation process of signal coverage ratio Fgb and pass rate Hgl is as follows:

[0084] According to the stored data set, the statistical data label is the number of indoor data SN, and the data label is the number of outdoor data SW;

[0085] Fgb=SN:SW

[0086] Based on the processed data set and the log data set, filter out all test plans that have completed data cleaning, data aggregation, data transformation, data analysis, data visualization, and logging, and mark the number of test plans that have completed data cleaning, data aggregation, data transformation, data analysis, data visualization, and logging as Z;

[0087] Based on the result dataset, the test plans with signal quality marked as good and excellent are divided into qualified tests, and the number of qualified tests is marked as hg;

[0088]

[0089] In the formula, The percentage of qualified tests to the number of test plans is the qualified rate. Efficient testing has strong traceability.

[0090] Step 3: Customize the format and style of the test result report, manage announcement information, and provide a data overview. Categorize and store real-time and historical data, combine private, public, and partially shared access rights control to ensure data security, record key system operation events (such as signal testing and fault reporting), and provide operation traceability functions to facilitate troubleshooting and responsibility determination.

[0091] Example 1

[0092] In this experiment, a 5G communication device with a bandwidth of 10 MHz was selected as the experimental object. After testing, the average signal power of the device was 100 mW and the average noise power was 10 mW. The signal transmission rate C and signal strength Q of the device were calculated as follows:

[0093]

[0094] In the formula, Represents the signal-to-noise ratio of the device. According to Shannon's theorem, the signal transmission rate C of the device is calculated. i About 34.59Mbps;

[0095]

[0096] In the formula, α1=0.3 represents the weight for signal power, α2=0.7 represents the weight for signal-to-noise ratio, α1 and α2 are both constants, and 0.3+0.7=1. According to the weights of α1 and α2, the signal strength Q of the device is calculated. i The value is 37, the rate threshold CY is set to 30Mbps, and the strength threshold QY is set to 35dBm. After judgment, the signal transmission rate C of the device exceeds the rate threshold CY, but the signal strength Q is lower than the strength threshold QY, indicating that the signal transmission status of the device is abnormal. While the device is marked in red, the device warning signal should be output in time to remind the test person in charge to check the device operation status in time.

[0097] Example 2

[0098] In this experiment, a total of 1000 storage devices were selected as experimental subjects. After testing, the number of data with the device data label "indoor" was 800, and the number of data with the device data label "outdoor" was 200. After screening all test plans that had completed data cleaning, data aggregation, data conversion, data analysis, data visualization, and logging, 58 qualified tests with signal quality marked as good or excellent were found. The signal coverage ratio Fgb and pass rate Hgl of this device were calculated as follows:

[0099] Fgb=SN:SW=800:200=4:1

[0100]

[0101] In the formula, It represents the percentage of qualified tests to the total number of test plans, with 58% being the qualified rate.

[0102] While embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions, and variations may be made to these embodiments without departing from the principles and spirit of the invention, and that the scope of the invention is defined by the appended claims and their equivalents.

Claims

1. 5G communication signal testing system based on data analysis, characterized by: It includes control module, user management module, test plan module, signal acquisition module, data storage module, data processing module, test result module, report generation module, equipment management module, log management module, announcement management module and data analysis module; The control module is used to provide platform overview and data analysis results; The user management module is used to manage personal information and account settings; The test plan module is used to formulate, execute and monitor test plans and form a plan data set; The signal acquisition module is used to configure the signal acquisition parameters of the test equipment and form a signal data set; The data storage module is used to manage the storage and security of test data and to form a storage data set; The data processing module is used to process and analyze the collected signal data and form a processing data set; The test result module is used to manage the test results generated during the test process and form a result data set; The report generation module is used to customize the format and style of the test result report; The device management module is used to uniformly manage various types of test equipment and form a device data set; The log management module is used to record key information and events during system operation and form a log data set; The announcement management module is used to manage announcement information in the system; The data analysis module is used to analyze the pass rate Tgl and average test time Pcs of all test plans, the signal transmission rate C and signal strength Q of each device, the signal coverage ratio Fgb and pass rate Hgl of all test plans. The data analysis module is set with a fixed value time threshold PCY, rate threshold CY, and strength threshold QY, which are used to evaluate the execution progress of the test plan and the signal transmission status of the device, and generate corresponding early warning signals.

2. The 5G communication signal testing system based on data analysis according to claim 1, characterized in that: The personal information includes user ID, user name, user avatar, mobile phone number, registration date, user status and system role, among which user status includes normal, disabled and frozen, and system roles include general user, information reviewer and super administrator.

3. The 5G communication signal testing system based on data analysis according to claim 2, characterized in that: The plan data set includes the test plan name, test plan description, test start date, test end date, test person in charge, test priority, test environment and test tools, wherein the test priority includes low, medium and high, the test environment includes laboratory environment, outdoor urban area and indoor experimental scene, and the test tools include signal analyzer, spectrum analyzer, signal source generator, power analyzer, transmission rate tester, multi-user access tester, security tester, signal coverage tester and power distribution tester.

4. The 5G communication signal testing system based on data analysis according to claim 3, characterized in that: The signal dataset includes frequency, bandwidth, signal power, noise power, sampling rate, type, wireless configuration, device ID and acquisition time. The stored dataset includes data name, data description, data creation date, data type, data label, data owner and access rights. Among them, the data type includes real-time data and historical data, the data labels include indoor, outdoor, low frequency and high frequency, and the access rights include private, public and partially shared.

5. The 5G communication signal testing system based on data analysis according to claim 4, characterized in that: The processing data set includes the processing name, processing description, processing creation date, data source type, processing method, enablement status and output format, wherein the data source type includes real-time data and batch data, the processing method includes automatic processing and manual processing, and the output format includes CSV, JSON, XML, reports and charts. The result data set includes the test name, test description, test date, tester, signal quality, transmission rate and delay, wherein the signal quality includes poor, average, good and excellent. The test result report includes the report title, author name, generation date, report description, report format and chart type, wherein the report format includes PDF, Word and Excel, and the chart type includes line chart, bar chart and pie chart.

6. The 5G communication signal testing system based on data analysis according to claim 5, characterized in that: The device data set includes the device name, device model, manufacturer, purchase date, device status, maintenance cycle and device location, wherein the device status includes normal and faulty, and the maintenance cycle includes 1 month, 3 months and 6 months. The log data set includes the log title, log content, recording time, log level, recorder, module name and operation type, wherein the log level includes serious and general, and the operation type includes signal test, system upgrade and fault reporting. The announcement information includes the announcement title, announcement body, announcement creation time, registration date and announcement status, wherein the announcement status includes unpublished and published.

7. The 5G communication signal testing system based on data analysis according to claim 6, characterized in that: The calculation process of the pass rate Tgl and the average test time Pcs is as follows: According to the plan data set, the total number of test plans N, the number of completed plans ys, the number of unfinished plans ns, and the test duration of all test plans {j1, j2, j3, ..., j N }; In the formula, j1 to j N Indicates the test duration from the first test plan to the Nth test plan; When the average test duration Pcs of a single test plan exceeds the duration threshold PCY, it indicates that there is a progress delay in the single test. While the test plan is displayed in red, a progress warning signal should be output in a timely manner to remind the test leader to follow up in a timely manner.

8. The 5G communication signal testing system based on data analysis according to claim 7, characterized in that: The calculation process of the signal transmission rate C and signal strength Q is as follows: According to the signal data set and the device data set, the signal acquisition parameters of the i-th device are extracted, and the bandwidth of the i-th device is marked as DK i , mark the signal power of the i-th device as XHL i , the noise power of the i-th device is marked as ZSL i ; In the formula, represents the average signal power of the i-th device, represents the average noise power of the i-th device, represents the signal-to-noise ratio of the i-th device, According to Shannon's theorem, the signal transmission rate C of the i-th device is calculated i ; In the formula, α1 represents the weight for signal power, α2 represents the weight for signal-to-noise ratio, α1 and α2 are both constants, and α1+α2=1. Indicates that the signal strength Q of the i-th device is calculated according to the weights α1 and α2 i ; When the signal transmission rate C of a single device is lower than the rate threshold CY or the signal strength Q is lower than the strength threshold QY, it indicates that the signal transmission status of the single device is abnormal. While the device is marked in red, a device warning signal should be output in time to remind the test person in charge to check the device operation status in time.

9. The 5G communication signal testing system based on data analysis according to claim 8, characterized in that: The calculation process of the signal coverage ratio Fgb and the pass rate Hgl is as follows: According to the stored data set, the statistical data label is the number of indoor data SN, and the data label is the number of outdoor data SW; Fgb=SN:SW Based on the processed data set and the log data set, filter out all test plans that have completed data cleaning, data aggregation, data transformation, data analysis, data visualization, and logging, and mark the number of test plans that have completed data cleaning, data aggregation, data transformation, data analysis, data visualization, and logging as Z; Based on the result dataset, the test plans with signal quality marked as good and excellent are divided into qualified tests, and the number of qualified tests is marked as hg; In the formula, The percentage of qualified tests to the number of test plans is the pass rate.

10. A 5G communication signal testing method based on data analysis, applied to a 5G communication signal testing system based on data analysis according to any one of claims 1 to 9, characterized in that: The following steps are involved: Step 1: Obtain the personal information of all testers and all types of test equipment, and then formulate, execute and monitor the test plan; Step 2: Configure the signal acquisition parameters of the test equipment, analyze the pass rate Tgl and average test time Pcs of all test plans, the signal transmission rate C and signal strength Q of each device, the signal coverage ratio Fgb and pass rate Hgl of all test plans, manage the various test results generated during the test process, securely store and log them, evaluate the execution progress of the test plan and the signal transmission status of the device, and generate corresponding warning signals; Step 3: Customize the format and style of the test result report, manage announcement information, and provide a data overview.

Images