Communicating with a database management system using a chatbot

Abstract

The disclosed technology can receive a voice query or text query in a natural language and translate it from natural language to a native database management language to respond to the query. For example, a human can ask his or her computer to “show large emails from December 2016”, and a data agent on computer can receive the voice request, convert audio associated with the voice to words in natural language, convert natural language into a SQL query, and convert the SQL query into a database management query. The data agent is trained with a corpus of technical documents and rules to determine the intent or keywords for answering the query. In some implementations, the disclosed technology can also include a chatbot and/or administrative assistant to enable a human to interface with a database management software using voice or text. In some implementations, the disclosed technology allows the user to automatically connect to a help desk technician to assist in completing the query.

I/We claim: 
     
         1 . A computer-readable storage medium storing instructions that, when executed by a computing system, cause the computing system to perform operations for providing a chatbot for assistance in using database management software, the operations comprising:
 receiving a user query via a graphical user interface, wherein the graphical user interface is a chatbot;   translating the user query from a natural language to a database software language;   determining whether user has provided required parameters for a proper query, wherein determining whether the user provided required parameters includes querying an action database with pre-determined queries and responses;   based on the database software language translation, determining a response to the user query; and   providing the response to the user in the graphical user interface, and wherein the graphical user interface provides the user with an option for modifying the user query after viewing the response.   
     
     
         2 . The computer-readable storage medium of  claim 1 , wherein the graphical user interface is displayed on a mobile device. 
     
     
         3 . The computer-readable storage medium of  claim 1 , wherein translating the user query includes accessing a technical document corpus. 
     
     
         4 . The computer-readable storage medium of  claim 3 , wherein the technical document corpus is modified using machine learning algorithms trained on historical data regarding tasks performed in the database management system. 
     
     
         5 . The computer-readable storage medium of  claim 4 , wherein the technical document corpus is modified by the user. 
     
     
         6 . The computer-readable storage medium of  claim 5 , wherein the user modifies the technical document corpus by requesting the modification using the chatbot. 
     
     
         7 . The computer-readable storage medium of  claim 1 , wherein database software language is DB2®, MySQL®, Oracle®, PostgreSQL® or SQLite®. 
     
     
         8 . The computer-readable storage medium of  claim 1 , wherein the operations further comprises automatically connecting the user to a help desk technician upon the user's request to be connected to a help desk. 
     
     
         9 . The computer-readable storage medium of  claim 8 , wherein the help desk technician is connected to the user via the graphical user interface, a telephone, or video conference. 
     
     
         10 . The computer-readable storage medium of  claim 1 , wherein the operations further comprises requesting the user to provide additional parameters missing from the user's query. 
     
     
         11 . A computer-readable storage medium storing instructions that, when executed by a computing system, cause the computing system to perform operations comprising:
 establishing a connection with a voice-recognition device;   transmitting instructions to the voice-recognition device to install a voice data agent, where the voice data agent causes the voice-recognition device to install a modified vocabulary for database management queries;   receiving an audio query;   determine an intent of the audio query based on executing a query operation with a REST API of the voice-recognition device; and   transmitting a response to the audio query based at least partially on the executed operations.   
     
     
         12 . The computer-readable storage medium of  claim 11 , wherein voice-recognition device is a mobile device. 
     
     
         13 . The computer-readable storage medium of  claim 11 , wherein the modified vocabulary is modified using machine learning algorithms trained on historical data regarding tasks performed in the database management system. 
     
     
         14 . The computer-readable storage medium of  claim 11 , wherein the modified vocabulary is at least partially provided by a user. 
     
     
         15 . The computer-readable storage medium of  claim 11 , the operations further comprising automatically connecting a user to a help desk technician upon the user's request to be connected to a help desk. 
     
     
         16 . The computer-readable storage medium of  claim 15 , wherein the help desk technician is connected to the user via a graphical user interface, a telephone, or video conference. 
     
     
         17 . The computer-readable storage medium of  claim 11 , the operations further comprising requesting the user to provide additional parameters missing from a user's query. 
     
     
         18 . A computer-readable storage medium storing instructions that, when executed by a computing system, cause the computing system to perform operations for providing a chatbot for assistance in communicating with a database management system using database management software, the operations comprising:
 receiving a user query via a graphical user interface, wherein the graphical user interface is a chatbot;   translating the user query from a natural language to a database software language;   determining whether user has provided required parameters for a proper query, wherein determining whether the user provided required parameters includes querying an action database with pre-determined queries and responses;   based on the database software language translation, determining a response to the user query wherein the response to the user query comprises at least one of: taking action in the database management system, an answer associated with the database management system, and a confirmation associated with the database management system; and   providing the response to the user in the graphical user interface, and wherein the graphical user interface provides the user with an option for modifying the user query after viewing the response.   
     
     
         19 . The computer-readable storage medium of  claim 18 , wherein translating the user query from a natural language to a database software language comprises translating the natural language into a domain language query, and translating the domain language query to a database software query. 
     
     
         20 . The computer-readable storage medium of  claim 18 , wherein taking action in the database management system comprises communicating with a storage manager associated with the database management system to execute the action.