WO2011131060A1

WO2011131060A1 - Method and system for storing sorted call bills by catalog

Info

Publication number: WO2011131060A1
Application number: PCT/CN2011/071379
Authority: WO
Inventors: 王春; 洪君景; 孔鹏
Original assignee: 中兴通讯股份有限公司
Priority date: 2010-04-22
Filing date: 2011-02-28
Publication date: 2011-10-27
Also published as: CN101827175A

Abstract

The present invention provides a method and a system for storing sorted call bills by catalog, wherein the method includes the following steps: acquiring classification fields (201); reading the original call bill records, and sorting and processing the original call bill records (202); and in the process of sorting and processing the original call bill records one by one, judging the value of the classification field in each call bill record one record by one record, creating the classification catalog corresponding to the classification field value in real time, and storing the call bill records with the same classification field value into a corresponding classification catalog (203). The method and the system of this present invention for sorting and classifying call bills, can write the call bill records into the real-time created catalog in real time according to the fields of the call bill records, implement that the sorted call bill records are stored by classification according to a certain characteristic of the call bills, and meanwhile finish the classification process of the call bills when finishing the sorting process of the call bills, without secondary sorting and classification, and have the characteristics that the method is simple and the processing is high-efficiency.

Description

Method and system for storing single-sorting sub-directory storage

The present invention relates to bill sorting processing of a billing system for a communication service in the field of communication, and more particularly to a method and system for sub-directory storage of bill files after sorting according to characteristics of bills. Background technique

In the billing system of the communication network, for the sorted bills, different operational support systems have various requirements for these sorted bills, one of which is a special and meaningful function, which is to divide these points. After the CDR record is sorted, the same file is written according to certain conditions, and then classified and classified into a specific directory.

The sorted bill records are composed of a number of fields. According to certain conditions, the above refers to sorting into a file according to one or some of the field values, and then storing them in a specific file. Under the directory, all the CDR records in this directory meet the same conditions.

An existing sub-directory storage method is to first sort out the bills, and then perform secondary processing (sorting) on the sorted bills to achieve the purpose of sub-directories and classified storage. Such a processing method has a problem of inefficiency because the CDRs are all sorted out and then the second sorting process is performed. Therefore, how to set up a better method to dialogue single record for sub-directory storage, in order to achieve efficiency, has become a problem that technicians need to consider. Summary of the invention

The technical problem to be solved by the present invention is to provide a method and system for storing bills and sorting sub-directories, realizing the storage of bills and sub-directories, and achieving the purpose of improving processing efficiency.

In order to solve the above technical problem, the present invention provides a method for storing bill sorting sub-directories, including: Obtain a classification field;

Reading the original bill record and sorting the original bill record one by one;

In the process of processing the original bill record one by one, the value of each bill record classification field is judged one by one, the category catalog corresponding to the value of the category field is created in real time, and the bill record with the value of the same category field is stored. Go to the corresponding category directory.

Further, the realizing the categorization directory corresponding to the value of the categorization field, and storing the CDR record having the value of the same categorization field in the corresponding categorization directory, includes: determining, corresponding to the categorization field value Whether the catalogue exists;

When the category directory corresponding to the value of the category field exists, the bill record is stored in the corresponding category directory;

When the category directory corresponding to the value of the category field does not exist, a category directory corresponding to the value of the category field is created, and the bill record is stored in the corresponding category directory.

Further, the directory name of the category directory is a type of value corresponding to the category field in the bill record.

Further, the obtaining the classification field includes:

Obtain a stored pre-set categorical field.

Further, the classification directory has separate status records to ensure that the order number of the bills in each category directory is independent and continuous.

In order to solve the above technical problem, the present invention also provides a system for bill sorting sub-directory storage, including a bill sorting unit, configured to read the original bill record and sort the original bill records one by one, and further includes :

Get the unit, set to get the classification field;

The processing unit, configured to read the original bill record and sort the original bill records one by one, in the process of sorting the original bill records one by one, determining the value of each bill record classification field one by one, real time Creating a category directory corresponding to the value of the category field, which will have a phase The bill records of the same category field value are stored in the corresponding category directory.

Further, the processing unit is further configured to:

Determining whether a category directory corresponding to the value of the category field exists;

Further, the obtaining unit is further configured to obtain a stored pre-set classification field.

Further, the processing unit is further configured to make the category directory have a separate status record, so as to ensure that the order number of the bills in each category directory is independent and continuous.

