METADATA PROCESSING METHOD, INFORMATION PROCESSING APPARATUS, AND RECORDING MEDIUM RECORDING METADATA PROCESSING PROGRAM

• US 20190317946A1
• Filed: 06/25/2019
• Published: 10/17/2019
• Est. Priority Date: 01/10/2017
• Status: Active Application

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Tago, Shinichiro, NISHINO, Fumihito
• Application Number:
  US16/451,618
• Publication Number:
  US 20190317946A1
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 8/00 Arrangements for software engineering testing or debugging G06F11/36; administrative, planning or organisation aspects of software project management G06Q10/06

Abstract

A non-transitory computer-readable recording medium having stores therein a metadata processing program for causing a computer to execute a process including: extracting, based on comparison between a first input item name of first input data and a first output item name of first output data, an element other than an element included in both of the first input item name and the first output item name; and generating, when the extracted element and an argument of a program which generates the first output data from the first input data include an element related to a first input item value of the first input data, metadata in which the element related to the first input item value in the extracted element is transformed into a variable.

Claims

1. A non-transitory computer-readable recording medium having stored therein a metadata processing program for causing a computer to execute a process comprising:

extracting, based on comparison between a first input item name of first input data and a first output item name of first output data, an element other than an element included in both of the first input item name and the first output item name; and

generating, when the extracted element and an argument of a program which generates the first output data from the first input data include an element related to a first input item value of the first input data, metadata in which the element related to the first input item value in the extracted element is transformed into a variable.

2. The non-transitory computer-readable recording medium according to claim 1, wherein

in the generating the metadata,

the metadata in which the element related to the first input item value in the extracted element is transformed into a variable, and the element included in both of the first input item name and the first output item name is transformed into a variable is generated.

3. The non-transitory computer-readable recording medium according to claim 1, wherein the process further includes:

extracting, based on comparison between a second input item name of second input data and a specified item name, an element other than an element included in both of the second input item name and the specified item name;

generating, when the extracted element includes an element related to a second input item value of the second input data, template data in which the element related to the second input item value in the extracted element is transformed into a variable;

rearranging columns of the second input data based on a correspondence relationship between elements included in the metadata and elements included in the template data; and

executing the program with the second input data of which the columns are rearranged as an input to generate second output data.

4. The non-transitory computer-readable recording medium according to claim 3, wherein

in the rearranging the columns of the second input data,

item names included in the template data are rearranged such that a format of the metadata matches a format of the template data, and the columns of the second input data are rearranged on the basis of a correspondence relationship between the elements included in the metadata and the elements included in the template data of which the item names are rearranged,

wherein the processing further includes executing the same rearrangement as rearrangement when restoring an arrangement of the item names included in the template data to an original arrangement, with respect to the columns of the second output data.

5. A metadata processing method comprising:

extracting, by a computer, based on comparison between a first input item name of first input data and a first output item name of first output data, an element other than an element included in both of the first input item name and the first output item name; and

generating, when the extracted element and an argument of a program which generates the first output data from the first input data include an element related to a first input item value of the first input data, metadata in which the element related to the first input item value in the extracted element is transformed into a variable.

6. The metadata processing method according to claim 5, wherein

in the generating the metadata,

the metadata in which the element related to the first input item value in the extracted element is transformed into a variable, and the element included in both of the first input item name and the first output item name is transformed into a variable is generated.

7. The metadata processing method according to claim 5, further comprising:

extracting, based on comparison between a second input item name of second input data and a specified item name, an element other than an element included in both of the second input item name and the specified item name;

generating, when the extracted element includes an element related to a second input item value of the second input data, template data in which the element related to the second input item value in the extracted element is transformed into a variable;

rearranging columns of the second input data based on a correspondence relationship between elements included in the metadata and elements included in the template data; and

executing the program with the second input data of which the columns are rearranged as an input to generate second output data.

8. The metadata processing method according to claim 7, wherein

in the rearranging the columns of the second input data,

item names included in the template data are rearranged such that a format of the metadata matches a format of the template data, and the columns of the second input data are rearranged on the basis of a correspondence relationship between the elements included in the metadata and the elements included in the template data of which the item names are rearranged,

wherein the method further includes executing the same rearrangement as rearrangement when restoring an arrangement of the item names included in the template data to an original arrangement, with respect to the columns of the second output data.

9. An information processing apparatus comprising:

a memory; and

a processor coupled to the memory and configured to execute a process of;

extracting, based on comparison between a first input item name of first input data and a first output item name of first output data, an element other than an element included in both of the first input item name and the first output item name; and

generating, when the extracted element and an argument of a program which generates the first output data from the first input data include an element related to a first input item value of the first input data, metadata in which the element related to the first input item value in the extracted element is transformed into a variable.

10. The information processing apparatus according to claim 9, wherein

in the generating the metadata,

the metadata in which the element related to the first input item value in the extracted element is transformed into a variable, and the element included in both of the first input item name and the first output item name is transformed into a variable is generated.

11. The information processing apparatus according to claim 9, wherein the process further includes:

extracting, based on comparison between a second input item name of second input data and a specified item name, an element other than an element included in both of the second input item name and the specified item name;

generating, when the extracted element includes an element related to a second input item value of the second input data, template data in which the element related to the second input item value in the extracted element is transformed into a variable;

rearranging columns of the second input data based on a correspondence relationship between elements included in the metadata and elements included in the template data; and

executing the program with the second input data of which the columns are rearranged as an input to generate second output data.

12. The information processing apparatus according to claim 11, wherein

in the rearranging the columns of the second input data,

item names included in the template data are rearranged such that a format of the metadata matches a format of the template data, and the columns of the second input data are rearranged on the basis of a correspondence relationship between the elements included in the metadata and the elements included in the template data of which the item names are rearranged,

wherein the processing further includes executing the same rearrangement as rearrangement when restoring an arrangement of the item names included in the template data to an original arrangement, with respect to the columns of the second output data.