A method and device for acquiring network quality information of a home mobile phone signal of a user

Abstract

The application provides a user home mobile phone signal network quality information acquisition method and device, electronic equipment and computer program product, and relates to the technical field of data analysis. The method comprises the following steps: based on the broadband network signaling service data and the wireless network MDT measurement report in a target area, obtaining the home gateway data under each broadband user account and the user resident base station cell information, extracting the mobile phone user online information under each broadband user account, and calculating the home online time period information of each mobile phone user; obtaining the MDT data of each mobile phone user in the corresponding home online time period; and combining the MDT data and the location information of the broadband user account, obtaining the user home mobile phone signal network quality information of the target area. The application can quickly and accurately determine the home online time period of the user, so as to accurately and efficiently obtain the real situation of the user home mobile phone signal quality.

Description

Technical Field

[0001] This application relates to the field of data analysis technology, specifically to a method, device, electronic device, and computer program product for obtaining mobile phone signal network quality information at a user's home. Background Technology

[0002] With the increasing penetration rate of mobile phones and the rapid development of urban construction, customers' requirements for network coverage are also constantly increasing. Whether it is the addition of new sites to the network, changes in the wireless environment, or the relocation and decommissioning of base stations, all will affect network coverage. The quality of network coverage has become the primary factor in users' perception of the network quality of various operators. Complaints about weak network coverage rank first among network quality complaints. For operators, how to promptly and accurately identify weak coverage areas and quickly and effectively resolve weak coverage has gradually become one of the most critical and challenging issues affecting customers' network quality experience.

