The Analyze And Design Of The Branch Data Integration

With the gradual deepening of concentration in data of Industrial and Commercial Bank of China, continuous conformity of various businesses, all kinds of systems' data are concentrating into headquarters gradually to form two data centers of Shanghai and Beijing, every branch generally can't keep data of host computer any more. Under this pattern, business and management analysis of various banks basically relies on feedback data from report forms and CS2002 system developed by headquarters and so on. In the beginning of data concentration, this kind of pattern doesn't exist any problems, but with the development of business and company listing, Industrial and Commercial Bank of China begins to particular operation, the assessment to employees and customers is becoming more and more specific, the business and decision-making need to consider more and more factors, with much higher requirements to data, simply applying CS2002 system developed by headquarters and feedback data from report forms everyday to analyze is not enough not only for requirements of data quality but also for the requirements of data degree as well as the time effective requirements of data, it is urgent to build up a suit of compete data platform to provide data support for management decision-making, customer assessment and employee examination.This paper starts from the two specific demands of employee integrated performance assessment and customer assessment, and specifically analyzes the data needed by employee integrated performance assessment and customer assessment, and determines the source of data, and describes the example picture of system, order picture, designs the network structure, system structure and logic structure of this system, and makes ER indication to the database forms, and setups the software and hardware environments required by selecting platform according to the previous development experiences and the requirements of Industrial and Commercial Bank of China headquarters. This paper makes specific study on form space technology, form, index sub area mechanism and outside form technology of Oracle data, designs a suit of ETL scheme suitable for Shandong branch of Industrial and Commercial Bank of China which realizes the process of taking out data, cleaning data and transfer data from data source to database which builds data pool for integrated data platform. It designs the data outdate and backup strategy meeting demands by parameter optimization to Oracle database.At last, it builds up a integrated data integration platform treating SUSE Linux Enterprise 9 as operation system, ORACLE10G as background database and WebSphere6.0 as application server middle components which can realize host computer returning data, international card business data, CM2002 downloading data, PCM2003 downloading data, electronic bank downloading data, the processing, application and storage of telephone bank downloading data, which develops basic data and development environment for the feature system development of Shandong branch of Industrial and Commercial Bank of China to meet the demands of current customer assessment, employee examination and business data analysis in our bank.