| CPC G06F 16/24564 (2019.01) [G06F 9/54 (2013.01); G06F 16/221 (2019.01); G06F 16/2282 (2019.01); G06F 16/2423 (2019.01); G06F 16/24534 (2019.01)] | 23 Claims |
|
1. A computer-implemented method for generating recommended replacements for a set of instructions, in a first language, based on known replacement patterns associated with instructions in a second language, the computer-implemented method comprising:
receiving, by an authoring computing system, a first input file of instructions, in a first language, for modifying content of a database comprising data organized into one or more tables, wherein at least one instruction comprises an instruction to join a first table of the one or more tables with a second table of the one or more tables;
receiving a set of rules, at least one rule comprising:
an identification of two or more input instructions of the first language, wherein the instructions comprise one or more of statements for modifying content of tables;
an identification of an input order between the two or more input instructions;
an identification of input values used by the two or more input instructions;
two or more output instructions in the second language representing the two or more input instructions in the first language; and
one or more output values;
translating, based on the set of rules, the first input file in the first language into a second input file in the second language, wherein translating the first input file comprises replacing input instructions in the first language with representations of the input instructions in the second language;
exposing, by a recommendation computing system and as a service, a process that analyzes the second input file;
receiving, by the recommendation computing system and via an application programming interface, a call in the second language with a payload of the second input file, wherein the application programming interface accepts files in the second language but not in the first language;
retrieving, by the recommendation computing system, a collection of known patterns in the second language and associated recommended replacement patterns in the second language, wherein the known patterns comprise identification of individual instructions and organizational structures comprising relationships between two or more individual instructions, and wherein at least one known pattern comprises joining two tables;
parsing, based on the received second input file and by the recommendation computing system, the second input file into representations of the instructions and one or more patterns of relationships between the representations of the instructions of the second input file, wherein the one or more patterns of relationships comprise organizational structures between the representations of the instructions;
storing, based on the representations of the instructions, the one or more patterns of the relationships between the representations of the instructions, and the collection of known patterns, one or more known patterns that correspond to the one or more patterns of the relationships, wherein at least one of the one or more known patterns comprises the at least one known pattern for joining the two tables;
generating, based on the stored one or more known patterns that correspond to the one or more patterns of the relationships, a first output file in the second language, wherein the first output file contains identified portions of the received second input file corresponding to the stored one or more known patterns, associated recommended replacement patterns as suggested replacement output instructions, and the one or more output values;
sending, by the recommendation computing system and to the authoring computing system, the first output file;
translating, by the authoring computing system and based on the set of rules, the first output file, in the second language, into a second output file in the first language, wherein the second output file includes, for at least one of the one or more associated recommended replacement patterns, two or more alternative replacement patterns for the at least one instruction to join the one or more tables with the joining table;
receiving, by the authoring computing system, a user selection of one of the two or more alternative replacement patterns; and
replacing the content of the second output file with the selected replacement pattern and corresponding output values.
|