CN115422311A

CN115422311A - Travel track data generation method and device, electronic equipment and storage medium

Info

Publication number: CN115422311A
Application number: CN202210982309.XA
Authority: CN
Inventors: 杨建昆; 张辉; 张俊春; 李俊
Original assignee: China Telecom Corp Ltd
Current assignee: China Telecom Corp Ltd
Priority date: 2022-08-16
Filing date: 2022-08-16
Publication date: 2022-12-02

Abstract

The embodiment of the invention provides a travel track data generation method, a travel track data generation device, electronic equipment and a storage medium, wherein signaling data are acquired and stored in a distributed database; determining target scene category information aiming at the signaling data, and generating a discrimination model by adopting the target scene category information; acquiring a target terminal equipment identification number, and determining target signaling data aiming at the target terminal equipment identification number in the distributed database through the target terminal equipment identification number; the target signaling data is input into the discrimination model, and first travel track data for the identification number of the target terminal device is generated, so that when track data error report is formed, the first travel track data for checking a user travel track can be timely and accurately obtained, the time for generating the travel track data is greatly shortened, and the generation efficiency for the travel track data is greatly improved.

Description

Travel track data generation method and device, electronic equipment and storage medium

Technical Field

The present invention relates to the field of travel trajectory data generation technologies, and in particular, to a travel trajectory data generation method, a travel trajectory data generation device, an electronic apparatus, and a computer-readable storage medium.

Background

However, because of the large amount of data, certain errors are inevitable in the processes of analysis processing, data transmission and the like of the platform, or because the positioning of the base station is not accurate enough, a small amount of user track misinformation can be caused, that is, the generated travel track data for the user does not correspond to the actual travel of the user, and therefore, the relevant technical staff is required to query and correct the travel track data of the relevant user on the premise of meeting the relevant regulations.

However, in the related art, usually, a way of manually writing a specified programming sentence in the system is adopted, and the travel track data for the user is generated again for checking the travel track data for the user.

Disclosure of Invention

The embodiment of the invention provides a method and a device for generating travel track data, electronic equipment and a computer readable storage medium, and aims to solve the problem of how to improve the generation efficiency of the travel track data.

The embodiment of the invention discloses a travel track data generation method, which is applied to a travel track data query system, wherein the travel track data query system is configured with a corresponding distributed database, and the method can comprise the following steps:

acquiring signaling data and storing the signaling data into the distributed database;

determining target scene category information aiming at the signaling data, and generating a discrimination model by adopting the target scene category information;

acquiring a target terminal equipment identification number, and determining target signaling data aiming at the target terminal equipment identification number in the distributed database through the target terminal equipment identification number;

and inputting the target signaling data into the discrimination model, and generating first travel track data aiming at the identification number of the target terminal equipment.

Optionally, the travel track data query system includes a front end terminal device, the front end terminal device is installed with a travel track data query application program for querying travel track data, the distributed database has an index logic plug-in for indexing the signaling data, and the method may further include:

and packaging the index logic plug-in into an application programming interface of the travel track data query application program.

Optionally, the step of determining, in the distributed database, target signaling data for the target terminal device identification number through the target terminal device identification number may include:

and calling the index logic plug-in through the application programming interface so as to retrieve target signaling data aiming at the identification number of the target terminal equipment in the signaling data by adopting the identification number of the target terminal equipment.

Optionally, the travel track data query system includes a front end terminal device, the front end terminal device is installed with a travel track data query application program for querying travel track data, and the travel track data query system is configured with a corresponding massively parallel processing database, and the method may further include:

acquiring measurement report data uploaded by a mobile terminal and storing the measurement report data in the large-scale parallel processing database; the measurement report data is used for carrying out positioning calculation on the mobile terminal;

determining target measurement report data aiming at the identification number of the target terminal equipment in the massively parallel processing database through the identification number of the target terminal equipment;

and generating second travel track data aiming at the identification number of the target terminal equipment by adopting the target measurement report data.

Optionally, the step of acquiring measurement report data uploaded by the mobile terminal and storing the measurement report data in the massively parallel processing database may include:

acquiring measurement report data uploaded by a mobile terminal;

writing the measurement report data in a text document;

storing the text document containing the measurement report data into the massively parallel processing database.

Optionally, the travel track data query application includes a user operation interface for displaying the travel track data, and the method may further include:

and displaying the first travel track data or the second travel track data in the user operation interface.

Optionally, the method may further include:

generating an electronic map by adopting the second travel track data; the electronic map is displayed in the user operation interface.

The embodiment of the invention also discloses a device for generating the travel track data, which is applied to a travel track data query system, wherein the travel track data query system is configured with a corresponding distributed database, and the device can comprise:

the signaling data acquisition module is used for acquiring signaling data and storing the signaling data into the distributed database;

the discrimination model generation module is used for determining target scene category information aiming at the signaling data and generating a discrimination model by adopting the target scene category information;

a target signaling data determining module, configured to obtain a target terminal device identification number, and determine target signaling data for the target terminal device identification number in the distributed database through the target terminal device identification number;

and the first travel track data generation module is used for inputting the target signaling data into the discrimination model and generating first travel track data aiming at the identification number of the target terminal equipment.

