数据仓库技术在邮政金融客户系统中的研究与应用

【作者】 李昱；

【导师】 范明；

【作者基本信息】 郑州大学 ， 软件工程， 2007， 硕士

【摘要】 随着国家宏观政策的调控，中国邮政分为邮政管理局和邮政企业集团，并且，进一步分为邮政银行和邮政企业集团。中国邮政银行必将面临更多的挑战与压力。如何有力的把握市场动态、有效的挽留金融客户、合理的部署渠道、准确的规避风险、合理的设置产品等将成为邮政储蓄将来更为紧迫的问题。另一方面，各业务系统积累了大量的客户资料、交易信息、渠道信息，这些信息充分反映了邮政储蓄业务发展的特点，隐含了邮政储蓄的经营现状和市场需求，使得邮政储蓄管理层可以从中发现有用的信息，用于进行企业的经营管理和分析、进行客户的差异化服务、进行针对性的营销活动，最大限度的提高企业的效益。正是在这种市场环境、业务要求和数据支撑的情况下，邮政储蓄提出了实施以数据仓库为基础的邮政金融客户信息管理系统。本文结合中国邮政金融客户管理的实际要求，开展了数据仓库技术在中国邮政金融客户系统的研究及应用。本文首先介绍了对信息化发展所积累的海量数据进一步挖掘的意义和本课题的技术背景。然后根据金融客户系统的业务需求、储蓄业务系统的数据质量、数据仓库建设特点等因素，重点研究了金融客户系统的整体架构设计和模型设计两方面的内容，并给出了金融客户系统的系统架构设计、ETL设计、应用架构设计和逻辑模型及物理模型等。为了确保数据仓库的成功建设、保证数据仓库系统使用时的高效性，根据数据仓库的特点和性能上的要求，将逻辑数据模型转换成数据在物理设备上的存储结构与存取方法。本文主要解决如下关键问题：从整体上给出了全国大集中的金融客户系统的系统整体架构，并在此基础上设计了系统逻辑体系架构、物理体系架构、应用逻辑体系等。基于整体架构设计重点研究设计了后台ETL数据处理机制，包括数据处理流程、数据质量检查和系统ETL的作业分类等。研究了前端应用总体设计，包含了应用的逻辑结构及对应的物理结构，同时还设计了系统的应该功能子系统。定制了符合系统实际情况的逻辑数据模型。考虑了数据库性能优化的有关处理方法。本文介绍的系统架构、ETL处理机制、逻辑模型、物理模型、物理体系架构，已经在邮政金融客户管理系统(简称CPCIM)中投入使用。金融客户管理系统的成功上线，有力地推动了中国邮政金融系统管理的信息化，为经营决策提供强有力的数据支撑。更多还原

【Abstract】 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.更多还原