CN101572628B - Call detail record pegging method and system therefor - Google Patents

Call detail record pegging method and system therefor Download PDF

Info

Publication number
CN101572628B
CN101572628B CN 200910104004 CN200910104004A CN101572628B CN 101572628 B CN101572628 B CN 101572628B CN 200910104004 CN200910104004 CN 200910104004 CN 200910104004 A CN200910104004 A CN 200910104004A CN 101572628 B CN101572628 B CN 101572628B
Authority
CN
China
Prior art keywords
cdr
statistical
records
description
management module
Prior art date
Application number
CN 200910104004
Other languages
Chinese (zh)
Other versions
CN101572628A (en
Inventor
张强
舒忠玲
雒江涛
张治中
Original Assignee
重庆重邮东电通信技术有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 重庆重邮东电通信技术有限公司 filed Critical 重庆重邮东电通信技术有限公司
Priority to CN 200910104004 priority Critical patent/CN101572628B/en
Publication of CN101572628A publication Critical patent/CN101572628A/en
Application granted granted Critical
Publication of CN101572628B publication Critical patent/CN101572628B/en

Links

Abstract

为解决现有技术统计记录管理模块与CDR管理模块之间耦合度较高、对查询条件的增加或修改复杂且耗费较大等问题,本发明提出一种呼叫详细记录反查方法及系统。 In order to solve the higher the degree of coupling between the prior art and statistical records management module CDR management module, additions or modifications to the query is complex and consumes large problems, call detail records to provide a method and system for pegging the present invention. 本发明呼叫详细记录反查方法采用CDR描述表和统计记录集描述表实现统计记录与CDR之间的对应关系,采用统计记录集描述表对CDR查询条件表达式进行配置。 Call Detail Record The present invention is a method using reverse lookup table described CDR records and statistics collection description achieve a correspondence between the statistical records CDR, statistical description of the CDR record set query expressions configuration. 本发明呼叫详细记录反查系统的CDR管理模块与统计记录管理模块完全分离,在需要增加或修改查询条件时只需对统计记录集描述表进行修改或增加即可实现,因此,大大提高了开发效率,降低开发成本,维护起来极为便利。 Call Detail Record The present invention is set only on the statistical record table describes modifications or additions can be realized when the reverse lookup system management module and statistical records CDR management module completely separated, the need to add or modify the query, thus greatly improving the development efficiency, reduce development costs, maintenance is very convenient.

Description

呼叫详细记录反查方法及系统 Call Detail Record Lookup method and system

技术领域 FIELD

[0001] 本发明涉及通信网络传输性能的监测和分析技术,尤其涉及到通信网络监测和分析技术中呼叫详细记录反查方法及系统。 [0001] The present invention relates to a communication network and monitoring transmission performance of analytical techniques, in particular, relates to a communication network monitoring and analysis techniques Call Detail Record Lookup methods and systems.

背景技术 Background technique

[0002] 在通信网络监测技术中,常采用对某一呼叫过程的信息交互进行分析,从而监测到网络的运行情况,得到网络通信质量的监测指标。 [0002] In a communication network monitoring technique, often used for information interaction process of a call are analyzed, in order to monitor the operation of the network, network traffic is monitored quality metrics. 为准确监测和分析每一呼叫过程的信息交互情况,需要进行呼叫合成。 In order to accurately monitor and analyze case information exchange process for each call, you need to make a call synthesis. 所谓呼叫合成就是对采集到的每条消息进行分类,分辨出每一条消息所对应的呼叫过程,并得到该呼叫过程的呼叫详细记录(英文Call DetailRecord,简称为⑶R),并储存CDR和该⑶R所对应的消息。 The so-called synthetic call is collected for each message to be classified, to distinguish the call process corresponding to each message, and the call to obtain call detail record process (in English Call DetailRecord, abbreviated as ⑶R), and storing the CDR and ⑶R the corresponding message. 并且,在进行呼叫合成的同时,还需要对合成完毕的CDR进行实时统计。 And, making a call synthesis, it is also required for the synthesis of CDR completed real-time statistics. 现有技术在对CDR进行实时统计时,采用的方法是CDR合成完毕后,发送给统计记录管理模块,统计记录管理模块实时生成统计记录。 When the prior art for real-time statistics of the CDR, the CDR method used is the synthesis is completed, the recording management module transmits to the statistics, statistical records statistics management module generates a real-time recording. 需要说明的是,统计记录管理模块在对CDR进行处理时,需要定义CDR结构体和统计记录结构体,并使CDR结构体与统计记录结构体之间形成对应关系。 Incidentally, when the statistical records of the management module CDR processed structure and the need to define the statistical records CDR structure, and to form a corresponding relation between the structure and the statistical records CDR structure. 相应的,现有技术采用CDR管理模块对网络信息交互进行呼叫合成并对CDR进行管理,采用统计记录管理模块处理合成完毕的⑶R并对统计记录进行管理。 Accordingly, the prior art using network information management module CDR interactions and synthetic CDR call management, statistical processing ⑶R recording management module and the synthesis completed statistical records management.

[0003] 在对某一呼叫过程信息交互进行分析的过程中,常常需要通过统计记录查询CDR(通常被称为统计记录的CDR反查)。 [0003] In the process of analyzing the information exchange a call, often you need to query statistical records CDR (CDR often referred to statistics record reverse lookup). 所谓CDR反查是指根据某一统计记录对已经合成完毕的CDR进行查询,获取符合该统计记录条件的所有CDR集合。 The so-called reverse lookup CDR refers to a CDR has completed the synthesis of a query based on statistical records, get a collection of all CDR in line with the statistical recording conditions. 显然,要查询就必须建立统计记录与CDR之间的对应关系,并根据该对应关系获取符合条件的CDR集合。 Obviously, you want to query must establish correspondence between the statistical records and CDR, CDR collection and get qualified according to the correspondence. 现有技术进行CDR反查时,通常按照统计记录结构体和CDR结构体的对应关系构建查询条件表达式,查询所有合成完毕的CDR,然后,返回符合条件的CDR集合。 When the prior art for CDR reverse lookup, typically built in a corresponding relationship between the structure and the statistical records CDR structure query expressions, query all synthetic CDR completed, and then returns the set of CDR qualified. 例如,当需要对isup协议统计记录中释放原因为O的统计记录(即relcauseO)进行CDR查询时,其查询条件的表达式为:isup_cdr.0pc = = isup_statistic.0pc && isup_cdr.dpc == isup_statistic.dpcAfcrelcause==OtjSm7Struct isup_cdr 即为定义的isup CDR 结构体,struct isup_statistic即为定义的isup统计记录结构体。 For example, when the need for statistical reasons isup recording agreement to release statistical records of O (ie relcauseO) were CDR query expressions that query is: isup_cdr.0pc = = isup_statistic.0pc && isup_cdr.dpc == isup_statistic. isup CDR structure is the dpcAfcrelcause == OtjSm7Struct isup_cdr defined, struct isup_statistic ISUP is the definition of the structure of the statistical records.

[0004] 现有技术采用统计记录结构体和CDR结构体实现两者之间的对应关系,而定义或者声明统计记录结构体和CDR结构体的功能模块分别设置在统计记录管理模块和CDR管理模块中,造成统计记录管理模块和CDR管理模块的耦合度较高,统计记录管理模块的微小改动均需要对CDR管理模块的相应部分进行改动,使得CDR管理模块和统计记录管理模块的代码维护极为不便。 [0004] The prior art structure and the statistical records CDR structures to achieve correspondence between the two, and the function module definition statements or statistical records CDR structures and structures are provided in the recording management module statistics management module and CDR , resulting in a higher degree of coupling statistical records management module and CDR management module, statistical records management module minor changes are needed to make changes to the corresponding part of the CDR management module, making the code CDR management module and statistical records management module maintenance is extremely inconvenient . 另外,现有技术查询条件表达式的生成方式是在代码编译时确定的,使得修改或增加查询条件时需要重新编译源程序,十分复杂且耗费较大。 Further, the prior art generation method of the query expression is determined at compile time the code, so that the need to recompile source code when modifying or adding query is very complex and time-consuming larger.

发明内容 SUMMARY

[0005]为解决现有技术统计记录管理模块与CDR管理模块之间耦合度较高、对查询条件的增加或修改复杂且耗费较大等问题,本发明提出一种呼叫详细记录反查方法及系统。 [0005] In order to solve the higher the degree of coupling between the prior art and statistical records management module CDR management module, additions or modifications to the query is complex and consumes large problems, it proposes a method of call detail records and Reverse Lookup invention system. 本发明呼叫详细记录反查方法采用CDR描述表和统计记录集描述表实现统计记录与CDR之间的对应关系,采用统计记录集描述表对CDR查询条件表达式进行配置。 Call Detail Record The present invention is a method using reverse lookup table described CDR records and statistics collection description achieve a correspondence between the statistical records CDR, statistical description of the CDR record set query expressions configuration. 本发明呼叫详细记录反查系统的CDR管理模块与统计记录管理模块完全分离,在需要增加或修改查询条件时只需对统计记录集描述表进行修改或增加即可实现,因此,大大提高了开发效率,降低开发成本,维护起来极为便利。 Call Detail Record The present invention is set only on the statistical record table describes modifications or additions can be realized when the reverse lookup system management module and statistical records CDR management module completely separated, the need to add or modify the query, thus greatly improving the development efficiency, reduce development costs, maintenance is very convenient.

[0006] 本发明呼叫详细记录反查方法采用CDR描述表和统计记录集描述表分别对CDR管理模块和统计记录管理模块进行配置;采用⑶R标签建立统计记录与⑶R之间的对应关系;采用统计记录集描述表对查询条件表达式进行配置并以查询条件表达式和CDR标签作为查询条件;其中,CDR标签由系统生成,可以是字母、数字、字符串或其组合。 [0006] The present invention is a Call Detail Record CDR Methods described Reverse Lookup table records and statistics, respectively CDR description set management module and the configuration management module statistical records; tag using ⑶R establishing a correspondence between the statistical records and ⑶R; statistical record set description table query expressions and configured to query expressions and the query as CDR label; wherein, CDR tags generated by the system, may be letters, numbers, strings, or combinations thereof.

[0007] 本发明呼叫详细记录反查方法采用CDR描述表和统计记录集描述表分别对CDR管理模块和统计记录管理模块进行配置,包括:在⑶R管理模块外部建立⑶R描述表,⑶R管理模块能够读取CDR描述表的信息并依此对CDR属性进行增加或修改;在统计记录管理模块外部建立统计记录集描述表,统计管理模块能够读取统计记录集描述表的信息并依此对统计记录的属性进行增加或修改。 [0007] The present invention is a call detail record Lookup Methods CDR description and statistical records set description respectively CDR management module and statistical records management module configuration, comprising: establishing ⑶R description outside ⑶R management module, ⑶R management module is capable of CDR description read information and so on CDR attribute is added or modified; build statistical description record set management module in an external statistical records, statistics management module can read information recorded set of statistical description of the statistical records and so on the properties are added or modified.

[0008] 本发明呼叫详细记录反查方法的⑶R描述表,内容包括:⑶R标签和⑶R属性描述,其中,CDR属性描述又包括CDR的字段类型、字段长度、字段过滤名和字段显示名。 [0008] The present invention is a call detail record Lookup table ⑶R described method, including: ⑶R ⑶R tags and attributes described in which, in turn comprising CDR attribute describes the CDR field type, field length, field name and field display name filtration.

[0009] 本发明呼叫详细记录反查方法的统计记录集描述表,内容包括:统计记录集信息描述和统计记录集字段信息描述,其中: [0009] The present invention is a call detail record Lookup statistical methodology described in the record set, includes: recording statistics and statistical records set information set fields described description, wherein:

[0010] 统计记录集信息描述,包括:记录集名称、⑶R标签及索引; [0010] Description statistics record set information, comprising: a recording set name, ⑶R labels and indexes;

[0011] 统计记录集字段信息描述,包括:记录集中字段的字段类型、字段过滤名和字段的⑶R查询条件表达式;其中,⑶R查询条件表达式是以字符串形式存在的⑶R过滤条件。 [0011] Field description set statistical records, comprising: a recording ⑶R query expressions for the field type field, the field names and field filter; wherein, ⑶R query expressions are ⑶R string of the presence of the filter.

[0012] 本发明呼叫详细记录反查方法采用CDR标签建立统计记录与CDR之间的对应关系,包括:在呼叫合成前系统生成⑶R标签并采用此标签对合成完毕的⑶R进行标识,一个⑶R标签对应一个⑶R,并分别在⑶R描述表和统计记录集描述表中建立⑶R标签索引。 [0012] The present invention Call Detail Record CDR Label Lookup Methods establishing a correspondence between the statistical records CDR, comprising: generating a tag ⑶R call system and using this synthetic precursors for the synthesis completed ⑶R tag identified, a label ⑶R It corresponds to a ⑶R, and were established in ⑶R ⑶R label description table and index records statistical description table set.

[0013] 本发明呼叫详细记录反查方法采用统计记录集描述表对查询条件表达式进行配置并以查询条件表达式和CDR标签作为查询条件,包括:根据待查询的统计记录字段确定该统计记录字段所对应的统计记录集名称,根据该统计记录集名称获取对应的统计记录集描述表,根据统计记录集描述表中该统计记录字段的CDR查询条件的描述生成CDR查询条件表达式并获取统计记录集描述表中相应的CDR标签,将前述CDR查询条件表达式和CDR标签作为查询条件;其中,所述⑶R查询条件表达式是以字符串形式存在的⑶R过滤条件。 [0013] The present invention is a call detail record Lookup record set using statistical methods described table configuration query expressions and the query to the conditional expression and CDR label as a query, comprising: recording the statistics records to be queried in the field is determined according to the field name corresponds to the statistical record set, to acquire a corresponding set of statistical records statistical records based on the description set name, generation CDR CDR query expressions from the description set query statistics records the statistical description table and obtain statistical record field record set corresponding CDR description table label, the CDR and CDR tag query expression as a query; wherein said query expressions are ⑶R ⑶R string of the presence of the filter.

[0014] 本发明呼叫详细记录反查方法在进行呼叫详细记录反查时,包括以下步骤: When [0014] the present invention, a call detail record Lookup carrying out the method call detail record reverse lookup, comprising the steps of:

[0015] 1、统计记录管理模块根据待查询的统计记录字段确定所对应的统计记录集名称; [0015] 1, statistics management module records statistics records to be queried to determine the field names corresponding to the set of statistical records according to;

[0016] 2、统计记录管理模块根据统计记录集名称获取所对应的统计记录集描述表; [0016] 2, the management module acquires statistical records statistical records corresponding description set based on the statistical record set name;

[0017] 3、统计记录管理模块根据统计记录集描述表中该统计记录字段的CDR查询条件的描述生成CDR查询条件表达式,CDR查询条件表达式是以字符串形式存在的CDR过滤条件; [0017] 3, the statistics management module generates a CDR record query expressions from the description of the statistical records CDR query conditions set in the statistical description of the recording field, CDR query expression is present in the form of a string of CDR filter conditions;

[0018] 4、统计记录管理模块获取该统计记录集描述表对应的⑶R标签; [0018] 4, statistical records statistical record management module acquires the corresponding description set ⑶R tag;

[0019] 5、统计记录管理模块向⑶R管理模块发送包含有前述⑶R查询条件表达式和⑶R标签的⑶R查询请求; [0019] 5, statistical records management module transmits to the management module comprises ⑶R ⑶R ⑶R the query request and the query condition expression ⑶R tags;

[0020] 6、⑶R管理模块根据⑶R标签获取对应的⑶R描述表; [0020] 6, ⑶R management module acquires the corresponding table according to ⑶R ⑶R described label;

[0021 ] 7 XDR管理模块依次读取具有该⑶R标签的全部⑶R并获取满足⑶R查询条件表达式的⑶R集合。 [0021] 7 XDR ⑶R management module reads sequentially all having the same tag and acquiring ⑶R meet ⑶R set ⑶R query expression.

[0022] 本发明呼叫详细记录反查系统,包括:⑶R描述表、⑶R管理模块、呼叫合成模块、统计记录集描述表、统计记录管理模块、统计模块和人机界面,其中: [0022] The present invention is a call detail record pegging system, comprising: ⑶R description, ⑶R management module, a call module synthesis, described in the table set statistical records, records statistics management module, a statistics module and HMI, wherein:

[0023] CDR描述表用于对不同规范协议的CDR属性进行描述并传输给CDR管理模块; [0023] CDR CDR property description for different protocol specification will be described and transferred to CDR management module;

[0024] CDR管理模块能够获取CDR描述表的信息并依此对CDR属性进行增加或修改;根据系统生成的⑶R标签对呼叫合成完毕的⑶R进行标识并建立⑶R标签索引;依据⑶R查询条件表达式和CDR标签对CDR进行查询; [0024] CDR CDR management module description information can be acquired and so on CDR attribute is added or modified; call for identification of the synthesis completed ⑶R label system according ⑶R generated index label and establish ⑶R; query expression based ⑶R CDR and CDR label on the query;

[0025] 呼叫合成模块根据CDR管理模块的指令和协议规范要求对网络信令进行呼叫合成; [0025] Synthesis of module specifications call for a call network signaling protocol synthesized according to the instructions and CDR management module;

[0026] 统计记录集描述表能够对不同规范协议的统计记录、统计记录集属性进行描述并传输给统计记录管理模块;根据待查询统计记录字段和该统计记录字段的CDR查询条件的描述生成⑶R查询条件表达式;生成包含有⑶R查询条件表达式和⑶R标签的⑶R查询条件;根据⑶R标签对统计记录进行标识并建立⑶R标签索引; [0026] Statistics recordset description can be statistical records for different protocol specification, the statistical record set attribute will be described and transferred to the statistical records of the management module; generating ⑶R description CDR query conditions to query statistics record fields and the statistical records field query expressions; there ⑶R query generates a query expression and ⑶R ⑶R label; for identification of statistical records based on ⑶R label and establish ⑶R label index;

[0027] 统计记录管理模块能够获取统计记录集描述表的信息并依此对统计记录、统计记录集的属性进行增加或修改; [0027] Statistics can acquire the information management module records statistical records and so description set statistical records statistical property record set is added or modified;

[0028] 统计模块根据统计记录管理模块的指令和协议规范要求对CDR进行统计; [0028] Statistics module specifications in accordance with instructions of the CDR statistics and statistical records management protocol module;

[0029] 人机界面能够接收人为控制命令并将控制命令传输给CDR描述表或统计记录集描述表;显示查询结果信息。 [0029] The human machine interface capable of receiving a control command and the control command transmitted to the CDR description table or record set description; displaying the search result.

附图说明 BRIEF DESCRIPTION

[0030] 附图1是本发明呼叫详细记录反查方法isup实施例CDR描述表的示意图; [0030] Figure 1 is a Call Detail Record The present invention is a method isup schematic diagram Reverse Lookup table CDR described embodiment;

[0031] 附图2是本发明呼叫详细记录反查方法isup实施例统计记录集描述表的示意图; [0031] Figure 2 is a call detail record according to the present invention is a schematic diagram of statistical method of pegging the recording sheet set isup described embodiment;

[0032] 附图3是本发明呼叫详细记录反查方法在进行呼叫详细记录反查时的流程示意图; [0032] Figure 3 is a call detail record according to the present invention carrying out the method pegging pegging schematic flow when the call detail record;

[0033] 附图4是本发明呼叫详细记录反查系统的结构示意图。 [0033] Figure 4 is a schematic view of the present invention, a call detail record pegging system configuration.

[0034] 下面结合附图及具体实施例对本发明呼叫详细记录反查方法及系统做进一步的说明。 [0034] The following detailed recording method and system for reverse look further embodiment of the present invention is described in conjunction with the accompanying drawings and specific embodiments call.

具体实施方式 Detailed ways

[0035] 具体实施例1 [0035] DETAILED Example 1

[0036] 附图1是本发明呼叫详细记录反查方法isup实施例⑶R描述表的示意图。 [0036] Figure 1 is a schematic view of the present invention, a call detail record methodology described in Example ⑶R isup embodiment of pegging. 由图可知,⑶R描述表用于描述⑶R,包括:⑶R标签和⑶R属性描述。 Seen from FIG, ⑶R description is used to describe ⑶R, comprising: ⑶R ⑶R tags and attributes described. 在本实施例中,⑶R标签采用了⑶R_TYPE的取值来表述,如附图1中⑶R描述表的第4行“cdr_type = 15 O”;⑶R属性描述包括:CDR每个属性的字段类型、字段长度、字段过滤名和字段显示名,如附图1中的CDRITEM 部分。 In the present embodiment, using the tag value ⑶R_TYPE ⑶R be expressed as in FIG. 1, line 4 described in Table ⑶R "cdr_type = 15 O"; ⑶R attribute describes comprising: CDR each attribute field type, field length, field names and field display name filter, as illustrated CDRITEM portion 1. 如附图1 中CDR 描述表的第11 行“4 = call_num,9,50,Calling PartyNumber,主叫号码”,即描述了索引号为O的字段的属性名称为call_num,数据类型为9 (字符串类型),字段长度为50,字段英文名为“Calling Party Number”,字段中文名为“主叫 The CDR described in Figure 1 of the table row 11 "4 = call_num, 9,50, Calling PartyNumber, the calling number", which describes the index number for the name of the field attribute O is call_num, 9 of the data type (character string type), a length field 50, a field English called "calling Party Number", Chinese field called "caller

号码”。 number".

[0037] 具体实施例2 [0037] Specific Example 2

[0038] 附图2是本发明呼叫详细记录反查方法isup实施例统计记录集描述表的示意图。 [0038] Figure 2 is a Call Detail Record The present invention method is a schematic diagram Reverse Lookup record set statistics table isup described embodiment. 由图可知,统计记录集描述表用于描述统计记录集,包括,统计记录集信息描述和统计记录集字段信息描述,其中: The figure shows a statistical record set description descriptive statistics record set, includes, statistical records and statistical records set information set fields described description, wherein:

[0039] 统计记录集信息描述,包括:记录集名称、⑶R标签及索引; [0039] Description statistics record set information, comprising: a recording set name, ⑶R labels and indexes;

[0040] 统计记录集字段信息描述,包括:记录集中字段的字段类型、字段过滤名和字段的⑶R查询条件表达式;其中,⑶R查询条件表达式是以字符串形式存在的⑶R过滤条件。 [0040] Field description set statistical records, comprising: a recording ⑶R query expressions for the field type field, the field names and field filter; wherein, ⑶R query expressions are ⑶R string of the presence of the filter.

[0041] 在本实施例中,附图2的statstic_cfg部分(附图2中的第1、2、3行): [0041] In the present embodiment, statstic_cfg portion 2 of the drawings (in FIG. 2, lines 2 and 3):

[0042] “statistic_name = ISUP_SPC” [0042] "statistic_name = ISUP_SPC"

[0043] “sub_statistic_name = isup_call_statistic” 描述了呼叫统计记录集的名称。 [0043] "sub_statistic_name = isup_call_statistic" describes the name of the call set of statistical records.

[0044] “relook_cdrtype = 150” (附图2中的第5行)描述了该统计记录的⑶R标签。 [0044] "relook_cdrtype = 150" (reference 2, line 5) describe ⑶R statistical record of the tag.

[0045] 而Record部分包含了对统计字段的描述,例如(附图2中的第8行): [0045] Record the description of the statistics section contains the fields, for example (line 2 of the drawings. 8):

[0046] “O = 1300m_UDStAddr源信令点描述了索引号为O的字段,数据类型为9 (信令点格式,长度为4),记录中偏移量为0,字段长度为O (可通过数据类型确定),字段英文名为“m_uDStAddr”,字段中文名为“源信令点”。查询条件表达式为表示没有定义查询条件)。对于每条统计记录,可以通过这些描述表获取统计记录中指定的字段的取值和查询条件。 [0046] "O = 1300m_UDStAddr source signaling point O as described index field, the data type 9 (signaling point format, length 4), the record offset 0, field length of O (by data type determination), field English called "m_uDStAddr", Chinese field called "source signaling point." query expression. for each statistical records, can not obtain statistical record is a defined query) is described by the table values ​​and conditions specified in the query field.

