TY - GEN
T1 - S-NAR
T2 - 23rd South African Institute of Computer Scientists and Information Technologists Conference, SAICSIT 2017
AU - Ade-Ibijola, Abejide
AU - Obaido, George
N1 - Publisher Copyright:
© 2017 Association for Computing Machinery.
PY - 2017/9/26
Y1 - 2017/9/26
N2 - Structured Query Language (SQL) is popular with relational databases. Despite the simple and highly structured nature of SQL, end users often find it difficult to comprehend written queries and/or write new queries. Hence, a number of tools have been proposed to aid the comprehension of SQL queries via visualisation. In this paper, we present a different comprehension aid called narrations. Narrations are non-technical, textual descriptions of SQL queries. Using a representation of regular languages, regular expressions, we have designed a tool, called S-NAR (or Sql-NARrator), that reads queries and generates a narration of these queries using pre-defined templates. S-NAR was tested with 5,000 queries and narrated 96% of the queries. The generated narrations should find applications in aiding comprehension in the teaching of database courses at higher institutions of learning, and assisting the comprehension of legacy queries in data-centered industries.
AB - Structured Query Language (SQL) is popular with relational databases. Despite the simple and highly structured nature of SQL, end users often find it difficult to comprehend written queries and/or write new queries. Hence, a number of tools have been proposed to aid the comprehension of SQL queries via visualisation. In this paper, we present a different comprehension aid called narrations. Narrations are non-technical, textual descriptions of SQL queries. Using a representation of regular languages, regular expressions, we have designed a tool, called S-NAR (or Sql-NARrator), that reads queries and generates a narration of these queries using pre-defined templates. S-NAR was tested with 5,000 queries and narrated 96% of the queries. The generated narrations should find applications in aiding comprehension in the teaching of database courses at higher institutions of learning, and assisting the comprehension of legacy queries in data-centered industries.
KW - Learning via abstraction
KW - Query comprehension
KW - Regular expression application
KW - SQL query narration
UR - http://www.scopus.com/inward/record.url?scp=85032644769&partnerID=8YFLogxK
U2 - 10.1145/3129416.3129454
DO - 10.1145/3129416.3129454
M3 - Conference contribution
AN - SCOPUS:85032644769
T3 - ACM International Conference Proceeding Series
BT - South African Institute of Computer Scientists and Information Technologists
A2 - Blignaut, Pieter
A2 - Stott, Tanya
PB - Association for Computing Machinery
Y2 - 26 September 2017 through 28 September 2017
ER -