Method and device for storing signaling log text in database

Abstract

The present invention belongs to the technical field of log processing, and in particular relates to a method and a device for storing signaling log text into a database. The method includes the following steps: parsing the first signaling log in the log text to obtain the first signaling type and the first signaling generation time corresponding to the first signaling log; judging whether the first signaling type includes the first master-slave If the first signaling type includes the first calling and called number, then extract the first calling and called number, and establish a first mapping i between the first calling and called number and the first signaling generation time; The first calling and called numbers, the first signaling generation time, and the first mapping i are written into the database. This method can be used for the processing of signaling logs, which can store corresponding keywords in the database, which can improve the speed of follow-up queries, thereby improving the query efficiency, and can also facilitate the search and query for multiple matching conditions, and facilitate the retrieval of relevant information. Statistical Analysis.

Description

technical field [0001] The present invention belongs to the technical field of log processing, and in particular relates to a method and a device for storing signaling log text into a database. Background technique [0002] The existing No. 7 signaling log is stored in a text file. If you query the number of successful calls of a certain calling number within a period of time according to the text file, the general process is: first, according to the calling number in the text of the signaling log Search the call record of the calling number in a certain period of time (each call record represents a call), and then check whether each call has received ANM (in the signaling signal) according to the time slot in each call record A kind of, indicating that the off-hook signal is connected. Therefore, it is necessary to inquire whether each call represented by each call record is successful or not, which is slow and inefficient, and is also very unfavorable for searching and co...

AI Technical Summary

Problems solved by technology

Therefore, it is necessary to query whether each call represented by each call record is successful or not. Such query speed is slow and inefficient, and it is also very unfavorable for searching and counting multiple compound conditions.

Images