| The Customer Service System of Gas Company, in accordance with customer serviceregulations and based on the concept of workflow, facilitates system operation personnel to shareinformation in a convenient and speedy way and to cooperate effectively. The Customer ServiceSystem has achieved the workflow management of business and stipulated relatively stringentrequirements for the workflow and operating practices of all the businesses, striving to realizethe real-time input of all the businesses statistics and accurate business information, which haspromoted the management efficiency and service level of departments and has made refined andhumanized management come true.Recently, the accelerating proliferation of archived data and the construction characteristicsof the system itself have brought about the surprisingly low running speed of client side andfrequent time-out errors during data inquiring, which is extremely severe.After abundant user surveys within the company and the comprehensive analysis on theCustomer Service System, a proposal of establishing customer service system statisticsresembling data warehouse is come up with. The main operating practices are to detach thedatabase data applied by the normal running Customer Service System and preserve thenecessary basic statistics and current business statistics for the system running so as to guaranteethe system’s normal operating. Meanwhile, we should detach the historical data, import into thebackup database and then reestablish a data inquiring system of customer service in the backupdatabase.The data inquiring system of the Gas Customer Service employs the B/S mode which canbe accessed to the users by the browsers coming with the computer system and it is ofmagnificent convenience. This system is utilizing Struts+spring+hibernate (SSH) framework andthe three-tier architecture MVC, with the backend system applying SERVER database.This system is functionally divided into three modules as system setting module, datadetaching module and business inquiring module. The foundation of this system has established a historical data inquiring platform for development-oriented customer service system based onWEB and it is capable of supplying timely inquiring function of the Customer Service Systemdata for all the staff of the company. Thanks to this system, a timely good knowledge of thedetailed information, business progress of various businesses, historical data of variousbusinesses, analysis on the statistics and real-time supervision on the development of businessesis all available for all staff.The foundation of The data inquiring system of the Customer Service will not onlythoroughly work out problems existing in the current Customer Service System, but alsodramatically promote the management efficiency of each department relying on itscharacteristics of high efficiency and convenience, thus further regulating the timeliness andservice level of staff. |
