Heuristics-based sql query generation engine

Abstract

A database is one of the prime media to store data. Most of the time, relational databases are preferred over other databases due to their ability to represent complex relationships between data. Languages like Structured Query Language (SQL) are used to retrieve data stored in relational databases. Information stored in these databases is often accessed by naïve users who do not possess high competencies in technical database querying. Therefore, Natural Language Interfaces to Databases (NLIDB) are being developed to translate natural language into SQL queries and retrieve the corresponding database results. This paper proposes a novel NLIDB called SQL Query Generation Engine which has been developed using a heuristics-based approach. The system was tested with more than 200 natural language queries and has shown an overall accuracy of 93%.