[0047] 另外,在本实施例的display部分(附图2中的第17行),还对字段的显示名称、统计记录集的分组条件等进行了描述。 [0047] Further, the display portion in the present embodiment (FIG. 2, line 17), also display the name of the field, sets the grouping condition statistical records and the like are described. 在function_colum部分(附图2中的第28行)描述了用户自定义的统计项。 In statistical terms function_colum section describes the user-defined (reference line 28 in Figure 2).

[0048] 附图3是本发明呼叫详细记录反查方法在进行呼叫详细记录反查时的流程示意图。 [0048] Figure 3 is a call detail record according to the present invention is a schematic flow diagram Reverse Lookup carrying out the method when the call detail record pegging. 由图可知,本发明呼叫详细记录反查方法包括以下步骤: The figure shows that the call detail records according to the present invention, the method comprising the steps of Reverse Lookup:

[0049] 1、统计记录管理模块根据待查询的统计记录字段确定所对应的统计记录集名称; [0049] 1, statistics management module records statistics records to be queried to determine the field names corresponding to the set of statistical records according to;

[0050] 2、统计记录管理模块根据统计记录集名称获取所对应的统计记录集描述表; [0050] 2, the management module acquires statistical records statistical records corresponding description set based on the statistical record set name;

[0051] 3、统计记录管理模块根据统计记录集描述表中该统计记录字段的CDR查询条件的描述生成CDR查询条件表达式,CDR查询条件表达式是以字符串形式存在的CDR过滤条件; [0051] 3, the statistics management module generates a CDR record query expressions from the description of the statistical records CDR query conditions set in the statistical description of the recording field, CDR query expression is present in the form of a string of CDR filter conditions;

