US 12,353,407 B1
System and method for artificial intelligence based generation of database queries
Yuval Shachaf, Tzur Moshe (IL); Rami Tibi Abu Rass, Taybeh (IL); Omer Kuleski, Petah-Tikva (IL); and Gal Tesler, Hoboken, NJ (US)
Assigned to NICE LTD., Ra'anana (IL)
Filed by NICE LTD., Ra'anana (IL)
Filed on Jan. 10, 2024, as Appl. No. 18/408,818.
Int. Cl. G06F 16/242 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/243 (2019.01) [G06F 16/2455 (2019.01)] 15 Claims
OG exemplary drawing
 
1. A computerized method for automatic generation of database queries, the method comprising, using a computer processor:
wrapping a free text prompt, the free text prompt received from a remote computer system using a representational state transfer (REST) protocol, wherein the wrapped prompt includes database structure information, wherein the wrapping of the free text prompt comprises embedding the free text prompt in a first predefined string of a plurality of predefined strings, the first predefined string describing one or more of: table names, and column names;
generating, by a first large language model (LLM), a database query based on the wrapped prompt, the database query describing one or more database operations;
wrapping the database query, wherein the wrapped database query includes one or more instructions, the instructions corresponding to one or more of the database operations, wherein the wrapping of the database query comprises embedding the database query in a second predefined string of the plurality of predefined strings, the second predefined string including a text format representation of a chart's axis names and a chart's type;
generating, by a second LLM, one or more metadata items based on the wrapped database query:
extracting one or more data items from a database based on the database query; and
automatically plotting a chart on a user interface (UI) based on one or more of the extracted data items and one or more of the metadata items.