IP Library › Granted Patent US 12,748,790
Granted Patent B2
US 12,748,790 · App. 17/940,494 · Granted Sep 29, 2026

Hybrid database interface with intent expansion

Inventors: Karina Elayne Kervin (Sacramento, CA); Manish Kesarwani (Bengaluru, IN); Satyajeet Raje (White Plains, NY); Nergal Issaie (San Jose, CA)
Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
G06F16/3344G06F16/3328G06F16/3329
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,748,790
App. No.
17/940,494
Granted
Sep 29, 2026
Kind
B2
Abstract

An embodiment includes generating an intent string representative of a user's intention based on an input string from the user. The embodiment generates a search string that includes text from the input string and text from the intent string, and then executes a text-based query and an ontology-based query against a graph database using the search string. The embodiment generates a combined set of search results from search results of the text-based query and search results of the ontology-based query. The embodiment generates final relevance scores for the combined set of search results by adjusting at least a portion of preliminary relevance scores of the combined set of search results. The embodiment generates a query response that includes the combined set of search results ranked according to the final relevance scores.

Claims (67)

1 . A computer-implemented method comprising:

generating an intent string representative of a user's intention based on an input string received as an input by the user, wherein the input includes a query request directed to querying a graph database;

generating a search string that includes text from the input string and text from the intent string, wherein the generating the search string further comprises:

processing the input string using a natural language processing technique to extract a phrase from the input string, producing an extracted phrase;

generating a vector embedding of the extracted phrase;

extracting one or more phrases from metadata associated with the graph database;

computing one or more embeddings for the one or more phrases extracted from the metadata;

identifying a closest phrase based on a similarity comparison between the vector embedding of the extracted phrase and the one or more embeddings for the one or more phrases extracted from the metadata; and

appending text from the closest phrase to the search string;

executing a text-based query against the graph database using the search string;

executing an ontology-based query against the graph database using the search string;

generating a combined set of search results from a first set of search results and a second set of search results, wherein the first set of search results is from the text-based query, and wherein the second set of search results is from the ontology-based query;

generating final relevance scores for the combined set of search results by adjusting at least a portion of preliminary relevance scores of the combined set of search results; and

generating a query response that includes the combined set of search results ranked according to the final relevance scores.

2 . The computer-implemented method of claim 1 , wherein the generating of the intent string comprises processing the input string using a natural language processing technique.

3 . The computer-implemented method of claim 1 , wherein the generating of the intent string comprises extracting a phrase from the input string and generating a query embedding representative of the phrase.

4 . The computer-implemented method of claim 3 , wherein the generating of the intent string comprises extracting metadata from the graph database and generating a data embedding representative of the metadata.

5 . The computer-implemented method of claim 4 , wherein the generating of the intent string comprises ranking the data embedding among other data embeddings based on a comparison of the data embedding to the query embedding.

6 . The computer-implemented method of claim 1 , wherein the text-based query comprises matching the text from the input string and text from the intent string to textual properties of indexed nodes and relationships of the graph database.

7 . The computer-implemented method of claim 1 , wherein the ontology-based query comprises generating a network template that includes text from the input string and text from the intent string and matching nodes and relationships of the graph database to the network template.

8 . The computer-implemented method of claim 1 , wherein the adjusting of at least a portion of the preliminary relevance scores comprises normalizing the preliminary relevance scores of the first and second sets of search results.

9 . The computer-implemented method of claim 1 , further comprising:

identifying a table that is included in both the first set of search results and the second set of search results,

wherein the adjusting of at least a portion of the preliminary relevance scores comprises increasing the preliminary relevance score of the table responsive to identifying that the table is included in both the first set of search results and the second set of search results.

10 . The computer-implemented method of claim 9 , wherein the adjusting of the preliminary relevance score of the table comprises increasing the preliminary relevance score by a predetermined percentage of the preliminary relevance score.

11 . A computer program product comprising one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable by a processor to cause the processor to perform operations comprising:

generating an intent string representative of a user's intention based on an input string received as an input by the user, wherein the input includes a query request directed to querying a graph database;

generating a search string that includes text from the input string and text from the intent string, wherein the generating the search string further comprises:

processing the input string using a natural language processing technique to extract a phrase from the input string, producing an extracted phrase;

generating a vector embedding of the extracted phrase;

