Conversion of Natural Language Query to SQL Query
Title | Conversion of Natural Language Query to SQL Query |
Publication Type | Conference Paper |
Year of Publication | 2018 |
Authors | Kate, Abhilasha, Kamble, Satish, Bodkhe, Aishwarya, Joshi, Mrunal |
Conference Name | 2018 Second International Conference on Electronics, Communication and Aerospace Technology (ICECA) |
ISBN Number | 978-1-5386-0965-1 |
Keywords | Conferences, Data Dictionary, Databases, Dictionaries, Human Behavior, natural language processing, natural language query, pubcrawl, query processing, relational database management system, relational databases, resilience, Resiliency, Scalability, Semantic, Semantics, speech format, speech-to-text, SQL, SQL query, Structured Query Language, student database, Syntactic, text format |
Abstract | This paper present an approach to automate the conversion of Natural Language Query to SQL Query effectively. Structured Query Language is a powerful tool for managing data held in a relational database management system. To retrieve or manage data user have to enter the correct SQL Query. But the users who don't have any knowledge about SQL are unable to retrieve the required data. To overcome this we proposed a model in Natural Language Processing for converting the Natural Language Query to SQL query. This helps novice user to get required content without knowing any complex details about SQL. This system can also deal with complex queries. This system is designed for Training and Placement cell officers who work on student database but don't have any knowledge about SQL. In this system, user can also enter the query using speech. System will convert speech into the text format. This query will get transformed to SQL query. System will execute the query and gives output to the user. |
URL | https://ieeexplore.ieee.org/document/8474639 |
DOI | 10.1109/ICECA.2018.8474639 |
Citation Key | kate_conversion_2018 |
- Resiliency
- text format
- Syntactic
- student database
- Structured Query Language
- SQL query
- SQL
- speech-to-text
- speech format
- Semantics
- Semantic
- Scalability
- Conferences
- resilience
- relational databases
- relational database management system
- query processing
- pubcrawl
- natural language query
- natural language processing
- Human behavior
- Dictionaries
- Databases
- Data Dictionary