{"id":"https://openalex.org/W4400909559","doi":"https://doi.org/10.1109/icde60146.2024.00420","title":"Chat2Query: A Zero-Shot Automatic Exploratory Data Analysis System with Large Language Models","display_name":"Chat2Query: A Zero-Shot Automatic Exploratory Data Analysis System with Large Language Models","publication_year":2024,"publication_date":"2024-05-13","ids":{"openalex":"https://openalex.org/W4400909559","doi":"https://doi.org/10.1109/icde60146.2024.00420"},"language":"en","primary_location":{"id":"doi:10.1109/icde60146.2024.00420","doi":"https://doi.org/10.1109/icde60146.2024.00420","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde60146.2024.00420","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 40th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"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/A5114195823","display_name":"Jun-Peng Zhu","orcid":"https://orcid.org/0009-0006-9053-0129","observed_orcids":["https://orcid.org/0009-0006-9053-0129"]},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jun-Peng Zhu","raw_affiliation_strings":["East China Normal University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"East China Normal University","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100618606","display_name":"Peng Cai","orcid":"https://orcid.org/0000-0002-5457-3811","observed_orcids":["https://orcid.org/0000-0002-5457-3811","https://orcid.org/0000-0001-5640-4715","https://orcid.org/0009-0007-8685-0135"]},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Peng Cai","raw_affiliation_strings":["East China Normal University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"East China Normal University","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105309751","display_name":"Boyan Niu","orcid":"https://orcid.org/0009-0000-3242-6864","observed_orcids":["https://orcid.org/0009-0000-3242-6864"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Boyan Niu","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113300589","display_name":"Zheming Ni","orcid":"https://orcid.org/0009-0005-9689-8162","observed_orcids":["https://orcid.org/0009-0005-9689-8162"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zheming Ni","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101925526","display_name":"Kai Xu","orcid":"https://orcid.org/0000-0002-4334-2444","observed_orcids":["https://orcid.org/0000-0002-4334-2444"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kai Xu","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101440049","display_name":"Jiajun Huang","orcid":"https://orcid.org/0009-0005-9963-3047","observed_orcids":["https://orcid.org/0009-0005-9963-3047","https://orcid.org/0009-0008-1129-5488","https://orcid.org/0009-0007-2346-953X"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jiajun Huang","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]},{"author_position":"middle","author":{"id":null,"display_name":"Jianwei Wan","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jianwei Wan","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111513994","display_name":"Shengbo Ma","orcid":"https://orcid.org/0009-0005-3133-4358","observed_orcids":["https://orcid.org/0009-0005-3133-4358","https://orcid.org/0009-0008-4775-4236"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shengbo Ma","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100382568","display_name":"Bing Wang","orcid":"https://orcid.org/0000-0003-4945-7725","observed_orcids":["https://orcid.org/0000-0003-4945-7725","https://orcid.org/0009-0000-1018-6425","https://orcid.org/0009-0004-5152-6093"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bing Wang","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107951617","display_name":"Donghui Zhang","orcid":"https://orcid.org/0009-0005-2859-9363","observed_orcids":["https://orcid.org/0009-0005-2859-9363"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Donghui Zhang","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100764958","display_name":"Liu Tang","orcid":"https://orcid.org/0000-0002-0813-8229","observed_orcids":["https://orcid.org/0000-0002-0813-8229"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Liu Tang","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100453156","display_name":"Qi Liu","orcid":"https://orcid.org/0000-0001-6956-5550","observed_orcids":["https://orcid.org/0000-0001-6956-5550","https://orcid.org/0009-0001-7559-8989","https://orcid.org/0009-0005-2398-860X"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Qi Liu","raw_affiliation_strings":["Ping CAP"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ping CAP","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.6922,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.94687091,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":93,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"5429","last_page":"5432"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.4494999945163727,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.4494999945163727,"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/T10028","display_name":"Topic Modeling","score":0.1185000017285347,"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.08649999648332596,"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/exploratory-data-analysis","display_name":"exploratory data analysis","score":0.8629999756813049},{"id":"https://openalex.org/keywords/text-to-sql","display_name":"text-to-SQL","score":0.890999972820282},{"id":"https://openalex.org/keywords/large-language-models","display_name":"large language models","score":0.9739999771118164},{"id":"https://openalex.org/keywords/zero-shot-learning","display_name":"zero-shot learning","score":0.8659999966621399},{"id":"https://openalex.org/keywords/database-scalability","display_name":"database scalability","score":0.3179999887943268}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7321996688842773},{"id":"https://openalex.org/C2780813799","wikidata":"https://www.wikidata.org/wiki/Q3274237","display_name":"Zero (linguistics)","level":2,"score":0.6844170689582825},{"id":"https://openalex.org/C2778344882","wikidata":"https://www.wikidata.org/wiki/Q278938","display_name":"Shot (pellet)","level":2,"score":0.5598500967025757},{"id":"https://openalex.org/C2780518707","wikidata":"https://www.wikidata.org/wiki/Q685332","display_name":"Ground zero","level":2,"score":0.43347835540771484},{"id":"https://openalex.org/C120894424","wikidata":"https://www.wikidata.org/wiki/Q1322871","display_name":"Exploratory data analysis","level":2,"score":0.4191688895225525},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.3686354160308838},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3663700819015503},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.19924423098564148},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.09969297051429749},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.09674802422523499},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C185544564","wikidata":"https://www.wikidata.org/wiki/Q81197","display_name":"Nuclear physics","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde60146.2024.00420","doi":"https://doi.org/10.1109/icde60146.2024.00420","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde60146.2024.00420","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 40th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G1882485028","display_name":null,"funder_award_id":"U22B2020","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W3032467329","https://openalex.org/W4317716303","https://openalex.org/W4361019453","https://openalex.org/W4381326944","https://openalex.org/W4385270122","https://openalex.org/W4385270129","https://openalex.org/W7133224126"],"related_works":["https://openalex.org/W4414244629","https://openalex.org/W7156692195","https://openalex.org/W4417474175","https://openalex.org/W7160799630","https://openalex.org/W4411374346","https://openalex.org/W6968238761","https://openalex.org/W4404506291","https://openalex.org/W4417128654","https://openalex.org/W4415273867","https://openalex.org/W4411112295"],"abstract_inverted_index":{"Data":[0],"analysts":[1],"often":[2],"encounter":[3],"two":[4],"primary":[5],"challenges":[6],"while":[7],"conducting":[8],"exploratory":[9],"data":[10,63],"analysis":[11,64],"by":[12,105],"SQL:":[13],"(1)":[14],"the":[15,24,32,82,110,124,134,138,147],"need":[16],"to":[17,26,75,79,126,129],"skillfully":[18],"craft":[19],"SQL":[20,93,95],"queries,":[21],"and":[22,51,97,116,143,150,154],"(2)":[23],"requirement":[25],"generate":[27],"suitable":[28],"visualizations":[29],"that":[30,72],"enhance":[31],"interpretation":[33],"of":[34,39,109,137],"query":[35],"results.":[36],"The":[37],"emergence":[38],"large":[40],"language":[41],"models":[42],"(LLMs)":[43],"has":[44],"inaugurated":[45],"a":[46,69],"paradigm":[47],"shift":[48],"in":[49,146,156],"text-to-SQL":[50,91],"data-to-chart.":[52],"This":[53,118],"paper":[54],"presents":[55],"Chat2Query,":[56],"an":[57,88],"LLM":[58,89],"-empowered":[59,90],"zero-shot":[60],"automatic":[61],"exploration":[62],"system.":[65],"Firstly,":[66],"Chat2Query":[67,86,101,122,145],"provides":[68],"user-friendly":[70],"interface":[71],"allows":[73],"users":[74],"employ":[76],"natural":[77],"languages":[78],"interact":[80],"with":[81,123,133],"database":[83],"directly.":[84],"Secondly,":[85],"offers":[87],"generator,":[92],"rewriter,":[94],"formatter,":[96],"data-to-chart":[98],"generator.":[99],"Thirdly,":[100],"is":[102],"uniquely":[103],"distinguished":[104],"its":[106,152],"underlying":[107],"incorporation":[108],"TiDB":[111],"Serverless,":[112],"fostering":[113],"superior":[114],"elasticity":[115],"scalability.":[117],"strategic":[119],"integration":[120],"empowers":[121],"capability":[125],"seamlessly":[127],"adapt":[128],"change":[130],"workloads,":[131],"aligning":[132],"evolving":[135],"demands":[136],"user.":[139],"We":[140],"have":[141],"implemented":[142],"deployed":[144],"production":[148],"environment,":[149],"demonstrate":[151],"usability":[153],"efficiency":[155],"three":[157],"representative":[158],"real-world":[159],"scenarios.":[160]},"counts_by_year":[{"year":2026,"cited_by_count":5},{"year":2025,"cited_by_count":9},{"year":2024,"cited_by_count":2}],"updated_date":"2026-11-08T12:12:28.789561","created_date":"2024-07-24T00:00:00"}