[0003] However, the most severe weak coverage by operators is in residential areas. The solution for residential coverage involves planning and optimization personnel analyzing user MR and MDT data, such as gridded MR or MDT signal coverage, or on-site testing by technicians, to plan and construct coverage for residential areas. This solution only addresses the overall picture; it cannot accurately obtain the signal coverage at specific points (such as residents' homes). Tracking individual users' MR or MDT data is impractical because it's impossible to determine when a user is home. Communicating with and tracking each user is also impractical.

[0004] The common approach to address this is to combine customer complaints with proactive testing to identify weak coverage and poor signal quality in homes. However, this approach has drawbacks such as delayed detection and high costs, and poses a potential source of complaints. Furthermore, the data obtained is not always accurate, as users' verbal feedback lacks supporting data. The test data from operators' technicians differs from users' actual perceptions in three ways: the test terminals used are different, the test times are different, and the test locations are different (test data from doorways and hallways). Consequently, the test data cannot accurately reflect the true state of users' mobile phone signals.

[0005] Therefore, there is an urgent need for a method that can accurately and efficiently obtain the true situation of mobile phone signal quality at users' homes. Summary of the Invention

[0006] This application provides a method, apparatus, electronic device, and computer program product for obtaining mobile phone signal network quality information at a user's home, which can accurately and efficiently obtain the true situation of mobile phone signal quality at a user's home.

[0007] In a first aspect, embodiments of this application provide a method for obtaining mobile phone signal network quality information at a user's residence, including:

[0008] Based on broadband network signaling service data and wireless network MDT measurement reports within the target area, the home gateway data and user camping base station cell information under each broadband user account are obtained, the mobile phone user internet access information under each broadband user account is extracted, and the home internet access time information of each mobile phone user is calculated.

[0009] The MDT data of each mobile phone user during the corresponding home internet access time period is obtained by association;

[0010] By combining the MDT data and the location information of the broadband user account, the mobile signal network quality information of the user's residence in the target area is obtained.

[0011] In one embodiment, the process of obtaining home gateway data and user-hosted base station cell information under each broadband user account based on broadband network signaling service data and wireless network MDT measurement reports within the target area, extracting mobile phone user internet access information under each broadband user account, and calculating the home internet access time information of each mobile phone user includes:

[0012] For each broadband user account, the time period with the most mobile terminals connected to the home gateway is determined based on the home gateway data as the suspected home internet access time period of the first mobile user corresponding to the broadband user account. The home address and location information of the first mobile user are obtained from the broadband network database. The cell information of the user's base station is obtained from the wireless network MDT measurement report. The suspected home internet access time period is filtered based on the home address and cell information of the first mobile user to determine the home internet access time period of the first mobile user.

[0013] Based on broadband DPI service data, obtain the mobile phone user internet access information under the broadband user account, convert the time series in the mobile phone user internet access information into time periods, and obtain the home internet access time periods of multiple associated mobile phone users under the broadband user account.

[0014] The home internet access time periods of the first mobile phone user and the home internet access time periods of the multiple associated mobile phone users are merged to obtain the home internet access time period information of each mobile phone user.

[0015] In one embodiment, for each broadband user account, the time period with the most mobile terminals connected to the home gateway is determined based on the home gateway data as the suspected home internet access time period of the first mobile user corresponding to the broadband user account. The home address and location information of the first mobile user are obtained from the broadband network database, and the user's base station cell information is obtained from the wireless network MDT measurement report. The suspected home internet access time period is then filtered based on the first mobile user's home address and base station cell information to determine the first mobile user's home internet access time period, including:

[0016] For each broadband user account, the time period with the most mobile phone users connected to the home gateway of the broadband user account is determined as the suspected home internet access time period of the first mobile phone user based on the home gateway data.

[0017] Based on the MDT records of the first mobile phone user during the suspected home internet access period, obtain the base station cell where the first mobile phone user camped during the suspected home internet access period.

[0018] The home address and location information of the first mobile phone user are obtained from the broadband network database. The distance between each base station cell and the home address of the first mobile phone user is calculated. Based on a preset distance threshold, the MDT records corresponding to the base station cells that are outside the preset range of the home address of the first mobile phone user are deleted.

[0019] The above process is repeated within a preset continuous period. MDT records corresponding to the base station cells that recur less than a preset threshold are deleted. The home internet access time period of the first mobile phone user is determined based on the access time period corresponding to the retained MDT records.

[0020] In one embodiment, the step of obtaining mobile phone user internet access information under the broadband user account based on broadband DPI service data, converting the time series in the mobile phone user internet access information into time periods, and obtaining the home internet access time periods of multiple associated mobile phone users under the broadband user account includes:

[0021] Based on broadband DPI service data, obtain the internet access records of mobile terminals with suspected mobile phone numbers under the broadband user account, and filter out target internet access records that meet the preset internet access characteristics from the mobile terminal internet access records;

[0022] The target internet access records are categorized by mobile phone number and sorted by timestamp. Target internet access records with timestamps less than a preset time threshold are connected as a single segment to generate an associated mobile user internet access record information table for the broadband user account.

[0023] Based on the associated mobile phone user internet access record information table, the home internet access time periods of multiple associated mobile phone users of the broadband user account are obtained.

[0024] In one embodiment, the step of obtaining internet access records of mobile terminals with suspected mobile phone numbers under the broadband user account based on broadband DPI service data, and filtering target internet access records that meet preset internet access characteristic conditions from the mobile terminal internet access records, includes:

[0025] Based on broadband DPI service data, obtain the internet access records of mobile terminals with suspected mobile phone numbers under the broadband user account;

[0026] Target internet access records that meet preset internet access characteristics are selected from the internet access records of the mobile terminal; wherein, when it is determined that the internet access record of the mobile terminal contains preset keywords and the preset keywords are connected to a suspected mobile phone number, the internet access record of the mobile terminal is determined to be a target internet access record that meets the preset internet access characteristics.

[0027] In one embodiment, obtaining the mobile network quality information of the user's residence in the target area by combining the MDT data and the location information of the broadband user account includes:

[0028] By combining the MDT data and the location information of the broadband user account, a user home mobile phone signal status table corresponding to each broadband user account in the target area is obtained; wherein, each user home mobile phone signal status table includes signal strength information and signal quality information of multiple service cells;

[0029] By summarizing the mobile phone signal status tables of all users' residences, the network quality information of mobile phone signals in the target area can be obtained.

[0030] In one embodiment, the method for obtaining user home mobile signal network quality information further includes:

[0031] For the same serving cell in each user's home mobile phone signal status table, multiple signal strength measurements and multiple signal quality measurements of different mobile phone users in that serving cell are obtained based on the MDT data.

[0032] The first average value and the second average value are obtained by averaging the multiple signal strength measurements and the multiple signal quality measurements, respectively.

[0033] The first average value is used as the signal strength information of the serving cell, and the second average value is used as the signal quality information of the serving cell.

[0034] Secondly, embodiments of this application provide a device for acquiring mobile phone signal network quality information at a user's residence, comprising:

[0035] The home time period acquisition module is used to acquire home gateway data and user camping base station cell information under each broadband user account based on broadband network signaling service data and wireless network MDT measurement reports in the target area, extract mobile phone user internet access information under each broadband user account, and calculate the home internet access time period information of each mobile phone user.

[0036] The MDT data association module is used to associate and obtain the MDT data of each mobile phone user during the corresponding home internet access time period.

[0037] The signal quality acquisition module is used to combine the MDT data and the location information of the broadband user account to obtain the mobile network signal quality information of the user's home in the target area.

[0038] 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 method for obtaining user home mobile phone signal network quality information as described in the first aspect.

[0039] Fourthly, embodiments of this application provide a computer program product, including a computer program that, when executed by a processor, implements the steps of the method for obtaining user home mobile phone signal network quality information as described in the first aspect.

[0040] The method, apparatus, electronic device, and computer program product for obtaining user home mobile signal network quality information provided in this application accurately obtain the corresponding mobile phone user's home internet access time based on broadband user account internet access data, and correlate it with the corresponding mobile phone user's MDT data during their home internet access time. Then, by combining the location information of each broadband account and the corresponding mobile phone user's MDT data, the user's home mobile signal network quality information in the target area is obtained. This application embodiment can quickly and accurately determine the user's home internet access time, thereby accurately and efficiently obtaining the true situation of the user's home mobile signal quality. Attached Figure Description

[0041] 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.

[0042] Figure 1This is one of the flowcharts illustrating the method for obtaining user home mobile signal network quality information provided in this application embodiment;

[0043] Figure 2 This is one of the structural schematic diagrams of the user's home mobile phone signal network quality information acquisition device provided in the embodiments of this application;

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

[0045] 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.

[0046] Figure 1 This is a flowchart illustrating the method for obtaining mobile network signal quality information at a user's home. (Refer to...) Figure 1 This application provides a method for obtaining mobile network signal quality information at a user's home, which may include the following steps:

[0047] S1. Based on broadband network signaling service data and wireless network MDT measurement reports within the target area, obtain home gateway data and user-hosted base station cell information under each broadband user account, extract mobile phone user internet access information under each broadband user account, and calculate the home internet access time information of each mobile phone user.

[0048] S2. Retrieve the MDT data of each mobile phone user during the corresponding home internet access time period;

[0049] S3. By combining the MDT data and the location information of the broadband user account, the mobile phone signal network quality information of the user's residence in the target area is obtained.

[0050] In this embodiment of the application, the internet access data of all broadband user accounts in a certain region (target area) is first obtained. Based on this internet access data, the home internet access time of the corresponding mobile phone users can be determined. For example, based on the internet access data of a certain broadband user account, each mobile terminal connected to the WiFi network of the broadband gateway can be obtained, and the specific internet access time of each mobile terminal can be obtained, that is, the home internet access time of each mobile phone user.

[0051] Then, for each mobile phone user, based on their mobile phone number and time window (home internet access time), the corresponding MDT data can be retrieved. Data parsing of this MDT data can generate user home mobile network signal quality information containing parameters such as timestamp, MME UES1AP ID, serving cell ID, serving cell PCI, serving cell frequency, serving cell RSRP (Reference Signal Receiving Power), serving cell RSRQ (Reference Signal Receiving Quality), UE longitude, UE latitude, and UE altitude.

[0052] Then, by associating the broadband user account, its location information, and mobile signal network quality information, the mobile signal network quality information for each broadband user account in the target area can be obtained. It should be noted that the location information for the broadband user account can initially be the home address provided when applying for broadband installation, and then updated using the average value calculated from the UE's longitude, latitude, and altitude for each service cell.

[0053] The method for obtaining home mobile phone signal network quality information provided in this application accurately obtains the time period of home internet access for corresponding mobile phone users based on the internet access data of broadband user accounts, and correlates it with the MDT data of the corresponding mobile phone users during their home internet access time. Then, by combining the location information of each broadband account and the corresponding mobile phone user's MDT data, the home mobile phone signal network quality of the user in the target area is obtained. This application embodiment can quickly and accurately determine the user's home internet access time, thereby accurately and efficiently obtaining the true situation of the user's home mobile phone signal quality.

[0054] In one embodiment, step S2 may include the following steps:

[0055] S21. For each broadband user account, the time period with the most mobile terminals connected to the home gateway is determined based on the home gateway data as the suspected home internet access time period of the first mobile user corresponding to the broadband user account. The home address and location information of the first mobile user are obtained from the broadband network database. The cell information of the user's base station is obtained from the wireless network MDT measurement report. The suspected home internet access time period is filtered based on the home address and cell information of the first mobile user to determine the home internet access time period of the first mobile user.

[0056] S22. Obtain the mobile phone user internet access information under the broadband user account based on the broadband DPI service data, convert the time series in the mobile phone user internet access information into time periods, and obtain the home internet access time periods of multiple associated mobile phone users under the broadband user account.

[0057] S23. The home internet access time of the first mobile phone user and the home internet access time of the multiple associated mobile phone users are merged to obtain the home internet access time information of each mobile phone user.

[0058] In this embodiment, the home internet access time periods for each mobile phone user under each broadband user account can be obtained from two aspects: 1. Based on internet access data, the suspected home internet access time periods of the first mobile phone user corresponding to the broadband user account can be obtained (e.g., the time periods when the first mobile phone user accesses the internet via the broadband account's Wi-Fi). Then, based on the distance between the mobile phone user's MDT (Multi-Demand Detection) cell and the corresponding residential address, the time periods corresponding to cells outside the preset range are filtered to determine the first mobile phone user's home internet access time periods; 2. Based on broadband DPI (Digital Per Pixel) service data, the internet access records of all mobile terminals (associated mobile phone users) connected to the broadband user account can be obtained. By converting the time series of these internet access records into time period information, the home internet access time periods of multiple associated mobile phone users are obtained. Then, the home internet access time periods obtained by the above two methods are merged to obtain the home internet access time periods of each mobile phone user under the broadband user account.

[0059] The method for obtaining home mobile signal network quality information provided in this application combines two methods to obtain the home internet access time of each mobile phone user under the broadband user account, thereby obtaining the home internet access time of the mobile phone user more comprehensively and accurately, and further improving the accuracy of obtaining the true situation of home mobile signal quality.

[0060] In one embodiment, step S21 may include the following steps:

[0061] S211. For each broadband user account, the time period with the most mobile phone users connected to the home gateway of the broadband user account is determined as the suspected home internet access time period of the first mobile phone user based on the home gateway data.

[0062] S212. Based on the MDT records of the first mobile phone user during the suspected home internet access period, obtain the base station cell where the first mobile phone user camped during the suspected home internet access period.

[0063] S213. Obtain the home address and location information of the first mobile phone user from the broadband network database, calculate the distance between each of the base station cells and the home address of the first mobile phone user, and delete the MDT records corresponding to the base station cells that are outside the preset range of the home address of the first mobile phone user based on a preset distance threshold.

[0064] S214. Repeat the above process within a preset continuous period, delete the MDT records corresponding to the base station cells that recur less than a preset threshold, and determine the home internet access time of the first mobile phone user based on the access time period corresponding to the retained MDT records.

[0065] In this embodiment of the application, the first method for obtaining the home internet access time of a mobile phone user adopts the steps S211-S214 described above. Specifically, the time period with the most mobile phone users connected to the home gateway of the broadband user account is first determined as the suspected home internet access time of the first mobile phone user; then, the corresponding MDT record of the first mobile phone user is obtained based on the suspected home internet access time, and the base station cell where the mobile phone user is camped during this time period can be obtained; then, the distance between each base station cell and the mobile phone user's home address is calculated to see if it is within a preset range, and base station cells that do not meet the conditions are filtered out; then, the above process is repeated within a preset continuous period (such as one week), and the MDT records corresponding to base station cells that appear less than a preset threshold (such as less than three times) are deleted; finally, the home internet access time of the first mobile phone user is determined based on the access time period of the MDT records corresponding to the retained base station cells.

[0066] The method for obtaining user home mobile phone signal network quality information provided in this application embodiment utilizes the user's station base station cell to further filter suspected home internet access time periods, thereby further improving the accuracy of the obtained mobile phone user home internet access time periods and thus improving the accuracy of obtaining the true situation of user home mobile phone signal quality.

[0067] In one embodiment, step S22 may include the following steps:

[0068] S221. Obtain the internet access records of mobile terminals with suspected mobile phone numbers under the broadband user account based on the broadband DPI service data, and filter out the target internet access records that meet the preset internet access characteristic conditions from the mobile terminal internet access records.

[0069] S222. Classify the target internet access records based on mobile phone numbers and sort them by timestamps. Connect the target internet access records whose timestamps are less than a preset time threshold to form a segment, and generate an associated mobile phone user internet access record information table for the broadband user account.

[0070] S223. Obtain the home internet access time periods of multiple associated mobile phone users of the broadband user account based on the associated mobile phone user internet access record information table.

[0071] In this embodiment, the second method for obtaining the home internet access time of mobile phone users adopts the steps S221-S223 described above. Specifically, firstly, based on broadband DPI service data, the internet access records of mobile terminals with suspected mobile phone numbers under the broadband user account are obtained. The matching rules for suspected mobile phone numbers may include: Rule 1: judging by sorting through the operator's mobile phone number segments, or Rule 2: the mobile phone number feature value is a consecutive 11 digits starting with 1; then, these internet access records are filtered according to preset internet access feature conditions; then, these internet access records are categorized by mobile phone number, and then multiple internet access records of the same mobile phone number are sorted according to timestamps, and then timestamps less than a preset threshold between each pair of internet access records are connected to form a time period, thereby generating an internet access record information table for multiple associated mobile phone users corresponding to each broadband user account, and thus obtaining the home internet access time of multiple associated mobile phone users of the broadband user account.

[0072] The method for obtaining home mobile phone signal network quality information provided in this application improves the accuracy of the obtained home mobile phone user internet time periods by classifying and filtering internet access records to identify multiple associated mobile phone users under each broadband user account, thereby improving the accuracy of obtaining the true situation of home mobile phone signal quality.

[0073] In one embodiment, step S221 may include:

[0074] Based on broadband DPI service data, obtain the internet access records of mobile terminals with suspected mobile phone numbers under the broadband user account;

[0075] Target internet access records that meet preset internet access characteristics are selected from the internet access records of the mobile terminal; wherein, when it is determined that the internet access record of the mobile terminal contains preset keywords and the preset keywords are connected to a suspected mobile phone number, the internet access record of the mobile terminal is determined to be a target internet access record that meets the preset internet access characteristics.

[0076] In this embodiment, when filtering target internet access records that meet preset internet access characteristics, the preset internet access characteristics can be set to include certain preset keywords followed by corresponding suspected mobile phone numbers. By using preset keywords and rules for combining numbers to filter internet access records that do not meet the conditions, interference from irrelevant internet access records is effectively reduced, thereby further improving the accuracy of obtaining the time period of mobile phone users' home internet access, and thus improving the accuracy of obtaining the true situation of mobile phone signal quality at users' homes.

[0077] In one embodiment, step S3 may include:

[0078] By combining the MDT data and the location information of the broadband user account, a user home mobile phone signal status table corresponding to each broadband user account in the target area is obtained; wherein, each user home mobile phone signal status table includes signal strength information and signal quality information of multiple service cells;

[0079] By summarizing the mobile phone signal status tables of all users' residences, the network quality information of mobile phone signals in the target area can be obtained.

[0080] In this embodiment of the application, it is understood that a residential address corresponding to a broadband account may be covered by multiple service cells. Therefore, the mobile phone signal status table for each broadband user account corresponds to the signal strength and signal quality information of multiple service cells. After obtaining the mobile phone signal status tables for each broadband user account (one broadband user account corresponds to multiple service cells), all mobile phone signal status tables are summarized to obtain the mobile phone signal network quality information for the target area.

[0081] The method for obtaining mobile phone signal network quality information at a user's residence provided in this application subdivides the signal network information under each broadband user account into multiple service cells, which can reflect the signal network situation of the corresponding location at a finer granularity, making it easier for network optimization personnel to carry out signal coverage optimization work in the area in a more targeted manner.

[0082] In one embodiment, the method for obtaining user home mobile signal network quality information further includes:

[0083] For the same serving cell in each user's home mobile phone signal status table, multiple signal strength measurements and multiple signal quality measurements of different mobile phone users in that serving cell are obtained based on the MDT data.

[0084] The first average value and the second average value are obtained by averaging the multiple signal strength measurements and the multiple signal quality measurements, respectively.

[0085] The first average value is used as the signal strength information of the serving cell, and the second average value is used as the signal quality information of the serving cell.

[0086] In this embodiment of the application, for the same serving cell in each user's home mobile phone signal status table, the average of multiple measured signal values ​​of different mobile phone users in that serving cell is used as the corresponding signal coverage information, thereby effectively improving the accuracy of obtaining user's home mobile phone signal network quality information.

[0087] Based on the above solution, and to facilitate a better understanding of the method for obtaining user home mobile phone signal network quality information provided in this application embodiment, the following detailed explanation is provided:

[0088] It should be noted that the prior art mentioned in the background section has the following problems:

[0089] 1. Discovering poor signal or signal quality at a user's home through user complaints is delayed and reactive, potentially leading to further complaints.

[0090] 2. Conducting comprehensive tests to determine the signal quality of users' homes is labor-intensive and costly; entering users' homes for testing is difficult (except for a few users who allow it), so test data from the doorway or surrounding area can only be used as a substitute, and even if you do enter the home, you cannot test every room; the test terminal may be different from the client's terminal, and the network load will vary depending on the test time, so it cannot reflect the user's true perception.

[0091] 3. Tracking a user's MR or MDT data individually is impractical because it is impossible to determine when the user was at home. It is also impossible to recreate the user's situation at that time.

[0092] 4. Requiring each user to test and report is impractical.

[0093] To address the aforementioned technical problems, this application provides a method for obtaining mobile phone signal network quality information at a user's residence. This method integrates broadband network signaling service data, wireless network MDT measurement reports, and wireless signaling data for analysis. It analyzes data collected by the IHGU soft probe from the home gateway, the distance range between the broadband user's corresponding mobile terminal MDT cell and the user's residence, and integrates internet access information of user numbers under the broadband account's IP address to extract the internet access time information of user numbers within the residence. For the target area to be tested, the method is based on each broadband user account and mainly includes the following steps:

[0094] (1) Extract the time period with the most mobile terminals connected to the home gateway, obtain the broadband user number and home location information from the broadband user database, filter the MDT station of this user number within a small range from the home location, and determine the time period when the broadband user number is online at home.

[0095] (2) Analyze broadband DPI service data, identify the mobile phone number and time under the broadband account IP address through keywords, and obtain the user's home internet access time period by converting the time series;

[0096] (3) By integrating the user number and internet access time obtained earlier, and associating them with the MDT measurement data of the mobile terminal during this period, a user home mobile signal quality profile table is obtained.

[0097] After obtaining the user's home mobile signal quality profile for each broadband account user, operators can better understand the user's true perception of wireless network quality at home; effectively support the rapid handling of user complaints, save technical personnel's time in on-site diagnosis and verification, and improve complaint handling efficiency; proactively plan, construct, and optimize improvements in advance to reduce potential complaints and improve customer satisfaction; guide 5G construction and improve 5G traffic offloading ratio; prioritize VIP users and prevent VIP user churn; and, through the service cell's latitude, longitude, azimuth, and altitude information, and the UE's latitude, longitude, and altitude information, operators can further understand the actual wireless propagation model.

[0098] The following is a detailed explanation of each step of the process:

[0099] 1. Determine the time period when mobile phone users stay at home.

[0100] Determining the time period when a user's mobile device is online at home requires confirming that the user's mobile device (not necessarily the user themselves) is at home and is using internet services. This is achieved through a combination of the following two aspects:

[0101] First, by identifying known broadband user account mobile terminals, it is highly likely that they are connected to the home gateway for internet access, and they are located in the base station cell near the residence, thus determining whether the broadband account mobile terminal is at home during this time period.

[0102] Secondly, by retrieving the internet access records of mobile terminals belonging to the broadband account IP address from the massive XDR data, it can be seen that there are users' mobile terminals in the home that are using internet access services (including mobile terminals belonging to family members, the user, or visitors).

[0103] (1) Determine the time period for broadband user accounts and mobile terminals to access the Internet at home.

[0104] The smart home gateway's software probe periodically collects relevant data, including reporting time, Wi-Fi access type connected to the gateway, and number of connected mobile devices. It extracts the time period with the most connected mobile terminals to the home gateway throughout the day, and can highly determine whether the broadband user's account mobile terminal is using the broadband network to access the Internet during this time (suspected home Internet access time).

[0105] The system retrieves the mobile phone terminal number and home location information (detailed address and latitude and longitude) of broadband users from the broadband user database. The latitude and longitude information in the broadband user database is data entered by installation technicians and has some deviation, but it does not affect the subsequent judgment. The system further retrieves the MDT data of this mobile phone number during the suspected home internet access period, filters the corresponding base station cells, retrieves the corresponding latitude and longitude information from the base station cell database, and calculates the distance between the base station cell and the user's home.

[0106] By filtering base station cells that are more than 300 meters away (this threshold is adjustable), only base station cells within 300 meters of the user's home are retained. The time periods corresponding to the retained MDT data are then re-analyzed to determine the mobile phone user's home internet access time.

[0107] You can continue the above process for a week, repeating the same operation every day, and only keep the communities where residents stayed for more than 3 days in a week, and then re-examine the retained MDT records.

[0108] (2) Determine the time period for broadband user accounts to access the internet at home via mobile terminals.

[0109] By retrieving the internet access records of mobile terminals belonging to the broadband account IP address from massive XDR data, and extracting the mobile terminal number and the time period of internet access, it can be determined that someone in the broadband user's home is using broadband internet service.

[0110] Generally, people access the internet via home Wi-Fi, and visitors also use the home Wi-Fi network. To access a home Wi-Fi network, two conditions must be met: the mobile device must be within Wi-Fi signal coverage, and the username and password for accessing the Wi-Fi network are required. Therefore, by checking the mobile device's internet access records and the time periods during which the device was online, it's possible to determine if the device was inside the home during those times. Specifically:

[0111] Step 1) Collect home broadband user internet access data using port splitting, and parse the data packets using DPI (Deep Packet Inspection) technology to generate XDR data records.

[0112] Step 2) Obtain the user terminal's internet access history via Wi-Fi network;

