CN116567519A

CN116567519A - Method and device for acquiring quality information of signal network of home mobile phone of user

Info

Publication number: CN116567519A
Application number: CN202210108007.XA
Authority: CN
Inventors: 蔡伟明; 刘菁菁; 李键平; 梅明涛
Original assignee: China Mobile Communications Group Co Ltd; China Mobile Group Jiangsu Co Ltd
Current assignee: China Mobile Communications Group Co Ltd; China Mobile Group Jiangsu Co Ltd
Priority date: 2022-01-28
Filing date: 2022-01-28
Publication date: 2023-08-08

Abstract

The application provides a method and a device for acquiring quality information of a signal network of a mobile phone of a user home, electronic equipment and a computer program product, and relates to the technical field of data analysis. The method comprises the following steps: based on broadband network signaling service data and wireless network MDT measurement reports in a target area, acquiring home gateway data under each broadband user account and user resident base station cell information, extracting mobile phone user internet surfing information under each broadband user account, and calculating to obtain home internet surfing time period information of each mobile phone user; the MDT data of each mobile phone user in the corresponding home internet time period are obtained in an associated mode; and combining the MDT data and the position information of the broadband user account to obtain the signal network quality information of the user home mobile phone in the target area. The method and the device can rapidly and accurately determine the home internet time period of the user, so that the real signal quality condition of the home mobile phone of the user can be accurately and efficiently obtained.

Description

Method and device for acquiring quality information of signal network of home mobile phone of user

Technical Field

The present invention relates to the field of data analysis technologies, and in particular, to a method and an apparatus for obtaining quality information of a signal network of a mobile phone in a home of a user, an electronic device, and a computer program product.

Background

With the increasing of the permeability of mobile phones and the rapid development of urban construction, the requirements of customers on network coverage rate are also continuously improved. Whether a new station is in the network or the wireless environment is changed, and the moving and the service withdrawal of the base station are caused, the coverage of the network is affected; the quality of network coverage has become a primary factor of network quality acceptance of operators in the mind of users, network weak coverage complaints are located at the first place of network quality complaints, and for operators, how to timely and accurately find out the weak coverage area in the network and quickly and effectively solve the weak coverage is one of the most critical difficult problems in influencing the quality experience of the client network.

However, the most serious place for weak coverage by operators is in the residential area, and the coverage solution of the residential area is: planning and optimizing personnel conduct planning construction of the coverage residential area through analysis of the user MR data and MDT data, such as the covering condition of the rasterized MR or MDT signals, or the field test condition of technicians. The scheme can only solve the problem on the whole surface, particularly the signal coverage condition on the point (such as resident house), can not be obtained truly, and the MR or MDT data of the user can not be tracked independently, so that the time of the user in the house of the user can not be determined, and if each user needs to communicate and track, the method is unrealistic.

In contrast, the common method is to find out the weak coverage and poor signal quality of the house through the combination of customer complaints and active tests, so that on one hand, the defects of hysteresis, high cost and the like are found out, and the hidden danger of potential complaints exists; on the other hand, the acquired data is not real enough, the oral response of the user has no data basis, and the test data of the operator technician are different from the real perception data of the user in three aspects: the test terminals are different, the test time is different, the test positions are different (the test data of the gate and the corridor periphery), and the test data cannot reflect the real situation of the mobile phone signals of the user.

Therefore, a method for accurately and efficiently acquiring the signal quality of the mobile phone of the user is needed.

Disclosure of Invention

The embodiment of the application provides a method, a device, electronic equipment and a computer program product for acquiring signal network quality information of a mobile phone of a user home, which can accurately and efficiently acquire the real signal quality condition of the mobile phone of the user home.

In a first aspect, an embodiment of the present application provides a method for obtaining quality information of a signal network of a mobile phone in a home of a user, including:

based on broadband network signaling service data and wireless network MDT measurement reports in a target area, acquiring home gateway data under each broadband user account and user resident base station cell information, extracting mobile phone user internet surfing information under each broadband user account, and calculating to obtain home internet surfing time period information of each mobile phone user;

The MDT data of each mobile phone user in the corresponding home internet time period are obtained in an associated mode;

and combining the MDT data and the position information of the broadband user account to obtain the signal network quality information of the user home mobile phone in the target area.

In one embodiment, the obtaining home gateway data and user residence base station cell information under each broadband user account based on broadband network signaling service data and wireless network MDT measurement report in the target area, extracting mobile phone user internet information under each broadband user account, and calculating to obtain home internet time period information of each mobile phone user includes:

for each broadband user account, acquiring the most time period of a mobile phone terminal hung down from a home gateway according to the home gateway data, determining the most suspected home internet surfing time period of a first mobile phone user corresponding to the broadband user account, acquiring the home address and the position information of the first mobile phone user according to a broadband network database, acquiring the user resident base station cell information of the first mobile phone user according to the wireless network MDT measurement report, screening the suspected home internet surfing time period according to the home address and the user resident base station cell information of the first mobile phone user, and determining the home internet surfing time period of the first mobile phone user;

Acquiring mobile phone user internet surfing information under a broadband user account according to broadband DPI service data, converting a time sequence in the mobile phone user internet surfing information into a time period, and acquiring home internet surfing time periods of a plurality of associated mobile phone users under the broadband user account;