extracting one or more phrases from metadata associated with the graph database;

computing one or more embeddings for the one or more phrases extracted from the metadata;

identifying a closest phrase based on a similarity comparison between the vector embedding of the extracted phrase and the one or more embeddings for the one or more phrases extracted from the metadata; and

appending text from the closest phrase to the search string;

executing a text-based query against the graph database using the search string;

executing an ontology-based query against the graph database using the search string;

generating a combined set of search results from a first set of search results and a second set of search results, wherein the first set of search results is from the text-based query, and wherein the second set of search results is from the ontology-based query;

generating final relevance scores for the combined set of search results by adjusting at least a portion of preliminary relevance scores of the combined set of search results; and

generating a query response that includes the combined set of search results ranked according to the final relevance scores.

12 . The computer program product of claim 11 , wherein the program instructions are stored in a computer readable storage device in a data processing system, and wherein the program instructions are transferred over a network from a remote data processing system.

13 . The computer program product of claim 11 , wherein the program instructions are stored in a computer readable storage device in a server data processing system, and wherein the program instructions are downloaded in response to a request over a network to a remote data processing system for use in a computer readable storage device associated with the remote data processing system, further comprising:

program instructions to meter use of the program instructions associated with the request; and

program instructions to generate an invoice based on the metered use.

14 . The computer program product of claim 11 , wherein the generating of the intent string comprises processing the input string using a natural language processing technique.

15 . The computer program product of claim 11 , wherein the generating of the intent string comprises extracting a phrase from the input string and generating a query embedding representative of the phrase.

16 . The computer program product of claim 11 , further comprising:

identifying a table that is included in both the first set of search results and the second set of search results,

wherein the adjusting of at least a portion of the preliminary relevance scores comprises increasing the preliminary relevance score of the table responsive to identifying that the table is included in both the first set of search results and the second set of search results.

17 . A computer system comprising a processor and one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions executable by the processor to cause the processor to perform operations comprising:

generating an intent string representative of a user's intention based on an input string received as an input by the user, wherein the input includes a query request directed to querying a graph database;

generating a search string that includes text from the input string and text from the intent string, wherein the generating the search string further comprises:

processing the input string using a natural language processing technique to extract a phrase from the input string, producing an extracted phrase;

generating a vector embedding of the extracted phrase;

extracting one or more phrases from metadata associated with the graph database;

computing one or more embeddings for the one or more phrases extracted from the metadata;

identifying a closest phrase based on a similarity comparison between the vector embedding of the extracted phrase and the one or more embeddings for the one or more phrases extracted from the metadata; and

appending text from the closest phrase to the search string;

executing a text-based query against the graph database using the search string;

executing an ontology-based query against the graph database using the search string;

generating a combined set of search results from a first set of search results and a second set of search results, wherein the first set of search results is from the text-based query, and wherein the second set of search results is from the ontology-based query;

generating final relevance scores for the combined set of search results by adjusting at least a portion of preliminary relevance scores of the combined set of search results; and

generating a query response that includes the combined set of search results ranked according to the final relevance scores.

18 . The computer system of claim 17 , wherein the generating of the intent string comprises processing the input string using a natural language processing technique.

19 . The computer system of claim 17 , wherein the generating of the intent string comprises extracting a phrase from the input string and generating a query embedding representative of the phrase.

20 . The computer system of claim 17 , further comprising:

identifying a table that is included in both the first set of search results and the second set of search results,

