Design And Realization Of Data Warehouse In Bank

In today's world, all industries are facing intense competition; timely making the correct decision is an important link to the enterprises survival and development. With the escalating of competition in the market and the development of enterprise management concepts, enterprise informationization (EI) was an inevitable trend.The bringing up of data warehouse (DW) technology establishes a system environment of data storage. It separate the large amount of analysis-oriented data required for decision-making from the traditional operation environment, and make the scattered, inconsistent operating data into integrated, unified message. The different units and different members in the enterprises can use of data and information in this single environment. Through data warehouse, enterprises can find relations of data from the flood data and make decision support.Data warehouse utilizes traditional database technology as a means of storage data and management resources, and utilizes on-line analytical processing (OLAP) technology as an effective way of analysis data and extract information, and utilizes data mining, artificial intelligence technology as a means of knowledge discovery. It is the integrated application technologies of crosscutting many disciplines.The paper introduce exhaustively system architecture and design model and realization procedure of data warehouse creatively in the basis of introducing theory of database and data warehouse, data mining technology. The system has been used in the bank and made obvious benefit. The result prove that the design schema is high effective and performable.