{"id":"https://openalex.org/W4391093918","doi":"https://doi.org/10.1109/bigdata59044.2023.10386277","title":"TRANSQLATION: TRANsformer-based SQL RecommendATION","display_name":"TRANSQLATION: TRANsformer-based SQL RecommendATION","publication_year":2023,"publication_date":"2023-12-15","ids":{"openalex":"https://openalex.org/W4391093918","doi":"https://doi.org/10.1109/bigdata59044.2023.10386277"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata59044.2023.10386277","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata59044.2023.10386277","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE International Conference on Big Data (BigData)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://hdl.handle.net/11250/3128259","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5068338892","display_name":"Shirin Tahmasebi","orcid":null},"institutions":[{"id":"https://openalex.org/I86987016","display_name":"KTH Royal Institute of Technology","ror":"https://ror.org/026vcq606","country_code":"SE","type":"education","lineage":["https://openalex.org/I86987016"]}],"countries":["SE"],"is_corresponding":true,"raw_author_name":"Shirin Tahmasebi","raw_affiliation_strings":["KTH Royal Institute of Technology,Sweden","KTH Royal Institute of Technology, Sweden"],"affiliations":[{"raw_affiliation_string":"KTH Royal Institute of Technology,Sweden","institution_ids":["https://openalex.org/I86987016"]},{"raw_affiliation_string":"KTH Royal Institute of Technology, Sweden","institution_ids":["https://openalex.org/I86987016"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012596151","display_name":"Amir H. Payberah","orcid":"https://orcid.org/0000-0002-2748-8929"},"institutions":[{"id":"https://openalex.org/I86987016","display_name":"KTH Royal Institute of Technology","ror":"https://ror.org/026vcq606","country_code":"SE","type":"education","lineage":["https://openalex.org/I86987016"]}],"countries":["SE"],"is_corresponding":false,"raw_author_name":"Amir H. Payberah","raw_affiliation_strings":["KTH Royal Institute of Technology,Sweden","KTH Royal Institute of Technology, Sweden"],"affiliations":[{"raw_affiliation_string":"KTH Royal Institute of Technology,Sweden","institution_ids":["https://openalex.org/I86987016"]},{"raw_affiliation_string":"KTH Royal Institute of Technology, Sweden","institution_ids":["https://openalex.org/I86987016"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012429784","display_name":"Ahmet Soylu","orcid":"https://orcid.org/0000-0001-6034-4137"},"institutions":[{"id":"https://openalex.org/I184531372","display_name":"OsloMet \u2013 Oslo Metropolitan University","ror":"https://ror.org/04q12yn84","country_code":"NO","type":"education","lineage":["https://openalex.org/I184531372"]}],"countries":["NO"],"is_corresponding":false,"raw_author_name":"Ahmet Soylu","raw_affiliation_strings":["Oslo Metropolitan University,Norway","Oslo Metropolitan University, Norway"],"affiliations":[{"raw_affiliation_string":"Oslo Metropolitan University,Norway","institution_ids":["https://openalex.org/I184531372"]},{"raw_affiliation_string":"Oslo Metropolitan University, Norway","institution_ids":["https://openalex.org/I184531372"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016864296","display_name":"Dumitru Roman","orcid":"https://orcid.org/0000-0001-6397-3705"},"institutions":[{"id":"https://openalex.org/I173888879","display_name":"SINTEF","ror":"https://ror.org/01f677e56","country_code":"NO","type":"facility","lineage":["https://openalex.org/I173888879"]}],"countries":["NO"],"is_corresponding":false,"raw_author_name":"Dumitru Roman","raw_affiliation_strings":["SINTEF AS,Norway","SINTEF AS, Norway"],"affiliations":[{"raw_affiliation_string":"SINTEF AS,Norway","institution_ids":["https://openalex.org/I173888879"]},{"raw_affiliation_string":"SINTEF AS, Norway","institution_ids":["https://openalex.org/I173888879"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056152467","display_name":"Mihhail Matskin","orcid":null},"institutions":[{"id":"https://openalex.org/I86987016","display_name":"KTH Royal Institute of Technology","ror":"https://ror.org/026vcq606","country_code":"SE","type":"education","lineage":["https://openalex.org/I86987016"]}],"countries":["SE"],"is_corresponding":false,"raw_author_name":"Mihhail Matskin","raw_affiliation_strings":["KTH Royal Institute of Technology,Sweden","KTH Royal Institute of Technology, Sweden"],"affiliations":[{"raw_affiliation_string":"KTH Royal Institute of Technology,Sweden","institution_ids":["https://openalex.org/I86987016"]},{"raw_affiliation_string":"KTH Royal Institute of Technology, Sweden","institution_ids":["https://openalex.org/I86987016"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5068338892"],"corresponding_institution_ids":["https://openalex.org/I86987016"],"apc_list":null,"apc_paid":null,"fwci":0.3474,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.68420992,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"4703","last_page":"4711"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9983000159263611,"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.9983000159263611,"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.9968000054359436,"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"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9794999957084656,"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.8980762958526611},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7156499624252319},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6684024930000305},{"id":"https://openalex.org/keywords/session","display_name":"Session (web analytics)","score":0.6097842454910278},{"id":"https://openalex.org/keywords/relevance-feedback","display_name":"Relevance feedback","score":0.4696972370147705},{"id":"https://openalex.org/keywords/recommender-system","display_name":"Recommender system","score":0.460466593503952},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.42934924364089966},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.42752042412757874},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.41869646310806274},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4181728959083557},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.27130526304244995},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.11683374643325806},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.09656327962875366},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.08032611012458801}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8980762958526611},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7156499624252319},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6684024930000305},{"id":"https://openalex.org/C2779182362","wikidata":"https://www.wikidata.org/wiki/Q17126187","display_name":"Session (web analytics)","level":2,"score":0.6097842454910278},{"id":"https://openalex.org/C2779532271","wikidata":"https://www.wikidata.org/wiki/Q445558","display_name":"Relevance feedback","level":4,"score":0.4696972370147705},{"id":"https://openalex.org/C557471498","wikidata":"https://www.wikidata.org/wiki/Q554950","display_name":"Recommender system","level":2,"score":0.460466593503952},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.42934924364089966},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42752042412757874},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.41869646310806274},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4181728959083557},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.27130526304244995},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.11683374643325806},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.09656327962875366},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08032611012458801},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C1667742","wikidata":"https://www.wikidata.org/wiki/Q10927554","display_name":"Image retrieval","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/bigdata59044.2023.10386277","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata59044.2023.10386277","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE International Conference on Big Data (BigData)","raw_type":"proceedings-article"},{"id":"pmh:oai:sintef.brage.unit.no:11250/3128259","is_oa":true,"landing_page_url":"https://hdl.handle.net/11250/3128259","pdf_url":null,"source":{"id":"https://openalex.org/S4306401716","display_name":"Duo Research Archive (University of Oslo)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I184942183","host_organization_name":"University of Oslo","host_organization_lineage":["https://openalex.org/I184942183"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"4703-4711","raw_type":"info:eu-repo/semantics/bookPart"}],"best_oa_location":{"id":"pmh:oai:sintef.brage.unit.no:11250/3128259","is_oa":true,"landing_page_url":"https://hdl.handle.net/11250/3128259","pdf_url":null,"source":{"id":"https://openalex.org/S4306401716","display_name":"Duo Research Archive (University of Oslo)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I184942183","host_organization_name":"University of Oslo","host_organization_lineage":["https://openalex.org/I184942183"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"4703-4711","raw_type":"info:eu-repo/semantics/bookPart"},"sustainable_development_goals":[{"display_name":"Quality Education","score":0.7900000214576721,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W2003251288","https://openalex.org/W2005048938","https://openalex.org/W2032787143","https://openalex.org/W2080795333","https://openalex.org/W2108932068","https://openalex.org/W2118178958","https://openalex.org/W2318056513","https://openalex.org/W2435931733","https://openalex.org/W2607294481","https://openalex.org/W2890561662","https://openalex.org/W2891691255","https://openalex.org/W2912817604","https://openalex.org/W2945102109","https://openalex.org/W2963357517","https://openalex.org/W2965373594","https://openalex.org/W2970217403","https://openalex.org/W2984100107","https://openalex.org/W2985898855","https://openalex.org/W3034835156","https://openalex.org/W3087096020","https://openalex.org/W3098605233","https://openalex.org/W3113477245","https://openalex.org/W3121694563","https://openalex.org/W3134304069","https://openalex.org/W3150263485","https://openalex.org/W3173458274","https://openalex.org/W3200664681","https://openalex.org/W4288026527","https://openalex.org/W4360764237","https://openalex.org/W4383199468","https://openalex.org/W6754783781","https://openalex.org/W6755207826","https://openalex.org/W6766673545","https://openalex.org/W6770059428","https://openalex.org/W6791330069","https://openalex.org/W6967286523"],"related_works":["https://openalex.org/W2955368753","https://openalex.org/W1987288934","https://openalex.org/W2384284661","https://openalex.org/W2362136306","https://openalex.org/W319014924","https://openalex.org/W2391725132","https://openalex.org/W172736152","https://openalex.org/W151494989","https://openalex.org/W2612905717","https://openalex.org/W2356335648"],"abstract_inverted_index":{"The":[0],"exponential":[1],"growth":[2],"of":[3,9,18,23,34,62,85,117,146,176],"data":[4,147,155],"production":[5],"emphasizes":[6],"the":[7,21,83,115,118,172],"importance":[8],"database":[10],"management":[11],"systems":[12,69],"(DBMS)":[13],"for":[14,41,76],"managing":[15],"vast":[16],"amounts":[17],"data.":[19],"However,":[20],"complexity":[22],"writing":[24,77],"Structured":[25],"Query":[26],"Language":[27],"(SQL)":[28],"queries":[29],"requires":[30],"a":[31,39,107,123,143,166],"diverse":[32],"range":[33],"skills,":[35],"which":[36],"can":[37,170],"be":[38],"challenge":[40,51],"many":[42],"users.":[43],"Different":[44],"approaches":[45,64],"are":[46],"proposed":[47],"to":[48,66,74],"address":[49],"this":[50,102],"by":[52,133],"aiding":[53],"SQL":[54,80,120],"users":[55,75],"in":[56,122,178],"mitigating":[57],"their":[58,78],"skill":[59],"gaps.":[60],"One":[61],"these":[63],"is":[65,149,156,165],"design":[67],"recommendation":[68,87,111,139,180],"that":[70,113,128,161,169],"provide":[71],"several":[72,92],"suggestions":[73],"next":[79],"queries.":[81],"Despite":[82],"availability":[84],"such":[86,94],"systems,":[88],"they":[89],"often":[90],"have":[91],"limitations,":[93],"as":[95],"lacking":[96],"sequence-awareness,":[97],"session-awareness,":[98],"and":[99,109,148,174],"context-awareness.":[100],"In":[101],"paper,":[103],"we":[104],"propose":[105],"TRANSQLATION,":[106],"session-aware":[108],"sequence-aware":[110],"system":[112],"recommends":[114],"fragments":[116],"subsequent":[119],"query":[121,179],"user":[124],"session.":[125],"We":[126,158],"demonstrate":[127,160],"TRANSQLATION":[129],"outperforms":[130],"existing":[131],"works":[132],"achieving,":[134],"on":[135],"average,":[136],"22%":[137],"more":[138],"accuracy":[140,173],"when":[141,153],"having":[142],"large":[144],"amount":[145],"still":[150],"effective":[151],"even":[152],"training":[154],"limited.":[157],"further":[159],"considering":[162],"contextual":[163],"similarity":[164],"critical":[167],"aspect":[168],"enhance":[171],"relevance":[175],"recommendations":[177],"systems.":[181]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}