The method and system for storing the bill sorting sub-directory of the present invention can be written into the real-time created catalog according to the field of the bill record in real time, and realize the bill record after sorting, according to a certain characteristic of the bill. As a classification storage, it has the characteristics of simple method and high efficiency. In the process of completing the bill sorting, that is, according to the category field, the bill catalogue corresponding to the category field value is created in real time, and when the bill sorting is completed, the sub-directory storage process of the bill is also completed, and Secondary sorting.

Moreover, since the classification field can be pre-set and stored, the classification field in the bill record can be configured according to actual needs, and is not limited to a certain field. DRAWINGS

1 is a frame diagram of a bill sorting system according to an embodiment of the present invention;

2 is a flowchart of a method for classifying bills according to an embodiment of the present invention;

FIG. 3 is a flowchart of detailed processing of an application example of the method according to an embodiment of the present invention. detailed description

The main idea of the present invention is: in the process of sorting the bill record, real-time creating a catalogue corresponding to the field value of the bill record, and using the field value of the bill record as a sorting condition, will have a certain or some The CDR records of the same field value are divided into one class and stored in the corresponding category directory. Therefore, compared with the prior art, the processing efficiency can be improved without using the secondary sorting method.

Specifically, first, the field condition of the bill sorting classification is determined, and the so-called bill sub-directory storage is classified according to different values of a certain field in the bill record, which may be referred to as a sort field Field, to classify the bill records. . Then, in the bill sorting process, when the original bill is sorted, the value of the category field Field in each bill record is judged, and is written into the bill file of the corresponding category, and the next bill record is divided into When sorting, if the Field value corresponds to other categories, it will be stored in the corresponding bill file of other categories. When a complete original bill file is sorted, all the bill records in it are sorted into the catalogues corresponding to different categories according to the different values of Filed, and the sorting of bills after sorting is completed. Store.

The classification field filed is configurable, that is, the classified rule field is changeable and is not fixed to a certain field.

For the classification field Filed, according to this field value, the vocabulary is classified, and the classified classification is generated in real time, and this classification is generated without pre-configuration.

The CDRs in each category have their own separate status records, record the file serial numbers of the CDRs in the categorization directory, generate flood periods, etc., to ensure that the CDR numbers in each category are contiguous.

The technical solution of the present invention will be further described in detail below with reference to the accompanying drawings and preferred embodiments.

FIG. 1 is a schematic diagram of a specific embodiment of a bill classification system according to the present invention. In Fig. 1, the classification system includes a bill sorting unit 11 for reading the original bill record and sorting the original bill by item. The initial bill record also includes:

The obtaining unit 10 is configured to obtain a classification field;

The processing unit 12 is configured to determine the value of each CDR record classification field one by one in the process of processing the original CDR record one by one, and create a categorization directory corresponding to the categorical field value in real time, which will have the same categorical field value. The bill records are stored in the corresponding category directory.

In a preferred embodiment of the system of the present invention, the processing unit 12 is further configured to: determine whether a category directory corresponding to the category field value exists;

When the category directory corresponding to the category field value exists, the bill record is stored in the corresponding category directory;

When the category directory corresponding to the category field value does not exist, a category directory corresponding to the category field value is created, and the bill record is stored in the corresponding category directory.

The directory name of the category directory is a type of value corresponding to the category field in the bill record. Of course, the directory name of the category directory may also use other naming rules, which is not limited in the present invention.

In a preferred embodiment of the system of the present invention, the obtaining unit 10 is further configured to obtain a stored predetermined classification field.

The processing unit 12 is further configured to have separate status records in the category directory, so as to ensure that the order numbers of the bills in each category are independently and continuously.

Based on the above modules, the present invention can realize that the CDRs can be stored in multiple categories after sorting, and the catalogues are all created in real time. It is not known in advance how many catalogs are in existence, and the catalogue is dynamically determined in the sorting process.

FIG. 2 is a flowchart of a method for classifying a bill according to the present invention. The method flow includes the following steps:

Step 201: Obtain a classification field.

Step 202: Read the original bill record and sort the original bill record one by one. Step 203: In the process of processing the original bill record one by one, the value of each bill record classification field is judged one by one, the category catalog corresponding to the category field value is created in real time, and the bill record with the same category field value is recorded. Stored in the corresponding category directory.

In a preferred embodiment of the method of the present invention, the categorization directory corresponding to the categorical field value is created in real time, and the CDR record having the same categorical field value is stored in the corresponding categorization directory, including:

