System and method for implementing database replication configurations using replication modeling and transformation
First Claim
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, the replication configuration data including conflict handler information associated with the plurality of databases;
building, using the at least one processor, at least one memory model based on metadata accessed from the plurality of databases, wherein the at least one memory model is interlinked with a database Server Replication Model, a Table Level Replication Model, a Table Metadata Model, a Replication Configuration Information Model, a Table Replication Rule Model, and a Transformed Replication Configuration Information Model, and wherein the at least one memo model references to one or more objects in the Table Level Replication Model, the Table Metadata Model, the Replication Configuration Information Model, the Table Replication Rule Model, or the Transformed Replication Configuration Information Model;
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, wherein the user-identified modification includes configuring one or more properties of a conflict handler processor and adding a connection from one database of the plurality of databases to another database of the plurality of databases;
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, wherein the configurable target and source properties includes the one or more properties of the conflict handler processor;
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, wherein modifying the property of the first universal replication model includes 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, and wherein the second universal replication model includes;
a first conflict handler associated with a first database of the plurality of databases and a second conflict handler associated with a second database of the plurality of databases, the first database being configured for the first platform, and the second database being configured for a second platform,a first data extraction rule for the first database of the plurality of databases, the first data extraction rule being passed to the second conflict handler for detecting a first conflict, anda second data extraction rule for the second database of the plurality of databases, the second data extraction rule being passed to the first conflict handler for detecting a second conflict;
transforming, using the at least one processor, the second universal replication model to the 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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
21 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, the replication configuration data including conflict handler information associated with the plurality of databases; building, using the at least one processor, at least one memory model based on metadata accessed from the plurality of databases, wherein the at least one memory model is interlinked with a database Server Replication Model, a Table Level Replication Model, a Table Metadata Model, a Replication Configuration Information Model, a Table Replication Rule Model, and a Transformed Replication Configuration Information Model, and wherein the at least one memo model references to one or more objects in the Table Level Replication Model, the Table Metadata Model, the Replication Configuration Information Model, the Table Replication Rule Model, or the Transformed Replication Configuration Information Model; 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, wherein the user-identified modification includes configuring one or more properties of a conflict handler processor and adding a connection from one database of the plurality of databases to another database of the plurality of databases; 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, wherein the configurable target and source properties includes the one or more properties of the conflict handler processor; 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, wherein modifying the property of the first universal replication model includes 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, and wherein the second universal replication model includes; a first conflict handler associated with a first database of the plurality of databases and a second conflict handler associated with a second database of the plurality of databases, the first database being configured for the first platform, and the second database being configured for a second platform, a first data extraction rule for the first database of the plurality of databases, the first data extraction rule being passed to the second conflict handler for detecting a first conflict, and a second data extraction rule for the second database of the plurality of databases, the second data extraction rule being passed to the first conflict handler for detecting a second conflict; transforming, using the at least one processor, the second universal replication model to the 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. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
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, the replication configuration data including conflict handler information associated with the plurality of databases; building, using the at least one processor, at least one memory model based on metadata accessed from the plurality of databases, wherein the at least one memory model is interlinked with a database Server Replication Model, a Table Level Replication Model, a Table Metadata Model, a Replication Configuration Information Model, a Table Replication Rule Model, and a Transformed Replication Configuration Information Model, and wherein the at least one memory model references to one or more objects in the Table Level Replication Model, the Table Metadata Model, the Replication Configuration Information Model, the Table Replication Rule Model, or the Transformed Replication Configuration Information Model; 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, wherein the user-identified modification includes configuring one or more properties of a conflict handler processor and adding a connection from one database of the plurality of databases to another database of the plurality of databases; 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, wherein the configurable target and source properties includes the one or more properties of the conflict handler processor; 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, wherein modifying the property of the first universal replication model includes 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, and wherein the second universal replication model includes; a first conflict handler associated with a first database of the plurality of databases and a second conflict handler associated with a second database of the plurality of databases, the first database being configured for the first platform, and the second database being configured for a second platform, a first data extraction rule for the first database of the plurality of databases, the first data extraction rule being passed to the second conflict handler for detecting a first conflict, and a second data extraction rule for the second database of the plurality of databases, the second data extraction rule being passed to the first conflict handler for detecting a second conflict; transforming, using the at least one processor, the second universal replication model to the 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 east one processor, the at least one script to a second memory device. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
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, the replication configuration data including conflict handler information associated with the plurality of databases; building, using the at least one processor, at least one memory model based on metadata accessed from the plurality of databases, wherein the at least one memory model is interlinked with a database Server Replication Model, a Table Level Replication Model, a Table Metadata Model, a Replication Configuration Information Model, a Table Replication Rule Model, and a Transformed Replication Configuration information Model, and wherein the at least one memory model references to one or more objects in the Table Level Replication Model, the Table Metadata Model, the Replication Configuration Information Model, the Table Replication Rule Model, or the Transformed Replication Configuration Information Model; 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, wherein the user-identified modification includes configuring one or more properties of a conflict handler processor and adding connection from one database of the plurality of databases to another database of the plurality of databases; 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, wherein the configurable target and source properties includes the one or more properties of the conflict handler processor; 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, wherein modifying the property of the first universal replication model includes 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, and wherein the second universal replication model includes; a first conflict handler associated with a first database of the plurality of databases and a second conflict handler associated with a second database of the plurality of databases, the first database being configured for the first platform, and the second database being configured for a second platform, a first data extraction rule for the first database of the plurality of databases, the first data extraction rule being passed to the second conflict handler for detecting a first conflict, and a second data extraction rule for the second database of the plurality of databases, the second data extraction rule being passed to the first conflict handler for detecting a second conflict; transforming, using the at least one processor, the second universal replication model to the 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. - View Dependent Claims (16, 17, 18, 19, 20, 21)
-
Specification