[0113] Step 3) For the URL and UserAgent fields in the browsing history, match them according to the regular expression rules for mobile phone number characteristics. Rule 1: Analyze the mobile phone number segments of the operator for judgment, or Rule 2: The mobile phone number characteristic is a consecutive 11 digits starting with 1. Filter out the rest of the browsing history that are uncertain whether they are from a mobile terminal. Although these browsing history do not display a mobile phone number, they may still be browsing history from a mobile terminal. Since we cannot determine this, we only keep browsing history with suspected mobile phone numbers; for example, as shown in the table below:

[0114]

[0115]

[0116] Step 4) From the internet access records containing suspected mobile phone numbers, sort out the internet access records containing user account keywords, as well as the internet access records where the suspected mobile phone number matches the broadband user account. User account keywords include, but are not limited to, the following key features, as shown in the table below:

[0117]

[0118]

[0119] Step 5) From the internet browsing records containing user account keywords and mobile phone number features, extract the mobile phone number immediately following the user account keyword, and filter out browsing records without "mobile phone number keyword + mobile phone number"; the resulting browsing records are shown in the table below:

[0120]

[0121]

[0122] Step 6) Categorize internet access records by mobile phone number and sort them by timestamp. For pairs of timestamps with an interval of less than a threshold (such as one minute), connect them to form a time period. Finally, obtain the home broadband account, mobile phone terminal number, and internet access time period information.