Optionally, the system for querying travel track data includes a front end terminal device, the front end terminal device is installed with a travel track data query application program for querying travel track data, the distributed database has an indexing logic plug-in for indexing the signaling data, and the apparatus may further include:

and the index logic plug-in packaging module is used for packaging the index logic plug-in into an application programming interface aiming at the travel track data query application program.

Optionally, the target signaling data determining module may include:

and the target signaling data determination submodule is used for calling the index logic plug-in through the application programming interface so as to retrieve target signaling data aiming at the identification number of the target terminal equipment in the signaling data by adopting the identification number of the target terminal equipment.

Optionally, the travel track data query system includes a front end terminal device, the front end terminal device is installed with a travel track data query application program for querying travel track data, the travel track data query system is configured with a corresponding massively parallel processing database, and the apparatus may further include:

the measurement report data acquisition module is used for acquiring measurement report data uploaded by the mobile terminal and storing the measurement report data in the large-scale parallel processing database; the measurement report data is used for carrying out positioning calculation on the mobile terminal;

a target measurement report data determining module, configured to determine, in the massively parallel processing database, target measurement report data for the target terminal device identification number according to the target terminal device identification number;

and the second travel track data generation module is used for generating second travel track data aiming at the identification number of the target terminal equipment by adopting the target measurement report data.

Optionally, the measurement report data obtaining module may include:

a measurement report data acquisition submodule for acquiring measurement report data uploaded by the mobile terminal;

the measurement report data writing sub-module is used for writing the measurement report data into a text document;

and the measurement report data storage sub-module is used for storing the text document containing the measurement report data into the massively parallel processing database.

Optionally, the travel track data query application includes a user operation interface for displaying the travel track data, and the apparatus may further include:

and the travel track data display module is used for displaying the first travel track data or the second travel track data in the user operation interface.

Optionally, the method may further include:

the electronic map generating module is used for generating an electronic map by adopting the second travel track data; the electronic map is displayed in the user operation interface.

The embodiment of the invention also discloses electronic equipment which comprises a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory finish mutual communication through the communication bus;

the memory is used for storing a computer program;

the processor is configured to implement the method according to the embodiment of the present invention when executing the program stored in the memory.

Also disclosed is a computer-readable storage medium having instructions stored thereon, which, when executed by one or more processors, cause the processors to perform a method according to an embodiment of the invention.

The embodiment of the invention has the following advantages:

in the embodiment of the invention, the signaling data is acquired and stored in the distributed database; determining target scene category information aiming at the signaling data, and generating a discrimination model by adopting the target scene category information; acquiring a target terminal device identification number, and determining target signaling data aiming at the target terminal device identification number in the distributed database through the target terminal device identification number; the target signaling data is input into the discrimination model, and first travel track data for the identification number of the target terminal device is generated, so that when track data error report is formed, the first travel track data for checking a user travel track can be timely and accurately obtained, the time for generating the travel track data is greatly shortened, and the generation efficiency for the travel track data is greatly improved.

Drawings

Fig. 1 is a flowchart illustrating steps of a method for generating travel track data according to an embodiment of the present invention;

FIG. 2 is a topology diagram of a travel track data query system provided in an embodiment of the present invention;

FIG. 3 is a schematic diagram of data interaction for a travel track data query system provided in an embodiment of the present invention;

FIG. 4 is a schematic structural diagram of a user interface provided in the embodiment of the present invention;

fig. 5 is a block diagram of a travel track data generation apparatus provided in an embodiment of the present invention;

fig. 6 is a block diagram of a hardware structure of an electronic device provided in each embodiment of the present invention.

Detailed Description

In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in further detail below.

The signaling data is a record of various communication events of a mobile terminal such as a mobile phone, a tablet computer and a mobile computer which are kept in contact with a communication network, and the signaling data comprises base station switching, heartbeat information and the like which are recorded by network equipment, and the relative position of a mobile phone user can be obtained by analyzing the position coordinates of the base station in the signaling data.

However, because of the large amount of data, certain errors are inevitable in the processes of analysis processing, data transmission and the like of the platform, or because the positioning of the base station is not accurate enough, a small amount of user trajectory misinformation may be caused, that is, the travel trajectory data generated by the user does not match the actual travel of the user, and therefore, the related technical staff is required to query and correct the travel trajectory data of the related user on the premise of meeting the related regulations.

In the related technology, signaling data related to a travel track is stored in a large data platform HIVE table in a centralized manner, the HIVE is a data warehouse tool based on distributed computation Hadoop and is used for data extraction, conversion and loading, and the HIVE is a mechanism capable of storing, inquiring and analyzing large-scale data stored in the Hadoop. HIVE supports storage, analysis and calculation of mass data through multi-node parallel processing, supports traditional SQL (Structured Query Language), and is convenient to use. However, HIVE has no indexing mechanism, and a full table scan is performed on a relevant node every query, and specifically, a relevant technician is required to write an SQL statement meeting the HIVE data specification in the HIVE system under the condition of meeting relevant regulations and to check relevant data queried from the HIVE table. In order to ensure that the checking result is reliable and the basis is sufficient, and ensure that the misjudged travel track data can be timely track corrected, and to generate a travel track data again for checking and capable of reflecting the real travel track of the user, various signaling detailed data such as 4G (fourth generation mobile information system), VOLTE (Voice over Long-Term Evolution Voice bearer), open information dynamic data oid are generally required to be mutually supplemented and attested.