[0052] 4、统计记录管理模块获取该统计记录集描述表对应的⑶R标签; [0052] 4, statistical records statistical record management module acquires the corresponding description set ⑶R tag;

[0053] 5、统计记录管理模块向⑶R管理模块发送包含有前述⑶R查询条件表达式和⑶R标签的⑶R查询请求; [0053] 5, statistical records management module transmits to the management module comprises ⑶R ⑶R ⑶R the query request and the query condition expression ⑶R tags;

[0054] 6、⑶R管理模块根据⑶R标签获取对应的⑶R描述表; [0054] 6, ⑶R management module acquires the corresponding table according to ⑶R ⑶R described label;

[0055] 7 XDR管理模块依次读取具有该⑶R标签的全部⑶R并获取满足⑶R查询条件表达式的⑶R集合。 [0055] 7 XDR ⑶R management module reads sequentially all having the same tag and acquiring ⑶R meet ⑶R set ⑶R query expression.

[0056] 由以上步骤可知,本发明呼叫详细记录反查方法主要包括三个主要技术特征:1、采用CDR描述表和统计记录集描述表分别对CDR管理模块和统计记录管理模块进行配置;2、采用CDR标签建立统计记录与CDR之间的对应关系;3、采用统计记录集描述表对查询条件表达式进行配置并以查询条件表达式和CDR标签作为查询条件;其中,CDR标签由系统生成,可以是字母、数字、字符串或其组合。 [0056] From the above steps, the call detail records according to the present invention mainly comprises three anti-check method Main technical characteristics: 1, using statistical records CDR description and set of tables is described CDR management module and the configuration management module statistical records; 2 using CDR label establishing a correspondence between the statistical records CDR;. 3, statistical description of recording current query expressions and configured to query expressions and the query as CDR label; wherein, CDR generated by the system tags , may be letters, numbers, strings, or combinations thereof. 其中: among them:

