Natural Language to SQL: Automated Query Formation Using NLP Techniques
SL Y., et al.
(2023)
E3S Web of Conferences
- There is no summary for this article.
Medical and Health Science
Abstract
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
Comments are visible to all users.
Login or Register for free to comment on this publication.
Your personal notes related to this publication. These notes are only visible to you, will save automatically, and will be here when you come back.
Login or Register for free to make personal notes.
Authors: | SL Y., P G., S Puranam, SR Vemula, P Doulathbaji, A Bellamkonda |
Year published: | 2023 |
DOI: | 10.1051/e3sconf/202339101115 |
Full-text available: | Yes |
Journal: | E3S Web of Conferences |
Publisher: | EDP Sciences |

Search Controls
Log in or Register for free to adjust controls.
Adjust how much the below factors influence search score
Boost the overall effect of controls on search score

Citation
Something went wrong trying to cite the current publication. Please try again later.

Share this article

Badges

Downloads
Log in or Register for free to download citations