A lightweight timestamp-based method for data replication in database

Introducing additional timestamp field to capture data table changes is one of the most common methods for data replication. In this paper, we test the timestamp-based method with a table with 10 million records. There were several inconsistencies caused by concurrent executions within certain database isolation level. This paper describes an improved timestamp-based method by using Oracle database's internal system change number (SCN) instead of traditional user-defined timestamp field. Experimental results show that the method can solve data inconsistencies and show better performance. It is a lightweight method for data replication and easier to implement than other methods.