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

Abstract

The invention relates to the technical field of 5G communication signal testing, and discloses a 5G communication signal testing system and method 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, an equipment management module, a log management module, an announcement management module and a data analysis module. The system supports full-automatic making, execution and monitoring of test plans by acquiring information of test personnel and test equipment, configures signal acquisition parameters, analyzes passing rates and average test durations of different test plans, and improves test efficiency. According to the method, the signal transmission rate and the signal strength fluctuation value of different devices and the signal coverage ratio and the qualified rate of different test plans are obtained, test results are managed, logs are safely stored and recorded, the expandability is high in flexible configuration, the format of a test result report is customized, announcement information is managed, a data overview is provided, and the traceability of efficient testing is high.

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 5G communication signal testing system based on data analysis is a comprehensive tool designed specifically for 5G network testing and optimization, integrating multifunctional modules such as signal acquisition, data storage, processing and analysis, and result presentation, and can provide users with a full range of testing solutions. Through the collaborative work of the multifunctional modules, it provides a one-stop solution from signal acquisition, data storage, processing and analysis to result presentation. The main purpose of the 5G communication signal testing system is to provide users with comprehensive data support and decision-making basis to significantly improve the efficiency and accuracy of 5G communication signal testing. Users can manage test plans and test equipment through this system, flexibly configure acquisition parameters to ensure data accuracy, and extract useful information through a variety of data processing methods, support custom and automated report generation, and facilitate users to view and analyze test results. Through this system, users can more comprehensively and accurately understand the operation of the 5G network and provide a scientific basis for network optimization.

[0003] Currently, when dealing with different test scenarios, traditional 5G communication signal testing systems need to make judgments multiple times based on human experience to determine whether test configurations need to be adjusted, with low test efficiency. Traditional testing systems lack in-depth analysis capabilities and can no longer meet the comprehensive testing requirements for characteristics such as high speed, large capacity, and low latency, and have low test accuracy. Summary of the Invention

[0004] (1) Technical Problems to be Solved

[0005] In view of the deficiencies of the prior art, 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, high-efficiency testing, and strong traceability, and solves the problems of low test efficiency and lack of in-depth analysis capabilities of traditional 5G communication signal testing systems.

[0006] (2) Technical Solutions

[0007] To achieve the above object, the present invention provides the following technical solutions: A 5G communication signal testing system 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, an equipment management module, a log management module, a notice management module, and a data analysis module;

[0008] The control module is used to provide an overview of the platform 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 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 various 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 equipment management module is used to uniformly manage various types of test equipment and form an equipment data set;

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

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

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

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

[0021] Preferably, the planned 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 test tools. Among them, the test priority includes low, medium, and high. The test environment includes a laboratory environment, an outdoor urban area, and an indoor experimental scenario. 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. The storage data set includes a data name, a data description, a data creation date, a data type, a data label, a data owner, and access rights. Among them, the data type includes real-time data and historical data. The data label includes indoor, outdoor, low frequency, and high frequency. The access rights include private, public, and partial sharing.

[0023] Preferably, the processed data set includes a processing name, a processing description, a processing creation date, a data source type, a processing method, an enabled status, and an output format. Among them, 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 a test name, a test description, a test date, a tester, signal quality, transmission rate, and latency. Among them, the signal quality includes poor, average, good, and excellent. The test result report includes a report title, an author's name, a generation date, a report description, a report format, and a chart type. Among them, the report format includes PDF, Word, and Excel. The chart type includes line charts, bar charts, and pie charts.

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

[0025] Preferably, the calculation processes of the passing rate Tgl and the average test duration Pcs are as follows:

[0026] According to the planned dataset, count the total number of test plans N, the number of completed plans ys, the number of uncompleted plans ns, and the test durations of all test plans {j1, j2, j3, ..., j N};

[0027]

[0028] In the formula, j1 to j N represent the test durations of 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 highlighting the test plan 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 calculation processes of the signal transmission rate C and the signal strength Q are as follows:

[0031] According to the signal dataset and the device dataset, extract the signal acquisition parameters of the ith device, and mark the bandwidth of the ith device as DK i , mark the signal power of the ith device as XHL i , mark the noise power of the ith device as ZSL i ;

[0032]

[0033] In the formula, represents the average signal power of the ith device, represents the average noise power of the ith device, represents the signal-to-noise ratio of the ith device, represents that according to the Shannon theorem, the signal transmission rate C of the ith device is calculated i ;

