Data Warehouse Technology Research And Application Of The System Of Postal Financial Customers

Along with our country's macro-control, State Postal Bureau of China divides into national postal industry and postal enterprises management, further more, divides into the china postal bank and the postal enterprises management. China postal bank will face to more challenge and pressure. As a result, there are more sever problems occurred: how to grasp marketplace development, persuade the finance customer to stay effectively, deploy a channel rationally, escape risk accurately, sets up a product rationally and so on. On the other hand, in every service system, there are plenty of customer data, transaction information, channel information, which reflect the characteristics of postal saving business, and imply the present managing status and the market need, so that the managing rank of postal saving business can find out some useful information and then apply them into the enterprises managing and different service for the customers, then, they can have the right marketing actions, and improve the enterprises profit in the large scale. Base on these situations, the postal saving business bring out the idea of carrying out Chinese postal service finance customer system which regards the data base as a foundation. Combined with the real demand, this article studies the application of the data storehouse technology in Chinese postal service finance customer system. The research job in this article will be helpful to the data storehouse technology application in Chinese postal service finance customer system and can directly guide the carrying out of Chinese postal service finance customer system.This article firstly introduces the meaning of study the data accumulated in the informationization development and the technical background. Then, considering the business demand of the finance customer system, the data quality of the saving system and the data storehouse construction characteristic, this article mainly studies the overall frame design and model of finance customer system design, meanwhile, brings out the system frame, ELT designs, applies frame design and logic model and physics model etc. For insuring the success construction of the data storehouse and the high-efficiency of the data storehouse's application, based on the data storehouse's characteristics and properties, this article applies the logic data storehouse to the saving data in the physics equipment.This article mainly solve the following key problems: First, gives a nationally frame of national gathering finance customer system, based on which designs the logic system frame, physics system frame, application logic system etc. Second, based on the nationally frame, designs the mechanism of the ETL background data handling, which includes data handling technological process, data mass examination and system ETL school assignment classification etc. Third, studies the fore-end application nationally designation that contains the applicative logic structure and corresponding physics structure, meanwhile designs the function subsystem. Fourth, designs the logic data model according with system reality. Last, takes the related processing methods of improving the data storehouse quality into account.The system frame,, mechanism of the ETL background data processing, logic model , physics model , physics system frame , are already put in use in postal service finance customer management system (be called CPCIM for short). The success of Finance customer management system have forcefully driven the administrative informatization of Chinese postal service and provides the data for the managerial decision-making.