[0123] Step 7) Since internet access records with mobile phone numbers only include a portion of websites, and considering that residents' home locations are relatively fixed within a certain period, broadband internet access data can be collected daily. Following the steps above, obtain the mobile terminal numbers and internet access time periods under the household account. Each terminal contains multiple internet access time periods, as shown in the table below:

[0124]

[0125] (3) Integrate users' mobile phone terminal home internet access time periods

[0126] Since different rooms in a user's home may occupy different wireless cells, and the wireless cells occupied at different times may also be different, the online time periods of broadband users' homes obtained by the two methods above are combined.

[0127] 2. Obtain MDT data of broadband user terminal numbers

[0128] Step 1) Enable MDT measurement reports. Minimize Drive-Tests (MDT) technology, compared to regular measurement reports (MR), not only collects precise location (latitude and longitude) information corresponding to the measurement results, but also supports idle-state terminal measurement data collection, relevant measurement data collection during abnormal events such as RLF, and supports the reporting of more measurement items. This includes Immediate MDT / Connected-State MDT for UEs in connected state and Logged MDT / Idle-State MDT for UEs in idle state.

[0129] Step 2) MDT data parsing generates data including timestamp, MME UE S1AP ID, serving cell ID, serving cell PCI, serving cell frequency, serving cell RSRP (Reference Signal Receiving Power), serving cell RSRQ (Reference Signal Receiving Quality), UE longitude, UE latitude, and UE altitude, as shown in the table below:

