Indoor connectivity analysis methods, apparatus, equipment and storage media

Abstract

This application relates to the field of communication technology, providing a method, apparatus, device, and storage medium for analyzing indoor connectivity. The method includes: collecting full gateway resource data and network device model data; extracting at least one network device parameter from the device model data to form a first temporary table; associating the gateway MAC addresses in the first temporary table with the gateway MAC addresses in the full gateway resource data to obtain a second temporary table; and associating the second temporary table with at least one network operation data table based on the device MAC addresses in the second temporary table and the device MAC addresses in at least one network operation data table to obtain at least one indoor connectivity analysis table. This application groups and associates various data tables by MAC values ​​to obtain detailed tables reflecting network quality, enabling multi-dimensional analysis of indoor user connectivity quality, which helps improve user connectivity quality in home environments and enhance user experience.

Description

Technical Field

[0001] This application relates to the field of communication technology, specifically to a method, apparatus, device, and storage medium for analyzing indoor connectivity. Background Technology

[0002] With the development of mobile network technology, home users' devices have become increasingly diverse and intelligent, leading to exceptionally complex home connectivity scenarios and inconsistent user experiences. Currently, multiple factors negatively impact user internet experience, including a large number of connected devices, significant wireless interference, weak wireless signals, and low-quality routers. Furthermore, current data on home connectivity is often presented in isolation, lacking systematic analysis and visualization. Summary of the Invention

[0003] This application provides a method, apparatus, device, and storage medium for analyzing indoor connectivity, in order to address the problem of a lack of diversity in the analysis of indoor connectivity.

[0004] In a first aspect, embodiments of this application provide a method for analyzing indoor connectivity, including:

[0005] Collect all gateway resource data and network device model data;

[0006] Extract at least one network device parameter from the device model data to form a first temporary table;

[0007] Associate the gateway MAC in the first temporary table with the gateway MAC of the full gateway resource data to obtain the second temporary table;

[0008] Based on the device MAC addresses in the second temporary table and the device MAC addresses in at least one network operation data table, the second temporary table is associated with the at least one network operation data table to obtain at least one indoor connection status analysis table.

[0009] In one embodiment, the network operation data table includes an uplink status information table, and the indoor connection status analysis table includes a negotiation rate table;

[0010] The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including:

[0011] From the uplink status information table, extract the device MAC corresponding to the negotiated rate of the set rate to obtain the first temporary table of the negotiated rate;

[0012] Based on the device MAC in the second temporary table and the device MAC in the first temporary table of negotiation rate corresponding to the set rate, the second temporary table is associated with the first temporary table of negotiation rate to obtain the second temporary table of negotiation rate;

[0013] At least one network device parameter is extracted from the second temporary table of the negotiated rate to obtain the negotiated rate table.

[0014] In one embodiment, the network operation data table includes a downstream device information table, and the indoor connection status analysis table includes a Wi-Fi signal strength table;

[0015] The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including:

[0016] From the attached device information table, extract the MAC addresses of devices with Wi-Fi strength less than a set strength to obtain a first temporary table of Wi-Fi information strength;

[0017] Based on the device MAC in the second temporary table and the device MAC in the first temporary table of Wi-Fi strength that is less than a set strength, the second temporary table is associated with the first temporary table of Wi-Fi strength to obtain the second temporary table of Wi-Fi strength;

[0018] At least one network device parameter is extracted from the second temporary table of Wi-Fi information strength to obtain the Wi-Fi information strength table.

[0019] In one embodiment, the network operation data table includes a service monitoring data table, and the indoor connectivity analysis table includes a 2.4G band access details table.

[0020] The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including:

[0021] From the aforementioned business monitoring data table, based on the MAC address of the 2.4G band access information extraction device, a first temporary table of 2.4G band access details is obtained;

[0022] Based on the device MAC in the second temporary table and the device MAC extracted from the 2.4G band access information in the first temporary table of 2.4G band access details, the second temporary table is associated with the first temporary table of 2.4G band access details to obtain the second temporary table of 2.4G band access details.

[0023] At least one network device parameter is extracted from the second temporary table of the 2.4G band access details to obtain the 2.4G band access details table.

[0024] In one embodiment, the network operation data table includes a surrounding Wi-Fi information table, and the indoor connection analysis table includes a 2.4G strong interference details table;

[0025] The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including:

[0026] From the surrounding Wi-Fi information table, based on the MAC address of the 2.4G strong interference information extraction device, a first temporary table of 2.4G strong interference details is obtained;

[0027] Based on the device MAC in the second temporary table and the device MAC extracted from the 2.4G strong interference information in the first temporary table of 2.4G strong interference details, the second temporary table is associated with the first temporary table of 2.4G strong interference details to obtain the second temporary table of 2.4G strong interference details.

[0028] At least one network device parameter is extracted from the second temporary table of the 2.4G strong interference details to obtain the 2.4G strong interference details table.

[0029] In one embodiment, the network operation data table includes a Wi-Fi status information table, and the indoor connection status analysis table includes a router connected device details table;

[0030] The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including:

[0031] From the Wi-Fi status information table, extract the MAC addresses of devices whose number of devices connected to the router exceeds a set number, and obtain the first temporary table of router connected device details.

[0032] Based on the device MAC in the second temporary table and the device MAC corresponding to the number of router-connected devices being greater than a set number in the first temporary table of router-connected device details, the second temporary table is associated with the first temporary table of router-connected device details to obtain the second temporary table of router-connected device details;

[0033] At least one network device parameter is extracted from the second temporary table of the router's connected devices details to obtain the router's connected devices details table.

[0034] In one embodiment, after associating the second temporary table with the at least one network operation data table based on the device MAC address in the second temporary table and the device MAC address in at least one network operation data table to obtain at least one indoor connectivity analysis table, the method further includes:

[0035] The indoor connectivity analysis table is visualized using a predefined display method.

[0036] Secondly, embodiments of this application provide an indoor connectivity analysis device, comprising:

[0037] The data acquisition module is used to collect full gateway resource data and network device model data;

