Database creation and collision reduction

A computer-implemented method comprising:

• receiving, by a first computing system, a first input file of instructions, in a first language, for modifying content of a database comprising data organized into tables, wherein at least one instruction comprises an instruction to join a first table of the tables with a second table of the tables;
• executing the first input file, wherein execution of the first input file of instructions is associated with a first computing time interval;
• receiving, by the first computing system, 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 a second language representing the two or more input instructions in the first language;
• and
• one or more output values;
• translating, by the first computing system 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;
• sending, by the first computing system, the second input file via an API to a second computing system;
• receiving, by the first computing system from the second computing system, a first output file comprising one or more associated recommended replacement patterns;
• translating, by the first computing system 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 tables;
• receiving, by the first computing system, a user selection of one of the two or more alternative replacement patterns;
• replacing, by the first computing system, the content of the second output file with the selected replacement pattern and corresponding one or more output values;
• and
• modifying, by the first computing system based on modified first input file of instructions, the first table of the database,
• wherein the modifying the first table of the database, based on the modified first input file of instructions, is associated with a second computing time interval, and
• wherein the second computing time interval is shorter than the first computing time interval.

An apparatus for generating recommended replacement instructions relating to a first input file in a first language, wherein execution of the first input file is associated with a first computing time interval, the apparatus comprising:

• one or more processors;
• memory storing computer-executable instructions configured to, when executed by the one or more processors, cause the apparatus to:
• receive, from a first computing system via an application programming interface, a call in a second language with a payload of a second input file, wherein the application programming interface accepts files in the second language but not in the first language, wherein the second input file is a translation of the first input file in the first language into the second language, and wherein at least one instruction comprises an instruction to join a first table with a second table;
• retrieve 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;
• parse, based on the received second input file, the second input file into representations of the individual instructions and one or more patterns of relationships between the representations of the individual instructions of the second input file, wherein the one or more patterns of relationships comprise organizational structures between the representations of the individual instructions;
• store, based on the representations of the individual instructions, the one or more patterns of the relationships between the representations of the individual 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;
• generate, 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 one or more output values;
• and
• send, to the first computing system, the first output file for modifying the first input file based on the suggested replacement output instructions,
• wherein execution of the first input file modified by the suggested replacement output instructions is associated with a second computing time interval, and
• wherein the second computing time interval is shorter than the first computing time interval.

An apparatus for generating recommended replacement instructions relating to a first input file in a first language, the apparatus comprising:

• one or more processors;
• memory storing computer-executable instructions configured to, when executed by the one or more processors, cause the apparatus to:
• receive a first input file of instructions, in a first language, for modifying content of a database comprising data organized into tables, wherein at least one instruction comprises an instruction to join a first table of the tables with a second table of the tables;
• execute the first input file of instructions, wherein execution of the first input file of instructions is associated with a first computing time interval;
• receive 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 a second language representing the two or more input instructions in the first language;
• and
• one or more output values;
• translate, 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;
• send the second input file via an API to a remote computing system;
• receive, from the remote computing system, a first output file from the remote computing system comprising one or more associated recommended replacement patterns;
• translate, 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 two tables;
• receive a user selection of one of the two or more alternative replacement patterns;
• replace the content of the second output file with the selected replacement pattern and corresponding one or more output values;
• and
• modify, based on modified first input file of instructions, the first table of the database,
• wherein the computer-executable instructions to modify the first table of the database, based on the modified first input file of instructions, are associated with a second computing time interval, and
• wherein the second computing time interval is shorter than the first computing time interval.