{"id":"https://openalex.org/W4392348090","doi":"https://doi.org/10.1145/3650114","title":"Insights into Natural Language Database Query Errors: from Attention Misalignment to User Handling Strategies","display_name":"Insights into Natural Language Database Query Errors: from Attention Misalignment to User Handling Strategies","publication_year":2024,"publication_date":"2024-03-02","ids":{"openalex":"https://openalex.org/W4392348090","doi":"https://doi.org/10.1145/3650114"},"language":"en","primary_location":{"id":"doi:10.1145/3650114","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3650114","pdf_url":null,"source":{"id":"https://openalex.org/S4210173818","display_name":"ACM Transactions on Interactive Intelligent Systems","issn_l":"2160-6455","issn":["2160-6455","2160-6463"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Interactive Intelligent Systems","raw_type":"journal-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/A5074125965","display_name":"Zheng Ning","orcid":"https://orcid.org/0000-0001-7374-7453"},"institutions":[{"id":"https://openalex.org/I107639228","display_name":"University of Notre Dame","ror":"https://ror.org/00mkhxb43","country_code":"US","type":"education","lineage":["https://openalex.org/I107639228"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zheng Ning","raw_affiliation_strings":["University of Notre Dame, Notre Dame, USA"],"raw_orcid":"https://orcid.org/0000-0001-7374-7453","affiliations":[{"raw_affiliation_string":"University of Notre Dame, Notre Dame, USA","institution_ids":["https://openalex.org/I107639228"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047416354","display_name":"Yuan Tian","orcid":"https://orcid.org/0000-0002-2200-5713"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yuan Tian","raw_affiliation_strings":["Purdue University, West Lafayette, USA"],"raw_orcid":"https://orcid.org/0000-0002-2200-5713","affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, USA","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081039383","display_name":"Zheng Zhang","orcid":"https://orcid.org/0000-0002-7040-2326"},"institutions":[{"id":"https://openalex.org/I107639228","display_name":"University of Notre Dame","ror":"https://ror.org/00mkhxb43","country_code":"US","type":"education","lineage":["https://openalex.org/I107639228"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zheng Zhang","raw_affiliation_strings":["University of Notre Dame, Notre Dame, USA"],"raw_orcid":"https://orcid.org/0000-0002-7040-2326","affiliations":[{"raw_affiliation_string":"University of Notre Dame, Notre Dame, USA","institution_ids":["https://openalex.org/I107639228"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100437453","display_name":"Tianyi Zhang","orcid":"https://orcid.org/0000-0002-5468-9347"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tianyi Zhang","raw_affiliation_strings":["Purdue University, West Lafayette, USA"],"raw_orcid":"https://orcid.org/0000-0002-5468-9347","affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, USA","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5007240808","display_name":"Toby Jia-Jun Li","orcid":"https://orcid.org/0000-0001-7902-7625"},"institutions":[{"id":"https://openalex.org/I107639228","display_name":"University of Notre Dame","ror":"https://ror.org/00mkhxb43","country_code":"US","type":"education","lineage":["https://openalex.org/I107639228"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Toby Jia-Jun Li","raw_affiliation_strings":["University of Notre Dame, Notre Dame, USA"],"raw_orcid":"https://orcid.org/0000-0001-7902-7625","affiliations":[{"raw_affiliation_string":"University of Notre Dame, Notre Dame, USA","institution_ids":["https://openalex.org/I107639228"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.2228,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.88794461,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":"14","issue":"4","first_page":"1","last_page":"32"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9994000196456909,"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.9994000196456909,"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.9987000226974487,"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/T10260","display_name":"Software Engineering Research","score":0.9965999722480774,"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.856443464756012},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.6201333403587341},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5467939376831055},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.540245771408081},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.5320020318031311},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5201402306556702},{"id":"https://openalex.org/keywords/language-model","display_name":"Language model","score":0.4809693396091461},{"id":"https://openalex.org/keywords/bridge","display_name":"Bridge (graph theory)","score":0.44410231709480286},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4137510061264038},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.33742034435272217}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.856443464756012},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.6201333403587341},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5467939376831055},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.540245771408081},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.5320020318031311},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5201402306556702},{"id":"https://openalex.org/C137293760","wikidata":"https://www.wikidata.org/wiki/Q3621696","display_name":"Language model","level":2,"score":0.4809693396091461},{"id":"https://openalex.org/C100776233","wikidata":"https://www.wikidata.org/wiki/Q2532492","display_name":"Bridge (graph theory)","level":2,"score":0.44410231709480286},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4137510061264038},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.33742034435272217},{"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},{"id":"https://openalex.org/C126322002","wikidata":"https://www.wikidata.org/wiki/Q11180","display_name":"Internal medicine","level":1,"score":0.0},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3650114","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3650114","pdf_url":null,"source":{"id":"https://openalex.org/S4210173818","display_name":"ACM Transactions on Interactive Intelligent Systems","issn_l":"2160-6455","issn":["2160-6455","2160-6463"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Interactive Intelligent Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.8500000238418579,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[{"id":"https://openalex.org/G1887447798","display_name":"Collaborative Research: SHF: Medium: Towards More Human-like AI Models of Source Code","funder_award_id":"2211428","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4706632707","display_name":"Proto-OKN Theme 1: Knowledge Graph Construction for Resilient, Trustworthy, and Secure Software Supply Chains","funder_award_id":"2333736","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7802459857","display_name":null,"funder_award_id":"ITE-2333736","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320309480","display_name":"Nvidia","ror":"https://ror.org/03jdj4y14"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":96,"referenced_works":["https://openalex.org/W1583837637","https://openalex.org/W1722846244","https://openalex.org/W1902674502","https://openalex.org/W1975879668","https://openalex.org/W1979290264","https://openalex.org/W2032374895","https://openalex.org/W2085828533","https://openalex.org/W2086320398","https://openalex.org/W2120589136","https://openalex.org/W2156985047","https://openalex.org/W2159934185","https://openalex.org/W2164155814","https://openalex.org/W2165382777","https://openalex.org/W2269738476","https://openalex.org/W2274505579","https://openalex.org/W2516809705","https://openalex.org/W2534380090","https://openalex.org/W2536574992","https://openalex.org/W2562979205","https://openalex.org/W2594633041","https://openalex.org/W2610474269","https://openalex.org/W2733769132","https://openalex.org/W2745934983","https://openalex.org/W2751448157","https://openalex.org/W2753415590","https://openalex.org/W2753472863","https://openalex.org/W2762513422","https://openalex.org/W2796544889","https://openalex.org/W2798456655","https://openalex.org/W2798753108","https://openalex.org/W2889883176","https://openalex.org/W2890431379","https://openalex.org/W2895739182","https://openalex.org/W2912083425","https://openalex.org/W2914275818","https://openalex.org/W2945102109","https://openalex.org/W2952032096","https://openalex.org/W2952682849","https://openalex.org/W2953192040","https://openalex.org/W2962851944","https://openalex.org/W2963149119","https://openalex.org/W2963341956","https://openalex.org/W2970393840","https://openalex.org/W2972018816","https://openalex.org/W2972324944","https://openalex.org/W2984353433","https://openalex.org/W2995200518","https://openalex.org/W3012014212","https://openalex.org/W3017863658","https://openalex.org/W3019871180","https://openalex.org/W3025624935","https://openalex.org/W3031696893","https://openalex.org/W3034503989","https://openalex.org/W3035140194","https://openalex.org/W3035715371","https://openalex.org/W3046744391","https://openalex.org/W3085281588","https://openalex.org/W3094211608","https://openalex.org/W3094252362","https://openalex.org/W3103962261","https://openalex.org/W3104030782","https://openalex.org/W3104514174","https://openalex.org/W3105251181","https://openalex.org/W3115456736","https://openalex.org/W3128196311","https://openalex.org/W3134547365","https://openalex.org/W3141327079","https://openalex.org/W3162444510","https://openalex.org/W3169611685","https://openalex.org/W3170656151","https://openalex.org/W3174940665","https://openalex.org/W3177376359","https://openalex.org/W3187638065","https://openalex.org/W3200079259","https://openalex.org/W3214600982","https://openalex.org/W4220867331","https://openalex.org/W4221166579","https://openalex.org/W4225108562","https://openalex.org/W4230330790","https://openalex.org/W4230872509","https://openalex.org/W4231388112","https://openalex.org/W4287634587","https://openalex.org/W4287723703","https://openalex.org/W4288025992","https://openalex.org/W4288103164","https://openalex.org/W4300371389","https://openalex.org/W4322718191","https://openalex.org/W4360991127","https://openalex.org/W4366548345","https://openalex.org/W4366660081","https://openalex.org/W4366835679","https://openalex.org/W4372346061","https://openalex.org/W4377014236","https://openalex.org/W4385245566","https://openalex.org/W4386302905","https://openalex.org/W4389520086"],"related_works":["https://openalex.org/W2378211422","https://openalex.org/W2745001401","https://openalex.org/W4321353415","https://openalex.org/W2130974462","https://openalex.org/W2028665553","https://openalex.org/W2086519370","https://openalex.org/W972276598","https://openalex.org/W2087343574","https://openalex.org/W4246352526","https://openalex.org/W2296445635"],"abstract_inverted_index":{"Querying":[0],"structured":[1],"databases":[2],"with":[3,37,94,125],"natural":[4,21,117,160],"language":[5,22,27,118,161],"(NL2SQL)":[6],"has":[7],"remained":[8],"a":[9,53,56,78,121],"difficult":[10],"problem":[11],"for":[12,70,159],"years.":[13],"Recently,":[14],"the":[15,38,46,60,76,99,102,111,116,132,148,166],"advancement":[16],"of":[17,55,59,65,68,80,98,104,134,150],"machine":[18],"learning":[19],"(ML),":[20],"processing":[23],"(NLP),":[24],"and":[25,63,153,156],"large":[26],"models":[28,87],"(LLM)":[29],"have":[30],"led":[31],"to":[32,115,130],"significant":[33],"improvements":[34],"in":[35,90,139,165],"performance,":[36],"best":[39],"model":[40,105,151],"achieving":[41],"\u223c85%":[42],"percent":[43],"accuracy":[44],"on":[45,147],"benchmark":[47],"Spider":[48],"dataset.":[49],"However,":[50],"there":[51],"is":[52],"lack":[54],"systematic":[57],"understanding":[58],"types,":[61],"causes,":[62],"effectiveness":[64,133],"error-handling":[66,137],"mechanisms":[67,138],"errors":[69,81,106],"erroneous":[71],"queries":[72],"nowadays.":[73],"To":[74],"bridge":[75],"gap,":[77],"taxonomy":[79],"made":[82],"by":[83,109],"four":[84],"representative":[85],"NL2SQL":[86],"was":[88,128],"built":[89],"this":[91,143],"work,":[92],"along":[93],"an":[95],"in-depth":[96],"analysis":[97],"errors.":[100],"Second,":[101],"causes":[103],"were":[107],"explored":[108],"analyzing":[110],"model-human":[112],"attention":[113],"alignment":[114],"query.":[119],"Last,":[120],"within-subjects":[122],"user":[123],"study":[124],"26":[126],"participants":[127],"conducted":[129],"investigate":[131],"three":[135],"interactive":[136],"NL2SQL.":[140],"Findings":[141],"from":[142],"article":[144],"shed":[145],"light":[146],"design":[149],"structure":[152],"error":[154],"discovery":[155],"repair":[157],"strategies":[158],"data":[162],"query":[163],"interfaces":[164],"future.":[167]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":5}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}