# US 2025/0165231 A1 · User-centric and llm-enhanced adaptive etl code synthesis

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

- Number: US 2025/0165231 A1
- Document ID: US20250165231A1
- Status: Published application
- Kind: A1
- Application number: 18/516,801
- Filed: 2023-11-21
- Published: 2025-05-22
- Earliest claimed: 2023-11-21
- Assignees: Hitachi, Ltd.
- Applicants: HITACHI, Ltd.
- Inventors: Sudhanshu GAUR; Takuya HABARA; Shoji YUNOKI
- Web page: https://patentgrep.com/patent/US20250165231A1

## CPC

- G06F 8/35: model driven
- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F 8/36: Software reuse
- G06F 11/3495: {for systems}
- G06F 16/211: {Schema design and management}
- G06F 16/221: {Column-oriented storage; Management thereof}
- G06F 16/24522: {Translation of natural language queries to structured queries}
- G06F 16/24544: {Join order optimisation}
- G06F 16/2456: {Join operations}
- G06F 16/2458: Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F 16/248: Presentation of query results
- G06F 16/285: {Clustering or classification}
- G06F 16/3322: {using system suggestions (G06F16/3325 takes precedence)}
- G06F 16/3328: {using graphical result space presentation or visualisation}
- G06F 16/3329: Natural language query formulation
- G06F 16/335: Filtering based on additional data, e.g. user or group profiles (filtering in web context G06F16/9535, G06F16/9536)
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Systems and methods described herein involve program code generation for data processing programs, which can involve, for receipt of a user prompt, reference a prompt database that associates historical prompts, program code generated from the historical prompts, and information indicative of whether execution results of the program code were expected to generate a combined prompt from the user prompt and a historical prompt from the historical prompts determined to be related to the combined prompt from the referencing; reference a program template database that associates combinations of the historical prompts and historical program code that was verified to work as expected to generate program code with the combined prompt; and execute the generated program code and the combined prompt for the data processing programs.

## Claims

### Claim 1

A method for program code generation for data processing programs, comprising:
for receipt of a user prompt:
referencing a prompt database that associates historical prompts, program code generated from the historical prompts, and information indicative of whether execution results of the program code were expected to generate a combined prompt from the user prompt and a historical prompt from the historical prompts determined to be related to the combined prompt from the referencing;
referencing a program template database that associates combinations of the historical prompts and historical program code that was verified to work as expected to generate program code with the combined prompt; and
executing the generated program code and the combined prompt for the data processing programs.

### Claim 2 (depends on 1)

The method of claim 1, further comprising, for the execution of the generated program code and the combined prompt determined to work as expected:
separating and storing parameters from the generated program code and the combined prompt; and
for receipt of a subsequent user prompt being similar to the combined prompt:
replacing parameters of the generated program code with parameters associated with the subsequent user prompt; and
executing the generated program code with the parameters associated with the subsequent user prompt.

### Claim 3 (depends on 1)

The method of claim 1, further comprising:
storing the combined prompt, the generated program code prompt, and information indicating whether the execution of the generated program code and the combined prompt had an expected result in the prompt database.

### Claim 4 (depends on 1)

The method of claim 1, further comprising:
generating the program code using the historical prompts in the prompt database associated with program code associated with the information indicative of the execution results not being expected.

### Claim 5 (depends on 1)

The method of claim 1, wherein the data processing programs are part of an extract, transfer, load (ETL) system.

### Claim 6 (depends on 1)

The method of claim 1, wherein the data processing programs are part of a data analytics system.

### Claim 7 (depends on 1)

The method of claim 1, wherein the executing the generated program code and the combined prompt for the data processing programs is conducted by a generative artificial intelligence process configured to intake the combined prompt and the generated code and execute a process based on the combined prompt and the generated code.

### Claim 8 (depends on 1)

The method of claim 1, further comprising, for the referencing the prompt database resulting in none of the historical prompts being determined to be related to the user prompt, including the user prompt into the prompt database and executing a generative artificial intelligence process on the user prompt to execute a process based on the user prompt.

### Claim 9

A non-transitory computer readable medium, storing instructions for program code generation for data processing programs, comprising:
for receipt of a user prompt:
referencing a prompt database that associates historical prompts, program code generated from the historical prompts, and information indicative of whether execution results of the program code were expected to generate a combined prompt from the user prompt and a historical prompt from the historical prompts determined to be related to the combined prompt from the referencing;
referencing a program template database that associates combinations of the historical prompts and historical program code that was verified to work as expected to generate program code with the combined prompt; and
executing the generated program code and the combined prompt for the data processing programs.

### Claim 10 (depends on 9)

The non-transitory computer readable medium of claim 9, the instructions further comprising, for the execution of the generated program code and the combined prompt determined to work as expected:
separating and storing parameters from the generated program code and the combined prompt; and
for receipt of a subsequent user prompt being similar to the combined prompt:
replacing parameters of the generated program code with parameters associated with the subsequent user prompt; and
executing the generated program code with the parameters associated with the subsequent user prompt.

### Claim 11 (depends on 9)

The non-transitory computer readable medium of claim 9, the instructions further comprising:
storing the combined prompt, the generated program code prompt, and information indicating whether the execution of the generated program code and the combined prompt had an expected result in the prompt database.

### Claim 12 (depends on 9)

The non-transitory computer readable medium of claim 9, the instructions further comprising:
generating the program code using the historical prompts in the prompt database associated with program code associated with the information indicative of the execution results not being expected.

### Claim 13 (depends on 9)

The non-transitory computer readable medium of claim 9, wherein the data processing programs are part of an extract, transfer, load (ETL) system.

### Claim 14 (depends on 9)

The non-transitory computer readable medium of claim 9, wherein the data processing programs are part of a data analytics system.

### Claim 15 (depends on 9)

The non-transitory computer readable medium of claim 9, wherein the executing the generated program code and the combined prompt for the data processing programs is conducted by a generative artificial intelligence process configured to intake the combined prompt and the generated code and execute a process based on the combined prompt and the generated code.

### Claim 16 (depends on 9)

The non-transitory computer readable medium of claim 9, further comprising, for the referencing the prompt database resulting in none of the historical prompts being determined to be related to the user prompt, including the user prompt into the prompt database and executing a generative artificial intelligence process on the user prompt to execute a process based on the user prompt.

### Claim 17

An apparatus, storing instructions for program code generation for data processing programs, comprising:
a processor, configured to, for receipt of a user prompt:
reference a prompt database that associates historical prompts, program code generated from the historical prompts, and information indicative of whether execution results of the program code were expected to generate a combined prompt from the user prompt and a historical prompt from the historical prompts determined to be related to the combined prompt from the referencing of the prompt database;
reference a program template database that associates combinations of the historical prompts and historical program code that was verified to work as expected to generate program code with the combined prompt; and
execute the generated program code and the combined prompt for the data processing programs.