and fusing the home internet time periods of the first mobile phone users and the home internet time periods of the plurality of associated mobile phone users to obtain the home internet time period information of each mobile phone user.

In one embodiment, for each broadband user account, the time period when the mobile phone terminal hangs down from the home gateway is determined to be a suspected home internet surfing time period of the first mobile phone user corresponding to the broadband user account according to the most time period when the mobile phone terminal hangs down from the home gateway, the home address and the location information of the first mobile phone user are obtained according to a broadband network database, the user resident base station cell information of the first mobile phone user is obtained according to the wireless network MDT measurement report, the suspected home internet surfing time period is screened according to the home address and the user resident base station cell information of the first mobile phone user, and the home internet surfing time period of the first mobile phone user is determined, including:

For each broadband user account, determining the time period with the largest number of home gateway down-hanging internet surfing mobile phone users of the broadband user account as the suspected home internet surfing time period of the first mobile phone user according to the home gateway data;

acquiring a resident base station cell of the first mobile phone user in the suspected home networking time period according to the MDT record of the first mobile phone user in the suspected home networking time period;

acquiring home address and position information of the first mobile phone user according to a broadband network database, calculating the distance between each resident base station cell and the home address of the first mobile phone user, and deleting MDT records corresponding to resident base station cells outside the preset range of the home address of the first mobile phone user based on a preset distance threshold;

repeating the above process in a preset continuous period, deleting MDT records corresponding to resident base station cells with the repeated occurrence times smaller than a preset threshold value, and determining and obtaining the home internet time period of the first mobile phone user based on the access time period corresponding to the reserved MDT records.

In one embodiment, the obtaining the mobile phone user internet surfing information under the broadband user account according to the broadband DPI service data, converting a time sequence in the mobile phone user internet surfing information into a time period, and obtaining the home internet surfing time periods of the plurality of associated mobile phone users under the broadband user account includes:

Acquiring a mobile phone terminal internet surfing record with a suspected mobile phone number under the broadband user account according to broadband DPI service data, and screening a target internet surfing record which accords with a preset internet surfing characteristic condition from the mobile phone terminal internet surfing record;

classifying the target internet surfing records according to the classification basis of the mobile phone numbers, sequencing the target internet surfing records according to the time stamps, connecting the target internet surfing records with the time stamps smaller than a preset time threshold value between every two target internet surfing records as a section, and generating an associated mobile phone user internet surfing record information table for obtaining the broadband user account;

and acquiring the home internet time periods of a plurality of associated mobile phone users of the broadband user account according to the internet record information table of the associated mobile phone users.

In one embodiment, the obtaining the internet surfing record of the mobile phone terminal with the suspected mobile phone number under the broadband user account according to the broadband DPI service data, and screening the target internet surfing record meeting the preset internet surfing characteristic condition from the internet surfing record of the mobile phone terminal, includes:

acquiring a mobile phone terminal internet log with a suspected mobile phone number under the broadband user account according to broadband DPI service data;

screening out target internet surfing records which accord with preset internet surfing characteristic conditions from the internet surfing records of the mobile phone terminal; when the mobile phone terminal internet surfing record is judged to contain a preset keyword and the preset keyword is connected with a suspected mobile phone number, the mobile phone terminal internet surfing record is judged to be a target internet surfing record which accords with a preset internet surfing characteristic condition.

In one embodiment, the obtaining, by combining the MDT data and the location information of the broadband user account, the signal network quality information of the user home handset in the target area includes:

combining the MDT data and the position information of the broadband user account numbers to obtain a user home mobile phone signal condition table corresponding to each broadband user account number in the target area; each user home mobile phone signal condition table comprises signal intensity information and signal quality information of a plurality of service cells;

and summarizing all the signal condition tables of the home mobile phones of the users to obtain the signal network quality information of the home mobile phones of the users in the target area.

In one embodiment, the method for obtaining the quality information of the signal network of the home mobile phone of the user further comprises the following steps:

for the same service cell in the signal condition table of the home mobile phone of each user, obtaining a plurality of signal strength measurement values and a plurality of signal quality measurement values of different mobile phone users under the service cell according to the MDT data;

respectively carrying out average calculation on the plurality of signal strength measurement values and the plurality of signal quality measurement values to obtain a first average value and a second average value;

And taking the first average value as the signal intensity information of the serving cell and the second average value as the signal quality information of the serving cell.

In a second aspect, an embodiment of the present application provides a device for obtaining quality information of a signal network of a mobile phone in a home of a user, including:

the home period acquisition module is used for acquiring home gateway data under each broadband user account and cell information of a user resident base station based on broadband network signaling service data and wireless network MDT measurement reports in a target area, extracting mobile phone user internet surfing information under each broadband user account, and calculating to obtain home internet surfing time period information of each mobile phone user;

the MDT data association module is used for associating and acquiring MDT data of each mobile phone user in a corresponding home internet time period;

and the signal quality acquisition module is used for acquiring the signal network quality information of the user home mobile phone in the target area by combining the MDT data and the position information of the broadband user account.

In a third aspect, an embodiment of the present application provides an electronic device, including a processor and a memory storing a computer program, where the processor implements the steps of the method for obtaining signal network quality information of a user's home handset according to the first aspect when executing the program.

