CN101404805B - Method for finding out network edge roaming problem through call bill depth excavation - Google Patents
Method for finding out network edge roaming problem through call bill depth excavation Download PDFInfo
- Publication number
- CN101404805B CN101404805B CN2008101951028A CN200810195102A CN101404805B CN 101404805 B CN101404805 B CN 101404805B CN 2008101951028 A CN2008101951028 A CN 2008101951028A CN 200810195102 A CN200810195102 A CN 200810195102A CN 101404805 B CN101404805 B CN 101404805B
- Authority
- CN
- China
- Prior art keywords
- suspicious
- ticket
- roaming
- border
- cities
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Images
Abstract
The invention discloses a method for finding network boundary roaming by deeply digging a call ticket. A neighbor city base station subdistrict which joins in a boundary roaming preferential charge range is chosen in a border region; a local mobile user in a signal intersection coverage of the neighbor city base station is determined; when a boundary roaming charge base station subdistrict in relation to the user appears near the base station subdistrict of the neighbor city, a boundary roaming charge suspicious boundary subdistrict appearing near the base station of the neighbor city can be located by extracting a roaming call list of the defined local mobile user to carry out active real-time screening and examining; the system easily realizes initiative discovery and real-time early warning on the suspicious boundary subdistrict, generates revolutionary innovation on discovery and treatment system of boundary roaming complaint, brings new breakthrough on timeliness and accuracy of boundary roaming discovery and treatment.
Description
Technical field
The present invention relates to communication network operation management field, especially a kind of be suitable for the common carrier stiffened edge overflow management, effectively reduce the limit and overflow and complain the effective ways of increasing customer satisfaction degree.
Background technology
" border roaming " is meant the forntier region between the different districts and cities, and the base station signal intersection covers, and taken the base station signal of outer districts and cities when the user uses mobile phone and produce the phenomenon of roaming telephone expenses under the situation that does not go out the districts and cities border.This phenomenon is not the special case in certain city or province, and it is at national administrative division intersection ubiquity; Along with changing, network cutover adjustment and network element cause wireless environment to change and corresponding preferential charging situation such as fail in time to come into force, add factors such as urban border fast development, the serious in recent years border bothersome part of roaming withdrawn occurs repeatedly, on the one hand: great inconvenience, the worry of bringing for the normal use of vast mobile phone user, on the other hand: the society, the economic loss that cause to company are inestimable; For constantly promoting corporate image, increase customer satisfaction degree and degree of belief, solve border roaming " shortage " energetically, imperative; At present common carrier generally takes stiffened edge to overflow data management, shortens the limit and overflows the complaint handling flow process, strengthens the limit and overflows measures such as complaint on-the-spot test dynamics, and the shortcoming of this way to manage is:
1, the casual data management of stiffened edge exists subjectivity strong, omits easily; The border roaming problem mainly depends on reporting of adjacent districts and cities opposite side circle data, can't real-time tracking and supervision;
2, shortening complaint handling flow process strengthens the casual on-the-spot test dynamics of complaining in limit, all can't reduce the casual complaint amount in existing limit, can only passively pinpoint the problems, and handles problems; On-the-spot test is subjected to wireless environment to influence, exist probability problem easily, influences judgement;
Summary of the invention
For solving the weak point of the casual problem in existing limit, the present invention mainly utilizes the user to roam the method that call bill depth excavation is initiatively found the casual problem in limit, particularly according to taking that roaming takes place for adjacent districts and cities sub-districts last month but the ticket writing of not receiving wandering fee is found out the border targeted customer, take the ticket writing that wandering fee is collected in adjacent districts and cities sub-district every day in conjunction with these targeted customers, location prefectures and cities border issue sub-district is as suspicious border cell, be aided with the number of times that takies simultaneously to suspicious border cell, occupation proportion and GIS map, the border cell that affirmation is failed to report is is in time reported and submitted preferential charging then.
Technical scheme of the present invention is: a kind of method of finding the casual problem in network limit by call bill depth excavation, choose the adjacent city base station cell that certain has added the casual preferential charging area in limit in the forntier region, determine the local mobile subscriber in its signal cross coverage, when the charging base station cell is overflow near the limit that occurs relative local user this neighbour city base station cell, roam the conversation inventory by extracting top fixed local mobile subscriber, carry out real-time screening of active and verification, just can orient near the casual suspicious border cell that charges in the limit that occurs this base station, neighbour city.This system has realized the active discovery and the real-time early warning of the casual suspicious border cell that charges of opposite side easily, casual discovery and the disposal system of complaining of opposite side produced revolutionary innovation, the new breakthrough that the casual ageing and accuracy of finding and handling of opposite side is also brought.
Beneficial effect of the present invention:
The present invention roams the method that call bill depth excavation is found the casual problem in network limit by a kind of to the user, has solved the casual problem in long-term existence limit, provides strong guarantee for effectively supporting market and customer service.Have the following advantages:
1, the roaming ticket analysis that makes full use of existing boundary zone user finds that initiatively suspicious limit overflows problem cells, reach and evade the artificial origin and cause failing to report and misrepresenting deliberately of border cell data, fill a vacancy with roaming call bill data leakage detection and to remedy the defective that exists of artificial judgment, the active that realizes the casual problem of opposite side is first found, monitoring and active defense in real time, reduce the casual complaint in limit to the full extent, thereby reach the rapid response user and the market demand, effectively solve the casual problem of complaining in limit
2, the existing user's ticket resource of utilization, discovery takies the truth of the casual problem cells in suspicious limit, and the drawback of having avoided artificial test to exist has increased the accuracy of judging casual sub-district, suspicious limit; Break through the specialty restriction simultaneously, realized the resource high-efficiency integration, also lay the foundation for multi-specialized modality for co-operation from now on.
Description of drawings
Fig. 1: call bill data extracts interface
Fig. 2: pre-alarming system is overflow on call bill data tap/dip deep into and limit
Fig. 3: functional framework figure
Embodiment
The present invention mainly carries out limit casual screening through subsystem to the BOSS ticket by the BOSS ticket, will screen casual data in back and the preferential metering data in border then and be sent to the casual early warning platform of call bill depth analysis and limit by the FTP mode;
The BOSS ticket is through the subsystem effect: mainly according to demand ticket is carried out preliminary treatment, will handle what happened latter single upload then and overflow the early warning platform to call bill depth analysis and limit and do further processing;
Call bill depth is analyzed and the casual early warning platform action in limit: mainly BOSS ticket after the preliminary treatment is carried out calculation process, find out suspicious border cell; It is the platform of building specially for casual sub-district, the better suspicious limit of faster discovery.
Implementation of the present invention is divided into 4 stages:
Stage 1: determine the targeted customer:
Analyze data: full dose roaming visit last month ticket
Analysis rule:
■ is a condition with the districts and cities that will analyze, and only extracts this districts and cities' roaming inventory
■ had made user's inventory of the preferential processing of roaming; Take and be adjacent to city's area code, do not receive wandering fee; The user of overflowing regional activity who promptly searches roaming but do not receive roaming charges through the limit of being everlasting
The ■ talk times surpasses the user of definition threshold values; Threshold value is rationally set according to actual needs; Filter and take phenomenon once in a while;
Analysis result:
User profile, roaming position information, talk times etc.
Select User_id, Count (1) hds, trim (cell_id) cell_id, trim (lac) lac (Subscriber Number takies number of times etc.)
From Gsm_Cdr '--last month GSM voice ticket table
Where Trim (roam_type)=" 0 " And Trim (visit_area_code) roaming type is the ticket (not receiving roaming charges) of border roaming
In (" 021 ", " 0510 ", " 0513 ", " 0523 ", " 0573 ", " 0572 ")--take city, border area code (is example with Suzhou)
Group?by?User_id,trim(cell_id),trim(lac)′;
Stage 2: extract and roam ticket every day:
Analyze data: full dose roaming visit ticket (time with the user task custom analysis is as the criterion); According to the targeted customer, extract " roaming " conversation inventory that these targeted customers take adjacent boundary districts and cities every day, set up database (verifying time span can suitably choose according to actual needs)
Analysis rule:
■ is a condition with the districts and cities that will analyze, and only extracts this districts and cities' roaming inventory
■ is a condition with the time of user task custom analysis
■ did not make user's inventory of the preferential processing of roaming
■ Subscriber Number and targeted customer's numbers match
Analysis result:
User profile, roaming position information, talk times etc.
Select?User_id,To_Number(msisdn)msisdn,Count(1)hds,trim(cell_id)cell_id,trim(lac)lac
FromGsm_Cdr GSM every day voice ticket table
Where Trim (roam_type)=" 1 " or Trim (roam_type)=" 4 " And Trim (visit_area_code)--roaming type be roam inside the province, the ticket of inter-provincial roaming
In (" 021 ", " 0510 ", " 0513 ", " 0523 ", " 0573 ", " 0572 ")--take city, border area code (is example with Suzhou)
And Exists (Select1From month_roamcell_hz b Where a.User_id=b.User_id)---Subscriber Number and targeted customer's numbers match
Group?by?User_id,To_Number(msisdn),trim(cell_id),trim(lac);
Stage 3: carry out data boundary and verify: carry out the suspicious border cell screening of different districts and cities, different districts and the whole province according to suspicious sub-district being taken number and occupation proportion;
The sub-district is analyzed
Business background:, search for the CU number and the CU inventory of this suspicious sub-district according to the suspicious sub-district that customer complaint is learnt.
Analyze data: this month roaming visit ticket
Analysis condition: designated cell, time, number of calls threshold values
Analysis rule: in the roaming ticket of every day, according to field LAC, CI, search out the suspicious number of charging that the number of calls surpasses threshold values
Analysis result:
Cell name, Lac, CI, ownership districts and cities, time, msisdn, the number of calls
Districts and cities analyze
Business background:, find out these users and roam this month and visit to the suspicious sub-district that border districts and cities collect roaming charges according to targeted customer's last month who specifies districts and cities.
Analyze data: specify casual sub-district, limit full dose roaming visit ticket, this month roaming visit ticket last month
Analysis condition: specify the targeted customer of districts and cities, time, suspicious sub-district to count targeted customer's proportion of threshold values, suspicious sub-district
Analysis rule:
Each preferential charging sub-district to given city travels through verification.If A is preferential charging sub-district, at first in targeted customer's table, filter out the potential user group of A sub-district by LAC and CI.
The roaming inventory on the targeted customer by the A sub-district and targeted customer same day searches out the roaming cell that this group user takies
Filter out the most suspicious roaming cell by setting threshold value (this roaming cell occupant content, number/A sub-district targeted customer's number of ratio=take).Targeted customer's proportion that the targeted customer of suspicious sub-district counts threshold values, suspicious sub-district between the two be " with " relation
Analysis result:
Cell name, Lac, CI, ownership districts and cities, adjacently be capped districts and cities and fate appears in adjacent targeted customer's proportion, time period, the accumulative total that is capped districts and cities' code (deriving from the user attaching area code AREA_CODE in border roaming target user data or the suspicious border roaming user data), this sub-district roamer's number, targeted customer's number of given city, suspicious sub-district
The whole province's analysis classes is analyzed like the city, finds out the suspicious border cell of the whole province
Stage 4: confirm that suspicious border cell carries out preferential reporting and submitting;
Suspicious sub-district take number and occupation proportion situation in conjunction with the whole province and districts and cities in a period of time, send to simultaneously and carry out the GIS location in the network optimization platform and calculate automatically to frontier distance, be aided with artificial judgment, the suspicious border cell of preferential charging is reported and submitted in affirmation at last.
Though the present invention is described by embodiment, embodiment is used for limiting the present invention.Those skilled in the art can make various distortion and improvement in the scope of spirit of the present invention, so being as the criterion of should being defined with the application's claim protection range of protection scope of the present invention.
Claims (2)
1. find that by call bill depth excavation the network limit overflows the method for problem for one kind, it is characterized in that, choose the adjacent city base station cell that certain has added the casual preferential charging area in limit in the forntier region, determine the local mobile subscriber in its signal cross coverage, when the charging base station cell is overflow near the limit that occurs relative local user this neighbour city base station cell, roam the conversation inventory by extracting fixed local mobile subscriber, carry out real-time screening of active and verification, orient near the casual suspicious border cell that charges in the limit that occurs this neighbour city base station cell;
Specifically may further comprise the steps:
Step 1 is determined the targeted customer;
Step 2 is extracted the targeted customer and is roamed ticket every day;
Step 3 is carried out data boundary and is verified;
Step 4 determines that suspicious border cell carries out preferential reporting and submitting;
Described definite targeted customer is meant: analyze full dose roaming visit last month ticket, according to taking that roaming takes place in adjacent districts and cities sub-district last month but the ticket writing of not receiving wandering fee is found out the border targeted customer; Rationally set threshold value according to actual needs, analyze the user that talk times surpasses the definition threshold value, take phenomenon once in a while to filter;
Described extraction targeted customer roams ticket every day and is meant: be as the criterion with time of user task custom analysis and analyze full dose roaming visit ticket; According to the targeted customer, extract " roaming " conversation inventory that these targeted customers take adjacent boundary districts and cities every day, set up database;
The described data boundary that carries out is verified and to be meant: the adjacent districts and cities of combining target CU collect the sub-district ticket writing of wandering fee, location prefectures and cities border issue sub-district is carried out the suspicious border cell screening of different districts and cities, different districts as suspicious border cell according to suspicious border cell being taken number and occupation proportion;
The suspicious border cell of described affirmation carries out preferential reporting and submitting and is meant: in conjunction with districts and cities in a period of time suspicious border cell take the number and the occupation proportion situation, send to simultaneously and carry out GIS location in the network optimization platform and calculate automatically to frontier distance, be aided with artificial judgment, confirm to report and submit the suspicious border cell of preferential charging at last.
2. find that by call bill depth excavation the network limit overflows the system of problem for one kind, it is characterized in that it comprises,
Data acquisition unit: through subsystem the BOSS ticket is carried out the casual preferential data filling mining of call bill data collection and limit by the BOSS ticket, will screen casual data in back and the preferential metering data in border then and be sent to the casual early warning platform of call bill depth analysis and limit by the FTP mode;
Data analysis unit: data statistic analysis full dose last month roaming visit ticket, according to taking that roaming takes place for adjacent districts and cities sub-districts last month but the ticket writing of not receiving wandering fee is found out the border targeted customer, extract the targeted customer and roam ticket every day and carry out the data boundary contrast and verify;
Use display unit: the adjacent districts and cities of combining target CU collect the sub-district ticket writing of wandering fee, location prefectures and cities border issue sub-district is as suspicious border cell, carry out the suspicious border cell screening of different districts and cities, different districts according to suspicious border cell being taken number and occupation proportion, obtain that the whole network verifies that the result presents, specific cell verifies that the result presents, the town verifies that the result presents and the limit is overflow the sub-district and presented;
The issue handling unit: in conjunction with districts and cities in a period of time suspicious border cell take the number and the occupation proportion situation, send to simultaneously and carry out GIS location in the network optimization platform and calculate automatically to frontier distance, be aided with artificial judgment, confirm that at last form sends the suspicious border cell of preferential charging;
Described BOSS ticket is meant through subsystem: according to demand ticket is carried out preliminary treatment, will handle what happened latter single upload then and do further processing to the casual early warning platform of call bill depth analysis and limit;
The casual early warning platform in described call bill depth analysis and limit is meant: BOSS ticket after the preliminary treatment is carried out calculation process, find out suspicious border cell.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2008101951028A CN101404805B (en) | 2008-11-05 | 2008-11-05 | Method for finding out network edge roaming problem through call bill depth excavation |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2008101951028A CN101404805B (en) | 2008-11-05 | 2008-11-05 | Method for finding out network edge roaming problem through call bill depth excavation |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101404805A CN101404805A (en) | 2009-04-08 |
CN101404805B true CN101404805B (en) | 2011-05-18 |
Family
ID=40538647
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2008101951028A Expired - Fee Related CN101404805B (en) | 2008-11-05 | 2008-11-05 | Method for finding out network edge roaming problem through call bill depth excavation |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101404805B (en) |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102083083B (en) * | 2009-11-30 | 2013-04-03 | 中国移动通信集团广西有限公司 | Method and device for confirming boundary roaming base station |
CN104735710B (en) * | 2015-03-18 | 2018-09-04 | 大连理工大学 | A kind of mobile network property early warning pre-judging method based on trend extropolation cluster |
CN113473487B (en) * | 2020-03-31 | 2022-09-27 | 中国移动通信集团贵州有限公司 | Method, device, equipment and storage medium for optimizing store construction in base station area |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1674707A (en) * | 2004-03-24 | 2005-09-28 | 华为技术有限公司 | Method for realizing charge metering of boundary roaming |
CN1809215A (en) * | 2006-02-10 | 2006-07-26 | 中国移动通信集团公司 | Regional border roaming control method for mobile communication system |
CN101094516A (en) * | 2007-07-20 | 2007-12-26 | 中国移动通信集团福建有限公司 | Device of automatic tracking system for borderline roam on adjacent sectors |
-
2008
- 2008-11-05 CN CN2008101951028A patent/CN101404805B/en not_active Expired - Fee Related
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1674707A (en) * | 2004-03-24 | 2005-09-28 | 华为技术有限公司 | Method for realizing charge metering of boundary roaming |
CN1809215A (en) * | 2006-02-10 | 2006-07-26 | 中国移动通信集团公司 | Regional border roaming control method for mobile communication system |
CN101094516A (en) * | 2007-07-20 | 2007-12-26 | 中国移动通信集团福建有限公司 | Device of automatic tracking system for borderline roam on adjacent sectors |
Also Published As
Publication number | Publication date |
---|---|
CN101404805A (en) | 2009-04-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104484993B (en) | Processing method of cell phone signaling information for dividing traffic zones | |
CN108924333B (en) | Fraud telephone identification method, device and system | |
CN106295787B (en) | A kind of passenger flow statistical method and device based on mobile signaling protocol | |
CN102097004B (en) | Mobile phone positioning data-based traveling origin-destination (OD) matrix acquisition method | |
CN103116696B (en) | Personnel based on the mobile phone location data of sparse sampling reside place recognition methods | |
CN105513351A (en) | Traffic travel characteristic data extraction method based on big data | |
CN102609616A (en) | Dynamic population distribution density detecting method based on mobile phone positioning data | |
CN102149119A (en) | Speech service quality end-to-end analyzing method | |
CN102149103A (en) | Network optimizing system and method | |
CN103037388B (en) | Method and device for confirming distribution of user equipment | |
EP2608181B1 (en) | Method for detecting traffic | |
CN106658394A (en) | High-speed rail user separation method and apparatus thereof | |
CN101404805B (en) | Method for finding out network edge roaming problem through call bill depth excavation | |
CN102083083B (en) | Method and device for confirming boundary roaming base station | |
Wang et al. | A novel complaint calls handle scheme using big data analytics in mobile networks | |
CN106504524A (en) | A kind of method that express highway section is divided based on mobile signaling protocol dynamic | |
CN103888961A (en) | User monitoring method and device | |
CN102131202A (en) | Method for geographic gridding of communication network information based on area method | |
CN103491568A (en) | Mobile network road optimized analysis system | |
CN107889210B (en) | Building user positioning method and system | |
CN110012436B (en) | User position determination method, device, equipment and computer readable storage medium | |
CN104683982A (en) | False base station determination method based on data mining of signaling system | |
CN107644390A (en) | A kind of method and device for obtaining track platform passenger flow data | |
CN103037386B (en) | A kind of network telephone traffic distribution method made based on A mouth and IU-CS message | |
CN103124430A (en) | Method and system for locating indoor users |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20110518 Termination date: 20211105 |
|
CF01 | Termination of patent right due to non-payment of annual fee |