Determining whether a category directory corresponding to the category field value exists;

In a preferred embodiment of the method of the present invention, the obtaining the classification field comprises: obtaining the stored preset classification field.

The category directory has separate status records to ensure that the order numbers of the bills in each category are independently and continuously.

Based on the above method, the present invention can realize that the CDRs can be stored in multiple categories after sorting, and the catalogues are all created in real time. It is not known in advance how many catalogs are in existence, and the catalogue is dynamically determined in the sorting process.

The application example shown in FIG. 3 is used to illustrate the method of the present invention. The process of the application example includes the following steps:

Step 301: The sorting program starts.

Step 302: Read in the category field Field, such as a service provider (SP) in the bill The system name SP-SYSID of the service, when the subsequent sorting process processes an original bill record, the SP name according to the bill (that is, the bill belongs to the SP) is classified into the corresponding category.

Step 303: The program reads in an original bill record.

Step 304: According to the sorted bill format, form a sorted bill record, and find the SP_SYSID value in the original bill record belongs to the interworking gateway, SP_SYSID=GW.

Step 305: Determine whether the interworking gateway GW classification directory exists. If yes, execute step 307. Otherwise, go to step 306.

Step 306: Create a corresponding directory immediately, and go to step 307.

Step 307: Write the CDR that belongs to the GW into the CDR file in the GW classification directory.

Step 308: Determine whether an original bill file is processed, and if yes, perform steps

309, otherwise, go to step 303.

Step 309: - The original bill is sorted into N different directories, and the current process is ended. In this way, after the original bill file is sorted, the sort result files are sorted and stored in different categories.

For example, the original bill to be sorted, the sorted bill format is:

CDR type I CDR water number I calling number I called number I ... ... SP type I ... I message identification for such CDR records, need to be written to the CDR file , generally all files are placed in a category directory.

Now, select the SP type field as the classification field. For each of the above records, write to different categories according to the SP type value. The classification name is the SP type value.

SP_type value possible values: PPS, OCS, PDSCP (-name identification of some SPs), in the bill sorting process, when processing the order record of SP type=PPS, create a classification directory PPS, and then This record is written in the bill file under the PPS category directory, and the others are similar.

Therefore, after the above processing, the final sorting order is written to PPS, OCS, PDSCP and other such categories. As for how many classifications there are, this does not need to be preset, and it depends entirely on the SP type value in the bill sorting process.

Similarly, you can select the "Bill Type" field as the categorical field to sort the CDRs based on the value of the CDR type.

It should be noted that the above description is only a preferred embodiment of the present invention, and is not intended to limit the technical solution of the present invention. Any equivalent replacement or corresponding improvement made by those skilled in the art to the technical features of the present invention is still in the present invention. Within the scope of the protection, the patent protection scope of the invention shall be determined by the appended claims.

Claims

Claim

A method for storing bills by sub-directory, the method comprising:

Obtain a classification field;

The method according to claim 1, wherein the real-time creation of a classification directory corresponding to the value of the classification field, and the bill record having the same classification field value are stored in the corresponding classification directory, Includes:

The method according to claim 1 or 2, wherein the directory name of the category directory is a type of value corresponding to the category field in the bill record.

The method according to claim 1 or 2, wherein the obtaining the classification field comprises:

Obtain a stored pre-set categorical field.

The method according to claim 1 or 2, wherein the classification directory has a separate status record, so that the order number of the bills in each category directory is independently continuous.

6. A system for sorting and sorting sub-directories, wherein the system includes a bill sorting unit configured to read the original bill record and sort the original bill records one by one, the system further comprising: an acquiring unit , set to get the classification field; The processing unit, configured to read the original bill record and sort the original bill records one by one, in the process of sorting the original bill records one by one, determining the value of each bill record classification field one by one, real time A category directory corresponding to the value of the category field is created, and a bill record having the value of the same category field is stored in the corresponding category directory.

The system according to claim 6, wherein the processing unit is further configured to:

The system according to claim 6 or 7, wherein the directory name of the category directory is a type of value corresponding to the category field in the bill record.

9. System according to claim 6 or 7, characterized in that the acquisition unit is further arranged to obtain a stored pre-set classification field.

The system according to claim 6 or 7, wherein the processing unit is further configured to make the category directory have separate status records, so that the order numbers of the bills in each category are independently and continuously.