Design And Application Of Group Customer Information Management System Based On Data Warehouse

With the surging wave of ecnomic globalization and the new pattern of China's accession to the WTO, the company and the enterprise group in China's commercial banks will be the focus of marketing and important customer resource. Therefore, the decision-makers to make a correct and timely decision-making is an important link to the bank survival and development. Data warehouse is a subject-oriented, integrated, non-volatile, and time-variant collection of data in support of management decisions. What's more, ETL ( Extraction Transformation Loading ) are basic and important processes in data warehouses. Data warehousing is not a new platform, but a new concept. Meanwhile it is not a product, but a solution. Data warehouse utilizes traditional database technology as a means of storage data and management resources, and utilizes on-line analytical processing 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. Data Warehouse provides decision-maker a single analysis environment, in which information from multiple heterogeneous sources is transformed and integrated in advance and stored in a warehouse.This paper first elaborates the data warehouse basic concept and the characteristic, the data warehouse architecture, the data warehouse modeling as well as the data warehouse two kind of users. Next, It has given the ETL related concept, the ETL translation rule as well as in the data warehouse implementation process the ETL load strategy, the ETL necessity. Then, It has given the data warehouse system architecture design proposal, the model structure design, the ETL design cycle and the report front end form unfolds. Finally, using Oracle 10g data warehouse business system to integrate existing data to build a group of customer data warehouse system , which makes full use of Oracle, PL/SQL Developer, such as product characteristics, is an efficient, flexible, practical decision-making support, has been applied to the Ministry of bank customers and gain significant business benefits. The result proves that the design schema is high effective and performable.