Natural language processing with pre-specified SQL queries
A natural language processing system with pre-specified SQL queries is provided. A user input can be performed via a graphical user interface. The system can process via natural language processing, and return an intent field corresponding to one or more variables. Pre-specified SQL queries can be provided for possible intents. The query can be altered by populating with particular parameters. In addition, an answer can be returned to the user comprising natural language results and graphical material.
1. A system for natural language processing having an intent-refinement graphical user interface using a pre-specified database query, the system comprising at least one hardware processor, and a memory storing computer program instructions which when executed by the at least one hardware processor cause the at least one hardware processor to perform operations comprising:
training the system, by a machine learning technique, to identify a user intent relating to a business travel query, the user intent corresponding to a flight count, a hotel booking count, a total spending amount by an individual or corporation, a personal habit of an employee traveling for business, a date restriction of the business travel query, a location where the employee has traveled for business, a corporation for whom the business traveler has traveled for business, an airline carrier or hotel operator providing business travel services, or whether a business travel booking is made online or offline, resulting in a first trained system state;
displaying a text box configured to accept free-form text input typed in by the user;
receiving from the user the free-form text input in the free form natural language form;
determining, by the system a first perceived user intent, the first perceived user intent solely based on the free-form text input, and not based on the user's selecting a predefined intent displayed on the display;
displaying to the user, by a table associated with the graphical user interface, first results associated with a first perceived user intent in connection with business travel based on interpreting the first input, wherein the first results comprise:
a first column of the table displaying at least one interpretation by the system of perceived user intent based on the free-form text input typed by the user; and
a second column of the table displaying a user-selectable graphical element, wherein the second column has a selectable element comprising a drop-down menu, wherein the selectable element is configured to provide options for user refinement of the at least one interpretation by the system of perceived user intent;
receiving from the user second input, based on a user selection of the user-selectable graphical element in the second column of the table, corresponding to a refinement of the perceived user intent; and
incorporating into the system the refinement, resulting in a second trained system state.