{"id":"https://openalex.org/W4394939134","doi":"https://doi.org/10.1109/tcds.2024.3391278","title":"MAVIDSQL: A Model-Agnostic Visualization for Interpretation and Diagnosis of Text-to-SQL Tasks","display_name":"MAVIDSQL: A Model-Agnostic Visualization for Interpretation and Diagnosis of Text-to-SQL Tasks","publication_year":2024,"publication_date":"2024-04-18","ids":{"openalex":"https://openalex.org/W4394939134","doi":"https://doi.org/10.1109/tcds.2024.3391278"},"language":"en","primary_location":{"id":"doi:10.1109/tcds.2024.3391278","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tcds.2024.3391278","pdf_url":null,"source":{"id":"https://openalex.org/S2488537894","display_name":"IEEE Transactions on Cognitive and Developmental Systems","issn_l":"2379-8920","issn":["2379-8920","2379-8939"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Cognitive and Developmental 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/A5015778738","display_name":"Jingwei Tang","orcid":"https://orcid.org/0000-0001-5712-0722"},"institutions":[{"id":"https://openalex.org/I55712492","display_name":"Zhejiang University of Technology","ror":"https://ror.org/02djqfd08","country_code":"CN","type":"education","lineage":["https://openalex.org/I55712492"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Jingwei Tang","raw_affiliation_strings":["College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China","institution_ids":["https://openalex.org/I55712492"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015625058","display_name":"Guodao Sun","orcid":"https://orcid.org/0000-0002-8383-8153"},"institutions":[{"id":"https://openalex.org/I55712492","display_name":"Zhejiang University of Technology","ror":"https://ror.org/02djqfd08","country_code":"CN","type":"education","lineage":["https://openalex.org/I55712492"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guodao Sun","raw_affiliation_strings":["College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China","institution_ids":["https://openalex.org/I55712492"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114488752","display_name":"Jiahui Chen","orcid":"https://orcid.org/0009-0004-6824-632X"},"institutions":[{"id":"https://openalex.org/I55712492","display_name":"Zhejiang University of Technology","ror":"https://ror.org/02djqfd08","country_code":"CN","type":"education","lineage":["https://openalex.org/I55712492"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jiahui Chen","raw_affiliation_strings":["College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China","institution_ids":["https://openalex.org/I55712492"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101574588","display_name":"Gefei Zhang","orcid":"https://orcid.org/0009-0005-5704-9176"},"institutions":[{"id":"https://openalex.org/I55712492","display_name":"Zhejiang University of Technology","ror":"https://ror.org/02djqfd08","country_code":"CN","type":"education","lineage":["https://openalex.org/I55712492"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Gefei Zhang","raw_affiliation_strings":["College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China","institution_ids":["https://openalex.org/I55712492"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070989578","display_name":"Baofeng Chang","orcid":"https://orcid.org/0000-0002-1028-716X"},"institutions":[{"id":"https://openalex.org/I55712492","display_name":"Zhejiang University of Technology","ror":"https://ror.org/02djqfd08","country_code":"CN","type":"education","lineage":["https://openalex.org/I55712492"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Baofeng Chang","raw_affiliation_strings":["College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China","institution_ids":["https://openalex.org/I55712492"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100439428","display_name":"Haixia Wang","orcid":"https://orcid.org/0000-0002-2378-2725"},"institutions":[{"id":"https://openalex.org/I55712492","display_name":"Zhejiang University of Technology","ror":"https://ror.org/02djqfd08","country_code":"CN","type":"education","lineage":["https://openalex.org/I55712492"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haixia Wang","raw_affiliation_strings":["College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China","institution_ids":["https://openalex.org/I55712492"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5001531117","display_name":"Ronghua Liang","orcid":"https://orcid.org/0000-0003-2077-9608"},"institutions":[{"id":"https://openalex.org/I55712492","display_name":"Zhejiang University of Technology","ror":"https://ror.org/02djqfd08","country_code":"CN","type":"education","lineage":["https://openalex.org/I55712492"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ronghua Liang","raw_affiliation_strings":["College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University of Technology, Hangzhou, China","institution_ids":["https://openalex.org/I55712492"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5015778738"],"corresponding_institution_ids":["https://openalex.org/I55712492"],"apc_list":null,"apc_paid":null,"fwci":1.366,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.83051208,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":98},"biblio":{"volume":"16","issue":"5","first_page":"1887","last_page":"1903"},"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/T10260","display_name":"Software Engineering Research","score":0.9932000041007996,"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"}},{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9900000095367432,"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.9131847023963928},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.6927676200866699},{"id":"https://openalex.org/keywords/interpretation","display_name":"Interpretation (philosophy)","score":0.6635895371437073},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.63920658826828},{"id":"https://openalex.org/keywords/data-visualization","display_name":"Data visualization","score":0.5637903213500977},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.4548895061016083},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4256320595741272},{"id":"https://openalex.org/keywords/visual-analytics","display_name":"Visual analytics","score":0.41335344314575195},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.362632155418396},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3622742295265198}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9131847023963928},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.6927676200866699},{"id":"https://openalex.org/C527412718","wikidata":"https://www.wikidata.org/wiki/Q855395","display_name":"Interpretation (philosophy)","level":2,"score":0.6635895371437073},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.63920658826828},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.5637903213500977},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.4548895061016083},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4256320595741272},{"id":"https://openalex.org/C59732488","wikidata":"https://www.wikidata.org/wiki/Q2528440","display_name":"Visual analytics","level":3,"score":0.41335344314575195},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.362632155418396},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3622742295265198}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tcds.2024.3391278","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tcds.2024.3391278","pdf_url":null,"source":{"id":"https://openalex.org/S2488537894","display_name":"IEEE Transactions on Cognitive and Developmental Systems","issn_l":"2379-8920","issn":["2379-8920","2379-8939"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Cognitive and Developmental Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4099999964237213,"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities"}],"awards":[{"id":"https://openalex.org/G2861150812","display_name":null,"funder_award_id":"62036009","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4281558348","display_name":null,"funder_award_id":"62372411","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5453643118","display_name":null,"funder_award_id":"RF-B2023006","funder_id":"https://openalex.org/F4554350417","funder_display_name":"Fundamental Research Funds for the Provincial Universities of Zhejiang"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4554350417","display_name":"Fundamental Research Funds for the Provincial Universities of Zhejiang","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":49,"referenced_works":["https://openalex.org/W1973012451","https://openalex.org/W2115556748","https://openalex.org/W2143475690","https://openalex.org/W2156377393","https://openalex.org/W2248605503","https://openalex.org/W2512274390","https://openalex.org/W2751448157","https://openalex.org/W2752194699","https://openalex.org/W2768409085","https://openalex.org/W2886614482","https://openalex.org/W2889883176","https://openalex.org/W2890431379","https://openalex.org/W2891691255","https://openalex.org/W2896457183","https://openalex.org/W2906105753","https://openalex.org/W2945102109","https://openalex.org/W2952032096","https://openalex.org/W2963123635","https://openalex.org/W2963214037","https://openalex.org/W2964200170","https://openalex.org/W2965373594","https://openalex.org/W2971323043","https://openalex.org/W2978934711","https://openalex.org/W3005984470","https://openalex.org/W3034835156","https://openalex.org/W3035231859","https://openalex.org/W3048148501","https://openalex.org/W3091852516","https://openalex.org/W3102020135","https://openalex.org/W3103801878","https://openalex.org/W3118589616","https://openalex.org/W3126918322","https://openalex.org/W3150263485","https://openalex.org/W3159301005","https://openalex.org/W3169343516","https://openalex.org/W3183122026","https://openalex.org/W3200033622","https://openalex.org/W3204549625","https://openalex.org/W3214600982","https://openalex.org/W4285244831","https://openalex.org/W4288089799","https://openalex.org/W4288601872","https://openalex.org/W4295954116","https://openalex.org/W4315778472","https://openalex.org/W4317716303","https://openalex.org/W4360836968","https://openalex.org/W4361019453","https://openalex.org/W4385572953","https://openalex.org/W4392658099"],"related_works":["https://openalex.org/W2362367986","https://openalex.org/W348707231","https://openalex.org/W2571228289","https://openalex.org/W4293108519","https://openalex.org/W3041760129","https://openalex.org/W2013728941","https://openalex.org/W4225274103","https://openalex.org/W2154046714","https://openalex.org/W2189613078","https://openalex.org/W2579659702"],"abstract_inverted_index":{"Significant":[0],"advancements":[1],"in":[2,36,40,83,101,132,195],"semantic":[3,98],"parsing":[4],"for":[5,112],"text-to-SQL":[6,48,102,136,200],"tasks":[7],"have":[8,80],"been":[9,34,81,91],"achieved":[10],"through":[11],"the":[12,44,66,73,95,107,143,146,150,191,197],"employment":[13],"of":[14,27,47,68,97,109,193,199],"neural":[15],"network":[16],"models,":[17,30],"such":[18],"as":[19,52],"LSTM,":[20],"BERT,":[21],"and":[22,62,115,130,134,149,162,178,185,202],"T5.":[23],"The":[24,138],"exceptional":[25],"performance":[26],"large":[28],"language":[29,85],"like":[31],"ChatGPT,":[32],"has":[33,90],"demonstrated":[35],"recent":[37],"research,":[38],"even":[39],"zero-shot":[41],"scenarios.":[42],"However,":[43],"inherent":[45],"transparency":[46],"models":[49],"presents":[50,119],"them":[51],"black":[53],"boxes,":[54],"concealing":[55],"their":[56],"inner":[57],"workings":[58],"from":[59],"both":[60],"developers":[61,129],"users,":[63],"which":[64,153],"complicates":[65],"diagnosis":[67],"potential":[69,160,204],"error":[70,176],"patterns.":[71],"Despite":[72],"fact":[74],"that":[75],"numerous":[76],"visual":[77,122,172],"analysis":[78,123,173],"studies":[79,184],"conducted":[82],"natural":[84],"processing":[86],"communities,":[87],"scant":[88],"attention":[89],"paid":[92],"to":[93,126,158,174],"addressing":[94],"challenges":[96],"parsing,":[99],"specifically":[100],"tasks.":[103,137],"This":[104,117],"limitation":[105],"hinders":[106],"development":[108],"effective":[110],"tools":[111],"model":[113,128,164,180],"optimization":[114],"evaluation.":[116],"paper":[118],"an":[120],"interactive":[121,171],"tool,":[124],"MAVIDSQL,":[125],"assist":[127],"users":[131],"understanding":[133,198],"diagnosing":[135],"system":[139],"comprises":[140],"three":[141],"modules:":[142],"Model":[144],"Manager,":[145],"Feature":[147],"Extractor,":[148],"Visualization":[151],"Interface,":[152],"adopt":[154],"a":[155],"model-agnostic":[156],"approach":[157],"diagnose":[159],"errors":[161],"infer":[163],"decisions":[165],"by":[166],"analyzing":[167],"input-output":[168],"data,":[169],"facilitating":[170,196],"identify":[175],"patterns":[177],"assess":[179],"performance.":[181],"Two":[182],"case":[183],"interviews":[186],"with":[187],"domain":[188],"experts":[189],"demonstrate":[190],"effectiveness":[192],"MAVIDSQL":[194],"Tasks":[201],"identifying":[203],"errors.":[205]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3}],"updated_date":"2026-04-09T08:11:56.329763","created_date":"2025-10-10T00:00:00"}