In a fourth aspect, an embodiment of the present application provides a computer program product, including a computer program, where the computer program when executed by a processor implements the steps of the method for obtaining signal network quality information of a mobile phone in a home of a user according to the first aspect.

According to the method, the device, the electronic equipment and the computer program product for acquiring the quality information of the user home mobile phone signal network, the corresponding time period of the mobile phone user home surfing is accurately acquired based on the surfing data of the broadband user account, the MDT data of the corresponding mobile phone user in the home surfing time period are acquired in a correlated mode, and then the quality information of the user home mobile phone signal network in a target area is acquired by combining the position information of each broadband account and the MDT data of the corresponding mobile phone user. According to the method and the device for determining the home network time period, the home network time period of the user can be rapidly and accurately determined, and therefore the real signal quality condition of the home mobile phone of the user can be accurately and efficiently obtained.

Drawings

For a clearer description of the present application or of the prior art, the drawings that are used in the description of the embodiments or of the prior art will be briefly described, it being apparent that the drawings in the description below are some embodiments of the present application, and that other drawings may be obtained from these drawings without inventive effort for a person skilled in the art.

Fig. 1 is a schematic flow chart of a method for obtaining quality information of a signal network of a mobile phone in a home of a user according to an embodiment of the present application;

fig. 2 is a schematic structural diagram of a signal network quality information acquisition device of a mobile phone of a user home provided in an embodiment of the present application;

fig. 3 is a schematic structural diagram of an electronic device according to an embodiment of the present application.

Detailed Description

For the purposes of making the objects, technical solutions and advantages of the present application more apparent, the technical solutions in the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application, and it is apparent that the described embodiments are some, but not all, embodiments of the present application. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments herein without making any inventive effort, are intended to be within the scope of the present application.

Fig. 1 is a flow chart of a method for obtaining quality information of a signal network of a mobile phone in a home of a user. Referring to fig. 1, an embodiment of the present application provides a method for obtaining quality information of a signal network of a mobile phone in a home of a user, which may include the steps of:

s1, acquiring home gateway data under each broadband user account and user resident base station cell information based on broadband network signaling service data and a wireless network MDT measurement report in a target area, extracting mobile phone user internet surfing information under each broadband user account, and calculating to obtain home internet surfing time period information of each mobile phone user;

S2, obtaining MDT data of each mobile phone user in a corresponding home internet time period in an associated mode;

s3, combining the MDT data and the position information of the broadband user account to obtain the signal network quality information of the user home mobile phone of the target area.

In the embodiment of the application, the internet surfing data of all broadband user accounts in a certain region (target region) are firstly obtained, and the home internet surfing time period of the corresponding mobile phone user can be determined and obtained according to the internet surfing data. For example, according to the internet data of a certain broadband user account, each mobile phone terminal of the WiFi network connected to the broadband gateway can be obtained, and a specific internet time period of each mobile phone terminal, that is, a home internet time period of each mobile phone user, is obtained.

Then, for each mobile phone user, based on the mobile phone number and time window (home internet time period), corresponding MDT data can be obtained in an associated mode. By performing data analysis on these MDT data, it is possible to generate user-resident mobile phone signal network quality information including parameters such as a time stamp, MME UE S1AP ID, serving cell PCI, serving cell frequency point, serving cell RSRP (reference signal received power), serving cell RSRQ (reference signal received quality), UE longitude, UE latitude, and UE height.

And then, the broadband user account numbers, the position information of the broadband user account numbers and the mobile phone signal network quality information are correlated, so that the user home mobile phone signal network quality information corresponding to each broadband user account number in the target area can be obtained. It should be noted that, the location information of the broadband user account may be updated by first reporting the home address reserved when installing the broadband, and then using the average value obtained by calculating the UE longitude, UE latitude, and UE height of each serving cell.

According to the method for acquiring the quality information of the user home mobile phone signal network, the corresponding time period of the mobile phone user home surfing is accurately acquired based on the surfing data of the broadband user account, the MDT data of the corresponding mobile phone user in the home surfing time period are acquired in a correlated mode, and then the quality of the user home mobile phone signal network in the target area is acquired by combining the position information of each broadband account and the MDT data of the corresponding mobile phone user. According to the method and the device for determining the home network time period, the home network time period of the user can be rapidly and accurately determined, and therefore the real signal quality condition of the home mobile phone of the user can be accurately and efficiently obtained.

In one embodiment, step S2 may include the steps of:

S21, for each broadband user account, acquiring the most time period of a mobile phone terminal hung under a home gateway according to the home gateway data, determining the most suspected home internet surfing time period of a first mobile phone user corresponding to the broadband user account, acquiring the home address and the position information of the first mobile phone user according to a broadband network database, acquiring the user resident base station cell information of the first mobile phone user according to the wireless network MDT measurement report, screening the suspected home internet surfing time period according to the home address and the user resident base station cell information of the first mobile phone user, and determining the home internet surfing time period of the first mobile phone user;

s22, acquiring mobile phone user internet surfing information under the broadband user account according to broadband DPI service data, converting a time sequence in the mobile phone user internet surfing information into a time period, and acquiring home internet surfing time periods of a plurality of associated mobile phone users under the broadband user account;

