A Synchroniz ation Algorithm Based on the Database Record Mark
LI Liya
Abstract:The data in the database need to be stored at several storage‐point in order to reduce the risk of data loss . Synchronization of heterogeneous database ,different scenes often use different algorithms to meet the actual demand .A da‐tabase synchronization method based on the recording mark according is proposed to the synchronization requirements of two heterogeneous databases .To achieve synchronization markers and business records binding ,store mark synchronization in‐formation in a column in a table .The data operation algorithms designed with the synchronization marker can achieve row granularity level of data synchronization .This algorithm is simple and reliable ,easy to implement ,has good performance , can realize certain double database hot standby function .This algorithm is implemented in the application layer ,application can fully control the data synchronization and only synchronize the business data needed synchronization .This algorithm has high flexibility and is suitable for the data synchronization between two heterogeneous databases .
Keywords:heterogeneous databasedata synchronizationrecord markstate transitiondata operation
Publication Date:2015-01-01
Online Publishing Date:2025-08-15(First online date of this platform, not the publication date of the document)
Pages:7( 946-952 )