[0034]

[0035] In the formula, α1 represents the weight for the signal power, α2 represents the weight for the signal-to-noise ratio, both α1 and α2 are constants, and α1 + α2 = 1, represents that according to the weights of α1 and α2, the signal strength Q of the ith device is calculated 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 state of the single device is abnormal. While highlighting the device in red, a device warning signal should be output in a timely manner to remind the test person in charge to check the device operation state in a timely manner.

[0037] Preferably, the calculation processes of the signal coverage ratio Fgb and the qualification rate Hgl are as follows:

[0038] According to the stored data set, count the number of indoor data SN with the data label being indoor and the number of outdoor data SW with the data label being outdoor;

[0039] Fgb = SN:SW

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

[0041] According to the result data set, divide the test plans with the signal quality marked as good and excellent into qualified tests, and mark the number of qualified tests as hg;

[0042]

[0043] In the formula, represents the percentage of the number of qualified tests in the number of test plans, that is, the qualification 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 passing rate Tgl and the average test duration Pcs of different test plans, the signal transmission rate C and the signal intensity fluctuation value Qbd of different devices, the signal coverage ratio Fgb and the qualification rate Hgl of different test plans, manage various test results generated during the test, store them safely and record logs, 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 the announcement information, and provide an overview of the data.

[0048] Compared with the prior art, the present invention provides a 5G communication signal testing system and method based on data analysis, having 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 device 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 passing rate Tgl and the average test duration Pcs of different test plans, the signal transmission rate C and the signal intensity fluctuation value Qbd of different devices, the signal coverage ratio Fgb and the qualification rate Hgl of different test plans, which can quickly adapt to different scenario requirements, reduce manual intervention, improve test efficiency. The test result module manages various test results generated during the test process, the data storage module stores securely, and the log management module records logs, evaluates the execution progress of the test plan and the signal transmission status of the device, generates corresponding warning signals, can accurately locate the performance bottleneck of the device, guide maintenance and upgrade, and has strong flexibility and 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, and the chart types include line charts, bar charts, and pie charts. It automatically generates test reports, reduces the cost of manual collation. The announcement management module manages announcement information, and provides an overview of the data through the control module, classifies and stores real-time data and historical data, combines access rights control of private, public, and partial sharing, ensures data security, records key events in the system operation, provides an operation traceability function, facilitates fault troubleshooting and responsibility identification, and has strong test traceability. BRIEF DESCRIPTION OF THE DRAWINGS

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

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

[0053] Figure 3 is the system schematic diagram of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0054] Next, the technical solutions in the embodiments of the present invention will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0055] Since the traditional 5G communication signal test system needs to make judgments multiple times based on human experience when dealing with different test scenarios to determine whether it is necessary to adjust the test configuration, the test efficiency is low. The traditional test system lacks the ability of in-depth analysis and can no longer meet the comprehensive test requirements for characteristics such as high speed, large capacity, and low latency. The test accuracy is low. Therefore, a 5G communication signal test system and method based on data analysis are provided. Please refer to Figures 1 - 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, a notice management module, and a data analysis module;

