IP Library Granted Patent US 12,417,225
Granted Patent B2
US 12,417,225 · App. 18/809,284 · Granted Sep 16, 2025

Machine learning-implemented chat bot database query system for multi-format database queries

Inventors: Jayaprakash Vijayan (Dublin, CA); Ved Surtani (Bengaluru, IN); Nitika Gupta (Bengaluru, IN); Malarvizhi Saravanan (Bengaluru, IN); Anirudh Saria (Kathmandu, NP); Amrutha Dharmaraj (Karnataka, IN)
Assignee: Tekion Corp
G06F16/24522G06F16/215G06F16/2365G06F16/248G06F16/285G06F16/9535G06N20/00
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,417,225
App. No.
18/809,284
Granted
Sep 16, 2025
Kind
B2
Abstract

A device receives a query from a user associated with a car dealership and applies the query to a first trained machine learning model configured to predict an intent, and to a second trained machine learning model to predict a set of entities. The device generates a normalized representation of the first query that is database language agnostic based on the predicted intent and the predicted set of entities, and translates the normalized representation into a second query having a format compatible with a language of a database of the car dealership. The device fetches data from the database of the car dealership using the second query, and provides the data for display to the user.

Claims (64)

1. A method comprising:

receiving, through a user interface, a first query from a user associated with a vehicle dealership;

applying the first query to a first trained machine learning model configured to predict an intent of the first query;

applying the first query to a second trained machine learning model configured to predict a set of entities of the first query;

generating a normalized representation of the first query based on the predicted intent and the predicted set of entities, wherein a format of the normalized representation of the first query is database language agnostic, and wherein generating the normalized representation comprises filtering out a subset of metadata from an interim representation of the first query that precedes the normalized representation of the first query, the filtering out based on an importance value for each metadata of the subset being below a threshold level of importance;

translating the normalized representation of the first query into a second query having a format compatible with a language of a database of the vehicle dealership;

fetching data from the database of the vehicle dealership associated with the predicted intent and the predicted set of entities using the second query; and

providing, on the user interface, the data for display to the user.

2. The method of claim 1 , wherein the first query is a text query, the method further comprising:

pre-processing the text query using a natural language processing model configured to identify spelling errors in the text query; and

responsive to identifying one or more spelling errors in the text query, modifying the text query to remove the one or more spelling errors.

3. The method of claim 1 , wherein the first query is a voice query, the method further comprising:

receiving audio data from the user via the user interface, the audio data associated with the first query; and

applying the audio data to a third trained machine learning model configured to generate a transcript from the audio data; and

generating a text query from the transcript.

4. The method of claim 1 , wherein the first trained machine learning model is a classification model.

5. The method of claim 4 , wherein the classification model is a supervised machine learning model, and wherein the supervised machine learning model is configured to classify the first query as one or more of an overall intent query, a sales query, or a services query.

6. The method of claim 1 , further comprising: extracting metadata associated with the vehicle dealership, wherein the normalized representation of the first query is further based on the extracted metadata.

7. The method of claim 1 , wherein the first query is associated with a requested action, the method further comprising:

accessing one or more documents associated with the requested action;

accessing metadata associated with the user;

inputting one or more metadata values into the one or more documents based on the requested action; and

providing for display the one or more documents to the user via the user interface.

8. The method of claim 1 , further comprising:

generating a query recommendation for an additional query based on the predicted set of entities of the first query;

providing the query recommendation for the additional query for display on the user interface; and

responsive to receiving an indication that the user interacted with the additional query:

fetching data associated with the additional query; and

providing the data associated with the additional query for display to the user.

9. The method of claim 1 , wherein the second trained machine learning model is an entity determination model, and wherein an entity of a query describes a category of a term of the query.

10. The method of claim 9 , wherein the entity determination model is a deep learning model.

11. The method of claim 1 , wherein generating the normalized representation of the first query further comprises filtering data associated with the first query based on a level of importance associated with one or more data values, and wherein the normalized representation includes data with at least a threshold level of importance.

12. The method of claim 1 , wherein an entity of the predicted set of entities is associated with a first value in a set of values, the method further comprising:

randomizing an additional query recommendation for an additional query based on additional values in the set of values; and

providing the randomized additional query recommendation for the additional query for display on the user interface.

13. The method of claim 1 , further comprising: updating a method of randomizing an additional query recommendation based on one or more responses to additional query recommendations from vehicle dealerships.

14. A non-transitory computer-readable medium comprising memory with instructions encoded thereon, the instructions, when executed, causing one or more processors to perform operations, the instructions comprising instructions to:

receive, through a user interface, a first query from a user associated with a vehicle dealership;

apply the first query to a first trained machine learning model configured to predict an intent of the first query;

apply the first query to a second trained machine learning model configured to predict a set of entities of the first query;

generate a normalized representation of the first query based on the predicted intent and the predicted set of entities, wherein a format of the normalized representation of the first query is database language agnostic, and wherein generating the normalized representation comprises filtering out a subset of metadata from an interim representation of the first query that precedes the normalized representation of the first query, the filtering out based on an importance value for each metadata of the subset being below a threshold level of importance;

translate the normalized representation of the first query into a second query having a format compatible with a language of a database of the vehicle dealership;

fetch data from the database of the vehicle dealership associated with the predicted intent and the predicted set of entities using the second query; and

provide, on the user interface, the data for display to the user.

15. The non-transitory computer-readable medium of claim 14 , wherein the first query is a text query, and wherein the instructions further comprise instructions to:

pre-process the text query using a natural language processing model configured to identify spelling errors in the text query; and

responsive to identifying one or more spelling errors in the text query, modify the text query to remove the one or more spelling errors.

