×

Replicating structured query language (SQL) in a heterogeneous replication environment

  • US 10,366,105 B2
  • Filed: 05/05/2017
  • Issued: 07/30/2019
  • Est. Priority Date: 09/25/2015
  • Status: Active Grant
First Claim
Patent Images

1. A processor-implemented method for replicating structured query language (SQL) in a heterogeneous replication environment comprising:

  • receiving, by a database replication component of a database management system (DBMS), a delete or update first SQL statement that was executed on a source DBMS and is directed to one or more tables of a target DBMS having an architecture that is non-compatible with the source DBMS, being of different operating system architectures, different DBMS versions, different host server architectures, or different DBMS vendors;

    evaluating whether to create a source tree structure from the received first SQL-statement based on complexity of the first SQL statement wherein the first SQL statement comprises;

         1) a column in a source table not corresponding to a column in a target table;

         2) the first SQL statement including a concatenation of columns;

    or

         3) the first SQL statement including a user-defined function;

    in response to creating the source tree structure, evaluating whether the source tree structure is transformable;

    based on the source tree structure being transformable, transforming the source tree structure to a target tree structure, wherein the transforming comprises mapping one or more columns in the source tree structure to corresponding columns in at least one target table by substituting values associated with columns of the source table into corresponding columns of the target table, and wherein the values comprise constant data and expressions using other columns, the values being connected using relational operators, and grouped using brackets and parentheses, but when the source tree structure is not transformable, indicating to the database replication component to apply default row level replication strategy instead of performing data transformation; and

    generating a target SQL statement for execution at the target DBMS.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×