期刊名称：International Journal of Research in Computer Engineering & Electronics
印刷版ISSN：2319-376x
出版年度：2014
卷号：3
期号：4
语种：English
出版社：BHOPAL INSTITUTE OF PROFESSIONAL STUDIES
摘要：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 environment. 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 exe-cute the changed query in the target database. Our experimental results evidence the effectiveness of the proposed method.
Loading...