16. The non-transitory computer-readable medium of claim 14 , wherein the first query is a voice query, and wherein the instructions further comprise instructions to:

receive audio data from the user via the user interface, the audio data associated with the first query; and

apply the audio data to a third trained machine learning model configured to generate a transcript from the audio data; and

generate a text query from the transcript.

17. The non-transitory computer-readable medium of claim 14 , wherein the first trained machine learning model is a classification model.

18. The non-transitory computer-readable medium of claim 17 , wherein the classification model is a supervised machine learning model, and wherein the supervised machine learning model is configured to classify the first query as one or more of an overall intent query, a sales query, or a services query.

19. A system comprising:

memory with instructions encoded thereon; and

one or more processors that, when executing the instructions, are caused to perform operations comprising:

receiving, through a user interface, a first query from a user associated with a vehicle dealership;

applying the first query to a first trained machine learning model configured to predict an intent of the first query;

applying the first query to a second trained machine learning model configured to predict a set of entities of the first query;

generating a normalized representation of the first query based on the predicted intent and the predicted set of entities, wherein a format of the normalized representation of the first query is database language agnostic, and wherein generating the normalized representation comprises filtering out a subset of metadata from an interim representation of the first query that precedes the normalized representation of the first query, the filtering out based on an importance value for each metadata of the subset being below a threshold level of importance;

translating the normalized representation of the first query into a second query having a format compatible with a language of a database of the vehicle dealership;

fetching data from the database of the vehicle dealership associated with the predicted intent and the predicted set of entities using the second query; and

providing, on the user interface, the data for display to the user.

20. The system of claim 19 , wherein generating the normalized representation of the first query further comprises filtering data associated with the first query based on a level of importance associated with one or more data values, and wherein the normalized representation includes data with at least a threshold level of importance.

Assignments (2)
SECURITY INTEREST Recorded Mar 2, 2026
From: TEKION CORP
To: MUFG BANK, LTD.
Reel/Frame 075012/0335 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 5, 2024
From: GUPTA, NITIKA; SURTANI, VED; SARAVANAN, MALARVIZHI; SARIA, ANIRUDH; DHARMARAJ, AMRUTHA; VIJAYAN, JAYAPRAKASH
To: TEKION CORP
Reel/Frame 068808/0698 →
Continuity (2)
Continuation 17508442 · Oct 22, 2021
Related Publication 20240411755A1 · Dec 12, 2024
References Cited (31)
US 9424233B2 · Barve et al. · 2016 [cited by applicant]
US 10750122B2 · Stewart et al. · 2020 [cited by applicant]
US 20060026147A1 · Cone · 2006 [cited by examiner]
US 20070016616A1 · Brill · 2007 [cited by examiner]
US 20070203863A1 · Gupta · 2007 [cited by examiner]
US 20110246468A1 · Raines · 2011 [cited by examiner]
US 20130262501A1 · Kuchmann-Beauger · 2013 [cited by examiner]
US 20130282682A1 · Batraski · 2013 [cited by examiner]
US 20160189047A1 · Meij · 2016 [cited by examiner]
US 20180260384A1 · Pasupalak · 2018 [cited by examiner]
US 20190034813A1 · Das · 2019 [cited by examiner]
US 20190258722A1 · Guo · 2019 [cited by examiner]
US 20200012721A1 · Pasupalak et al. · 2020 [cited by applicant]
US 20200035244A1 · Kim · 2020 [cited by examiner]
US 20200050662A1 · Bhat · 2020 [cited by examiner]
US 20200090270A1 · Dash · 2020 [cited by examiner]
US 20210012408A1 · Price et al. · 2021 [cited by applicant]
US 20210019309A1 · Yadav et al. · 2021 [cited by applicant]
WO WO2019118927A2 · 2019 [cited by examiner]
International Search Report and Written Opinion, Patent Cooperation Treaty Application No. PCT/US2022/047018, dated Feb. 6, 2023, 12 pages. [cited by applicant]
Li, Z. et al., “Addressing Inquiries about History: An Efficient and Practical Framework for Evaluating Open-domain Chatbot Consistency,” arXiv:2106.02228vl. Jun. 4, 2021, pp. 1-11. [cited by applicant]
Mamaniva, R. et al., “Online Chat bot for Car Dealership,” International Journal of Computer Trends and Technology, Apr. 14, 2020, vol. 68, No. 4, pp. 12-13, ISSN 2231-2803. [cited by applicant]
European Patent Office, Extended European Search Report, EP Patent Application No. 22884356.1, Jan. 9, 2025, 11 pages. [cited by applicant]
Mittal, A. et al., “Bootstrapping Chatbot Interfaces to Databases,” CODS COMAD, Jan. 2021, pp. 47-55. [cited by applicant]
United States Office Action, U.S. Appl. No. 17/508,442, Feb. 15, 2022, 30 pages. [cited by applicant]
United States Office Action, U.S. Appl. No. 17/508,442, Apr. 1, 2022, 33 pages. [cited by applicant]
United States Office Action, U.S. Appl. No. 17/508,442, Aug. 15, 2022, 38 pages. [cited by applicant]
United States Office Action, U.S. Appl. No. 17/508,442, Dec. 19, 2022, 39 pages. [cited by applicant]
United States Office Action, U.S. Appl. No. 17/508,442, Mar. 31, 2023, 41 pages. [cited by applicant]
United States Office Action, U.S. Appl. No. 17/508,442, Nov. 9, 2023, 41 pages. [cited by applicant]
United States Office Action, U.S. Appl. No. 17/508,442, Dec. 29, 2023, 46 pages. [cited by applicant]