IP Library Granted Patent US 12,475,149
Granted Patent B2
US 12,475,149 · App. 18/505,988 · Granted Nov 18, 2025

Database systems and methods for automated conversational responses

Inventor: John Conway (Vancouver, CA)
G06F16/3329G06F16/338G06F40/30
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,475,149
App. No.
18/505,988
Granted
Nov 18, 2025
Kind
B2
Abstract

Database systems and methods are provided for managing usage of large language models (LLMs). One method involves determining a numerical representation of a conversational input to a user interface, identifying a semantically similar subset of prior conversational inputs based at least in part on the numerical representation of the conversational input, and determining numerical representations of respective conversational responses generated by a language model responsive to the respective prior conversational input of the semantically similar subset. When the numerical representations of the respective conversational responses satisfy a semantic similarity threshold, the method automatically generates an automated response to the conversational input based at least in part on one or more prior conversational responses and automatically provides the automated response to the user interface responsive to the conversational input.

Claims (50)

1 . A method comprising:

determining a numerical representation of a conversational input to a user interface;

identifying, based at least in part on the numerical representation of the conversational input, a semantically similar subset of prior conversational inputs previously sent to a large language model-based (LLM-based) service from a plurality of prior conversational inputs having associated conversational responses maintained at a database system, wherein a respective prior conversational input of the semantically similar subset has a respective conversational response generated by the LLM-based service responsive to the respective prior conversational input associated therewith, resulting an associated subset of prior conversational responses provided by the LLM-based service responsive to the semantically similar subset of prior conversational inputs;

determining numerical representations of the respective conversational responses of the associated subset of prior conversational responses provided by the LLM-based service; and

when the numerical representations of the respective conversational responses satisfy a semantic similarity threshold for homogeneity across the prior conversational responses provided by the LLM-based service:

automatically generating a synthetic LLM response to the conversational input based at least in part on one or more prior conversational responses of the associated subset of prior conversational responses provided by the LLM-based service responsive to the semantically similar subset of prior conversational inputs; and

automatically providing the synthetic LLM response to the user interface responsive to the conversational input.

2 . The method of claim 1 , further comprising removing personal identifying information from the conversational input prior to determining the numerical representation of the conversational input.

3 . The method of claim 2 , further comprising supplementing the synthetic LLM response with the personal identifying information prior to automatically the automated synthetic LLM response to the user interface.

4 . The method of claim 1 , wherein identifying the semantically similar subset of prior conversational inputs comprises identifying a cluster group of prior input prompts previously sent to the LLM-based service having respective numerical representations semantically similar to the numerical representation of the conversational input.

5 . The method of claim 1 , further comprising filtering the semantically similar subset of prior conversational inputs based at least in part on contextual information associated with the conversational input prior to identifying the associated subset of prior conversational responses.

6 . The method of claim 5 , wherein the contextual information includes at least one of an identifier associated with a user providing the conversational input and a database object type associated with the conversational input.

7 . At least one non-transitory machine-readable storage medium that provides instructions that, when executed by at least one processor, are configurable to cause the at least one processor to perform operations comprising:

determining a numerical representation of a conversational input to a user interface;

identifying, based at least in part on the numerical representation of the conversational input, a semantically similar subset of prior conversational inputs previously sent to a large language model-based (LLM-based) service from a plurality of prior conversational inputs having associated conversational responses maintained at a database system, wherein a respective prior conversational input of the semantically similar subset has a respective conversational response generated by the LLM-based service responsive to the respective prior conversational input associated therewith, resulting an associated subset of prior conversational responses provided by the LLM-based service responsive to the semantically similar subset of prior conversational inputs;

determining numerical representations of the respective conversational responses of the associated subset of prior conversational responses provided by the LLM-based service; and

when the numerical representations of the respective conversational responses satisfy a semantic similarity threshold for homogeneity across the prior conversational responses provided by the LLM-based service:

automatically generating a synthetic LLM response to the conversational input based at least in part on one or more prior conversational responses of the associated subset of prior conversational responses provided by the LLM-based service responsive to the semantically similar subset of prior conversational inputs; and

automatically providing the synthetic LLM response to the user interface responsive to the conversational input.

