Research Of Intermediate Business In Bank Based On Data Warehouse

In recent years, a substantial increasing in the business-critical data and customer data of enterprises, and traditional database couldn't satisfy the bank's business, so data warehouse is the best solution means for those who wish to make use of these data with advantages. How to make the enterprises existing applications and data warehouse integration, has become a hot area of research.Intermediary business is raising in recent years, because of their characteristics of low cost, small risk, high-return which relative to the traditional banking business, it has become a hot spot focus of the development in commercial banks. However, the intermediary business involving complex variety of products, product-specific basis of information scattered in various business systems, so it would greatly restricting the development of intermediate business. At present these problems greatly restricted the development of intermediate business, manufacturer eager to find an effective solution.For the above-mentioned problems, the paper will integrate intermediate business and data warehouse, make a research of intermediate business in bank based on data warehouse, to enhance work efficiency and bring more economic benefits for the bank. This paper is based on the in-depth analyzing development of domestic and foreign banks, and discusses detailed data warehouse structure, the basic principles of methodology, and analyzes their systems design and development process. Then in close connection with a commercial bank's intermediate business, we design and implement the intermediate business of banking system based on data warehouse. Hereinto, we are focusing on design process of the bank's intermediate business management information system, and building a data warehouse model detailed programmer. Besides, we show the detailed design of the ETL process in according with ETL design principles, and defined the basic rules of ETL development.Finally, under this programmer, the commercial banks has been completed the construction of intermediate business system at this stage, and it could provide reports and front-end web shown for the business accurately and timely, and made a good effect.