Abstract: A system and method for an improved text to structured query language (SQL) for use with a large language model (LLM). Categories of possible questions for a database can be determined and a mapping between the data elements of the database and the categories can be determined. User questions can have a match level to the categories. Data elements from a data schema can be removed that do not match categories according to the match level, the modified data schema can be used for the database with the LLM.

Abstract: A real-time system for generating Structured Query Language (SQL) queries from natural language input includes a server in communication with a large language model (LLM). The server is configured to: receive a natural language input from a user; generate a prompt that includes a terse table name or column name from the database, and instructions for generating an SQL query for the database, based on the natural language input. The processor is further configured to: replace the terse table name or column name with a verbose table name or column name; send the prompt to the LLM; receive an SQL query from the LLM, including the at least one verbose table name or column name; replace the at least one verbose table name or column name with the at least one terse table name or column name; execute the SQL query on the database; and receive an SQL query result.

Abstract: A question processing system and methods are provided that are configured to intelligently generate structured data queries from natural language questions using a large language model (LLM). The system includes a processor and a computer readable medium operably coupled thereto, the computer readable medium comprising a plurality of instructions stored in association therewith that are accessible to, and executable by, the processor, to perform operations which include receiving a natural language question for structured data including columns having discrete text values, generating, using an LLM, a first structured data query having a predicted text value, searching a data store for similar ones of the discrete text values, generating, using the LLM, a second structured data query that refines the first structured data query based on the similar discrete text values, and querying a structured database based on the first and/or second structured data query.

Abstract: A customer issue resolution system and methods for resolving a customer issue include receiving an audio interaction between a customer and an agent; converting the audio interaction into text; identifying a customer issue in the text of the interaction; performing a semantic search in a vector database for the customer issue in past customer interactions of a plurality of customers; obtaining a plurality of transcripts of past customer interactions from the vector database that match the customer issue, where the customer issue was resolved, and that have a threshold customer satisfaction score; constructing a large language model (LLM) prompt based on the obtained plurality of transcripts and the customer issue; executing the LLM prompt to return a recommendation to resolve the customer issue; and displaying the recommendation to the agent in real-time.

Abstract: A multi-channel publishing system for publishing tagged content in a plurality of versions via a plurality of channels, comprises: an input for tagged content; an input for receptacles of intelligent layout rules, the receptacles comprising cells associated with tags, the cells being optimized within the receptacles for respective versions or respective channels; a tagged content insertion unit for inserting the tagged content into the cells of the receptacles according to the tags, the receptacles actively responding to the content insertion by adjusting the cells to allow fitting of the content, the adjusting being constrained by at least one intelligent layout rule, thereby to form the plurality of versions of the tagged content optimized for respective output channels; and a publishing unit for outputting the plurality of versions.