Table generation based on scripts for existing tables

A table generation device comprising:

• a memory;
• and
• a processor coupled to the memory and configured to:
• acquire a first input table used for generating a target table, based on target table information indicating a column included in the target table to be generated;
• acquire a script for generating a first output table from the first input table, and a constraint model indicating a constraint condition between a column included in the first input table and a column included in the first output table;
• convert the first input table into a second input table such that the second input table obtained by converting a column structure of the first input table and a second output table to be obtained by converting a column structure of the target table comply with the constraint condition, and generate assignment information indicating a correspondence relationship between a column to be included in the second output table and a column included in the target table;
• generate the second output table from the script and the second input table, and convert the second output table into the target table, based on the assignment information;
• estimate a constraint relationship between a column of the first input table and a column of the target table, based on a column name of a column included in the first input table and a column name of a column included in the target table;
• and
• assign the column included in the first input table to the input slot and assigning the column included in the target table to the output slot, based on the constraint condition indicated by the constraint model and the estimated constraint relationship,
• the constraint model includes an input slot indicating a position of the column included in the first input table, an output slot indicating a position of the column included in the first output table, and the constraint condition specified for the input slot and the output slot, and
• the assigning includes determining an assignment of a column of the original table or a column of the target table by preferring a slot having a larger number of constraints existing between slots other than the input and output slots among a plurality of slots including the input slot and the output slot.

A non-transitory, computer-readable recording medium having stored therein a program for causing a computer included in a table generation device to execute a process comprising:

• acquiring a first input table used for generating a target table, based on target table information indicating a column included in the target table to be generated;
• acquiring a script for generating a first output table from the first input table, and a constraint model indicating a constraint condition between a column included in the first input table and a column included in the first output table;
• converting the first input table into a second input table such that the second input table obtained by converting a column structure of the first input table and a second output table to be obtained by converting a column structure of the target table comply with the constraint condition, and generating assignment information indicating a correspondence relationship between a column to be included in the second output table and a column included in the target table;
• generating the second output table from the script and the second input table, and converting the second output table into the target table, based on the assignment information;
• estimating a constraint relationship between a column of the first input table and a column of the target table, based on a column name of a column included in the first input table and a column name of a column included in the target table;
• and
• assigning the column included in the first input table to the input slot and assigning the column included in the target table to the output slot, based on the constraint condition indicated by the constraint model and the estimated constraint relationship,
• the constraint model includes an input slot indicating a position of the column included in the first input table, an output slot indicating a position of the column included in the first output table, and the constraint condition specified for the input slot and the output slot, and
• the assigning includes determining an assignment of a column of the original table or a column of the target table by preferring a slot having a larger number of constraints existing between slots other than the input and output slots among a plurality of slots including the input slot and the output slot.