[0038] The extraction module is used to extract at least one network device parameter from the device model data to form a first temporary table;

[0039] The association module is used to associate the gateway MAC in the first temporary table with the gateway MAC of the full gateway resource data to obtain a second temporary table;

[0040] The analysis module is used to associate the second temporary table with the at least one network operation data table based on the device MAC in the second temporary table and the device MAC in at least one network operation data table to obtain at least one indoor connection status analysis table.

[0041] Thirdly, embodiments of this application provide an electronic device, including a processor and a memory storing a computer program, wherein the processor executes the program to implement the steps of the indoor connectivity analysis method described in the first aspect.

[0042] Fourthly, embodiments of this application provide a non-transitory computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the steps of the indoor connectivity analysis method described in the first aspect.

[0043] The indoor connectivity analysis method, apparatus, device, and storage medium provided in this application collect full gateway resource data and network device model data; extract at least one network device parameter from the device model data to form a first temporary table; associate the gateway MAC addresses in the first temporary table with the gateway MAC addresses in the full gateway resource data to obtain a second temporary table; based on the device MAC addresses in the second temporary table and the device MAC addresses in at least one network operation data table, associate the second temporary table with at least one network operation data table to obtain at least one indoor connectivity analysis table. This application groups and associates various data tables by MAC values ​​to obtain detailed tables reflecting network quality, realizing multi-dimensional analysis of indoor user connectivity quality, which helps improve user connectivity quality in the home environment and enhance user experience. Attached Figure Description

[0044] To more clearly illustrate the technical solutions in this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0045] Figure 1 This is a flowchart illustrating the indoor connectivity analysis method provided in an embodiment of this application;

[0046] Figure 2 This is a schematic diagram of the modules of the home user connection quality model design system based on big data provided in this application embodiment;

[0047] Figure 3 This is a schematic diagram of the structure of the indoor connectivity analysis device provided in the embodiments of this application;

[0048] Figure 4 This is a schematic diagram of the structure of the electronic device provided in the embodiments of this application. Detailed Implementation

[0049] To make the objectives, technical solutions, and advantages of this application clearer, the technical solutions of this application will be clearly and completely described below with reference to the accompanying drawings of the embodiments. Obviously, the described embodiments are only some embodiments of this application, not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0050] Figure 1 This is a flowchart illustrating the indoor connectivity analysis method provided in an embodiment of this application. (Refer to...) Figure 1This application provides a method for analyzing indoor connectivity, which may include:

[0051] S100 collects full gateway resource data and network device model data;

[0052] It should be noted that device model data refers to the model information of network devices, including device name, model, manufacturer, firmware version, etc.; full gateway resource data refers to the data of all gateway devices in a specific region (such as a province), including basic information, status information and information of connected downstream devices of the gateways.

[0053] This application embodiment is based on the data acquisition module collecting network device model data and full gateway resource data from the provincial platform. The data acquisition module mainly includes the following steps:

[0054] Step 1: The provincial platform collects gateway resource data daily based on the installed plugins, packages it, and uploads it to the designated FTP (File Transfer Protocol Server) server.

[0055] Step 2: The network side uploads device model data, uplink status data, connected device information data, Wi-Fi status information data, service monitoring data, and surrounding Wi-Fi data daily. This data is collected by network devices and related monitoring equipment and uploaded to the designated location.

[0056] Step 3: By specifying a scheduled task, download the relevant files from the FTP server at a fixed time every day. These files contain the previously uploaded device data and resource data.

[0057] Step 4: Verify the validity of the files downloaded in Step 3. If any problems are found, issue an alarm to ensure that the collected data is complete and reliable.

[0058] Optionally, the collected raw data can be preprocessed through a data preprocessing module to clean and filter out useless data, and to standardize the content into a fixed format.

[0059] S200, extract at least one network device parameter from the device model data to form a first temporary table;

[0060] It should be noted that network device parameters include gateway MAC (Media Access Control), device MAC, broadband account, city ID, gateway SN (Serial Number), etc.

[0061] Retrieve parameters such as gateway MAC, device MAC, broadband account, city ID, and gateway SN from the full device model table and create a first temporary table. For example, using SQL statements to extract fields including gateway MAC, device MAC, broadband account, city ID, and gateway SN from the full device model table involves the following steps: Use a SELECT statement to select the required fields, such as gateway MAC, device MAC, broadband account, city ID, and gateway SN; simultaneously, use a FROM statement to specify the data source, i.e., the full device model table. If specific filtering conditions are needed, corresponding conditions can be added to the WHERE clause. For example, if only device model data from a specific city is needed, a condition can be added where the city ID equals a specified value. If data aggregation operations are required (such as calculating the average or sum), the GROUP BY clause can be used to group the data according to specified fields, and then aggregate functions can be used for calculation. Finally, a new temporary table can be created using the CREATE TABLE statement, and the results of the SELECT statement can be inserted into the temporary table.

[0062] S300, associate the gateway MAC in the first temporary table with the gateway MAC of the full gateway resource data to obtain a second temporary table;

[0063] A second temporary table is obtained by left-joining the gateway MAC addresses of all gateway resource data using the gateway MAC addresses of the first temporary table. A left join is a database operation used to connect two tables according to specified join conditions and return all records in the left table plus any records that match those in the right table. In a left join, the left table is the table being joined, and the right table is the table used for the join. A left join returns all records in the left table, regardless of whether they match those in the right table. If a record in the left table has a matching record in the right table, the matching records are merged together; otherwise, the relevant fields in the right table will be NULL.

[0064] For example, when joining the first temporary table with the full gateway resource data table using the gateway MAC field, the LEFT JOIN operation in SQL can be used. The steps are as follows:

[0065] The LEFT JOIN statement is used to join the first temporary table and the full gateway resource data table. LEFT JOIN is a join operation that returns all records from the left table (i.e., the first temporary table). If there are matching records from the right table (i.e., the full gateway resource data table), the matching records are returned; otherwise, NULL is returned.