s23, fusing the home internet time periods of the first mobile phone user and the home internet time periods of the plurality of associated mobile phone users to obtain home internet time period information of each mobile phone user.

In the embodiment of the present application, for a home internet time period of each mobile phone user under each broadband user account, the method may be obtained from two aspects: 1. according to the internet surfing data, a suspected home internet surfing time period of a first mobile phone user corresponding to the broadband user account (such as a time period when the first mobile phone user surfs the internet through the broadband account wifi) can be obtained, and according to the distance between the MDT residence cell of the mobile phone user and the corresponding residence address, the time period corresponding to the residence cell which is not in a preset range is filtered, and the home internet surfing time period of the first mobile phone user is determined; 2. and obtaining internet surfing records of all mobile phone terminals (associated mobile phone users) connected with the broadband user account for surfing the internet according to the broadband DPI service data, and obtaining the home internet surfing time periods of a plurality of associated mobile phone users by converting the time sequences of the internet surfing records into time period information. And then, the home internet time periods obtained in the two modes are fused to obtain the home internet time periods of all mobile phone users under the broadband user account.

According to the method for acquiring the quality information of the user home mobile phone signal network, the home internet time periods of all mobile phone users under the broadband user account are acquired by combining the two acquisition modes, so that the home internet time periods corresponding to the mobile phone users can be acquired more comprehensively and accurately, and the acquisition accuracy of the real condition of the user home mobile phone signal quality is further improved.

In one embodiment, step S21 may include the steps of:

s211, for each broadband user account, determining the time period with the largest number of the mobile phone users hanging on the internet under the home gateway of the broadband user account as the suspected home internet time period of the first mobile phone user according to the home gateway data;

s212, acquiring a resident base station cell of the first mobile phone user in the suspected home networking time period according to the MDT record of the first mobile phone user in the suspected home networking time period;

s213, acquiring home address and position information of the first mobile phone user according to a broadband network database, calculating the distance between each resident base station cell and the home address of the first mobile phone user, and deleting MDT records corresponding to resident base station cells outside the preset range of the home address of the first mobile phone user based on a preset distance threshold;

s214, repeating the above process in a preset continuous period, deleting the MDT records corresponding to the resident base station cells with the repeated occurrence times smaller than the preset threshold value, and determining to obtain the home internet time period of the first mobile phone user based on the access time period corresponding to the reserved MDT records.

In the embodiment of the present application, for the first method for obtaining the home internet surfing time period of the mobile phone user, the steps S211 to S214 are adopted. Specifically, firstly, determining a time period with the maximum number of the home gateway of the broadband user account number for hanging the internet surfing mobile phone user as a suspected home internet surfing time period of the first mobile phone user; and then obtaining the corresponding MDT record of the first mobile phone user according to the suspected home Internet surfing time period, obtaining resident base station cells of the mobile phone user in the time period, calculating whether the distance between each resident base station cell and the home address of the mobile phone user is in a preset range, filtering resident base station cells which do not meet the conditions, repeating the above process in a preset continuous period (such as a continuous circle), deleting the MDT record corresponding to the resident base station cells with the repeated occurrence frequency smaller than a preset threshold (such as less than three times), and finally determining to obtain the home Internet surfing time period of the first mobile phone user according to the access time period of the MDT record corresponding to the resident base station cells.

According to the method for acquiring the quality information of the signal network of the mobile phone of the user home, the suspected home internet surfing time period is further filtered by utilizing the resident base station cell of the user, the accuracy of the acquired home internet surfing time period of the mobile phone user is further improved, and the acquisition accuracy of the real condition of the signal quality of the mobile phone of the user home is further improved.

In one embodiment, step S22 may include the steps of:

s221, acquiring a mobile phone terminal internet surfing record with a suspected mobile phone number under the broadband user account according to broadband DPI service data, and screening out a target internet surfing record which accords with a preset internet surfing characteristic condition from the mobile phone terminal internet surfing record;

s222, classifying the target internet surfing records according to the classification basis of the mobile phone numbers, sequencing the target internet surfing records according to time stamps, connecting the target internet surfing records with time stamps smaller than a preset time threshold value between every two target internet surfing records as a section, and generating an associated mobile phone user internet surfing record information table for obtaining the broadband user account;

s223, acquiring the home internet time periods of a plurality of associated mobile phone users of the broadband user account according to the internet record information table of the associated mobile phone users.

In the embodiment of the present application, for the second mode of obtaining the home internet surfing time period of the mobile phone user, the steps S221 to S223 are adopted. Specifically, firstly, obtaining a mobile phone terminal internet surfing record with a suspected mobile phone number under the broadband user account according to broadband DPI service data, wherein the matching rule of the suspected mobile phone number can include: rule 1: judging the mobile phone number section of the carding operator, or determining rule 2: the characteristic value of the mobile phone number is a continuous 11-bit number at the beginning of 1; filtering the Internet surfing records according to preset Internet surfing characteristic conditions; classifying the internet surfing records according to the mobile phone numbers, sorting a plurality of internet surfing records of the same mobile phone number according to time stamps, connecting time stamps smaller than a preset threshold value between every two internet surfing records into a time period, generating an internet surfing record information table corresponding to a plurality of associated mobile phone users of each broadband user account, and further obtaining the home internet surfing time periods of a plurality of associated mobile phone users of the broadband user account.

