Computer and Modernization

Previous Articles     Next Articles

Research on Relational Database Data Block Replication Model

  

  1. State Grid Electric Power Research Institute, Nanjing 210003, China
  • Received:2015-12-15 Online:2016-05-24 Published:2016-05-25

Abstract:  In view of the problems existing in the current logic level database replication technology, this paper presents a model of database data replication based on physical level. The model uses a database replication group to establish its reference relationship. By analyzing the Oracle log data in the file system format, the raw device and the redo log based on the database, the data fragments are synchronized to the end of the data segment. By end of log fragment reorganization, the log head sign is modified a synthetic log file and source side validation are registered to disaster libraries, and synthetic log is automatically or manually written to disaster libraries, so as to realize the physical database replication. By comparing and analyzing the test data, the model can not only ensure the data consistency, but also reduce the time delay of data replication.

Key words:  , redo mining; encrypted transmission; redo synthesis; redo application; consistency; delay

CLC Number: