Natural Language to SQL: Automated Query Formation Using NLP Techniques
In this era of information world, given any topic, we are able to get relevant data or documents at a mouse click. The flexibility that internet provides is the user friendly language or Natural Language to search for required topic. Natural Language Querying and Retrieval has made internet popular....
Main Authors: | , , , , , |
---|---|
Format: | Article |
Language: | English |
Published: |
EDP Sciences
2023-01-01
|
Series: | E3S Web of Conferences |
Online Access: | https://www.e3s-conferences.org/articles/e3sconf/pdf/2023/28/e3sconf_icmed-icmpc2023_01115.pdf |
_version_ | 1797807787685707776 |
---|---|
author | Y. Sri Lalitha G. Prashanthi Puranam Sravani Vemula Sheethal Reddy Doulathbaji Preethi Bellamkonda Anusha |
author_facet | Y. Sri Lalitha G. Prashanthi Puranam Sravani Vemula Sheethal Reddy Doulathbaji Preethi Bellamkonda Anusha |
author_sort | Y. Sri Lalitha |
collection | DOAJ |
description | In this era of information world, given any topic, we are able to get relevant data or documents at a mouse click. The flexibility that internet provides is the user friendly language or Natural Language to search for required topic. Natural Language Querying and Retrieval has made internet popular. It is implicit for business user to understand what the business data is indicating to find better business opportunities. Querying for required data the business users are using SQL. To effectively Query such systems, the Business users has to master the Language. But many business users may not be aware of the SQL language or may not be aware of the databases and some users feel difficulty to write the long SQL Queries. Therefore, it is equally important to query the database very easily. The work here presents a case study to help the business users to type a query in Natural Language, which then converts into SQL statement and process this SQL query against the Databases and get the expected result. This work proposes QCNER approach to extract SQL properties from Natural Language Query. The proposed approach after the application of SMOTE technique depicts 92.31 accuracy over the existing models.1 |
first_indexed | 2024-03-13T06:27:53Z |
format | Article |
id | doaj.art-6a218444eff547acb1ec34c0ec307c9d |
institution | Directory Open Access Journal |
issn | 2267-1242 |
language | English |
last_indexed | 2024-03-13T06:27:53Z |
publishDate | 2023-01-01 |
publisher | EDP Sciences |
record_format | Article |
series | E3S Web of Conferences |
spelling | doaj.art-6a218444eff547acb1ec34c0ec307c9d2023-06-09T09:12:17ZengEDP SciencesE3S Web of Conferences2267-12422023-01-013910111510.1051/e3sconf/202339101115e3sconf_icmed-icmpc2023_01115Natural Language to SQL: Automated Query Formation Using NLP TechniquesY. Sri Lalitha0G. Prashanthi1Puranam Sravani2Vemula Sheethal Reddy3Doulathbaji Preethi4Bellamkonda Anusha5Department of Information and Technology, Gokaraju Rangaraju Institute of Engineering and TechnologyDepartment of Information and Technology, Gokaraju Rangaraju Institute of Engineering and TechnologyDepartment of Information and Technology, Gokaraju Rangaraju Institute of Engineering and TechnologyDepartment of Information and Technology, Gokaraju Rangaraju Institute of Engineering and TechnologyDepartment of Information and Technology, Gokaraju Rangaraju Institute of Engineering and TechnologyDepartment of Information and Technology, Gokaraju Rangaraju Institute of Engineering and TechnologyIn this era of information world, given any topic, we are able to get relevant data or documents at a mouse click. The flexibility that internet provides is the user friendly language or Natural Language to search for required topic. Natural Language Querying and Retrieval has made internet popular. It is implicit for business user to understand what the business data is indicating to find better business opportunities. Querying for required data the business users are using SQL. To effectively Query such systems, the Business users has to master the Language. But many business users may not be aware of the SQL language or may not be aware of the databases and some users feel difficulty to write the long SQL Queries. Therefore, it is equally important to query the database very easily. The work here presents a case study to help the business users to type a query in Natural Language, which then converts into SQL statement and process this SQL query against the Databases and get the expected result. This work proposes QCNER approach to extract SQL properties from Natural Language Query. The proposed approach after the application of SMOTE technique depicts 92.31 accuracy over the existing models.1https://www.e3s-conferences.org/articles/e3sconf/pdf/2023/28/e3sconf_icmed-icmpc2023_01115.pdf |
spellingShingle | Y. Sri Lalitha G. Prashanthi Puranam Sravani Vemula Sheethal Reddy Doulathbaji Preethi Bellamkonda Anusha Natural Language to SQL: Automated Query Formation Using NLP Techniques E3S Web of Conferences |
title | Natural Language to SQL: Automated Query Formation Using NLP Techniques |
title_full | Natural Language to SQL: Automated Query Formation Using NLP Techniques |
title_fullStr | Natural Language to SQL: Automated Query Formation Using NLP Techniques |
title_full_unstemmed | Natural Language to SQL: Automated Query Formation Using NLP Techniques |
title_short | Natural Language to SQL: Automated Query Formation Using NLP Techniques |
title_sort | natural language to sql automated query formation using nlp techniques |
url | https://www.e3s-conferences.org/articles/e3sconf/pdf/2023/28/e3sconf_icmed-icmpc2023_01115.pdf |
work_keys_str_mv | AT ysrilalitha naturallanguagetosqlautomatedqueryformationusingnlptechniques AT gprashanthi naturallanguagetosqlautomatedqueryformationusingnlptechniques AT puranamsravani naturallanguagetosqlautomatedqueryformationusingnlptechniques AT vemulasheethalreddy naturallanguagetosqlautomatedqueryformationusingnlptechniques AT doulathbajipreethi naturallanguagetosqlautomatedqueryformationusingnlptechniques AT bellamkondaanusha naturallanguagetosqlautomatedqueryformationusingnlptechniques |