Referring to fig. 1, a flowchart illustrating steps of a method for generating travel track data according to an embodiment of the present invention is shown, which may specifically include the following steps:

step 101, acquiring signaling data and storing the signaling data in the distributed database;

step 102, determining target scene category information aiming at the signaling data, and generating a discrimination model by adopting the target scene category information;

103, acquiring a target terminal equipment identification number, and determining target signaling data aiming at the target terminal equipment identification number in the distributed database through the target terminal equipment identification number;

and 104, inputting the target signaling data into the discriminant model, and generating first travel track data aiming at the identification number of the target terminal equipment.

In a specific implementation, the embodiment of the present invention may be applied to a travel track data query system, where the travel track data query system is configured with a corresponding distributed database, for example, an Hbase database, and the Hbase is a distributed database oriented to column storage.

The embodiment of the invention can acquire the signaling data from the HIVE and store the acquired signaling data into the distributed database.

Specifically, the signaling data is a record of various communication events of the mobile terminal in contact with the communication network, including but not limited to base station handover data, heartbeat information data for the mobile terminal, and the like, and in practical applications, analyzing the base station position coordinates in the signaling data can determine the relative position of the mobile terminal, that is, the action trajectory data for the user can be determined. The mobile terminal of the embodiment of the invention includes but is not limited to a mobile phone, a tablet computer, a mobile computer and the like.

The embodiment of the invention can determine the target scene category information aiming at the signaling data and generate the discrimination model by adopting the target scene category information, for example, the method can perform characteristic classification aiming at the scene, determine the stay time information of a user in a target area, the number information of base stations for data interaction between the user and different base stations, the interval time information for data interaction between the user and different base stations, the distance information between the base stations for data interaction with the user and a peripheral administrative area and other target scene category information, then can generate the characteristic vector by adopting the target scene category information, and train the discrimination model by adopting the characteristic vector.

After the signaling data is obtained and the discrimination model is generated, a target terminal device identification number, for example, a mobile phone number of a target user to be queried, is obtained, target signaling data for the target terminal device identification number is determined in the distributed database through the target terminal device identification number, then the target signaling data is input into the discrimination model, first travel track data for the target terminal device identification number is generated through the discrimination model, and the first travel track data can be travel track data corresponding to the target signaling data.

In the embodiment of the invention, the signaling data is acquired and stored in the distributed database; determining target scene category information aiming at the signaling data, and generating a discrimination model by adopting the target scene category information; acquiring a target terminal device identification number, and determining target signaling data aiming at the target terminal device identification number in the distributed database through the target terminal device identification number; the target signaling data is input into the discrimination model, and first travel track data aiming at the identification number of the target terminal equipment is generated, so that when the track data is mistakenly reported, the travel track data used for checking the user travel track is prevented from being manually generated, the first travel track data used for checking the user travel track can be timely and accurately obtained, the time for generating the travel track data is greatly shortened, and the generation efficiency aiming at the travel track data is greatly improved.

On the basis of the above-described embodiment, a modified embodiment of the above-described embodiment is proposed, and it is to be noted herein that, in order to make the description brief, only the differences from the above-described embodiment are described in the modified embodiment.

In an optional embodiment of the present invention, the travel track data query system includes a front end terminal device, the front end terminal device is installed with a travel track data query application program for querying travel track data, the distributed database has an index logic plug-in for indexing the signaling data, and the method further includes:

In the related art, usually, a customer service person receives a requirement for checking a travel track of a user, and then the customer service person notifies a telephone number of the user to a related technical person, and the related technical person generates travel track data for checking the travel track of the user and then sends a checking result to the customer service person, because the related art only depends on manual checking, the customer service person who does not have the related technical ability cannot check the travel track of the user, therefore, the travel track data query system of the embodiment of the present invention may be configured with a corresponding front-end terminal device, for example, a work computer used by the customer service person, and the front-end terminal device may be installed with a travel track data query application program for querying the travel track data, so that the customer service person can directly pass through 100002 under the condition that the customer service person is authorized and meets related regulations

The overstroke data query application automatically generates first trip trace data for verification of user trip data.

In practical applications, because the hbase and the hive have different data storage manners, the query manner for data is also different, and in order to implement that the data in the hive is transferred to the hbase, a user can determine target signaling data for a target terminal device identification number in a distributed database, so as to generate first travel track data, in an embodiment of the present invention, an index logic plug-in may be encapsulated in an Application Programming Interface for a travel track data query Application program, for example, an index logic plug-in with a row key technology may be encapsulated in an API (Application Programming Interface) for the travel track data query Application program.

In another optional embodiment of the present invention, the step of determining, by the target terminal device identification number, target signaling data for the target terminal device identification number in the distributed database includes:

The embodiment of the invention can package the index logic plug-in into the application programming interface aiming at the travel track data query application program, and when the first travel track data for checking the user travel data needs to be automatically generated through the travel track data query application program, the index logic plug-in can be called through the application programming interface so as to retrieve the target signaling data aiming at the identification number of the target terminal equipment in the signaling data by adopting the identification number of the target terminal equipment. For example, an index logic plug-in with a row key rowkey technology may be packaged into an API for a travel track data query application, so that when first travel track data used for checking user travel data needs to be automatically generated by the travel track data query application, a customer service staff may call the index logic plug-in with the row key rowkey technology through the API, and retrieve target signaling data corresponding to a mobile phone number from a plurality of signaling data.

According to the embodiment of the invention, the index logic plug-in is packaged into an application programming interface aiming at the travel track data query application program; the index logic plug-in is called through the application programming interface so as to retrieve target signaling data aiming at the target terminal equipment identification number in the signaling data by adopting the target terminal equipment identification number, so that when a user needs to automatically generate first travel track data for checking user travel data through a travel track data query application program, the index logic plug-in can be called through the application programming interface, and target signaling data aiming at the target terminal equipment identification number is retrieved in a distributed database, thereby further improving the generation efficiency aiming at the travel track data.

In an optional embodiment of the present invention, the travel track data query system includes a front end terminal device, the front end terminal device is installed with a travel track data query application program for querying travel track data, and the travel track data query system is configured with a corresponding massively parallel processing database, and the method further includes:

acquiring measurement report data uploaded by a mobile terminal and storing the measurement report data in the massively parallel processing database; the measurement report data is used for carrying out positioning calculation on the mobile terminal;

In practical application, the conventional track judgment is carried out by referring to the position coordinates of the base station in the signaling data, and the coverage distance of the base station signal can reach thousands of meters, so that the cross-area and cross-border coverage conditions exist. And the construction condition of some base stations across districts exists, the attribution district and the actual station construction district belong to different administrative districts, and the similar condition is more prominent in the boundary area of the adjacent administrative districts. Therefore, the travel track of the user in the area near the boundary can be misjudged only according to the coordinates of the base station, that is, the travel track of the user cannot be truly reflected due to the detailed data characteristics of the signaling data, and whether the area visited by the user displayed on the travel track is real and reasonable is difficult to clearly judge whether the area visited by the user is real and reasonable by adopting discrimination model identification or manual comparison.

Therefore, in the embodiment of the present invention, in addition to acquiring the signaling data and generating the first travel track data for checking the user travel track based on the signaling data, measurement Report data uploaded by the mobile terminal, that is, MR (Measurement Report) data, which is different from the signaling data, may also be acquired, and although the mobile terminal may be located by the signaling data, the location logic based on the signaling data is to determine a base station that has performed data interaction with the mobile terminal by the signaling data, and then locate the mobile terminal by using coordinates of the base station, the location precision of the location mode is relatively low, and the MR data may be used to perform relatively accurate location calculation on the mobile phone.

In practical applications, the hive can store more data depending on the unique data storage characteristics of the hive, and raw data collected on a network, such as MR data, etc., can be stored in the hive more easily due to the strong compatibility of the hive with the data. However, as can be seen from the above, based on the retrieval characteristic of the hive, it takes a lot of time to query the file in the hive, and usually, the MR data is only temporarily stored in the hive in a log file manner, and is not stored for a long time, because the generation amount of the MR data in practical application is very large, and the application scenario for the MR data is not many, and therefore the MR data is quickly covered by the MR data subsequently written in the server, the embodiment of the present invention may configure a corresponding massive parallel processing database greenplus for the trip trajectory data query system, and the architecture of the greenplus adopts MPP (massive parallel processing). In the MPP system, each SMP (symmetric Multi-Processing) node may also run its own operating system, database, etc., greenplus may be specially used to store data and provide a function of data statistical analysis, and greenplus may be combined into a GP large data cluster, which may store more data and have a faster data analysis Processing speed than a conventional single database.

Therefore, in a specific implementation, the embodiment of the present invention may acquire MR data in hive and store the MR data in greenplus to provide better query and long-term preservation service for the MR data.

Further, the travel track data query system according to the embodiment of the present invention may be configured with a corresponding front end terminal device, for example, a work computer used by a customer service staff, where a travel track data query application program for querying travel track data may be installed in the front end terminal device, when a user travel needs to be checked, the travel track data query application program may determine, by using an identification number of a target terminal device, MR data corresponding to the identification number of the target terminal device in greenplus, and generate second travel track data for the identification number of the target terminal device by using the MR data, where the second travel track data may be the travel track data corresponding to the MR data, for example, when the customer service staff receives a check instruction for the travel track of the user, the MR data may be input in the travel track data query application program under the condition that the customer service staff is authorized and meets relevant regulations, so as to determine, in the greenplus, the second travel track data for the mobile phone number by using the MR data, and be used for checking the travel track of the user.

In the embodiment of the invention, the measurement report data uploaded by the mobile terminal is obtained and stored in the large-scale parallel processing database; the measurement report data is used for carrying out positioning calculation on the mobile terminal; determining target measurement report data aiming at the identification number of the target terminal equipment in the massively parallel processing database through the identification number of the target terminal equipment; the target measurement report data is adopted to generate second travel track data aiming at the identification number of the target terminal equipment, so that when error report of the track data is formed, first travel track data used for checking a user travel track can be timely and accurately obtained, the precision aiming at the user travel track is further improved on the basis of greatly shortening the time for generating the travel track data, and the generation efficiency aiming at the user travel track data is further improved.

In an optional embodiment of the present invention, the step of acquiring measurement report data uploaded by a mobile terminal and storing the measurement report data in the massively parallel processing database includes:

acquiring measurement report data uploaded by a mobile terminal;

