# US 2025/0094737 A1 · Managing date-time intervals in transforming natural language to a logical form

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

- Number: US 2025/0094737 A1
- Document ID: US20250094737A1
- Status: Published application
- Kind: A1
- Application number: 18/794,986
- Filed: 2024-08-05
- Published: 2025-03-20
- Earliest claimed: 2023-08-21
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Gioacchino Tangari; Cong Duy Vu Hoang; Dalu Guo; Steve Wai-Chun Siu; Stephen Andrew McRitchie; Christopher Mark Broadbent; Thanh Long Duong; Srinivasa Phani Kumar Gadde; Vishal Vishnoi; Chandan Basavaraju; Kenneth Khiaw Hong Eng
- Web page: https://patentgrep.com/patent/US20250094737A1

## CPC

- G06F 40/58: Use of machine translation, e.g. for multi-lingual retrieval, for server-side translation for client devices or for real-time translation
- G06F 40/166: Editing, e.g. inserting or deleting
- G06F 40/253: Grammatical analysis; Style critique
- G06F 40/295: Named entity recognition
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Techniques are disclosed herein for managing date-time intervals in transforming natural language utterances to logical forms by providing an enhanced grammar, a natural language utterance comprising a date-time interval, and database schema information to a machine learning model that has been trained to convert natural language utterances to logical forms; and using the machine learning model to convert the natural language utterance to an output logical form, wherein the output logical form comprises at least one of the date-time interval and an extraction function for extracting date-time information corresponding to the date-time interval from at least one date-time attribute of the database schema information.

## Claims

### Claim 1

A computer-implemented method comprising:
providing an enhanced grammar, a natural language utterance comprising a date-time interval, and database schema information to a machine learning model that has been trained to convert natural language utterances to logical forms; and
using the machine learning model to convert the natural language utterance to an output logical form, wherein the output logical form comprises at least one of the date-time interval and an extraction function for extracting date-time information corresponding to the date-time interval from at least one date-time attribute of the database schema information.

### Claim 2 (depends on 1)

The computer-implemented method of claim 1, wherein the output logical form comprises the extraction function, wherein the enhanced grammar comprises a set of relational algebra operators and a set of date-time extraction functions, and wherein the machine learning model converts the natural language utterance to the output logical form based at least in-part on selecting the extracting function from the set of date-time extraction functions.

### Claim 3 (depends on 2)

The computer-implemented method of claim 2, further comprising:
prior to using the machine learning model to convert the natural language utterance to the output logical form:
accessing a grammar comprising the set of relational algebra operators; and
generating the enhanced grammar by adding the set of date-time extraction functions to the grammar.

### Claim 4 (depends on 1)

The computer-implemented method of claim 1, wherein the machine learning model has been trained to convert natural language utterances to logical forms by:
accessing training data comprising a set of training examples;
generating a set of augmented training examples from training examples in the set of training examples by:
identifying a subset of training examples in the set of training examples that include date-time intervals;
associating the date-time intervals with first extraction functions included in a set of extraction functions that are configured to extract date-time information from date-time attributes included in a database schema;
selecting second extraction functions included in the set of extraction functions that are different from the first extraction functions; and
modifying logical forms and natural language utterances of training examples in the subset of training examples based on the second extraction functions to result in the set of augmented training examples;
generating augmented training data by combining the set of augmented training examples and the set of training examples; and
using the augmented training data to train the machine learning model to convert natural language utterances to logical forms.

### Claim 5 (depends on 1)

The computer-implemented method of claim 1, wherein the output logical form comprises the date-time interval, and the method further comprising:
processing the output logical form to generate a processed output logical form, wherein the processing output logical form to generate the processed output logical form comprises identifying a portion of the output logical form that comprises a logical form operator and the date-time interval and replacing the portion with a replacement extraction function selected from a set of extraction functions that are configured to extract date-information from date-time attributes included in a database schema.

### Claim 6 (depends on 5)

The computer-implemented method of claim 5, wherein the processing the output logical form to generate the processed output logical form further comprises using a named entity recognizer to identify a type for the date-time interval and selecting the replacement extraction function based on the type for the date-time interval.

### Claim 7 (depends on 5)

The computer-implemented method of claim 5, further comprising:
translating the processed output logical form to a query language output statement;
providing the query language output statement to a cloud-based platform;
using the cloud-based platform to execute the query language output statement on a database associated with the database schema information to retrieve a result describing information corresponding to the date-time interval of the natural language utterance; and
providing the result to a user device.

### Claim 8

A system comprising:
one or more processors; and
one or more computer-readable media storing instructions which, when executed by the one or more processors, cause the system to perform operations comprising:
providing an enhanced grammar, a natural language utterance comprising a date-time interval, and database schema information to a machine learning model that has been trained to convert natural language utterances to logical forms; and
using the machine learning model to convert the natural language utterance to an output logical form, wherein the output logical form comprises at least one of the date-time interval and an extraction function for extracting date-time information corresponding to the date-time interval from at least one date-time attribute of the database schema information.

### Claim 9 (depends on 8)

