Data processing apparatus, data processing method, and data processing program stored on computer-readable storage medium

Patent metadata

Field	Value
Publication number	US-11663232-B2
Application number	US-201917268742-A
Country	US
Kind code	B2
Filing date	Feb 21, 2019
Priority date	Sep 6, 2018
Publication date	May 30, 2023
Grant date	May 30, 2023

Abstract

A data processing apparatus according to one or more embodiments may process metadata indicative of an attribute of real data input into an extract, transform, and load (ETL) tool external to the data processing apparatus. The real data and the metadata may each include an identification (ID). The data processing apparatus may include a memory and a processor. The memory may store a program. The processor may execute the program. The program may cause the processor to process the metadata to include the same ID as the real data output from the ETL tool.

First claim

The invention claimed is:

1. A data processing apparatus comprising:
a memory configured to store a program for processing metadata indicative of an attribute of real data input into an ETL tool external to the data processing apparatus, the ETL tool being an extract, transform, and load tool, the real data comprising a first identification identifying the real data and the metadata comprising a second identification identifying the metadata; and
a processor configured with the program
to perform operations comprising operation to process the metadata such that the second identification identifying the metadata comprises the same identification as an output identification identifying the real data output from the ETL tool.

2. The data processing apparatus according to claim 1 , wherein
prior to processing in the ETL tool, the first identification identifying the real data and the second identification identifying the metadata each share a common identification, and
the program causes the processor to perform operations comprising operation to change, in response to the first identification identifying the real data being changed by the ETL tool to the output identification different from the first identification, the second identification identifying the metadata to the output identification identifying the real data such that the real data and the metadata again share a common identification.

3. The data processing apparatus according to claim 2 , wherein
in response to determining that real data is changed or likely to be changed but the first identification identifying in the real data is not changed by the ETL tool, and
the program causes the processor to perform operations comprising operation to change the first identification identifying the real data before being input into the ETL tool and the second identification identifying the metadata to a new common identification.

4. The data processing apparatus according to claim 2 , wherein
the real data comprises sensing data generated by a sensor.

5. The data processing apparatus according to claim 1 , wherein
in response to determining that real data is changed or likely to be changed but the first identification identifying the real data is not changed by the ETL tool, and
the program causes the processor to perform operations comprising operation to change the first identification identifying the real data before being input into the ETL tool and the second identification identifying the metadata to a new common identification.

6. The data processing apparatus according to claim 5 , wherein
the real data comprises sensing data generated by a sensor.

7. The data processing apparatus according to claim 1 , wherein
the real data comprises sensing data generated by a sensor.

8. A data processing method comprising:
processing metadata indicative of an attribute of real data input into an ETL tool, the ETL tool being an extract, transform, and load tool, the real data comprising a first identification identifying the real data and the metadata comprising a second identification identifying the metadata; and
processing the metadata such that the second identification identifying the metadata comprises the same identification as an output identification identifying the real data output from the ETL tool.

9. A non-transitory computer-readable storage medium storing a data processing program, which when read and executed, causes a processor to perform operations comprising:
processing metadata indicative of an attribute of real data input into an ETL tool, the ETL tool being an extract, transform, and load tool, the real data comprising a first identification identifying the real data and the metadata comprising a second identification identifying the metadata; and
processing the metadata such that the second identification identifying the metadata comprises the same identification as an output identification identifying the real data output from the ETL tool.

Assignees

• Omron Tateisi Electronics Co

Inventors

• Yamato Tetsuji
• Yoshikawa Taiji

Classifications

• G06F16/24573

  using data annotations, e.g. user-defined metadata · CPC title

• G06F16/254 Primary

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title

• G06F16/258

  Data format conversion from or to a database · CPC title

• G06F12/00

  Accessing, addressing or allocating within memory systems or architectures (digital input from, or digital output to record carriers, e.g. to disk storage units, G06F3/06) · CPC title

• G06F16/248

  Presentation of query results · CPC title