CN106900004B - Method for associating the LTE network wireless measurement report MR record with the IMSI number - Google Patents

Abstract

The invention discloses a kind of methods of association LTE network wireless measurement report MR record ownership IMSI number, comprising: 1. reports that relevant field searches MME relevant field in MR database by LTE wireless measurement；2. obtaining the corresponding IMSI number of this MR data by MME relevant field in LTE core network database.The problem of measurement report MR data that the present invention solves previous wireless side can not correspond to IMSI number, and wireless side analysis can only cannot be based on particular user based on cell.

Description

Method for associating the LTE network wireless measurement report MR record with the IMSI number

technical field

The invention belongs to the field of data mining and analysis in mobile communication, and in particular relates to a method for associating an LTE network wireless measurement report MR record with an IMSI number.

Background technique

According to the agreement, LTE cannot obtain the user's IMSI number on the wireless side. MR is LTE's wireless measurement report (Measure Report), in which RSRP (Reference Signal Receiving Power) and RSRQ (Reference Signal Receiving Quality) can reflect the user experience in the cell, but in the wireless measurement report The MR database does not reflect the user's mobile phone number MSISDN and IMSI number. As a result, when the wireless side analyzes the user's experience, it can only make statistics by cell, and cannot effectively target specific users.

Contents of the invention

The purpose of the present invention is to solve the above-mentioned existing problems, and provide a method for attributing the IMSI number of the associated LTE network wireless measurement report MR record, through the query of the MR related field in the LTE wireless side measurement report database, after processing, and through the LTE core network The association of the database CHR (Call History Record) is analyzed to obtain the IMSI of the belonging user of the MR record.

Technical solution of the present invention is as follows:

A method for associating an LTE network wireless measurement report MR record with an IMSI number, characterized in that: the method includes the following steps:

Step 1) Extract the MME UE S1AP ID, MMEC, MMEGI, eNB ID and Time fields of the MR record to be checked from the wireless measurement report database;

Step 2) Convert the MME UE S1AP ID, MMEC, MMEGI, and eNB ID in step 1) from decimal to hexadecimal, where MMEGI is converted to a four-digit hexadecimal number, set it to G0G1G2G3, and then the left two digits and Swap the two digits on the right to get G2G3G0G1; convert MMEC to a two-digit hexadecimal number and set it to C0C1; convert the MME UE S1AP ID to hexadecimal number and set it to S; convert the eNB ID to hexadecimal number and set it to Nb; Time value remains unchanged, set to time_value;

Step 3) In the core network signaling call history record CHR database, according to the eNB ID, query the 16-byte device number device_num within the latest time_value, and set it as DN0DN1DN2DN3DN4DN5DN6DN7DN8DN9DN10DN11DN12DN13DN14DN15;

Step 4) Form a new device_numnew from MMEGI, MMEC and device_num data, the rules are as follows:

The first 6 digits of device_num remain unchanged, the 7th to 10th digits are replaced with the MMEGI obtained in step 2), the 11th to 12th digits are replaced with the MMEC obtained in step 3), and the last 4 digits on the right remain unchanged, that is, DN0DN1DN2DN3DN4DN5G2G3G0G1C0C1DN12DN13DN14DN15;

Step 5) According to the device_numnew obtained in step 4) and the hexadecimal MME UES1AP ID, eNB ID value S, Nb obtained in step 2), and the original time value time_value, query the MR in the CHR table according to the following conditions Recorded IMSI number:

device_num is equal to device_numnew,

mme_uesiap is equal to 0xS,

enodeb_id is equal to N,

time_value-180<mme_uesiap_utc<time_value+180;

Step 6) Obtain the IMSI number of the MR record.

The mme_uesiap_utc time plus and minus 180: refers to the time deviation of 3 minutes and 180 seconds.

Query according to this condition in the CHR table to obtain the IMSI corresponding to the MR.

The requirements for the fields used in the query are as follows: use the MME-related fields MME UE S1AP ID, MMEC, MMEGI and the eNB ID and Time fields in the MR table to query.

When querying the CHR table, the time condition mme_uesiap_utc should be within 3 minutes before and after the time time_value of the MR record.

Compared with prior art, the beneficial effect of the present invention is:

By extracting specific fields in the MR table and converting them into related fields of core network signaling, and limiting them within a certain time range, the query efficiency of the IMSI number corresponding to the MR record is effectively improved, thereby solving the problem of the previous LTE wireless side. The problem that MR data and core network IMSI data cannot be correlated creates conditions for user-based wireless perception analysis. It has good promotion and application value.

Description of drawings

Fig. 1 is the application system network diagram of the method for associating the LTE network wireless measurement report MR record attribution IMSI number in the present invention

Fig. 2 is some fields of the wireless measurement report MR data table in the embodiment of the present invention

Fig. 3 is the algorithm flowchart in the embodiment of the present invention

Fig. 4 is some fields of the core network signaling call history record CHR data table in the embodiment of the present invention

Detailed ways

The present invention will be further described below in conjunction with the embodiments and accompanying drawings, but the protection scope of the present invention should not be limited thereby.

Due to the large amount of MR data, the present invention should adopt a big data platform. The data sources of this patent system are the wireless measurement report MR database on the LTE wireless side and the call history record signaling bill CHR database on the core network side, and the above data sources are provided to the associated devices shown in Figure 1, such as computers. The data format of the wireless measurement report MR table is shown in Figure 2.

