The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 18, 2022
Filed:
Dec. 31, 2019
International Business Machines Corporation, Armonk, NY (US);
The Regents of the University of Michigan, Ann Arbor, MI (US);
Yunyao Li, San Jose, CA (US);
Christopher J. Baik, Ann Arbor, MI (US);
Hosagrahar V. Jagadish, Ann Arbor, MI (US);
International Business Machines Corporation, Armonk, NY (US);
The Regents of the University of Michigan, Ann Arbor, MI (US);
Abstract
A natural language interface for databases (NLIDB) component of a database-management system receives a user-submitted natural-language query. The NLIDB parses the query into keywords and maps each keyword onto a corresponding query fragment that identifies a predicate of a non-join condition, or other type of expression, of a structured query. The NLIDB selects an optimal mapping for each keyword with the aid of a Query Fragment Graph (QFG) that counts the number of occurrences of each fragment, and the number of co-occurrences of each pair of fragments, in previously received structured queries. The NLIDB then uses the QFG, optionally augmented by contextual data, to select join paths most likely to be consistent with the semantic intent of the user. The NLIDB generates a structured query that incorporates the mapped query fragments and selected join paths and forwards. The structured the query is then forwarded to downstream DBMS components.