System, Method, and Computer Program Product for Determining SQL Replication Process

• US 20100030730A1
• Filed: 07/31/2008
• Published: 02/04/2010
• Est. Priority Date: 07/31/2008
• Status: Active Grant

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Sybase Incorporated (SAP SE)
• Inventors: Lora-Gallardo, Elena, Shang, Heping, Sarapuk, Andrzej
• Granted Patent: US 8,751,441 B2
• Time in Patent Office: Days
• US Class Current: N/A
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

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.

Claims

1. A method for replicating a table in a source database to a target database, comprising:

executing a query on the source database;

normalizing the query;

determining whether the query would cause semantically appropriate changes to the target database; and

sending the normalized query to the target database for execution, if the determining step determines that the query would cause semantically appropriate changes to the target database.

2. The method of claim 1, further comprising:

sending change data to the target database for execution, if the determining step determines that the query would not cause semantically appropriate changes to the target database.

3. The method of claim 1, wherein the determining step is performed when the subscription is defined.

4. The method of claim 1, wherein the normalized query is sent as part of a transaction log.

5. The method of claim 4, wherein the transaction log comprises one or more transactions, the normalized query associated with one of the one or more transactions.

6. The method of claim 5, wherein the target database processes the transaction log by processing the one or more transactions in commit order.

7. A system for replicating a table in a source database to a target database, comprising:

a defining module to define a subscription to the table;

an executing module to execute a query on the source database;

a normalizing module to normalize the query;

a determining module to determine whether the query would cause semantically appropriate changes to the target database; and

a sending module to send the normalized query to the target database for execution, if the determining module determines that the query would cause semantically appropriate changes to the target database.

8. The system of claim 7, further comprising:

a second sending module to send change data to the target database for execution, if the determining module determines that the query would not cause semantically appropriate changes to the target database.

9. The system of claim 7, wherein the determining module executes when the subscription is defined.

10. The system of claim 7, wherein the normalized query is sent as part of a transaction log.

11. The system of claim 10, wherein the transaction log comprises one or more transactions, the normalized query associated with one of the one or more transactions.

12. The system of claim 11, wherein the target database processes the transaction log by processing the one or more transactions in commit order.

13. A computer program product comprising a computer-usable medium having computer program logic recorded thereon for enabling a processor to replicate a table in a source database to a target database, the computer program logic comprising:

defining means for enabling a processor to define a subscription to the table;

executing means for enabling a processor to execute a query on the source database;

normalizing means for enabling a processor to normalize the query;

determining means for enabling a processor to determine whether the query would cause semantically appropriate changes to the target database; and

sending means for enabling a processor to send the normalized query to the target database for execution, if the determining means determines that the query would cause semantically appropriate changes to the target database.

14. The computer program logic of claim 13, further comprising:

second sending means for enabling a processor to send change data to the target database for execution, if the determining means determines that the query would not cause semantically appropriate changes to the target database.

15. The computer program logic of claim 13, wherein the determining means executes when the subscription is defined.

16. The computer program logic of claim 13, wherein the normalized query is sent as part of a transaction log.

17. The computer program logic of claim 16, wherein the transaction log comprises one or more transactions, the normalized query associated with one of the one or more transactions.

18. The computer program logic of claim 17, wherein the target database processes the transaction log by processing the one or more transactions in commit order.