Design And Implementation For The Credit Card Integration And Analysis System

With the rapid development of the China Business Bank credit card, the types and services attached with the credit card are increasing continuously, as a result, the original analysis system for credit cards has failed to afford the current requirement. Now that the supervision system and internal critical data within China Business Bank need to be updated dynamically, developing and implementing an integration for the credit card analysis system has a serious meaning.The credit card business method of China Business Bank are changing from rutial into lean, the focus factor is turning from quantity to quality. Without a analysis system, which are really facing market and the end users, China Business Bank can not provide perfect service and effective management. Since the open Chinese financial market is coming up, how to improve the competition of the credit card is raised up to the critical schedule, which focuses on the stronger total completion of the credit card, the clear analysis, the more specified market, the more effective management, and the better product innovation ability. Meanwhile, to support the data mining for different level departments within China Business Bank, a credit card analysis system with a unique format and powerful functions is necessary.The author is going to explain the design of the credit card analysis system and the implement of back-end data management. The credit card analysis system consists of the back-end data management, system management, the front-end display system, and the management system. Further, the back-end data management includes three parts:the basic data area, the application data area, and the table data area. The basic data area can manage and store basic data as data units in terms of packing, unpacking, extracting, transporting, cleaning and transforming; The application data area, the application data area analyses data units, and calculate the complexity of data units; according to the complexity calculation result, the table data area creates and uses data tables, and with the further calculation within different data tables, the table data area also creates tables which can directly support the data query on Web. The credit card analysis system is implemented on the SYSBASE IQ data server, it is developed by the Language C with SQL, also uses the ETL for data extraction, transformation, and reload. With the help of the above technologies, the credit card analysis supports the total web interface, and multiple level data analysis.