# US 2026/0093916 A1 · Expanding abbreviated column names in tabular data using artificial intelligence models

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

- Number: US 2026/0093916 A1
- Document ID: US20260093916A1
- Status: Published application
- Kind: A1
- Application number: 18/899,163
- Filed: 2024-09-27
- Published: 2026-04-02
- Earliest claimed: 2024-09-27
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Michael Joseph Loughran; Niall Jordan; MARY O'NEILL
- Web page: https://patentgrep.com/patent/US20260093916A1

## CPC

- G06F 40/274: Converting codes to words; Guess-ahead of partial word inputs
- G06F 16/3329: Natural language query formulation
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method, system, and computer program product are configured to: extract, from metadata of a table in a database, a table name abbreviation of the table and plural column name abbreviations of plural columns in the table; automatically generate a prompt for an artificial intelligence (AI) model, the prompt including the table name abbreviation, the plural column name abbreviations, and an instruction to expand the table name abbreviation and the plural column name abbreviations; provide the prompt to the AI model using a single call to the AI model; receive an output generated by the AI model based on the prompt; and process the output.

## Claims

### Claim 1

A computer implemented method, comprising:
receiving, by a processor set and via a user interface, a user input identifying a table in a database;
extracting, by the processor set and from metadata of the database, a table name abbreviation of the table and plural column name abbreviations of plural columns in the table;
automatically generating, by the processor set, a prompt for an artificial intelligence (AI) model, the prompt including the table name abbreviation, the plural column name abbreviations, and an instruction to expand the table name abbreviation and the plural column name abbreviations;
providing, by the processor set, the prompt to the AI model;
receiving, by the processor set, an output generated by the AI model based on the prompt; and
processing, by the processor set, the output.

### Claim 2 (depends on 1)

The computer-implemented method of claim 1, wherein the output includes:
an expanded table name corresponding to the table name abbreviation; and
plural expanded column names corresponding, respectively, to the plural column name abbreviations.

### Claim 3 (depends on 2)

The computer-implemented method of claim 2, wherein the processing the output comprises automatically generating and storing a glossary of terms that:
equates the table name abbreviation to the expanded table name; and
equates respective ones of the plural column name abbreviations to respective ones of the plural expanded column names.

### Claim 4 (depends on 2)

The computer-implemented method of claim 2, wherein the processing the output comprises automatically modifying the table in the database by adding labels to the plural columns in the table, wherein each respective one of the labels includes a respective one of the plural expanded column names corresponding to a respective one of the plural column name abbreviations.

### Claim 5 (depends on 2)

The computer-implemented method of claim 2, wherein the processing the output comprises automatically modifying the database by storing metadata links between respective ones of the plural column name abbreviations and respective ones of the plural expanded column names.

### Claim 6 (depends on 2)

The computer-implemented method of claim 2, wherein the processing the output comprises:
analyzing the output by comparing the output to one or more ground truths; and
generating a report that includes a result of the analyzing.

### Claim 7 (depends on 1)

The computer-implemented method of claim 1, wherein the automatically generating the prompt comprises:
obtaining a predefined prompt format for the AI model; and
arranging the table name abbreviation and the plural column name abbreviations in a JavaScript Object Notation format in the predefined prompt format.

### Claim 8 (depends on 1)

The computer-implemented method of claim 1, further comprising receiving user input selecting the AI model from plural AI models that are available to the user, wherein the generating the prompt for the AI model comprises generating the prompt using one of plural predefined prompt formats that is specific to the AI model selected.

### Claim 9 (depends on 1)

The computer-implemented method of claim 1, wherein the plural columns constitute all the columns in the table, such that the AI model expands all the plural column name abbreviations of the table in a single call.

### Claim 10 (depends on 1)

The computer-implemented method of claim 1, wherein the prompt includes one or more examples each comprising an abbreviation and an expansion of the abbreviation.

### Claim 11 (depends on 1)

The computer-implemented method of claim 1, wherein the AI model comprises a trained generative AI model.

### Claim 12 (depends on 1)

The computer-implemented method of claim 1, wherein the AI model comprises a trained large language model.

### Claim 13

A computer program product comprising one or more computer readable storage media having program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:
extract, from metadata of a table in a database, a table name abbreviation of the table and plural column name abbreviations of plural columns in the table;
automatically generate a prompt for an artificial intelligence (AI) model, the prompt including the table name abbreviation, the plural column name abbreviations, and an instruction to expand the table name abbreviation and the plural column name abbreviations;
provide the prompt to the AI model using a single call to the AI model;
receive an output generated by the AI model based on the prompt; and
process the output.

### Claim 14 (depends on 13)

The computer program product of claim 13, wherein the output includes:
an expanded table name corresponding to the table name abbreviation; and
plural expanded column names corresponding, respectively, to the plural column name abbreviations.

### Claim 15 (depends on 13)

The computer program product of claim 13, wherein the automatically generating the prompt comprises:
obtaining a predefined prompt format for the AI model; and
arranging the table name abbreviation and the plural column name abbreviations in a JavaScript Object Notation format in the predefined prompt format.

### Claim 16 (depends on 13)

The computer program product of claim 13, wherein the prompt includes one or more examples each comprising an abbreviation and an expansion of the abbreviation.

### Claim 17

A system comprising:
a processor set, one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable to:
extract, from metadata of a table in a database, a table name abbreviation of the table and plural column name abbreviations of plural columns in the table;
automatically generate a prompt for an artificial intelligence (AI) model, the prompt including the table name abbreviation, the plural column name abbreviations, and an instruction to expand the table name abbreviation and the plural column name abbreviations;
provide the prompt to the AI model using a call to the AI model, wherein the call comprises a single application programming interface (API) call to the AI model or a single web service call to the AI model;
receive an output generated by the AI model based on the prompt; and
process the output.

### Claim 18 (depends on 17)

The system of claim 17, wherein the output includes:
an expanded table name corresponding to the table name abbreviation; and
plural expanded column names corresponding, respectively, to the plural column name abbreviations.

### Claim 19 (depends on 17)

The system of claim 17, wherein the automatically generating the prompt comprises:
obtaining a predefined prompt format for the AI model; and
arranging the table name abbreviation and the plural column name abbreviations in a JavaScript Object Notation format in the predefined prompt format.

### Claim 20 (depends on 17)

The system of claim 17, wherein the prompt includes one or more examples each comprising an abbreviation and an expansion of the abbreviation.
