CN1300728C

CN1300728C - Segmented charging method

Info

Publication number: CN1300728C
Application number: CNB031048234A
Authority: CN
Inventors: 马云; 王友军
Original assignee: Huawei Technologies Co Ltd
Current assignee: Huawei Technologies Co Ltd
Priority date: 2003-02-20
Filing date: 2003-02-20
Publication date: 2007-02-14
Anticipated expiration: 2023-02-20
Also published as: CN1523519A

Abstract

The present invention provides a segmented charging method which comprises the following steps: a temporary database table is created, and the temporary database table comprises time information and rate information; the rate information of each time interval in the temporary database table is updated at real time by executing JOB operation of a database according to charging tactic data of a system; after a user's charging request message is received by the system, the rate information of the corresponding time interval in the temporary database table is queried according to the time information, and the user's expense information is calculated out. The present invention not only can carry out real-time charging, but also has the advantages that overall operating amounts are small, and simultaneously the change of database information can be fed back into the charging process at real time.

Description

The sectional type charging method

Technical field

The present invention relates to the charging method of communication field, refer to a kind of sectional type charging method especially.

Background technology

AAA (AAA is the abbreviation of authorizing (Authorization), authentication (Authentication) and charge (Accounting)) server is as access device (NAS, LAN Switch etc.) authentication, accounting server, the effect in the Internet networking plan is more and more important.Aaa server normally operational relation to the user whether can normally insert, charge information whether normal recordings etc. and user, the closely-related problem of supplier's interests, simultaneously, the calculated relationship of the functional expenses that the user uses is to supplier's vital interests, therefore, the accuracy of charging and rapidity are vital.

At present mainly be to use information in the reading database in internal memory to the billing operation of aaa server, the processing that using system multithreading, multi-process are chargeed, but the information that needs frequent reading database like this, and the changed information with database that can not be real-time feeds back in the internal memory.Therefore, can cause the performance of system significantly to descend, real-time than higher system on, can be a bottleneck.Simultaneously for the charging policy of complexity, as multiple preferential influencing each other, the intersection of multiple charging way all can have influence on the performance and the processing power of system.As in the prior art to charging event each time, accounting processing is by the rate information in the reading database, and preferential mode is carried out accounting processing, in computation process, need carry out the calculating of tariff discount, again the rate after the discount is carried out accounting processing, because middle result of calculation can't preserve, therefore for charging event each time, all need to carry out above-mentioned processing, like this, the calculated amount of system is quite big, and operation efficiency is very low.

Summary of the invention

In view of above-mentioned shortcoming of the prior art, the invention provides a kind of brand-new sectional type charging method.By the JOB that uses database to provide, the function of storing process, according to the charging policy of system change, the corresponding rate of real-time update day part can be accomplished computational costs real-time, quickly and accurately.

The inventive method comprises:

Create a volatile data base table, described volatile data base table includes temporal information and rate information;

According to the charging policy data of system, the storing process of periodically automatic runtime database, day part and corresponding rate information thereof in the described volatile data base table of real-time update;

Receiving the user when system charges behind the request message, according to this professional shared period of this user, inquire about the rate information of corresponding period in the described volatile data base table,, calculate this cost information of this user in conjunction with the duration/data on flows of this professional shared day part.

According to said method of the present invention, described temporal information comprises the in chronological sequence zero-time and the termination time of the corresponding different rates of order; Described rate information is the actual rate of the day part carrying out different different concessionary rates of period according to the charging policy of system and calculate.

According to said method of the present invention, reality is not carried out period of tariff discount, unifiedly carry out percent 0 concessionary rate calculating.

Described volatile data base table also comprises identifier information, gives different identifiers respectively corresponding to different charging type of offer.

The record that has identical identifier in the described volatile data base table, its corresponding time period is continuous.

When installing in system, creates by described volatile data base table.

The storing process of the automatic runtime database of described periodicity is for carrying out once at least every day.

The present invention not only can carry out real time billing, and compare, it is little to have an overall operand, simultaneously the little advantage of calculated amount each time, in the feedback charging process that simultaneously can the modification of database information is real-time, the server of charging is well utilized.

Description of drawings

Fig. 1 is the process flow diagram of the inventive method.

Embodiment

The present invention adopts a kind of brand-new sectional type charging method, and the JOB function that active bank provides realizes.Described JOB function is the function that oracle database provides, and other database also has identical functions, and title may be different, and JOB is meant that database supports storing process operation and need not user's intervention periodically automatically under the management of system; JOB among the Oracle can designated program at the appointed time move, and what support this timing operation function is the job sequence that bag DBMS_JOB provides; The operation of operation is to realize by the common submit job sequence of parameter with this operation and this job run mode of explanation among the Oracle.The present invention stores temporal information and rate information in this volatile data base table, in system's operational process in advance by creating a volatile data base table, carry out the JOB operation, according to the charging policy data, the rate information in this volatile data base table of real-time update is as preferential period rate etc.; As shown in Figure 1, receive the user when system and charge behind the request message, by inquiring about this volatile data base table, obtain the preferential rate of day part, read tariff data and charge, thereby need recomputate the calculated amount of discount rate when reducing each real time billing, increase the efficient of computing.The present invention can use dynamic load to handle, be that the user uses few time of portfolio in one day by detecting in system, carry out the JOB operation of database, in the not high period of cpu busy percentage, carry out the evaluation work of big data quantity, as carry out rate, preferential evaluation work, thereby the performance and the processing power of performance server can not occur peak value simultaneously and handle phenomenon.