[0057] 采用⑶R描述表和统计记录集描述表分别对⑶R管理模块和统计记录管理模块进行配置,包括:在⑶R管理模块外部建立⑶R描述表,⑶R管理模块能够读取⑶R描述表的信息并依此对CDR属性进行增加或修改;在统计记录管理模块外部建立统计记录集描述表,统计管理模块能够读取统计记录集描述表的信息并依此对统计记录的属性进行增加或修改。 [0057] The description and statistical records ⑶R description set respectively ⑶R statistical records management module and the configuration management module, comprising: establishing a description ⑶R outside ⑶R management module, ⑶R management module can read information and description ⑶R and so on CDR attribute is added or modified; build statistical description record set management module in an external statistical records, statistics management module can read information recorded set of statistical description of statistical property records and so on will be added or modified. 所述CDR描述表的内容包括:CDR标签和CDR属性描述,其中,CDR属性描述又包括CDR的字段类型、字段长度、字段过滤名和字段显示名。 The CDR content description table comprises: CDR and CDR tag attributes described in which, in turn comprising CDR attribute describes the CDR field type, field length, field name and field display name filtration. 所述统计记录集描述表的内容包括:统计记录集信息描述和统计记录集字段信息描述,其中:统计记录集信息描述包括:记录集名称、CDR标签及索引;统计记录集字段信息描述包括:记录集中字段的字段类型、字段过滤名和字段的⑶R查询条件表达式;其中,⑶R查询条件表达式是以字符串形式存在的⑶R过滤条件。 The statistical description of the content recording set comprising: recording statistics and statistical records set information set fields described description, wherein: the statistical information describing record set comprising: a recording set name, CDR labels and indexes; statistical record set information Description field comprises: field of fields in the type of recording, ⑶R query field names and field filter expression; wherein, ⑶R query expressions are ⑶R presence of the filter in the form of a string.

