Commercial Banks Massive Historical Data Integrated Storage And Access Control Systems Design And Implementation,

Face to Chinese financial market' s fierce competition and the IT high-speed development, the bank informatization construction has displayed as 'data centralization, business synthesis, management structure flat, scientific decision-making' . Information accompanies with the marketplace, fund, talented person and turns to be one of the most important resource in modernized commercial bank, be occupying more and more important position. And it already become the basis scientific management guarantee , the premise of correct decision-making and the effect regulates and controls, which the bank serves to the outside. Whether all-round information can own timely and accurately or not, already becomes the key point to measure the banks' potential. Bank information administration relates to the information resources progress of work such as collecting, storing, processing, handling, and providing. Among all the applications, the history data store system play a vital role.This paper firstly summarizes the bank industry historical data storage and service system background and current situation. On how to keep and use the historical data, we analyze the existing problem, and conclude the aim and meaning of building the historical data storage and service system. Based on this research, we find the way to build up the whole construction of historical data storage and service system, further improve the bank internal data management and optimize the data flow. And in the end of this paper, we explain the Change Data Capture, the Tracking the Data Model Change, Database Virtual Backup and Historical Data Service etc.The contents are included as follows :1. Design a Change Data Capture (CDC) arithmetic based on MD5. With CDC, a data fingerprint is initialed, and use the data fingerprint to capture the change data. In this way, the irrelevant logic of business can be reached.2. On the handling of the data change, we use Chained Increments data store mode to complete data increase quantity store. It can save the time and storage space effectively, and meet with the data backward.3. Utilize the Web Service to provide real-time history data query, satisfy the batch history data analysis requirement, and use SQL language to query history data slice and so on4. Usage the database Virtual Backup technique of Sybase IQ, and combine the hardware disk copy functions, such as technical Local Copy, Delta Copy, the Remote Copy and the more related channel management, etc. And finally realize the quick and efficient database backup and restore system, satisfy the system demand of 7*24 hours to run without a break.