According to the method for acquiring the quality information of the signal network of the mobile phone of the user home, the information of the Internet surfing time periods of a plurality of related mobile phone users under each broadband user account is screened out by classifying the Internet surfing records, the accuracy of the acquired Internet surfing time periods of the mobile phone users home is further improved, and the acquisition accuracy of the real condition of the signal quality of the mobile phone of the user home is further improved.

In one embodiment, step S221 may include:

In this embodiment of the present application, when screening the target internet surfing record that meets the preset internet surfing feature condition, the preset internet surfing feature condition may be set to include some preset keywords and the corresponding suspected mobile phone number is immediately after the keywords. The internet surfing record which does not meet the conditions is filtered by utilizing the preset keywords and the rules of the combination number, so that the interference caused by irrelevant internet surfing records is effectively reduced, the accuracy of the acquired mobile phone user home internet surfing time period is further improved, and the acquisition accuracy of the real condition of the signal quality of the mobile phone of the user home is further improved.

In one embodiment, step S3 may include:

In the embodiment of the present application, it may be understood that a home address corresponding to one broadband account may have a plurality of service cells covered, so that a signal condition table of a user home mobile phone corresponding to each broadband user account corresponds to signal strength information and signal quality information of a plurality of service cells. After obtaining the signal condition tables of the user home mobile phones corresponding to the broadband user accounts (one broadband user account corresponds to a plurality of service cells), summarizing the signal condition tables of all the user home mobile phones to obtain the signal network quality information of the user home mobile phones in the target area.

According to the method for acquiring the signal network quality information of the user home mobile phone, the signal network information under each broadband user account is subdivided into a plurality of service cells, so that the signal network condition of the corresponding position can be reflected from finer granularity, and network optimization personnel can conduct signal coverage optimization work on the region more pertinently.

In the embodiment of the application, for the same service cell in the signal condition table of the mobile phone of each user home, the average value of a plurality of measured signal values of different mobile phone users under the service cell is adopted as corresponding signal coverage information, so that the acquisition accuracy of the signal network quality information of the mobile phone of the user home is effectively improved.

Based on the above scheme, in order to facilitate better understanding of the method for acquiring quality information of the signal network of the mobile phone of the user home provided by the embodiment of the present application, the following is specifically described:

It should be noted that the prior art mentioned in the background art has the following problems:

1. the user complaints are used for finding out the house signals of the user or the quality is poor, the finding is delayed, the problem is passively solved, and the hidden danger of potential complaints exists.

2. The quality condition of the household signals of the user is found through traversal test, and the workload and the cost are high; the difficulty of the home test of the entering user is high (except the permission of the individual user), the entering user can only be replaced by the home gate or peripheral test data, and the face of each room can not be reached even if the entering user enters the home test; the test terminal may be different from the client terminal, and the test time is different from the network load condition, so that the real perception of the user cannot be reflected.

3. Separately tracking MR or MDT data of users, and cannot determine when the users are in the home of the users, if the users communicate and track one by one, the method is unrealistic; and the current scene of the user cannot be reproduced.

4. Requiring each user test report is impractical.

In order to solve the technical problems, the embodiment of the application provides a method for acquiring signal network quality information of a mobile phone of a user home, which integrates broadband network signaling service data, a wireless network MDT measurement report and wireless signaling data for analysis, analyzes the home gateway data acquired by an IHGU soft probe, the distance range of a cell where a broadband user corresponds to a mobile phone terminal MDT to the user home, integrates the internet surfing information of a user number subordinate to a broadband account IP address, and extracts the internet surfing time period information of the user number in the home. For a target area to be detected, taking each user broadband user account as a unit, the method mainly comprises the following steps:

(1) Extracting the most time period of the mobile phone terminal hung under the home gateway, acquiring the broadband user number and home position information from a broadband user database, screening the range of the home position of the residence community of the user number MDT from the home position, and determining the home surfing time period of the broadband user number;

(2) Analyzing broadband DPI service data, identifying the Internet surfing mobile phone number and time under the broadband account IP address through keywords, and converting the time period through a time sequence to obtain the home Internet surfing time period of the user number;

(3) And merging the acquired user number and the online time period, and correlating MDT measurement data of the mobile phone terminal in the period to obtain the signal quality portrait table of the mobile phone of the user house.

After obtaining the signal quality portrait table of the user home mobile phone corresponding to each broadband account user, the operator can conveniently master the real perception of the user home to the wireless network quality; the quick treatment of the user complaints is effectively supported, the on-site diagnosis and verification time of the technical personnel complaint treatment is saved, and the complaint treatment efficiency is improved; targeted planning, construction and optimization improvement are actively performed in advance, potential complaints are reduced, and customer satisfaction is improved; the construction of 5G can be guided, and the 5G split ratio is improved; the key point is to ensure the VIP user and avoid the loss of the VIP user; the operator can further master the real wireless propagation model through the longitude and latitude, the direction angle and the cell altitude of the service cell and the longitude and latitude and altitude information of the UE.

The flow of each step is described in detail below:

