{"id":"https://openalex.org/W2942881102","doi":"https://doi.org/10.1109/ictas.2019.8703620","title":"Generating Narrations of Nested SQL Queries Using Context-free Grammars","display_name":"Generating Narrations of Nested SQL Queries Using Context-free Grammars","publication_year":2019,"publication_date":"2019-03-01","ids":{"openalex":"https://openalex.org/W2942881102","doi":"https://doi.org/10.1109/ictas.2019.8703620","mag":"2942881102"},"language":"en","primary_location":{"id":"doi:10.1109/ictas.2019.8703620","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ictas.2019.8703620","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 Conference on Information Communications Technology and Society (ICTAS)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5053034151","display_name":"George Obaido","orcid":"https://orcid.org/0000-0001-5049-9522"},"institutions":[{"id":"https://openalex.org/I192619145","display_name":"University of the Witwatersrand","ror":"https://ror.org/03rp50x72","country_code":"ZA","type":"education","lineage":["https://openalex.org/I192619145"]}],"countries":["ZA"],"is_corresponding":false,"raw_author_name":"George Obaido","raw_affiliation_strings":["School of Computer Science and Applied Mathematics, University of the Witwatersrand, Johannesburg, South Africa"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science and Applied Mathematics, University of the Witwatersrand, Johannesburg, South Africa","institution_ids":["https://openalex.org/I192619145"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004107129","display_name":"Abejide Ade-Ibijola","orcid":"https://orcid.org/0000-0001-9507-0455"},"institutions":[{"id":"https://openalex.org/I24027795","display_name":"University of Johannesburg","ror":"https://ror.org/04z6c2n17","country_code":"ZA","type":"education","lineage":["https://openalex.org/I24027795"]}],"countries":["ZA"],"is_corresponding":false,"raw_author_name":"Abejide Ade-Ibijola","raw_affiliation_strings":["Formal Structures, Algorithms and Industrial Applications Research Cluster, University of Johannesburg, Johannesburg, South Africa"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Formal Structures, Algorithms and Industrial Applications Research Cluster, University of Johannesburg, Johannesburg, South Africa","institution_ids":["https://openalex.org/I24027795"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5081793269","display_name":"Hima Vadapalli","orcid":"https://orcid.org/0000-0001-9040-3601"},"institutions":[{"id":"https://openalex.org/I192619145","display_name":"University of the Witwatersrand","ror":"https://ror.org/03rp50x72","country_code":"ZA","type":"education","lineage":["https://openalex.org/I192619145"]}],"countries":["ZA"],"is_corresponding":false,"raw_author_name":"Hima Vadapalli","raw_affiliation_strings":["School of Computer Science and Applied Mathematics, University of the Witwatersrand, Johannesburg, South Africa"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science and Applied Mathematics, University of the Witwatersrand, Johannesburg, South Africa","institution_ids":["https://openalex.org/I192619145"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.8471,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.7981274,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9947999715805054,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9947999715805054,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9919000267982483,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9797000288963318,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8774253726005554},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8435112237930298},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6723699569702148},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5634018778800964},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.5365737676620483},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5345323085784912},{"id":"https://openalex.org/keywords/nested-set-model","display_name":"Nested set model","score":0.5225300788879395},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.45658084750175476},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.45201241970062256},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.449446439743042},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.34644564986228943},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.32579493522644043},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.09587013721466064},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07178151607513428}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8774253726005554},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8435112237930298},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6723699569702148},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5634018778800964},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.5365737676620483},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5345323085784912},{"id":"https://openalex.org/C103000020","wikidata":"https://www.wikidata.org/wiki/Q1978426","display_name":"Nested set model","level":3,"score":0.5225300788879395},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.45658084750175476},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.45201241970062256},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.449446439743042},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.34644564986228943},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32579493522644043},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.09587013721466064},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07178151607513428},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/ictas.2019.8703620","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ictas.2019.8703620","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 Conference on Information Communications Technology and Society (ICTAS)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4300000071525574,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W236237575","https://openalex.org/W1588302298","https://openalex.org/W1829303854","https://openalex.org/W2003503236","https://openalex.org/W2051989764","https://openalex.org/W2079112936","https://openalex.org/W2084734886","https://openalex.org/W2088074648","https://openalex.org/W2095026299","https://openalex.org/W2095513884","https://openalex.org/W2105590118","https://openalex.org/W2106625078","https://openalex.org/W2107853792","https://openalex.org/W2116351853","https://openalex.org/W2122982975","https://openalex.org/W2129768188","https://openalex.org/W2132032354","https://openalex.org/W2149440769","https://openalex.org/W2198113157","https://openalex.org/W2269738476","https://openalex.org/W2499393420","https://openalex.org/W2503947316","https://openalex.org/W2504887022","https://openalex.org/W2528910168","https://openalex.org/W2529969364","https://openalex.org/W2530002960","https://openalex.org/W2534674944","https://openalex.org/W2564649326","https://openalex.org/W2760404271","https://openalex.org/W2782865516","https://openalex.org/W2788803360","https://openalex.org/W2809284492","https://openalex.org/W2809686080","https://openalex.org/W2885090162","https://openalex.org/W2907950887","https://openalex.org/W2914032487","https://openalex.org/W2951332749","https://openalex.org/W2953181121","https://openalex.org/W3104497569","https://openalex.org/W4285719527","https://openalex.org/W6727979115","https://openalex.org/W6763979471"],"related_works":["https://openalex.org/W638381921","https://openalex.org/W3209496184","https://openalex.org/W2340883001","https://openalex.org/W2912795851","https://openalex.org/W2240099544","https://openalex.org/W2282090486","https://openalex.org/W1890845846","https://openalex.org/W2738342198","https://openalex.org/W2512476881","https://openalex.org/W2486394024"],"abstract_inverted_index":{"In":[0],"the":[1,22,33],"software":[2],"industry,":[3],"Structured":[4],"Query":[5],"Language":[6],"(SQL)":[7],"remains":[8],"a":[9,53,62,76,81],"highly":[10],"sought-after":[11],"skill":[12],"required":[13],"by":[14],"most":[15],"employers.":[16],"SQL":[17,77,95,119,144],"is":[18,97],"widely":[19],"adopted":[20],"as":[21],"preferred":[23],"declarative":[24],"language":[25],"to":[26,43,60,99,116,138],"manipulate":[27],"data":[28],"in":[29,113,121],"relational":[30],"databases.":[31],"However,":[32],"process":[34],"of":[35,55],"comprehending":[36],"written":[37],"and":[38,71,86],"new":[39],"queries":[40,65,90,102,120,141],"turns":[41],"out":[42],"be":[44,111],"difficult,":[45],"especially":[46],"for":[47,89],"novices.":[48],"To":[49],"address":[50],"this":[51],"problem,":[52],"plethora":[54],"tools":[56],"have":[57],"been":[58],"developed":[59],"assist":[61],"novice":[63],"understand":[64,139],"using":[66,80,91,142],"different":[67],"approaches":[68],"via":[69],"visualisation":[70],"narration.":[72],"This":[73],"paper":[74],"describes":[75],"Narrator":[78,96],"designed":[79],"Context-free":[82],"Grammar":[83],"that":[84,131,134],"reads":[85],"generates":[87],"narrations":[88,109],"predefined":[92],"templates.":[93],"The":[94,107],"able":[98,137],"narrate":[100],"nested":[101,118,140],"cascaded":[103],"with":[104],"balanced":[105],"parentheses.":[106],"generated":[108],"can":[110],"used":[112],"assisting":[114],"students":[115],"comprehend":[117],"learning":[122],"environments.":[123],"A":[124],"survey":[125],"conducted":[126],"on":[127],"161":[128],"participants":[129],"showed":[130],"98.1%":[132],"agreed":[133],"they":[135],"were":[136],"our":[143],"Narrator.":[145]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}