wherein the adjusting of at least a portion of the preliminary relevance scores comprises increasing the preliminary relevance score of the table responsive to identifying that the table is included in both the first set of search results and the second set of search results.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 8, 2022
From: KERVIN, KARINA ELAYNE; KESARWANI, MANISH; RAJE, SATYAJEET; ISSAIE, NERGAL
To: INTERNATIONAL BUSINESS MACHINES CORPORATION
Reel/Frame 061027/0414 →
Continuity (1)
Related Publication 20240086437A1 · Mar 14, 2024
References Cited (39)
US 6675159B1 · Lin et al. · 2004 [cited by applicant]
US 8468163B2 · Gupta et al. · 2013 [cited by applicant]
US 9367536B2 · Raina · 2016 [cited by examiner]
US 9448995B2 · Kurz · 2016 [cited by applicant]
US 9747390B2 · Cooper et al. · 2017 [cited by applicant]
US 10002189B2 · Cheyer · 2018 [cited by applicant]
US 10509814B2 · Lastra Diaz et al. · 2019 [cited by applicant]
US 10649990B2 · Harris et al. · 2020 [cited by applicant]
US 10853396B2 · Miseldine et al. · 2020 [cited by applicant]
US 10977164B2 · Saha et al. · 2021 [cited by applicant]
US 11176323B2 · Bull et al. · 2021 [cited by applicant]
US 11200222B2 · Sen et al. · 2021 [cited by applicant]
US 11288294B2 · Wason et al. · 2022 [cited by applicant]
US 11790006B2 · Prakash · 2023 [cited by examiner]
US 20190188285A1 · Scheau · 2019 [cited by examiner]
US 20200272651A1 · Luo · 2020 [cited by examiner]
US 20200387551A1 · Hays et al. · 2020 [cited by applicant]
US 20210064932A1 · Wang · 2021 [cited by examiner]
US 20210294829A1 · Bender et al. · 2021 [cited by applicant]
US 20210342380A1 · Luus et al. · 2021 [cited by applicant]
US 20220035866A1 · Carrier et al. · 2022 [cited by applicant]
US 20220051665A1 · Bade et al. · 2022 [cited by applicant]
US 20220138216A1 · Kesarwani et al. · 2022 [cited by applicant]
US 20220156299A1 · Kervin et al. · 2022 [cited by applicant]
US 20220172040A1 · Kazi · 2022 [cited by examiner]
US 20240386015A1 · Crabtree · 2024 [cited by examiner]
Saha et al.; ATHENA: An Ontology-driven System For Natural Language Querying Over Relational Data Stores, VLDB Endowment, vol. 9, No. 12, pp. 1209-1220, Aug. 1, 2016. [cited by applicant]
Sen et al.; ATHENA++: Natural Language Querying For Complex Nested SQL Queries, VLDB Endowment, vol. 13, No. 11, pp. 2747-2759, Aug. 1, 2020. [cited by applicant]
Damljanovic et al.; Natural Language Interfaces to Ontologies: Combining Syntactic Analysis and Ontology-based Lookup through the User Interaction, Extended Semantic Web Conference On, pp. 106-120, May 30-Jun. 2, 2010. [cited by applicant]
Sukys et al.; SBVR Based Natural Language Interface to Ontologies, Journal Of Information Technology And Control, vol. 46, No. 1, pp. 118-137, Feb. 23, 2017. [cited by applicant]
Solis-Sanchez et al.; Toward A Natural-Language Interface In Ontologies For Disambiguation, Research In Computer Science, vol. 149, No. 8, pp. 1227-1241, Aug. 2020. [cited by applicant]
Zhu et al., A natural language interface to a graph-based bibliographic information retrieval system, Data & Knowledge Engineering, vol. 111, Sep. 2017, pp. 73-89. [cited by applicant]
Formica et al., A Bayesian approach for semantic search based on DAG-shaped ontologies, Lecture Notes in Computer Science book series (LNISA, vol. 10439), Aug. 2, 2017. [cited by applicant]
Rocha et al., A hybrid approach for searching in the semantic web, WWW '04: Proceedings of the 13th international conference on World Wide Web, May 17, 2004, pp. 374-383. [cited by applicant]
Fernandez et al., Semantically enhanced Information Retrieval: An ontology-based approach, Web Semantics: Science, Services and Agents on the World Wide Web, vol. 9 Issue 4, Dec. 1, 2011, pp. 434-452. [cited by applicant]
Stojanovic et al., An approach for the ranking of query results in the semantic web, pp. 500-516, 2003. [cited by applicant]
Rada et al., Development and application of a metric on semantic nets, IEEE Transactions on Systems, Man, and Cybernetics, vol. 19, No. 1, pp. 17-30, Jan./Feb. 1989. [cited by applicant]
Thenmalar et al., Ontology based semantic similarly ranking of documents, ACAI '11: Proceedings of the International Conference on Advances in Computing and Artificial Intelligence, Jul. 21-22, 2011, pp. 107-110. [cited by applicant]
Xamena et al., A structural analysis of topic ontologies, Information Sciences, vol. 421, Aug. 2017. [cited by applicant]