[0066] In the LEFT JOIN statement, specify the association condition, that is, to associate through the gateway MAC field. For example, use the ON clause and specify the first temporary table.gatewayMAC = full gateway resource data table.gatewayMAC.

[0067] Depending on the specific requirements, you can select the required fields in the SELECT statement. You can select the required fields from the first temporary table and the full gateway resource data table, and then save the results after the connection to a new temporary table (i.e., the second temporary table). You can use the CREATE TABLE statement to create a new temporary table and insert the results after the SELECT statement into the temporary table.

[0068] S400, based on the device MAC in the second temporary table and the device MAC in at least one network operation data table, associate the second temporary table with the at least one network operation data table to obtain at least one indoor connection status analysis table.

[0069] It should be noted that the network operation data tables include uplink status information tables, downstream device information tables, service monitoring data tables, surrounding Wi-Fi information tables, and Wi-Fi status information tables. The indoor connectivity analysis tables include negotiation rate tables, Wi-Fi signal strength tables, 2.4G band access details tables, 2.4G strong interference details tables, and router downstream device details tables.

[0070] Based on the device MAC addresses in the second temporary table and at least one device MAC address in at least one network operation data table, the second temporary table is associated with at least one network operation data table to obtain at least one indoor connectivity analysis table. For example, the device MAC addresses are extracted from the network operation data table to create a third temporary table; then, the second and third temporary tables are left-associated by the device MAC address field and grouped by device MAC address to obtain a fourth temporary table; parameters such as gateway MAC address, device MAC address, broadband account, city ID, and gateway SN are extracted from the fourth temporary table, and an indoor connectivity analysis table is created based on these parameters.

[0071] Furthermore, a customized display method is adopted to visualize the indoor connectivity analysis table. For example, various methods and tools are used, such as charts, maps, bar charts, line charts, and heatmaps, to present the data.

[0072] The indoor connectivity analysis method provided in this application collects full gateway resource data and network device model data; extracts at least one network device parameter from the device model data to form a first temporary table; associates the gateway MAC addresses in the first temporary table with the gateway MAC addresses in the full gateway resource data to obtain a second temporary table; based on the device MAC addresses in the second temporary table and at least one device MAC address in a network operation data table, associates the second temporary table with at least one network operation data table to obtain at least one indoor connectivity analysis table. This application groups and associates various data tables by MAC values ​​to obtain detailed tables reflecting network quality, enabling multi-dimensional analysis of indoor user connectivity quality, which helps improve user connectivity quality in the home environment and enhance user experience.

[0073] In one embodiment, the step of associating the second temporary table with the at least one network operation data table based on the device MAC address in the second temporary table and the device MAC address in at least one network operation data table to obtain at least one indoor connectivity analysis table includes:

[0074] From the uplink status information table, extract the device MAC corresponding to the negotiated rate of the set rate to obtain the first temporary table of the negotiated rate;

[0075] Based on the device MAC in the second temporary table and the device MAC in the first temporary table of negotiation rate corresponding to the set rate, the second temporary table is associated with the first temporary table of negotiation rate to obtain the second temporary table of negotiation rate;

[0076] At least one network device parameter is extracted from the second temporary table of the negotiated rate to obtain the negotiated rate table.

[0077] It should be noted that the uplink status information table contains various fields related to the uplink status and is partitioned by date. The uplink status information table includes fields such as device MAC address, reporting time, uplink type, working mode, CPU utilization, memory utilization, received signal strength indication, receiving rate, transmitting rate, IP address, user binding status, signal-to-noise ratio, IPv6 status, receiving rate, network lock status, and fiber optic transmitting / receiving power.

[0078] The system groups records from the uplink status information table by device MAC address and filters out records with a negotiation rate of 100 Mbps to extract the device MAC address values, thus creating a first temporary table for negotiation rates. For example, the data table is grouped based on the device's MAC address, grouping records with the same MAC address together. Within each group of records corresponding to a device MAC address, records with a negotiation rate of 100 Mbps are filtered out. The device MAC address values ​​are then extracted from the filtered records and stored in the first temporary table for negotiation rates.

[0079] Then, the second temporary table is left-associated with the first temporary table of negotiation rate according to the device MAC value, and grouped according to the device MAC value to obtain the second temporary table of negotiation rate; the city ID, broadband account, gateway SN, device MAC, negotiation rate and other values ​​are taken from the second temporary table of negotiation rate and stored in the corresponding negotiation rate table.

[0080] This application embodiment associates the uplink status information table with the full gateway resource data and device model data through the device MAC, realizing multi-dimensional analysis of the connection quality of indoor users, which helps to improve the connection quality of users in the home environment and enhance the user experience.

[0081] In one embodiment, the step of associating the second temporary table with the at least one network operation data table based on the device MAC address in the second temporary table and the device MAC address in at least one network operation data table to obtain at least one indoor connectivity analysis table includes:

[0082] From the attached device information table, extract the MAC addresses of devices with Wi-Fi strength less than a set strength to obtain a first temporary table of Wi-Fi information strength;

[0083] Based on the device MAC in the second temporary table and the device MAC in the first temporary table of Wi-Fi strength that is less than a set strength, the second temporary table is associated with the first temporary table of Wi-Fi strength to obtain the second temporary table of Wi-Fi strength;

[0084] At least one network device parameter is extracted from the second temporary table of Wi-Fi information strength to obtain the Wi-Fi information strength table.

[0085] It should be noted that the downstream device information table contains various fields related to downstream device information, such as the device's MAC address, IPv6 address, hostname, physical address, device type, device uptime, receive rate, send rate, number of bytes sent by the device, and the date the device information was reported.

[0086] The device information table is grouped according to device MAC address, and records with Wi-Fi strength less than -75 are filtered out to extract device MAC values, resulting in a first temporary table for Wi-Fi strength. For example, the data table is grouped according to device MAC address, grouping records with the same MAC address together; within each group, records with Wi-Fi strength less than -75 are filtered out; the device MAC address values ​​are extracted from the filtered records and stored in the first temporary table for Wi-Fi strength. Then, a left join is made between the second temporary table and the first temporary table for Wi-Fi strength based on device MAC values, and the data is grouped according to device MAC, resulting in a second temporary table for Wi-Fi strength; values ​​such as city ID, broadband account, gateway SN, device MAC, and Wi-Fi strength are retrieved from the second temporary table for Wi-Fi strength and stored in the corresponding Wi-Fi strength tables.