8 . The at least one non-transitory machine-readable storage medium of claim 7 , wherein the instructions are configurable to cause the at least one processor to remove personal identifying information from the conversational input prior to determining the numerical representation of the conversational input.

9 . The at least one non-transitory machine-readable storage medium of claim 8 , wherein the instructions are configurable to cause the at least one processor to supplement the synthetic LLM response with the personal identifying information prior to automatically providing the synthetic LLM response to the user interface.

10 . The at least one non-transitory machine-readable storage medium of claim 7 , wherein:

the semantically similar subset of prior conversational inputs comprises a subset of prior input prompts previously sent to the LLM-based service; and

the associated subset of prior conversational responses comprises conversational responses provided by the LLM-based service in response to receiving respective ones of the subset of prior input prompts.

11 . The at least one non-transitory machine-readable storage medium of claim 7 , wherein the instructions are configurable to cause the at least one processor to identify a cluster group of prior input prompts previously sent to the LLM-based service having respective numerical representations semantically similar to the numerical representation of the conversational input.

12 . The at least one non-transitory machine-readable storage medium of claim 7 , wherein the instructions are configurable to cause the at least one processor to filter the semantically similar subset of prior conversational inputs based at least in part on contextual information associated with the conversational input prior to identifying the associated subset of prior conversational responses.

13 . The at least one non-transitory machine-readable storage medium of claim 12 , wherein the contextual information includes at least one of an identifier associated with a user providing the conversational input and a database object type associated with the conversational input.

14 . A computing system comprising:

at least one non-transitory machine-readable storage medium that stores software; and

at least one processor, coupled to the at least one non-transitory machine-readable storage medium, to execute the software that implements a large language model (LLM) management service and that is configurable to perform operations comprising:

determining a numerical representation of a conversational input to a user interface;

identifying, based at least in part on the numerical representation of the conversational input, a semantically similar subset of prior conversational inputs previously sent to an LLM-based service from a plurality of prior conversational inputs having associated conversational responses maintained at a database system, wherein a respective prior conversational input of the semantically similar subset has a respective conversational response generated by the LLM-based service responsive to the respective prior conversational input associated therewith, resulting an associated subset of prior conversational responses provided by the LLM-based service responsive to the semantically similar subset of prior conversational inputs;

determining numerical representations of the respective conversational responses of the associated subset of prior conversational responses provided by the LLM-based service; and

when the numerical representations of the respective conversational responses satisfy a semantic similarity threshold for homogeneity across the prior conversational responses provided by the LLM-based service:

automatically generating a synthetic LLM response to the conversational input based at least in part on one or more prior conversational responses of the associated subset of prior conversational responses provided by the LLM-based service responsive to the semantically similar subset of prior conversational inputs; and

automatically providing the synthetic LLM response to the user interface responsive to the conversational input.

15 . The computing system of claim 14 , wherein the LLM management service is configurable to:

remove personal identifying information from the conversational input prior to determining the numerical representation of the conversational input; and

supplement the synthetic LLM response with the personal identifying information prior to automatically providing the synthetic LLM response to the user interface.

16 . The computing system of claim 14 , wherein the LLM management service is configurable to filter the semantically similar subset of prior conversational inputs based at least in part on contextual information associated with the conversational input prior to identifying the conversational responses provided by the LLM-based service in response to receiving respective ones of a filtered semantically similar subset of prior conversational inputs.

17 . The method of claim 1 , wherein:

the semantically similar subset of prior conversational inputs comprises a subset of prior input prompts previously sent to the LLM-based service;

each prior input prompt of the subset of prior input prompts has a respective numerical representation within a threshold similarity of the numerical representation of the conversational input;

each prior input prompt of the subset of prior input prompts has a respective conversational response by the LLM-based service in response to receiving the respective prior input prompts; and

the associated subset of prior conversational responses comprises the respective conversational responses provided by the LLM-based service in response to receiving respective ones of the subset of prior input prompts.

18 . The method of claim 1 , wherein:

the conversational input and the prior conversational inputs are unstructured and free form using natural language; and

numerical representations of respective prior conversational inputs of the semantically similar subset of prior conversational inputs are within a threshold degree of similarity of the numerical representation of the conversational input.

