SQL query based data synchronization in heterogeneous database environment

摘要

Database synchronization is a complex process in heterogeneous database environment. Maintaining the uniformity of data and its structure is a fundamental problem of data synchronization. In this paper we present a methodology to synchronize data and structure in heterogeneous database envrionment. We capture all DDL and DML SQL query from source database and pass this SQL query to target database. A process runs continuously in the back end to read SQL query and passes the SQL query to target system through HTTP. Another process processes the SQL query in the target system. Some errors may happen in target database for data type mismatch or SQL query function mismatch or unavailability. To avoid these errors, we have used two lookup tables and adapt the SQL query. Then we execute the changed query in the target database. Our experimental results evidence the effectiveness of the proposed method.