{"id":"https://openalex.org/W7156692195","doi":"https://doi.org/10.1145/3788853.3801590","title":"TiInsight: A SQL-based Automated Exploratory Data Analysis System through Large Language Models","display_name":"TiInsight: A SQL-based Automated Exploratory Data Analysis System through Large Language Models","publication_year":2026,"publication_date":"2026-05-26","ids":{"openalex":"https://openalex.org/W7156692195","doi":"https://doi.org/10.1145/3788853.3801590"},"language":null,"primary_location":{"id":"doi:10.1145/3788853.3801590","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3801590","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3788853.3801590","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5114195823","display_name":"Jun-Peng Zhu","orcid":"https://orcid.org/0009-0006-9053-0129"},"institutions":[{"id":"https://openalex.org/I37802460","display_name":"Northwest University","ror":"https://ror.org/00z3td547","country_code":"CN","type":"education","lineage":["https://openalex.org/I37802460"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jun-Peng Zhu","raw_affiliation_strings":["Northwest A&F University, Shaanxi, China and PingCAP, Sh ang h, China"],"raw_orcid":"https://orcid.org/0009-0006-9053-0129","affiliations":[{"raw_affiliation_string":"Northwest A&F University, Shaanxi, China and PingCAP, Sh ang h, China","institution_ids":["https://openalex.org/I37802460"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105309751","display_name":"Boyan Niu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Boyan Niu","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0000-3242-6864","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134816140","display_name":"Peng Cai","orcid":null},"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, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0006-7468-7695","affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113300589","display_name":"Zheming Ni","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zheming Ni","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0005-9689-8162","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134779404","display_name":"Kai Xu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kai Xu","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0007-7876-5192","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134812948","display_name":"Jiajun Huang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jiajun Huang","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0000-8198-8388","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111513994","display_name":"Shengbo Ma","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shengbo Ma","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0005-3133-4358","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134785158","display_name":"Bing Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bing Wang","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0002-4133-769X","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134756105","display_name":"Xuan Zhou","orcid":null},"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":"Xuan Zhou","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0001-8426-9450","affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111390662","display_name":"Guangyu Bao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Guanglei Bao","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0008-5174-1622","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101882846","display_name":"Donghui Zhang","orcid":"https://orcid.org/0000-0002-9503-5809"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Donghui Zhang","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0004-0916-4949","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5134787108","display_name":"Liu Tang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Liu Tang","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0002-0008-8917","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5134773619","display_name":"Qi Liu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Qi Liu","raw_affiliation_strings":["PingCAP, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0008-6973-9205","affiliations":[{"raw_affiliation_string":"PingCAP, Shanghai, China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":13,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.64128656,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"158","last_page":"161"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.14409999549388885,"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.14409999549388885,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.10580000281333923,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/T13398","display_name":"Data Analysis with R","score":0.0754999965429306,"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.7182999849319458},{"id":"https://openalex.org/keywords/exploratory-analysis","display_name":"Exploratory analysis","score":0.6182000041007996},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5726000070571899},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.5602999925613403},{"id":"https://openalex.org/keywords/data-visualization","display_name":"Data visualization","score":0.4805000126361847},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.41290000081062317},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.3846000134944916},{"id":"https://openalex.org/keywords/visual-language","display_name":"Visual language","score":0.3785000145435333}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7926999926567078},{"id":"https://openalex.org/C120894424","wikidata":"https://www.wikidata.org/wiki/Q1322871","display_name":"Exploratory data analysis","level":2,"score":0.7182999849319458},{"id":"https://openalex.org/C3018260909","wikidata":"https://www.wikidata.org/wiki/Q1322871","display_name":"Exploratory analysis","level":2,"score":0.6182000041007996},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5726000070571899},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.5602999925613403},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.49219998717308044},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.4805000126361847},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.41290000081062317},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.3846000134944916},{"id":"https://openalex.org/C2780878386","wikidata":"https://www.wikidata.org/wiki/Q1659648","display_name":"Visual language","level":2,"score":0.3785000145435333},{"id":"https://openalex.org/C85973986","wikidata":"https://www.wikidata.org/wiki/Q1091731","display_name":"Exploratory research","level":2,"score":0.3684000074863434},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34369999170303345},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.34040001034736633},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.32839998602867126},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.32670000195503235},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.3244999945163727},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.29820001125335693},{"id":"https://openalex.org/C2780977526","wikidata":"https://www.wikidata.org/wiki/Q42417149","display_name":"Data exploration","level":3,"score":0.29260000586509705},{"id":"https://openalex.org/C183322885","wikidata":"https://www.wikidata.org/wiki/Q17007702","display_name":"Context model","level":3,"score":0.288100004196167},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2766000032424927},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.2700999975204468},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.2606000006198883},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.25699999928474426},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.25519999861717224},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.2524999976158142}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3788853.3801590","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3801590","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2601.09404","is_oa":true,"landing_page_url":"https://arxiv.org/abs/2601.09404","pdf_url":"https://arxiv.org/pdf/2601.09404","source":{"id":"https://openalex.org/S4393918464","display_name":"ArXiv.org","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"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":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/3788853.3801590","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3801590","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"The":[0,14],"SQL-based":[1,55],"exploratory":[2,58,83],"data":[3,11,30,59,72,84,88,101],"analysis":[4,12,60,85],"has":[5,21],"garnered":[6],"significant":[7],"attention":[8],"within":[9],"the":[10,23,37,43,113],"community.":[13],"emergence":[15],"of":[16,45,116],"large":[17],"language":[18,75],"models":[19],"(LLMs)":[20],"facilitated":[22],"paradigm":[24],"shift":[25],"from":[26],"manual":[27],"to":[28,70],"automated":[29,56],"exploration.":[31],"However,":[32],"existing":[33],"methods":[34],"generally":[35],"lack":[36],"ability":[38],"for":[39],"cross-domain":[40,57,82],"analysis,":[41],"and":[42,95,100,109,118],"exploration":[44],"LLMs":[46],"capabilities":[47,121],"remains":[48],"insufficient.":[49],"This":[50],"paper":[51],"presents":[52],"TiInsight,":[53],"a":[54,65,80],"system.":[61],"First,":[62],"TiInsight":[63,78,111],"offers":[64,79],"user-friendly":[66],"GUI":[67],"enabling":[68],"users":[69],"explore":[71],"using":[73,122],"natural":[74],"queries.":[76],"Second,":[77],"robust":[81],"pipeline:":[86],"hierarchical":[87],"context":[89],"(i.e.,":[90,98,103],"HDC)":[91],"generation,":[92],"question":[93],"clarification":[94],"decomposition,":[96],"text-to-SQL":[97],"TiSQL),":[99],"visualization":[102],"TiChart).":[104],"Third,":[105],"we":[106],"have":[107],"implemented":[108],"deployed":[110],"in":[112],"production":[114],"environment":[115],"PingCAP":[117],"demonstrated":[119],"its":[120],"representative":[123],"datasets.":[124]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-04-29T00:00:00"}