REPLICATING STRUCTURED QUERY LANGUAGE (SQL) IN A HETEROGENEOUS REPLICATION ENVIRONMENT
Patent №
US 10,366,105
Granted
2019-07-30
Filed 2017
Owner
INTERNATIONAL BUSINESS MACHINES CORPORATION
Lab
AI components
2
nlp · planning
Assignment
Recorded
Dataset
AIPD
2023_r1 edition
Application
15587488
A processor-implemented method for replicating structured query language (SQL) in a heterogeneous replication environment is provided. The method includes receiving a first statement for a multi-row operation, whereby the multi-row operation is directed to one or more tables of a database, and whereby the first statement includes a text of a SQL statement in a DBMS transaction log. The method also provides for evaluating whether to create a source tree structure from the received first statement. In response to creating the source tree structure, the method evaluates whether the source tree structure is transformable. The method transforms the source tree structure to a target tree structure in response to evaluating that the source tree structure is transformable.
AI classification
Ownership
INTERNATIONAL BUSINESS MACHINES CORPORATION
assignment · 422500974
Assignors
SPYKER, JAMES D., SZABO, VICTOR L., YAO, YONGFENG
On an employer assignment, the assignors are typically the inventors.