[0058] 采用⑶R标签建立统计记录与⑶R之间的对应关系,包括:在呼叫合成前系统生成⑶R标签并采用此标签对合成完毕的⑶R进行标识,一个⑶R标签对应一个⑶R,并分别在⑶R描述表和统计记录集描述表中建立⑶R标签索引。 [0058] The tab ⑶R establishing a correspondence between the statistical records and ⑶R, comprising: generating a tag ⑶R call system and using this synthetic precursors for the synthesis completed ⑶R tag identified, a label corresponding to a ⑶R ⑶R, and respectively ⑶R description and statistical record label established ⑶R index set description table.

[0059] 采用统计记录集描述表对查询条件表达式进行配置并以查询条件表达式和⑶R标签作为查询条件,包括:根据待查询的统计记录字段确定该统计记录字段所对应的统计记录集名称,根据该统计记录集名称获取对应的统计记录集描述表,根据统计记录集描述表中该统计记录字段的CDR查询条件的描述生成CDR查询条件表达式并获取统计记录集描述表中相应的CDR标签,将前述CDR查询条件表达式和CDR标签作为查询条件;其中,所述⑶R查询条件表达式是以字符串形式存在的⑶R过滤条件。 [0059] The description of the statistical record set query expressions and configured to query expressions and ⑶R tag as a query, comprising: a statistical record of the corresponding field of statistics records statistical record field name to be set is determined based on the query acquire a corresponding set of statistical records statistical records based on the description set name, generation CDR CDR query expressions from the description set query statistics records the statistical description table and get statistics record field description table record set corresponding CDR tag, the aforementioned conditional expressions and the query CDR CDR label as a query; wherein said query expressions are ⑶R ⑶R string of the presence of the filter.