19 . The method of claim 1 , further comprising filtering the prior conversational inputs previously sent to the LLM-based service based at least in part on a database object type associated with the conversational input to obtain the semantically similar subset of prior conversational inputs by removing a second subset of the prior conversational inputs relating to a different database object type than the database object type.

20 . The method of claim 1 , further comprising filtering the prior conversational inputs previously sent to the LLM-based service based at least in part on an identifier associated with a user providing the conversational input to remove a second subset of the prior conversational inputs and obtain the semantically similar subset of prior conversational inputs associated with a same tenant, organization or user as the conversational input.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 7, 2025
From: CONWAY, JOHN
To: SALESFORCE, INC.
Reel/Frame 071967/0395 →
Continuity (1)
Related Publication 20250156453A1 · May 15, 2025
References Cited (152)
US 5577188A · Zhu · 1996 [cited by applicant]
US 5608872A · Schwartz et al. · 1997 [cited by applicant]
US 5649104A · Carleton et al. · 1997 [cited by applicant]
US 5715450A · Ambrose et al. · 1998 [cited by applicant]
US 5761419A · Schwartz et al. · 1998 [cited by applicant]
US 5819038A · Carleton et al. · 1998 [cited by applicant]
US 5821937A · Tonelli et al. · 1998 [cited by applicant]
US 5831610A · Tonelli et al. · 1998 [cited by applicant]
US 5873096A · Lim et al. · 1999 [cited by applicant]
US 5918159A · Fomukong et al. · 1999 [cited by applicant]
US 5963953A · Cram et al. · 1999 [cited by applicant]
US 6092083A · Brodersen et al. · 2000 [cited by applicant]
US 6161149A · Achacoso et al. · 2000 [cited by applicant]
US 6169534B1 · Raffel et al. · 2001 [cited by applicant]
US 6178425B1 · Brodersen et al. · 2001 [cited by applicant]
US 6189011B1 · Lim et al. · 2001 [cited by applicant]
US 6216135B1 · Brodersen et al. · 2001 [cited by applicant]
US 6233617B1 · Rothwein et al. · 2001 [cited by applicant]
US 6266669B1 · Brodersen et al. · 2001 [cited by applicant]
US 6295530B1 · Ritchie et al. · 2001 [cited by applicant]
US 6324568B1 · Diec et al. · 2001 [cited by applicant]
US 6324693B1 · Brodersen et al. · 2001 [cited by applicant]
US 6336137B1 · Lee et al. · 2002 [cited by applicant]
US D454139S · Feldcamp et al. · 2002 [cited by applicant]
US 6367077B1 · Brodersen et al. · 2002 [cited by applicant]
US 6393605B1 · Loomans · 2002 [cited by applicant]
US 6405220B1 · Brodersen et al. · 2002 [cited by applicant]
US 6434550B1 · Warner et al. · 2002 [cited by applicant]
US 6446089B1 · Brodersen et al. · 2002 [cited by applicant]
US 6535909B1 · Rust · 2003 [cited by applicant]
US 6549908B1 · Loomans · 2003 [cited by applicant]
US 6553563B2 · Ambrose et al. · 2003 [cited by applicant]
US 6560461B1 · Fomukong et al. · 2003 [cited by applicant]
US 6574635B2 · Stauber et al. · 2003 [cited by applicant]
US 6577726B1 · Huang et al. · 2003 [cited by applicant]
US 6601087B1 · Zhu et al. · 2003 [cited by applicant]
US 6604117B2 · Lim et al. · 2003 [cited by applicant]
US 6604128B2 · Diec · 2003 [cited by applicant]
US 6609150B2 · Lee et al. · 2003 [cited by applicant]
US 6621834B1 · Scherpbier et al. · 2003 [cited by applicant]
US 6654032B1 · Zhu et al. · 2003 [cited by applicant]
US 6665648B2 · Brodersen et al. · 2003 [cited by applicant]
US 6665655B1 · Warner et al. · 2003 [cited by applicant]
US 6684438B2 · Brodersen et al. · 2004 [cited by applicant]
US 6711565B1 · Subramaniam et al. · 2004 [cited by applicant]
US 6724399B1 · Katchour et al. · 2004 [cited by applicant]
US 6728702B1 · Subramaniam et al. · 2004 [cited by applicant]
US 6728960B1 · Loomans et al. · 2004 [cited by applicant]
US 6732095B1 · Warshavsky et al. · 2004 [cited by applicant]
US 6732100B1 · Brodersen et al. · 2004 [cited by applicant]
US 6732111B2 · Brodersen et al. · 2004 [cited by applicant]
US 6754681B2 · Brodersen et al. · 2004 [cited by applicant]
US 6763351B1 · Subramaniam et al. · 2004 [cited by applicant]
US 6763501B1 · Zhu et al. · 2004 [cited by applicant]
US 6768904B2 · Kim · 2004 [cited by applicant]
US 6772229B1 · Achacoso et al. · 2004 [cited by applicant]
US 6782383B2 · Subramaniam et al. · 2004 [cited by applicant]
US 6804330B1 · Jones et al. · 2004 [cited by applicant]
US 6826565B2 · Ritchie et al. · 2004 [cited by applicant]
US 6826582B1 · Chatterjee et al. · 2004 [cited by applicant]
US 6826745B2 · Coker · 2004 [cited by applicant]
US 6829655B1 · Huang et al. · 2004 [cited by applicant]
US 6842748B1 · Warner et al. · 2005 [cited by applicant]
US 6850895B2 · Brodersen et al. · 2005 [cited by applicant]
US 6850949B2 · Warner et al. · 2005 [cited by applicant]
US 7062502B1 · Kesler · 2006 [cited by applicant]
US 7069231B1 · Cinarkaya et al. · 2006 [cited by applicant]
US 7181758B1 · Chan · 2007 [cited by applicant]
US 7289976B2 · Kihneman et al. · 2007 [cited by applicant]
US 7340411B2 · Cook · 2008 [cited by applicant]
US 7356482B2 · Frankland et al. · 2008 [cited by applicant]
US 7401094B1 · Kesler · 2008 [cited by applicant]
US 7412455B2 · Dillon · 2008 [cited by applicant]
US 7508789B2 · Chan · 2009 [cited by applicant]
US 7620655B2 · Larsson et al. · 2009 [cited by applicant]
US 7698160B2 · Beaven et al. · 2010 [cited by applicant]
US 7730478B2 · Weissman · 2010 [cited by applicant]
US 7779475B2 · Jakobson et al. · 2010 [cited by applicant]
US 8014943B2 · Jakobson · 2011 [cited by applicant]
US 8015495B2 · Achacoso et al. · 2011 [cited by applicant]
US 8032297B2 · Jakobson · 2011 [cited by applicant]
US 8082301B2 · Ahlgren et al. · 2011 [cited by applicant]
US 8095413B1 · Beaven · 2012 [cited by applicant]
US 8095594B2 · Beaven et al. · 2012 [cited by applicant]
US 8209308B2 · Rueben et al. · 2012 [cited by applicant]
US 8275836B2 · Beaven et al. · 2012 [cited by applicant]
US 8457545B2 · Chan · 2013 [cited by applicant]
US 8484111B2 · Frankland et al. · 2013 [cited by applicant]
US 8490025B2 · Jakobson et al. · 2013 [cited by applicant]
US 8504945B2 · Jakobson et al. · 2013 [cited by applicant]
US 8510045B2 · Rueben et al. · 2013 [cited by applicant]
US 8510664B2 · Rueben et al. · 2013 [cited by applicant]
US 8566301B2 · Rueben et al. · 2013 [cited by applicant]
US 8646103B2 · Jakobson et al. · 2014 [cited by applicant]
US 20010044791A1 · Richter et al. · 2001 [cited by applicant]
US 20020072951A1 · Lee et al. · 2002 [cited by applicant]
US 20020082892A1 · Raffel · 2002 [cited by applicant]
US 20020129352A1 · Brodersen et al. · 2002 [cited by applicant]
US 20020140731A1 · Subramanian et al. · 2002 [cited by applicant]
US 20020143997A1 · Huang et al. · 2002 [cited by applicant]
US 20020162090A1 · Parnell et al. · 2002 [cited by applicant]
US 20020165742A1 · Robbins · 2002 [cited by applicant]
US 20030004971A1 · Gong · 2003 [cited by applicant]
US 20030018705A1 · Chen et al. · 2003 [cited by applicant]
US 20030018830A1 · Chen et al. · 2003 [cited by applicant]
US 20030066031A1 · Laane et al. · 2003 [cited by applicant]
US 20030066032A1 · Ramachandran et al. · 2003 [cited by applicant]
US 20030069936A1 · Warner et al. · 2003 [cited by applicant]
US 20030070000A1 · Coker et al. · 2003 [cited by applicant]
US 20030070004A1 · Mukundan et al. · 2003 [cited by applicant]
US 20030070005A1 · Mukundan et al. · 2003 [cited by applicant]
US 20030074418A1 · Coker et al. · 2003 [cited by applicant]
US 20030120675A1 · Stauber et al. · 2003 [cited by applicant]
US 20030151633A1 · George et al. · 2003 [cited by applicant]
US 20030159136A1 · Huang et al. · 2003 [cited by applicant]
US 20030187921A1 · Diec et al. · 2003 [cited by applicant]
US 20030189600A1 · Gune et al. · 2003 [cited by applicant]
US 20030204427A1 · Gune et al. · 2003 [cited by applicant]
US 20030206192A1 · Chen et al. · 2003 [cited by applicant]
US 20030225730A1 · Warner et al. · 2003 [cited by applicant]
US 20040001092A1 · Rothwein et al. · 2004 [cited by applicant]
US 20040010489A1 · Rio et al. · 2004 [cited by applicant]
US 20040015981A1 · Coker et al. · 2004 [cited by applicant]
US 20040027388A1 · Berg et al. · 2004 [cited by applicant]
US 20040128001A1 · Levin et al. · 2004 [cited by applicant]
US 20040186860A1 · Lee et al. · 2004 [cited by applicant]
US 20040193510A1 · Catahan et al. · 2004 [cited by applicant]
US 20040199489A1 · Barnes-Leon et al. · 2004 [cited by applicant]
US 20040199536A1 · Barnes-Leon et al. · 2004 [cited by applicant]
US 20040199543A1 · Braud et al. · 2004 [cited by applicant]
US 20040249854A1 · Barnes-Leon et al. · 2004 [cited by applicant]
US 20040260534A1 · Pak et al. · 2004 [cited by applicant]
US 20040260659A1 · Chan et al. · 2004 [cited by applicant]
US 20040268299A1 · Lei et al. · 2004 [cited by applicant]
US 20050050555A1 · Exley et al. · 2005 [cited by applicant]
US 20050091098A1 · Brodersen et al. · 2005 [cited by applicant]
US 20060021019A1 · Hinton et al. · 2006 [cited by applicant]
US 20080249972A1 · Dillon · 2008 [cited by applicant]
US 20090063414A1 · White et al. · 2009 [cited by applicant]
US 20090100342A1 · Jakobson · 2009 [cited by applicant]
US 20090177744A1 · Marlow et al. · 2009 [cited by applicant]
US 20110247051A1 · Bulumulla et al. · 2011 [cited by applicant]
US 20120042218A1 · Cinarkaya et al. · 2012 [cited by applicant]
US 20120218958A1 · Rangaiah · 2012 [cited by applicant]
US 20120233137A1 · Jakobson et al. · 2012 [cited by applicant]
US 20130212497A1 · Zelenko et al. · 2013 [cited by applicant]
US 20130218948A1 · Jakobson · 2013 [cited by applicant]
US 20130218949A1 · Jakobson · 2013 [cited by applicant]
US 20130218966A1 · Jakobson · 2013 [cited by applicant]
US 20130247216A1 · Cinarkaya et al. · 2013 [cited by applicant]
US 20210406264A1 · Nahamoo · 2021 [cited by examiner]
Plu, Julien. Dec. 2018. Knowledge Extraction in WEb Media: At the Frontier of NLP, Machine Learning and Semantics. Telecom Paris Tech. pp. 1-88. [cited by examiner]