Transformation rule generation and validation

One or more non-transitory computer-readable storage media storing computer-executable instructions for causing a computing system to perform a method, the method comprising:

• receiving an alignment between a source database and a target database, wherein the alignment comprises one or more mappings respectively comprising one or more source fields in the source database and a target field in the target database;
• for the respective one or more mappings, identifying one or more transformation functions applicable to the respective mappings;
• for the respective one or more mappings, generating one or more sets of transformation rules based on the respective one or more source fields, the respective target field, and the respective one or more transformation functions;
• for the respective one or more mappings, evaluating the respective sets of transformation rules via one or more classifiers based on source instance data from the source database, target instance data from the target database, and test data generated via the transformation rules;
• and
• providing the one or more sets of generated transformation rules in association with their respective evaluation results.

A system comprising:

• one or more memories;
• one or more processing units coupled to the one or more memories;
• and
• one or more computer-readable storage media storing instructions that, when loaded into the one or more memories, cause the one or more processing units to perform operations comprising:
• receiving an alignment between a source database and a target database, wherein the alignment comprises one or more mappings respectively comprising one or more source fields in the source database and a target field in the target database;
• identifying one or more transformation functions applicable to a given mapping of the one or more mappings of the alignment;
• generating a set of transformation rules based on the one or more source fields of the given mapping, the target field of the given mapping, and the one or more identified transformation functions, wherein generating the set of transformation rules comprises generating rules for respective combinations of the one or more source fields and the one or more identified transformation functions;
• identifying one or more transformation rule classifiers applicable to the given mapping of the one or more mappings of the alignment, wherein the transformation rule classifiers are machine-learning classification algorithms;
• evaluating the set of transformation rules via the one or more transformation rule classifiers based on source instance data from the source database, target instance data from the target database, and test data generated via the transformation rules, wherein the evaluating comprises generating respective confidence scores for the respective rules in the set of transformation rules;
• and
• providing the set of generated transformation rules in association with their respective confidence scores.