[0087] This application embodiment associates the downstream device information table with the full gateway resource data and device model data through the device MAC, realizing multi-dimensional analysis of the connection quality of indoor users, which helps to improve the user connection quality in the home environment and enhance the user experience.

[0088] In one embodiment, the step of associating the second temporary table with the at least one network operation data table based on the device MAC address in the second temporary table and the device MAC address in at least one network operation data table to obtain at least one indoor connectivity analysis table includes:

[0089] From the aforementioned business monitoring data table, based on the MAC address of the 2.4G band access information extraction device, a first temporary table of 2.4G band access details is obtained;

[0090] Based on the device MAC in the second temporary table and the device MAC extracted from the 2.4G band access information in the first temporary table of 2.4G band access details, the second temporary table is associated with the first temporary table of 2.4G band access details to obtain the second temporary table of 2.4G band access details.

[0091] At least one network device parameter is extracted from the second temporary table of the 2.4G band access details to obtain the 2.4G band access details table.

[0092] It should be noted that the business monitoring data table includes fields such as device MAC address, service number, MAC process information, service start time, service runtime, protocol type, average send / receive rate, maximum send / receive rate, uplink / downlink statistics, TCP connection count, HTTP response latency, HTTP request error list, and HTTP request count.

[0093] The data is grouped by device MAC address from the business monitoring data table, and the device MAC address is extracted based on the 2.4G band access information to obtain the first temporary table of 2.4G band access details. For example, the data table is grouped according to the device MAC address, and records with the same MAC address are grouped together. Within each group of records corresponding to a device MAC address, the value of the device MAC address is extracted based on the 2.4G band access information (such as signal strength, channel, and transmission rate), and these values ​​are stored in the first temporary table of 2.4G band access details. Then, the second temporary table is left-associated with the first temporary table of 2.4G band access details according to the device MAC value, and grouped according to the device MAC address to obtain the second temporary table of 2.4G band access details. The city ID, broadband account, gateway SN, device MAC address, and 2.4G band access details are retrieved from the second temporary table of 2.4G band access details, and these values ​​are stored in the corresponding 2.4G band access details table.

[0094] This application embodiment associates the service monitoring data table with the full gateway resource data and device model data through the device MAC, realizing multi-dimensional analysis of the connection quality of indoor users, which helps to improve the connection quality of users in the home environment and enhance the user experience.

[0095] In one embodiment, the step of associating the second temporary table with the at least one network operation data table based on the device MAC address in the second temporary table and the device MAC address in at least one network operation data table to obtain at least one indoor connectivity analysis table includes:

[0096] From the surrounding Wi-Fi information table, based on the MAC address of the 2.4G strong interference information extraction device, a first temporary table of 2.4G strong interference details is obtained;

[0097] Based on the device MAC in the second temporary table and the device MAC extracted from the 2.4G strong interference information in the first temporary table of 2.4G strong interference details, the second temporary table is associated with the first temporary table of 2.4G strong interference details to obtain the second temporary table of 2.4G strong interference details.

[0098] At least one network device parameter is extracted from the second temporary table of the 2.4G strong interference details to obtain the 2.4G strong interference details table.

[0099] It should be noted that the surrounding Wi-Fi information table includes fields such as the device's MAC address, information reporting timestamp, number of surrounding Wi-Fi networks, the radio frequency band the device is connected to, the MAC address of the surrounding Wi-Fi network, the channel of the surrounding Wi-Fi network, the bandwidth of the surrounding Wi-Fi network, and the wireless standard of the surrounding Wi-Fi network.

[0100] The system groups devices in the surrounding Wi-Fi information table by MAC address and extracts their MAC values ​​based on 2.4G strong interference information to obtain a first temporary table for 2.4G strong interference details. For example, the data table is grouped according to the device's MAC address, grouping records with the same MAC address together. Within each group of records corresponding to a device MAC address, the device MAC address value is extracted based on 2.4G strong interference information (such as interference source channel, interference source signal strength, and interference source type), and these values ​​are stored in the first temporary table for 2.4G strong interference details. Then, the second temporary table is left-associated with the first temporary table for 2.4G strong interference details based on the device MAC value, and grouped by device MAC address to obtain a second temporary table for 2.4G strong interference details. From the second temporary table for 2.4G strong interference details, the city ID, broadband account, gateway SN, device MAC address, and 2.4G strong interference details are retrieved and stored in the corresponding 2.4G strong interference detail table.

[0101] This application embodiment associates the surrounding Wi-Fi information table with the full gateway resource data and device model data through the device MAC, realizing multi-dimensional analysis of the connection quality of indoor users, which helps to improve the connection quality of users in the home environment and enhance the user experience.

[0102] In one embodiment, the step of associating the second temporary table with the at least one network operation data table based on the device MAC address in the second temporary table and the device MAC address in at least one network operation data table to obtain at least one indoor connectivity analysis table includes:

[0103] From the Wi-Fi status information table, extract the MAC addresses of devices whose number of devices connected to the router exceeds a set number, and obtain the first temporary table of router connected device details.

[0104] Based on the device MAC in the second temporary table and the device MAC corresponding to the number of router-connected devices being greater than a set number in the first temporary table of router-connected device details, the second temporary table is associated with the first temporary table of router-connected device details to obtain the second temporary table of router-connected device details;

[0105] At least one network device parameter is extracted from the second temporary table of the router's connected devices details to obtain the router's connected devices details table.

[0106] It should be noted that the Wi-Fi status information table includes fields such as the device's MAC address, 2.4GHz radio frequency band, 2.4GHz channel, 5GHz radio frequency band, 5GHz channel, 2.4GHz configured radio frequency band, 2.4GHz configured password, 5GHz configured radio frequency band, 5GHz configured maximum number of connections, and 2.4GHz load rate.

