中小型银行的信用卡数据分析系统设计_学士学位论文.doc

沈阳师范大学学士学位论文 V- 中小型银行的信用卡数据分析系统设计 【摘 要】 近年来我国信用卡业务获得了飞速的发展，商业银行信用卡业务已经逐步成为了一个成熟的金融市场的一种重要的商业产品，现在我国商业银行信用卡业务正处于快速增长的阶段，随着商业银行信用卡业务的高速发展，银行积累了大量的信用卡交易数据，如何将这些数据变成有用的信息，使银行的领导做出决策性的判断，是信用卡分析集市需要解决的问题。 为了解决上述问题，本课题对国内某家中小型银行的信用卡数据分析系统进行设计，并以数据仓库和数据集市的理论为基础，结合该银行的技术现状和业务需求，建设了基于数据仓库的信用卡数据分析集市。支持多维分析和灵活的报表展现。 本课题根据从源系统到用户的数据流向，设计了临时层、基础数据层、数据汇总层三大数据层次。临时层用于存放缓冲数据基本与源数据保持一致。基础数据层用于企业数据仓库，存储细节和历史数据。数据汇总层用于数据集市，支持数据挖掘，该层并且直接面向多维分析和灵活报表。 每个层次根据不同需求而设计，并且数据在导入的过程中存在一定依赖关系，基础层依赖临时层，汇总层依赖基础层。本系统实现的信用卡数据分析集市使该银行首次拥有了支持信用卡数据挖掘的数据分析平台。 【关键词】 数据仓库，信用卡，数据分析，ETL  Design and Implementation of Credit Card Analysis Data Market Based on Data Warehouse 【Abstract】Bank credit card business in China in recent years has been developed rapidly, the bank credit card business has become a mature financial market is a kind of important commercial products, now Chinas bank credit card business is in rapid growth stage, along with the high speed development of bank credit card business, the bank transactions to accumulate a huge mass of data, how to turn data into useful information, so that the leadership of the bank to make decision-making judgment, is the credit card market analysis problems need to be solved. In order to solve the above problems, the subject of a domestic small and medium-sized bank credit card data analysis of information system design, and based on the theory of the data warehouse and data mart, combined with the current situation and business needs of the banks construction based on data warehouse credit card data marts. Support multidimensional analysis and flexible reports show. This subject from the source data system according to the users data flow, design the temporary data layer, data collection layer three large data level. The temporary data layer store cache data and keep almost the same with the original data basic data layer for the enterprise data warehouse, store details and historical data. Data collection layer applied in data mart, and support the data