Chengdu Power Administration Marketing System Upgrade Program Design

In the voice of breaking the monopoly, the power companies bear the brunt of the media, the people focus of attention, how to adapt to a market economy, how to eliminate the public the wrong perception about power enterprises, quality service has become an important factor. Marketing system to connect customers and electricity as a carrier, an increasingly important role to ensure the system normal, stable and error-free run, become the most important issue.Chengdu Electric Power Bureau has more than 0.8 million users, and the high-speed growth momentum will be sustained over a long period. By 2012, the number of customers will reach more than 2.5million. In Sep. and Oct.2006, due to virus attacks to billing system, network instability, and business overstock caused by National Day vacation, the charging system worked extremely unstable, and a serious impact on customer service quality. So, It was very necessary to upgrade our marketing system immediately.In this thesis, first we make an in-depth analysis of existing problems in our business management and marketing billing charging system, includeing:tariff calculation speed is slow, switch to paid-up accounts receivable data block, and security vulnerabilities. Then, we analysised the potential bad consequences based on some relevant criteria, and defined the target of system upgrading clearly. The main work of this paper is as follows:(1) Designing a solution to improve the reliability of the database system.(2) Solving the problem of imbalance work loading among application server, database server.(3) Designing a charging solution with three ways, which include:banks, business offices and self-charging terminals charging.(4) Effectively strengthing security and stability of marketing system.(5) We redesign the network structure of the marketing system.(6) We design a solution to break the bottleneck in billing system at peak periods.