{"id":"https://openalex.org/W4399729491","doi":"https://doi.org/10.1109/syscon61195.2024.10553509","title":"Translating Natural Language Queries to SQL Using the T5 Model","display_name":"Translating Natural Language Queries to SQL Using the T5 Model","publication_year":2024,"publication_date":"2024-04-15","ids":{"openalex":"https://openalex.org/W4399729491","doi":"https://doi.org/10.1109/syscon61195.2024.10553509"},"language":"en","primary_location":{"id":"doi:10.1109/syscon61195.2024.10553509","is_oa":false,"landing_page_url":"https://doi.org/10.1109/syscon61195.2024.10553509","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE International Systems Conference (SysCon)","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/A5103139210","display_name":"Albert Wong","orcid":"https://orcid.org/0000-0002-0669-4352"},"institutions":[{"id":"https://openalex.org/I39466443","display_name":"Langara College","ror":"https://ror.org/05qp50e50","country_code":"CA","type":"education","lineage":["https://openalex.org/I39466443"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Albert Wong","raw_affiliation_strings":["Mathematics and Statistics Langara College,Vancouver,Canada","Mathematics and Statistics Langara College, Vancouver, Canada"],"affiliations":[{"raw_affiliation_string":"Mathematics and Statistics Langara College,Vancouver,Canada","institution_ids":["https://openalex.org/I39466443"]},{"raw_affiliation_string":"Mathematics and Statistics Langara College, Vancouver, Canada","institution_ids":["https://openalex.org/I39466443"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082972778","display_name":"Li\u00ean Ph\u1ea1m","orcid":"https://orcid.org/0000-0003-3137-5609"},"institutions":[{"id":"https://openalex.org/I198387804","display_name":"Okanagan College","ror":"https://ror.org/04k2ezm16","country_code":"CA","type":"education","lineage":["https://openalex.org/I198387804"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Lien Pham","raw_affiliation_strings":["Mathematics and Statistics Okanagan College,Kelowna,Canada","Mathematics and Statistics Okanagan College, Kelowna, Canada"],"affiliations":[{"raw_affiliation_string":"Mathematics and Statistics Okanagan College,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]},{"raw_affiliation_string":"Mathematics and Statistics Okanagan College, Kelowna, Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100389578","display_name":"Young Lee","orcid":"https://orcid.org/0000-0003-0126-3112"},"institutions":[{"id":"https://openalex.org/I198387804","display_name":"Okanagan College","ror":"https://ror.org/04k2ezm16","country_code":"CA","type":"education","lineage":["https://openalex.org/I198387804"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Young Lee","raw_affiliation_strings":["Mathematics and Statistics Okanagan College,Kelowna,Canada","Mathematics and Statistics Okanagan College, Kelowna, Canada"],"affiliations":[{"raw_affiliation_string":"Mathematics and Statistics Okanagan College,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]},{"raw_affiliation_string":"Mathematics and Statistics Okanagan College, Kelowna, Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018889144","display_name":"Shek Tom Chan","orcid":null},"institutions":[{"id":"https://openalex.org/I39466443","display_name":"Langara College","ror":"https://ror.org/05qp50e50","country_code":"CA","type":"education","lineage":["https://openalex.org/I39466443"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Shek Chan","raw_affiliation_strings":["Mathematics and Statistics Langara College,Vancouver,Canada","Mathematics and Statistics Langara College, Vancouver, Canada"],"affiliations":[{"raw_affiliation_string":"Mathematics and Statistics Langara College,Vancouver,Canada","institution_ids":["https://openalex.org/I39466443"]},{"raw_affiliation_string":"Mathematics and Statistics Langara College, Vancouver, Canada","institution_ids":["https://openalex.org/I39466443"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5093551727","display_name":"Razel Sadaya","orcid":null},"institutions":[{"id":"https://openalex.org/I39466443","display_name":"Langara College","ror":"https://ror.org/05qp50e50","country_code":"CA","type":"education","lineage":["https://openalex.org/I39466443"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Razel Sadaya","raw_affiliation_strings":["Mathematics and Statistics Langara College,Vancouver,Canada","Mathematics and Statistics Langara College, Vancouver, Canada"],"affiliations":[{"raw_affiliation_string":"Mathematics and Statistics Langara College,Vancouver,Canada","institution_ids":["https://openalex.org/I39466443"]},{"raw_affiliation_string":"Mathematics and Statistics Langara College, Vancouver, Canada","institution_ids":["https://openalex.org/I39466443"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083484982","display_name":"Youry Khmelevsky","orcid":"https://orcid.org/0000-0002-6837-3490"},"institutions":[{"id":"https://openalex.org/I198387804","display_name":"Okanagan College","ror":"https://ror.org/04k2ezm16","country_code":"CA","type":"education","lineage":["https://openalex.org/I198387804"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Youry Khmelevsky","raw_affiliation_strings":["Computer Science Okanagan College,Kelowna,Canada","Computer Science Okanagan College, Kelowna, Canada"],"affiliations":[{"raw_affiliation_string":"Computer Science Okanagan College,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]},{"raw_affiliation_string":"Computer Science Okanagan College, Kelowna, Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039595665","display_name":"Mathias Clement","orcid":null},"institutions":[{"id":"https://openalex.org/I198387804","display_name":"Okanagan College","ror":"https://ror.org/04k2ezm16","country_code":"CA","type":"education","lineage":["https://openalex.org/I198387804"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mathias Clement","raw_affiliation_strings":["Computer Science Okanagan College,Kelowna,Canada","Computer Science Okanagan College, Kelowna, Canada"],"affiliations":[{"raw_affiliation_string":"Computer Science Okanagan College,Kelowna,Canada","institution_ids":["https://openalex.org/I198387804"]},{"raw_affiliation_string":"Computer Science Okanagan College, Kelowna, Canada","institution_ids":["https://openalex.org/I198387804"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111098006","display_name":"Florence Wing Yau Cheng","orcid":null},"institutions":[{"id":"https://openalex.org/I39466443","display_name":"Langara College","ror":"https://ror.org/05qp50e50","country_code":"CA","type":"education","lineage":["https://openalex.org/I39466443"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Florence Wing Yau Cheng","raw_affiliation_strings":["Mathematics and Statistics Langara College,Vancouver,Canada","Mathematics and Statistics Langara College, Vancouver, Canada"],"affiliations":[{"raw_affiliation_string":"Mathematics and Statistics Langara College,Vancouver,Canada","institution_ids":["https://openalex.org/I39466443"]},{"raw_affiliation_string":"Mathematics and Statistics Langara College, Vancouver, Canada","institution_ids":["https://openalex.org/I39466443"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032078853","display_name":"Joe Mahony","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Joe Mahony","raw_affiliation_strings":["Research and Development Harris SmartWorks,Ottawa,Canada","Research and Development Harris SmartWorks, Ottawa, Canada"],"affiliations":[{"raw_affiliation_string":"Research and Development Harris SmartWorks,Ottawa,Canada","institution_ids":[]},{"raw_affiliation_string":"Research and Development Harris SmartWorks, Ottawa, Canada","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057415804","display_name":"Michael Ferri","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Michael Ferri","raw_affiliation_strings":["Research and Development Harris SmartWorks,Ottawa,Canada","Research and Development Harris SmartWorks, Ottawa, Canada"],"affiliations":[{"raw_affiliation_string":"Research and Development Harris SmartWorks,Ottawa,Canada","institution_ids":[]},{"raw_affiliation_string":"Research and Development Harris SmartWorks, Ottawa, Canada","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":10,"corresponding_author_ids":["https://openalex.org/A5103139210"],"corresponding_institution_ids":["https://openalex.org/I39466443"],"apc_list":null,"apc_paid":null,"fwci":1.4488,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.84074217,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"7"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9970999956130981,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9970999956130981,"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/T10215","display_name":"Semantic Web and Ontologies","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/T10028","display_name":"Topic Modeling","score":0.991599977016449,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.839566707611084},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6849567294120789},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6478846073150635},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5905610918998718},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.5167242884635925},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.4806441366672516},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4502699077129364},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4290083646774292},{"id":"https://openalex.org/keywords/data-control-language","display_name":"Data control language","score":0.4139620065689087},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3992401361465454},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3676881492137909},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2911074161529541},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.07939222455024719},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.06699451804161072}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.839566707611084},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6849567294120789},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6478846073150635},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5905610918998718},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.5167242884635925},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.4806441366672516},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4502699077129364},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4290083646774292},{"id":"https://openalex.org/C32977378","wikidata":"https://www.wikidata.org/wiki/Q604737","display_name":"Data control language","level":5,"score":0.4139620065689087},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3992401361465454},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3676881492137909},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2911074161529541},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.07939222455024719},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.06699451804161072}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/syscon61195.2024.10553509","is_oa":false,"landing_page_url":"https://doi.org/10.1109/syscon61195.2024.10553509","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE International Systems Conference (SysCon)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.5199999809265137,"display_name":"Quality Education"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":78,"referenced_works":["https://openalex.org/W146900863","https://openalex.org/W2000507679","https://openalex.org/W2044857874","https://openalex.org/W2048805759","https://openalex.org/W2092154000","https://openalex.org/W2345895475","https://openalex.org/W2751448157","https://openalex.org/W2768409085","https://openalex.org/W2890431379","https://openalex.org/W2896457183","https://openalex.org/W2930957955","https://openalex.org/W2945102109","https://openalex.org/W2950067395","https://openalex.org/W2952032096","https://openalex.org/W2970172141","https://openalex.org/W2980315084","https://openalex.org/W2980741705","https://openalex.org/W2989365868","https://openalex.org/W3023926726","https://openalex.org/W3034835156","https://openalex.org/W3040736431","https://openalex.org/W3043801363","https://openalex.org/W3103801878","https://openalex.org/W3104003456","https://openalex.org/W3128979271","https://openalex.org/W3170698273","https://openalex.org/W3173274550","https://openalex.org/W3175488485","https://openalex.org/W3214600982","https://openalex.org/W4210301429","https://openalex.org/W4210351797","https://openalex.org/W4210686497","https://openalex.org/W4251334431","https://openalex.org/W4280570673","https://openalex.org/W4280583546","https://openalex.org/W4285244831","https://openalex.org/W4285717428","https://openalex.org/W4287169739","https://openalex.org/W4288601872","https://openalex.org/W4292949568","https://openalex.org/W4295857769","https://openalex.org/W4312096242","https://openalex.org/W4312121203","https://openalex.org/W4319999851","https://openalex.org/W4361019453","https://openalex.org/W4366835679","https://openalex.org/W4378191509","https://openalex.org/W4382202531","https://openalex.org/W4382202695","https://openalex.org/W4384834950","https://openalex.org/W4385571380","https://openalex.org/W4385572953","https://openalex.org/W4385573058","https://openalex.org/W4385573571","https://openalex.org/W4390092028","https://openalex.org/W4391792097","https://openalex.org/W4399729491","https://openalex.org/W6691431627","https://openalex.org/W6743367031","https://openalex.org/W6745921949","https://openalex.org/W6755207826","https://openalex.org/W6758814090","https://openalex.org/W6769004557","https://openalex.org/W6769627184","https://openalex.org/W6769642167","https://openalex.org/W6775746918","https://openalex.org/W6784229166","https://openalex.org/W6790406606","https://openalex.org/W6790715162","https://openalex.org/W6798393109","https://openalex.org/W6803081274","https://openalex.org/W6842220085","https://openalex.org/W6846305921","https://openalex.org/W6846926693","https://openalex.org/W6851131874","https://openalex.org/W6852852302","https://openalex.org/W6859011727","https://openalex.org/W6860086163"],"related_works":["https://openalex.org/W4388053677","https://openalex.org/W2340883001","https://openalex.org/W1964555030","https://openalex.org/W4316658535","https://openalex.org/W2486394024","https://openalex.org/W4281757942","https://openalex.org/W2990338989","https://openalex.org/W2031915568","https://openalex.org/W4388551928","https://openalex.org/W4367189846"],"abstract_inverted_index":{"This":[0],"paper":[1],"presents":[2],"the":[3,14,18,54,73],"development":[4,75],"process":[5],"of":[6],"a":[7,33,37,66,80,89],"natural":[8],"language":[9,93],"to":[10],"SQL":[11],"model":[12,16,74],"using":[13],"T5":[15],"as":[17],"basis.":[19,68],"The":[20,69],"models,":[21,46],"developed":[22],"in":[23,47,53,72,79],"August":[24],"2022":[25],"for":[26,59,83],"an":[27],"online":[28],"transaction":[29],"processing":[30],"system":[31],"and":[32,39,62,87],"data":[34],"warehouse,":[35],"have":[36],"73%":[38],"84%":[40],"exact":[41],"match":[42],"accuracy":[43],"respectively.":[44],"These":[45],"conjunction":[48],"with":[49,88],"other":[50,84],"work":[51],"completed":[52],"research":[55],"project,":[56],"were":[57],"implemented":[58,78],"several":[60],"companies":[61],"used":[63,71],"successfully":[64],"on":[65],"daily":[67],"approach":[70],"could":[76],"be":[77],"similar":[81],"fashion":[82],"database":[85],"environments":[86],"more":[90],"powerful":[91],"pre-trained":[92],"model.":[94]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1}],"updated_date":"2026-02-27T16:54:17.756197","created_date":"2025-10-10T00:00:00"}