# US 2019/0377807 A1 · Transforming data for a target schema

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2019/0377807 A1
- Document ID: US20190377807A1
- Status: Published application
- Kind: A1
- Application number: 16/004,863
- Filed: 2018-06-11
- Published: 2019-12-12
- Earliest claimed: 2018-06-11
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Daniel DEAN; Checed A. RODGERS; Dingcheng LI; Pei Ni LIU; Xiao Xi LIU; Hui LEI; Yu GU; Jing Min XU; Yaoping RUAN
- Web page: https://patentgrep.com/patent/US20190377807A1

## CPC

- G06F 16/211: {Schema design and management}
- G06F 16/258: {Data format conversion from or to a database}
- G06F 16/84: Mapping; Conversion
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Embodiments generally relate transforming data for a target schema. In some embodiments, a method includes receiving input data, where the input data includes a plurality of segments, and where the segments include a plurality of source fields containing target data. The method further includes characterizing the input data based at least in part on a plurality of predetermined metrics, where the predetermined metrics determine a structure of the input data. The method further includes mapping the target data in the source fields of the segments to a plurality of target fields of a target schema based at least in part on the characterizing. The method further includes populating the target fields of the target schema with the target data from the source fields based at least in part on the mapping.

## Claims

### Claim 1

A system comprising:
at least one processor and a computer readable storage medium having program instructions embodied therewith, the program instructions executable by the at least one processor to cause the at least one processor to perform operations comprising:
receiving input data, wherein the input data includes a plurality of segments, and wherein the segments include a plurality of source fields containing target data;
characterizing the input data based at least in part on a plurality of predetermined metrics, wherein the predetermined metrics determine a structure of the input data;
mapping the target data in the source fields of the segments to a plurality of target fields of a target schema based at least in part on the characterizing; and
populating the target fields of the target schema with the target data from the source fields based at least in part on the mapping.

### Claim 2 (depends on 1)

The system of claim 1, wherein the input data is semi-structured data.

### Claim 3 (depends on 1)

The system of claim 1, wherein the target schema is a structured schema.

### Claim 4 (depends on 1)

The system of claim 1, wherein, to characterize the input data, the at least one processor further performs operations comprising determining contextual information associated with the input data.

### Claim 5 (depends on 1)

The system of claim 1, wherein, to map the target data in the source fields of the segments to the target fields of a target schema, the at least one processor further performs operations comprising:
comparing each target field to contextual information associated with each segment; and
matching the target data in each source field to one of the target fields of the target schema based at least in part on the comparing of each target field to the contextual information.

### Claim 6 (depends on 1)

The system of claim 1, wherein the mapping of the target data in the source fields of the segments to the target fields of a target schema is based at least in part on confidence values, and wherein the confidence values indicate degrees of matching between the target data and one or more target fields.

### Claim 7 (depends on 1)

The system of claim 1, wherein, to map the target data in the source fields of the segments to the target fields of a target schema, the at least one processor further performs operations comprising:
determining confidence values, wherein the confidence values indicate degrees of matching between the target data and one or more target fields; and
matching the target data in the source fields to the target fields of the target schema.

### Claim 8

A computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by at least one processor to cause the at least one processor to perform operations comprising:
receiving input data, wherein the input data includes a plurality of segments, and wherein the segments include a plurality of source fields containing target data;
characterizing the input data based at least in part on a plurality of predetermined metrics, wherein the predetermined metrics determine a structure of the input data;
mapping the target data in the source fields of the segments to a plurality of target fields of a target schema based at least in part on the characterizing; and
populating the target fields of the target schema with the target data from the source fields based at least in part on the mapping.

### Claim 9 (depends on 8)

The computer program product of claim 8, wherein the input data is semi-structured data.

### Claim 10 (depends on 8)

The computer program product of claim 8, wherein the target schema is a structured schema.

### Claim 11 (depends on 8)

The computer program product of claim 8, wherein, to characterize the input data, the at least one processor further performs operations comprising determining contextual information associated with the input data.

### Claim 12 (depends on 8)

The computer program product of claim 8, wherein, to map the target data in the source fields of the segments to the target fields of a target schema, the at least one processor further performs operations comprising:
comparing each target field to contextual information associated with each segment; and
matching the target data in each source field to one of the target fields of the target schema based at least in part on the comparing of each target field to the contextual information.

### Claim 13 (depends on 8)

The computer program product of claim 8, wherein the mapping of the target data in the source fields of the segments to the target fields of a target schema is based at least in part on confidence values, and wherein the confidence values indicate degrees of matching between the target data and one or more target fields.

### Claim 14 (depends on 8)

The computer program product of claim 8, wherein, to map the target data in the source fields of the segments to the target fields of a target schema, the at least one processor further performs operations comprising:
determining confidence values, wherein the confidence values indicate degrees of matching between the target data and one or more target fields; and
matching the target data in the source fields to the target fields of the target schema.

### Claim 15

A computer-implemented method for transforming data for a target schema, the method comprising:
receiving input data, wherein the input data includes a plurality of segments, and wherein the segments include a plurality of source fields containing target data;
characterizing the input data based at least in part on a plurality of predetermined metrics, wherein the predetermined metrics determine a structure of the input data;
mapping the target data in the source fields of the segments to a plurality of target fields of a target schema based at least in part on the characterizing; and
populating the target fields of the target schema with the target data from the source fields based at least in part on the mapping.

### Claim 16 (depends on 15)

The method of claim 15, wherein the input data is semi-structured data.

### Claim 17 (depends on 15)

The method of claim 15, wherein the target schema is a structured schema.

### Claim 18 (depends on 15)

The method of claim 15, wherein, to characterize the input data, the method further comprises determining contextual information associated with the input data.

### Claim 19 (depends on 15)

The method of claim 15, wherein, to map the target data in the source fields of the segments to the target fields of a target schema, the method further comprises:
comparing each target field to contextual information associated with each segment; and
matching the target data in each source field to one of the target fields of the target schema based at least in part on the comparing of each target field to the contextual information.

### Claim 20 (depends on 15)

The method of claim 15, wherein the mapping of the target data in the source fields of the segments to the target fields of a target schema is based at least in part on confidence values, and wherein the confidence values indicate degrees of matching between the target data and one or more target fields.