1. determining a home time period of a mobile phone user

Determining a home internet time period of a user mobile phone terminal, wherein the user mobile phone terminal (not necessarily the user) needs to be determined to be at home at the moment, and the internet service is also performed, and the method is realized by combining the following two aspects:

firstly, determining that a known broadband user account mobile phone terminal is at home in the time period by judging that the known broadband user account mobile phone terminal is connected with a home gateway to carry out internet surfing service with high probability and a base station cell which resides nearby a house;

secondly, searching a mobile phone terminal internet log of an IP address of a home broadband account from massive XDR data, which shows that a user mobile phone terminal in a home is in internet surfing service (comprising mobile phone terminals of home users, visitors and the like).

(1) Determining a home internet time period of a broadband user account mobile phone terminal

The intelligent home gateway soft probe periodically collects related data, including information such as reporting time, wifi access type hung under the gateway, number of mobile phone equipment hung under the gateway, extracts the time zone with the maximum number of mobile phone terminals hung under the home gateway all the day, and determines the time of the mobile phone terminal of the broadband user account with high probability that the mobile phone terminal is in internet service (suspected home internet time zone) through the broadband network.

Acquiring mobile phone terminal numbers and home position information (detailed addresses and longitudes and latitudes) of broadband users from a broadband user database, wherein the home position longitudes and latitudes information in the broadband user database is data recorded by an installation technician, has certain deviation, and does not influence the later judgment; further obtaining MDT data of the mobile phone number in a suspected home Internet surfing time period, screening corresponding resident base station cells, taking corresponding longitude and latitude information from a base station cell database, and calculating the distance between the base station cell and the home of a user.

Through screening, base station cells which are more than 300 meters (the threshold is adjustable) are filtered, only base station cells within the range of 300 meters of the home of the user are reserved, the time period corresponding to the reserved MDT data is re-carded, and the home internet surfing time period of the mobile phone user is determined.

The same operation may be repeated daily for a week according to the above procedure, leaving only resident cells for more than 3 days for a week, and re-carding the remaining MDT records.

(2) Determining a home internet time period of a broadband user account mobile phone terminal

And searching a mobile phone terminal internet surfing record of the IP address of the home broadband account from the massive XDR data, extracting the mobile phone terminal number and the internet surfing time period, and determining that the home of the broadband user has a person to perform broadband internet surfing service.

The broadband internet access is generally performed through the wifi network in the home, and the visitor can also use the wifi network in the home, but to enter the home wifi network, two conditions are required, one is that the mobile phone terminal is in the wifi network signal coverage range, and the other is that the account number password accessing the wifi network is needed to be known, so that the internet access record of the mobile phone terminal and the internet access time period are found out in the internet access data of the home broadband network, and the internet access terminal in the home in the corresponding time period can be determined. Specifically:

step 1) acquiring home broadband user internet surfing data in a port beam splitting mode, analyzing the data packet through DPI (deep packet inspection technology) to generate XDR data record.

Step 2) acquiring an internet record of the user terminal through a wifi network;

step 3) aiming at URL and UserAgent fields in the Internet surfing record, according to the regular matching rule of the characteristic value of the mobile phone number, rule 1: judging the mobile phone number section of the carding operator, or determining rule 2: the characteristic value of the mobile phone number is a continuous 11-bit number at the beginning of 1, and the rest of the internet surfing records of the mobile phone terminal are filtered out, so that although the mobile phone number is not displayed in the internet surfing records, the internet surfing records of the mobile phone terminal can be also recorded, and only the internet surfing records with the suspected mobile phone number can be reserved because the mobile phone number cannot be judged; for example as shown in the following table:

Step 4) sorting out the internet log with the user account key words from the internet log with the suspected mobile phone number, and the internet log with the suspected mobile phone number consistent with the broadband user account, wherein the user account key words include the following key features, but are not limited to the following features, as shown in the following table:

step 5) extracting the mobile phone number behind the user account key from the internet surfing record containing the user account key and the mobile phone number characteristic value, and filtering the internet surfing record without the mobile phone number key and the mobile phone number; the resulting internet log is shown in the following table:

step 6), classifying the Internet surfing records according to the mobile phone numbers, sorting according to the time stamps, and connecting the time slots as time slots when the interval between every two time stamps is smaller than a threshold value (such as one minute), so as to finally obtain the family broadband account number, the Internet surfing mobile phone terminal number and the Internet surfing time slot information;

step 7) because the internet record with the mobile phone number is only a part of websites, the broadband internet service data can be acquired every day in consideration of the fact that the resident home position is fixed in a certain period, and according to the steps, the mobile phone terminal number and the internet time period of the home account subordinate to the mobile phone are acquired, and each terminal comprises a plurality of internet time periods, as shown in the following table:

(3) Integration of user mobile phone terminal home internet time period

Because the wireless cells occupied by different houses of the user house may be different, and the wireless cells occupied by different times may be different, the user terminal internet surfing time periods of the broadband user house obtained by the two methods are fused.

2. Obtaining MDT data of broadband user terminal number

