{"id":"https://openalex.org/W4319725120","doi":"https://doi.org/10.1162/dint_a_00194","title":"Towards Text-to-SQL over Aggregate Tables","display_name":"Towards Text-to-SQL over Aggregate Tables","publication_year":2022,"publication_date":"2022-10-01","ids":{"openalex":"https://openalex.org/W4319725120","doi":"https://doi.org/10.1162/dint_a_00194"},"language":"en","primary_location":{"id":"doi:10.1162/dint_a_00194","is_oa":true,"landing_page_url":"https://doi.org/10.1162/dint_a_00194","pdf_url":"https://direct.mit.edu/dint/article-pdf/doi/10.1162/dint_a_00194/2070491/dint_a_00194.pdf","source":{"id":"https://openalex.org/S4210186383","display_name":"Data Intelligence","issn_l":"2096-7004","issn":["2096-7004","2641-435X"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310315718","host_organization_name":"The MIT Press","host_organization_lineage":["https://openalex.org/P4310315718"],"host_organization_lineage_names":["The MIT Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data Intelligence","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://direct.mit.edu/dint/article-pdf/doi/10.1162/dint_a_00194/2070491/dint_a_00194.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100778782","display_name":"Shuqin Li","orcid":"https://orcid.org/0000-0003-3647-442X"},"institutions":[{"id":"https://openalex.org/I116953780","display_name":"Tongji University","ror":"https://ror.org/03rc6as71","country_code":"CN","type":"education","lineage":["https://openalex.org/I116953780"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shuqin Li","raw_affiliation_strings":["College of Design and Innovation, Tongji University, Shanghai, 200092"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Design and Innovation, Tongji University, Shanghai, 200092","institution_ids":["https://openalex.org/I116953780"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055025300","display_name":"Kaibin Zhou","orcid":null},"institutions":[{"id":"https://openalex.org/I116953780","display_name":"Tongji University","ror":"https://ror.org/03rc6as71","country_code":"CN","type":"education","lineage":["https://openalex.org/I116953780"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Kaibin Zhou","raw_affiliation_strings":["School of Software, Tongji University, Shanghai, 201804"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software, Tongji University, Shanghai, 201804","institution_ids":["https://openalex.org/I116953780"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003922435","display_name":"Zeyang Zhuang","orcid":"https://orcid.org/0009-0006-7898-6895"},"institutions":[{"id":"https://openalex.org/I116953780","display_name":"Tongji University","ror":"https://ror.org/03rc6as71","country_code":"CN","type":"education","lineage":["https://openalex.org/I116953780"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zeyang Zhuang","raw_affiliation_strings":["School of Software, Tongji University, Shanghai, 201804"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software, Tongji University, Shanghai, 201804","institution_ids":["https://openalex.org/I116953780"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039059501","display_name":"Haofen Wang","orcid":"https://orcid.org/0000-0003-3018-3824"},"institutions":[{"id":"https://openalex.org/I116953780","display_name":"Tongji University","ror":"https://ror.org/03rc6as71","country_code":"CN","type":"education","lineage":["https://openalex.org/I116953780"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Haofen Wang","raw_affiliation_strings":["College of Design and Innovation, Tongji University, Shanghai, 200092"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Design and Innovation, Tongji University, Shanghai, 200092","institution_ids":["https://openalex.org/I116953780"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100747067","display_name":"Jun Ma","orcid":"https://orcid.org/0000-0002-1257-9748"},"institutions":[{"id":"https://openalex.org/I116953780","display_name":"Tongji University","ror":"https://ror.org/03rc6as71","country_code":"CN","type":"education","lineage":["https://openalex.org/I116953780"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Jun Ma","raw_affiliation_strings":["School of Automotive Studies, Tongji University, Shanghai, 201804"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Automotive Studies, Tongji University, Shanghai, 201804","institution_ids":["https://openalex.org/I116953780"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5039059501","https://openalex.org/A5100747067"],"corresponding_institution_ids":["https://openalex.org/I116953780"],"apc_list":null,"apc_paid":null,"fwci":0.8167,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.76053347,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"5","issue":"2","first_page":"457","last_page":"474"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9927999973297119,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9927999973297119,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9902999997138977,"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.9843999743461609,"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.8265215158462524},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6840019226074219},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6336898803710938},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.47979122400283813},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.47493961453437805},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.4571012258529663},{"id":"https://openalex.org/keywords/pruning","display_name":"Pruning","score":0.41918259859085083},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4005609154701233},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.30543243885040283}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8265215158462524},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6840019226074219},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6336898803710938},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.47979122400283813},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.47493961453437805},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.4571012258529663},{"id":"https://openalex.org/C108010975","wikidata":"https://www.wikidata.org/wiki/Q500094","display_name":"Pruning","level":2,"score":0.41918259859085083},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4005609154701233},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.30543243885040283},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C6557445","wikidata":"https://www.wikidata.org/wiki/Q173113","display_name":"Agronomy","level":1,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1162/dint_a_00194","is_oa":true,"landing_page_url":"https://doi.org/10.1162/dint_a_00194","pdf_url":"https://direct.mit.edu/dint/article-pdf/doi/10.1162/dint_a_00194/2070491/dint_a_00194.pdf","source":{"id":"https://openalex.org/S4210186383","display_name":"Data Intelligence","issn_l":"2096-7004","issn":["2096-7004","2641-435X"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310315718","host_organization_name":"The MIT Press","host_organization_lineage":["https://openalex.org/P4310315718"],"host_organization_lineage_names":["The MIT Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data Intelligence","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:2e7fd2c102104496b991673f07d454b5","is_oa":false,"landing_page_url":"https://doaj.org/article/2e7fd2c102104496b991673f07d454b5","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Data Intelligence, Vol 5, Iss 2, Pp 457-474 (2023)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1162/dint_a_00194","is_oa":true,"landing_page_url":"https://doi.org/10.1162/dint_a_00194","pdf_url":"https://direct.mit.edu/dint/article-pdf/doi/10.1162/dint_a_00194/2070491/dint_a_00194.pdf","source":{"id":"https://openalex.org/S4210186383","display_name":"Data Intelligence","issn_l":"2096-7004","issn":["2096-7004","2641-435X"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310315718","host_organization_name":"The MIT Press","host_organization_lineage":["https://openalex.org/P4310315718"],"host_organization_lineage_names":["The MIT Press"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data Intelligence","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W1495859460","https://openalex.org/W2251957808","https://openalex.org/W2751448157","https://openalex.org/W2863697128","https://openalex.org/W2890431379","https://openalex.org/W2896457183","https://openalex.org/W2952032096","https://openalex.org/W2963617989","https://openalex.org/W3034835156","https://openalex.org/W3035159685","https://openalex.org/W3035231859","https://openalex.org/W3101082165","https://openalex.org/W3102020135","https://openalex.org/W3102381932","https://openalex.org/W3102480827","https://openalex.org/W3103801878","https://openalex.org/W3106221893","https://openalex.org/W3124424060","https://openalex.org/W3156366114","https://openalex.org/W3177318507","https://openalex.org/W4287898313","https://openalex.org/W4385245566","https://openalex.org/W6773245271","https://openalex.org/W6786852218"],"related_works":["https://openalex.org/W1592149428","https://openalex.org/W650213220","https://openalex.org/W1980548249","https://openalex.org/W2183714398","https://openalex.org/W3094396153","https://openalex.org/W2042813897","https://openalex.org/W2340883001","https://openalex.org/W4382050951","https://openalex.org/W1481857963","https://openalex.org/W1554917839"],"abstract_inverted_index":{"ABSTRACT":[0],"Text-to-SQL":[1],"aims":[2],"at":[3],"translating":[4],"textual":[5],"questions":[6,51],"into":[7],"the":[8,34,161],"corresponding":[9],"SQL":[10],"queries.":[11,19],"Aggregate":[12],"tables":[13,42],"are":[14,138],"widely":[15],"created":[16],"for":[17,101,118,140,155],"high-frequent":[18],"Although":[20],"text-to-SQL":[21,102],"has":[22],"emerged":[23],"as":[24,86],"an":[25],"important":[26],"task,":[27],"recent":[28],"studies":[29],"paid":[30],"little":[31],"attention":[32],"to":[33,67,133],"task":[35],"over":[36,103],"aggregate":[37,41,104,141],"tables.":[38,105,142],"The":[39,73],"increased":[40],"bring":[43],"two":[44],"challenges:":[45],"(1)":[46],"mapping":[47],"of":[48,76,165,172,177],"natural":[49],"language":[50],"and":[52,71,163,174],"relational":[53],"databases":[54],"will":[55,81],"suffer":[56],"from":[57,152],"more":[58,84],"ambiguity,":[59],"(2)":[60],"modern":[61],"models":[62],"usually":[63],"adopt":[64],"self-attention":[65],"mechanism":[66,74,117],"encode":[68],"database":[69],"schema":[70],"question.":[72],"is":[75],"quadratic":[77],"time":[78,179],"complexity,":[79],"which":[80],"make":[82],"inferring":[83],"time-consuming":[85],"input":[87],"sequence":[88],"length":[89],"grows.":[90],"In":[91],"this":[92],"paper,":[93],"we":[94,112,127],"introduce":[95,128],"a":[96,114,129,146,181],"novel":[97],"approach":[98],"named":[99],"WAGG":[100],"To":[106,121],"effectively":[107],"select":[108],"among":[109],"ambiguous":[110],"items,":[111],"propose":[113],"relation":[115,119],"selection":[116],"computing.":[120],"deal":[122],"with":[123,169],"high":[124],"computation":[125],"costs,":[126],"dynamical":[130],"pruning":[131],"strategy":[132],"discard":[134],"unrelated":[135],"items":[136],"that":[137],"common":[139],"We":[143],"also":[144],"construct":[145],"new":[147],"large-scale":[148],"dataset":[149,154],"SpiderwAGG":[150],"extended":[151],"Spider":[153],"validation,":[156],"where":[157],"extensive":[158],"experiments":[159],"show":[160],"effectiveness":[162],"efficiency":[164],"our":[166],"proposed":[167],"method":[168],"4%":[170],"increase":[171],"accuracy":[173],"15%":[175],"decrease":[176],"inference":[178],"w.r.t":[180],"strong":[182],"baseline":[183],"RAT-SQL.":[184]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}