[0130]

[0131] The "Serving Cell Information" in the idle state is the information of the stationed cell, and the timestamp in the idle state uses the value of the "Measurement Absolute Time" parameter.

[0132] Step 3) Based on the assigned MME UE S1AP ID, combined with radio signaling data and time window (home internet access time period), the MME can obtain the user's mobile phone number, complete the mobile phone number backfilling, and obtain MDT data with the mobile phone number.

[0133] Based on the steps outlined above for obtaining user home internet usage time periods, the overall process for obtaining a true perception of home mobile phone signal quality mainly includes:

[0134] (1) Obtain broadband user account information and broadband user database, including broadband user account (mobile phone number) and detailed location information (address, name of residential area, building unit, room number);

[0135] (2) Extract broadband user terminal numbers and internet access time periods on a per-broadband-user basis;

[0136] (3) Filter MDT data records with mobile phone numbers by “mobile phone number + time period”, that is, Logged MDT data records with the same mobile phone number and timestamp falling within the time period of broadband user (corresponding mobile phone number) going online, because when the mobile terminal is using the home Wi-Fi network for broadband service, the user terminal is in an idle state for the wireless network.

[0137] (4) Further classify the above MDT records by “broadband account + service cell”. Taking the service cell as the unit, calculate the average of the signal strength (RSRP) and signal quality (RSRQ) of the same service cell and retain one record for “broadband account + service cell”. One broadband account may cover multiple cells.