Step 1) starting an MDT measurement report, and compared with a common Measurement Report (MR), the MDT (minimization of drive tests) technology MDT (Minimization of Drive-tests) can collect accurate position (longitude and latitude) information corresponding to a measurement result, can also support idle state terminal measurement data collection, support relevant measurement data collection during an abnormal event such as RLF and the like, and support measurement report of more measurement items. The method comprises the steps that a measurement report IMmedia MDT/connection MDT of the UE in a connection state is included, and a measurement report Logged MDT/idle MDT of the UE in an idle state is included;

step 2) MDT data parsing, generating a data set including a time stamp, MME UE S1AP ID, serving cell PCI, serving cell frequency point, serving cell RSRP (reference signal received power), serving cell RSRQ (reference signal received quality), UE longitude, UE latitude, UE height, etc.; the following table shows:

Here, the "serving cell information" in the idle state is the camping cell information, and the timestamp in the idle state uses the value of the parameter "measurement absolute time".

Step 3), the MME combines the wireless signaling data and the time window (home Internet time period) according to the allocated MME UE S1AP ID, can correlate to obtain the mobile phone number of the user, and completes the backfilling of the mobile phone number to obtain the MDT data with the mobile phone number.

Based on the step of obtaining the user home internet time period, the whole step flow of obtaining the true perception of the signal quality of the home mobile phone mainly comprises the following steps:

(1) Acquiring broadband user account information, and a broadband user database comprising broadband user account (mobile phone number), detailed location information (address, residential area name, building unit and room number);

(2) Extracting the number of a broadband user terminal and the Internet surfing time period by taking the broadband user as a unit;

(3) Screening MDT data records with mobile phone numbers by using the mobile phone numbers and the time period, namely, the mobile phone numbers are the same, and the time stamp of the MDT data records is in the log-on time period of a broadband user (corresponding to the mobile phone number), because when the mobile phone terminal performs broadband service through a home wifi network, the user terminal is in an idle state for a wireless large network;

(4) The MDT records are further classified by using a broadband account number and a service cell, the signal strength (RSRP) and the signal quality (RSRQ) of the same service cell are averaged by taking the service cell as a unit, one record of the broadband account number and the service cell is reserved, and one broadband account number can be covered by a plurality of cells;

(5) Finally, the longitude and latitude information in the database of the home broadband user is temporarily used for replacing (accurate to building) if the longitude and latitude information reported by the UE does not exist;

(6) The wireless cell signal portrait table for organizing resident houses comprises a broadband account number, a broadband account number detailed address, address longitude and latitude information, a wireless service cell number, wireless service cell signal strength and wireless service cell signal quality. The following table shows:

for address longitude and latitude information, firstly, manually-input longitude and latitude information in a broadband user database is acquired, some deviation is possible, only building can be achieved accurately, then the information is replaced by longitude and latitude information measured by a user terminal at home, if a plurality of longitude and latitude information exists, such as the vicinity of a southern room window or the vicinity of a northern room window, the longitude and latitude information can be averaged, and the longitude and latitude information can be achieved accurately to the home.

For the solution of the embodiment of the present application, the software implementation may include:

firstly, based on signaling business big data analysis of a home broadband user, internet surfing data with terminal mobile phone numbers in part of websites are fully mined, and mobile phone terminal numbers and internet surfing time periods are extracted through software programming according to mobile phone number characteristics.

And secondly, through analysis of wireless signaling data and MDT measurement report big data and combination of user identification (MME UE S1AP ID) and a time window distributed by a core network, the association of the user identification and the user mobile phone number is realized through software programming, and the MDT data record with the mobile phone number is obtained.

Finally, the method is realized through software programming, the time period of broadband service of the mobile phone terminal number under the home broadband account through a wifi network is extracted, then MDT records with the mobile phone terminal number are associated, and finally the detailed wireless service cell information, the wireless service cell signal intensity and the wireless service cell signal quality of the user home are obtained.

Compared with the prior art, the embodiment of the application has the following beneficial effects:

1. the acquisition of the quality condition of the user home internet surfing signal can be realized without the participation of the user and the analysis and mining of the pure big data;

2. The real situation of the mobile phone signal quality of the user home is truly reflected, and the mobile phone signal quality is data reported by the user's own terminal, so that larger errors (due to different testing positions, different testing time and different testing terminals) caused by testing and evaluation of operators are avoided;

3. after the network is adjusted and changed, the condition of the wireless service cell and/or signal quality of the user home can be changed truly;

4. the wireless cell signal portrait of resident house is convenient for operators to process user complaints, shortens the on-site test and verification time, and greatly improves the complaint processing efficiency;

5. the operator planning optimization personnel can know the actual customer perception of the residential area users in advance, and the targeted planning, construction, optimization and improvement are performed in advance, so that the potential user complaints are reduced, and the customer satisfaction is improved;

6. building a mobile phone signal quality model of a residential community through clustering real mobile phone signal quality indexes of resident residents;

7. the operator can further master the real wireless propagation model through the longitude and latitude, the direction angle and the cell altitude of the service cell and the longitude and latitude and altitude information of the UE.

The device for acquiring the quality information of the signal network of the mobile phone in the home of the user, which is provided in the embodiment of the present application, is described below, and the device for acquiring the quality information of the signal network of the mobile phone in the home of the user, which is described below, and the method for acquiring the quality information of the signal network of the mobile phone in the home of the user, which is described above, can be referred to correspondingly.