For example: with common once conversation is example, data message that operator is provided with such as table one, table two:

Table one:

Destination address	Number head	Rate
Destination address	Number head	Rate	Beijing	10	0.4 unit/minute
The U.S., Canada	1	2.5 unit/minute	Beijing	10	0.4 unit/minute
The U.S., Canada	1	2.5 unit/minute	Abroad	0	4 yuan/minute

Table two:

Title	Sign	Type of offer	Zero-time	Termination time	Discount
Title	Sign	Type of offer	Zero-time	Termination time	Discount	No. 9 12 half prices in every month are preferential	1	Month	12:00:00 on the 9th	24:00:00 on the 9th	0.5
Every month No. 10 7 folding is preferential	1	Month	00:00:00 on the 10th	24:00:00 on the 10th	0.7	No. 9 12 half prices in every month are preferential	1	Month	12:00:00 on the 9th	24:00:00 on the 9th	0.5

Data message after the calculating such as following table three:

Sequence number

Sign

Preferential zero-time

The preferential termination time

Discount

1	1	2002-10-09	2002-10-09 12:00:00	1
1	1	2002-10-09	2002-10-09 12:00:00	1	2	1	2002-10-09 12:00:00	2002-10-10	0.5
3	1	2002-10-10	2002-10-11	0.7	2	1	2002-10-09 12:00:00	2002-10-10	0.5
3	1	2002-10-10	2002-10-11	0.7	4	1	2002-10-11	2002-10-12	1

For example: the user uses the making call U.S., zero-time is 2002-10-09 10:00:00, concluding time is 2002-10-11 1:00:00, all listed in the table three sections have promptly been used, therefore, at first calculate the expense of The initial segment, it is the item of sequence number 1 expression, time period is 2002-10-09 10:00:00～2002-10-0912:00:00, calculate the expense of concluding time section again, promptly sequence number 4 is represented item, and the time period is 2002-10-1100:00:00～2002-10-11 1:00:00, calculate the center section time period at last, promptly sequence number 2, the time period cost data of sequence number 3.The expense of each time period is the actual rate (rate when the actual rate of each preferential period equals without privileges multiply by the discount rate of each preferential period) of this time period correspondence and the product of duration; The expense summation of these three time periods is the total expenses of this time calling user.

Block meter rate method of the present invention is adapted to charge on traffic equally.As above example as long as multiply by the actual flow rate of day part with the data on flows of day part, can obtain the traffic fee usefulness of day part, and the expense summation of these three time periods is the total expenses of this time calling user.

Shown in the table three, be volatile data base table of the present invention, preserved the data such as rate information that calculate through after the JOB execution in this volatile data base table.This volatile data base table is created when system installs, corresponding identifier is different type of offer sign in the table, in the process of real time billing, because the preferential evaluation work of corresponding rate is complete, only need the tariff data information of the correspondence in the question blank to get final product, need all not carry out the preferential operation of primary charging, significantly reduce calculated amount for accounting processing each time.

In the system for the ease of handling, for any rate, be provided with preferential, for in fact unpreferential part, also unified be treated to 0% preferential so that unified processing, above JOB operation, but carry out once every day, and the data of the corresponding like-identified of Sheng Chenging are continuous on the time period simultaneously.

Claims

1, a kind of sectional type charging method comprises:

2, sectional type charging method as claimed in claim 1 is characterized in that: described temporal information comprises the in chronological sequence zero-time and the termination time of the corresponding different rates of order; Described rate information is the actual rate of the day part carrying out different different concessionary rates of period according to the charging policy of system and calculate.

3, sectional type charging method as claimed in claim 2 is characterized in that: reality is not carried out period of tariff discount, unifiedly carry out percent 0 concessionary rate calculating.

4, as claim 1,2 or 3 described sectional type charging methods, it is characterized in that: described volatile data base table also comprises identifier information, gives different identifiers respectively corresponding to different charging type of offer.

5, sectional type charging method as claimed in claim 4 is characterized in that: the record that has identical identifier in the described volatile data base table, its corresponding time period is continuous.

6, as claim 1,2 or 3 described sectional type charging methods, it is characterized in that: create when described volatile data base table is installed in system.

7, as claim 1,2 or 3 described sectional type charging methods, it is characterized in that: the storing process of the automatic runtime database of described periodicity, for carrying out once at least every day.