Generating narrations of nested SQL queries using context-free grammars

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

7 Citations (Scopus)

Abstract

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.

Original languageEnglish
Title of host publication2019 Conference on Information Communications Technology and Society, ICTAS 2019
PublisherInstitute of Electrical and Electronics Engineers Inc.
ISBN (Electronic)9781538673652
DOIs
Publication statusPublished - 30 Apr 2019
Event3rd Conference on Information Communications Technology and Society, ICTAS 2019 - Durban, South Africa
Duration: 6 Mar 20198 Mar 2019

Publication series

Name2019 Conference on Information Communications Technology and Society, ICTAS 2019

Conference

Conference3rd Conference on Information Communications Technology and Society, ICTAS 2019
Country/TerritorySouth Africa
CityDurban
Period6/03/198/03/19

Keywords

  • Comprehension aid for queries
  • Context-free grammar applications
  • Learning via narrations
  • SQL query narration

ASJC Scopus subject areas

  • Computer Science Applications
  • Computer Networks and Communications
  • Computer Vision and Pattern Recognition
  • Information Systems and Management
  • Education

Fingerprint

Dive into the research topics of 'Generating narrations of nested SQL queries using context-free grammars'. Together they form a unique fingerprint.

Cite this