{"title":"S-NAR:使用正则表达式生成SQL查询的叙述","authors":"Abejide Ade-Ibijola, George Obaido","doi":"10.1145/3129416.3129454","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":269578,"journal":{"name":"Research Conference of the South African Institute of Computer Scientists and Information Technologists","volume":"68 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2017-09-26","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"6","resultStr":"{\"title\":\"S-NAR: generating narrations of SQL queries using regular expressions\",\"authors\":\"Abejide Ade-Ibijola, George Obaido\",\"doi\":\"10.1145/3129416.3129454\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":269578,\"journal\":{\"name\":\"Research Conference of the South African Institute of Computer Scientists and Information Technologists\",\"volume\":\"68 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2017-09-26\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"6\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Research Conference of the South African Institute of Computer Scientists and Information Technologists\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/3129416.3129454\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Research Conference of the South African Institute of Computer Scientists and Information Technologists","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3129416.3129454","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
S-NAR: generating narrations of SQL queries using regular expressions
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.
求助内容：
应助结果提醒方式：
京公网安备 11010802042870号