[0107] The Wi-Fi status information table is grouped by device MAC address, and records with more than 10 devices connected to the router are selected for extraction of their MAC addresses, resulting in a first temporary table detailing the router's connected devices. For example, the data table is grouped based on device MAC addresses, grouping records with the same MAC address together. Within each group, records with more than 10 devices connected to the router are selected. The MAC address values ​​are extracted from these selected records and stored in the first temporary table detailing the router's connected devices. Then, a left join is made between the second temporary table and the first temporary table detailing the router's connected devices, and the data is grouped by MAC address to obtain a second temporary table detailing the router's connected devices. The city ID, broadband account, gateway SN, device MAC address, and connected device information are retrieved from the second temporary table and stored in the corresponding detailed table.

[0108] This application embodiment associates the Wi-Fi status information table with the full gateway resource data and device model data through the device MAC, realizing multi-dimensional analysis of the connection quality of indoor users, which helps to improve the connection quality of users in the home environment and enhance the user experience.

[0109] To further explain the indoor connectivity analysis method provided in this application, please refer to... Figure 2 and the following embodiments:

[0110] This application specifically proposes a home user connection quality model design system based on big data, including a data acquisition module, a data preprocessing module, an analysis module, a monitoring module, a storage module, and a data application module. The functions of each module are as follows:

[0111] The data acquisition module is used to collect data from different networks, network topology data, etc.

[0112] The data preprocessing module is used to clean and filter the collected data, removing useless data;

[0113] The analysis module is used for data analysis and processing, such as grouping, merging, and filtering results.

[0114] The monitoring module is used to monitor whether any abnormalities occur during the processing of each module, such as whether the original data file is provided correctly and whether the acquisition module can acquire data normally.

[0115] The storage module is used to store raw data, intermediate processed data, and result data; the data application module is used to visualize the result data.

[0116] Furthermore, the data acquisition module is used to collect data on the model of the network platform equipment and the full gateway resource data of the provincial platform. The data acquisition module mainly includes the following steps:

[0117] Step A1: The provincial platform collects gateway resource data daily based on the installed plugins, and packages and uploads it to the designated FTP server;

[0118] Step A2: The network side uploads device model data, as well as uplink status data, connected device information data, Wi-Fi status information data, service monitoring data, and surrounding Wi-Fi data daily;

[0119] Step A3: By specifying a scheduled task, download the relevant files from the FTP server at a fixed time every day;

[0120] Step A4: Verify the validity of the file downloaded in step A3. If any problems are found, issue an alarm.

[0121] The data preprocessing module is used to preprocess the collected raw data, clean and filter out useless data, and standardize the content into a fixed format. The data preprocessing module mainly includes the following steps:

[0122] Step B1: Create a Hive big data database, create a gateway resource table, a device model data table, an uplink status table, a downstream device information table, a Wi-Fi status table, a service monitoring data table, and a surrounding Wi-Fi table;

[0123] Step B2: Store the data collected by the data acquisition module into the corresponding table.

[0124] The processing steps for each data point are as follows:

[0125] Preprocessing of gateway resource data:

[0126] Step B11: Decompress the downloaded ZIP file;

[0127] Step B12: Upload the decompressed files to HDFS;

[0128] Step B13: Filter invalid data: Delete data with empty information such as gateway MAC, gateway model, registration time, gateway SN, gateway manufacturer, and broadband account;

[0129] Step B14: After processing, valid full gateway resource data is obtained.

[0130] Preprocessing of equipment model data:

[0131] Step B15: Upload the downloaded device model data to HDFS;

[0132] Step B16: Filter useless data: Delete data with empty information such as broadband account, gateway SN, gateway MAC, device MAC, network registration time, and most recent active time;

[0133] Step B17: After processing, valid and complete equipment model data is obtained.

[0134] Optionally, the processing logic for uplink status information data, downlink device information data, Wi-Fi status data, service monitoring data, and surrounding Wi-Fi data is similar to that for gateway resource data and device model data.

[0135] The analysis module is used to perform analysis and processing on the data after it has been processed by the preprocessing module, such as classification, association, and merging. The analysis module mainly includes the following steps:

[0136] Step C1: Based on the uplink status information data, associate it with all device model data and all gateway resource data, and analyze and statistically obtain model data for a maximum negotiated network speed of 100 Mbps; the specific steps are as follows:

[0137] Step C11: Retrieve the following from the full device model table: gateway MAC, device MAC, broadband account, city ID, and gateway SN, to obtain temporary table T1;

[0138] Step C12: Left-join the gateway MAC value of the full gateway resource data table with the gateway MAC value of table T1 to obtain temporary table T2;

[0139] Step C13: Extract the device MAC value from the uplink status information data grouped by device MAC and with a negotiation rate of 100 Mbps, and obtain temporary table T3;

[0140] Step C14: Left join tables T2 and T3 according to device MAC values, and group them according to device MAC values ​​to obtain temporary table T4;

[0141] Step C15: Retrieve the city ID, broadband account, gateway SN, device MAC, negotiated speed, and other values ​​from table T4;

[0142] Step C16: Store the result value obtained in the previous step into the corresponding negotiation rate table.

[0143] Step C2: Based on the connected device information data, the platform device model data associated with the network, and the full gateway resource data, analyze and statistically obtain model data for weak Wi-Fi signals (e.g., below -75). The specific steps are as follows:

[0144] Step C21: Retrieve the following from the full device model table: gateway MAC, device MAC, broadband account, city ID, and gateway SN, to obtain temporary table T1;

[0145] Step C22: Left-join the gateway MAC value of the full gateway resource data table with the gateway MAC value of table T1 to obtain temporary table T2;

[0146] Step C23: Extract the device MAC value from the connected device information data by grouping the devices by MAC address and ensuring that the Wi-Fi information strength is less than -75, and obtain temporary table T3;

[0147] Step C24: Left join tables T2 and T3 according to device MAC values, and group them according to device MAC values ​​to obtain temporary table T4;

