首页>
外国专利>
DML NoSQL Transaction control method to synchronize DML statements in relational database to NoSQL database
DML NoSQL Transaction control method to synchronize DML statements in relational database to NoSQL database
展开▼
机译:DML NoSQL事务控制方法,用于将关系数据库中的DML语句同步到NoSQL数据库
展开▼
页面导航
摘要
著录项
相似文献
摘要
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.
展开▼