TY - GEN
T1 - Generating narrations of nested SQL queries using context-free grammars
AU - Obaido, George
AU - Ade-Ibijola, Abejide
AU - Vadapalli, Hima
N1 - Publisher Copyright:
© 2019 IEEE.
PY - 2019/4/30
Y1 - 2019/4/30
N2 - In the software industry, Structured Query Language (SQL) remains a highly sought-after skill required by most employers. SQL is widely adopted as the preferred declarative language to manipulate data in relational databases. However, the process of comprehending written and new queries turns out to be difficult, especially for novices. To address this problem, a plethora of tools have been developed to assist a novice understand queries using different approaches via visualisation and narration. This paper describes a SQL Narrator designed using a Context-free Grammar that reads and generates narrations for queries using predefined templates. The SQL Narrator is able to narrate nested queries cascaded with balanced parentheses. The generated narrations can be used in assisting students to comprehend nested SQL queries in learning environments. A survey conducted on 161 participants showed that 98.1% agreed that they were able to understand nested queries using our SQL Narrator.
AB - In the software industry, Structured Query Language (SQL) remains a highly sought-after skill required by most employers. SQL is widely adopted as the preferred declarative language to manipulate data in relational databases. However, the process of comprehending written and new queries turns out to be difficult, especially for novices. To address this problem, a plethora of tools have been developed to assist a novice understand queries using different approaches via visualisation and narration. This paper describes a SQL Narrator designed using a Context-free Grammar that reads and generates narrations for queries using predefined templates. The SQL Narrator is able to narrate nested queries cascaded with balanced parentheses. The generated narrations can be used in assisting students to comprehend nested SQL queries in learning environments. A survey conducted on 161 participants showed that 98.1% agreed that they were able to understand nested queries using our SQL Narrator.
KW - Comprehension aid for queries
KW - Context-free grammar applications
KW - Learning via narrations
KW - SQL query narration
UR - http://www.scopus.com/inward/record.url?scp=85065773315&partnerID=8YFLogxK
U2 - 10.1109/ICTAS.2019.8703620
DO - 10.1109/ICTAS.2019.8703620
M3 - Conference contribution
AN - SCOPUS:85065773315
T3 - 2019 Conference on Information Communications Technology and Society, ICTAS 2019
BT - 2019 Conference on Information Communications Technology and Society, ICTAS 2019
PB - Institute of Electrical and Electronics Engineers Inc.
T2 - 3rd Conference on Information Communications Technology and Society, ICTAS 2019
Y2 - 6 March 2019 through 8 March 2019
ER -
