Design And Implementation Of Commercial Bank Data Warehouse System

Data warehouse technology is through the development at home and abroad for many years, used in financial industry has been very common, the international market of a few large data warehouse software company, providing large capacity data transmission technology in storage server, powerful, in order to reduce the cost of data integration, provides the hardware and software security powerful, improves data utilization efficiency. Through the research on the field of data warehouse, looking for an effectively data warehouse architecture and implementation method of large data integration theory, namely the data warehouse multi architecture technology. ORACLE can provide powerful data storage and parallel database server and storage service, Cisco provides data transmission, greatly reduces the difficulty of data integration and the implementation cycle.Commercial bank data warehouse systems for the enterprise of large commercial banks can be used to provide powerful set of data integration solutions for group data integration business models. Commercial bank data warehouse system is a distributed and parallel data warehouse system, integrate the data between the various business departments, branches and the group, use technology to implement data integration between cross regional, cross platform and cross system. Both ends of the business data requirements of personnel and data warehouse server require a large amount of data transmission in real time, efficiency and a secure transport. In a more in-depth study of the data warehouse implementation principle, storage infrastructure, service characteristics of commercial banks and financial data warehouse system characteristic and deployment scheme along with data warehouse resulted in the banking industry to solve the commercial banks big data integration problem.This paper studies the technology of data warehouse, and the commercial bank data warehouse system data requirements analysis, using large capacity storage technology, the leading data integration model, parallel database server and broadband network transmission technology to design and implement commercial bank data warehouse system features. And track the use effect of typical users along with program performance tuning.