| With the further informatization after 1990s, various social work show more and more dependence on the network and database system.The computer system being distributed in different area, integrating all the computer system has become important technology in computer science fields. The distributed database system emerges at the time required.The core of the distributed database system lies in the guarantee of the constant server working of each system and the synchronization of the key data.A reliable synchronization plan for remote database should be put forward. The traditonal methods can not accomplish data synchronization in the specified time and in the specified field of the data. So a synchronization plan for remote database based on the Oracle log parser is put forward in this thesis, including as follows:1. Presenting different researching methods of the data synchronization for remote database.One based on the synchronizaiton function of the database; One based on the characteristic of the database(There are set catalogue in each database and they are saved in the form of documents);One based on the appropriative data synchronization software.2. Putting forward some proper solutions for the key problem in data synchronization for remote database based on the log parser.Including Redo log parser and log documents parcer through Logminer. Resolving SQL sentence syntax pasered by logminer(making it acord with the target table with the Flex log parcer) and changing it into other sql sentences with parameters acquiesced by the OIC (the sql sentences with parameters will be efficient ). The remote database accomplish synchronization operation by the log table.3. Putting forward a prototype of the remote database and discusing the problems of the robutness of the system.In this thesis I probe into the problem in data synchronization for remote database in Oracle and put forward a solutions based on the log parcer. Some experimental results and their analyzing work are provided . |
PDF Full Text Request