Programmatic Database Language Generation for Big Data Applications

Abstract

Database management systems offer an efficient way of managing huge amount of data such as financial and healthcare data and he data retrieval from databases requires knowledge of Structured Query Language (SQL). In this paper, an Automatic SQL Generation System is proposed to help users who are inexperienced in querying database with SQL. The proposed SQL generation system reads formatted data items in the query report from the user and converts the data items into SQL statements programmatically with the help of a data model that is pulled from a database. The SQL generation system can handle simple queries composed of a query block with a SELECT statement as well as complex queries composed of multiple query blocks containing multiple SELECT statements. The proposed system is integrated with an NLIDB (Natural Language Interface for Database) system to translate data items (or tokens) extracted from queries in natural languages into SQL query language, and the system is also integrated and adapted with various types of databases and use cases that include financial and healthcare use cases. The experiment results show that the proposed system correctly handles user queries in natural language just like any other neural model based system and more importantly, the proposed SQL generation engine generates SQL queries without syntactic problems with various databases for all queries.