Database system interaction embedding and indexing for text retrieval and generation

A database system comprising at least one processor and configured to perform a method, the method comprising:

• receiving a text interaction record, the text interaction record including interaction text from one or more messages between a client machine and a service provider;
• determining a search vector based on the interaction text via a processor at the database system, the search vector including a text embedding representing the interaction text in a multi-dimensional vector space;
• retrieving a reference interaction record from the database system based on the search vector, the reference interaction record including reference interaction text, the reference interaction record including a reference vector representing the reference interaction text in the multi-dimensional vector space;
• determining recommended reply text based on the interaction text and the reference interaction text, the recommended reply text being determined by a large language model configured to generate the recommended reply text in response to a prompt that includes one or more natural language instructions;
• and
• transmitting a response message to the client machine, the response message including some or all of the recommended reply text.

One or more non-transitory computer readable media having instructions stored thereon for performing a method, the method comprising:

• receiving a text interaction record at a database system, the text interaction record including interaction text from one or more messages between a client machine and a service provider;
• determining a search vector based on the interaction text via a processor at the database system, the search vector including a text embedding representing the interaction text in a multi-dimensional vector space;
• retrieving a reference interaction record from the database system based on the search vector, the reference interaction record including reference interaction text, the reference interaction record including a reference vector representing the reference interaction text in the multi-dimensional vector space;
• determining recommended reply text based on the interaction text and the reference interaction text, the recommended reply text being determined by a large language model configured to generate the recommended reply text in response to a prompt that includes one or more natural language instructions;
• and
• transmitting a response message from the database system to the client machine, the response message including some or all of the recommended reply text.