[0138] (5) Finally, the longitude, latitude, and height values ​​of all measured and reported UEs within the broadband account's residence are averaged to obtain the precise location information of the resident's residence. If there is no longitude and latitude information reported by the UE, the longitude and latitude information in the database of home broadband users is temporarily used instead (accurate to the building level).

[0139] (6) Compile a wireless signal profile table for residents' homes, including broadband account information, detailed broadband account address, address latitude and longitude information, wireless service cell number, wireless service cell signal strength, and wireless service cell signal quality. See the table below:

[0140]

[0141] For address latitude and longitude information, first obtain the latitude and longitude information manually entered in the broadband user database. There may be some deviation, and it can only be accurate to the building level. Then replace it with the latitude and longitude information measured by the user terminal at home. If there are multiple latitude and longitude information, such as near the window of a south-facing room or near the window of a north-facing room, the multiple latitude and longitude information can be averaged. The latitude and longitude can be accurate to the home level.

[0142] The software implementation of the solution in this application embodiment may include:

[0143] Firstly, based on big data analysis of signaling services of home broadband users, we fully explore internet access data containing mobile phone numbers from some websites. Based on the characteristics of the mobile phone numbers, we use software programming to extract the mobile phone terminal numbers and internet access time periods.

[0144] Secondly, through big data analysis of wireless signaling data and MDT measurement reports, combined with the user identifier (MME UE S1AP ID) and time window allocated by the core network, the association between the user identifier and the user's mobile phone number is realized through software programming, thereby obtaining MDT data records with mobile phone numbers.

[0145] Finally, through software programming, the time periods during which mobile phone numbers under the home broadband account used broadband services via Wi-Fi are extracted. Then, the data is correlated with MDT records containing the mobile phone numbers to obtain detailed wireless service cell information, signal strength, and signal quality of the user's home.

[0146] Compared with the prior art, the embodiments of this application have the following beneficial effects:

[0147] 1. No user participation is required; the system can obtain information about the quality of a user's home internet signal simply through big data analysis and mining.