writing the measurement report data in a text document;

In practical application, the greenplus can provide a quick query service, but the speed of updating data into the greenplus is very slow, because for each modification of the greenplus data, even if only one record is modified, much time is consumed to perform various consistency checks, and a large amount of time is consumed, so that the embodiment of the invention can write the MR data into the text document before the MR data is stored into the greenplus, store the text document into the hive, and then transmit the text document containing the MR data into the greenplus for association updating at one time, so that even if the text document contains a large amount of MR data, only one check needs to be performed on the newly stored MR data, thereby greatly shortening the time for storing the MR data, and further improving the generation efficiency for the MR journey trace data.

According to the embodiment of the invention, the measurement report data uploaded by the mobile terminal is obtained; writing the measurement report data in a text document; the text document containing the measurement report data is stored in the massively parallel processing database, so that the time for storing the MR data is greatly shortened, and the generation efficiency of the travel track data is further improved.

In an optional embodiment of the present invention, the travel track data query application includes a user operation interface for displaying the travel track data, and the method further includes:

and displaying the first travel track data and/or the second travel track data in the user operation interface.

Therefore, in practical application, a customer service staff usually receives a checking instruction for a user travel track, so that the embodiment of the invention can configure a corresponding user operation interface for the travel track data query application program to display the travel track data, so that when the user travel track needs to be checked, the first travel track data or the second travel track data can be displayed in the user operation interface for the relevant staff to check.

According to the embodiment of the invention, the first travel track data or the second travel track data is displayed in the user operation interface, so that the generation efficiency of the travel track data is further improved.

In an optional embodiment of the present invention, further comprising:

The embodiment of the invention can also adopt the second travel track data to generate a Web (World Wide Web) electronic map, and the Web electronic map can be displayed in a user operation interface.

In practical application, neither the position coordinates of the base station nor the position coordinates in the MR data can be directly used on a Web electronic map, and can be accurately presented on the map only through coordinate conversion. Therefore, the embodiment of the invention can adopt any network map as a base map and adopt an online conversion mode to obtain the map coordinates. However, the online mode can only convert about hundreds of coordinates per second, and cannot meet the requirement of coordinate conversion of billions of orders of magnitude every day, so that the map coordinates can be converted based on an offline coordinate conversion algorithm. Through comparison of conversion results, the error of checking the travel track is about 10 meters, and the precision requirement of track display is completely met.

In order that those skilled in the art will better understand the embodiments of the present invention, a full and complete example will be described below.

Referring to fig. 2, fig. 2 is a topological diagram of a travel track data query system provided in an embodiment of the present invention, the travel track data query system is configured with a corresponding GP big data cluster, and the GP cluster is composed of a plurality of servers and is a core responsible for data storage and online analysis and calculation. The specific configuration deployment may be determined by the amount of data that needs to be stored and calculated. For example, for MR data of a province, full position acquisition analysis is performed, historical data is saved for about one month, 10 node servers and a single node storage 10TB are typical configurations.

The travel track data query system is configured with a corresponding travel track data query application program (client), and a WEB interface is adopted to support travel track check processing. And (4) inquiring, comparing and checking the track detailed list, wherein the track map is finished on a WEB interface. The client opens a webpage through a browser to realize man-machine interaction, submits parameters to the server, receives calculation and processing results, presents a WEB visual map of a user activity route, judges a model identification result, and manually compares and checks results to finish on a WEB interface. Therefore, the requirement on the client is not high, and the normal operation of the mainstream browser can be supported by the ordinary personal computer

Referring to fig. 3, fig. 3 is a schematic diagram of data interaction for a travel track data query system provided in an embodiment of the present invention.

1. And (4) automatic and interface processing of Hive data query.

The hive data operation client commands the tool tunnel to develop, so that the data query is automated. As shown in fig. 4, fig. 4 is a schematic structural diagram of a user operation interface provided in an embodiment of the present invention, a travel route data query system may be configured with corresponding front-end terminal equipment, for example, a work computer used by a customer service staff, a travel route data query application (client) for querying travel route data may be installed in the front-end terminal equipment, so that a relevant person can directly input a specified mobile phone number on the user operation interface under the condition that the relevant person is authorized and meets relevant regulations, and the travel route data query system may automatically package relevant signaling data bottom layer query logic and display all query results in one user operation interface.

2. And (5) taking measures for improving the speed of inquiring the detailed data.

The original storage of the signaling details is in a Hive mode, but Hive has no index mechanism, and all-table scanning needs to be carried out on related data storage nodes during each query, so that the cluster resource scheduling response efficiency is low, and the response is relatively slow. The average query response time of the detail list of a single complaint exceeds 10 minutes, and a large amount of manpower and time are consumed to deal with the situation that a large number of user travel tracks need to be checked.

The method comprises the steps of converting a storage mode aiming at data needing to be frequently inquired, regularly reading and converting newly generated signaling data from hive into an hbase library every day, and then carrying out api encapsulation on a bottom layer implementation logic of hbase data inquiry for calling by a front-end interface program. The hbase adopts the rowkey technology to quickly locate the query data, the detailed query response speed is greatly improved, the single track verification data is generated for about 2 seconds, and the real-time response is basically realized.

3. Intelligent judgment for accuracy of travel track data

