Application Of Data Warehouse Modeling To Bank Customer Information Management

Recent years, with the rapid growth of bank market, the amounts of customer andbusiness data have become voluminous and complicated. How to manage andrecombine these data resources, and extract valuable information to make decision, hasbecome an impending problem to solve. The birth and development of data warehouseand data mining technology has provided efficient theory and method to solve theproblem.In the found of data warehouse system, data modeling is the key process of DataWarehouse project which will directly decide the usability, expansibility andmaintainability of Data Warehouse. In view of status of the independency and differentsystems of a bank, which results in the phenomenon that the customer and operationdata become isolated, forming information silos, the paper researches and utilizes datawarehouse modeling technology to direct and build its data warehouse system based onthe bank requirements of market decision and business expansion. At the same time,taking the customer management system of the bank for an example, the papersummarizes implementary background, process and effect of the item.At first, the paper analyzed the status of development of data warehouse andbackground of the bank industry. The definition of data warehouse is specificallyintroduced, and the key techniques of data warehouse modeling are studied.The paper emphasizes on analyzing and building the conceptual data model, thelogical data model and the implemental data model for the customer managementsystem of the bank, through researching on data warehouse modeling theory. Based onthe research work of the bank, The paper summarizes the data model which has6subjects(customer, product, agreement, event, channel, marketing)and satisfiesrequirements of most bank companies. What’s more, the paper proposes the manner ofdata distributed and storage for a nationwide data warehouse center, combining withthe real project. The paper discusses the procedure and effect of building the datawarehouse for customer management system.