CN107818133A - A kind of residential block network capabilities analysis method and system based on big data - Google Patents

A kind of residential block network capabilities analysis method and system based on big data Download PDF

Info

Publication number
CN107818133A
CN107818133A CN201710859665.1A CN201710859665A CN107818133A CN 107818133 A CN107818133 A CN 107818133A CN 201710859665 A CN201710859665 A CN 201710859665A CN 107818133 A CN107818133 A CN 107818133A
Authority
CN
China
Prior art keywords
residential block
family
wide
user
cell
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.)
Granted
Application number
CN201710859665.1A
Other languages
Chinese (zh)
Other versions
CN107818133B (en
Inventor
王迪
于洁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Metarnet Technologies Co Ltd
Original Assignee
Beijing Metarnet Technologies Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Metarnet Technologies Co Ltd filed Critical Beijing Metarnet Technologies Co Ltd
Priority to CN201710859665.1A priority Critical patent/CN107818133B/en
Publication of CN107818133A publication Critical patent/CN107818133A/en
Application granted granted Critical
Publication of CN107818133B publication Critical patent/CN107818133B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2465Query processing support for facilitating data mining operations in structured databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2471Distributed queries

Abstract

The embodiment of the present invention provides a kind of residential block network capabilities analysis method and system based on big data.Methods described includes:Obtain MRO data, residential block information, the wide cell information of family, LTE signalings and the family's visitor's resource of preset number of days;Analyzed using residential block and wireless area correlation model, residential block resident user correlation model, the wide potential target user's identification model of the wide cell association model in residential block and family and family, obtain the incidence relation between residential block, the wide cell in wireless area and family;Exported incidence relation as analysis result.The system is used to perform methods described.The embodiment of the present invention is analyzed by residential block and wireless area correlation model, residential block resident user correlation model, the wide potential target user's identification model of the wide cell association model in residential block and family and family, the incidence relation between residential block, the wide cell in wireless area and family is obtained, so as to the network coverage situation of efficient, accurate analysis residential block.

Description

A kind of residential block network capabilities analysis method and system based on big data
Technical field
The present embodiments relate to big data processing technology field, more particularly to a kind of residential block network based on big data Capability analysis method and system.
Background technology
As 4G and broadband services are after network and market scale development, have increasing need for us and carry out what is become more meticulous Networking and marketing.In terms of network-oriented, the covering of 4G depth:By dividing scene analysis to data such as MR, test, complaints, The subject matter of current network concentrates on the high-rise indoor, residential block in city.4G macro station construction, study emphasis 4G will be reduced within 2017 Depth covering is built.
Currently carry out broadband light and change policy, less than 20,000,000 low bandwidth user's churn rates are more than 20,000,000 high-bandwidth users 2 times, and it is that the light for completing storage FTTB residential blocks changes to accelerate the storage user premise raised the price that raises speed.In addition, largely move 4G Mobile phone connects WIFI online after user's custom is got home, and causes 4G flows to excite limited.Market-oriented aspect, market department wishes to pass through Signaling big data identifies the behavior of user terminal connection WIFI online, connects mobile broadband, movement eventually for mobile terminal WIFI End WIFI connects rete mirabile broadband, heterogeneous network terminal WIFI connects mobile broadband three behaviors specific aim and carries out flow and excites or rete mirabile instigates rebellion within enemy camp battalion Pin.Therefore, being fully understood by covering residential block network condition helps to carry out the work such as the network optimization, planning construction, the marketing Development.At present, be all to network coverage residential block situation by manually going field investigation, so not only under efficiency, and Analysis result may be caused inaccurate due to subjective factor of people etc..Therefore how efficiently, accurately the network of residential block is covered It is problem nowadays urgently to be resolved hurrily that lid situation, which carries out analysis,.
The content of the invention
The problem of existing for prior art, the embodiment of the present invention provide a kind of residential block network capabilities based on big data Analysis method and system.
In a first aspect, the embodiment of the present invention provides a kind of residential block network capabilities analysis method based on big data, including:
The data source information of preset number of days is obtained, the data source information includes:MRO data, residential block information, family are wide small Area's information, LTE signalings and family's visitor's resource;
According to the MRO data, institute's residential block information, the wide cell information of man of institute and institute's LTE signalings, residential block and nothing are utilized Line cell association model, residential block resident user correlation model, the wide cell association model in residential block and family and the wide potential target of family User's identification model is analyzed, and obtains the incidence relation between residential block, the wide cell in wireless area and family;
Exported the incidence relation between the residential block, the wide cell in wireless area and family as analysis result.
Second aspect, the embodiment of the present invention provide a kind of residential block network capabilities analysis system based on big data, including: Data active layer, acquisition layer, storage and process layer and application layer;
The data active layer is used to provide data source, and the data source includes MRO data, residential block information, the wide cell of family Information and LTE signalings;
The acquisition layer is used for from the data active layer gathered data source;
The storage is used to handle the data source that collects with process layer, acquisition residential block respectively with wirelessly Incidence relation between cell, the wide cell of resident user man and potential user, and by incidence relation storage into database;
The application layer is used to obtain inquiry request, and data are obtained from corresponding database according to the inquiry request, And the data got are returned.
The third aspect, the embodiment of the present invention provide a kind of electronic equipment, including:Processor, memory and bus, wherein,
The processor and the memory complete mutual communication by the bus;
The memory storage has and by the programmed instruction of the computing device, the processor described program can be called to refer to Order is able to carry out the method and step of first aspect.
Fourth aspect, the embodiment of the present invention provide a kind of non-transient computer readable storage medium storing program for executing, including:
The non-transient computer readable storage medium storing program for executing stores computer instruction, and the computer instruction makes the computer Perform the method and step of first aspect.
A kind of residential block network capabilities analysis method and system based on big data provided in an embodiment of the present invention, pass through root According to MRO data, residential block information, the wide cell information of family and LTE signalings, residential block and wireless area correlation model, resident are utilized Area's resident user correlation model, the wide potential target user's identification model of the wide cell association model in residential block and family and family are divided Analysis, obtain residential block, the incidence relation between the wide cell in wireless area and family, so as to it is efficient, accurately analyze residential block Network coverage situation.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are this hairs Some bright embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can be with root Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is a kind of residential block network capabilities analysis method flow signal based on big data provided in an embodiment of the present invention Figure;
Fig. 2 is residential block provided in an embodiment of the present invention and wireless area correlation model Establishing process schematic diagram;
Fig. 3 is to identify user's resident population area schematic flow sheet based on signaling;
Fig. 4 identifies user's resident population area schematic flow sheet to be provided in an embodiment of the present invention based on voice ticket;
Fig. 5 is residential block provided in an embodiment of the present invention and the wide cell association model Establishing process schematic diagram of family;
Fig. 6 is provided in an embodiment of the present invention wide potential target user's identification model Establishing process schematic diagram;
Fig. 7 is residential block provided in an embodiment of the present invention and wireless area incidence relation schematic diagram;
Fig. 8 is resident user list schematic diagram in residential block provided in an embodiment of the present invention;
Fig. 9 is residential block provided in an embodiment of the present invention and the wide cell association list schematic diagram of family;
Figure 10 is provided in an embodiment of the present invention wide potential target user list schematic diagram;
Figure 11 is that a kind of residential block network capabilities analysis system structure based on big data provided in an embodiment of the present invention is shown It is intended to;
Figure 12 is the residential block network capabilities analysis system business structure figure provided in an embodiment of the present invention based on big data;
Figure 13 is electronic equipment entity structure schematic diagram provided in an embodiment of the present invention.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is Part of the embodiment of the present invention, rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art The every other embodiment obtained under the premise of creative work is not made, belongs to the scope of protection of the invention.
Fig. 1 is a kind of residential block network capabilities analysis method flow signal based on big data provided in an embodiment of the present invention Figure, as shown in figure 1, methods described, including:
Step 101:The data source information of preset number of days is obtained, the data source information includes:MRO data, residential block letter Breath, the wide cell information of family, LTE signalings and family's visitor's resource;
Specifically, system obtains the data source information of preset number of days, wherein, preset number of days can be seven days, can also root It is adjusted according to actual conditions, data source information includes MRO data, residential block information, the wide cell information of family, LTE signalings and family Objective resource, family visitor XDR, network optimization platform data can also be included, be come from through divided data and ARCGIS data etc., data above some Each base station, some come from other equipment.
Step 102:According to the MRO data, the residential block information, described wide cell information and the LTE signalings, Utilize residential block and wireless area correlation model, residential block resident user correlation model, the wide cell association model in residential block and family Analyzed with family wide potential target user's identification model, the association obtained between residential block, the wide cell in wireless area and family is closed System;
Specifically, corresponding model is input to according to MRO data, residential block information, the wide cell information of family and LTE signalings In, i.e., MRO data and residential block information are input in residential block and wireless area correlation model, obtain residential block with it is wirelessly small Which wireless area the incidence relation in area, i.e. some residential block include.Closed according to LTE signalings and residential block with wireless area Gang mould type can obtain the incidence relation of residential block resident wireless area corresponding with resident user.By the wide cell information of family and residence People area information is input to residential block with the wide cell association model of family, obtaining the incidence relation of residential block and the wide cell of family.By family Objective resource input is got home in wide potential target user's identification model, is obtained and is opened the user in targeted carrier broadband, opens competition The user in opponent operator broadband and the user for not opening broadband.It should be noted that residential block associates with wireless area Model, residential block resident user correlation model, the wide potential target user's identification mould of the wide cell association model in residential block and family and family Type all pre-establishes.
Step 103:Incidence relation between the residential block, the wide cell in wireless area and family is defeated as analysis result Go out.
Specifically, by using residential block and wireless area correlation model, residential block resident user correlation model, residential block The wide potential target user's identification model of cell association model wide with family and family is analyzed, and after obtaining analysis result, analysis is tied Incidence relation output between the wide cell in residential block, wireless area and family in fruit, to related management personnel be directed to The work such as the network optimization of property, planning construction, the marketing.
The embodiment of the present invention is by according to MRO data, residential block information, the wide cell information of family and LTE signalings, utilizing resident Area is wide latent with wireless area correlation model, residential block resident user correlation model, the wide cell association model in residential block and family and family Analyzed in targeted customer's identification model, obtain the incidence relation between residential block, the wide cell in wireless area and family, so as to Enough network coverage situations for efficiently, accurately analyzing residential block.
On the basis of above-described embodiment, methods described, in addition to:
Obtain the MRO data of the user of the preset number of days and the residential block information;The MRO data include TA values with AOA values, the residential block information include residential block longitude and latitude;
The TA values in the MRO data of each user are corresponding with AOA values calculating acquisition each user Wireless cell information, the wireless cell information includes cell longitude and latitude;
According to the residential block longitude and latitude and the cell longitude and latitude obtain the residential block to be analyzed with it is described wirelessly small The incidence relation in area, and number of days carries out descending sort according to corresponding to the residential block for belonging to Target Wireless cell;
Ownership residential block of the residential block of sequence first as the Target Wireless cell is obtained, to obtain the residential block With wireless area correlation model.
Specifically, Fig. 2 is residential block provided in an embodiment of the present invention and wireless area correlation model Establishing process schematic diagram, As shown in Fig. 2 including:
Step 201:Obtain MRO data;Obtain preset number of days user MRO data, MRO data include TA values with AOA values, can also include Base Station Identification, the information such as eci marks, and user can be user in predeterminable area or All users.
Step 202:Calculate wireless area corresponding to obtaining;TA values and AOA values in MRO data, which calculate, obtains MRO The latitude and longitude information of point, can obtain corresponding wireless area according to MRO latitude and longitude informations and wireless cell information, should say Bright, wireless cell information includes cell longitude and latitude, can also including cell name etc. information.
Step 203:Obtain residential block information;All residential blocks are obtained by high moral map or other third party softwares to wrap The residential block longitude and latitude included, because residential block is planar, therefore, residential block corresponds to multiple residential block longitudes and latitudes, is a collection Close.
Step 204:Matching;Cell longitude and latitude corresponding to MRO data in every day and residential block longitude and latitude are matched, Recorded if matching, therefore there is number of days in the residential block that can get each wireless area, and according to appearance Number of days carries out descending sort to residential block.
Step 205:Obtain residential block and wireless area correlation model;Ranking corresponding to each wireless area is obtained respectively Ownership residential block of first residential block as the wireless area, so as to form residential block and wireless area correlation model.
Table 1 is residential block provided in an embodiment of the present invention and wireless area incidence relation list, as shown in table 1:
Table 1
Wherein, 4G cells TAC encodes for base station tracks area, and 4G cells ECI is a signaling function in LTE.
It should be noted that can per diem it be analyzed, i.e. on the basis of the MRO data obtained originally, all obtain daily The MRO data on the same day are taken, are added up day by day then according to the flow of above-mentioned steps 202- steps 205, so as to improve the accurate of analysis Degree.
The embodiment of the present invention acquires each wireless area ownership by establishing residential block and wireless area correlation model Residential block, laid the foundation for ensuing analysis.
On the basis of above-described embodiment, methods described, in addition to:
Obtain in the preset number of days LTE signalings caused by targeted customer, the LTE signalings bag in daily preset time period Include and produce wireless area and corresponding user profile corresponding to the LTE signalings;
Descending sort is carried out to wireless area corresponding to producing LTE signalings according to number of days, obtains and sorts forward default Resident wireless area of several wireless areas as the targeted customer;
According to the residential block and wireless area correlation model, the pass of the acquisition resident wireless area and the residential block Connection relation, to obtain the residential block resident user correlation model.
Specifically, system obtains in preset number of days LTE signalings, example caused by the targeted customer in preset time period daily Such as, 3 are counted daily:00-6:Wireless area and user corresponding to user SI-MME chain of command signaling events in 00 this period Information, count 7 days altogether, because targeted customer is not necessarily all the time in same cell, therefore, statistics produces LTE letters in 7 days The number of days of wireless area corresponding to order, descending sort is carried out to wireless area according to corresponding number of days, number of days accounting occurs in acquisition More than the resident cell of total number of days 0.3 and the ranking wireless area of first three as the targeted customer.According to residential block and wirelessly Cell association model, the resident cell of targeted customer can be corresponded to some residential block, residential block is resident to be used so as to obtain Family correlation model.
Table 2 is resident user incidence relation list in residential block provided in an embodiment of the present invention, as shown in table 2:
Table 2
It should be noted that targeted customer is the resident user of the residential block with incidence relation, whether targeted customer is judged Have for the method for resident user:
Algorithm 1:Based on signaling identification user's resident population area
Fig. 3 is to identify user's resident population area schematic flow sheet based on signaling, as shown in figure 3, being obtained based on 2/3/4G signalings Obtain mobile phone and be resident base station cell information, step 301:Counting user night (21:00- next day 7:00) use of control signaling caused by Family;Step 302:The resident duration of user is judged according to control information, using wireless area of the resident duration more than 3 hours as day Resident wireless area;Step 303:Wireless area will be resided day in one month and is resident most resident wireless small as the moon of number Area;Step 304:Obtain the residential block above established and wireless area correlation model;Step 305:The resident base station of user is small Area corresponds to some residential block, and so we are obtained with resident user all in some residential block.
It is attached:User is resident wireless area duration algorithm:Whole events that record mobile phone occurs in each base station cell (are opened Machine, location updating, shutdown, call, short message, internet behavior etc.) time.
Algorithm 2:Method identification user's resident population area is got ready based on MR
Per diem pass through user 21:00- next day 6:The detailed forms datas of 00MR, obtain user and carry out service interaction behavior with network Longitude and latitude point information, using user's longitude and latitude point data and the cell longitude and latitude of residential quarter, contain algorithm by ordering bread, obtain User and residential area incidence relation.
Above rule is per diem analyzed, and generation day granularity conclusion, data is per diem added up, take middle of the month number of days TOP1 residence People's cell is the residential area that user lives.
Algorithm 3:Based on voice ticket identification user's resident population area
Fig. 4 identifies user's resident population area schematic flow sheet, such as Fig. 4 to be provided in an embodiment of the present invention based on voice ticket It is shown, step 401:Obtain daily 21:00-0:00 user through dividing ticket;Step 402:Obtain daily 21:00-0:00 is logical Talk about the most wireless area of number;Step 403:Obtain the residential block above established and wireless area correlation model;Step 404: The resident base station cell of user is corresponded into some residential block, it is possible to obtain the residential block that user resides.
The embodiment of the present invention can obtain resident use corresponding to residential block by establishing residential block resident user correlation model Family, consequently facilitating relevant staff carries out the operation such as promoting service to it.
On the basis of above-described embodiment, the residential block information includes residential block longitude and latitude, and described wide cell includes The wide cell longitude and latitude of family, methods described, in addition to:
Matched according to the residential block longitude and latitude and described wide cell longitude and latitude, if judging to know that target man is wide small Area's longitude and latitude matches with first object residential block longitude and latitude, then is associated the wide cell of target man with target residential block, Obtain the first incidence relation result set;
Grid division is carried out according to default size to unmatched wide cell and obtains multiple grids, if judging to know target Grid longitude and latitude corresponding to grid matches with the second target residential block longitude and latitude, then by the wide cell of family corresponding to the target grid It is associated with the second target residential block, obtains the second incidence relation result set;
The residential block and family are obtained according to the first incidence relation result set and the second incidence relation result set Wide cell association model.
Specifically, the wide cell in residential block and family is all section, therefore the residential block longitude and latitude that residential block information includes is one Individual set, the wide cell longitude and latitude of family that the wide cell of family includes are also a set.Fig. 5 is residential block provided in an embodiment of the present invention With the wide cell association model Establishing process schematic diagram of family, as shown in figure 5, including:
Step 501:Obtain the residential block longitude and latitude of residential block;Residential block is obtained by high moral map or other maps business Residential block longitude and latitude;
Step 502:Obtain the wide cell longitude and latitude of family;Wide cell longitude and latitude of getting home can be obtained according to the wide cell information of family;
Step 503:Whether longitude and latitude matches;Judge whether the wide cell longitude and latitude of family has corresponding residential block longitude and latitude therewith Overlap, if so, then carrying out step 504;Otherwise step 505 is carried out;
Step 504:The first incidence relation result set is obtained, the wide cell of family that the match is successful and residential block are associated, Obtain the first incidence relation result set;
Step 505:Grid division;Grid division will be carried out according to default size without the wide cell of family that the match is successful, obtained Multiple grids are obtained, each grid corresponds to grid longitude and latitude;
Step 506:Matching;Each grid and residential block are carried out according to grid longitude and latitude and residential block longitude and latitude Match somebody with somebody, if the match is successful, carry out step 507;
Step 507:The second incidence relation result set is obtained, by the wide cell of family and residential block corresponding to the grid that the match is successful It is associated, obtains the second incidence relation result set;
Step 508:Merge;First incidence relation result set and the second incidence relation result set are merged, obtain residential block With the wide cell association model of family.
It should be noted that in addition to being matched by longitude and latitude, the wide cell name of family and resident can also be passed through Area's title is matched, and title identical is associated.
Table 3 is residential block provided in an embodiment of the present invention and the wide cell association relation list of family, as shown in table 3:
Table 3
The embodiment of the present invention is by according to MRO data, residential block information, the wide cell information of family and LTE signalings, utilizing resident Area is wide latent with wireless area correlation model, residential block resident user correlation model, the wide cell association model in residential block and family and family Analyzed in targeted customer's identification model, obtain the incidence relation between residential block, the wide cell in wireless area and family, so as to Enough network coverage situations for efficiently, accurately analyzing residential block.
On the basis of above-described embodiment, methods described, in addition to:
The objective resource acquisition of family is believed to all numbers of opening an account for opening targeted carrier if judging to know from described wide cell Inquire about fall short in breath to open an account number, then the target is opened an account number non-installation targets operator broadband;
If judgement knows that the daily average water discharge of the target number of opening an account is more than the first predetermined threshold value, and in the first preset time period Flow be less than the second predetermined threshold value, and logout is produced in the second preset time period and is more than the 3rd predetermined threshold value, then it is described Target number of opening an account has installed broadband;Otherwise target number of opening an account does not install broadband;
If the target is opened an account, number has installed broadband, and non-installation targets operator broadband, then the target number of opening an account Code installation rival broadband, the target do not installed broadband and install rival broadband is opened an account corresponding to number User is as the wide potential target user of family, to obtain the wide potential target user's identification model of family.
Specifically, Fig. 6 is provided in an embodiment of the present invention wide potential target user's identification model Establishing process schematic diagram, As shown in fig. 6, including:
Step 601:Obtain the wide data of user family;From the wide data of family corresponding to family visitor resource acquisition targeted customer, so as to To find the number of opening an account of targeted customer.
Step 602:It is single in detail to obtain user S1-MME;It is single in detail to obtain the S1-MME of user, and is recorded in 19:00-24:00 hair Raw chain of command event;
Step 603:Inquiry target is opened an account number;According to the wide data of the family of targeted customer and S1-MME in detail singly in mobile broadband Inquiry is with the presence or absence of the number of opening an account in user list;
Step 604:It is determined that non-installation targets operator broadband;If in mobile broadband user list inquiry less than, Illustrate that the targeted customer is fitted without targeted carrier broadband, that is, be fitted without mobile broadband;
Step 605:It is single in detail to obtain user S1-U;Singly obtain the daily average water discharge and 21 of targeted customer in detail according to S1-U:00- 24:00 flow;
Step 606:Whether preparatory condition is met;According to S1-MME, single and S1-U singly judges whether user meets to preset in detail in detail Condition, preparatory condition are:1st, daily average water discharge is more than or equal to 10,000,000;2、21:00-24:Flow caused by 00 is less than 0.5 million;3、19: 00-24:00 chain of command logout number is more than 1;
Step 607:It is determined that broadband is installed;If meeting 3 conditions in step 606 simultaneously, illustrate that the target is used Family is to have installed broadband user;
Step 608:It is determined that broadband is not installed;If 3 preparatory conditions in step 606 can not be met simultaneously, illustrate The targeted customer does not install broadband;
Step 609:It is determined that installation rival broadband;If it is determined that learn that the targeted customer has installed broadband, but not Mobile broadband is installed, then explanation is mounted with rival broadband;
Step 610:Obtain the wide potential target user's identification model of family;If the targeted customer for do not install broadband user or Rival broadband user has been installed, then using the targeted customer as the wide potential target user of family, all users carried out Above-mentioned flow judges, obtains the wide potential target user of all families, forms the wide potential target user's identification model of family.
It should be noted that the first predetermined threshold value, the first preset time period, the second predetermined threshold value, the second preset time period, 3rd predetermined threshold value is all set in advance according to actual conditions, and the embodiment of the present invention is not specifically limited to this, and above-mentioned step Suddenly its order can be adjusted on the premise of normal implement is not influenceed.
The embodiment of the present invention is the wide potential target of family by obtaining the wide potential target user's identification model of family which user obtained User, depth excavation is carried out for these users, the number of users of targeted carrier can be increased.
It is described according to the MRO data, institute's residential block information, the wide cell information of man of institute on the basis of above-described embodiment It is wide using residential block and wireless area correlation model, residential block resident user correlation model, residential block and family with institute's LTE signalings The wide potential target user's identification model of cell association model and family is analyzed the residential block to be analyzed, including:
According to the MRO data, institute's residential block information, the wide cell information of man of institute and institute's LTE signalings, the residential block is utilized The residential block of each wireless area ownership is obtained with wireless area correlation model, is obtained using residential block resident user correlation model The resident user that each residential block includes, it is corresponding to obtain each residential block using residential block cell association model wide with family The wide cell of family, utilize described wide potential target user's identification model to obtain the wide potential target of family in each residential block and use Family.
Specifically, the resident of each wireless area ownership can be obtained by the correlation model of residential block and wireless area Area, Fig. 7 is residential block provided in an embodiment of the present invention and wireless area incidence relation schematic diagram, as shown in fig. 7, mainly including city City, district, residential block title, 4G cell names, the ECI of TAC, 4G cell of 4G cells, can be concise from Fig. 7 obtain 4G Which residential block is cell belong to.Which user's hand in each residential block can be obtained by residential block resident user correlation model Machine number belongs to the resident user of the residential block, and Fig. 8 is resident user list schematic diagram in residential block provided in an embodiment of the present invention, As shown in figure 8, including subscriber phone number, IMEI, IMSI, districts and cities, district, residential block title, residential block type, pass through resident Area's title and subscriber phone number can be to draw the subscriber phone number which has resident in residential block.Pass through residential block and family Wide cell association model obtains residential block and the corresponding relation of the wide cell of family, Fig. 9 be residential block provided in an embodiment of the present invention with The wide cell association list schematic diagram of family, as shown in figure 9, including districts and cities, district, the wide cell name of family, the wide cell ID of family, residential block The information such as title, residential block ID, its corresponding relation can be obtained by the wide cell name of family and residential block title.It is wide latent by family It is the wide potential target user of family to have which user in targeted customer's identification model can obtain each residential block, and Figure 10 is this hair The wide potential target user list schematic diagram of family that bright embodiment provides, as shown in Figure 10, including time, residential block title, phone Number (MSISIDN), IMSI, IMEI, terminal brand, terminal models.
It should be noted that the wide table of residential block multidimensional data is based on, from networking, market development, client perception, benefit It is worth four dimensions and carries out multidimensional analysis, portrait output 10 classes portrait label is carried out to each residential block, and automatically analyze output Support planning, support marketing suggestion.
The class tag definition rule of residential block 10:
1st, suggest that residential block is built in preferential 4G depth covering:
Correlation tag:The weak covering residential block & users of 4G perceive the more residents of poor residential block & high values residential block & resident users Area.
2nd, the preferential residential block for carrying out light and changing is suggested:
Correlation tag:Light requirement changes residential block & broadbands and has developed the residential block & high values residential block more residential blocks of & resident users.
3rd, preferential development broadband marketing residential block is suggested:
Correlation tag:The insufficient residential block & high values residential block more residential blocks of & resident users are developed in broadband.
The embodiment of the present invention is by according to MRO data, residential block information, the wide cell information of family and LTE signalings, utilizing resident Area is wide latent with wireless area correlation model, residential block resident user correlation model, the wide cell association model in residential block and family and family Analyzed in targeted customer's identification model, obtain the incidence relation between residential block, the wide cell in wireless area and family, so as to Enough network coverage situations for efficiently, accurately analyzing residential block.
Figure 11 is that a kind of residential block network capabilities analysis system structure based on big data provided in an embodiment of the present invention is shown It is intended to, as shown in figure 11, the system includes:Data active layer 1101, data collection layer 1102, storage with process layer 1103 and should With layer 1104;
The data active layer 1101 is used to provide data source, and the data source is wide including MRO data, residential block information, family Cell information and LTE signalings;
The data collection layer 1102 is used for from the data active layer gathered data source;
The storage is used to handle the data source that collects with process layer 1103, acquisition residential block respectively with Incidence relation between wireless area, the wide cell of resident user man and potential user, and data are arrived into incidence relation storage In storehouse;
The application layer 1104 is used to obtain inquiry request, and number is obtained from corresponding database according to the inquiry request According to, and the data got are returned.
Specifically, data active layer 1101 is used to provide data source, data source is wide small including MRO data, residential block information, family Area's information and LTE signalings;Data collection layer 1102 be responsible for by signaling, webmaster statistics, network optimization platform, through point, resource, testing Deng data access into system.Store and be used to handle the data source collected with process layer 1103, obtain resident Area's incidence relation between wireless area, the wide cell of resident user man and potential user respectively, and the incidence relation is deposited Store up in database;Specifically include:
(1) XDR detailed datas are loaded into Hadoop Hbase, and detailed single real-time query interface is opened to application layer;
(2) Hadoop computing resources and ability are provided, are easy to collect using light granularity of the realization based on XDR;
(3) Hadoop computing resources and ability are provided, realize residential block and wireless area, the wide cell of family incidence relation, Residential block resident user, mobile subscriber's model of Wifi online is established and data correlation.
Application layer 1104 is mainly responsible for:
(1) complex calculation towards service application is completed based on MPP database servers, result is loaded into RDB data In storehouse;
(2) in application server deployment Web applications and infrastructure service, realize that the database service interface in different manufacturer data storehouse is looked into Inquiry ability.
Figure 12 is the residential block network capabilities analysis system business structure figure provided in an embodiment of the present invention based on big data, As shown in figure 12, including:Business function domain 1201, platform feature domain 1202, data field 1203, systemic-function domain 1204, wherein:
Business function domain 1201:Residential block overview, residential block panorama analytical method, planning construction, city are provided towards end user All kinds of service applications such as field marketing, are that system intuitively shows the function of end user to combine.
Platform feature domain 1202:Construction platform level base power, there is provided basic and reusable public module, component and clothes Business, can quickly supporting business apply realization and delivery.
Data field 1203:Support to carry out data ETL processing, Various types of data collects and the ability such as data storage, inquiry, Support the abilities such as self-service analysis, multidimensional analysis, data mining.
Systemic-function domain 1204:Data management is provided, supported using the system self-management of safety, system monitoring etc. Ability.
The embodiment of system provided by the invention specifically can be used for the handling process for performing above-mentioned each method embodiment, its Function will not be repeated here, and be referred to the detailed description of above method embodiment.
The embodiment of the present invention is by according to MRO data, residential block information, the wide cell information of family and LTE signalings, utilizing resident Area is wide latent with wireless area correlation model, residential block resident user correlation model, the wide cell association model in residential block and family and family Analyzed in targeted customer's identification model, obtain the incidence relation between residential block, the wide cell in wireless area and family, so as to Enough network coverage situations for efficiently, accurately analyzing residential block.
Figure 13 is electronic equipment entity structure schematic diagram provided in an embodiment of the present invention, and as shown in figure 13, the electronics is set It is standby, including:Processor (processor) 1301, memory (memory) 1302 and bus 1303;Wherein,
The processor 1301 and memory 1302 complete mutual communication by the bus 1303;
The processor 1301 is used to call the programmed instruction in the memory 1302, is implemented with performing above-mentioned each method The method that example is provided, such as including:The data source information of preset number of days is obtained, the data source information includes:MRO data, Residential block information, the wide cell information of family, LTE signalings and family's visitor's resource;According to MRO data, the residential block information, described The wide cell information of family and the LTE signalings, mould is associated using residential block with wireless area correlation model, residential block resident user Type, the wide potential target user's identification model of the wide cell association model in residential block and family and family are analyzed, and obtain residential block, wireless Incidence relation between the wide cell of cell and family;Incidence relation between the residential block, the wide cell in wireless area and family is made Exported for analysis result.
The present embodiment discloses a kind of computer program product, and the computer program product includes being stored in non-transient calculating Computer program on machine readable storage medium storing program for executing, the computer program include programmed instruction, when described program instruction is calculated When machine performs, computer is able to carry out the method that above-mentioned each method embodiment is provided, such as including:Obtain the number of preset number of days According to source information, the data source information includes:MRO data, residential block information, the wide cell information of family, LTE signalings and family's visitor's money Source;According to the MRO data, the residential block information, described wide cell information and the LTE signalings, using residential block with Wireless area correlation model, residential block resident user correlation model, the wide potential mesh of the wide cell association model in residential block and family and family Mark user's identification model is analyzed, and obtains the incidence relation between residential block, the wide cell in wireless area and family;By the resident Incidence relation between area, the wide cell in wireless area and family exports as analysis result.
The present embodiment provides a kind of non-transient computer readable storage medium storing program for executing, the non-transient computer readable storage medium storing program for executing Computer instruction is stored, the computer instruction makes the computer perform the method that above-mentioned each method embodiment is provided, example Such as include:The data source information of preset number of days is obtained, the data source information includes:MRO data, residential block information, family are wide small Area's information, LTE signalings and family's visitor's resource;According to the MRO data, the residential block information, described wide cell information and institute LTE signalings are stated, it is wide small using residential block and wireless area correlation model, residential block resident user correlation model, residential block and family The wide potential target user's identification model of area's correlation model and family is analyzed, obtain residential block, the wide cell in wireless area and family it Between incidence relation;Exported the incidence relation between the residential block, the wide cell in wireless area and family as analysis result.
One of ordinary skill in the art will appreciate that:Realizing all or part of step of above method embodiment can pass through Programmed instruction related hardware is completed, and foregoing program can be stored in a computer read/write memory medium, the program Upon execution, the step of execution includes above method embodiment;And foregoing storage medium includes:ROM, RAM, magnetic disc or light Disk etc. is various can be with the medium of store program codes.
The embodiments such as system described above are only schematical, wherein the unit illustrated as separating component It can be or may not be physically separate, can be as the part that unit is shown or may not be physics list Member, you can with positioned at a place, or can also be distributed on multiple NEs.It can be selected according to the actual needs In some or all of module realize the purpose of this embodiment scheme.Those of ordinary skill in the art are not paying creativeness Work in the case of, you can to understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can Realized by the mode of software plus required general hardware platform, naturally it is also possible to pass through hardware.Based on such understanding, on The part that technical scheme substantially in other words contributes to prior art is stated to embody in the form of software product, should Computer software product can store in a computer-readable storage medium, such as ROM/RAM, magnetic disc, CD, including some fingers Make to cause a computer equipment (can be personal computer, server, or network equipment etc.) to perform each implementation Method described in some parts of example or embodiment.
Finally it should be noted that:The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations;Although The present invention is described in detail with reference to the foregoing embodiments, it will be understood by those within the art that:It still may be used To be modified to the technical scheme described in foregoing embodiments, or equivalent substitution is carried out to which part technical characteristic; And these modification or replace, do not make appropriate technical solution essence depart from various embodiments of the present invention technical scheme spirit and Scope.

Claims (10)

  1. A kind of 1. residential block network capabilities analysis method based on big data, it is characterised in that including:
    The data source information of preset number of days is obtained, the data source information includes:MRO data, residential block information, the wide cell letter of family Breath, LTE signalings and family's visitor's resource;
    According to the MRO data, the residential block information, described wide cell information and the LTE signalings, using residential block with Wireless area correlation model, residential block resident user correlation model, the wide potential mesh of the wide cell association model in residential block and family and family Mark user's identification model is analyzed, and obtains the incidence relation between residential block, the wide cell in wireless area and family;
    Exported the incidence relation between the residential block, the wide cell in wireless area and family as analysis result.
  2. 2. according to the method for claim 1, it is characterised in that methods described, in addition to:
    Obtain the MRO data of the user of the preset number of days and the residential block information;The MRO data include TA values and AOA Value, the residential block information include residential block longitude and latitude;
    The TA values and the AOA values in the MRO data of each user, which calculate, obtains nothing corresponding to each user Line cell information, the wireless cell information include cell longitude and latitude;
    The incidence relation of residential block and the wireless area is obtained according to the residential block longitude and latitude and the cell longitude and latitude, and Number of days carries out descending sort according to corresponding to the residential block for belonging to Target Wireless cell;
    Ownership residential block of the residential block of sequence first as the Target Wireless cell is obtained, to obtain the residential block and nothing Line cell association model.
  3. 3. according to the method for claim 2, it is characterised in that methods described, in addition to:
    LTE signalings caused by targeted customer in daily preset time period are obtained in the preset number of days, the LTE signalings include production Wireless area and corresponding user profile corresponding to the raw LTE signalings;
    Descending sort is carried out to wireless area corresponding to generation LTE signalings according to number of days, obtains the forward predetermined number that sorts Resident wireless area of the wireless area as the targeted customer;
    According to the residential block and wireless area correlation model, the acquisition resident wireless area associates with the residential block System, to obtain the residential block resident user correlation model.
  4. 4. according to the method for claim 1, it is characterised in that the residential block information includes residential block longitude and latitude, described The wide cell of family includes the wide cell longitude and latitude of family, methods described, in addition to:
    Matched according to the residential block longitude and latitude and described wide cell longitude and latitude, if judging to know the wide cell warp of target man Latitude matches with first object residential block longitude and latitude, then is associated the wide cell of target man with target residential block, obtains First incidence relation result set;
    Grid division is carried out according to default size to unmatched wide cell and obtains multiple grids, if judging to know target grid Corresponding grid longitude and latitude matches with the second target residential block longitude and latitude, then by the wide cell of family and institute corresponding to the target grid State the second target residential block to be associated, obtain the second incidence relation result set;
    The residential block is obtained according to the first incidence relation result set and the second incidence relation result set and family is wide small Area's correlation model.
  5. 5. according to the method for claim 1, it is characterised in that methods described, in addition to:
    The objective resource acquisition of family is to all numbers of opening an account for opening targeted carrier, if judging to know from described wide cell information Inquiry fall short is opened an account number, then the target is opened an account number non-installation targets operator broadband;
    If judgement knows that the daily average water discharge of the target number of opening an account is more than the first predetermined threshold value, and the stream in the first preset time period Amount is less than the second predetermined threshold value, and logout is produced in the second preset time period and is more than the 3rd predetermined threshold value, then the target Number of opening an account has installed broadband;Otherwise target number of opening an account does not install broadband;
    If the target is opened an account, number has installed broadband, and non-installation targets operator broadband, then the target open an account number peace Rival broadband is filled, the target do not installed broadband and install rival broadband is opened an account user corresponding to number As the wide potential target user of family, to obtain the wide potential target user's identification model of family.
  6. 6. according to the method for claim 1, it is characterised in that described according to the MRO data, institute's residential block information, institute The wide cell information of family and institute's LTE signalings, using residential block and wireless area correlation model, residential block resident user correlation model, Residential block cell association model wide with family and the wide potential target user's identification model of family are analyzed the residential block to be analyzed, Including:
    According to the MRO data, institute's residential block information, the wide cell information of man of institute and institute's LTE signalings, the residential block and nothing are utilized Line cell association model obtains the residential block of each wireless area ownership, is obtained using residential block resident user correlation model each The resident user that residential block includes, the corresponding family in each residential block is obtained using wide with the family cell association model in the residential block Wide cell, the wide potential target user of family in each residential block is obtained using described wide potential target user's identification model.
  7. 7. according to the method for claim 3, it is characterised in that the targeted customer is the resident population of residential block.
  8. A kind of 8. residential block network capabilities analysis system based on big data, it is characterised in that including:Data active layer, acquisition layer, Storage and process layer and application layer;
    The data active layer is used to provide data source, and the data source includes MRO data, residential block information, the wide cell information of family With LTE signalings;
    The acquisition layer is used for from the data active layer gathered data source;
    The storage is used to handle the data source that collects with process layer, obtain residential block respectively with it is wirelessly small Incidence relation between area, the wide cell of resident user man and potential user, and by incidence relation storage into database;
    The application layer is used to obtain inquiry request, and data are obtained from corresponding database according to the inquiry request, and will The data got return.
  9. 9. a kind of electronic equipment, it is characterised in that including:Processor, memory and bus, wherein,
    The processor and the memory complete mutual communication by the bus;
    The memory storage has can be by the programmed instruction of the computing device, and the processor calls described program instruction energy Enough perform the method as described in claim any one of 1-7.
  10. 10. a kind of non-transient computer readable storage medium storing program for executing, it is characterised in that the non-transient computer readable storage medium storing program for executing is deposited Computer instruction is stored up, the computer instruction makes the computer perform the method as described in claim any one of 1-7.
CN201710859665.1A 2017-09-21 2017-09-21 Residential area network capacity analysis method and system based on big data Active CN107818133B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710859665.1A CN107818133B (en) 2017-09-21 2017-09-21 Residential area network capacity analysis method and system based on big data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710859665.1A CN107818133B (en) 2017-09-21 2017-09-21 Residential area network capacity analysis method and system based on big data

Publications (2)

Publication Number Publication Date
CN107818133A true CN107818133A (en) 2018-03-20
CN107818133B CN107818133B (en) 2020-08-04

Family

ID=61607826

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710859665.1A Active CN107818133B (en) 2017-09-21 2017-09-21 Residential area network capacity analysis method and system based on big data

Country Status (1)

Country Link
CN (1) CN107818133B (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108632905A (en) * 2018-05-15 2018-10-09 中国联合网络通信集团有限公司 Development method, device, terminal and the computer readable storage medium of broadband user
CN109195175A (en) * 2018-09-03 2019-01-11 郑州云海信息技术有限公司 A kind of mobile wireless network optimization method based on cloud computing
CN109348488A (en) * 2018-11-21 2019-02-15 中国联合网络通信集团有限公司 A kind of mobile network users perception support method and device
CN109743693A (en) * 2018-12-21 2019-05-10 中国联合网络通信集团有限公司 Information recommendation method, device and storage medium
CN110930638A (en) * 2019-10-25 2020-03-27 北京拓明科技有限公司 Crowd gathering early warning method and system

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101998417A (en) * 2009-08-11 2011-03-30 大唐移动通信设备有限公司 Method, system and device for improving network coverage performance
CN102045689A (en) * 2009-10-20 2011-05-04 中兴通讯股份有限公司 Method and device for obtaining mobility parameter of adjacent district
CN102640525A (en) * 2009-12-04 2012-08-15 高通股份有限公司 Managing a data network connection for mobile communications based on user location
US20130005381A1 (en) * 2011-06-29 2013-01-03 Renesas Mobile Corporation Terminal Mobility State Detection

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101998417A (en) * 2009-08-11 2011-03-30 大唐移动通信设备有限公司 Method, system and device for improving network coverage performance
CN102045689A (en) * 2009-10-20 2011-05-04 中兴通讯股份有限公司 Method and device for obtaining mobility parameter of adjacent district
CN102640525A (en) * 2009-12-04 2012-08-15 高通股份有限公司 Managing a data network connection for mobile communications based on user location
US20130005381A1 (en) * 2011-06-29 2013-01-03 Renesas Mobile Corporation Terminal Mobility State Detection

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
代晓菊: "基于数据挖掘的电信LTE用户上网数据的用户流失算法研究", 《中国优秀硕士学位论文全文数据库》 *

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108632905A (en) * 2018-05-15 2018-10-09 中国联合网络通信集团有限公司 Development method, device, terminal and the computer readable storage medium of broadband user
CN109195175A (en) * 2018-09-03 2019-01-11 郑州云海信息技术有限公司 A kind of mobile wireless network optimization method based on cloud computing
CN109348488A (en) * 2018-11-21 2019-02-15 中国联合网络通信集团有限公司 A kind of mobile network users perception support method and device
CN109743693A (en) * 2018-12-21 2019-05-10 中国联合网络通信集团有限公司 Information recommendation method, device and storage medium
CN110930638A (en) * 2019-10-25 2020-03-27 北京拓明科技有限公司 Crowd gathering early warning method and system

Also Published As

Publication number Publication date
CN107818133B (en) 2020-08-04

Similar Documents

Publication Publication Date Title
CN107818133A (en) A kind of residential block network capabilities analysis method and system based on big data
CN103116825B (en) Intelligent city management
Csáji et al. Exploring the mobility of mobile phone users
CN101990003B (en) User action monitoring system and method based on IP address attribute
CN105246033B (en) A kind of crowd state monitoring method and monitoring device based on terminal positioning
IL263654D0 (en) Empirical expert determination and question routing system and method
CN103236163A (en) Traffic jam avoiding prompting system based on collective intelligence network
CN107480624A (en) Permanent resident population's acquisition methods, apparatus and system, computer installation and storage medium
CN104349366B (en) A kind of radio network problems association analysis method based on GIS
JP2015210681A (en) Decision-making support system and decision-making support method
CN105894358A (en) Commuting order identification method and device
CN103258027A (en) Context awareness service platform based on intelligent terminal
US10218575B2 (en) Provision, configuration and use of a telecommunications network
CN102056351B (en) Push service system and method
US20140222538A1 (en) Customer experience management for an organization
CN105468161A (en) Instruction execution method and device
CN108495329A (en) A kind of evaluation method and device of base station reliability
CN106663258A (en) Measurement of multi-screen internet user profiles, transactional behaviors and structure of user population through a hybrid census and user based measurement methodology
CN103365900A (en) Method and device for throwing on-line material
GB2543393A (en) Correlating data from satellite images with retail location performance
CN110648071A (en) Risk control method and device
CN107436945A (en) A kind of information collecting method and system based on electronic map
CN107958050A (en) Urban planning monitoring method, device and electronic equipment
CN105610698B (en) The treating method and apparatus of event result
Castanhari et al. A Software Architecture to Integrate Sensor Data and Volunteered Geographic Information for Flood Risk Management.

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant