Digital Repository

A Natural Language Understanding Sequential Model for Generating Queries with Multiple SQL Commands

Show simple item record

dc.contributor.author Sonnadara, Tharushi
dc.date.accessioned 2024-04-30T05:28:08Z
dc.date.available 2024-04-30T05:28:08Z
dc.date.issued 2023
dc.identifier.citation Sonnadara, Tharushi (2023) A Natural Language Understanding Sequential Model for Generating Queries with Multiple SQL Commands. BSc. Dissertation, Informatics Institute of Technology en_US
dc.identifier.issn 2019689
dc.identifier.uri http://dlib.iit.ac.lk/xmlui/handle/123456789/2096
dc.description.abstract "The use of natural language to query databases has become increasingly popular, particularly for non-technical users. However, mapping natural language queries to SQL remains a challenging task due to the inherent complexity of natural language processing. This poses a significant problem for businesses that want to leverage big data but lack the technical expertise to do so. People who do not have SQL knowledge, on the other hand, will be unable to obtain the necessary information. To overcome these issues GenSQL proposes a solution that gives hand for non-technical users to interact with SQL Queries when they need to perform any action with databases. The system automates the conversion of natural language text into SQL queries, enabling non-technical users to interact with databases easily and retrieve the required data. It can process complex queries and manage multiple SQL query creation, making data retrieval more efficient and effective. Overall, GenSQL provides a valuable tool for businesses to access data insights and make informed decisions based on data. The system's performance was evaluated using BLEU and ROUGE scores, which are data science metrics that measure the similarity between generated SQL queries and the ground truth. Additionally, user studies were conducted to evaluate the system's usability, where it was found to be effective in retrieving the desired data. GenSQL offers a valuable solution for businesses interested in leveraging big data, particularly for non-technical users without SQL expertise." en_US
dc.language.iso en en_US
dc.subject Natural Language Processing en_US
dc.subject Artificial Intelligence en_US
dc.subject Structured Query Language en_US
dc.title A Natural Language Understanding Sequential Model for Generating Queries with Multiple SQL Commands en_US
dc.type Thesis en_US


Files in this item

This item appears in the following Collection(s)

Show simple item record

Search


Advanced Search

Browse

My Account