The Design And Realization Of Call Ticket Billing System Of Shandong Telecommunication Company

Along with the market environment changes rapidly and the competition Intensifies day by day, the Business Support System, is called BSS , has become the focal point of competition among telecommunication enterprise. From BOSS of China Mobile to CTG-BOSS of China Telecom, All telecommunication businesses are year by year enlarging the investment to the BSS. Telecom Ticket Billing System is a core subsystem of BSS, It takes the functions of checking and collecting the outlay which customers should pay when using the service provided by the telecom enterprise and it is the foundation of the other subsequence subsystems, such as the account subsystem, the statistical & inquiry subsystem, the payment subsystem and so on.With the telecom market tending towards the opening step by step, the competition among the telecom enterprises becomes more and more intense .The Telecom Ticket Billing subsystem also be proposed to a higher accuracy and a higher timely request. For instance: Some telecom enterprises give the user newest pledge: the call cost can be inquired real-time and will be compensated decuple if the fee is wrong.The Telecom Ticket Billing System can be divided into two primary parts: the picking module and the billing module.The picking module realizes the formatting to each kind of primitive data (mainly binary speech document), the error correction, obtains the standard text speech file that the billing module is to deal and to compute expense. Primitive data mainly is the different binary speech document ,Produced by many kinds of communication program controlled switch (for instance: HuaWei, Siemens EWSD, QingDao 3G TD-SCDMA net, Lucent 5ESS, Bell S1240) ,The document records calling phone number, called phone number, telephone conversation start time, duration, intrunks&outtrunks, call transfer and other correspondence information, Therefore regarding the different switch ,We need to write the different picking disposal procedure, and Finally realize that the picking daemon process automatically scan the assigned directory after started, and if the files conforming to the conditions are discovered under the directory, then the related picking process will be transferred and carried on to deal the files immediately, At last produces the standard text files for Billing modules.The Billing module deals the standard files formed by the picking module, Based on the tariff which already drew up to compute the expense, obtains all kinds of fee statements of each speech for the following account subsystem to further process. According to processing flow, The Billing module is allowed to divide into two parts: pretreatment and entering into the database. Pretreatment mainly costs the fee of the standard speech, Including: Counts speech pretreatment, the local speech pretreatment, the long-distance speech pretreatment.Entering into the database mainly transfers ORACLE sqlload utility to enter the expense statement into the database table, While entering into the database table, also can transfer the related database Stored Procedure to carry on further processing, Finally can provide the integrated expense statement for local network account system.Moreover, In the Billing module we added the procedure monitoring interface that the data enter into the storage in order to be convenient to use and monitor the procedure, as well as the J2EE frame was adopted for the ease query of the billed statement through providing the intuitionistic and flexible interface.Because the quantity of communication speech data is extremely huge, considering the actual production requests the procedure processing by high speed and high efficiency, our item takes the IBM machine ,UNTX operating system, ORACLE database as the system platform, uses the signal mechanism ,the multi-processes concurrent execution, with the C language, Embed SQL (ESQLC) realizes the above research content, Adopted the traditional waterfall model as the software developing method, We carried though requirement getting, requirement analysis and system design on the telecom billing system. Thereinto signal mechanism has also used to realize synchronization and incompatibility, used Balanced Binary Tree arithmetic to deal the repeat ticket, regarding the material data which used repeatedly many times has used the sharing memory technology, many processes use the physical memory section together in the identical time to realize data communication, greatly enhanced the system operating efficiency. The scheduler program reads the data from all material tables and writes them into the sharing physical memory section completely. The whole system has formidable function, high efficiency and high stabilization.We adopted the popular J2EE frame for the query module of the billed statement.The structure is composed by browser (IE), application server (Tomcat), backstage database (Oracle).The developing tool is Jbuilder X.After about one year sealed development, this Ticket Billing Subsystem now already adopted and used actually by the ShanDong Telecom Company and its city company, The practices, lasting more than half a year, proved definitely that the system could absolutely satisfy the service requirement of the telecommunication enterprise about accuracy and real time to pick the communication speech, to compute expense, to enter into storage, and reduced the billing cycle.What more delightful, the subsystem already was now designated as the original version for the 3G TD-SCDMA net testing platform in QingDao of the China Telecom Group.This article analyses the background, the domestic and foreign status of telecommunication Ticket Billing System, briefly recounted the main question that the system must be realized and solved, briefly recounted the whole system descriptions, and it elaborated requirement analyses and system architecture. It also elaborated how the system pivotal modules are designed and implemented.