[0148] Step C25: Retrieve the city ID, broadband account, gateway SN, device MAC, Wi-Fi signal strength, and other values ​​from table T4;

[0149] Step C26: Store the result value obtained in the previous step into the corresponding Wi-Fi information strength table.

[0150] Step C3: Based on business monitoring data, platform device model data associated with the network, and full gateway resource data, analyze and statistically obtain detailed model data for access using the 2.4G frequency band; the specific steps are as follows:

[0151] Step C31: Retrieve the following from the full device model table: gateway MAC, device MAC, broadband account, city ID, and gateway SN, to obtain temporary table T1;

[0152] Step C32: Left-join the gateway MAC value of the full gateway resource data table with the gateway MAC value of table T1 to obtain temporary table T2;

[0153] Step C33: Extract the device MAC values ​​from the business monitoring data table by grouping by device MAC and the 2.4G band access details to obtain temporary table T3;

[0154] Step C34: Left join tables T2 and T3 according to device MAC values, and group them according to device MAC values ​​to obtain temporary table T4;

[0155] Step C35: Retrieve the city ID, broadband account, gateway SN, device MAC, and 2.4G band access details from table T4;

[0156] Step C36: Store the result value obtained in the previous step into the corresponding 2.4G band access details table.

[0157] Step C4: Based on surrounding Wi-Fi information data, associated network platform device model data, and full gateway resource data, analyze and statistically obtain detailed model data of 2.4G strong interference; the specific steps are as follows:

[0158] Step C41: Retrieve the following from the full device model table: gateway MAC, device MAC, broadband account, city ID, and gateway SN, to obtain temporary table T1;

[0159] Step C42: Left-join the gateway MAC value of the full gateway resource data table with the gateway MAC value of table T1 to obtain temporary table T2;

[0160] Step C43: Extract the device MAC value from the surrounding Wi-Fi information data according to device MAC group and 2.4G strong interference details to obtain temporary table T3;

[0161] Step C44: Left join tables T2 and T3 according to device MAC values, and group them according to device MAC values ​​to obtain temporary table T4;

[0162] Step C45: Retrieve the city ID, broadband account, gateway SN, device MAC, and 2.4G strong interference details from table T4;

[0163] Step C46: Store the result value obtained in the previous step into the corresponding 2.4G strong interference details table.

[0164] Step C5: Based on the Wi-Fi status information data, the associated platform device model data, and the full gateway resource data, analyze and statistically obtain detailed model data for router-connected devices (e.g., more than 10). The specific steps are as follows:

[0165] Step C51: Retrieve the following from the full device model table: gateway MAC, device MAC, broadband account, city ID, and gateway SN, to obtain temporary table T1;

[0166] Step C52: Left-join the gateway MAC value of the full gateway resource data table with the gateway MAC value of table T1 to obtain temporary table T2;

[0167] Step C53: From the surrounding Wi-Fi information data, group the devices by MAC address and ensure that there are more than 10 devices connected to the router, extract the device MAC values, and obtain temporary table T3;

[0168] Step C54: Left join tables T2 and T3 according to device MAC values, and group them according to device MAC values ​​to obtain temporary table T4;

[0169] Step C55: Retrieve the values ​​of city ID, broadband account, gateway SN, device MAC, and router-connected devices from table T4;

[0170] Step C56: Store the result value obtained in the previous step into the corresponding router connected device details table.

[0171] The monitoring module is used to monitor the integrity of the collected data, the correctness of the data processing, and the accuracy of the analysis results. It mainly includes the following monitoring information:

[0172] Step D1: Monitor whether the source data has uploaded the correct data file within a fixed time period, and whether the data file size, number of rows, and other indicators are correct. If any one of the requirements is not met, an early warning signal will be issued and timely action will be taken.

[0173] Step D2: The data acquisition module determines whether to collect the specified data into the corresponding data table and issues an early warning signal when an abnormality occurs during the acquisition process.

[0174] Step D3: The analysis module checks whether it correctly produces analysis results and stores them in the corresponding result table. When the analysis results are incorrect or the data in the result table is faulty, a warning signal is issued in a timely manner.

[0175] The storage module is used to store intermediate data processed by each module, as well as the final result data, and mainly includes:

[0176] E1: Full list of equipment models;

[0177] E2: Full gateway resource data table;

[0178] E3: The original table containing uplink status data, connected device information data, Wi-Fi status data, service monitoring data, and surrounding Wi-Fi data;

[0179] E4: A preprocessed table containing uplink status data, connected device information data, Wi-Fi status data, service monitoring data, and surrounding Wi-Fi data;

[0180] E5: Results table for the following conditions: maximum negotiated network speed of 100 Mbps, weak Wi-Fi signal (e.g., below -75), access using 2.4G frequency band, strong 2.4G interference, and a large number of devices connected to the router (e.g., more than 10).

[0181] The data application module is used to display the final result data, such as in the form of visual reports, real-time interfaces, and external output files.

[0182] This application provides distributed processing capabilities, aggregates multiple data sources, and enables multi-dimensional analysis of in-home user connection quality; it supports scalability, supports the access of data from other dimensions, and increases the dimensions of analysis; it identifies business shortcomings by visually displaying the in-home user connection status, and helps optimize the in-home user connection quality.

[0183] The indoor connectivity analysis device provided in the embodiments of this application is described below. The indoor connectivity analysis device described below and the indoor connectivity analysis method described above can be referred to in correspondence.

[0184] refer to Figure 3 , Figure 3 This is a schematic diagram of the indoor connectivity analysis device provided in this application embodiment. The indoor connectivity analysis device provided in this application embodiment includes a data acquisition module 301, an extraction module 302, an association module 303, and an analysis module 304.

[0185] The data acquisition module 301 is used to collect full gateway resource data and network device model data.

[0186] Extraction module 302 is used to extract at least one network device parameter from the device model data to form a first temporary table;

[0187] The association module 303 is used to associate the gateway MAC in the first temporary table with the gateway MAC of the full gateway resource data to obtain a second temporary table;

