Data transformation methodology using generated program code and token mappings

Patent metadata

Field	Value
Publication number	US-11928126-B1
Application number	US-202217821309-A
Country	US
Kind code	B1
Filing date	Aug 22, 2022
Priority date	Aug 22, 2022
Publication date	Mar 12, 2024
Grant date	Mar 12, 2024

Abstract

A computer implemented method transforms data. Responsive to receiving a data transformation of an input string to an output string, a computer system identifies mappable tokens in the input string that are mappable to the output string. The computer system creates a set of initial mappings for a set of common tokens in the mappable tokens. The set of initial mappings maps the set of common tokens from the input string to the output string. The computer system creates a set of user mappings that maps the mappable tokens from input string to the output string using a user input to the set of initial mappings. The computer system generates program code that transform input strings to output strings using the set of user mappings that maps the mappable tokens from input string to the output string, wherein the program code is used to transform input strings to output strings.

First claim

What is claimed is:

1. A computer implemented method for transforming data, the computer implemented method comprising:
responsive to receiving a data transformation of an input string to an output string, identifying, by a computer system, mappable tokens in the input string that are mappable to the output string,
creating, by the computer system, a set of initial mappings for a set of common tokens in the mappable tokens, wherein the set of initial mappings maps the set of common tokens from the input string to the output string that match one another;
creating, by the computer system, a set of user mappings that maps the mappable tokens from input string to the output string using a user input to the set of initial mappings;
generating, by the computer system, program code that transform input strings to output strings using the set of user mappings that maps the mappable tokens from input string to the output string, wherein the program code is used to transform input strings to output strings;
identifying, by the computer system, a set of initial token properties for the mappable tokens in the set of user mappings;
creating, by the computer system, a set of user token properties using an additional user input to the set of initial token properties; and
performing, by the computer system, data transformation of the input strings to the output strings using the program code, wherein generating, by the computer system, the program code for mapping the input string to the output string using the set of user mappings comprises:
creating, by the computer system, the program code for mapping the input string to the output string using the set of user mappings and the set of user token properties.

2. The computer implemented method of claim 1 , wherein the user input to the set of initial mappings is selected from one of a confirmation of the set of initial mappings and a modification to the set of initial mappings.

3. The computer implemented method of claim 1 , wherein the additional user input to the set of initial token properties is selected from one of a confirmation of the set of initial token properties and a modification to the set of initial token properties.

4. A computer system comprising:
comprising a number of processor units, wherein the number of processor units executes program instructions to:
responsive to receiving a data transformation of an input string to an output string, identify mappable tokens in the input string that are mappable to the output string,
create a set of initial mappings for a set of common tokens in the mappable tokens, wherein the set of initial mappings maps the set of common tokens from the input string to the output string that match one another;
create a set of user mappings that maps the mappable tokens from input string to the output string using a user input to the set of initial mappings;
generate, program code that transform input strings to output strings using the set of user mappings that maps the mappable tokens from input string to the output string, wherein the program code is used to transform input strings to output strings;
identify a set of initial token properties for the mappable tokens in the set of user mappings;
create a set of user token properties using an additional user input to the set of initial token properties; and
perform, by the computer system, data transformation of the input strings to the output strings using the program code, wherein in generating, by the computer system, the program code for mapping the input string to the output string using the set of user mappings, wherein the number of processor units executes program instructions to:
create the program code for mapping the input string to the output string using the set of user mappings and the set of user token properties.

5. The computer system of claim 4 , wherein the user input to the set of initial mappings is selected from one of a confirmation of the set of initial mappings and a modification to the set of initial mappings.

6. The computer system of claim 4 , wherein the additional user input to the set of initial token properties is selected from one of a confirmation of the set of initial token properties and a modification to the set of initial token properties.

7. A computer program product for transforming data, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computer system to cause the computer system to perform a method of:
responsive to receiving a data transformation of an input string to an output string, identifying, by a computer system, mappable tokens in the input string that are mappable to the output string,
creating, by the computer system, a set of initial mappings for a set of common tokens in the mappable tokens, wherein the set of initial mappings maps the set of common tokens from the input string to the output string that match one another;
creating, by the computer system, a set of user mappings that maps the mappable tokens from input string to the output string using a user input to the set of initial mappings;
generating, by the computer system, program code that transform input strings to output strings using the set of user mappings that maps the mappable tokens from input string to the output string, wherein the program code is used to transform input strings to output strings;
identifying, by the computer system, a set of initial token properties for the mappable tokens in the set of user mappings;
creating, by the computer system, a set of user token properties using an additional user input to the set of initial token properties; and
performing, by the computer system, data transformation of the input strings to the output strings using the program code, wherein generating, by the computer system, the program code for mapping the input string to the output string using the set of user mappings comprises:
creating, by the computer system, program code for mapping the input string to the output string using the set of user mappings and the set of user token properties.

8. The computer program product of claim 7 , wherein the user input to the set of initial mappings is selected from one of a confirmation of the set of initial mappings and a modification to the set of initial mappings.

9. The computer program product claim 7 , wherein the additional user input to the set of initial token properties is selected from one of a confirmation of the set of initial token properties and a modification to the set of initial token properties.

Assignees

• IBM

Inventors

• Guttula Shanmukha Chaitanya
• Lohia Pranay Kumar
• Gupta Nitin
• Patel Hima

Classifications

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title

• G06F16/86

  Mapping to a database · CPC title