{"id":"https://openalex.org/W4388145573","doi":"https://doi.org/10.1109/access.2023.3329071","title":"Enabling Generative AI to Produce SQL Statements: A Framework for the Auto- Generation of Knowledge Based on EBNF Context-Free Grammars","display_name":"Enabling Generative AI to Produce SQL Statements: A Framework for the Auto- Generation of Knowledge Based on EBNF Context-Free Grammars","publication_year":2023,"publication_date":"2023-01-01","ids":{"openalex":"https://openalex.org/W4388145573","doi":"https://doi.org/10.1109/access.2023.3329071"},"language":"en","primary_location":{"is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2023.3329071","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/6514899/10304149.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true},"type":"article","type_crossref":"journal-article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://ieeexplore.ieee.org/ielx7/6287639/6514899/10304149.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5029461555","display_name":"Christopher Troy","orcid":"https://orcid.org/0009-0006-4107-6775"},"institutions":[{"id":"https://openalex.org/I868834043","display_name":"University of the West of Scotland","ror":"https://ror.org/04w3d2v20","country_code":"GB","type":"education","lineage":["https://openalex.org/I868834043"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Christopher Troy","raw_affiliation_strings":["School of Computing, Engineering and Physical Sciences, University of the West of Scotland, High St, Paisley, UK"],"affiliations":[{"raw_affiliation_string":"School of Computing, Engineering and Physical Sciences, University of the West of Scotland, High St, Paisley, UK","institution_ids":["https://openalex.org/I868834043"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020444067","display_name":"Sean Sturley","orcid":"https://orcid.org/0000-0003-1056-059X"},"institutions":[{"id":"https://openalex.org/I868834043","display_name":"University of the West of Scotland","ror":"https://ror.org/04w3d2v20","country_code":"GB","type":"education","lineage":["https://openalex.org/I868834043"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Sean Sturley","raw_affiliation_strings":["School of Computing, Engineering and Physical Sciences, University of the West of Scotland, High St, Paisley, UK"],"affiliations":[{"raw_affiliation_string":"School of Computing, Engineering and Physical Sciences, University of the West of Scotland, High St, Paisley, UK","institution_ids":["https://openalex.org/I868834043"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049376858","display_name":"Jos\u00e9 M. Alcaraz Calero","orcid":"https://orcid.org/0000-0002-2654-7595"},"institutions":[{"id":"https://openalex.org/I868834043","display_name":"University of the West of Scotland","ror":"https://ror.org/04w3d2v20","country_code":"GB","type":"education","lineage":["https://openalex.org/I868834043"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Jose M. Alcaraz-Calero","raw_affiliation_strings":["School of Computing, Engineering and Physical Sciences, University of the West of Scotland, High St, Paisley, UK"],"affiliations":[{"raw_affiliation_string":"School of Computing, Engineering and Physical Sciences, University of the West of Scotland, High St, Paisley, UK","institution_ids":["https://openalex.org/I868834043"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100341330","display_name":"Qi Wang","orcid":"https://orcid.org/0000-0002-7764-9858"},"institutions":[{"id":"https://openalex.org/I868834043","display_name":"University of the West of Scotland","ror":"https://ror.org/04w3d2v20","country_code":"GB","type":"education","lineage":["https://openalex.org/I868834043"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Qi Wang","raw_affiliation_strings":["School of Computing, Engineering and Physical Sciences, University of the West of Scotland, High St, Paisley, UK"],"affiliations":[{"raw_affiliation_string":"School of Computing, Engineering and Physical Sciences, University of the West of Scotland, High St, Paisley, UK","institution_ids":["https://openalex.org/I868834043"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":1850,"currency":"USD","value_usd":1850,"provenance":"doaj"},"apc_paid":{"value":1850,"currency":"USD","value_usd":1850,"provenance":"doaj"},"fwci":0.352,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.606989,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":68,"max":79},"biblio":{"volume":"11","issue":null,"first_page":"123543","last_page":"123564"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9966,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9966,"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/T10028","display_name":"Topic Modeling","score":0.9947,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.993,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8286128},{"id":"https://openalex.org/C97212296","wikidata":"https://www.wikidata.org/wiki/Q338047","display_name":"Context-free grammar","level":3,"score":0.6650788},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6516093},{"id":"https://openalex.org/C53893814","wikidata":"https://www.wikidata.org/wiki/Q7378909","display_name":"Rule-based machine translation","level":2,"score":0.63855666},{"id":"https://openalex.org/C37734731","wikidata":"https://www.wikidata.org/wiki/Q5421802","display_name":"Extended Affix Grammar","level":4,"score":0.6384763},{"id":"https://openalex.org/C39890363","wikidata":"https://www.wikidata.org/wiki/Q36108","display_name":"Generative grammar","level":2,"score":0.61878335},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.5532861},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5235172},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.52196944},{"id":"https://openalex.org/C67621940","wikidata":"https://www.wikidata.org/wiki/Q3113340","display_name":"L-attributed grammar","level":4,"score":0.44363102},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.34188414},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2023.3329071","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/6514899/10304149.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true}],"best_oa_location":{"is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2023.3329071","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/6514899/10304149.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true},"sustainable_development_goals":[{"display_name":"Quality education","id":"https://metadata.un.org/sdg/4","score":0.6}],"grants":[{"funder":"https://openalex.org/F4320320174","funder_display_name":"Carnegie Trust for the Universities of Scotland","award_id":"PHD010695"},{"funder":"https://openalex.org/F4320332999","funder_display_name":"Horizon 2020 Framework Programme","award_id":"H2020-SU-DS-2018-2019-2020/101020259"}],"datasets":[],"versions":[],"referenced_works_count":19,"referenced_works":["https://openalex.org/W2091232155","https://openalex.org/W2128777959","https://openalex.org/W2806843026","https://openalex.org/W2913353391","https://openalex.org/W2944133700","https://openalex.org/W2955512557","https://openalex.org/W3001281425","https://openalex.org/W3024325437","https://openalex.org/W3047123285","https://openalex.org/W4206451169","https://openalex.org/W4212916849","https://openalex.org/W4226399820","https://openalex.org/W4240836798","https://openalex.org/W4280554137","https://openalex.org/W4289655661","https://openalex.org/W4312912966","https://openalex.org/W4384200891","https://openalex.org/W4388139328","https://openalex.org/W82821701"],"related_works":["https://openalex.org/W4398164120","https://openalex.org/W4286266684","https://openalex.org/W2918124307","https://openalex.org/W1991706120","https://openalex.org/W1982538124","https://openalex.org/W1969069928","https://openalex.org/W1714026380","https://openalex.org/W1557335907","https://openalex.org/W152266133","https://openalex.org/W144732315"],"abstract_inverted_index":{"The":[0,103,130,146,175,209],"motivation":[1],"of":[2,20,44,51,75,89,95,106,112,171,204],"this":[3,107,118],"paper":[4,119,147,176],"is":[5,109],"to":[6,9,29,62,85,92,123,152,163,215,243,249,281],"be":[7,116,244],"able":[8,84,248],"generate":[10,126,217],"high-quality":[11],"(Structured":[12],"Query":[13],"Language)":[14],"SQL":[15,76,220,269,275,279],"language":[16,128,136,190],"sentences":[17,77,98],"in":[18,54],"terms":[19],"syntax":[21],"and":[22,34,69,78,125,165,184,197,246],"semantics":[23,88],"so":[24],"that":[25,41,67],"they":[26],"are":[27,42,60,200],"intended":[28,101],"achieve":[30,63,154],"a":[31,46,49,55,65,121,150,168,179,268],"concrete":[32],"predefined":[33],"well-known":[35],"aim.":[36],"For":[37],"example,":[38],"generating":[39],"SQL-sentences":[40],"capable":[43],"detecting":[45],"cyber-attack":[47],"from":[48],"set":[50],"metrics":[52],"available":[53],"database":[56],"table.":[57],"Two":[58],"solutions":[59],"needed":[61],"so,":[64],"tool":[66,122,131],"enables":[68],"performs":[70],"the":[71,87,93,96,100,110,172,232,251,256,273,283],"syntactically":[72,218],"valid":[73,219],"generation":[74,173,191],"an":[79,139,155,213,278],"(Artificial":[80],"intelligence)":[81],"AI":[82,207],"algorithm":[83],"guide":[86],"such":[90,240],"generations":[91],"achievement":[94],"best":[97],"for":[99,159,189,206,239],"purpose.":[102],"main":[104],"contribution":[105],"manuscript":[108],"first":[111],"these":[113],"solutions.":[114],"To":[115],"concrete,":[117],"proposes":[120],"enable":[124],"syntactic-valid":[127],"sentences.":[129],"can":[132],"deal":[133],"with":[134,225],"any":[135],"defined":[137],"as":[138,167],"ANTLR4":[140],"EBNF":[141,156,193,270],"(Extended":[142],"Backus-Naur":[143],"Form)":[144],"grammar.":[145],"also":[148,254],"provides":[149],"methodology":[151],"help":[153],"grammar":[157,271],"suitable":[158],"addressing":[160],"concerns":[161],"related":[162],"ambiguity":[164],"recursion":[166,252],"direct":[169],"result":[170],"process.":[174],"further":[177],"implements":[178],"prototype":[180,211],"utilizing":[181],"ANTLR4's":[182],"recognizer":[183],"its":[185],"Augmented":[186],"Transition":[187],"Network":[188],"using":[192],"grammars.":[194],"In-depth":[195],"design":[196],"logic":[198],"implementation":[199],"provided,":[201],"showcasing":[202],"areas":[203],"interest":[205],"integration.":[208],"achieved":[210],"showed":[212],"ability":[214],"easily":[216],"statements":[221],"at":[222],"various":[223],"depths,":[224],"observable":[226],"problems":[227],"becoming":[228],"more":[229],"apparent":[230],"during":[231],"exponential":[233],"recursive":[234],"growth.":[235],"Our":[236],"mitigation":[237],"controls":[238],"scenarios":[241],"proved":[242],"successful":[245],"were":[247],"complete":[250],"whilst":[253],"moving":[255],"push-down":[257],"automata":[258],"forward":[259],"until":[260],"query":[261],"completion.":[262],"Experimental":[263],"validation":[264],"was":[265],"performed":[266],"against":[267],"feeding":[272],"generated":[274],"statement":[276],"into":[277],"parser":[280],"validate":[282],"syntax.":[284]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4388145573","counts_by_year":[{"year":2023,"cited_by_count":1}],"updated_date":"2024-12-12T06:01:36.689404","created_date":"2023-11-02"}