{"id":"https://openalex.org/W4378505284","doi":"https://doi.org/10.48550/arxiv.2305.16265","title":"UNITE: A Unified Benchmark for Text-to-SQL Evaluation","display_name":"UNITE: A Unified Benchmark for Text-to-SQL Evaluation","publication_year":2023,"publication_date":"2023-05-25","ids":{"openalex":"https://openalex.org/W4378505284","doi":"https://doi.org/10.48550/arxiv.2305.16265"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2305.16265","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2305.16265","pdf_url":"https://arxiv.org/pdf/2305.16265","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":"","raw_type":"text"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2305.16265","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5058348064","display_name":"Wuwei Lan","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Lan, Wuwei","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100430099","display_name":"Zhiguo Wang","orcid":"https://orcid.org/0000-0003-3686-6220"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wang, Zhiguo","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107406620","display_name":"Anuj Chauhan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chauhan, Anuj","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054049845","display_name":"Henghui Zhu","orcid":"https://orcid.org/0000-0002-4534-6975"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhu, Henghui","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041824418","display_name":"Alexander Li","orcid":"https://orcid.org/0009-0003-9852-0855"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Li, Alexander","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100301349","display_name":"Jiang Guo","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Guo, Jiang","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100394046","display_name":"Sheng Zhang","orcid":"https://orcid.org/0000-0003-1732-0011"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhang, Sheng","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042384129","display_name":"Chung-Wei Hang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hang, Chung-Wei","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025863991","display_name":"Joseph Lilien","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lilien, Joseph","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102837904","display_name":"Yiqun Hu","orcid":"https://orcid.org/0000-0001-9157-7865"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hu, Yiqun","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100439438","display_name":"Lin Pan","orcid":"https://orcid.org/0000-0001-5271-6295"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Pan, Lin","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018125443","display_name":"Mingwen Dong","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dong, Mingwen","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100384838","display_name":"Jun Wang","orcid":"https://orcid.org/0000-0002-9515-076X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wang, Jun","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055815844","display_name":"Jiarong Jiang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jiang, Jiarong","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089963460","display_name":"Stephen R. Ash","orcid":"https://orcid.org/0000-0003-4873-6087"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ash, Stephen","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112539661","display_name":"Vittorio Castelli","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Castelli, Vittorio","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102761306","display_name":"Patrick Ng","orcid":"https://orcid.org/0000-0001-8208-652X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ng, Patrick","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5107249743","display_name":"Bing Xiang","orcid":"https://orcid.org/0009-0006-4028-4935"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xiang, Bing","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":18,"corresponding_author_ids":["https://openalex.org/A5058348064"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":9,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9977999925613403,"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.9977999925613403,"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.993399977684021,"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.9620000123977661,"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.8528788089752197},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.810935378074646},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.725261926651001},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.47685396671295166},{"id":"https://openalex.org/keywords/null","display_name":"Null (SQL)","score":0.45756796002388},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.4386079013347626},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.41580063104629517},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.36018770933151245},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.3253566324710846},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.31701335310935974},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.30596357583999634},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.09266847372055054},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.07228124141693115}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8528788089752197},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.810935378074646},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.725261926651001},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.47685396671295166},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.45756796002388},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.4386079013347626},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.41580063104629517},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.36018770933151245},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.3253566324710846},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.31701335310935974},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.30596357583999634},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09266847372055054},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.07228124141693115},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2305.16265","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2305.16265","pdf_url":"https://arxiv.org/pdf/2305.16265","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":"","raw_type":"text"},{"id":"doi:10.48550/arxiv.2305.16265","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2305.16265","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":"pmh:oai:arXiv.org:2305.16265","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2305.16265","pdf_url":"https://arxiv.org/pdf/2305.16265","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":"","raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4378505284.pdf","grobid_xml":"https://content.openalex.org/works/W4378505284.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2382973082","https://openalex.org/W4312632526","https://openalex.org/W2086783690","https://openalex.org/W2389720334","https://openalex.org/W151494989","https://openalex.org/W4320473518","https://openalex.org/W1488984669","https://openalex.org/W2031915568","https://openalex.org/W3210031882","https://openalex.org/W2155838697"],"abstract_inverted_index":{"A":[0],"practical":[1],"text-to-SQL":[2,26,43,98],"system":[3],"should":[4],"generalize":[5],"well":[6,111],"on":[7,100,112],"a":[8,30,77,91],"wide":[9],"variety":[10],"of":[11,40,94],"natural":[12,46],"language":[13,47],"questions,":[14],"unseen":[15],"database":[16],"schemas,":[17],"and":[18,61,76,86,104,130,140,157,170],"novel":[19],"SQL":[20,54,81],"query":[21],"structures.":[22],"To":[23],"comprehensively":[24],"evaluate":[25],"systems,":[27],"we":[28,71],"introduce":[29,72],"UNIfied":[31],"benchmark":[32,103,150],"for":[33,127],"Text-to-SQL":[34],"Evaluation":[35],"(UNITE).":[36],"It":[37],"is":[38],"composed":[39],"publicly":[41],"available":[42,175],"datasets,":[44],"containing":[45],"questions":[48,139],"from":[49,56],"more":[50,57],"than":[51,58],"12":[52],"domains,":[53],"queries":[55],"3.9K":[59],"patterns,":[60,82],"29K":[62],"databases.":[63],"Compared":[64],"to":[65],"the":[66,136,144],"widely":[67],"used":[68],"Spider":[69],"benchmark,":[70],"$\\sim$120K":[73],"additional":[74],"examples":[75],"threefold":[78],"increase":[79],"in":[80],"such":[83],"as":[84],"comparative":[85],"boolean":[87],"questions.":[88],"We":[89],"conduct":[90],"systematic":[92],"study":[93],"six":[95],"state-of-the-art":[96],"(SOTA)":[97],"parsers":[99],"our":[101,149],"new":[102],"show":[105],"that:":[106],"1)":[107],"Codex":[108],"performs":[109],"surprisingly":[110],"out-of-domain":[113,131],"datasets;":[114],"2)":[115],"specially":[116],"designed":[117],"decoding":[118],"methods":[119],"(e.g.":[120],"constrained":[121],"beam":[122],"search)":[123],"can":[124],"improve":[125],"performance":[126],"both":[128],"in-domain":[129],"settings;":[132],"3)":[133],"explicitly":[134],"modeling":[135],"relationship":[137],"between":[138],"schemas":[141],"further":[142],"improves":[143],"Seq2Seq":[145],"models.":[146],"More":[147],"importantly,":[148],"presents":[151],"key":[152],"challenges":[153],"towards":[154],"compositional":[155],"generalization":[156],"robustness":[158],"issues":[159],"--":[160],"which":[161],"these":[162],"SOTA":[163],"models":[164],"cannot":[165],"address":[166],"well.":[167],"Our":[168],"code":[169],"data":[171],"processing":[172],"script":[173],"are":[174],"at":[176],"https://github.com/awslabs/unified-text2sql-benchmark":[177]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":6}],"updated_date":"2026-03-10T16:38:18.471706","created_date":"2025-10-10T00:00:00"}