CN100433774C - Telephone bill data processing method and apparatus - Google Patents
Telephone bill data processing method and apparatus Download PDFInfo
- Publication number
- CN100433774C CN100433774C CNB031366325A CN03136632A CN100433774C CN 100433774 C CN100433774 C CN 100433774C CN B031366325 A CNB031366325 A CN B031366325A CN 03136632 A CN03136632 A CN 03136632A CN 100433774 C CN100433774 C CN 100433774C
- Authority
- CN
- China
- Prior art keywords
- data
- expression formula
- database
- ticket
- call bill
- 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.)
- Expired - Fee Related
Links
Images
Abstract
The present invention discloses a preprocessing method of phone list data, which sets an expression for preprocessing the phone list data based on original data and standard data of the phone list; the expression is translated to be an expression of which the form can be identified by a computer, and stored into a database of the computer; in this way, the original data and associated data are read when pretreatment is carried out for the original phone list data, according to a processing requirement of the phone list data, the corresponding recognizable expression is invoked from the database of the computer, the standard data of the phone list is formed by operating the associated data and the original data of the phone list with the expression, then the standard data is carried out with statistics, and the statistical result is saved in the database. The method is suitable for the preprocessing of large numbers of the phone list data generated incessantly; after processing, the data quantity of the phone list processing can be effectively reduced, a convenient condition for reuse of the phone list data is provided, and the complexity of operation and maintaining is reduced when the phone list data is processed.
Description
Technical field
The present invention relates to the processing method of the telephone expenses business in the communication system and the device of realizing this methodological function.
Background technology
When in communication system, handling call bill data, need analyze the call bill data that is kept in file or the database according to certain rule, obtain the intermediate object program data, then middle result data be added up, data separating be come out according to certain rule.For example, in the ticket of intelligent network, calling number shape as: 075512345678, this number comprises two parts, first is domestic area code 0755, and second portion is the real telephone number of caller 12345678, needs to isolate from calling number area code and telephone number in the reality.After carrying out above-mentioned data separating, carry out the statistics of data again, that is, with data qualification, category summation or counting are for example added up the caller area code and are total how many bar tickets of 010, and how many air times is.
At present, the processing of call bill data commonly used is the processing method of database, use the prerequisite of database to need exactly processing again behind a large amount of initial data insertion databases, so not only need the mass data that continue to produce every day is inserted in the database, also need to write complicated storing process, finish the analysis of data by storing process,, also utilize the statistical function of database itself to finish if statistical requirements is arranged.The shortcoming of this method is that owing to need the initial data that continues in a large number to produce is inserted database, this will expend a large amount of data processing times, therefore be difficult to finish at short notice the processing of big several ticket according to amount before the analytic statistics of call bill data.During the processing logic of this external description call bill data, need write complicated storing process, to user's requirement height.As seen, the call bill data of existing method is handled complicated, is unfavorable for realizing the processing of the data in enormous quantities that continue.
Summary of the invention
The object of the present invention is to provide a kind of preprocess method and device of call bill data, the call bill data that continues to produce is carried out preliminary treatment, improve the database processing efficient of call bill data and the complexity of reduction operation.
For achieving the above object, the preprocess method of call bill data provided by the invention comprises:
Step 1: the expression formula of preliminary treatment call bill data is set, and described expression formula is used to describe the rule of handling call bill data;
Step 2: above-mentioned expression formula is construed to computer can discerns the expression formula of form and store in the database;
Step 3: the initial data and the associated data that read ticket, processing requirements according to call bill data, call the expression formula that can discern form accordingly from database, the initial data of utilizing this expression formula to operate above-mentioned associated data and ticket generates the normal data of ticket.
The process that but the recognition expression formula utilizes the initial data of associated data and ticket to generate the normal data of ticket in the step 3 is:
Step 31: read in ticket initial data and associated data;
Step 32: obtain the field value that to search, do maximum coupling, utilize matching result to generate normal data with the preceding N bit data and the associated data of this value.
Described step 3 also comprises: according to the processing requirements to normal data, call the expression formula that can discern form accordingly from the database of computer, utilize this expression formula that normal data is added up, result data is saved in database.
The pretreatment unit of call bill data provided by the invention comprises:
The expression formula editor module is used for the expression formula that initial data, normal data and result data according to ticket is provided with the preliminary treatment call bill data, and described expression formula is used to describe the rule of handling the ticket initial data;
The expression formula explanation module is used for that above-mentioned expression formula is construed to computer and can discerns the database that the expression formula of form stores computer into;
The expression formula Executive Module, be used for reading the initial data and the associated data of ticket from file or database, processing requirements according to call bill data, from database, call the expression formula that to discern form accordingly, the initial data of utilizing this expression formula to operate above-mentioned associated data and ticket generates the normal data of ticket, then normal data is carried out statistical disposition, result data is kept in the database.
Scheduler module is used to control the editor and the interpreter operation of expression formula editor module, expression formula explanation module, and the execution opportunity and the task classification of control expression formula Executive Module;
Database module is used for initial data, associated data and the result data of memory ticket and the expression formula that computer can be discerned form.
Said method or device are applicable to the preliminary treatment to a large amount of call bill datas of constant generation, through after handling, can reduce the data volume that ticket is handled effectively, give the utilization again of the call bill data condition of providing convenience; After the pretreated call bill data of process deposits database in, owing to can directly use pretreated call bill data, can greatly improve the efficient of database processing call bill data, in addition, because being provided with of expression formula is fairly simple, reduced the complexity of Operation and Maintenance when call bill data is handled.
Description of drawings
Fig. 1 is the embodiment flow chart of the method for the invention;
Fig. 2 is the embodiment block diagram of device of the present invention.
Embodiment
The present invention is described in further detail below in conjunction with accompanying drawing
Fig. 1 is the embodiment flow chart of the method for the invention.Implement the present invention according to Fig. 1, at first carry out the editor of expression formula in step 1, the expression formula of preliminary treatment call bill data just is set according to initial data, normal data and the result data of ticket, so that generate normal data and generate result data according to normal data according to initial data, this expression formula is used to describe the processing rule of ticket initial data.The expression formula of describing the call bill data processing rule meets common expression formula and constitutes requirement, can form by function, function parameter, operator, can nesting allocation between the function, function parameter can be table name word, field name of field name, the database of field name, the associated data of initial data etc., and operator comprises arithmetic operation, logical operation etc.Function comprises string operation function, Time of Day handling function, correlation inquiry function etc.For example in set following expression formula:
1+2*f1([abc]，24)％(3/(2+4))
F1 is a function name, and ([abc], 24) are the f1 function parameters.
When after step 1 sets up expression formula, above-mentioned expression formula is construed to computer in step 2 and can discerns in the memory that the expression formula of form stores computer into.It in this example the explanation of carrying out expression formula according to head sea blue formula rule.For example, above-mentioned expression formula is converted to following form: 1--＞2--＞[abc]--＞24--＞) through after explaining--＞(--＞f1--＞*--and＞3--＞2--＞4--＞+--＞)--＞(--＞/--＞)--＞(--＞%--＞+.Result with above-mentioned form is kept in the database then, uses during for execution.
Read the initial data and the associated data of ticket in step 3, processing requirements according to call bill data, from the memory of computer, call the expression formula that to discern form accordingly, the initial data of utilizing this expression formula to operate above-mentioned associated data and ticket generates the normal data of ticket, again according to processing requirements to normal data, from the database of computer, call the expression formula that to discern form accordingly, utilize this expression formula that normal data is added up, result data is saved in database.After, database just can utilize the above-mentioned data that deposit in, for example utilizes normal data and the statistics of normal data is carried out the secondary statistical disposition, perhaps directly utilizes the result who finishes by statistics, promptly can improve the database processing efficient of call bill data, reduce complexity.
In the aforesaid operations, the Original CDR data are CDR files, and each provisional capital is a message registration, all comprise the data that will resolve in each row.The Original CDR data exist with the form of file or the form of table, during processing file or table are read in the internal memory in batches and are handled.For example in the Original CDR data of following table, calling number is exactly the data that will resolve.
Calling number called number duration of call cost of the phone call
075512345678 01012345678 10 20
075512345679 01012345679 10 20
01012345678 075512345678 10 20
............ ......... ... ...
Associated data be resolve the ticket initial data according to data, for example the described domestic area code table of following table promptly is an associated data.Associated data exists with the form of file or table, and the content all associated datas during processing is once read in the internal memory.
Domestic area code city title
10 Beijing
755 Shenzhen
20 Guangzhou
21 Shanghai
... ......
Certainly, the city title is an option not necessarily in last table.
In the described embodiment of Fig. 1, after the setting of finishing expression formula in step 1,2 and explaining, when needs are handled the ticket initial data, processing requirements according to call bill data, from the database of computer, call the expression formula that to discern form accordingly, when expression formula is carried out, read in initial data and associated data, according to these data of logical process of expression formula, at last result is write in the normal data.If with initial data in the above-mentioned table and associated data is example, calling number in the initial data is resolved, be about to calling number and be split as two parts, the one, the caller area code, it is calling telephone number, formed normal data is with reference to following table, and wherein caller area code and calling telephone number are exactly through resolving the new data that the back forms.
Calling number called number duration of call cost of the phone call caller area code calling telephone number
075512345678 01012345678 10 20 755 12345678
075512345679 01012345679 10 20 755 12345679
01012345678 075512345678 10 20 10 12345678
But the recognition expression formula utilizes the initial data of associated data and ticket to generate the process of the normal data of ticket in above-mentioned steps 3, at first read in ticket initial data and associated data, from the ticket initial data, obtain the field value that to search then, the calling number field that promptly will resolve, preceding N bit data and associated data with this field value are done maximum coupling, utilize matching result to generate normal data at last.Suppose to describe by following expression in this example the calling number field of needed processing:
matchquerytable([tollareano]，[areano]＝＝substr([callingPartyNumber]，2，6)，[areano])
Wherein matchquerytable is maximum adaptation function, and [tollareano] is the associated data table, the title of promptly domestic area code table; [areano] is the field name that is used for doing coupling in the associated data table, refers to domestic area code field here; [callingPartyNumber] is the calling number in the initial data, substr ([callingPartyNumber], 2,6) the 2nd to the 6th of calling number got in expression, [areano]==substr ([callingPartyNumber], 2,6) indicate to use the 2nd to the 6th of [areano] field and calling number and do maximum coupling, the field that rearmost [areano] expression is returned is [areano].
The described implication of above-mentioned expression formula is: obtain the 2nd to the 6th content of calling number, do maximum coupling with the domestic area code in this content and the contingency table, return domestic area code after the coupling.So just obtained the domestic area code in the calling number.
The method of using maximum matching process of the present invention to separate area code and telephone number is as follows:
Set up a domestic area code table tollareano, this table has only a field areano, and field contents is domestic area code, and every record is an area code.For example:
10
755
20
21
...
Known situation is that in calling number, the shared figure place of area code is no more than 4, then obtain calling number preceding 4, for example the 2nd of " 075512345678 " the to the 6th is " 75512 ", does coupling with " 75512 " in the area code table, and whether check has identical area code.To suppose with data in the area code table be associated data does maximum coupling to the 2nd to the 6th of calling number " 075512345678 ", first pass is searched does not have that the match is successful, so the scope of " 75512 " is dwindled, remove last position " 2 ", only remaining " 7551 ", in the area code table, do coupling with " 7551 ", still can not find out, so remove of back again, only remaining " 755 ", this time found identical, so think that " 755 " are area codes." 01012345678 " the 2nd to the 6th is " 10123 ", and then in like manner, preceding do not search for twice found, so reduce the scope, when " 10 ", has just found, so think that 10 is area codes.
After finding area code, then except area code, rest parts is exactly a calling telephone number.The area code that parses and calling telephone number and initial data are combined the normal data that has promptly constituted in this example.Handle the Original CDR data according to this until finishing.
From the above, use the expression formula of can the composition function powerful processing call bill data of method of the present invention, in order to a large amount of call bill datas that continue to produce are handled, can obtain adding up the normal data of use, solved the efficiency of database processing call bill data.Therefore, can finish needed initial data analysis of user and statistics task, for example merging of the filtration of data, field, fractionation, summation, count, average, ask maximin etc. with the method for the invention.
The pretreatment unit of call bill data provided by the invention comprises: expression formula editor module 1, expression formula explanation module 2, expression formula Executive Module 3, scheduler module 4 and database module 5, wherein:
Expression formula editor module 1, the initial data, normal data and the result data that are used for according to ticket are provided with the expression formula of preliminary treatment call bill data, so that generate normal data and generate result data according to normal data according to initial data.Described expression formula is used to describe the rule of handling the ticket initial data, the editor that this module is finished expression formula by for example patterned interface of certain supplementary means.This module scheduler module 4 control under, with the expression formula that edits is similar arithmetic form, being not suitable for computer directly uses and moves, therefore need deliver to expression formula explanation module 2, be construed to computer with expression formula and can discern in the database that the expression formula of form stores computer into expression formula editor module 1 editor.The interpretative rule of this module application can have multiple, for example adopts the blue rule of head sea.Can directly call through the expression formula that expression formula explanation module 2 is explained, when the preliminary treatment of Original CDR data, by expression formula Executive Module 3, under the control of scheduler module 4, from database module 5, read the initial data and the associated data of ticket, processing requirements according to call bill data, from the memory of computer, call the expression formula that to discern form accordingly, the initial data of utilizing this expression formula to operate above-mentioned associated data and ticket generates the normal data of ticket, again according to processing requirements to normal data, from the database of computer, call the expression formula that to discern form accordingly, utilize this expression formula that normal data is added up, statistics is saved in database.
Database module 5, the initial data, associated data, result data and the computer that are respectively applied for memory ticket can be discerned primitive formula, and this module comprises raw data base 51, linked database 52, result database 53 and the expression formula database 54 of the initial data, associated data and the normal data that are respectively applied for memory ticket.
Claims (7)
1, a kind of preprocess method of call bill data comprises:
Step 1: the expression formula of preliminary treatment call bill data is set, and described expression formula is used to describe the rule of handling call bill data;
Step 2: above-mentioned expression formula is construed to computer can discerns the expression formula of form and store in the database;
Step 3: the initial data and the associated data that read ticket, processing requirements according to call bill data, call the expression formula that can discern form accordingly from database, the initial data of utilizing this expression formula to operate above-mentioned associated data and ticket generates the normal data of ticket.
2, the preprocess method of call bill data according to claim 1 is characterized in that, but the process that the recognition expression formula utilizes the initial data of associated data and ticket to generate the normal data of ticket in the step 3 is:
Step 31: read in ticket initial data and associated data;
Step 32: obtain the field value that to search, do maximum coupling, utilize matching result to generate normal data with the preceding N bit data and the associated data of this value.
3, the preprocess method of call bill data according to claim 1 and 2 is characterized in that, in step 2, the expression formula that step 1 is provided with becomes computer can discern the expression formula of form according to the blue formula interpretation of rules of head sea.
4, the preprocess method of call bill data according to claim 1 and 2, it is characterized in that, described step 3 also comprises: according to the processing requirements to normal data, from the database of computer, call the expression formula that to discern form accordingly, utilize this expression formula that normal data is added up, result data is saved in database.
5, the preprocess method of call bill data according to claim 3, it is characterized in that, described step 3 also comprises: according to the processing requirements to normal data, from the database of computer, call the expression formula that to discern form accordingly, utilize this expression formula that normal data is added up, result data is saved in database.
6, a kind of pretreatment unit of call bill data comprises:
The expression formula editor module is used for the expression formula that initial data, normal data and result data according to ticket is provided with the preliminary treatment call bill data, and described expression formula is used to describe the rule of handling the ticket initial data;
The expression formula explanation module is used for that above-mentioned expression formula is construed to computer and can discerns the database that the expression formula of form stores computer into;
The expression formula Executive Module, be used for reading the initial data and the associated data of ticket from file or database, processing requirements according to call bill data, from database, call the expression formula that to discern form accordingly, the initial data of utilizing this expression formula to operate above-mentioned associated data and ticket generates the normal data of ticket, then normal data is carried out statistical disposition, result data is kept in the database;
Scheduler module is used to control the editor and the interpreter operation of expression formula editor module, expression formula explanation module, and the execution opportunity and the task classification of control expression formula Executive Module;
Database module is used for initial data, associated data and the result data of memory ticket and the expression formula that computer can be discerned form.
7, the pretreatment unit of call bill data according to claim 6, it is characterized in that described database module comprises: the initial data, associated data, result data and the computer that are respectively applied for memory ticket can be discerned the raw data base of primitive formula, linked database, result database and expression formula database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031366325A CN100433774C (en) | 2003-05-21 | 2003-05-21 | Telephone bill data processing method and apparatus |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031366325A CN100433774C (en) | 2003-05-21 | 2003-05-21 | Telephone bill data processing method and apparatus |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1549574A CN1549574A (en) | 2004-11-24 |
| CN100433774C true CN100433774C (en) | 2008-11-12 |
Family
ID=34323404
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB031366325A Expired - Fee Related CN100433774C (en) | 2003-05-21 | 2003-05-21 | Telephone bill data processing method and apparatus |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100433774C (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1933512B (en) * | 2006-09-30 | 2011-01-05 | 华为技术有限公司 | Tollticket processing equipment and method |
| CN101150831B (en) * | 2007-10-24 | 2010-06-09 | 华为技术有限公司 | Network element data processing method and device |
| CN101925039A (en) * | 2010-08-09 | 2010-12-22 | 中兴通讯股份有限公司 | Prewarning method and device of billing ticket |
| CN102982495B (en) * | 2012-12-04 | 2015-09-23 | 深圳中兴网信科技有限公司 | Adaptive data processing equipment and data processing method |
| CN112217944B (en) * | 2020-10-09 | 2022-04-15 | 中国联合网络通信集团有限公司 | Online ticket processing method, device, equipment and storage medium |
| CN113490202A (en) * | 2021-07-23 | 2021-10-08 | 恒安嘉新（北京）科技股份公司 | Method and device for synthesizing voice call ticket, computer equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5621728A (en) * | 1994-09-12 | 1997-04-15 | Bell Atlantic Network Services, Inc. | Level 1 gateway controlling broadband communications for video dial tone networks |
| CN1267414A (en) * | 1997-07-14 | 2000-09-20 | 诺基亚网络有限公司 | Implementation of access service |
| CN1373586A (en) * | 2001-03-01 | 2002-10-09 | 深圳市中兴通讯股份有限公司 | Universal internetwork charge method |
-
2003
- 2003-05-21 CN CNB031366325A patent/CN100433774C/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5621728A (en) * | 1994-09-12 | 1997-04-15 | Bell Atlantic Network Services, Inc. | Level 1 gateway controlling broadband communications for video dial tone networks |
| CN1267414A (en) * | 1997-07-14 | 2000-09-20 | 诺基亚网络有限公司 | Implementation of access service |
| CN1373586A (en) * | 2001-03-01 | 2002-10-09 | 深圳市中兴通讯股份有限公司 | Universal internetwork charge method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1549574A (en) | 2004-11-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6636877B1 (en) | Method for analyzing the quality of telecommunications switch command tables | |
| CN1933512B (en) | Tollticket processing equipment and method | |
| CN101686488B (en) | Service processing method, processing system and work sheet processing device | |
| US6678370B1 (en) | Data extraction process | |
| CA2218076A1 (en) | Telephone bill analyzer-conditioning system | |
| CN101582079A (en) | Object query method and device | |
| CN100433774C (en) | Telephone bill data processing method and apparatus | |
| CN102438205B (en) | Method and system for pushing service based on action of mobile user | |
| CN101710320A (en) | Statistical index data processing method and device | |
| CN105976302A (en) | Configurable data comparing method and system | |
| CN102737022A (en) | Method and device for acquiring and searching relevant knowledge information | |
| CN110196898A (en) | The management method and system of call center's marketing data | |
| CN103150155A (en) | Data interception method and device | |
| CN100512458C (en) | Method for prior triggering of multi-service for mobile intelligent network | |
| CN101645072A (en) | Changed data extracting method realized by being based on Oracle CDC technique | |
| CN101957860A (en) | Method and device for releasing and searching information | |
| CN109918391B (en) | Streaming transaction processing method and system | |
| CN1567829A (en) | General purpose data file conversion method | |
| CN101098495A (en) | System and method for improving intelligent business on-line statistical task performance | |
| CN101556680A (en) | Method for reusing transaction information in character front end and character front-end system | |
| CN107784588A (en) | Insurance user information merging method and device | |
| CN102117277A (en) | Management system and method on file number and code | |
| CN107092607B (en) | Ticket storage method and device | |
| CN100388804C (en) | Method of digit-figure number matching | |
| CN1756172A (en) | Short message robot system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20081112 Termination date: 20200521 |