Patents by Inventor Tesfagabir Meharizghi

Tesfagabir Meharizghi has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • CONVERTING NATURAL LANGUAGE QUERIES TO SQL QUERIES USING ONTOLOGICAL CODES AND PLACEHOLDERS
    Publication number: 20250013636
    Abstract: An NLQ-SQLQ tool or service of a provider network may receive a natural language query (NLQ) from a client and convert the NLQ to an SQL query using ontological codes and placeholders. For one or more portions of the NLQ, the tool/service determines that the portion is associated with one or more codes of an ontology. The tool/service then assigns, based on criteria, a particular code to the portion. The tool/service replaces portions of the NLQ with different argument placeholders to generate a modified NLQ. A trained model converts the modified NLQ into an initial SQL query that has argument placeholders and subquery placeholders. The tool/service generates a final SQL query based on the initial SQL query, predefined SQL subquery templates associated with the subquery placeholders, and codes associated with the argument placeholders. The tool/service executes the final SQL query and sends results to the client.
    Type: Application
    Filed: September 20, 2024
    Publication date: January 9, 2025
    Applicant: Amazon Technologies, Inc.
    Inventors: Miguel Romero Calvo, Tesfagabir Meharizghi, Thiruvarul Selvan Senthivel, Saman Sarraf, Lin Lee Cheong
  • Converting natural language queries to SQL queries using ontological codes and placeholders
    Patent number: 12124440
    Abstract: An NLQ-SQLQ tool or service of a provider network may receive a natural language query (NLQ) from a client and convert the NLQ to an SQL query using ontological codes and placeholders. For one or more portions of the NLQ, the tool/service determines that the portion is associated with one or more codes of an ontology. The tool/service then assigns, based on criteria, a particular code to the portion. The tool/service replaces portions of the NLQ with different argument placeholders to generate a modified NLQ. A trained model converts the modified NLQ into an initial SQL query that has argument placeholders and subquery placeholders. The tool/service generates a final SQL query based on the initial SQL query, predefined SQL subquery templates associated with the subquery placeholders, and codes associated with the argument placeholders. The tool/service executes the final SQL query and sends results to the client.
    Type: Grant
    Filed: September 13, 2021
    Date of Patent: October 22, 2024
    Assignee: Amazon Technologies, Inc.
    Inventors: Miguel Romero Calvo, Tesfagabir Meharizghi, Thiruvarul Selvan Senthivel, Saman Sarraf, Lin Lee Cheong