[0056] The control module is used to provide an overview of the platform and the data analysis results. The test plan management supports full-process automation from formulation, execution to monitoring. Combining priorities (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. The personal information includes user ID, user name, user avatar, mobile phone number, registration date, user status, and system role. Among them, the user status includes normal, disabled, and frozen, and the system role includes general user, information reviewer, and super administrator;

[0058] The test plan module is used to formulate, execute, and monitor test plans and form a plan data set. The plan data set includes test plan name, test plan description, test start date, test end date, test person in charge, test priority, test environment, and test tool. Among them, the test priority includes low, medium, and high, the test environment includes laboratory environment, outdoor urban area, and indoor experimental scenario, and the test tool includes 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 permission. Among them, the data type includes real-time data and historical data, the data label includes indoor, outdoor, low frequency, and high frequency, and the access permission includes private, public, and partial sharing;

[0061] The data processing module is used to process and analyze the collected signal data and form a processed data set. The processed data set includes a processing name, a processing description, a processing creation date, a data source type, a processing method, an enabled status, and an 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 the 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 various test results generated during the test process and form a result data set. The result data set includes a test name, a test description, a test date, a test person, signal quality, transmission rate, and latency. 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 a report title, an author's name, a generation date, a report description, a report format, and a chart type. Among them, the report format includes PDF, Word, and Excel, and the chart type includes line charts, bar charts, and pie charts. It automatically generates test reports and reduces the cost of manual collation;

[0064] The device management module is used to uniformly manage various test devices and form a device data set. The device data set includes a device name, a device model, a manufacturer, a purchase date, a device status, a maintenance cycle, and a device location. Among them, the device 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 the operation of the system and form a log data set. The log data set includes a log title, a log content, a recording time, a log level, a recorder, a module name, and an operation type. Among them, the log level includes critical and general, and the operation type includes signal testing, system upgrade, and fault reporting;

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

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

[0068] The 5G communication signal test 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 passing rate Tgl and the average test duration Pcs of different test plans, the signal transmission rate C and the signal strength fluctuation value Qbd of different devices, the signal coverage ratio Fgb and the passing rate Hgl of different test plans, manage various test results generated during the test process, store them securely and record logs, 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 the passing rate Tgl and the average test duration Pcs is as follows:

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

[0073]

[0074] In the formula, j1 to j N represent the test durations of 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 a single test. While highlighting the test plan 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;

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

[0077] According to the signal data set and the device data set, extract the signal acquisition parameters of the ith device, and mark the bandwidth of the ith device as DK i and mark the signal power of the ith device as XHL i, mark the noise power of the i-th device 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, represents that 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. Both α1 and α2 are constants, and α1 + α2 = 1, represents that according to the weights of α1 and α2, the signal strength Q of the i-th device is calculated 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 state of the single device is abnormal. While marking the device in red, an equipment warning signal should be output in a timely manner to remind the test person in charge to check the equipment operation status in a timely manner, which can accurately locate the equipment performance bottleneck, guide maintenance and upgrade, and has strong scalability with flexible configuration;

[0083] The calculation processes of the signal coverage ratio Fgb and the qualification rate Hgl are as follows:

[0084] According to the stored data set, count the number of indoor data SN with the data label being indoor and the number of outdoor data SW with the data label being outdoor;

[0085] Fgb = SN:SW

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

[0087] According to the result data set, divide the test plans with the signal quality marked as good and excellent into qualified tests, and mark the number of qualified tests as hg;

[0088]

[0089] In the formula, Indicates the percentage of qualified test quantities in the test plan quantities, which is the pass rate. High-efficiency testing has strong traceability;

[0090] Step 3: Customize the format and style of the test result report, manage announcement information, and provide an overview of data. Classify and store real-time data and historical data, and combine access control for private, public, and partial sharing to ensure data security. Record key events in the system operation (such as signal testing, fault reporting), and provide an operation traceability function for easy troubleshooting and responsibility determination.

[0091] Example 1

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

[0093]

[0094] In the formula, represents the signal-to-noise ratio of this device. According to Shannon's theorem, the signal transmission rate C of this device is calculated i is approximately 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. Both α1 and α2 are constants, and 0.3 + 0.7 = 1. According to the weights of α1 and α2, the signal strength Q of this device is calculated i 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 this device exceeds the rate threshold CY, but the signal strength Q is lower than the strength threshold QY, indicating that the signal transmission state of this device is abnormal. While marking the device in red, an early warning signal for the device should be output in a timely manner to remind the test person in charge to check the device operation state in a timely manner.

[0097] Example 2

[0098] In this experiment, a storage device with a total of 1000 test plans was selected as the experimental object. After testing, the number of data with the data label of indoor in this device is 800, and the number of data with the data label of outdoor in this device is 200. After screening out all the test plans that have completed data cleaning, data aggregation, data conversion, data analysis, data visualization, and log recording, the number of qualified tests with the signal quality marked as good and excellent is 58. The calculation processes of the signal coverage ratio Fgb and pass rate Hgl of this device are as follows:

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

[0100]

[0101] In the formula, represents the percentage of the number of qualified tests in the number of test plans, and 58% is the pass rate.

[0102] Although the embodiments of the present invention have been shown and described, those of ordinary skill in the art can understand that various changes, modifications, substitutions, and variations can be made to these embodiments without departing from the principles and spirit of the present invention. The scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. A 5G communication signal testing system based on data analysis, characterized in that: It 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, an equipment management module, a log management module, a notice management module, and a data analysis module; The control module is used to provide an overview of the platform and the 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 test equipment and form a signal data set; The data storage module is used to manage the storage and security of test data and form a storage data set; The data processing module is used to process and analyze the collected signal data and form a processed data set; The test result module is used to manage various 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 test result reports; The equipment management module is used to uniformly manage various types of test equipment and form an equipment data set; The log management module is used to record key information and events during the operation of the system and form a log data set; The notice management module is used to manage notice information in the system; The data analysis module is used to analyze the passing rate Tgl and the average test duration Pcs of all test plans, the signal transmission rate C and signal strength Q of each device, the signal coverage ratio Fgb and the passing rate Hgl of all test plans. The data analysis module is set with fixed numerical duration thresholds PCY, rate thresholds CY, and strength thresholds QY to evaluate the execution progress of test plans and the signal transmission status of devices, and generate corresponding warning signals.

2. The 5G communication signal testing system based on data analysis according to claim 1, wherein: The personal information includes user ID, user name, user avatar, mobile phone number, registration date, user status, and system role. Among them, the user status includes normal, disabled, and frozen, and the system role includes general user, information reviewer, and super administrator.

3. The 5G communication signal testing system based on data analysis according to claim 2, wherein: The plan data set includes test plan name, test plan description, test start date, test end date, test leader, 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 scenario, 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, wherein: The signal data set includes frequency, bandwidth, signal power, noise power, sampling rate, type, wireless configuration, device ID, and acquisition time. The storage data set includes data name, data description, data creation date, data type, data label, data owner, and access permission. Among them, the data type includes real-time data and historical data, the data label includes indoor, outdoor, low frequency, and high frequency, and the access permission includes private, public, and partial sharing.

5. The 5G communication signal testing system based on data analysis according to claim 4, characterized in that: The processed dataset includes a process name, a process description, a process creation date, a data source type, a processing method, an enabled status, and an 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 result dataset includes a test name, a test description, a test date, a tester, signal quality, transmission rate, and latency. Among them, the signal quality includes poor, average, good, and excellent. The test result report includes a report title, an author's name, a generation date, a report description, a report format, and a chart type. Among them, the report format includes PDF, Word, and Excel, and the chart type includes line charts, bar charts, and pie charts.

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

7. The 5G communication signal testing system based on data analysis according to claim 6, wherein: The calculation process of the passing rate Tgl and the average test duration Pcs is as follows: According to the planned dataset, count the total number N of test plans, the number ys of completed plans, the number ns of uncompleted plans, and the test durations {j1, j2, j3, ..., j N}; In the formula, j1 to j N represent the test durations of 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 a single test. While highlighting the test plan 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.

8. The 5G communication signal testing system based on data analysis according to claim 7, wherein: The calculation process of the signal transmission rate C and the signal strength Q is as follows: Extract the signal acquisition parameters of the i-th device according to the signal data set and the device data set, and mark the bandwidth of the i-th device as DK i , mark the signal power of the i-th device as XHL i , mark the noise power of the i-th device 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, represents the signal transmission rate C of the i-th device calculated according to Shannon's theorem i ; In the formula, α1 represents the weight for signal power, α2 represents the weight for signal-to-noise ratio. Both α1 and α2 are constants, and α1 + α2 = 1. It represents that according to the weights of α1 and α2, the signal strength Q of the i-th device is calculated. 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 a single device is abnormal. While highlighting the device in red, a device warning signal should be output in a timely manner to remind the test person in charge to check the device operation status in a timely manner.

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 dataset, count the number of data with the data label of indoor as SN and the number of data with the data label of outdoor as SW; Fgb = SN:SW According to the processed dataset and the log dataset, filter out all the 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; According to the result dataset, divide the test plans with the signal quality marked as good and excellent into qualified tests, and mark the number of qualified tests as hg; In the formula, represents the percentage of the number of qualified tests in the number of test plans, that is, the qualification rate.

10. A 5G communication signal testing method based on data analysis, which is applied to the 5G communication signal testing system based on data analysis according to any one of claims 1-9, characterized in that, It includes the following steps: 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 passing rate Tgl and the average test duration Pcs of all test plans, the signal transmission rate C and signal strength Q of each device, the signal coverage ratio Fgb and the qualification rate Hgl of all test plans, manage various test results generated during the test process, securely store and log them, evaluate the execution progress of the test plan and the device signal transmission status, and generate corresponding warning signals; Step 3: Customize the format and style of the test result report, manage the announcement information, and provide an overview of the data.

Images