Rac Optimization Of The Postal Financial Network Technology Research And Realization

This research subject origins from the optimal design program for the data centralization system of China Post financial network.This paper, with the background of information data centralization in the whole nation's China Post financial network, and especially focusing on the big challenges and high requirements for database in reliability, consistency and high performance in the data centralization system in Henan province, leveraged a latest performance optimization technology named RAC (Real Application Clustering) from Oracle to solve the problems mentioned before.The paper considers the technology of RAC and the characteristics of China Post financial network in the same time and leverages the lock mechanism, the high speed cache fusion mechanism, the query optimization mechanism, the disk sharing mechanism and the TAF mechanism in RAC. Based on the requirements of real running system, multi-granulirity lock machinism has been designed based metadata, to optimize the access and transformation among multi-threads; Databased buffer optimization has been implemented via the adjustment of databased memory, the optimization of the application program and the connection of clusters, based on the performance analysis of real system; By using parallel operation and constrcuting parallel index, database query performance has been optimized based on the analysis of database using pattern; Shared disk strategy has been executed by control the access of disk, and TAF has been implemented by using the roll back of transaction finally. The research optimizes the current system with aforementioned technologies based on the knowledge of existing problems in current system and builds a highly usable and highly trustable platform for business management and analysis and also assures a healthier development of the business and provides a better service for clients.The paper is divided into six sections and introduces the background, related works, the general architecture of the system, critical technology in RAC optimal design, optimized testing plan and the results, and the conclusion of the paper and future work, respectively.