Automated identification of complex transformations and generation of subscriptions for data replication
First Claim
Patent Images
1. A system for data replication comprising:
- at least one processor configured to;
identify one or more complex data transformations within database statements from source code files of installed software products on a target system, wherein the source code files on the target system are updated versions relative to corresponding ones of a source system, wherein the identified one or more complex data transformations are stored in an order reflecting an order of installation of the source code files on the target system, and wherein the one or more complex data transformations include one or more from a group of;
moving data from plural table columns to a common table column, moving data from plural database tables to a common database table, and changing column data using a formula;
create a subscription for each complex data transformation, the subscription containing generated instructions executable on the target system for transforming data within the source system into a form compatible with the target system according to the complex data transformation; and
execute the instructions of the subscriptions within the target system during data replication from the source system to the target system to perform the complex data transformations in the order reflecting the order of installation of the source code files and transform source data of the source system into a form compatible with the target system.
1 Assignment
0 Petitions
Accused Products
Abstract
According to embodiments of the present invention, machines, systems, methods and computer program products as part of a data replication process are provided. One or more complex transformations are identified from source code files of installed software products on a target system. A subscription is created for each complex transformation, the subscription containing instructions for transforming data within the source system into a form compatible with the target system. The instructions are executed within the target system to transform source data of the source system into a form compatible with the target system.
-
Citations
14 Claims
-
1. A system for data replication comprising:
at least one processor configured to; identify one or more complex data transformations within database statements from source code files of installed software products on a target system, wherein the source code files on the target system are updated versions relative to corresponding ones of a source system, wherein the identified one or more complex data transformations are stored in an order reflecting an order of installation of the source code files on the target system, and wherein the one or more complex data transformations include one or more from a group of;
moving data from plural table columns to a common table column, moving data from plural database tables to a common database table, and changing column data using a formula;create a subscription for each complex data transformation, the subscription containing generated instructions executable on the target system for transforming data within the source system into a form compatible with the target system according to the complex data transformation; and execute the instructions of the subscriptions within the target system during data replication from the source system to the target system to perform the complex data transformations in the order reflecting the order of installation of the source code files and transform source data of the source system into a form compatible with the target system. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
8. A computer program product for data replication comprising a computer readable storage medium having computer readable program instructions embodied therewith, the computer readable program instructions, when executed by a processor, cause the processor to:
-
identify one or more complex data transformations within database statements from source code files of installed software products on a target system, wherein the source code files on the target system are updated versions relative to corresponding ones of a source system, wherein the identified one or more complex data transformations are stored in an order reflecting an order of installation of the source code files on the target system, and wherein the one or more complex data transformations include one or more from a group of;
moving data from plural table columns to a common table column, moving data from plural database tables to a common database table, and changing column data using a formula;create a subscription for each complex data transformation, the subscription containing generated instructions executable on the target system for transforming data within the source system into a form compatible with the target system according to the complex data transformation; and execute the instructions of the subscriptions within the target system during data replication from the source system to the target system to perform the complex data transformations in the order reflecting the order of installation of the source code files and transform source data of the source system into a form compatible with the target system. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
Specification