Synchronization Based On Log Analysis, Database Design And Realization

With the rapid development of the information construction of social insurance, the transaction of social insurance on the network has become a new and convenient method. Owing to the fact that governmental net has a quite higher standard for safety, SGAP (Secure Gap), therefore, should be installed between application network and examination network to separate them, but SGAP(Secure Gap) is a peel of protocol and data recompose device, therefore TCP/IP the database replication,the database snapshot,the materialized views,the trigger synchronization of TCP/IP protocol fail to transfer application information to examination network.Log analysis for database synchronization put forward to a new idea, this method, with the help of the retrieval techniques of the Oracle database, and database examination, tries to analyze the archived redo log files, and retrieve DML operations existed on the database, and get all the application operations, then send them to the examination network through SGAP, and then operate to the data again to make application database and examination database the same.The present paper tries to research the transformation of examination database and its results by applying the method of log analysis; it first introduces how Oracle database operates on DML operations, and analyses the formation of log files according to the theories of ORACLE advanced retrieval, and get the DML data set. After through analysis of them, tries to describe how to transform the data set to make sure it becomes SQL language which can be understood by DBA and database. And then transfer the results to examination network for final approval after displaying the results, in this way, the synchronization of application database and examination database has been finished.