DML NoSQL Transaction control method to synchronize DML statements in relational database to NoSQL database

摘要

One embodiment of the present invention discloses a transaction control method for synchronizing DML statements of a relational database to a NoSQL database. The disclosed transaction control method is a method in which a synchronization proxy server synchronizes transactional DML data of a source RDBMS to a NoSQL DBMS, wherein the synchronization proxy server adds Sync_iid and Sync_uid columns for meta information, recovery history of the source RDBMS, and transactions A preparation step of generating a storage and a data structure for controlling the data, and generating a storage and a data structure for loading into a replication NoSQL DBMS to perform initialization of the synchronization operation; A transaction control step in which the synchronization proxy server receives and analyzes a packet from the network, and internally manages and processes the transaction of the source RDBMS by changing the DML of INSERT and UPDATE to handle NoSQL data conversion failure; A NoSQL conversion step in which the synchronization proxy server processes a corresponding NoSQL conversion after the committed data of the transaction is transmitted to the client; And a NoSQL loading step of loading the DML NoSQL data converted in the NoSQL conversion step into a replication NoSQL DBMS.