CN109450660A - The method and device of signaling log text deposit database - Google Patents
The method and device of signaling log text deposit database Download PDFInfo
- Publication number
- CN109450660A CN109450660A CN201711078878.7A CN201711078878A CN109450660A CN 109450660 A CN109450660 A CN 109450660A CN 201711078878 A CN201711078878 A CN 201711078878A CN 109450660 A CN109450660 A CN 109450660A
- Authority
- CN
- China
- Prior art keywords
- signaling
- log
- calling
- numbers
- mapping
- 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
Links
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/06—Management of faults, events, alarms or notifications
- H04L41/069—Management of faults, events, alarms or notifications using logs of notifications; Post-processing of notifications
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Telephonic Communication Services (AREA)
Abstract
Present specification belongs to journaling technique field, and in particular to the method and device of signaling log text deposit database.Method includes the following steps: the first signaling log in parsing log text, obtains the first signaling type corresponding with the first signaling log and the first signaling generation time;Judge whether the first signaling type includes the first numbers of calling and called parties;If the first signaling type includes the first numbers of calling and called parties, the first numbers of calling and called parties is extracted, and the first numbers of calling and called parties and the first signaling generation time are established into the first mapping I;Database is written into first numbers of calling and called parties, the first signaling generation time, the first mapping I.This method can be used for the processing of signaling log, corresponding keyword can be stored in database by it, subsequent query speed can be improved, and then improve search efficiency, also can be convenient for it is multiple it is eligible scan for inquiring, the convenient statistical analysis to relevant information.
Description
Technical field
Present specification belongs to journaling technique field, and in particular to signaling log text deposit database method and
Device.
Background technique
Existing signalling system No.7 log is stored in text file, is existed if inquiring some calling number according to text file
As soon as the number of the access success in the period, substantially process are: first being searched in signaling log text according to calling number
The call record (each call record represents call) of the calling number in some period is remembered further according to each calling
Time slot in record goes to check each calling either with or without receiving ANM (one of signaling-information, expression are connected) off hook signal.Cause
This needs to inquire whether per call that each call record represents succeeds one by one, and such inquiry velocity is slow, low efficiency, nor
Often it is unfavorable for the search and statistics for multiple compound conditions.
Summary of the invention
In order to solve the above technical problem, the present invention provides the methods and dress of a kind of signaling log text deposit database
It sets, corresponding keyword can be stored in database by this method, subsequent query speed can be improved, and then improve inquiry effect
Rate, also can be convenient for it is multiple it is eligible scan for inquiring, the convenient statistical analysis to relevant information.
The invention provides the following technical scheme:
On the one hand, a kind of method of signaling log text deposit database is provided in the embodiment of the present invention comprising following
Step:
Parse log text in the first signaling log, obtain the first signaling type corresponding with the first signaling log and
First signaling generation time;
Judge whether first signaling type includes the first numbers of calling and called parties;
If first signaling type includes the first numbers of calling and called parties, first numbers of calling and called parties is extracted, and will
First numbers of calling and called parties and the first signaling generation time establish the first mapping I;
Database is written into first numbers of calling and called parties, the first signaling generation time, the first mapping I.
The method of the signaling log text deposit database, wherein after the first signaling log of the parsing further include:
Parse after the first signaling log described in the log text and adjacent with the first signaling log
Two signaling logs obtain the second signaling type corresponding with the second signaling log and the second signaling generation time;
Judge whether second signaling type includes the second numbers of calling and called parties;
If second signaling type does not include the second numbers of calling and called parties, second signaling type and second are believed
It enables generation time establish the second mapping, and first numbers of calling and called parties and second mapping is established into comprehensive mapping I;
By second signaling type, the I write-in data of the second signaling generation time, the second mapping and comprehensive mapping
Library.
The method of the signaling log text deposit database, wherein after parsing the second signaling log further include:
Parse after the second signaling log described in the log text and adjacent with the second signaling log
Three signaling logs obtain third signaling type corresponding with the third signaling log and third signaling generation time;
Judge whether the third signaling type includes third numbers of calling and called parties;
If the third signaling type does not include third numbers of calling and called parties, by the third numbers of calling and called parties with it is described
Third signaling generation time establishes third mapping, and first numbers of calling and called parties and third mapping are established comprehensive mapping
Ⅱ;
By the third signaling type, II write-in database of third signaling generation time, third mapping and comprehensive mapping.
The method of the signaling log text deposit database, wherein after parsing the third signaling log, also wrap
It includes:
Parse after third signaling log described in the log text and adjacent with the third signaling log
Four signaling logs obtain the 4th signaling type corresponding with the 4th signaling log and the 4th signaling generation time;
Judge whether the 4th signaling type includes the 4th numbers of calling and called parties;
If the 4th signaling type includes the 4th numbers of calling and called parties, the 4th numbers of calling and called parties is extracted, and will
4th numbers of calling and called parties and the 4th signaling generation time establish the 4th mapping;
By the 4th numbers of calling and called parties, the 4th signaling generation time, the 4th mapping write-in database.
The method of the signaling log text deposit database, wherein if first signaling type does not include first
First signaling type and the first signaling generation time are then established the first mapping II by numbers of calling and called parties, and by described first
It maps II and preceding numbers of calling and called parties is established preceding synthesis and mapped;The preceding numbers of calling and called parties is the first letter described in the log text
The numbers of calling and called parties for enabling the preceding signaling type of preceding signaling log before log and adjacent with the first signaling log include
Or there is the numbers of calling and called parties of mapping relations with the preceding signaling type of preceding signaling log;
The preceding numbers of calling and called parties, the first signaling type, the first signaling generation time, the first mapping II and preceding synthesis are reflected
Penetrate write-in database.
On the other hand, a kind of device of signaling log text deposit database is also provided in the embodiment of the present invention comprising:
Parsing module obtains corresponding with the first signaling log for parsing the first signaling log in log text
First signaling type and the first signaling generation time;
Judgment module, for judging whether first signaling type includes the first numbers of calling and called parties;
It is main to extract described first if including the first numbers of calling and called parties for first signaling type for mapping block
Called number, and first numbers of calling and called parties and the first signaling generation time are established into the first mapping I;
Writing module, for data to be written in first numbers of calling and called parties, the first signaling generation time, the first mapping I
Library.
The device of the described signaling log text deposit database, wherein the parsing module is also used to the parsing the
After one signaling log, parse it is after the first signaling log described in the log text and with the first signaling log phase
The second adjacent signaling log, obtains the second signaling type corresponding with the second signaling log and the second signaling generation time;
The judgment module is also used to judge whether second signaling type includes the second numbers of calling and called parties;
The mapping block will be described if being also used to second signaling type does not include the second numbers of calling and called parties
Second signaling type and the second signaling generation time establish the second mapping, and first numbers of calling and called parties is reflected with described second
Penetrate the comprehensive mapping I of foundation;
The write module is also used to second signaling type, the second signaling generation time, the second mapping and synthesis
The I write-in database of mapping.
The device of the described signaling log text deposit database, wherein the parsing module is also used to parse described the
After two signaling logs, parse it is after the second signaling log described in the log text and with the second signaling log phase
Adjacent third signaling log, obtains third signaling type corresponding with the third signaling log and third signaling generation time;
The judgment module is also used to judge whether the third signaling type includes third numbers of calling and called parties;
The mapping block will be described if being also used to the third signaling type does not include third numbers of calling and called parties
Third numbers of calling and called parties and the third signaling generation time establish third mapping, and by first numbers of calling and called parties with it is described
Comprehensive mapping II is established in third mapping;
The write module is also used to the third signaling type, third signaling generation time, third mapping and synthesis
II write-in database of mapping.
The device of the described signaling log text deposit database, wherein the parsing module is also used to parse described the
After three signaling logs, parse it is after third signaling log described in the log text and with the third signaling log phase
The 4th adjacent signaling log, obtains the 4th signaling type corresponding with the 4th signaling log and the 4th signaling generation time;
The judgment module is also used to judge whether the 4th signaling type includes the 4th numbers of calling and called parties;
The mapping block, if be also used to the 4th signaling type include the 4th numbers of calling and called parties, extract described in
4th numbers of calling and called parties, and the 4th numbers of calling and called parties and the 4th signaling generation time are established into the 4th mapping;
The write module is also used to the 4th numbers of calling and called parties, the 4th signaling generation time, the 4th mapping write-in
Database.
The device of the described signaling log text deposit database, wherein the mapping block, if being also used to described the
One signaling type does not include the first numbers of calling and called parties, then first signaling type and the first signaling generation time is established first
II is mapped, and is mapped comprehensive before the first mapping II and the foundation of preceding numbers of calling and called parties;The preceding numbers of calling and called parties is described
The preceding signaling of preceding signaling log before first signaling log described in log text and adjacent with the first signaling log
Numbers of calling and called parties that type includes or the numbers of calling and called parties for having mapping relations with the preceding signaling type of preceding signaling log;
The write module, be also used to by the preceding numbers of calling and called parties, the first signaling type, the first signaling generation time,
First mapping II and preceding comprehensive mapping write-in database.
The method of signaling log text deposit database in the embodiment of the present invention can according to need signaling log text
Database is written in the first numbers of calling and called parties, the first signaling generation time, the first mapping I in this, subsequent to need to inquire the first letter
When enabling generation time, the first signaling generation time in the database can be directly inquired according to the first numbers of calling and called parties.It can
To improve subsequent inquiry velocity, and then improve search efficiency, also can be convenient for it is multiple it is eligible scan for inquiring,
The convenient statistical analysis to relevant information.
Detailed description of the invention
It, below will be to the present invention or the prior art in order to illustrate more clearly of the present invention or technical solution in the prior art
Attached drawing needed in description is briefly described, it should be apparent that, the accompanying drawings in the following description is only of the invention
Some embodiments for those of ordinary skill in the art without any creative labor, can also basis
These attached drawings obtain other attached drawings.
Fig. 1 is the flow chart of the method for the signaling log text deposit database in one embodiment of the present invention.
Fig. 2 is the part process of the method for the signaling log text deposit database in another preferred embodiment of the present invention
Figure.
Fig. 3 is the part process of the method for the signaling log text deposit database in another preferred embodiment of the present invention
Figure.
Fig. 4 is the structural block diagram of the device of the signaling log text deposit database in one embodiment of the present invention.
Specific embodiment
Below in conjunction with the attached drawing in the present invention, technical solution of the present invention is clearly and completely described, it is clear that
Described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, originally
Field those of ordinary skill every other embodiment obtained without making creative work, belongs to the present invention
The range of protection.
" first ", " second " in the embodiment of the present invention, " third ", " the 4th " only carry out distinctiveness to certain features
Ground address, this has no otherwise restriction in order to facilitate setting is understood.
The method of signaling log text deposit database as shown in Figure 1 comprising following steps:
S101: the first signaling log in parsing log text obtains the first signaling corresponding with the first signaling log
Type and the first signaling generation time.
In general, including signaling type, signaling generation time, time slot, tranceive type, source address, target in signaling log
The information such as location.Signaling type may include IAM (Initial Address Message initial address message), IAI (Initial
Address Message With Additional Information, the initial address message with additional information), ACM
(Address Complete Message, Address Complete Message), ANC (Answer Signal, Charge, response message, meter
Take), RLC (Release Complete, release complete), ANM (Answer Message, response message), RSC (Reset
Circuit signal reset-circuit signal), GRS (Circuit group reset message Circuit Group Reset message),
CFN (obscuring), REL (Release Message, release message), RLC (Release Complete, release are completed) etc..It is logical
It often, include rear subscriber number, called number in IAM.
S102: judge whether first signaling type includes the first numbers of calling and called parties.
The numbers of calling and called parties, refers to calling number and called number.If the first signaling type includes calling and called No. the first
Code, it can be said that the bright signaling type is initial address message or the initial address message with additional information, it is to establish
Calling and issue first message, illustrate that caller just starts to be called, in log text next signaling should be with
The caller, this by related signaling, until judging another group of numbers of calling and called parties according to signaling type.
S103: if first signaling type includes the first numbers of calling and called parties, extracting first numbers of calling and called parties,
And first numbers of calling and called parties and the first signaling generation time are established into the first mapping I.
It is subsequent for convenience that relative key message is searched out according to numbers of calling and called parties, then first by first calling and called
Number retention comes out, and first numbers of calling and called parties is established mapping relations to relevant key message.Here by first master
Called number and the first signaling generation time establish the first mapping I, can aspect it is subsequent according to first numbers of calling and called parties search for
The first signaling generation time out.
S104: database is written into first numbers of calling and called parties, the first signaling generation time, the first mapping I.
Usually database can also be written in the first signaling type, facilitate it is subsequent according to the first numbers of calling and called parties inquire this
One signaling type.
The method of signaling log text deposit database in the embodiment of the present invention can according to need signaling log text
Database is written in the first numbers of calling and called parties, the first signaling generation time, the first mapping I in this, subsequent to need to inquire the first letter
When enabling generation time, the first signaling generation time in the database can be directly inquired according to the first numbers of calling and called parties.It can
To improve subsequent inquiry velocity, and then improve search efficiency, also can be convenient for it is multiple it is eligible scan for inquiring,
The convenient statistical analysis to relevant information.
Based on the method for signaling log text shown in FIG. 1 deposit database, as shown in Fig. 2, the first signaling of the parsing
After log further include:
S105: it parses after the first signaling log described in the log text and adjacent with the first signaling log
The second signaling log, obtain the second signaling type corresponding with the second signaling log and the second signaling generation time.
It parses signaling log in the log text to carry out one by one in sequence, therefore, parses the first signaling log
It later, is after the first signaling log described in the parsing log text and adjacent with the first signaling log second
Signaling log.The second signaling type, the second signaling generation time in available second signaling log, second occupy when
The information such as gap, the tranceive type of the second signaling, the source address of the second signaling, the destination address of the second signaling.
S106: judge whether second signaling type includes the second numbers of calling and called parties.
S107: if second signaling type does not include the second numbers of calling and called parties, by second signaling type and
Second signaling generation time establishes the second mapping, and first numbers of calling and called parties and second mapping are established comprehensive mapping
Ⅰ。
If second signaling type does not include the second numbers of calling and called parties, illustrate main quilt relevant to second signaling
Code of calling out the numbers is the first numbers of calling and called parties in the first signaling type.Second signaling type and the second signaling generation time are built
Vertical second mapping, is in order in the database that the second signaling type and the second signaling generation time is corresponding, is the second letter
The time for enabling type generate is the second signaling generation time, and the corresponding signaling type of the second signaling generation time is the second signaling.
First numbers of calling and called parties and second mapping are established into comprehensive mapping I, be in order to subsequent according to the described first main quilt
Call out the numbers code from database search go out the second signaling type relevant to first numbers of calling and called parties and the second signaling generation time.
S108: will be described in second signaling type, I write-in of the second signaling generation time, the second mapping and comprehensive mapping
Database.
The method of signaling log text deposit database in the embodiment of the present invention can according to need signaling log text
The second signaling type relevant to the first numbers of calling and called parties, the second signaling generation time, the second mapping and comprehensive mapping I in this
Be written the database, it is subsequent to need to inquire relevant second signaling type of first numbers of calling and called parties, when the second signaling generates
Between when, second signaling type in the database can be directly inquired according to the first numbers of calling and called parties, when the second signaling generates
Between.Subsequent inquiry velocity can be improved in the embodiment of the present invention, and then improves search efficiency, also can be convenient and meets for multiple
Condition scans for inquiring, the convenient statistical analysis to relevant information.
Method based on signaling log text shown in Fig. 2 deposit database, wherein parsing the second signaling log it
Afterwards further include:
S109: it parses after the second signaling log described in the log text and adjacent with the second signaling log
Third signaling log, obtain third signaling type corresponding with the third signaling log and third signaling generation time;
S110: judge whether the third signaling type includes third numbers of calling and called parties;
S111: if the third signaling type does not include third numbers of calling and called parties, by the third numbers of calling and called parties
Establish third mapping with the third signaling generation time, and first numbers of calling and called parties and the third mapped establish it is comprehensive
Close mapping II;
If the third signaling type does not include third numbers of calling and called parties, illustrate main quilt relevant to the third signaling
Code of calling out the numbers is the first numbers of calling and called parties in the first signaling type.The third signaling type and third signaling generation time are built
Vertical second mapping is in order in the database that third signaling type and third signaling generation time is corresponding, is third letter
The time for enabling type generate is third signaling generation time, and the corresponding signaling type of third signaling generation time is third signaling.
First numbers of calling and called parties and third mapping are established into comprehensive mapping II, be in order to subsequent according to the described first main quilt
Call out the numbers code from database search go out third signaling type relevant to first numbers of calling and called parties and third signaling generation time.
S112: the third signaling type, third signaling generation time, third are mapped and data are written in comprehensive mapping II
Library.
The method of signaling log text deposit database in the embodiment of the present invention can according to need signaling log text
Third signaling type relevant to the first numbers of calling and called parties, third signaling generation time, third mapping and comprehensive mapping in this
The II write-in database, it is subsequent to need to inquire the relevant third signaling type of first numbers of calling and called parties, the generation of third signaling
When the time, the third signaling type in the database can be directly inquired according to the first numbers of calling and called parties, third signaling generates
Time.Subsequent inquiry velocity can be improved in the embodiment of the present invention, and then improves search efficiency, also can be convenient for multiple symbols
Conjunction condition scans for inquiring, the convenient statistical analysis to relevant information.
Method based on signaling log text shown in Fig. 2 deposit database further parses the third signaling day
After will, further includes:
S113: it parses after third signaling log described in the log text and adjacent with the third signaling log
The 4th signaling log, obtain the 4th signaling type corresponding with the 4th signaling log and the 4th signaling generation time;
S114: judge whether the 4th signaling type includes the 4th numbers of calling and called parties;
S115: if the 4th signaling type includes the 4th numbers of calling and called parties, extracting the 4th numbers of calling and called parties,
And the 4th numbers of calling and called parties and the 4th signaling generation time are established into the 4th mapping;
Here the 4th numbers of calling and called parties can be identical or different with first numbers of calling and called parties.
4th signaling type includes the 4th numbers of calling and called parties, then illustrates that relevant to the 4th signaling numbers of calling and called parties is the
Four numbers of calling and called parties.Illustrate to be stored in data with the signaling log for the related signaling of the first numbers of calling and called parties once conversed
Library.Certainly, in real process, relevant signaling has very much, is merely illustrative here one such.
Here the 4th numbers of calling and called parties and the 4th signaling generation time are established into the 4th mapping, it can the subsequent basis of aspect
4th numbers of calling and called parties searches out the 4th signaling generation time.
S116: by the 4th numbers of calling and called parties, the 4th signaling generation time, the 4th mapping write-in database.
Usually database can also be written in the 4th signaling type, facilitate it is subsequent according to the 4th numbers of calling and called parties inquire this
Four signaling types.
The method of signaling log text deposit database in the embodiment of the present invention can according to need signaling log text
The 4th numbers of calling and called parties, the 4th signaling generation time, the 4th mapping write-in database in this, it is subsequent to need to inquire the 4th signaling
When generation time, the 4th signaling generation time in the database can be directly inquired according to the 4th numbers of calling and called parties.It can be with
Improve subsequent inquiry velocity, and then improve search efficiency, also can be convenient for it is multiple it is eligible scan for inquiring, side
Just to the statistical analysis of relevant information.
Method based on signaling log text shown in FIG. 1 deposit database, in which:
If first signaling type does not include the first numbers of calling and called parties, first signaling type and first are believed
It enables generation time establish the first mapping II, and the first mapping II and preceding numbers of calling and called parties is established into preceding synthesis and mapped;It is described
Preceding numbers of calling and called parties be the first signaling log described in the log text before and it is adjacent with the first signaling log
The numbers of calling and called parties or have mapping relations with the preceding signaling type of preceding signaling log that the preceding signaling type of preceding signaling log includes
Numbers of calling and called parties;
The preceding numbers of calling and called parties, the first signaling type, the first signaling generation time, the first mapping II and preceding synthesis are reflected
Penetrate write-in database.
If first signaling type does not include the first numbers of calling and called parties, illustrate main quilt relevant to first signaling
Code of calling out the numbers is preceding numbers of calling and called parties.At this point, first signaling type and the first signaling generation time are established into the first mapping II,
It is in order in the database that the first signaling type and the first signaling generation time is corresponding, is what the first signaling type generated
Time is the first signaling generation time, and the corresponding signaling type of the first signaling generation time is the first signaling.Described first is reflected
Penetrate it is comprehensive before II and preceding numbers of calling and called parties are established map, be in order to it is subsequent according to the preceding numbers of calling and called parties from database search
The first signaling type relevant to the preceding numbers of calling and called parties and the first signaling generation time out.
The method of signaling log text deposit database in the embodiment of the present invention, can be according to believing in signaling log text
Log Sequence is enabled, parses signaling log one by one, and extract relevant key message, and establish corresponding mapping relations, is stored in number
Behind library, it can directly be inquired according to numbers of calling and called parties in its relevant signaling type, signaling production during subsequent query
Subsequent inquiry velocity can be improved it is possible thereby to judge whether per call succeeds in raw time etc., and then improves inquiry effect
Rate, also can be convenient for it is multiple it is eligible scan for inquiring, the convenient statistical analysis to relevant information.
The method of signaling log text deposit database as shown in Figure 3 comprising:
S201: selection signaling log text;
S202: first signaling log in signaling log text is read;
S203: judge whether reading succeeds;
S204: if reading is unsuccessful, reselection signalling log text (selects other signaling logs);
S205: if read successfully, parsing first signaling log in log text, obtains and this signaling log pair
The keyword answered is first signaling type and first signaling generation time;
S206: judge whether first signaling type includes numbers of calling and called parties, be to judge whether to be resolved to calling and called number
Code;
S207: if being resolved to numbers of calling and called parties, corresponding numbers of calling and called parties is updated, and according to method shown in FIG. 1
Establish corresponding mapping relations;
S208: if not being resolved to numbers of calling and called parties, according to method shown in Fig. 2, a calling and called number are continued to use
Code;
S209: will be in the field write-in database of needs.
S210: repeating step S202-S209, be successively read the log of Article 2 signaling, Article 3 signaling log ..., until
Signaling logs whole in selected signaling log text are run through, i.e., by the required keyword in the signaling log text
All it is deposited into database;
S211: step S201-S210 is repeated, selects signaling log text as needed, until by selected signaling day
The keyword in whole signaling logs in will text is all stored in database.
The device of signaling log text deposit database as shown in Figure 4 comprising:
Parsing module obtains corresponding with the first signaling log for parsing the first signaling log in log text
First signaling type and the first signaling generation time;
Judgment module, for judging whether first signaling type includes the first numbers of calling and called parties;
It is main to extract described first if including the first numbers of calling and called parties for first signaling type for mapping block
Called number, and first numbers of calling and called parties and the first signaling generation time are established into the first mapping I;
Writing module, for data to be written in first numbers of calling and called parties, the first signaling generation time, the first mapping I
Library.
The device of signaling log text deposit database in the embodiment of the present invention, may be implemented method as shown in Figure 1,
It can according to need the first numbers of calling and called parties in signaling log text, the first signaling generation time, the first mapping I write-in
Database, it is subsequent when needing to inquire the first signaling generation time, the database directly can be inquired according to the first numbers of calling and called parties
In the first signaling generation time.Subsequent inquiry velocity can be improved, and then improve search efficiency, also can be convenient and be directed to
It is multiple it is eligible scan for inquiring, the convenient statistical analysis to relevant information.
The device of signaling log text deposit database as shown in Figure 4, wherein the parsing module is also used to described
After parsing the first signaling log, parse it is after the first signaling log described in the log text and with first signaling
The second adjacent signaling log of log, obtains the second signaling type corresponding with the second signaling log and the second signaling generates
Time;
The judgment module is also used to judge whether second signaling type includes the second numbers of calling and called parties;
The mapping block will be described if being also used to second signaling type does not include the second numbers of calling and called parties
Second signaling type and the second signaling generation time establish the second mapping, and first numbers of calling and called parties is reflected with described second
Penetrate the comprehensive mapping I of foundation;
The write module is also used to second signaling type, the second signaling generation time, the second mapping and synthesis
The I write-in database of mapping.
The device of signaling log text deposit database as shown in Figure 4, further, the parsing module is also used to
After parsing the second signaling log, parse after the second signaling log described in the log text and with described second
The adjacent third signaling log of signaling log, obtains third signaling type corresponding with the third signaling log and third signaling
Generation time;
The judgment module is also used to judge whether the third signaling type includes third numbers of calling and called parties;
The mapping block will be described if being also used to the third signaling type does not include third numbers of calling and called parties
Third numbers of calling and called parties and the third signaling generation time establish third mapping, and by first numbers of calling and called parties with it is described
Comprehensive mapping II is established in third mapping;
The write module is also used to the third signaling type, third signaling generation time, third mapping and synthesis
II write-in database of mapping.
The device of signaling log text deposit database as shown in Figure 4, preferably, the parsing module, is also used to solve
After analysing the third signaling log, parses after third signaling log described in the log text and believe with the third
The 4th signaling log that log is adjacent is enabled, the 4th signaling type corresponding with the 4th signaling log is obtained and the 4th signaling produces
The raw time;
The judgment module is also used to judge whether the 4th signaling type includes the 4th numbers of calling and called parties;
The mapping block, if be also used to the 4th signaling type include the 4th numbers of calling and called parties, extract described in
4th numbers of calling and called parties, and the 4th numbers of calling and called parties and the 4th signaling generation time are established into the 4th mapping;
The write module is also used to the 4th numbers of calling and called parties, the 4th signaling generation time, the 4th mapping write-in
Database.
The device of signaling log text deposit database as shown in Figure 4, further, the mapping block is also used to
If first signaling type does not include the first numbers of calling and called parties, when first signaling type and the first signaling are generated
Between establish the first mapping II, and comprehensive before the first mapping II and preceding numbers of calling and called parties are established map;The preceding calling and called
Number be the first signaling log described in the log text before and preceding signaling day adjacent with the first signaling log
Numbers of calling and called parties that the preceding signaling type of will includes or the calling and called for having mapping relations with the preceding signaling type of preceding signaling log
Number;
The write module, be also used to by the preceding numbers of calling and called parties, the first signaling type, the first signaling generation time,
First mapping II and preceding comprehensive mapping write-in database.
The device of signaling log text deposit database in the embodiment of the present invention, can be according to believing in signaling log text
Log Sequence is enabled, parses signaling log one by one, and extract relevant key message, and establish corresponding mapping relations, is stored in number
Behind library, it can directly be inquired according to numbers of calling and called parties in its relevant signaling type, signaling production during subsequent query
Subsequent inquiry velocity can be improved it is possible thereby to judge whether per call succeeds in raw time etc., and then improves inquiry effect
Rate, also can be convenient for it is multiple it is eligible scan for inquiring, the convenient statistical analysis to relevant information.
Through the above description of the embodiments, those skilled in the art can be understood that the present invention can be by
Software adds the mode of required general hardware platform to realize, naturally it is also possible to which by hardware, but in many cases, the former is more
Good embodiment.Based on this understanding, technical solution of the present invention substantially in other words contributes to the prior art
Part can be embodied in the form of software products, which is stored in a storage medium, if including
Dry instruction is used so that terminal device (can be mobile phone, personal computer, server or the network equipment etc.) executes the present invention
Method described in each embodiment.
It will be appreciated by those skilled in the art that the module in device in embodiment can describe be divided according to embodiment
It is distributed in the device of embodiment, corresponding change can also be carried out and be located in one or more devices different from the present embodiment.On
The module for stating embodiment can integrate in one, can also be deployed separately;It can be merged into a module, can also further tear open
It is divided into multiple submodule.
The above is only a preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
Depending on protection scope of the present invention.
Claims (10)
1. the method for signaling log text deposit database, which comprises the following steps:
The first signaling log in log text is parsed, the first signaling type corresponding with the first signaling log and first are obtained
Signaling generation time;
Judge whether first signaling type includes the first numbers of calling and called parties;
If first signaling type includes the first numbers of calling and called parties, first numbers of calling and called parties is extracted, and will be described
First numbers of calling and called parties and the first signaling generation time establish the first mapping I;
Database is written into first numbers of calling and called parties, the first signaling generation time, the first mapping I.
2. the method for signaling log text deposit database according to claim 1, which is characterized in that the parsing first
After signaling log further include:
Parse the second after the first signaling log described in the log text and adjacent with the first signaling log letter
Log is enabled, the second signaling type corresponding with the second signaling log and the second signaling generation time are obtained;
Judge whether second signaling type includes the second numbers of calling and called parties;
If second signaling type does not include the second numbers of calling and called parties, second signaling type and the second signaling are produced
The raw time establishes the second mapping, and first numbers of calling and called parties and second mapping are established comprehensive mapping I;
By second signaling type, the I write-in database of the second signaling generation time, the second mapping and comprehensive mapping.
3. the method for signaling log text deposit database according to claim 2, which is characterized in that parsing described second
After signaling log further include:
Parse after the second signaling log described in the log text and adjacent with the second signaling log third letter
Log is enabled, third signaling type corresponding with the third signaling log and third signaling generation time are obtained;
Judge whether the third signaling type includes third numbers of calling and called parties;
If the third signaling type does not include third numbers of calling and called parties, by the third numbers of calling and called parties and the third
Signaling generation time establishes third mapping, and first numbers of calling and called parties and third mapping are established comprehensive mapping II;
By the third signaling type, II write-in database of third signaling generation time, third mapping and comprehensive mapping.
4. the method for signaling log text deposit database according to claim 3, which is characterized in that parse the third
After signaling log, further includes:
Parse the 4th after third signaling log described in the log text and adjacent with third signaling log letter
Log is enabled, the 4th signaling type corresponding with the 4th signaling log and the 4th signaling generation time are obtained;
Judge whether the 4th signaling type includes the 4th numbers of calling and called parties;
If the 4th signaling type includes the 4th numbers of calling and called parties, the 4th numbers of calling and called parties is extracted, and will be described
4th numbers of calling and called parties and the 4th signaling generation time establish the 4th mapping;
By the 4th numbers of calling and called parties, the 4th signaling generation time, the 4th mapping write-in database.
5. the method for signaling log text deposit database according to claim 1, which is characterized in that
If first signaling type does not include the first numbers of calling and called parties, first signaling type and the first signaling are produced
The raw time establishes the first mapping II, and maps comprehensive before the first mapping II and the foundation of preceding numbers of calling and called parties;It is main before described
Called number be the first signaling log described in the log text before and the preceding letter adjacent with the first signaling log
The numbers of calling and called parties that enables the preceding signaling type of log include or the master for having mapping relations with the preceding signaling type of preceding signaling log
Called number;
The preceding numbers of calling and called parties, the first signaling type, the first signaling generation time, the first mapping II and preceding comprehensive mapping are write
Enter database.
6. the device of signaling log text deposit database characterized by comprising
Parsing module obtains and the first signaling log corresponding first for parsing the first signaling log in log text
Signaling type and the first signaling generation time;
Judgment module, for judging whether first signaling type includes the first numbers of calling and called parties;
Mapping block extracts first calling and called if including the first numbers of calling and called parties for first signaling type
Number, and first numbers of calling and called parties and the first signaling generation time are established into the first mapping I;
Writing module, for database to be written in first numbers of calling and called parties, the first signaling generation time, the first mapping I.
7. the device of signaling log text deposit database according to claim 6, which is characterized in that the parsing mould
Block is also used to after the first signaling log of the parsing, parse it is after the first signaling log described in the log text and
The second signaling log adjacent with the first signaling log obtains the second signaling type corresponding with the second signaling log
With the second signaling generation time;
The judgment module is also used to judge whether second signaling type includes the second numbers of calling and called parties;
The mapping block, if being also used to second signaling type does not include the second numbers of calling and called parties, by described second
Signaling type and the second signaling generation time establish the second mapping, and first numbers of calling and called parties and second mapping are built
Vertical comprehensive mapping I;
The write module is also used to second signaling type, the second signaling generation time, the second mapping and comprehensive mapping
The I write-in database.
8. the device of signaling log text deposit database according to claim 7, which is characterized in that the parsing mould
Block, after being also used to parse the second signaling log, parse it is after the second signaling log described in the log text and
The third signaling log adjacent with the second signaling log obtains third signaling type corresponding with the third signaling log
With third signaling generation time;
The judgment module is also used to judge whether the third signaling type includes third numbers of calling and called parties;
The mapping block, if being also used to the third signaling type does not include third numbers of calling and called parties, by the third
Numbers of calling and called parties and the third signaling generation time establish third mapping, and by first numbers of calling and called parties and the third
Comprehensive mapping II is established in mapping;
The write module is also used to the third signaling type, third signaling generation time, third mapping and comprehensive mapping
II write-in database.
9. the device of signaling log text deposit database according to claim 8, which is characterized in that the parsing mould
Block, after being also used to parse the third signaling log, parse it is after third signaling log described in the log text and
The fourth signaling log adjacent with the third signaling log obtains the 4th signaling type corresponding with the 4th signaling log
With the 4th signaling generation time;
The judgment module is also used to judge whether the 4th signaling type includes the 4th numbers of calling and called parties;
The mapping block extracts the described 4th if being also used to the 4th signaling type includes the 4th numbers of calling and called parties
Numbers of calling and called parties, and the 4th numbers of calling and called parties and the 4th signaling generation time are established into the 4th mapping;
The write module is also used to the 4th numbers of calling and called parties, the 4th signaling generation time, the 4th mapping write-in data
Library.
10. the device of signaling log text deposit database according to claim 6, which is characterized in that
The mapping block, if being also used to first signaling type does not include the first numbers of calling and called parties, by described first
Signaling type and the first signaling generation time establish the first mapping II, and the first mapping II and preceding numbers of calling and called parties are established
Preceding comprehensive mapping;The preceding numbers of calling and called parties be the first signaling log described in the log text before and with described first
The numbers of calling and called parties that the preceding signaling type of the adjacent preceding signaling log of signaling log includes or the preceding signaling with preceding signaling log
Type has the numbers of calling and called parties of mapping relations;
The write module is also used to the preceding numbers of calling and called parties, the first signaling type, the first signaling generation time, first
Map II and preceding comprehensive mapping write-in database.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711078878.7A CN109450660B (en) | 2017-11-06 | 2017-11-06 | Method and device for storing signaling log text into database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711078878.7A CN109450660B (en) | 2017-11-06 | 2017-11-06 | Method and device for storing signaling log text into database |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109450660A true CN109450660A (en) | 2019-03-08 |
CN109450660B CN109450660B (en) | 2021-12-03 |
Family
ID=65530097
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711078878.7A Active CN109450660B (en) | 2017-11-06 | 2017-11-06 | Method and device for storing signaling log text into database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109450660B (en) |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2010079522A2 (en) * | 2009-01-09 | 2010-07-15 | Ugo Nevi | A technique for managing incoming calls on a cell phone |
CN103108318A (en) * | 2011-11-15 | 2013-05-15 | 中国移动通信集团山东有限公司 | Method and device achieving number backfill based on calling signalling relevance |
CN105025097A (en) * | 2015-07-14 | 2015-11-04 | 谢蓓 | Cloud server-based missed call prompt method and system |
CN105763370A (en) * | 2016-02-22 | 2016-07-13 | 贵阳朗玛信息技术股份有限公司 | Method and device for extracting signaling data |
CN105828334A (en) * | 2015-01-09 | 2016-08-03 | 中国移动通信集团河北有限公司 | Monitoring method and system for positioning illegal callback service |
-
2017
- 2017-11-06 CN CN201711078878.7A patent/CN109450660B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2010079522A2 (en) * | 2009-01-09 | 2010-07-15 | Ugo Nevi | A technique for managing incoming calls on a cell phone |
CN103108318A (en) * | 2011-11-15 | 2013-05-15 | 中国移动通信集团山东有限公司 | Method and device achieving number backfill based on calling signalling relevance |
CN105828334A (en) * | 2015-01-09 | 2016-08-03 | 中国移动通信集团河北有限公司 | Monitoring method and system for positioning illegal callback service |
CN105025097A (en) * | 2015-07-14 | 2015-11-04 | 谢蓓 | Cloud server-based missed call prompt method and system |
CN105763370A (en) * | 2016-02-22 | 2016-07-13 | 贵阳朗玛信息技术股份有限公司 | Method and device for extracting signaling data |
Also Published As
Publication number | Publication date |
---|---|
CN109450660B (en) | 2021-12-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109376552A (en) | A kind of evidence collection method and system for depositing card based on block chain | |
CN103377652A (en) | Method, device and equipment for carrying out voice recognition | |
CN105989076A (en) | Data statistical method and device | |
CN110674247A (en) | Barrage information intercepting method and device, storage medium and equipment | |
CN103368992A (en) | Message push method and device | |
CN102801859A (en) | Method and device for identifying junk short message, and mobile communication terminal with device | |
CN111125118B (en) | Associated data query method, device, equipment and medium | |
CN104572125A (en) | Methods and devices for drawing and storing entity relation diagrams | |
CN102510421A (en) | Method and client for correlating dial plate of terminal to data application | |
CN105843958A (en) | Cache-based server paging method and system | |
CN107644106A (en) | The internuncial method of automatic mining business, terminal device and storage medium | |
CN104636477A (en) | Push list duplicate removal method before information push | |
CN105635044A (en) | Information synchronization method and device | |
CN116737482A (en) | Method and device for collecting chip test data in real time and electronic equipment | |
CN103246663A (en) | Searching method and communication terminal | |
CN115039090A (en) | Data query method, device, server and storage medium | |
CN108984626B (en) | Data processing method and device and server | |
CN108494977B (en) | Method, device and system for identifying short signal code | |
CN104346151B (en) | A kind of information processing method and electronic equipment | |
CN109450660A (en) | The method and device of signaling log text deposit database | |
CN102932239B (en) | The means of communication in immediate communication platform and system | |
CN105094810B (en) | Data processing method and device based on CGI(Common gateway interface) plug-in unit | |
KR101033870B1 (en) | Method and device for processing spam call | |
CN112052248A (en) | Audit big data processing method and system | |
CN110597765A (en) | Large retail call center heterogeneous data source data processing method and device |
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 | ||
EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20190308 Assignee: Guiyang Longma Video Technology Co.,Ltd. Assignor: GUIYANG LONGMASTER INFORMATION & TECHNOLOGY Co.,Ltd. Contract record no.: X2022520000003 Denomination of invention: Method and device for storing signaling log text into database Granted publication date: 20211203 License type: Common License Record date: 20220302 |
|
EE01 | Entry into force of recordation of patent licensing contract |