CASE STUDY

Create Natural Language Interface to Database

CATEGORY

Management

DATE

January 19th, 2018

AUTHOR

Weichang Yu

PROGRAMMING LANGUAGE

Java

Challenge

Non-technical users tend to have issues retrieving data from database. It takes time and effort to study database language in order to manipulate the data.

Solution

We present a natural language interface to databases, which allows non-technical users to query database without having to learn database language. The system uses NLP to parse input English language into some intermediate representation, which will be mapped to database tokens. These tokens will be reorganized in a structured way so that a valid query can be formed. By querying the formed query against database, the user will be able to retrieve structured data. The system incorporates a combination of Natural Language Processing, information retrieval, and efficient query processing strategies

Result

We allowed non-technical users to use English sentences to query against a database. A user is able to see the intermediate results of how his query is parsed by our tool and also list of values returned by the database.


Want to learn more?

Let’s Chat

Location

205 Placer Ct, Unit 204
North York,OON M2H 0A9