The Design And Implementation Of The Xinjiang Rural Credit Cooperatives Data Warehouse

With the rapid development of computer technology, data warehouse technology has gradually become mature. At the same time, the commercial bank business system gradually perfect and interbank competition.Xinjiang rural credit cooperatives, data mining has become more and more important, and the realization of data warehouse system of rural credit cooperatives is the basis of banking data analysis.This paper first introduces the development status of data warehouse at home and abroad, introducing the data warehouse development in different stages. Secondly, the paper introduces the basic concept of data warehouse, including data warehouse and ETL(Extract-Transform-Load)related concepts. Thirdly, the paper also introduces the design of data warehouse based modeling, including subjiective modeling, logic modeling, physical modeling, mapping of source data and summary modeling, providing the feasibility scheme of ETL(Extract-Transform-Load), putting forward from the beginning to the end of the complete ETL(Extract-Transform-Load) process: the using of DataStage tools to complete by mirror database to the data exchange platform extraction data warehouse; special loading tool Nzload of Neteza to load the database buffer; buffer to the processing of base layer adopts java to develop the embedded SQL scripts to convert; Cognos connect Netezza to report the display of data warehouse. Finally, the work content of this paper are summarized and the prospect of the various stages of the entire process, the paper has carried on the summary and the summary, also made a prospect of the data warehouse system and look forward to the future development trend and prospect.Through the analysis, the thesis introduces a new implement method of data warehouse system of commercial banks, further to achieve a successful Xinjiang rural credit cooperatives in the data warehouse system, which for Xinjiang rural credit cooperative data analysis provides a good platform to enter the era of big, but also provides a good reference value for other similar bank data warehouse construction. This paper is completed in Tianjin Lian Yi Technology Co. Ltd..