System, method, and computer program product for determining SQL replication process
First Claim
Patent Images
1. A method for replicating a table in a source database to a target database, comprising:
- defining a subscription for replicating data from the table in the source database to the target database;
normalizing a query executed on the source database;
determining, based on parameters of the subscription, that the normalized query would cause changes to the target database that are semantically correct by comparison to changes made to the source database by the query executed on the source database;
determining that sending the normalized query to the target database is computationally preferable to propagation of log-based replication change data; and
sending the normalized query to the target database for execution responsive to the determinations that the sending is computationally preferable and that the changes would be semantically correct.
1 Assignment
0 Petitions
Accused Products
Abstract
A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source database. The query is then normalized, and it is determined whether the query would cause semantically appropriate changes to the target database. If so, the normalized query is sent to the target database for execution, in accordance with an additional embodiment of the present invention.
-
Citations
21 Claims
-
1. A method for replicating a table in a source database to a target database, comprising:
-
defining a subscription for replicating data from the table in the source database to the target database; normalizing a query executed on the source database; determining, based on parameters of the subscription, that the normalized query would cause changes to the target database that are semantically correct by comparison to changes made to the source database by the query executed on the source database; determining that sending the normalized query to the target database is computationally preferable to propagation of log-based replication change data; and sending the normalized query to the target database for execution responsive to the determinations that the sending is computationally preferable and that the changes would be semantically correct. - View Dependent Claims (2, 3, 4, 5, 6, 19)
-
-
7. A system for replicating a table in a source database to a target database, comprising:
-
a defining module configured to define a subscription for replicating data from the table in the source database to the target database; a normalizing module configured to normalize a query executed on the source database; a determining module configured to determine, based on parameters of the subscription, that the normalized query would cause changes to the target database that are semantically correct by comparison to changes made to the source database by the query executed on the source database, and configured to determine that sending the normalized query to the target database is computationally preferable to propagation of log-based replication change data; and a sending module configured to send the normalized query to the target database for execution responsive to the determinations that the sending is computationally preferable and that the changes would be semantically correct. - View Dependent Claims (8, 9, 10, 11, 12, 20)
-
-
13. A computer-usable medium having computer program logic recorded thereon for replicating a table in a source database to a target database, execution of which, by a computing device, causes the computing device to perform operations comprising:
-
defining a subscription for replicating data from the table in the source database to the target database; normalizing a query executed on the source database; determining, based on parameters of the subscription, that the normalized query would cause changes to the target database that are semantically correct by comparison to changes made to the source database by the query executed on the source database; determining that sending the normalized query to the target database is computationally preferable to propagation of log-based replication change data; and sending the normalized query to the target database for execution responsive to the determinations that the sending is computationally preferable and that the changes would be semantically correct. - View Dependent Claims (14, 15, 16, 17, 18, 21)
-
Specification