CN1885888A - Call ticket sorting method and system - Google Patents
Call ticket sorting method and system Download PDFInfo
- Publication number
- CN1885888A CN1885888A CN 200610036338 CN200610036338A CN1885888A CN 1885888 A CN1885888 A CN 1885888A CN 200610036338 CN200610036338 CN 200610036338 CN 200610036338 A CN200610036338 A CN 200610036338A CN 1885888 A CN1885888 A CN 1885888A
- Authority
- CN
- China
- Prior art keywords
- sorting
- ticket
- ticket field
- letter sorting
- billing
- 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.)
- Pending
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The disclosed calling-menu sorting method comprises: pre-configuring and storing the corresponding menu format name and field logic composite relation for every sorting; when sorting, acquiring the menu format name and logic composite relation, and sorting as the pre-set name and relation. This invention has well flexible to adjust the logic relation without rewriting.
Description
Technical field
The present invention relates to the ticket treatment technology, in particular, the present invention relates to a kind of call ticket sorting method and system.
Background technology
At field of telecommunications, exchange opportunity is exported different tickets according to the service difference that provides to the user, and for example the ticket that may export has user start ticket, user terminate ticket, preceding transfer list etc.These tickets generally all at first need to sort, and just can carry out next step processing then, as the merging of partial CDR, format conversion, warehouse-in, wholesale price etc., finally form user's bill.When carrying out CDR sorting, often need to judge according to certain field in the ticket or the logical combination of several fields, promptly carry out the extraction of ticket field and carry out logic determines.For example, sorting the ticket that can realize different districts and cities by the caller area code is stored in and is convenient in the different catalogues that each city charges separately and the combining of centralized charging; Can realize the message registration between the difference net is stored in the different directories by relaying or the calling and called prefix letter sorting of coming in and going out, be convenient to carry out inter-network settlement.In addition, the virtual operation of day by day rising has also proposed more requirement to CDR sorting.Traditional implementation method is to write extraction and the logic determines that code is realized the ticket field according to concrete ticket field domain, but for new CDR sorting demand, when needs are adjusted these fields and logical combination thereof and are concerned, then must write code again, and compile again, debugging etc. could satisfy new CDR sorting demand, efficient is low and easily make mistakes, and therefore, tradition realizes that the method flexibility of CDR sorting is not high.
Summary of the invention
The technical problem that the present invention solves provides a kind of call ticket sorting method and system, only needing to realize the logical combination relation of configuration ticket field, just can realize CDR sorting, when new CDR sorting demand, can adjust the logical combination relation of the ticket field of letter sorting flexibly, and then realize CDR sorting flexibly, and need not to write again code.
For addressing the above problem, call ticket sorting method of the present invention is applied to dispose the system that each letter sorting flows to corresponding format of billing title and ticket field logical combination relation, comprising:
A, the format of billing title that respectively sorts flow direction correspondence of obtaining described configuration and ticket field logical combination relation;
B, flow to corresponding format of billing title and ticket field logical combination relation is carried out the CDR sorting that each letter sorting flows to according to each letter sorting of described configuration.
Wherein, step b specifically comprises:
B1, flow to corresponding format of billing title according to each letter sorting and determine corresponding call bill data;
B2, flow to corresponding ticket field logical combination relation according to this letter sorting and determine the byte location of each ticket field in call bill data;
B3, from described call bill data the data of the corresponding ticket field of letter sorting.
Wherein, described ticket field comprises: the length in Domain Index, domain name, data type and territory, determine among the step b2 that the ticket field is definite according to the length in Domain Index, data type and the territory of this field at the byte location of call bill data.
Wherein, described data type comprises: binary-coded decimal, nybble have symbol integer, character, character string type, time type and a byte unsigned int.
Wherein, the logical combination of described interfield relation is according to following sequencing priority of disposing order just:
Logic NOT; Less than; Be less than or equal to; Greater than; Be greater than or equal to; Equal; Be not equal to; Logical AND; Logic OR.
Correspondingly, a kind of CDR sorting of the present invention system comprises:
Memory cell is used to store each pre-configured letter sorting and flows to corresponding format of billing title and ticket field logical combination relation;
Acquiring unit, during CDR sorting, each letter sorting of obtaining described configuration flows to corresponding format of billing title and ticket field logical combination relation;
The letter sorting unit carries out respectively sorting the CDR sorting that flows to according to format of billing title and ticket field logical combination relation that respectively sorting of described configuration flows to correspondence.
Wherein, described letter sorting unit specifically comprises:
The call bill data determining unit is used for flowing to corresponding format of billing title according to each letter sorting and determines corresponding call bill data;
Ticket field location determining unit is used for flowing to corresponding ticket field logical combination relation according to this letter sorting and determines the byte location of each ticket field at described definite call bill data;
The letter sorting processing unit is used for according to the byte location of described definite each the ticket field data from the corresponding ticket field of described call bill data letter sorting.
Wherein, described ticket field comprises attribute: the length in Domain Index, domain name, data type and territory, described ticket field location determining unit is determined the byte location of ticket field at call bill data according to the length in Domain Index, data type and the territory of ticket field.
Wherein, described data type comprises: binary-coded decimal, nybble have symbol integer, character, character string type, time type and a byte unsigned int.
Wherein, the logical combination of described interfield relation is according to following sequencing priority of disposing order just:
Logic NOT; Less than; Be less than or equal to; Greater than; Be greater than or equal to; Equal; Be not equal to; Logical AND; Logic OR.
Compared with prior art, the present invention has following beneficial effect:
The present invention concerns by format of billing title and the ticket field logical combination that pre-configured and each letter sorting of preservation flow to correspondence; During CDR sorting, each letter sorting of obtaining described configuration flows to corresponding format of billing title and ticket field logical combination relation; Concern the CDR sorting that carries out each letter sorting flow direction according to each letter sorting flow direction of described configuration corresponding format of billing title and ticket field logical combination then.Among the present invention for the letter sorting demand of most of ticket, by the easy configuration that each letter sorting is flowed to, can satisfy to fast and reliable, for new CDR sorting demand, when a kind of concrete format of billing or format of billing for example occurring and being adjusted, only need to revise configuration data, and need not the letter sorting that recompile just can be realized ticket, and configuration is simple, requires very low to operating personnel.
Description of drawings
Fig. 1 is a CDR sorting principle schematic of the present invention;
Fig. 2 is the main flow chart of ticket branch of the present invention with method;
Fig. 3 is the composition schematic diagram of CDR sorting of the present invention system.
Embodiment
Core of the present invention is to be configured according to the letter sorting flow direction, wherein each letter sorting flows to according to the format of billing of its letter sorting correspondence and the logical combination of ticket field and concerns configuration data, pass through simple configuration, can realize most CDR sorting demand, and need not recompile, obtain the corresponding configuration data according to each flow direction during CDR sorting, and then carry out CDR sorting according to the format of billing of configuration data configuration and the logical combination relation of ticket field, when field that flows to when certain letter sorting of needs adjustment among the present invention and logical combination thereof concern, only needing to adjust corresponding configuration data gets final product, need not recompile, describe in detail below.
With reference to figure 1, this figure is a CDR sorting principle schematic of the present invention.
There is multiple ticket in the practical application, these tickets will be sorted into each flow direction, letter sorting flows to and is called " passage " among the present invention, and promptly " passage " represents the later ownership/flow direction of CDR sorting, and different passages adheres to different charge accounting centers usually separately or is used for the charging purposes of Different Rule.For various tickets, thus can be by its form unique identification of definition; " passage " then is the logical combination relation by field, and the title of corresponding format of billing, thus unique identification.As shown in Figure 1, when carrying out CDR sorting, identification field logical combination relation, format of billing according to each " passage " just can arrive each passage with CDR sorting, thereby finish letter sorting.
The ticket field logical combination relation and corresponding format of billing title that how to define under format of billing, " passage " are described respectively below:
I. each field domain of format of billing can define with the base attribute in the following table one:
Table one
| Sequence number | Attribute | The attribute implication |
| 1 | Domain Index | Each territory is by its sequencing that occurs in data structure, from 0 open numbering. |
| 2 | Domain name | The title in each territory, for example " calling number ", " called number ", " duration of call " etc. |
| 3 | Data type | The data type in this territory, for example date type, time type, integer, character string type, character type, binary-coded decimal, bit field type etc. |
| 4 | The length in territory | The length in this territory. |
For each format of billing, just can uniquely define among the present invention by a bivariate table, the attribute of classifying the ticket field domain that provides in the above table as of bivariate table, each row of bivariate table then defines a ticket field domain of this format of billing.Therefore, according to " Domain Index ", " data type " and " length in territory " these three attributes, can determine the definite byte location of a territory in a kind of data format." data type " can be defined as follows severally at least among the present invention, can progressively expand as required later on:
1) BCD binary coded decimal coding (Binary-Coded Decimal, binary-coded decimal)
2) the INT nybble has the symbol integer
3) CHAR character type
4) STRING character string type
6) TIME time type
7) BYTE one byte unsigned int
The following describes ticket field logical combination relation and corresponding format of billing title under " passage ":
Need to dispose ticket field logical combination relation and corresponding format of billing title under each " passage ".The format of billing name is called a character string, and ticket field logical combination relation can be defined as follows several, if can arrange as follows from high to low according to priority:
"! ": presentation logic is non-
"＜": the expression less than
"＜=": expression is less than or equal to
"＞": the expression greater than
"＞=": expression is greater than or equal to
"==": expression equals
"!=": expression is not equal to
“ ﹠amp; ﹠amp; ": presentation logic with
" || ": presentation logic or
In addition, the letter sorting conditional expression is also supported some special processings to field, for example sorts conditional expression:
" prefix (caller, 3)=139 ": if the front three of caller (host number) value of expression ticket is 139, then this conditional expression is judged as very.
Specify call ticket sorting method of the present invention below, with reference to figure 2, this figure is the main flow chart of call ticket sorting method of the present invention, specifically comprises the steps:
Step s11, format of billing title and ticket field logical combination that pre-configured and each letter sorting of preservation flows to correspondence concern, during specific implementation, promptly according to the format of billing of above-mentioned definition and the logical combination relation of ticket field each " passage " is configured according to actual needs, preserves configuration data then.
Step s12, during CDR sorting, each letter sorting of obtaining described configuration flows to corresponding format of billing title and ticket field logical combination relation;
Step s13, format of billing title and the ticket field logical combination corresponding according to each letter sorting flow direction of described configuration concern the CDR sorting that carries out each letter sorting flow direction, during specific implementation, at first flow to corresponding format of billing title and determine corresponding call bill data according to each letter sorting; Flow to corresponding ticket field logical combination relation according to this letter sorting then and determine the byte location of each ticket field in call bill data; From described call bill data, sort the data of corresponding ticket field at last.
The following describes another aspect of the present invention.
With reference to figure 3, this figure is the composition schematic diagram of CDR sorting of the present invention system, mainly comprises:
Memory cell 11 is used to store each pre-configured letter sorting and flows to corresponding format of billing title and ticket field logical combination relation, and concrete ticket field attribute and ticket field logical combination relation can repeat no more here with reference to above stated specification.
Acquiring unit 12, during CDR sorting, each letter sorting of obtaining described configuration flows to corresponding format of billing title and ticket field logical combination relation;
Letter sorting unit 13 carries out respectively sorting the CDR sorting that flows to according to format of billing title and ticket field logical combination relation that respectively sorting of described configuration flows to correspondence, and as a kind of concrete realization, described letter sorting unit specifically comprises:
The call bill data determining unit is used for flowing to corresponding format of billing title according to each letter sorting and determines corresponding call bill data;
Ticket field location determining unit is used for flowing to corresponding ticket field logical combination relation according to this letter sorting and determines the byte location of each ticket field at affiliated definite call bill data;
The letter sorting processing unit is used for according to the byte location of the described definite ticket field data from the corresponding ticket field of described call bill data letter sorting.
Describe call ticket sorting method of the present invention in detail with concrete CDR sorting below, for example, if need ticket as follows is sorted according to the ticket type, and the CDR sorting of the overlength of will conversing (surpassing 3600 seconds, promptly 1 hour) comes out:
struct CDR_A
{
INT csn; // ticket serial number, integer
/ * cdrType territory is the ticket type
* 1: expression MOC (Mobile Originated Call calls out the ticket that starts)
* 2: expression MTC (Mobile Terminated Call, call ending ticket)
* 3: expression FWC (Forward Call, preceding transfer list)
*/
BYTE cdrType
BCD caller[12]; // calling number, binary-coded decimal
BCD called[12]; // called number, binary-coded decimal
BCD thirdPaty[12]; // third party number, binary-coded decimal
BYTE year; // conversation the time, a byte unsigned int
BYTE month; // call starting month, a byte unsigned int
BYTE day; // call starting day, a byte unsigned int
BYTE hour; During // call starting, a byte unsigned int
BYTE minute; // call starting branch, a byte unsigned int
BYTE second; // call starting second, a byte unsigned int
INT duration; // the duration of call, integer
CHAR callType[10]; // type of call, character string
}；
Then the format description of described CDR_A can define as table two:
Table two
| Domain Index | Domain name | Data type | Length of field |
| 0 | csn | INT | 1 |
| 1 | cdrType | BYTE | 1 |
| 2 | caller | BCD | 12 |
| 3 | called | BCD | 12 |
| 4 | thirdParty | BCD | 12 |
| 5 | year | BYTE | 1 |
| 6 | month | BYTE | 1 |
| 7 | day | BYTE | 1 |
| 8 | hour | BYTE | 1 |
| 9 | minute | BYTE | 1 |
| 10 | second | BYTE | 1 |
| 11 | time | TIME | 1 |
| 12 | duration | INT | 1 |
| 13 | callType | INT | 1 |
Each letter sorting flows to promptly, and " passage " can dispose as table three:
Table three
| Passage | The format of billing title | Ticket field logical combination |
| Passage 1 | CDR_A | cdrType＝＝1&&duration＜3600 |
| Passage 2 | CDR_A | cdrType＝＝2&&duration＜3600 |
| Passage 3 | CDR_A | cdrType＝＝3&&duration＜3600 |
| Passage 4 | CDR_A | (cdrType＝＝1||cdrType＝＝2||cdrType＝ ＝3)&&duration＞＝3600 |
When specifically carrying out CDR sorting, obtain the configuration data of each passage, carry out logic determines according to the format of billing title and the ticket field logical combination relation dialogue individual character section of each channel arrangement data configuration then, finally finish CDR sorting.
The above only is a preferred implementation of the present invention; should be pointed out that for those skilled in the art, under the prerequisite that does not break away from the principle of the invention; can also make some improvements and modifications, these improvements and modifications also should be considered as protection scope of the present invention.
Claims (10)
1, a kind of CDR sorting system is characterized in that, comprising:
Memory cell is used to store each pre-configured letter sorting and flows to corresponding format of billing title and ticket field logical combination relation;
Acquiring unit, during CDR sorting, each letter sorting of obtaining described configuration flows to corresponding format of billing title and ticket field logical combination relation;
The letter sorting unit carries out respectively sorting the CDR sorting that flows to according to format of billing title and ticket field logical combination relation that respectively sorting of described configuration flows to correspondence.
2, CDR sorting according to claim 1 system is characterized in that described letter sorting unit specifically comprises:
The call bill data determining unit is used for flowing to corresponding format of billing title according to each letter sorting and determines corresponding call bill data;
Ticket field location determining unit is used for flowing to corresponding ticket field logical combination relation according to this letter sorting and determines the byte location of each ticket field at described definite call bill data;
The letter sorting processing unit is used for according to the byte location of described definite each the ticket field data from the corresponding ticket field of described call bill data letter sorting.
3, CDR sorting according to claim 1 and 2 system, it is characterized in that, described ticket field comprises attribute: the length in Domain Index, domain name, data type and territory, described ticket field location determining unit is determined the byte location of ticket field at call bill data according to the length in Domain Index, data type and the territory of ticket field.
4, CDR sorting according to claim 3 system, it is characterized in that described data type comprises: binary coded decimal coding, nybble have symbol integer, character, character string type, time type and a byte unsigned int.
5, CDR sorting according to claim 4 system is characterized in that, the logical combination relation of described interfield is according to following sequencing priority of disposing order height:
Logic NOT; Less than; Be less than or equal to; Greater than; Be greater than or equal to; Equal; Be not equal to; Logical AND; Logic OR.
6, a kind of call ticket sorting method is applied to dispose the system that each letter sorting flows to corresponding format of billing title and ticket field logical combination relation, it is characterized in that, comprising:
A, the format of billing title that respectively sorts flow direction correspondence of obtaining described configuration and ticket field logical combination relation;
B, flow to corresponding format of billing title and ticket field logical combination relation is carried out the CDR sorting that each letter sorting flows to according to each letter sorting of described configuration.
7, call ticket sorting method according to claim 6 is characterized in that, step b specifically comprises:
B1, flow to corresponding format of billing title according to each letter sorting and determine corresponding call bill data;
B2, flow to corresponding ticket field logical combination relation according to this letter sorting and determine the byte location of each ticket field in call bill data;
B3, from described call bill data the data of the corresponding ticket field of letter sorting.
8, according to claim 6 or 7 described call ticket sorting methods, it is characterized in that, described ticket field comprises: the length in Domain Index, domain name, data type and territory, determine among the step b2 that the ticket field is definite according to the length in Domain Index, data type and the territory of this field at the byte location of call bill data.
9, call ticket sorting method according to claim 8 is characterized in that, described data type comprises: binary coded decimal coding, nybble have symbol integer, character, character string type, time type and a byte unsigned int.
10, call ticket sorting method according to claim 9 is characterized in that, the logical combination of described interfield concerns according to following sequencing priority of disposing order height:
Logic NOT; Less than; Be less than or equal to; Greater than; Be greater than or equal to; Equal; Be not equal to; Logical AND; Logic OR.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610036338 CN1885888A (en) | 2006-07-04 | 2006-07-04 | Call ticket sorting method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610036338 CN1885888A (en) | 2006-07-04 | 2006-07-04 | Call ticket sorting method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1885888A true CN1885888A (en) | 2006-12-27 |
Family
ID=37583857
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200610036338 Pending CN1885888A (en) | 2006-07-04 | 2006-07-04 | Call ticket sorting method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1885888A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101404693B (en) * | 2008-11-05 | 2011-05-11 | 中国移动通信集团江苏有限公司 | Method and system for fast positioning, downloading and efficiently sorting call bill |
| CN101247434B (en) * | 2007-02-16 | 2012-07-11 | 中兴通讯股份有限公司 | Traffic analyzing method and system |
| CN101751397B (en) * | 2008-12-04 | 2013-03-27 | 中国移动通信集团安徽有限公司 | Method and device for importing files into database |
| CN103570498A (en) * | 2013-08-06 | 2014-02-12 | 江苏大学 | Method of preparing dichloropropanol by glycerol chlorination |
-
2006
- 2006-07-04 CN CN 200610036338 patent/CN1885888A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101247434B (en) * | 2007-02-16 | 2012-07-11 | 中兴通讯股份有限公司 | Traffic analyzing method and system |
| CN101404693B (en) * | 2008-11-05 | 2011-05-11 | 中国移动通信集团江苏有限公司 | Method and system for fast positioning, downloading and efficiently sorting call bill |
| CN101751397B (en) * | 2008-12-04 | 2013-03-27 | 中国移动通信集团安徽有限公司 | Method and device for importing files into database |
| CN103570498A (en) * | 2013-08-06 | 2014-02-12 | 江苏大学 | Method of preparing dichloropropanol by glycerol chlorination |
| CN103570498B (en) * | 2013-08-06 | 2016-06-22 | 江苏大学 | A kind of glycerin chlorination prepares the method for dichlorohydrin |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1567818A (en) | A content charging method of data service and charging system thereof | |
| CN1885888A (en) | Call ticket sorting method and system | |
| CN100340093C (en) | Speech sound business real time recording and analysis system and its method | |
| CN1959712A (en) | Method and system for automatic fabricating commerce letters according to mailing address field | |
| CN101076055A (en) | Method for converting toll-ticket format | |
| CN101046824A (en) | Data association method based on unlinear report generation method | |
| CN1809186A (en) | Method of deleting short messages in mobile communication terminal | |
| CN1492359A (en) | Automatic state machine searching and matching method of multiple key words | |
| CN1744646A (en) | System and method for providing charging payment business in telecommunication network | |
| CN1674517A (en) | Method and apparatus for realizing charge metering | |
| CN1334512A (en) | Stack-type register stack and its control method | |
| CN1790996A (en) | General charging method and method for realizing general charging model | |
| CN1859268A (en) | Method and system for backward-forward analytic message at background | |
| CN1859536A (en) | Telecommunication service classification charging method and system | |
| CN1355647A (en) | Universal fee-counting method for telecommunication services | |
| CN1549574A (en) | Telephone bill data processing method and apparatus | |
| CN1741558A (en) | Method for metering call charge | |
| CN101075264A (en) | Method and device for displaying UNIX/LINUX character terminal file | |
| CN1567821A (en) | Call ticket repetition removing method | |
| CN1145898C (en) | Extensible multi-language character display method | |
| CN1254070C (en) | Method of realizing statistical analysis of group rate adapting signal | |
| CN1383285A (en) | Cyclic redundancy check method for parallel data | |
| CN100346390C (en) | Method for compiling variable voice signal | |
| CN1067783C (en) | Transfering generation tech. based on Sc grammar | |
| CN1867130A (en) | Method for short message transmitting user information and mobile terminal |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20061227 |