The dispute track check is to analyze and judge whether the track information displayed by the previous travel track data has a problem or not based on various communication detail events.

The scene can be classified according to characteristics, and the manually judged empirical rule is abstracted and digitalized to establish a judgment model. After detail data are inquired, the system carries out rule matching, automatically counts the duration of the place where the track stays in the dispute date, the number of different base stations which interact in the duration, the distance between the adjacent places, the interval time and other characteristic values to carry out comprehensive judgment, and can give out whether the dispute track is reasonable or not in real time and whether the dispute track needs to be corrected or not. The travel tracks to be checked can be determined timely and definitely, and the time-consuming process of manual comparison and possible human errors are avoided.

4. And (5) accurately judging by using the MR data.

The MR data is a measurement report which is periodically and automatically reported by a mobile phone, comprises signal strength, base station switching reasons, terminal position information and the like, and is mainly used for network evaluation and optimization. The position deviation obtained from the MR data is only a few meters to dozens of meters, so that the actual position of the user can be reflected more accurately, and clear and sufficient support basis can be provided for the judgment of the activity track of the user. The measure of acquiring the accurate position of the user by using the MR data effectively reduces the complexity of cross-region track dispute complaint processing and improves the judgment accuracy.

5. A mapped presentation of the travel trajectory.

The detailed track data is displayed on a WEB map, and related personnel can visually see the regional activity condition and the front and back related information of the mobile phone number corresponding to the user on the appointed date, so that the travel track can be effectively checked by the related personnel in a war way.

In practical application, neither the position coordinates of the base station nor the position coordinates in the MR data can be directly used on a WEB map, and can be accurately presented on the map only through coordinate conversion. Any network map can be used as a base map, and map coordinates can be obtained in an online conversion mode. However, the online mode can only convert about hundreds of coordinates per second, and cannot meet the requirement of coordinate conversion of billions of orders of magnitude every day, so that a mainstream configuration machine can convert millions of orders of magnitude of coordinate values per second based on an offline coordinate conversion algorithm. Through comparison of conversion results, the error of checking the travel track is about 10 meters, and the precision requirement of track display is completely met.

In order to further increase the conversion speed and avoid the problem of slow GP update, the conversion result is not directly updated to the database, but is written to the text document firstly and then is loaded to GP in batch for storage, and finally the required result is obtained through correlation operation.

Compared with the prior art, the following effects are achieved.

1. Interface processing of HIVE data operation of a group special area is realized based on tunnel secondary development, a mobile phone number can be input to realize event triggering, and the method can be used for automatic processing of a lot of data acquisition and processing scenes; the prior art does not support event triggering, most scenes need to be written manually to be realized, and the interface query of hive data is difficult to realize.

2. And (3) the hive data is converted into hbase support related travel track data for checking, and the response performance is obviously improved. The check time for single travel track data can be shortened from more than 10 minutes to 2 seconds.

3. Aiming at the dispute scenes of most tracks, a machine identification rule is established, and the travel track data for checking can be quickly and accurately generated so as to identify whether the previous travel track data is misjudged or not.

4. MR data is collected and combined with a WEB map, the activity track of a user is accurately identified, and the problems of cross-region and cross-border false alarm can be clearly and accurately judged. The traditional method relies on the position coordinates of the base station to identify the travel track of the user, and because of the problems of cross-area coverage of base station signals, cross-area construction of the base station and the like, the real track of the active user near the area boundary cannot be accurately identified, and the problem of cross-area track misinformation is difficult to process by relying on signaling data in related detailed lists.

The method for accurately identifying the user track by using the MR data can also be used for dispatching work of infected personnel or high-risk personnel, the accuracy of the dispatching inquiry result is verified, and the complicated dispatching workload can be greatly simplified.

It should be noted that, for simplicity of description, the method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the illustrated order of acts, as some steps may occur in other orders or concurrently in accordance with the embodiments of the present invention. Further, those skilled in the art will appreciate that the embodiments described in the specification are presently preferred and that no particular act is required to implement the invention.

Referring to fig. 5, a block diagram of a structure of a travel track data generation apparatus provided in the embodiment of the present invention is shown, which may specifically include the following modules:

a signaling data obtaining module 501, configured to obtain signaling data and store the signaling data in the distributed database;

a discrimination model generation module 502, configured to determine target scene category information for the signaling data, and generate a discrimination model using the target scene category information;

a target signaling data determining module 503, configured to obtain a target terminal device identification number, and determine target signaling data for the target terminal device identification number in the distributed database according to the target terminal device identification number;

a first travel trajectory data generating module 504, configured to input the target signaling data into the discriminant model, and generate first travel trajectory data for the identification number of the target terminal device.

Optionally, the target signaling data determining module may include:

Optionally, the measurement report data obtaining module may include:

Optionally, the method may further include:

For the apparatus embodiment, since it is substantially similar to the method embodiment, the description is relatively simple, and reference may be made to the partial description of the method embodiment for relevant points.

In addition, an embodiment of the present invention further provides an electronic device, including: the processor, the memory, and the computer program stored in the memory and capable of running on the processor, when executed by the processor, implement each process of the above-mentioned travel trajectory data generation method embodiment, and can achieve the same technical effect, and are not described herein again to avoid repetition.

The embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when being executed by a processor, the computer program implements each process of the above-mentioned method for generating travel track data, and can achieve the same technical effect, and in order to avoid repetition, the details are not repeated here. The computer-readable storage medium may be a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk.

Fig. 6 is a schematic diagram of a hardware structure of an electronic device for implementing various embodiments of the present invention.

The electronic device 600 includes, but is not limited to: a radio frequency unit 601, a network module 602, an audio output unit 603, an input unit 604, a sensor 605, a display unit 606, a user input unit 607, an interface unit 608, a memory 609, a processor 610, and a power supply 611. Those skilled in the art will appreciate that the electronic device configuration shown in fig. 6 does not constitute a limitation of the electronic device, and that the electronic device may include more or fewer components than shown, or some components may be combined, or a different arrangement of components. In the embodiment of the present invention, the electronic device includes, but is not limited to, a mobile phone, a tablet computer, a notebook computer, a palm computer, a vehicle-mounted terminal, a wearable device, a pedometer, and the like.

It should be understood that, in the embodiment of the present invention, the radio frequency unit 601 may be used for receiving and sending signals during a message sending and receiving process or a call process, and specifically, receives downlink data from a base station and then processes the received downlink data to the processor 610; in addition, the uplink data is transmitted to the base station. Generally, radio frequency unit 601 includes, but is not limited to, an antenna, at least one amplifier, a transceiver, a coupler, a low noise amplifier, a duplexer, and the like. Further, the radio frequency unit 601 may also communicate with a network and other devices through a wireless communication system.

The electronic device provides wireless broadband internet access to the user via the network module 602, such as assisting the user in sending and receiving e-mails, browsing web pages, and accessing streaming media.

The audio output unit 603 may convert audio data received by the radio frequency unit 601 or the network module 602 or stored in the memory 609 into an audio signal and output as sound. Also, the audio output unit 603 may also provide audio output related to a specific function performed by the electronic apparatus 600 (e.g., a call signal reception sound, a message reception sound, etc.). The audio output unit 603 includes a speaker, a buzzer, a receiver, and the like.

The input unit 604 is used to receive audio or video signals. The input Unit 604 may include a Graphics Processing Unit (GPU) 6041 and a microphone 6042, and the Graphics processor 6041 processes image data of a still picture or video obtained by an image capturing apparatus (such as a camera) in a video capture mode or an image capture mode. The processed image frames may be displayed on the display unit 606. The image frames processed by the graphic processor 6041 may be stored in the memory 609 (or other storage medium) or transmitted via the radio frequency unit 601 or the network module 602. The microphone 6042 can receive sound, and can process such sound into audio data. The processed audio data may be converted into a format output transmittable to a mobile communication base station via the radio frequency unit 601 in case of the phone call mode.

The electronic device 600 also includes at least one sensor 605, such as a light sensor, motion sensor, and other sensors. Specifically, the light sensor includes an ambient light sensor that can adjust the brightness of the display panel 6061 according to the brightness of ambient light, and a proximity sensor that can turn off the display panel 6061 and/or the backlight when the electronic apparatus 600 is moved to the ear. As one type of motion sensor, an accelerometer sensor can detect the magnitude of acceleration in each direction (generally three axes), detect the magnitude and direction of gravity when stationary, and can be used to identify the posture of an electronic device (such as horizontal and vertical screen switching, related games, magnetometer posture calibration), and vibration identification related functions (such as pedometer, tapping); the sensors 605 may also include fingerprint sensors, pressure sensors, iris sensors, molecular sensors, gyroscopes, barometers, hygrometers, thermometers, infrared sensors, etc., which are not described in detail herein.

The display unit 606 is used to display information input by the user or information provided to the user. The Display unit 606 may include a Display panel 6061, and the Display panel 6061 may be configured by a Liquid Crystal Display (LCD), an Organic Light-Emitting Diode (OLED), or the like.

The user input unit 607 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the electronic device. Specifically, the user input unit 607 includes a touch panel 6071 and other input devices 6072. Touch panel 6071, also referred to as a touch screen, may collect touch operations by a user on or near it (e.g., operations by a user on or near touch panel 6071 using a finger, stylus, or any other suitable object or attachment). The touch panel 6071 may include two parts of a touch detection device and a touch controller. The touch detection device detects the touch direction of a user, detects a signal brought by touch operation and transmits the signal to the touch controller; the touch controller receives touch information from the touch sensing device, converts the touch information into touch point coordinates, sends the touch point coordinates to the processor 610, receives a command from the processor 610, and executes the command. In addition, the touch panel 6071 can be implemented by various types such as a resistive type, a capacitive type, an infrared ray, and a surface acoustic wave. The user input unit 607 may include other input devices 6072 in addition to the touch panel 6071. Specifically, the other input devices 6072 may include, but are not limited to, a physical keyboard, function keys (such as volume control keys, switch keys, etc.), a track ball, a mouse, and a joystick, which are not described herein again.

Further, the touch panel 6071 can be overlaid on the display panel 6061, and when the touch panel 6071 detects a touch operation on or near the touch panel 6071, the touch operation is transmitted to the processor 610 to determine the type of the touch event, and then the processor 610 provides a corresponding visual output on the display panel 6061 according to the type of the touch event. Although in fig. 6, the touch panel 6071 and the display panel 6061 are two independent components to implement the input and output functions of the electronic device, in some embodiments, the touch panel 6071 and the display panel 6061 may be integrated to implement the input and output functions of the electronic device, which is not limited herein.