[0060] 附图4是本发明呼叫详细记录反查系统的结构示意图。 [0060] Figure 4 is a schematic view of the present invention, a call detail record pegging system configuration. 由图可知,本发明呼叫详细记录反查系统,包括=CDR描述表、CDR管理模块、呼叫合成模块、统计记录集描述表、统计记录管理模块、统计模块和人机界面,其中: The figure shows that the call detail records according to the present invention, anti-check system, including description = CDR, CDR management module, a call module synthesis, described in the table set statistical records, records statistics management module, a statistics module and HMI, wherein:

[0061] CDR描述表用于对不同规范协议的CDR属性进行描述并传输给CDR管理模块; [0061] CDR CDR property description for different protocol specification will be described and transferred to CDR management module;

[0062] CDR管理模块能够获取CDR描述表的信息并依此对CDR属性进行增加或修改;根据系统生成的⑶R标签对呼叫合成完毕的⑶R进行标识并建立⑶R标签索引;依据⑶R查询条件表达式和CDR标签对CDR进行查询; [0062] CDR CDR management module description information can be acquired and so on CDR attribute is added or modified; call for identification of the synthesis completed ⑶R label system according ⑶R generated index label and establish ⑶R; query expression based ⑶R CDR and CDR label on the query;

[0063] 呼叫合成模块根据CDR管理模块的指令和协议规范要求对网络信令进行呼叫合成; [0063] Synthesis of module specifications call for a call network signaling protocol synthesized according to the instructions and CDR management module;

[0064] 统计记录集描述表能够对不同规范协议的统计记录、统计记录集属性进行描述并传输给统计记录管理模块;根据待查询统计记录字段和该统计记录字段的CDR查询条件的描述生成⑶R查询条件表达式;生成包含有⑶R查询条件表达式和⑶R标签的⑶R查询条件;根据⑶R标签对统计记录进行标识并建立⑶R标签索引; [0064] Statistics recordset description can be statistical records for different protocol specification, the statistical record set attribute will be described and transferred to the statistical records of the management module; generating ⑶R description CDR query conditions to query statistics record fields and the statistical records field query expressions; there ⑶R query generates a query expression and ⑶R ⑶R label; for identification of statistical records based on ⑶R label and establish ⑶R label index;

[0065] 统计记录管理模块能够获取统计记录集描述表的信息并依此对统计记录、统计记录集的属性进行增加或修改; [0065] Statistics can acquire the information management module records statistical records and so description set statistical records statistical property record set is added or modified;

[0066] 统计模块根据统计记录管理模块的指令和协议规范要求对CDR进行统计; [0066] Statistics module specifications in accordance with instructions of the CDR statistics and statistical records management protocol module;

[0067] 人机界面能够接收人为控制命令并将控制命令传输给CDR描述表或统计记录集描述表;显示查询结果信息。 [0067] The human machine interface capable of receiving a control command and the control command transmitted to the CDR description table or record set description; displaying the search result.

[0068] 显然,由于本发明呼叫详细记录反查方法及系统采用外部文件CDR描述表和统计记录集描述表对CDR管理模块和统计记录管理模块进行配置,系统中CDR管理模块与统计记录管理模块完全分离,两者之间不存在耦合关系,维护起来极为便利。 [0068] Obviously, since the present invention is a call detail record Lookup Method and system for using the system CDR management module and statistical records management module external file CDR description and statistical records current description of the CDR management module and statistical records management module configuration, completely separated, the coupling relationship does not exist between the two, it is very convenient to maintain. 另外,由于采用统计记录集描述表对查询条件表达式进行配置并以查询条件表达式和CDR标签作为查询条件,在增加或修改统计指标时只需对外部文件CDR描述表和统计记录集描述表进行修改或增加即可实现,因此,大大提高了开发效率,降低开发成本。 Further, since the statistical description of the set of records query expressions and configured to query expressions and CDR label as a query, when only added or modified statistical indicators and statistical records CDR description set external file description table modify or increase can be realized, therefore, greatly improving development efficiency and reduce development costs.

Claims (4)