[0188] Analysis module 304 is used to associate the second temporary table with the at least one network operation data table based on the device MAC in the second temporary table and the device MAC in at least one network operation data table to obtain at least one indoor connection status analysis table.

[0189] The indoor connectivity analysis device provided in this application collects full gateway resource data and network device model data; extracts at least one network device parameter from the device model data to form a first temporary table; associates the gateway MAC addresses in the first temporary table with the gateway MAC addresses in the full gateway resource data to obtain a second temporary table; based on the device MAC addresses in the second temporary table and at least one device MAC address in a network operation data table, associates the second temporary table with at least one network operation data table to obtain at least one indoor connectivity analysis table. This application groups and associates various data tables by MAC values ​​to obtain detailed tables reflecting network quality, realizing multi-dimensional analysis of indoor user connectivity quality, which helps improve user connectivity quality in the home environment and enhance user experience.

[0190] In one embodiment, the network operation data table includes an uplink status information table, and the indoor connection status analysis table includes a negotiation rate table; the analysis module 304 is specifically used for:

[0191] From the uplink status information table, extract the device MAC corresponding to the negotiated rate of the set rate to obtain the first temporary table of the negotiated rate;

[0192] Based on the device MAC in the second temporary table and the device MAC in the first temporary table of negotiation rate corresponding to the set rate, the second temporary table is associated with the first temporary table of negotiation rate to obtain the second temporary table of negotiation rate;

[0193] At least one network device parameter is extracted from the second temporary table of the negotiated rate to obtain the negotiated rate table.

[0194] In one embodiment, the network operation data table includes a downstream device information table, and the indoor connectivity analysis table includes a Wi-Fi signal strength table; the analysis module 304 is specifically used for:

[0195] From the attached device information table, extract the MAC addresses of devices with Wi-Fi strength less than a set strength to obtain a first temporary table of Wi-Fi information strength;

[0196] Based on the device MAC in the second temporary table and the device MAC in the first temporary table of Wi-Fi strength that is less than a set strength, the second temporary table is associated with the first temporary table of Wi-Fi strength to obtain the second temporary table of Wi-Fi strength;

[0197] At least one network device parameter is extracted from the second temporary table of Wi-Fi information strength to obtain the Wi-Fi information strength table.

[0198] In one embodiment, the network operation data table includes a service monitoring data table, and the indoor connectivity analysis table includes a 2.4G band access details table; the analysis module 304 is specifically used for:

[0199] From the aforementioned business monitoring data table, based on the MAC address of the 2.4G band access information extraction device, a first temporary table of 2.4G band access details is obtained;

[0200] Based on the device MAC in the second temporary table and the device MAC extracted from the 2.4G band access information in the first temporary table of 2.4G band access details, the second temporary table is associated with the first temporary table of 2.4G band access details to obtain the second temporary table of 2.4G band access details.

[0201] At least one network device parameter is extracted from the second temporary table of the 2.4G band access details to obtain the 2.4G band access details table.

[0202] In one embodiment, the network operation data table includes a surrounding Wi-Fi information table, and the indoor connectivity analysis table includes a 2.4G strong interference details table; the analysis module 304 is specifically used for:

[0203] From the surrounding Wi-Fi information table, based on the MAC address of the 2.4G strong interference information extraction device, a first temporary table of 2.4G strong interference details is obtained;

[0204] Based on the device MAC in the second temporary table and the device MAC extracted from the 2.4G strong interference information in the first temporary table of 2.4G strong interference details, the second temporary table is associated with the first temporary table of 2.4G strong interference details to obtain the second temporary table of 2.4G strong interference details.

[0205] At least one network device parameter is extracted from the second temporary table of the 2.4G strong interference details to obtain the 2.4G strong interference details table.

[0206] In one embodiment, the network operation data table includes a Wi-Fi status information table, and the indoor connection analysis table includes a router-connected device details table; the analysis module 304 is specifically used for:

[0207] From the Wi-Fi status information table, extract the MAC addresses of devices whose number of devices connected to the router exceeds a set number, and obtain the first temporary table of router connected device details.

[0208] Based on the device MAC in the second temporary table and the device MAC corresponding to the number of router-connected devices being greater than a set number in the first temporary table of router-connected device details, the second temporary table is associated with the first temporary table of router-connected device details to obtain the second temporary table of router-connected device details;

[0209] At least one network device parameter is extracted from the second temporary table of the router's connected devices details to obtain the router's connected devices details table.

[0210] In one embodiment, the analysis module 304 is further configured to:

[0211] The indoor connectivity analysis table is visualized using a predefined display method.

[0212] Figure 4 An example is a schematic diagram of the physical structure of an electronic device, such as... Figure 4 As shown, the electronic device may include: a processor 410, a communication interface 420, a memory 430, and a communication bus 440, wherein the processor 410, the communication interface 420, and the memory 430 communicate with each other via the communication bus 440. The processor 410 can call a computer program in the memory 430 to execute the steps of the indoor connectivity analysis method, such as including:

[0213] Collect all gateway resource data and network device model data;

[0214] Extract at least one network device parameter from the device model data to form a first temporary table;

[0215] Associate the gateway MAC in the first temporary table with the gateway MAC of the full gateway resource data to obtain the second temporary table;

[0216] Based on the device MAC addresses in the second temporary table and the device MAC addresses in at least one network operation data table, the second temporary table is associated with the at least one network operation data table to obtain at least one indoor connection status analysis table.

[0217] Furthermore, the logical instructions in the aforementioned memory 430 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this application. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0218] On the other hand, embodiments of this application also provide a non-transitory computer-readable storage medium storing a computer program thereon. When executed by a processor, the computer program implements the steps of the indoor connectivity analysis method provided in the above embodiments, including, for example:

[0219] Collect all gateway resource data and network device model data;

[0220] Extract at least one network device parameter from the device model data to form a first temporary table;

[0221] Associate the gateway MAC in the first temporary table with the gateway MAC of the full gateway resource data to obtain the second temporary table;

[0222] Based on the device MAC addresses in the second temporary table and the device MAC addresses in at least one network operation data table, the second temporary table is associated with the at least one network operation data table to obtain at least one indoor connection status analysis table.

