The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 22, 2026
Filed:
Feb. 25, 2025
Oracle International Corporation, Redwood Shores, CA (US);
Nagesh Panyam Chandrasekarasatry, Melbourne, AU;
Duy Vu, Melbourne, AU;
Dai Quoc Nguyen, Raceview, AU;
Gioacchino Tangari, Sydney, AU;
Cong Duy Vu Hoang, Wantirna South, AU;
Yakupitiyage Don Thanuja Samodhye Dharmasiri, Melbourne, AU;
Vladislav Blinov, Melbourne, AU;
Thanh Tien Vu, Herston, AU;
Ying Xu, Melbourne, AU;
Thanh Long Duong, Melbourne, AU;
ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US);
Abstract
The present disclosure relates to machine learning techniques for In-Context-Learning (ICL) with pattern-based retrieval for the task of converting Natural Language (NL) to Structured Query Language (SQL). Aspects are directed towards acquiring a natural language utterance and a database schema, searching, using at least a portion of the natural language utterance as a key, a memory bank for one or more in-context examples that are relevant to the key, generating a prompt comprising the natural language query, the database schema, and the one or more in-context examples, transmitting the prompt to a first pretrained generative artificial intelligence model, receiving, from the first pretrained generative artificial intelligence model, a logical form corresponding to the natural language utterance based at least in part on the prompt, executing the logical form on a database to obtain a query result, and providing the query result to a user.