SYSTEM AND METHOD FOR IMPLEMENTING DATABASE REPLICATION CONFIGURTIONS USING REPLICATION MODELING AND TRANSFORMATION

• US 20140365437A1
• Filed: 08/06/2013
• Published: 12/11/2014
• Est. Priority Date: 06/07/2013
• Status: Active Grant

• Current Assignee: Wipro Limited
• Original Assignee: Wipro Limited
• Inventors: SRINIVASAN, Velmurugan
• Granted Patent: US 9,679,037 B2
• Time in Patent Office: Days
• US Class Current: 707/634
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/23 Updating
• 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 reverse engineering database replication data system is disclosed. In one embodiment, the replication data system receives an input of replication configuration data for a plurality of databases and builds memory models based on metadata accessed from the plurality of databases, which are then transformed to a first platform-specific replication model. Then, based on the first platform-specific replication model, a first universal replication model is configured, which is used to create a replication visual model using the rendering canvas. A user may modify the first universal replication model using the replication visual model to create a second universal replication model, which is then transformed to a second platform-specific replication model. Finally, scripts are generated for the second platform-specific replication model, which are then provided to a memory device.

Claims

1. A method for reverse engineering database replication configuration data performed by at least one processor connected to a plurality of databases, the method comprising:

receiving, using the at least one processor, an input of replication configuration data for a plurality of databases;

building, using the at least one processor, at least one memory model based on metadata accessed from the plurality of databases;

transforming, using the at least one processor and based on the replication configuration data, the at least one memory model to a first platform-specific replication model, the first platform-specific replication model being configured for a first platform;

generating, using the at least one processor and based on the first platform-specific replication model, a first universal replication model configured for a plurality of platforms, the first universal replication model including a rendering canvas configured to receive at least one user-identified modification of the first universal replication model;

creating, using the at least one processor and based on the first universal replication model, a replication visual model using the rendering canvas, the replication visual model including configurable target and source properties;

modifying, using the at least one processor, a property of the first universal replication model using the replication visual model to create a second universal replication model;

transforming, using the at least one processor, the second universal replication model to a second platform-specific replication model, the second platform-specific replication model being configured for a second platform;

generating, using the at least one processor, at least one script based on the second platform-specific replication model; and

providing, using the at least one processor, the at least one script to a memory device.

2. The method of claim 1, wherein the metadata comprises table metadata derived from the plurality of databases.

3. The method of claim 1, wherein the second universal replication model includes a conflict handler based on the target and source properties.

4. The method of claim 1, wherein the rendering canvas includes at least one of a graphical view, a grid view, or a tree view.

5. The method of claim 1, wherein a subset of the plurality of databases is displayed in the rendering canvas.

6. The method of claim 1, wherein the at least one user-identified modification comprises at least one of:

adding a table;

adding a connection from one database of the plurality of databases to another database of the plurality of databases;

modifying existing configurations of the plurality of databases;

linking a first table of a first database of the plurality of databases to a second table of a second database of the plurality of databases;

adding a rule;

modifying a rule;

adding a conflict handler;

or

modifying a conflict handler.

7. The method of claim 1, wherein the plurality of databases is in active-active or active-passive configuration.

8. A system for reverse engineering database replication configuration data, comprising:

at least one processor connected to a plurality of databases; and

a memory device operatively connected to the at least one processor and storing processor-executable instructions for;

receiving, using the at least one processor, an input of replication configuration data for a plurality of databases;

building, using the at least one processor, at least one memory model based on metadata accessed from the plurality of databases;

transforming, using the at least one processor and based on the replication configuration data, the at least one memory model to a first platform-specific replication model, the first platform-specific replication model being configured for a first platform;

generating, using the at least one processor and based on the first platform-specific replication model, a first universal replication model configured for a plurality of platforms, the first universal replication model including a rendering canvas configured to receive at least one user-identified modification of the first universal replication model;

creating, using the at least one processor and based on the first universal replication model, a replication visual model using the rendering canvas, the replication visual model including configurable target and source properties;

modifying, using the at least one processor, a property of the first universal replication model using the replication visual model to create a second universal replication model;

transforming, using the at least one processor, the second universal replication model to a second platform-specific replication model, the second platform-specific replication model being configured for a second platform;

generating, using the at least one processor, at least one script based on the second platform-specific replication model; and

providing, using the at least one processor, the at least one script to a second memory device.

9. The system of claim 8, wherein the metadata comprises table metadata derived from the plurality of databases.

10. The system of claim 8, wherein the second universal replication model includes a conflict handler based on the target and source properties.

11. The system of claim 8, wherein the rendering canvas includes at least one of a graphical view, a grid view, or a tree view.

12. The system of claim 8, wherein a subset of the plurality of databases is displayed in the rendering canvas.

13. The system of claim 8, wherein the at least one user-identified modification comprises at least one of:

adding a table;

adding a connection from one database of the plurality of databases to another database of the plurality of databases;

modifying existing configurations of the plurality of databases;

linking a first table of a first database of the plurality of databases to a second table of a second database of the plurality of databases;

adding a rule;

modifying a rule;

adding a conflict handler;

or

modifying a conflict handler.

14. The system of claim 8, wherein the plurality of databases is in active-active or active-passive configuration.

15. A non-transitory computer-readable storage medium containing instructions to configure at least one processor connected to a plurality of databases to perform a method for reverse engineering database replication configuration data, the method comprising:

receiving, using the at least one processor, an input of replication configuration data for a plurality of databases;

building, using the at least one processor, at least one memory model based on metadata accessed from the plurality of databases;

transforming, using the at least one processor and based on the replication configuration data, the at least one memory model to a first platform-specific replication model, the first platform-specific replication model being configured for a first platform;

generating, using the at least one processor and based on the first platform-specific replication model, a first universal replication model configured for a plurality of platforms, the first universal replication model including a rendering canvas configured to receive at least one user-identified modification of the first universal replication model;

creating, using the at least one processor and based on the first universal replication model, a replication visual model using the rendering canvas, the replication visual model including configurable target and source properties;

modifying, using the at least one processor, a property of the first universal replication model using the replication visual model to create a second universal replication model;

transforming, using the at least one processor, the second universal replication model to a second platform-specific replication model, the second platform-specific replication model being configured for a second platform;

generating, using the at least one processor, at least one script based on the second platform-specific replication model; and

providing, using the at least one processor, the at least one script to a memory device.

16. The non-transitory computer-readable storage medium of claim 15, wherein the metadata comprises table metadata derived from the plurality of databases.

17. The non-transitory computer-readable storage medium of claim 15, wherein the second universal replication model includes a conflict handler based on the target and source properties.

18. The non-transitory computer-readable storage medium of claim 15, wherein the rendering canvas includes at least one of a graphical view, a grid view, or a tree view.

19. The non-transitory computer-readable storage medium of claim 15, wherein a subset of the plurality of databases is displayed in the rendering canvas.

20. The non-transitory computer-readable storage medium of claim 15, wherein the at least one user-identified modification comprises at least one of:

adding a table;

adding a connection from one database of the plurality of databases to another database of the plurality of databases;

modifying existing configurations of the plurality of databases;

linking a first table of a first database of the plurality of databases to a second table of a second database of the plurality of databases;

adding a rule;

modifying a rule;

adding a conflict handler;

or

modifying a conflict handler.

21. The non-transitory computer-readable storage medium of claim 15, wherein the plurality of databases is in active-active or active-passive configuration.