1.一种呼叫详细记录反查方法,其特征在于:采用呼叫详细记录CDR描述表和统计记录集描述表分别对CDR管理模块和统计记录管理模块进行配置;采用CDR标签建立统计记录与CDR之间的对应关系;采用统计记录集描述表对查询条件表达式进行配置并以查询条件表达式和CDR标签作为查询条件;在进行呼叫详细记录反查时,包括以下步骤: (1)统计记录管理模块根据待查询的统计记录字段确定所对应的统计记录集名称; (2)统计记录管理模块根据统计记录集名称获取所对应的统计记录集描述表; (3)统计记录管理模块根据统计记录集描述表中该统计记录字段的CDR查询条件的描述生成⑶R查询条件表达式,⑶R查询条件表达式是以字符串形式存在的⑶R过滤条件; (4)统计记录管理模块获取该统计记录集描述表对应的CDR标签; (5)统计记录管理模块向⑶R管理模块发送包含有 An anti-check call detail records, characterized in that: the use of call detail records CDR description and statistical records CDR set, respectively description management module and the configuration management module statistical records; build statistical records using a CDR CDR tag the correspondence between; statistical description of recording current query expressions and configured to query expressions and CDR label as a query; call detail record when performing reverse lookup, comprising the steps of: (1) recording management statistics module according to statistics record fields to be queried to determine statistical record set name corresponding; (2) statistical record management module acquires statistical records set descriptor table corresponding to the statistics record set name; (3) statistical recording management module records set according to the statistics description of the CDR query field generated statistical record query expression ⑶R description table, ⑶R ⑶R query expressions are strings of the presence of the filter; (4) statistics statistics recording management module obtains the description recordset CDR corresponding label; (5) comprises statistical records management module transmits to the management module ⑶R 前述⑶R查询条件表达式和⑶R标签的⑶R查询请求; (6)⑶R管理模块根据⑶R标签获取对应的⑶R描述表; (7)⑶R管理模块依次读取具有该⑶R标签的全部⑶R并获取满足⑶R查询条件表达式的⑶R集合; 其中,⑶R标签由系统生成,为字母、数字、字符串或其组合; 所述采用CDR描述表和统计记录集描述表分别对CDR管理模块和统计记录管理模块进行配置,包括:在⑶R管理模块外部建立⑶R描述表,⑶R管理模块能够读取⑶R描述表的信息并依此对CDR属性进行增加或修改;在统计记录管理模块外部建立统计记录集描述表,统计管理模块能够读取统·计记录集描述表的信息并依此对统计记录的属性进行增加或修改; 所述采用CDR标签建立统计记录与CDR之间的对应关系,包括:在呼叫合成前系统生成⑶R标签并采用此标签对合成完毕的⑶R进行标识,一个⑶R标签对应一个⑶R, ⑶R ⑶R the query request and the query expressions ⑶R label; (6) ⑶R management module acquires the corresponding table according to ⑶R ⑶R described label; (7) ⑶R sequentially read all of the management module having ⑶R tag and acquiring the ⑶R satisfies ⑶R ⑶R set of query expressions; wherein, ⑶R tags generated by the system, letters, numbers, strings or a combination thereof; and the use of statistical description records CDR set, respectively description CDR records and statistics management module management module configuration, comprising: establishing a description ⑶R outside ⑶R management module, ⑶R management module can read information ⑶R description and so on CDR attribute is added or modified; build statistical description record set management module in an external statistical records, statistics statistics management module can read information record set, count and so description of statistical property records to be added or modified; CDR using the tag to establish a correspondence between the statistical records CDR, comprising: a call in the system before the synthesis of ⑶R generated using this tag and tag synthesis completed ⑶R identified, a label corresponding to a ⑶R ⑶R, 分别在⑶R描述表和统计记录集描述表中建立⑶R标签索引; 所述采用统计记录集描述表对查询条件表达式进行配置并以查询条件表达式和CDR标签作为查询条件,包括:根据待查询的统计记录字段确定该统计记录字段所对应的统计记录集名称,根据该统计记录集名称获取对应的统计记录集描述表,根据统计记录集描述表中该统计记录字段的CDR查询条件的描述生成CDR查询条件表达式并获取统计记录集描述表中相应的CDR标签,将前述CDR查询条件表达式和CDR标签作为查询条件;其中,所述⑶R查询条件表达式是以字符串形式存在的⑶R过滤条件。 Were established in ⑶R ⑶R label description table and index records statistical description table set; the statistical description of recording current query expressions and configured to query expressions and CDR label as a query, comprising: the to be queried statistical record field to determine statistical record set the name of the statistical record field corresponding to acquire a corresponding statistical record set description table based on the statistical record set name, description CDR query statistics record set description table the statistical record fields generated CDR query expression and obtain statistical record set corresponding CDR description table label, the CDR and CDR tag query expression as a query; wherein said ⑶R query expression is present in the form of a string filter ⑶R condition.
2.根据权利要求1所述呼叫详细记录反查方法,其特征在于:CDR描述表的内容包括:CDR标签和CDR属性描述,其中,CDR属性描述又包括CDR的字段类型、字段长度、字段过滤名和子段显不名。 2. The method of claim 1 anti-check call detail records, characterized in that claim: CDR content description table comprises: CDR and CDR tag attributes described in which, in turn comprising CDR attribute describes the CDR field type, field length, field filter name and sub-segment were not significant.
3.根据权利要求1所述呼叫详细记录反查方法,其特征在于:统计记录集描述表的内容包括:统计记录集信息描述和统计记录集字段信息描述,其中: 统计记录集信息描述,包括:记录集名称、CDR标签及索引; 统计记录集字段信息描述,包括:记录集中字段的字段类型、字段过滤名和字段的CDR查询条件表达式;其中,⑶R查询条件表达式是以字符串形式存在的⑶R过滤条件。 According to claim 1 said method call detail records Reverse Lookup claim, wherein: the content of statistical records set description table comprises: recording statistics and statistical records set information set fields described description, wherein: the statistical description record set information, comprising : record set name, CDR labels and indexes; statistics record set description field, including: centralized record field type field, CDR query filter expression field names and field; which, ⑶R query expression is present in the form of a string the ⑶R filter.
4.一种呼叫详细记录反查系统,其特征在于,该系统包括:⑶R描述表、⑶R管理模块、呼叫合成模块、统计记录集描述表、统计记录管理模块、统计模块和人机界面,其中:CDR描述表用于对不同规范协议的CDR属性进行描述并传输给CDR管理模块; CDR管理模块能够获取CDR描述表的信息并依此对CDR属性进行增加或修改;根据系统生成的⑶R标签对呼叫合成完毕的⑶R进行标识并建立⑶R标签索引;依据⑶R查询条件表达式和CDR标签对CDR进行查询; 呼叫合成模块根据CDR管理模块的指令和协议规范要求对网络信令进行呼叫合成; 统计记录集描述表能够对不同规范协议的统计记录、统计记录集属性进行描述并传输给统计记录管理模块;根据待查询统计记录字段和该统计记录字段的CDR查询条件的描述生成⑶R查询条件表达式;生成包含有⑶R查询条件表达式和⑶R标签的⑶R An anti-check call detail record system, characterized in that the system comprises: ⑶R description, ⑶R management module, a call module synthesis, described in the table set statistical records, records statistics management module, a statistics module, and interface, wherein : CDR CDR property description for different protocol specification will be described and transferred to CDR management module; CDR CDR management module description information can be acquired and so on CDR to add or modify attributes; tag system according to the generated ⑶R synthesis of completed calls are identified and established ⑶R ⑶R tab index; CDR query based on the query expressions and CDR ⑶R tags; calling synthesized according to the instruction module and protocol specification requirements CDR management module call network signaling synthesis; statistical records description table record can be set to different statistical protocol specification, the statistical record set attribute will be described and transferred to the statistical records of the management module; generating ⑶R query expression according to the query conditions described CDR statistics records to be queried and the field of the recording field statistics; there ⑶R ⑶R generates a query expression and ⑶R labels 询条件;根据⑶R标签对统计记录进行标识并建立⑶R标签索引; 统计记录管理模块能够获取统计记录集描述表的信息并依此对统计记录、统计记录集的属性进行增加或修改; 统计模块根据统计记录管理模块的指令和协议规范要求对CDR进行统计; 人机界面能够接收人为控制命令并将控制命令传输给CDR描述表或统计记录集描述表;显示查询结果信息。 Query conditions; ⑶R according to statistics record label to identify and establish ⑶R label index; statistical records management module can obtain statistical information record set description of the table and so on statistical records, property records set of statistics be added or modified; according to statistics module statistical records management module commands and protocol specification requirements CDR statistics; human machine interface capable of receiving a control command and the control command transmitted to the CDR description table or record set description; displaying the search result.
CN 200910104004 2009-06-03 2009-06-03 Call detail record pegging method and system therefor CN101572628B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 200910104004 CN101572628B (en) 2009-06-03 2009-06-03 Call detail record pegging method and system therefor

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 200910104004 CN101572628B (en) 2009-06-03 2009-06-03 Call detail record pegging method and system therefor