Referring to fig. 2, an embodiment of the present application provides a device for obtaining quality information of a signal network of a mobile phone in a home of a user, including:

the home period acquisition module 1 is used for acquiring home gateway data under each broadband user account and cell information of a user resident base station based on broadband network signaling service data and wireless network MDT measurement reports in a target area, extracting mobile phone user internet surfing information under each broadband user account, and calculating to obtain home internet surfing time period information of each mobile phone user;

the MDT data association module 2 is used for associating and acquiring MDT data of each mobile phone user in a corresponding home internet time period;

and the signal quality acquisition module 3 is used for acquiring the signal network quality information of the user home mobile phone in the target area by combining the MDT data and the position information of the broadband user account.

It can be understood that the embodiment of the device corresponds to the embodiment of the method of the application, and the device for acquiring the signal network quality information of the mobile phone of the user home provided by the embodiment of the application can realize the method for acquiring the signal network quality information of the mobile phone of the user home provided by any one of the embodiments of the method of the application.

Fig. 3 illustrates a physical schematic diagram of an electronic device, as shown in fig. 3, where the electronic device may include: processor 310, communication interface (Communication Interface) 320, memory 330 and communication bus 340, wherein processor 310, communication interface 320, memory 330 accomplish communication with each other through communication bus 340. The processor 310 may invoke a computer program in the memory 330 to perform the steps of a method for obtaining quality information of a signal network of a user's home handset, for example, including:

Further, the logic instructions in the memory 330 described above may be implemented in the form of software functional units and may be stored in a computer-readable storage medium when sold or used as a stand-alone product. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.

In another aspect, embodiments of the present application further provide a computer program product, where the computer program product includes a computer program, where the computer program may be stored on a non-transitory computer readable storage medium, where the computer program when executed by a processor is capable of executing the steps of the method for obtaining signal network quality information of a user's home handset provided in the foregoing embodiments, where the method includes:

In another aspect, embodiments of the present application further provide a processor-readable storage medium storing a computer program for causing a processor to perform the steps of the method provided in the above embodiments, for example, including:

The processor-readable storage medium may be any available medium or data storage device that can be accessed by a processor, including, but not limited to, magnetic storage (e.g., floppy disks, hard disks, magnetic tape, magneto-optical disks (MOs), etc.), optical storage (e.g., CD, DVD, BD, HVD, etc.), semiconductor storage (e.g., ROM, EPROM, EEPROM, nonvolatile storage (NAND FLASH), solid State Disk (SSD)), and the like.

The apparatus embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.

From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.

Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present application, and are not limiting thereof; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the corresponding technical solutions.

Claims

1. A method for acquiring quality information of a signal network of a mobile phone of a user home is characterized by comprising the following steps:

2. The method for obtaining quality information of a signal network of a mobile phone in a home of a user according to claim 1, wherein the obtaining home gateway data and cell information of a base station in which the user resides under each broadband user account based on broadband network signaling service data and a wireless network MDT measurement report in a target area, extracting internet surfing information of the mobile phone user under each broadband user account, and calculating to obtain information of a home internet surfing time period of each mobile phone user includes:

3. The method for obtaining quality information of a signal network of a mobile phone in a home of a user according to claim 2, wherein, for each broadband user account, a time period with a mobile phone terminal hung under a home gateway most according to the home gateway data is determined to be a suspected home internet time period of the first mobile phone user corresponding to the broadband user account, a home address and location information of the first mobile phone user are obtained according to a broadband network database, user residence base station cell information of the first mobile phone user is obtained according to the wireless network MDT measurement report, the suspected home internet time period is screened according to the home address and user residence base station cell information of the first mobile phone user, and the home internet time period of the first mobile phone user is determined, including:

4. The method for obtaining quality information of a signal network of a mobile phone in a home of a user according to claim 2, wherein obtaining the internet surfing information of the mobile phone user under the broadband user account according to the broadband DPI service data, converting a time sequence in the internet surfing information of the mobile phone user into a time period, and obtaining the home internet surfing time periods of a plurality of associated mobile phone users under the broadband user account includes:

5. The method for obtaining quality information of a signal network of a mobile phone in a home of a user according to claim 4, wherein obtaining a network surfing record of a mobile phone terminal with a suspected mobile phone number under the broadband user account according to broadband DPI service data, and screening out a target network surfing record meeting a preset network surfing characteristic condition from the network surfing records of the mobile phone terminal comprises:

6. The method for obtaining signal network quality information of a user's home handset according to claim 1, wherein the step of obtaining signal network quality information of the user's home handset in the target area by combining the MDT data and the location information of the broadband user account includes:

7. The method for obtaining quality information of signal network of mobile phone of home of user according to claim 6, further comprising:

8. The device for acquiring the signal network quality information of the home mobile phone of the user is characterized by comprising the following components:

9. An electronic device comprising a processor and a memory storing a computer program, characterized in that the processor implements the steps of the method for obtaining quality information of a signal network of a user's home handset according to any one of claims 1 to 7 when executing the computer program.

10. A computer program product comprising a computer program, characterized in that the computer program when executed by a processor carries out the steps of the method for obtaining signal network quality information of a user's home handset according to any one of claims 1 to 7.