Design and Implementation of Oracle Database Incremental Data Capture Based on Trigger and Identification Table

Abstract

Data synchronization technology is one of the key technologies of data storage in distributed database. At present, it is an effective method to achieve data synchronization between source database and target database by capturing incremental data and transferring incremental files. Based on the research of Oracle database and the analysis of commonly using incremental data capture methods, this paper designed DML trigger and incremental data identification table to store incremental identification data in the identification table, and generated incremental XML files for network transmission according to the identification table. Finally, the feasibility of this method was tested. Tests showed that the method was reliable and stable, and could be applied to data synchronization in distributed databases.