SQL Synchronization Error Detection AND Replication Method of Database Replication System Using SQL Packet Analysis

摘要

The present invention relates to a method for generating various types of derived data from one database, and more particularly, to a method for converting data stored in an original database into a data structure and replicating the data without a load by a replication operation. The system comprises: a first operating server operating an original database; a second operating server operating an extra DBMS; and a replication server which extracts an SQL transmitted to the original database from a network stream transmitted to the first operating server from a client and transmit the extracted SQL to match the original database and a replication database. The replication server comprises: a sniffing module capturing packets sent from the client to the first operating server or the original database; a packet analysis module for analyzing packets captured by the sniffing module; a data structure conversion module analyzing the extracted SQL to create SQL by masking personal information for generating SQL or test data for a heterogeneous DBMS; and a conversion data application module transferring the converted SQL to the operating server operating the replication database of a DBMS by using JDBC.