Designing And Achieving Data Warehouse For Internet Banking Transaction

With the continuous reform of the market economy in China and the development of the integration of the world economy, the banking industry of China will be confronted with more and more serious market competition. In order to adapt to requirements of bank management in new situation, the straight target of constructing enterprise informatization has transferred from raising the efficiency of dealing with business to raising the management efficiency and the policy-making level. Here are efficient ways for commercial banks to raise the operation and management efficiency and the policy-making level, which are to build a Data Warehouse and construct query and analysis application based on the Data Warehouse, and to study and analyze the data source more.A data warehouse is a subject oriented, integrated, non-volatile, and time variant collection of data in support of management's decisions. This article has introduced the Data Warehouse and Online Analytical Processing, defined the Data Warehouse and detailed the following contents such as the system structure, the design of the model of the Data Warehouse and also the design of dealing with ETL of the Data Warehouse, besides which it has also presented that when establishing a Data Warehouse, a large enterprise with many business systems, intricate business logic and quantity data should build a central Data Warehouse to conform enterprise data to provide an analyzing circumstance, and build data marts to meet analysis acquirements of the enterprise.Basing on the experience of succeeding in building the Data Warehouse for Bank A and with the case of building the Data Warehouse for the internet banking trading, this article presented that the central Data Warehouse must be used to solve the problems of redundant data from different business systems when facing the circumstance where there are repeat data among different business systems during building a Data Warehouse.