{"id":"https://openalex.org/W2985377636","doi":"https://doi.org/10.18653/v1/2020.acl-main.677","title":"RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers","display_name":"RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers","publication_year":2020,"publication_date":"2020-01-01","ids":{"openalex":"https://openalex.org/W2985377636","doi":"https://doi.org/10.18653/v1/2020.acl-main.677","mag":"2985377636"},"language":"en","primary_location":{"id":"doi:10.18653/v1/2020.acl-main.677","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2020.acl-main.677","pdf_url":"https://www.aclweb.org/anthology/2020.acl-main.677.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.aclweb.org/anthology/2020.acl-main.677.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5042749062","display_name":"Bailin Wang","orcid":"https://orcid.org/0000-0002-3579-298X"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Bailin Wang","raw_affiliation_strings":["University of Edinburgh, Edinburgh, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103861525","display_name":"Richard Shin","orcid":null},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Richard Shin","raw_affiliation_strings":["University of California, Berkeley, Berkeley, United States"],"affiliations":[{"raw_affiliation_string":"University of California, Berkeley, Berkeley, United States","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100374771","display_name":"Xiaodong Liu","orcid":"https://orcid.org/0000-0001-8652-9818"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xiaodong Liu","raw_affiliation_strings":["Microsoft (United States), Redmond, United States"],"affiliations":[{"raw_affiliation_string":"Microsoft (United States), Redmond, United States","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066539391","display_name":"Oleksandr Polozov","orcid":"https://orcid.org/0000-0003-3669-4262"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Oleksandr Polozov","raw_affiliation_strings":["Microsoft (United States), Redmond, United States"],"affiliations":[{"raw_affiliation_string":"Microsoft (United States), Redmond, United States","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5062300635","display_name":"Matthew Richardson","orcid":"https://orcid.org/0000-0003-1830-4726"},"institutions":[{"id":"https://openalex.org/I58610484","display_name":"Seattle University","ror":"https://ror.org/02jqc0m91","country_code":"US","type":"education","lineage":["https://openalex.org/I58610484"]},{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Matthew Richardson","raw_affiliation_strings":["University of Washington, Seattle, United States"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, United States","institution_ids":["https://openalex.org/I58610484","https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5042749062"],"corresponding_institution_ids":["https://openalex.org/I98677209"],"apc_list":null,"apc_paid":null,"fwci":4.2517,"has_fulltext":true,"cited_by_count":39,"citation_normalized_percentile":{"value":0.95034332,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"7567","last_page":"7578"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9998999834060669,"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.9998999834060669,"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.9998000264167786,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9679999947547913,"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.8730801343917847},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7098054885864258},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6922211647033691},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.662285327911377},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.569901704788208},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5671218037605286},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5225238800048828},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.5180485248565674},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.46420249342918396},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3841361999511719},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2778993844985962}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8730801343917847},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7098054885864258},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6922211647033691},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.662285327911377},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.569901704788208},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5671218037605286},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5225238800048828},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.5180485248565674},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.46420249342918396},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3841361999511719},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2778993844985962}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.18653/v1/2020.acl-main.677","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2020.acl-main.677","pdf_url":"https://www.aclweb.org/anthology/2020.acl-main.677.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1911.04942","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1911.04942","pdf_url":"https://arxiv.org/pdf/1911.04942","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"mag:2985377636","is_oa":true,"landing_page_url":"https://arxiv.org/pdf/1911.04942","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"arXiv (Cornell University)","raw_type":null},{"id":"doi:10.48550/arxiv.1911.04942","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.1911.04942","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"doi:10.18653/v1/2020.acl-main.677","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2020.acl-main.677","pdf_url":"https://www.aclweb.org/anthology/2020.acl-main.677.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 58th Annual Meeting of the Association for Computational Linguistics","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2985377636.pdf","grobid_xml":"https://content.openalex.org/works/W2985377636.grobid-xml"},"referenced_works_count":31,"referenced_works":["https://openalex.org/W2064675550","https://openalex.org/W2123442489","https://openalex.org/W2153710242","https://openalex.org/W2163274265","https://openalex.org/W2269738476","https://openalex.org/W2751448157","https://openalex.org/W2766453196","https://openalex.org/W2798663534","https://openalex.org/W2809324505","https://openalex.org/W2863697128","https://openalex.org/W2890561662","https://openalex.org/W2891691255","https://openalex.org/W2899771611","https://openalex.org/W2945102109","https://openalex.org/W2945290078","https://openalex.org/W2952032096","https://openalex.org/W2963266340","https://openalex.org/W2963341956","https://openalex.org/W2963357517","https://openalex.org/W2963617989","https://openalex.org/W2963866663","https://openalex.org/W2963925437","https://openalex.org/W2964121744","https://openalex.org/W2964271186","https://openalex.org/W2969670656","https://openalex.org/W2971323043","https://openalex.org/W2971377618","https://openalex.org/W2995446988","https://openalex.org/W2996086147","https://openalex.org/W3003587002","https://openalex.org/W3015937477"],"related_works":["https://openalex.org/W3034835156","https://openalex.org/W2751448157","https://openalex.org/W2963341956","https://openalex.org/W2963403868","https://openalex.org/W2945102109","https://openalex.org/W2964121744","https://openalex.org/W2163274265","https://openalex.org/W3152888762","https://openalex.org/W3015937477","https://openalex.org/W2963794306","https://openalex.org/W2963617989","https://openalex.org/W2891691255","https://openalex.org/W2890431379","https://openalex.org/W2047237057","https://openalex.org/W2953484651","https://openalex.org/W3116855718","https://openalex.org/W2966086173","https://openalex.org/W3111018782","https://openalex.org/W3187638065","https://openalex.org/W2984689063"],"abstract_inverted_index":{"When":[0],"translating":[1],"natural":[2],"language":[3],"questions":[4,10],"into":[5],"SQL":[6],"queries":[7],"to":[8,19,21,68,93],"answer":[9],"from":[11],"a":[12,54,59,78],"database,":[13],"contemporary":[14],"semantic":[15,41],"parsing":[16],"models":[17],"struggle":[18],"generalize":[20],"unseen":[22],"database":[23,33,48],"schemas.":[24],"The":[25],"generalization":[26],"challenge":[27],"lies":[28],"in":[29,35,53,125],"(a)":[30],"encoding":[31],"the":[32,40,64,82,89,109,116,126],"relations":[34],"an":[36],"accessible":[37],"way":[38],"for":[39],"parser,":[42],"and":[43,50,74,132],"(b)":[44],"modeling":[45],"alignment":[46],"between":[47],"columns":[49],"their":[51],"mentions":[52],"given":[55],"query.":[56],"We":[57],"present":[58],"unified":[60],"framework,":[61],"based":[62],"on":[63,115],"relation-aware":[65],"self-attention":[66],"mechanism,":[67],"address":[69],"schema":[70,72,130],"encoding,":[71],"linking,":[73],"feature":[75],"representation":[76],"within":[77],"text-to-SQL":[79],"encoder.":[80],"On":[81],"challenging":[83],"Spider":[84,117],"dataset":[85],"this":[86],"framework":[87],"boosts":[88],"exact":[90],"match":[91],"accuracy":[92],"57.2%,":[94],"surpassing":[95],"its":[96],"best":[97],"counterparts":[98],"by":[99],"8.7%":[100],"absolute":[101],"improvement.":[102],"Further":[103],"augmented":[104],"with":[105],"BERT,":[106],"it":[107],"achieves":[108],"new":[110],"state-of-the-art":[111],"performance":[112],"of":[113,129],"65.6%":[114],"leaderboard.":[118],"In":[119],"addition,":[120],"we":[121],"observe":[122],"qualitative":[123],"improvements":[124],"model's":[127],"understanding":[128],"linking":[131],"alignment.":[133],"Our":[134],"implementation":[135],"will":[136],"be":[137],"open-sourced":[138],"at":[139]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":7},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":13},{"year":2020,"cited_by_count":8}],"updated_date":"2026-03-10T16:38:18.471706","created_date":"2025-10-10T00:00:00"}