Heuristics-Based SQL Query Generation Engine

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....

Full description

Saved in:
Bibliographic Details
Published in2021 6th International Conference on Information Technology Research (ICITR) pp. 1 - 7
Main Authors Sugandhika, Chinthani, Ahangama, Supunmali
Format Conference Proceeding
LanguageEnglish
Published IEEE 01.12.2021
Subjects
Engines
Graphical user interfaces
heuristics-based approach
Information technology
Media
natural language query
Natural languages
naïve users
NLIDB
NLP
relational database
Relational databases
SQL
Structured Query Language
Online AccessGet full text

Cover

More Information
Summary: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%.
DOI:10.1109/ICITR54349.2021.9657317