The interface unit 608 is an interface for connecting an external device to the electronic apparatus 600. For example, the external device may include a wired or wireless headset port, an external power supply (or battery charger) port, a wired or wireless data port, a memory card port, a port for connecting a device having an identification module, an audio input/output (I/O) port, a video I/O port, an earphone port, and the like. The interface unit 608 may be used to receive input (e.g., data information, power, etc.) from external devices and transmit the received input to one or more elements within the electronic device 600 or may be used to transmit data between the electronic device 600 and external devices.

The memory 609 may be used to store software programs as well as various data. The memory 609 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, a phonebook, etc.) created according to the use of the cellular phone, etc. Further, the memory 609 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid state storage device.

The processor 610 is a control center of the electronic device, connects various parts of the whole electronic device by using various interfaces and lines, performs various functions of the electronic device and processes data by running or executing software programs and/or modules stored in the memory 609, and calling data stored in the memory 609, thereby performing overall monitoring of the electronic device. Processor 610 may include one or more processing units; preferably, the processor 610 may integrate an application processor, which mainly handles operating systems, user interfaces, application programs, etc., and a modem processor, which mainly handles wireless communications. It will be appreciated that the modem processor described above may not be integrated into the processor 610.

The electronic device 600 may further include a power supply 611 (e.g., a battery) for supplying power to the various components, and preferably, the power supply 611 may be logically connected to the processor 610 via a power management system, such that the power management system may be used to manage charging, discharging, and power consumption.

In addition, the electronic device 600 includes some functional modules that are not shown, and are not described in detail herein.

It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one of 8230, and" comprising 8230does not exclude the presence of additional like elements in a process, method, article, or apparatus comprising the element.

Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.

While the present invention has been described with reference to the particular illustrative embodiments, it is to be understood that the invention is not limited to the disclosed embodiments, but is intended to cover various modifications, equivalent arrangements, and equivalents thereof, which may be made by those skilled in the art without departing from the spirit and scope of the invention as defined by the appended claims.

Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.

It can be clearly understood by those skilled in the art that, for convenience and simplicity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.

In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.

The functions may be stored in a computer-readable storage medium if they are implemented in the form of software functional units and sold or used as separate products. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U disk, a removable hard disk, a ROM, a RAM, a magnetic disk or an optical disk, and various media capable of storing program codes.

The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily think of the changes or substitutions within the technical scope of the present invention, and shall cover the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims

1. A travel track data generation method is applied to a travel track data query system, wherein the travel track data query system is configured with a corresponding distributed database, and comprises the following steps:

acquiring a target terminal device identification number, and determining target signaling data aiming at the target terminal device identification number in the distributed database through the target terminal device identification number;

2. The method of claim 1, wherein the trip trace data query system comprises a front end terminal device, the front end terminal device is installed with a trip trace data query application program for querying trip trace data, the distributed database has an indexing logic plug-in for indexing the signaling data, and the method further comprises:

3. The method of claim 2, wherein the step of determining target signaling data for the target terminal device identification number in the distributed database by the target terminal device identification number comprises:

4. The method of claim 1, wherein the travel track data query system comprises a front end terminal device, the front end terminal device is installed with a travel track data query application program for querying travel track data, the travel track data query system is configured with a corresponding massively parallel processing database, and the method further comprises:

5. The method according to claim 4, wherein the step of obtaining the measurement report data uploaded by the mobile terminal and storing the measurement report data in the massively parallel processing database comprises:

acquiring measurement report data uploaded by a mobile terminal;

writing the measurement report data in a text document;

6. The method of claim 2 or 4, wherein the travel trajectory data query application includes a user interface for displaying travel trajectory data, the method further comprising:

7. The method of claim 6, further comprising:

8. The device for generating the travel track data is applied to a travel track data query system, wherein the travel track data query system is configured with a corresponding distributed database, and comprises the following steps:

the target signaling data determination module is used for acquiring a target terminal equipment identification number and determining target signaling data aiming at the target terminal equipment identification number in the distributed database through the target terminal equipment identification number;

9. The apparatus of claim 8, wherein the travel track data query system comprises a front end terminal device, the front end terminal device is installed with a travel track data query application program for querying travel track data, the distributed database has an indexing logic plug-in for indexing the signaling data, and the apparatus further comprises:

10. The apparatus of claim 9, wherein the target signaling data determining module comprises:

11. The apparatus according to claim 8, wherein the travel track data query system includes a front end terminal device, the front end terminal device is installed with a travel track data query application program for querying travel track data, the travel track data query system is configured with a corresponding massively parallel processing database, and the apparatus further includes:

12. The apparatus of claim 11, wherein the measurement report data obtaining module comprises:

13. The apparatus according to claim 9 or 11, wherein the travel track data query application program includes a user operation interface for displaying travel track data, the apparatus further comprising:

14. The apparatus of claim 13, further comprising:

15. An electronic device, comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other via the communication bus;

the memory is used for storing a computer program;

the processor, when executing a program stored on the memory, implementing the method of any of claims 1-7.

16. A computer-readable storage medium having instructions stored thereon, which when executed by one or more processors, cause the processors to perform the method recited by any of claims 1-7.