[0223] On the other hand, this application also provides a computer program product, which includes a computer program that can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can perform the steps of the indoor connectivity analysis method provided in the above embodiments, such as including:

[0224] Collect all gateway resource data and network device model data;

[0225] Extract at least one network device parameter from the device model data to form a first temporary table;

[0226] Associate the gateway MAC in the first temporary table with the gateway MAC of the full gateway resource data to obtain the second temporary table;

[0227] Based on the device MAC addresses in the second temporary table and the device MAC addresses in at least one network operation data table, the second temporary table is associated with the at least one network operation data table to obtain at least one indoor connection status analysis table.

[0228] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0229] Through the above description of the embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus necessary general-purpose hardware platforms, and of course, it can also be implemented by hardware. Based on this understanding, the above technical solutions, in essence or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute the methods described in the various embodiments or some parts of the embodiments.

[0230] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of this application.

Claims

1. A method for analyzing indoor connectivity, characterized in that, include: Collect all gateway resource data and network device model data; Extract at least one network device parameter from the device model data to form a first temporary table; Associate the gateway MAC in the first temporary table with the gateway MAC of the full gateway resource data to obtain the second temporary table; Based on the device MAC addresses in the second temporary table and the device MAC addresses in at least one network operation data table, the second temporary table is associated with the at least one network operation data table to obtain at least one indoor connection status analysis table.

2. The method for analyzing indoor connectivity according to claim 1, characterized in that, The network operation data table includes an uplink status information table, and the indoor connection status analysis table includes a negotiation rate table. The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including: From the uplink status information table, extract the device MAC corresponding to the negotiated rate of the set rate to obtain the first temporary table of the negotiated rate; Based on the device MAC in the second temporary table and the device MAC in the first temporary table of negotiation rate corresponding to the set rate, the second temporary table is associated with the first temporary table of negotiation rate to obtain the second temporary table of negotiation rate; At least one network device parameter is extracted from the second temporary table of the negotiated rate to obtain the negotiated rate table.

3. The method for analyzing indoor connectivity according to claim 1, characterized in that, The network operation data table includes a downstream device information table, and the indoor connection status analysis table includes a Wi-Fi information strength table. The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including: From the attached device information table, extract the MAC addresses of devices with Wi-Fi strength less than a set strength to obtain a first temporary table of Wi-Fi information strength; Based on the device MAC in the second temporary table and the device MAC in the first temporary table of Wi-Fi strength that is less than a set strength, the second temporary table is associated with the first temporary table of Wi-Fi strength to obtain the second temporary table of Wi-Fi strength; At least one network device parameter is extracted from the second temporary table of Wi-Fi information strength to obtain the Wi-Fi information strength table.

4. The method for analyzing indoor connectivity according to claim 1, characterized in that, The network operation data table includes a service monitoring data table, and the indoor connection status analysis table includes a 2.4G band access details table. The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including: From the aforementioned business monitoring data table, based on the MAC address of the 2.4G band access information extraction device, a first temporary table of 2.4G band access details is obtained; Based on the device MAC in the second temporary table and the device MAC extracted from the 2.4G band access information in the first temporary table of 2.4G band access details, the second temporary table is associated with the first temporary table of 2.4G band access details to obtain the second temporary table of 2.4G band access details. At least one network device parameter is extracted from the second temporary table of the 2.4G band access details to obtain the 2.4G band access details table.

5. The method for analyzing indoor connectivity according to claim 1, characterized in that, The network operation data table includes a surrounding Wi-Fi information table, and the indoor connection analysis table includes a 2.4G strong interference details table; The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including: From the surrounding Wi-Fi information table, based on the MAC address of the 2.4G strong interference information extraction device, a first temporary table of 2.4G strong interference details is obtained; Based on the device MAC in the second temporary table and the device MAC extracted from the 2.4G strong interference information in the first temporary table of 2.4G strong interference details, the second temporary table is associated with the first temporary table of 2.4G strong interference details to obtain the second temporary table of 2.4G strong interference details. At least one network device parameter is extracted from the second temporary table of the 2.4G strong interference details to obtain the 2.4G strong interference details table.

6. The method for analyzing indoor connectivity according to claim 1, characterized in that, The network operation data table includes a Wi-Fi status information table, and the indoor connection status analysis table includes a router connected device details table. The process involves associating the second temporary table with the device MAC addresses in at least one network operation data table, based on the device MAC addresses in the second temporary table, to obtain at least one indoor connectivity analysis table, including: From the Wi-Fi status information table, extract the MAC addresses of devices whose number of devices connected to the router exceeds a set number, and obtain the first temporary table of router connected device details. Based on the device MAC in the second temporary table and the device MAC corresponding to the number of router-connected devices being greater than a set number in the first temporary table of router-connected device details, the second temporary table is associated with the first temporary table of router-connected device details to obtain the second temporary table of router-connected device details; At least one network device parameter is extracted from the second temporary table of the router's connected devices details to obtain the router's connected devices details table.

7. The method for analyzing indoor connectivity according to claim 1, characterized in that, After associating the second temporary table with the at least one network operation data table based on the device MAC address in the second temporary table and the device MAC address in at least one network operation data table to obtain at least one indoor connectivity analysis table, the method further includes: The indoor connectivity analysis table is visualized using a predefined display method.

8. An indoor connectivity analysis device, characterized in that, include: The data acquisition module is used to collect full gateway resource data and network device model data; The extraction module is used to extract at least one network device parameter from the device model data to form a first temporary table; The association module is used to associate the gateway MAC in the first temporary table with the gateway MAC of the full gateway resource data to obtain a second temporary table; The analysis module is used to associate the second temporary table with the at least one network operation data table based on the device MAC in the second temporary table and the device MAC in at least one network operation data table to obtain at least one indoor connection status analysis table.

9. An electronic device comprising a processor and a memory storing a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the indoor connectivity analysis method according to any one of claims 1 to 7.

10. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the indoor connectivity analysis method according to any one of claims 1 to 7.

Images