Refining understanding of natural language database queries

A computer system for creating rules for a rule-based natural language interface for databases (NLIDB), the computer system comprising:

• one or more processors, one or more computer-readable memories, one or more computer-readable storage media, and program instructions stored on at least one of the one or more computer-readable storage media for execution by at least one of the one or more processors via at least one of the one or more computer-readable memories, wherein the computer system is capable of performing a method comprising:
• receiving a natural language query from a user, wherein the natural language query includes an original word;
• generating a first explanation for the natural language query using a deep learning model, wherein the first explanation includes a database value, and displaying the first explanation to the user;
• generating a second explanation for the natural language query using the rule-based natural language interface, wherein the second explanation includes a rule-based database value, and displaying the second explanation to the user;
• receiving a first decision and a second decision from the user, wherein the first decision indicates whether the first explanation represents the natural language query and the second decision indicates whether the second explanation represents the natural language query;
• in response to the first decision from the user indicating that the first explanation represents the natural language query and the second decision from the user indicating that the second explanation does not represent the natural language query, identifying the database value in the first explanation;
• and
• creating a rule in a table for the rule-based natural language interface that associates the database value with the original word of the natural language query.

A computer program product for creating rules for a rule-based natural language interface for databases, the computer program product comprising:

• a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to perform a method comprising:
• receiving a natural language query from a user, wherein the natural language query includes an original word;
• generating a first explanation for the natural language query using a deep learning model, wherein the first explanation includes a database value, and displaying the first explanation to the user;
• generating a second explanation for the natural language query using the rule-based natural language interface, wherein the second explanation includes a rule-based database value, and displaying the second explanation to the user;
• receiving a first decision and a second decision from the user, wherein the first decision indicates whether the first explanation represents the natural language query and the second decision indicates whether the second explanation represents the natural language query;
• in response to the first decision from the user indicating that the first explanation represents the natural language query and the second decision from the user indicating that the second explanation does not represent the natural language query, identifying the database value in the first explanation;
• and
• creating a rule in a table for the rule-based natural language interface that associates the database value with the original word of the natural language query.