Data Warehouse In Chinaconstrucfion Bank Individual Finance Service Application

With the break of the monopoly of banks and the entry of the foreign banks, the domestic banks face the severe competition ,which the gap is smaller among the types of produces and service quality ,So only relying on the touching movement to attract customers is due to the loss among the competitors.. Therefore, In order to solve this problem,banks is pursuing the method to improve the service quality and raise the market competition potential.The data storage technology is the good way for the banks to face the the fierce competition.The main thesis as follows :1. Research currently carried out at the banks of the personal financial business encountered all sorts of problems, proposed to establish as a data warehouse solutions.2.study and analysis of data warehouse technology in the personal financial business applications.3. according to the Construction Bank of the current status of the database, and put forward specific solutions.4. the bank's data warehouse implementation of the program.The main achievements are as follows :1.the Construction Bank has completed a nationwide data centralization, two branches need to rely on every day from the head office data centers and download data. and the head office to provide data covering a wide range of business, the amount of data, integration complexity, but not with the management system integration. In this paper, and consider multiple options, based on the Sybase IQ technology solutions, thus solving the data warehouse loaded with data cleansing issues.2. the Construction Bank personal financial business data, the bank raised a data warehouse implementation of the program, and the units specific implementation.3. targeted at the specific process of implementing some of the problems identified, raised the data warehouse experience and methods.This article mainly designed and has realized a bank individual finance service application data warehouse system, the function including the data warehouse establishment, OLAP and the data mining technology in the bank concrete service application, made concrete for the analysis subject determination, the analysis content is thin,granularity design. In the article proposed the construction bank datawarehouse implementation plan in view of the construction bank service and the data characteristic. Finally, the question which appeared toin the system design and the realization work has carried on the summary, and proposed the next stage work concrete direction.