[0148] 2. It accurately reflects the actual mobile signal quality at the user's home, based on data reported by the user's own terminal, avoiding significant errors caused by testing and evaluation by operator technicians (due to different test locations, test times, and test terminals).

[0149] 3. After network adjustments and changes, the changes in the wireless service cell and / or signal quality at the user's home can also be accurately reflected.

[0150] 4. By profiling the wireless signal in residential areas, operators' technicians can shorten on-site testing and verification time when handling user complaints, thus greatly improving the efficiency of complaint handling.

[0151] 5. It allows operators' planning and optimization personnel to understand the real customer perceptions of residents in advance, enabling them to make targeted plans, construction, and optimization improvements, reduce potential user complaints, and improve customer satisfaction.

[0152] 6. By clustering the actual mobile phone signal quality indicators of residents' homes, a mobile phone signal quality model for residential communities is constructed;

[0153] 7. By using the latitude, longitude, azimuth, and altitude of the serving cell and the latitude, longitude, and altitude of the UE, operators can better understand the actual wireless propagation model.

[0154] The following describes the user's home mobile phone signal network quality information acquisition device provided in the embodiments of this application. The user's home mobile phone signal network quality information acquisition device described below can be referred to in correspondence with the user's home mobile phone signal network quality information acquisition method described above.

[0155] Please see Figure 2This application provides a device for obtaining mobile phone signal network quality information at a user's residence, comprising:

[0156] The Home Time Acquisition Module 1 is used to acquire home gateway data and user camping base station cell information under each broadband user account based on broadband network signaling service data and wireless network MDT measurement reports in the target area, extract mobile phone user internet access information under each broadband user account, and calculate the home internet access time information of each mobile phone user.

[0157] MDT data association module 2 is used to associate and obtain the MDT data of each mobile phone user during the corresponding home internet access time period;

[0158] The signal quality acquisition module 3 is used to combine the MDT data and the location information of the broadband user account to obtain the mobile phone signal network quality information of the user's home in the target area.

[0159] It is understood that the above-described device embodiments correspond to the method embodiments of this application. The user's home mobile phone signal network quality information acquisition device provided in this application can implement the user's home mobile phone signal network quality information acquisition method provided in any one of the method embodiments of this application.

[0160] Figure 3 An example is a schematic diagram of the physical structure of an electronic device, such as... Figure 3 As shown, the electronic device may include: a processor 310, a communication interface 320, a memory 330, and a communication bus 340, wherein the processor 310, the communication interface 320, and the memory 330 communicate with each other via the communication bus 340. The processor 310 can call a computer program stored in the memory 330 to execute the steps of a method for obtaining user home mobile phone signal network quality information, such as including:

[0161] S1. Based on broadband network signaling service data and wireless network MDT measurement reports within the target area, obtain home gateway data and user-hosted base station cell information under each broadband user account, extract mobile phone user internet access information under each broadband user account, and calculate the home internet access time information of each mobile phone user.

[0162] S2. Retrieve the MDT data of each mobile phone user during the corresponding home internet access time period;

[0163] S3. By combining the MDT data and the location information of the broadband user account, the mobile phone signal network quality information of the user's residence in the target area is obtained.

[0164] Furthermore, the logical instructions in the aforementioned memory 330 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 portion 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.

[0165] 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 user's home mobile phone signal network quality information acquisition method provided in the above embodiments, such as including:

[0166] S1. Based on broadband network signaling service data and wireless network MDT measurement reports within the target area, obtain home gateway data and user camping base station cell information under each broadband user account, extract mobile phone user internet access information under each broadband user account, and calculate the home internet access time information of each mobile phone user.

[0167] S2. Retrieve the MDT data of each mobile phone user during the corresponding home internet access time period;

[0168] S3. Combining the MDT data and the location information of the broadband user account, obtain the mobile phone signal network quality information of the user's residence in the target area.

[0169] On the other hand, embodiments of this application also provide a processor-readable storage medium storing a computer program for causing a processor to perform the steps of the methods provided in the above embodiments, such as including:

[0170] S1. Based on broadband network signaling service data and wireless network MDT measurement reports within the target area, obtain home gateway data and user camping base station cell information under each broadband user account, extract mobile phone user internet access information under each broadband user account, and calculate the home internet access time information of each mobile phone user.

[0171] S2. Retrieve the MDT data of each mobile phone user during the corresponding home internet access time period;

[0172] S3. By combining the MDT data and the location information of the broadband user account, the mobile phone signal network quality information of the user's residence in the target area is obtained.

[0173] The processor-readable storage medium can be any available medium or data storage device that the processor can access, including but not limited to magnetic memory (e.g., floppy disk, hard disk, magnetic tape, magneto-optical disk (MO)), optical memory (e.g., CD, DVD, BD, HVD), and semiconductor memory (e.g., ROM, EPROM, EEPROM, non-volatile memory (NAND FLASH), solid-state drive (SSD)).

[0174] 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.

[0175] 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.

