The Design And Implementation Of The Bank Basic Data Platform Based On Data Warehouse

In order to adapt to demand for strategy changing and to keep high-speed development of each business, agriculture bank have designed and developed product pricing assess system. The system was an important part of comprehensive performance management of information system. Its aim was to assess every bank business product, and to accomplish automatically accouplement and encashment and performance wages and fee, according to assess results and conjoit standard.This system was composed of three parts:base circumstance, product measurement and product pricing. Major function of base circumstance subsystem was implementation configuration for system basic information; support of basic data for every module; management of data informatiom for organization, personnel and product. Product measurement subsystems were applied to complete collection, auditing for tranmoney, client number and volume of business through collection data from operation system or handwork record, and process computing result. Product pricing subsystem was applied to compute and arrange resources on the base of implemetation of product measurement for performance affiliation.This article analyzes the background of the system development and domestic and foreign banks in the development of product pricing assess system at first. Secondly, it detailedly described requirements analsysis and overall design. In the part of detailed design, we introduce emphatically design and devlopment of foreground and background modules. At last, this paper descripted detailedly design implementation of resource encashment module.By appling advanced concepts and newest technology, adopting B/S advanced concepts and newest technology, the entire system is based on ABC core accouting system, supporting mainstream database such as Sybase ASE, Sybase IQ et al, being compatible to each soft hardware platform of Window and Lunix of user side, applying J2EE assembly technique and XML language to accomplish writingworks. After pricing assess system of bank product was used and generalized, we can share the data resource of the bank in the system, reduce employee repetitive labour largely, and enhance the level of scientific and precise pricing management. Futherly, with the change of business requirement and the improvemnet of product pricing asses, we will optimize the system design and supply basic data support for product pricing work deeply and roundly.