Systems and methods for processing a natural language query in data tables

Abstract

Systems and methods are disclosed herein for processing a natural language query on data tables. According to some embodiments, a query term is obtained from a natural language query. A table summary is prepared based on the query term and a formula of the natural language query is generated based on the table summary. A result is generated based on the formula. Responsive to receiving negative feedback to the result, one or more of the table summary or the formula is disassociated from the query term.

What is claimed is: 
     
         1 . A method for processing a natural language query, the method comprising:
 obtaining, by a processor, a query term from the natural language query;   preparing a table summary based on the query term;   generating a formula of the natural language query based on the table summary;   generating a result based on the formula; and   responsive to receiving negative feedback to the result, disassociating one or more of the table summary or the formula with the query term.   
     
     
         2 . The method of  claim 1 , wherein the natural language query is provided by a user via a user interface at a client device. 
     
     
         3 . The method of  claim 2 , wherein the natural language query is manually or vocally entered by the user. 
     
     
         4 . The method of  claim 1 , wherein the natural language query is received at a server from a client device via a hypertext transfer protocol (HTTP) post request. 
     
     
         5 . The method of  claim 1 , wherein the natural language query is originated in a first language and is then translated into a second language. 
     
     
         6 . The method of  claim 1 , wherein the result is presented to a user via a visualization format including any of an answer statement, a chart, or a data plot. 
     
     
         7 . The method of  claim 1 , further comprising:
 storing the formula associated with the natural language query or the query term when the user feedback is positive.   
     
     
         8 . The method of  claim 1 , further comprising translating a logic operation into the formula by:
 selecting a formula build operation from a plurality of formula build operations based on a logic operation, wherein the formula build operation corresponds to a type of formula; and   executing the formula build operation to generate the formula based on the table summary and the logic operation.   
     
     
         9 . The method of  claim 1 , wherein the result is translated into a respective language when the natural language query is received in the respective language from the user. 
     
     
         10 . A system for processing a natural language query, the system comprising:
 a memory; and   a processor, coupled to the memory, to:
 obtain a query term from the natural language query; 
 prepare a table summary based on the query term; 
 generate a formula of the natural language query based on the table summary; 
 generate a result based on the formula; and 
 responsive to receiving negative feedback to the result, disassociate one or more of the table summary or the formula with the query term. 
   
     
     
         11 . The system of  claim 10 , wherein the natural language query is provided by a user via a user interface at a client device. 
     
     
         12 . The system of  claim 11 , wherein the natural language query is manually or vocally entered by the user. 
     
     
         13 . The system of  claim 10 , wherein the natural language query is received at a server from a client device via a hypertext transfer protocol (HTTP) post request. 
     
     
         14 . The system of  claim 10 , wherein the natural language query is originated in a first language and is then translated into a second language. 
     
     
         15 . The system of  claim 10 , wherein the result is presented to a user via a visualization format including any of an answer statement, a chart, or a data plot. 
     
     
         16 . The system of  claim 10 , wherein the processor is further to:
 store the formula associated with the natural language query or the query term when the user feedback is positive.   
     
     
         17 . The system of  claim 10 , wherein the processor is further to translate a logic operation into the formula by:
 select a formula build operation from a plurality of formula build operations based on a logic operation, wherein the formula build operation corresponds to a type of formula; and   execute the formula build operation to generate the formula based on the table summary and the logic operation.   
     
     
         18 . The system of  claim 10 , wherein the result is translated into a respective language when the natural language query is received in the respective language from the user. 
     
     
         19 . A computer-readable non-transitory storage medium storing processor-executable instructions for a processor, the instructions to cause the processor to:
 obtain a query term from a natural language query;   prepare a table summary based on the query term;   generate a formula of the natural language query based on the table summary;   generate a result based on the formula; and   responsive to receiving negative feedback to the result, disassociate one or more of the table summary or the formula with the query term.   
     
     
         20 . The computer-readable non-transitory storage medium of  claim 19 , wherein the processor is further to translate a logic operation into the formula by:
 select a formula build operation from a plurality of formula build operations based on a logic operation, wherein the formula build operation corresponds to a type of formula; and   execute the formula build operation to generate the formula based on the table summary and the logic operation.