The system of claim 8, wherein the output logical form comprises the extraction function, wherein the enhanced grammar comprises a set of relational algebra operators and a set of date-time extraction functions, and wherein the machine learning model converts the natural language utterance to the output logical form based at least in-part on selecting the extracting function from the set of date-time extraction functions.

### Claim 10 (depends on 9)

The system of claim 9, the operations further comprising:
prior to using the machine learning model to convert the natural language utterance to the output logical form:
accessing a grammar comprising the set of relational algebra operators; and
generating the enhanced grammar by adding the set of date-time extraction functions to the grammar.

### Claim 11 (depends on 8)

The system of claim 8, wherein the machine learning model has been trained to convert natural language utterances to logical forms by:
accessing training data comprising a set of training examples;
generating a set of augmented training examples from training examples in the set of training examples by:
identifying a subset of training examples in the set of training examples that include date-time intervals;
associating the date-time intervals with first extraction functions included in a set of extraction functions that are configured to extract date-time information from date-time attributes included in a database schema;
selecting second extraction functions included in the set of extraction functions that are different from the first extraction functions; and
modifying logical forms and natural language utterances of training examples in the subset of training examples based on the second extraction functions to result in the set of augmented training examples;
generating augmented training data by combining the set of augmented training examples and the set of training examples; and
using the augmented training data to train the machine learning model to convert natural language utterances to logical forms.

### Claim 12 (depends on 8)

The system of claim 8, wherein the output logical form comprises the date-time interval, and the operations further comprising:
processing the output logical form to generate a processed output logical form, wherein the processing output logical form to generate the processed output logical form comprises identifying a portion of the output logical form that comprises a logical form operator and the date-time interval and replacing the portion with a replacement extraction function selected from a set of extraction functions that are configured to extract date-information from date-time attributes included in a database schema.

### Claim 13 (depends on 12)

The system of claim 12, wherein the processing the output logical form to generate the processed output logical form further comprises using a named entity recognizer to identify a type for the date-time interval and selecting the replacement extraction function based on the type for the date-time interval.

### Claim 14 (depends on 12)

The system of claim 12, the operations further comprising:
translating the processed output logical form to a query language output statement;
providing the query language output statement to a cloud-based platform;
using the cloud-based platform to generate a visualization comprising visual information describing information corresponding to the date-time interval of the natural language utterance; and
providing the visualization to a user device.

### Claim 15

One or more non-transitory computer-readable media storing instructions which, when executed by one or more processors, cause a system to perform operations comprising:
providing an enhanced grammar, a natural language utterance comprising a date-time interval, and database schema information to a machine learning model that has been trained to convert natural language utterances to logical forms; and
using the machine learning model to convert the natural language utterance to an output logical form, wherein the output logical form comprises at least one of the date-time interval and an extraction function for extracting date-time information corresponding to the date-time interval from at least one date-time attribute of the database schema information.

### Claim 16 (depends on 15)

The one or more non-transitory computer-readable media of claim 15, wherein the output logical form comprises the extraction function, wherein the enhanced grammar comprises a set of relational algebra operators and a set of date-time extraction functions, and wherein the machine learning model converts the natural language utterance to the output logical form based at least in-part on selecting the extracting function from the set of date-time extraction functions.

### Claim 17 (depends on 16)

The one or more non-transitory computer-readable media of claim 16, the operations further comprising:
prior to using the machine learning model to convert the natural language utterance to the output logical form:
accessing a grammar comprising the set of relational algebra operators; and
generating the enhanced grammar by adding the set of date-time extraction functions to the grammar.

### Claim 18 (depends on 15)

The one or more non-transitory computer-readable media of claim 15, wherein the machine learning model has been trained to convert natural language utterances to logical forms by:
accessing training data comprising a set of training examples;
generating a set of augmented training examples from training examples in the set of training examples by:
identifying a subset of training examples in the set of training examples that include date-time intervals;
associating the date-time intervals with first extraction functions included in a set of extraction functions that are configured to extract date-time information from date-time attributes included in a database schema;
selecting second extraction functions included in the set of extraction functions that are different from the first extraction functions; and
modifying logical forms and natural language utterances of training examples in the subset of training examples based on the second extraction functions to result in the set of augmented training examples;
generating augmented training data by combining the set of augmented training examples and the set of training examples; and
using the augmented training data to train the machine learning model to convert natural language utterances to logical forms.

### Claim 19 (depends on 15)

The one or more non-transitory computer-readable media of claim 15, wherein the output logical form comprises the date-time interval, and the operations further comprising:
processing the output logical form to generate a processed output logical form, wherein the processing output logical form to generate the processed output logical form comprises identifying a portion of the output logical form that comprises a logical form operator and the date-time interval and replacing the portion with a replacement extraction function selected from a set of extraction functions that are configured to extract date-information from date-time attributes included in a database schema.

### Claim 20 (depends on 19)

The one or more non-transitory computer-readable media of claim 19, the operations further comprising:
translating the processed output logical form to a query language output statement;
providing the query language output statement to a cloud-based platform;
using the cloud-based platform to execute the query language output statement on a database associated with the database schema information to retrieve a result describing information corresponding to the date-time interval of the natural language utterance or generate a visualization comprising visual information describing information corresponding to the date-time interval of the natural language utterance, or a combination thereof; and
providing the result or the visualization to a user device.
