Credit Cooperation Data Integration Model And Solution Based On The ETL

In recent years, the foreign bank and joint-stock commercial bank result in a vast emerging. Domestic banks'competition intensifies. How to use the advanced science and technology method and how to build a system has become the major domestic banks principal problem to meet the need of comprehensive competition and various development.As the root of agriculture, services of rural economic Credit Cooperation local financial institutions -- China's rural credit cooperatives, business development and, in order to adapt to the need of fierce competition, this paper puts forward the construction of Chinese county to comprehensive data business network system. Because informationization start later and information level uneven, a series of serious problems for example backward technology and talent shortage become stumbling block of rural credit cooperatives's continued development. Although a few provinces with modern informationizaton have realized the province-level data centralization, but most only realize the city-level data centralization or remain in single computer operation. In recent years, a lot of branches have constructed small-sized information system, but most are regional stand-alone, data isolation, complex, unable to share information and uniqueness is out of question.This paper puts forward the construction of rural credit cooperatives, solve store ODS-ETL system database and its business integration issues of database management and realize the sharing, cross-platform valid data provide more effective for decision-making, true and accurate information. It firstly introduces technical concept store ODS-ETL and realization of technology of ETL process to realize, second inquiry. Detailed Lu Liang reference the rural credit cooperative in Shanxi Province, and puts forward its data centralization in original data platform based on data transplanted to establish the ETL store ODS system, the system.In Lv Liang rural credit cooperative in Shanxi Province and its data centralization in constructing process met the problem and put forward the countermeasures as follows:(1)Using the ETL tools to implement integrated solutions of heterogeneous database, design data incremental extraction, multithreading task, data schema definition module, task module schema definition module.(2)Based on thorough investigation and heterogeneous databases are analyzed, and Credit Cooperation data system construction in the store (ODS) system suggestion. Aiming at the existing data system of rural credit cooperatives, and points out that the concrete integration schemes, and store ODS-ETL the implementation scheme of each module in the system.The current Lv Liang in Shanxi Province for the construction of rural credit cooperatives are store ODS-ETL active preparations and try system. Hopefully through above all in for cooperatives data centralization process data integration, and puts forward a kind of thought for solving bank system - and each basic information and data integration between credit offer advice and reference. For the next step is the province online provides the technical support.