Publications (2)

Publication Number Publication Date
CN101572628A CN101572628A (en) 2009-11-04
CN101572628B true CN101572628B (en) 2014-02-12

Family

ID=41231867

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 200910104004 CN101572628B (en) 2009-06-03 2009-06-03 Call detail record pegging method and system therefor

Country Status (1)

Country Link
CN (1) CN101572628B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103647666A (en) * 2013-12-13 2014-03-19 北京中创信测科技股份有限公司 Method and apparatus for counting call detail record (CDR) messages and outputting results in real time

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6359976B1 (en) 1998-06-08 2002-03-19 Inet Technologies, Inc. System and method for monitoring service quality in a communications network
CN1761277A (en) 2004-10-11 2006-04-19 中兴通讯股份有限公司 Device for dynamic analyzing call ticket and dynamic analyzing method
CN1842022A (en) 2005-03-28 2006-10-04 华为技术有限公司 Log processing system and method
CN101247434A (en) 2007-02-16 2008-08-20 中兴通讯股份有限公司 Traffic analyzing method and system
CN101394451A (en) 2008-11-06 2009-03-25 北京中创信测科技股份有限公司 Storage method for call detailed recorded data, indication method and system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6359976B1 (en) 1998-06-08 2002-03-19 Inet Technologies, Inc. System and method for monitoring service quality in a communications network
CN1761277A (en) 2004-10-11 2006-04-19 中兴通讯股份有限公司 Device for dynamic analyzing call ticket and dynamic analyzing method
CN1842022A (en) 2005-03-28 2006-10-04 华为技术有限公司 Log processing system and method
CN101247434A (en) 2007-02-16 2008-08-20 中兴通讯股份有限公司 Traffic analyzing method and system
CN101394451A (en) 2008-11-06 2009-03-25 北京中创信测科技股份有限公司 Storage method for call detailed recorded data, indication method and system

Also Published As

Publication number Publication date
CN101572628A (en) 2009-11-04

Similar Documents

Publication Publication Date Title
US6691254B2 (en) Method and apparatus for analyzing performance of data processing system
US9128916B2 (en) Machine data web
EP2011013B1 (en) Merging multi-line log entries
US8578017B2 (en) Automatic correlation of service level agreement and operating level agreement
US20060004745A1 (en) Structured reporting report data manager
US10255238B2 (en) CEP engine and method for processing CEP queries
US8402131B2 (en) Hierarchy for characterizing interactions with an application
US8656006B2 (en) Integrating traffic monitoring data and application runtime data
US8792385B2 (en) Method and device for auto-generating goose signal connection topology from substation level
US7734775B2 (en) Method of semi-automatic data collection, data analysis, and model generation for the performance analysis of enterprise applications
CN100531055C (en) Data synchronous system and its method
CN103631907B (en) A relational data migration to a method and system for HBase
CN100530183C (en) System and method for collecting watch database
CN100395987C (en) Method and system for realizing telecommunication network universal performance management
US8935389B2 (en) Method and system for collecting and managing network data
US9696894B2 (en) Analytic process design
CN102098175B (en) Alarm association rule obtaining method of mobile internet
JP2004362557A (en) System and method for processing data of measurement instrument
WO2015039046A1 (en) Data flow exploration
CN103532780A (en) Operation and maintenance monitoring integral system and integral monitoring method used in IT (information technology) field
CN101047556A (en) Integral maintaining method and system for multi-equipment
US20120323941A1 (en) Processing Queries for Event Data in a Foreign Representation
CN101661460B (en) Method and device for generating management system report
US10237292B2 (en) Selecting network security investigation timelines based on identifiers
CN101257694A (en) Mobile communication network managing intelligent sending method based on information support system

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination
C14 Grant of patent or utility model
CP03 Change of name, title or address
CP01 Change in the name or title of a patent holder
CP02 Change in the address of a patent holder