RCCs data warehouse system design and implementation
|School||University of Electronic Science and Technology|
|Keywords||Inner Mongolia Rural credit cooperative data warehouse ETL OLAP|
Along with our country financial industry’s swift development, the traditional bank manual operation service substitutes by the computer system, but these on-line business process the (OLTP) system not to be able to satisfy a banking industry deeper level the demand, specially bank decision-making support demand, but technologies and the tool and so on data warehouse and with it related on-line analysis processing (OLAP), data excavation, has provided the brand-new technical support for banking industry’s management decision.Inner Mongolia Rural credit cooperative already entered to take the customer as central, face the management benefit, take the information technology creativity as the chief feature development phase, no longer merely is the batch run work and transaction processing, needs to use the data warehouse the formidable function, will be moving the independent many data pools to carry on the unification respectively the organization, forms an integrated the memory structure, serves for Inner Mongolia Rural credit cooperative’s decision analysis. Inner Mongolia Rural credit cooperative core business’s computer processing, accumulated the massive customer data and the management data. Builds Rural credit cooperative’s data warehouse, realizes to all management information and the customer information effective memory, and aims at the different department’s management decision need, carries on multi-level data smoothing processing, satisfies the management decision and the customer analysis need, sharpens the internal macro-scientific policy-making ability, sharpens Inner Mongolia Rural credit cooperative’s profit ability and protection risk ability.This article elaborated Inner Mongolia Rural credit cooperative data warehouse project introduction background and the construction, according to Inner Mongolia Rural credit cooperative to the project request, designed and has built the data warehouse project construction model, introduced in detail Inner Mongolia Rural credit cooperative data warehouse project demand analysis flow, aimed at the data extract, the transformation, the load process specially, proposed the ETL construction model, had determined Inner Mongolia Rural credit cooperative data warehouse project ETL deployment plan and realized the process. Finally, has carried on the summary to Inner Mongolia Rural credit cooperative data warehouse project implementation situation, and proposes the forecast.