Method and apparatus of conflict reduction in multi-source data synchronization
Original Publication Date: 2010-Jan-28
Included in the Prior Art Database: 2010-Jan-28
The disclosure includes a method and system to solve the primary key conflictions issue during multi-source database replication by using rule-based approach to dynamically change conflicting key values and propagate them to enable data consistence. In the disclosure, during database replication, firstly tables are linked together by primary key and foreign key relationships to generate a table dependency graph which is a directed graph of tables, then detect the replicate sequence by the table dependency graph. If any conflict is detected, change the primary keys according to predefined combination rule and keep adding the data into the target database. Further if any primary key is changed, all foreign keys of the primary key are changed according to table dependency graph. After the confliction reduction, legacy applications could run without any change.