Computer-readable recording medium, execution control method, and information processing apparatus
AssigneeFujitsu Limited
InventorsHaruyasu Ueda, Takamitsu Maeda
Life of this patent
Estimating the term…
Abstract
A slave computer reads a plurality of input files that have different formats and generates, for each of the input files, an intermediate file that has added thereto, as a join key, data in a type of column that is common to the input files. The slave computer sorts data in each intermediate file in accordance with the join key. The slave computer extracts, from each intermediate file that has data sorted therein, data that has the format of each of the input files so as to generate a plurality of output files that have data sorted therein with respect to each of the input files. The slave computer inputs the plurality of output files generated to a join program that joins data.
Claims10
A non-transitory computer-readable recording medium having stored therein an execution control program that causes a computer to execute a process comprising:
- inputting a plurality of input files that have different formats;
- generating, from the plurality of input files, first intermediate files respectively, the first intermediate files having data added as a join key in a column of a type that is common across the different formats of the plurality of input files and data added as an input number that indicates a respective input file;
- generating second intermediate files by sorting data in the first intermediate files in accordance with the join key, a second intermediate file among the second intermediate files generated including the join key and the input number in association with data of a respective input file among the plurality of input files;
- generating a plurality of output files for each input number, an output file among the plurality of output files generated including the data of the respective input file which is extracted from a second intermediate file among the second intermediate files based on the input number that indicates the respective input file and being in a same format as the respective input file;
- and
- inputting the plurality of output files generated to a join program that processes joining data.
An execution control method comprising:
- reading a plurality of input files that have different formats;
- generating, from the plurality of input files, first intermediate files respectively, the first intermediate files having data added as a join key in a column of a type that is common across the different formats of the plurality of input files and data added as an input number that indicates a respective input file;
- generating second intermediate files by sorting data in the first intermediate files in accordance with the join key, a second intermediate file among the second intermediate files generated including the join key and the input number in association with data of a respective input file among the plurality of input files;
- generating, by a computer, a plurality of output files for each input number, an output file among the plurality of output files generated including data that the data of the respective input file which is extracted from a second intermediate file among the second intermediate files based on the input number that indicates the respective input file and being in a same format as the respective input file;
- and
- inputting the plurality of output files generated to a join program that joins data.
An information processing apparatus comprising:
- a memory;
- and
- a processor coupled to the memory, wherein the processor executes a process comprising:
- reading a plurality of input files that have different formats;
- generating, from the plurality of input files, first intermediate files respectively, the first intermediate files having data added as a join key in a column of a type that is common across the different formats the plurality of input files and data added as an input number that indicates a respective input file;
- generating second intermediate files by sorting data in the first intermediate files in accordance with the join key, a second intermediate file among the second intermediate files generated including the join key and the input number in association with data of a respective input file among the plurality of input files;
- generating a plurality of output files for each input number, an output file among the plurality of output files generated including the data of the respective input file which is extracted from a second intermediate file among the second intermediate files based on the input number that indicates the respective input file and being in a same format as the respective input file;
- and
- inputting the plurality of output files generated to a join program that joins data.
Dependencies are inferred from the claim text.