Natural language explanation of SQL queries for database education

Data exists everywhere around us. However, despite the rise in dependency on relational databases, there still exists a fundamental limitation to being able to fetch data from them. This is because users are first required to comprehend convoluted structured query languages. As a result, there exist...

Full description

Bibliographic Details
Main Author: Pow, Liang Hong
Other Authors: Sourav S Bhowmick
Format: Final Year Project (FYP)
Language:English
Published: Nanyang Technological University 2022
Subjects:
Online Access:https://hdl.handle.net/10356/159539
_version_ 1826116284009414656
author Pow, Liang Hong
author2 Sourav S Bhowmick
author_facet Sourav S Bhowmick
Pow, Liang Hong
author_sort Pow, Liang Hong
collection NTU
description Data exists everywhere around us. However, despite the rise in dependency on relational databases, there still exists a fundamental limitation to being able to fetch data from them. This is because users are first required to comprehend convoluted structured query languages. As a result, there exist plenty of means to translate natural language to structured query languages. By contrast, there exists little research done in the opposite direction, from structured query language to natural language. This will be essential to aid users in understanding already written queries. To the best of my knowledge, this work is the first to focus on translating structured query language to natural language. This body of work presents an interface that allows users to perform translations from structured query language to natural language as opposed to the conventional natural language to structured query language translation. This helps users understand what each query does.
first_indexed 2024-10-01T04:08:48Z
format Final Year Project (FYP)
id ntu-10356/159539
institution Nanyang Technological University
language English
last_indexed 2024-10-01T04:08:48Z
publishDate 2022
publisher Nanyang Technological University
record_format dspace
spelling ntu-10356/1595392022-06-23T05:39:34Z Natural language explanation of SQL queries for database education Pow, Liang Hong Sourav S Bhowmick School of Computer Science and Engineering ASSourav@ntu.edu.sg Engineering::Computer science and engineering::Data Data exists everywhere around us. However, despite the rise in dependency on relational databases, there still exists a fundamental limitation to being able to fetch data from them. This is because users are first required to comprehend convoluted structured query languages. As a result, there exist plenty of means to translate natural language to structured query languages. By contrast, there exists little research done in the opposite direction, from structured query language to natural language. This will be essential to aid users in understanding already written queries. To the best of my knowledge, this work is the first to focus on translating structured query language to natural language. This body of work presents an interface that allows users to perform translations from structured query language to natural language as opposed to the conventional natural language to structured query language translation. This helps users understand what each query does. Bachelor of Engineering Science (Computer Science) 2022-06-23T05:39:34Z 2022-06-23T05:39:34Z 2022 Final Year Project (FYP) Pow, L. H. (2022). Natural language explanation of SQL queries for database education. Final Year Project (FYP), Nanyang Technological University, Singapore. https://hdl.handle.net/10356/159539 https://hdl.handle.net/10356/159539 en SCSE21-0160 application/pdf Nanyang Technological University
spellingShingle Engineering::Computer science and engineering::Data
Pow, Liang Hong
Natural language explanation of SQL queries for database education
title Natural language explanation of SQL queries for database education
title_full Natural language explanation of SQL queries for database education
title_fullStr Natural language explanation of SQL queries for database education
title_full_unstemmed Natural language explanation of SQL queries for database education
title_short Natural language explanation of SQL queries for database education
title_sort natural language explanation of sql queries for database education
topic Engineering::Computer science and engineering::Data
url https://hdl.handle.net/10356/159539
work_keys_str_mv AT powlianghong naturallanguageexplanationofsqlqueriesfordatabaseeducation