MMEGI (MME Group ID): MME group number

MMEC (MME Code): MME number

MME UE S1AP ID: MME UE S1 Application Protocol ID number

eNB ID (eNodeB ID): eNodeB base station number

Time: the timestamp corresponding to the MR

Serving Cell RSRP: Serving Cell Positioning RSRP

Serving Cell RSRQ: RSRQ of the serving cell

Neighbor Cell RSRP: RSRP of adjacent cells

Neighbor Cell RSRQ: RSRQ of adjacent cells

At the same time, the core network signaling bill call history record CHR table shown in Figure 4 should be obtained, including information such as the IMSI number of the user in each record, mme_uesiap, and the corresponding time.

device_num: device number

imsi: International Mobile Subscriber Identity

msisdn: mobile station number

enodeb_id: eNodeB base station number

mme_uesiap: MME UE S1 Application Protocol ID number

mme_uesiap_utc: the generation time of the UES1AP connection identifier assigned by the MME

As shown in Figure 1: First, extract the MME UE S1AP ID, MMEC, MMEGI, eNB ID, and Time fields from the records to be checked in the MR table of the wireless measurement report. After transforming the MMEGI, combine them with the original device_num in the CHR table to form a new The device number device_numnew is associated with other related fields in the CHR table. Considering a certain time difference, the IMSI number of the MR record is queried.

details as follows:

1) Simultaneously extract the MME UE S1AP ID, MMEC, MMEGI, eNB ID, and Time fields of the MR record to be checked from the LTE wireless measurement report database;

2) Convert the MME UE S1AP ID, MMEC, MMEGI, and eNB ID in 1) from decimal to hexadecimal. Among them, MMEGI becomes a four-digit hexadecimal number, which is set to G0G1G2G3, and then the left and right two digits are exchanged for G2G3G0G1. MMEC becomes a two-digit hexadecimal number, set to C0C1. The MME UE S1AP ID is converted to hexadecimal and set to S. The eNB ID is converted to hexadecimal and set to Nb. The Time value remains unchanged and is set to time_value.

3) In the LTE core network signaling CHR database, according to the eNB ID, query the 16-byte device number device_num within the latest time_value, and set it as DN0DN1DN2DN3DN4DN5DN6DN7DN8DN9DN10DN11DN12DN13DN14DN15.

4) From the MMEGI, MME Code and device_num data in 2) and 3), the 6 digits to the left of device_num remain unchanged, the 7th to 10th digits are replaced with the converted MMEGI (ie G2G3G0G1), and the 11th to 12th digits are replaced with MMEC (ie C0C1), the 4 bits on the right remain unchanged to form a new device_numnew: DN0DN1DN2DN3DN4DN5G2G3G0G1C0C1DN12DN13DN14DN15.

5) According to the new device_numnew, and the MME UE S1AP ID, eNB ID value S, Nb converted into hexadecimal, and the original time value time_value, query the IMSI number of the MR record in the CHR table according to the following conditions: Device number is equal to device_numnew, mme_uesiap is equal to 0xS, enodeb_id is equal to N, mme_uesiap_utc time>time_value-180 and mme_uesiap_utc time<time_value+180. The addition and subtraction of 180 in time means 180 seconds in 3 minutes.

The invention solves the problem that the MR data of the measurement report on the wireless side cannot correspond to the IMSI number in the past, and the analysis on the wireless side can only be based on the cell and not on the specific user.

Claims (1)

1. a kind of method of association LTE network wireless measurement report MR record ownership IMSI number, it is characterised in that: this method includes Following steps:

MME UE S1AP ID, MMEC, MMEGI, eNB of MR record to be checked are extracted in step 1) wireless measurement report database ID and Time field；

MME UE S1AP ID, MMEC, MMEGI, eNB ID in step 1) from the decimal system is converted to hexadecimal by step 2), Wherein MMEGI is converted to four hexadecimal numbers, is set as G0G1G2G3, and then left two are exchanged with right two, obtains G2G3G0G1；MMEC is converted to two hexadecimal numbers, is set as C0C1；MMEUE S1AP ID is converted to hexadecimal, is set as S； ENB ID is converted into hexadecimal, is set as Nb；Time value is constant, is set as time_value；

Step 3), according to eNB ID, is inquired nearest in time_value in core network signalling call history CHR database The device number device_num of 16 bytes in time, is set as DN0DN1DN2DN3DN4DN5DN6DN7DN8DN9DN10DN1 1DN12DN13DN14DN15；

Step 4) is made of new device_numnew MMEGI, MMEC and device_num data, and rule is as follows:

6 remain unchanged before device_num, and the 7th~10 replaces with the MMEGI that step 2) obtains, and the 11st~12 replaces with The MMEC that step 3) obtains, rear 4, the right remain unchanged, i.e. DN0DN1DN2DN3DN4DN5G2G3G0G1C0C1DN12DN13D N14DN15；

Hexadecimal MMEUE S1AP ID that the device_numnew and step 2) that step 5) is obtained according to step 4) are obtained, ENB ID value S, Nb and original time value time_value, by following this of condition query MR record in CHR table IMSI number:

Device_num is equal to device_numnew,

Mme_uesiap is equal to 0xS,

Enodeb_id is equal to Nb,

time_value-180<mme_uesiap_utc<time_value+180；

Step 6) obtains the IMSI number of this MR record.