[0176] 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 obtaining mobile network signal quality information at a user's residence, characterized in that, include: Based on broadband network signaling service data and wireless network MDT measurement reports within the target area, the home gateway data and user camping base station cell information under each broadband user account are obtained, the mobile phone user internet access information under each broadband user account is extracted, and the home internet access time information of each mobile phone user is calculated. The MDT data of each mobile phone user during the corresponding home internet access time period is obtained by association; By combining the MDT data and the location information of the broadband user account, the mobile signal network quality information of the user's residence in the target area is obtained; Based on broadband network signaling service data and wireless network MDT measurement reports within the target area, the system obtains home gateway data and user-hosted base station cell information for each broadband user account, extracts mobile phone user internet access information for each broadband user account, and calculates the home internet access time information for each mobile phone user, including: For each broadband user account, the time period with the most mobile terminals connected to the home gateway is determined based on the home gateway data as the suspected home internet access time period of the first mobile user corresponding to the broadband user account. The home address and location information of the first mobile user are obtained from the broadband network database. The cell information of the user's base station is obtained from the wireless network MDT measurement report. The suspected home internet access time period is filtered based on the home address and cell information of the first mobile user to determine the home internet access time period of the first mobile user. Based on broadband DPI service data, obtain the mobile phone user internet access information under the broadband user account, convert the time series in the mobile phone user internet access information into time periods, and obtain the home internet access time periods of multiple associated mobile phone users under the broadband user account. The home internet access time of the first mobile phone user and the home internet access time of the multiple associated mobile phone users are merged to obtain the home internet access time information of each mobile phone user; For each broadband user account, the time period with the most mobile terminals connected to the home gateway is determined based on the home gateway data as the suspected home internet access time period for the first mobile phone user corresponding to the broadband user account. The home address and location information of the first mobile phone user are obtained from the broadband network database. The user's base station cell information is obtained from the wireless network MDT measurement report. The suspected home internet access time period is then filtered based on the first mobile phone user's home address and base station cell information to determine the first mobile phone user's home internet access time period, including: For each broadband user account, the time period with the most mobile phone users connected to the home gateway of the broadband user account is determined as the suspected home internet access time period of the first mobile phone user based on the home gateway data. Based on the MDT records of the first mobile phone user during the suspected home internet access period, obtain the base station cell where the first mobile phone user camped during the suspected home internet access period. The home address and location information of the first mobile phone user are obtained from the broadband network database. The distance between each base station cell and the home address of the first mobile phone user is calculated. Based on a preset distance threshold, the MDT records corresponding to the base station cells that are outside the preset range of the home address of the first mobile phone user are deleted. The above process is repeated within a preset continuous period. MDT records corresponding to the base station cells that recur less than a preset threshold are deleted. The home internet access time period of the first mobile phone user is determined based on the access time period corresponding to the retained MDT records.

2. The method for obtaining user home mobile phone signal network quality information according to claim 1, characterized in that, The step involves obtaining mobile phone user internet access information under the broadband user account based on broadband DPI service data, converting the time series in the mobile phone user internet access information into time periods, and obtaining the home internet access time periods of multiple associated mobile phone users under the broadband user account, including: Based on broadband DPI service data, obtain the internet access records of mobile terminals with suspected mobile phone numbers under the broadband user account, and filter out target internet access records that meet the preset internet access characteristics from the mobile terminal internet access records; The target internet access records are categorized by mobile phone number and sorted by timestamp. Target internet access records with timestamps less than a preset time threshold are connected as a single segment to generate an associated mobile user internet access record information table for the broadband user account. Based on the associated mobile phone user internet access record information table, the home internet access time periods of multiple associated mobile phone users of the broadband user account are obtained.

3. The method for obtaining user home mobile phone signal network quality information according to claim 2, characterized in that, The step of obtaining internet access records of mobile terminals with suspected mobile phone numbers under the broadband user account based on broadband DPI service data, and filtering target internet access records that meet preset internet access characteristic conditions from the mobile terminal internet access records, includes: Based on broadband DPI service data, obtain the internet access records of mobile terminals with suspected mobile phone numbers under the broadband user account; Target internet access records that meet preset internet access characteristics are selected from the internet access records of the mobile terminal; wherein, when it is determined that the internet access record of the mobile terminal contains preset keywords and the preset keywords are connected to a suspected mobile phone number, the internet access record of the mobile terminal is determined to be a target internet access record that meets the preset internet access characteristics.

4. The method for obtaining user home mobile phone signal network quality information according to claim 1, characterized in that, The step of combining the MDT data and the location information of the broadband user account to obtain the mobile network quality information of the user's residence in the target area includes: By combining the MDT data and the location information of the broadband user account, a user home mobile phone signal status table corresponding to each broadband user account in the target area is obtained; wherein, each user home mobile phone signal status table includes signal strength information and signal quality information of multiple service cells; By summarizing the mobile phone signal status tables of all users' residences, the network quality information of mobile phone signals in the target area can be obtained.

5. The method for obtaining user home mobile phone signal network quality information according to claim 4, characterized in that, Also includes: For the same serving cell in each user's home mobile phone signal status table, multiple signal strength measurements and multiple signal quality measurements of different mobile phone users in that serving cell are obtained based on the MDT data. The first average value and the second average value are obtained by averaging the multiple signal strength measurements and the multiple signal quality measurements, respectively. The first average value is used as the signal strength information of the serving cell, and the second average value is used as the signal quality information of the serving cell.

6. A device for acquiring mobile phone signal network quality information at a user's residence, characterized in that, The method for obtaining user home mobile signal network quality information as described in claim 1 includes: The home time period acquisition module is used to acquire home gateway data and user camping base station cell information under each broadband user account based on broadband network signaling service data and wireless network MDT measurement reports in the target area, extract mobile phone user internet access information under each broadband user account, and calculate the home internet access time period information of each mobile phone user. The MDT data association module is used to associate and obtain the MDT data of each mobile phone user during the corresponding home internet access time period. The signal quality acquisition module is used to combine the MDT data and the location information of the broadband user account to obtain the mobile network signal quality information of the user's home in the target area.

7. 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 method for obtaining user home mobile phone signal network quality information as described in any one of claims 1 to 5.

8. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by the processor, it implements the steps of the method for obtaining user home mobile phone signal network quality information as described in any one of claims 1 to 5.

Images