Design And Development Of Anshan Local Network Telephone Bill Inquiry System

With the unceasing development for various new business and communication methods in recent years, charge item on the fixed phone has turned more diversified and detailed. Nowadays, a variety of charge problems have gradually become the focus of telephone subscribers and all social sectors. Depending on the charging statement of numerous services, complex types and different charge methods, the clarity of general expenses not only relates to the benefit of telephone subscribers but also the image and service level of telecom enterprises. As a result, we design Query System for Telephone Fee of Local Network. This system is allowed to provide inquiries to each detailed expense for subscribers and also carry on the inquiry, analysis and printing from different aspects according to their needs at the same time. Therefore it can provide charge inquiry to reduce every unnecessary kind of dispute over telephone expenses. Meanwhile, it can maintain good reputation of telecom enterprises and promote service level of telecom departments. Strengthening the credibility of telephone subscribers and all social sectors, this system helps to set up a good social image of telecom enterprises.According to every kind of business demand in the Query System for Telephone Fee of Local Network, the overall style of this new Query System for Telephone Fee of Local Network maintains to be consistent with "97 systems" and the realizes compatibly exchanges based on the design idea of "97 projects".In order to realize each business function, this system divides into the following several functional modules:The data inducts module: to induct charge information each month newly produces to the data sheet which the system needs, supplying the inquiry and printing use.The charge inquiry module: to inquire expense data each month produces according to the users' request and to provide the further detailed inquiry in its foundation.The printing module: to print fast the detailed list.The message charge inquiry module: mainly to provide the inquiry and the printing of the message charge.To guarantee the unit of data in the entire region, on the basis of business demand, this system generally plans the name and form of each charge item each month spends and establishes each corresponding kind of fees table. All users' charge data in the wholearea deposits in these fees tables according to these same forms. In order to protect the relative independence of the data simultaneously, the system establishes relative area marking to various local data. Thus, it concentrates the charge data of the entire region to complete the preparation process once, and also nimbly process the data from each place according to corresponding marking.Because the data quantity is huge, the Query System for Telephone Fee of Local Network uses the data which is separately deposit in a database and moreover separate from the database in Anshan district business system, Haicheng, Tai'an and Xiuyan. In order to fuses with the original "97" the system, we establish each data chain between the inquiry database with Anshan district business system, Haicheng, Tai'an and Xiuyan to achieve the long-distance visit to the database and realize the aims of inquiry and printing charge data after the system's register to every place.According to the design of the system, we need to establish the related database table to save the charge data. In view of the characteristic of huge fixed telephone user group and data quantity, considering saving the inquiry time and guaranteeing the data accuracy, we establish different forms of charge table according to the different inquiry of the data. The forms are mainly as follows: item expense table in view of each telephone number (Single expense table); Item expense table in view of each bureau account number each month produces (User expense table); the data sheet which memorizes the detailed recording of long-distance (Automatic long-distance telephone table); the data sheet which memorizes the detailed recording of message expense (Detailed list of specifications). These data sheets are for satisfying different inquiry request, which connect each other according to a certain field.Because of the extremely huge data of charging each month produces, the single expense table and the users expense table have achieved about 1 million along with the growth of user, meanwhile, the automatic long-distance telephone table reaches 5 much to 6 million, It needs very long time to search for or arrange the data in such great data quantity, this gives inconvenience to the inquiry and the printing. To improve the inquiry efficiency, we have established the index in view of several large data tables according to the commonly used retrieval field, this greatly sped up the inquiry and printing speed. For example, the single expense table and the automatic long-distance telephone table separately established index to the telephone number and bureau account number.Using the authorized mechanism to realize data access controland the safety control in ORACLE, it shows that the privilege only allow specially to be awarded to the user with privilege. In order to guarantee the security of the system, we establish special users in the database spending in the Query System for Telephone Fee, only can this user be allowed to carry on different kinds of operation such as increase, delete, change and so on. In the area of Anshan, not only Haicheng, Tai'an and Xiuyan has their own database, the Anshan district itself deposits the data of business system and Query System in separate database, however, users are unable to visit the charge database. In order to realize the security of resources sharing and the data safeguard, we award all users the privilege to inquiry each new data sheet.In order to achieve all design development goals of the system, the most important link is the design and compilation of the procedure code. This part costs quite a long time in the development and design of the Query System for Telephone Fee of Local Network, and has also met many difficulties in the programming process. But according to our analysis on the system's demand and earnest summary through the massive practices work, we have planned the overall system flow, and designed the concrete implementation plan on each step. After the careful discussion and analysis of each slight link, the compilation work of the procedure code carries on smoothly.In the procedure source code design of this system, we often use the method of downloading the system parameter. This can cause many procedures together to use the same parameter and also avoids the tedious operation and the artificial faults of inputting telephone number and bureau account number spending in the process of charge query. Increasing the working efficiency and accuracy, it also simplifies the operating process procedure of application.After finishing the compilation work of procedure source code, we use the black box to measure the procedure function of this system, according to the result of the test, we can discover the oversight and the mistake in the programming compilation process in order to achieve the function which the system requests to realize. Sometimes, the compilation procedure is unable to translate successfully, or has the discrepancy with the anticipated target in the test procession, we can use the method of transmitting "MESSAGE" in the procedure to debug procedure, discover the breakdown spot and revises the logical error, and recompiles the translation. After the test, this system has already achieved the demand, the main function has been realized as well.According to detailed analysis and introduction, this system issafe and reliable and carries artistic user surface, simple operation and comprehensive function, together with the good openness and probability, it also contains prominent promotion and usability.The Query System for Telephone Fee of Local Network performs stably and has a good effect since it comes into use. Solving the charging problems, it reduces various kinds of dispute over telephone expenses and protects benefit of general subscribers. In addition, it maintains a good image of telecom enterprises which sets up in the society and increases the transparency of charging. With the promotion of service level, it had obtained remarkable social efficiency. As a result, the system plays an important role in the telecom enterprises management now.