{"id":"https://openalex.org/W4398234583","doi":"https://doi.org/10.1145/3626246.3653375","title":"FinSQL: Model-Agnostic LLMs-based Text-to-SQL Framework for Financial Analysis","display_name":"FinSQL: Model-Agnostic LLMs-based Text-to-SQL Framework for Financial Analysis","publication_year":2024,"publication_date":"2024-05-23","ids":{"openalex":"https://openalex.org/W4398234583","doi":"https://doi.org/10.1145/3626246.3653375"},"language":"en","primary_location":{"id":"doi:10.1145/3626246.3653375","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3626246.3653375","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2024 International Conference on Management of Data","raw_type":"proceedings-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/A5103202043","display_name":"Chao Zhang","orcid":"https://orcid.org/0009-0008-4098-3298"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Chao Zhang","raw_affiliation_strings":["Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038355914","display_name":"Yuren Mao","orcid":"https://orcid.org/0000-0003-0550-3072"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yuren Mao","raw_affiliation_strings":["Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051678313","display_name":"Yijiang Fan","orcid":"https://orcid.org/0009-0008-9895-9207"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yijiang Fan","raw_affiliation_strings":["Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102015079","display_name":"Yu Mi","orcid":"https://orcid.org/0009-0006-9406-1104"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yu Mi","raw_affiliation_strings":["Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006238145","display_name":"Yunjun Gao","orcid":"https://orcid.org/0000-0003-3816-8450"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yunjun Gao","raw_affiliation_strings":["Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100432093","display_name":"Lu Chen","orcid":"https://orcid.org/0000-0002-5685-7017"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lu Chen","raw_affiliation_strings":["Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030513587","display_name":"Dongfang Lou","orcid":"https://orcid.org/0009-0003-3467-6957"},"institutions":[{"id":"https://openalex.org/I4210119021","display_name":"Hundsun (China)","ror":"https://ror.org/02hwfmb37","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210119021"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Dongfang Lou","raw_affiliation_strings":["Hundsun Technologies INC., Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Hundsun Technologies INC., Hangzhou, China","institution_ids":["https://openalex.org/I4210119021"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034761093","display_name":"Jinshu Lin","orcid":"https://orcid.org/0009-0009-8580-0018"},"institutions":[{"id":"https://openalex.org/I4210119021","display_name":"Hundsun (China)","ror":"https://ror.org/02hwfmb37","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210119021"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jinshu Lin","raw_affiliation_strings":["Hundsun Technologies INC., Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Hundsun Technologies INC., Hangzhou, China","institution_ids":["https://openalex.org/I4210119021"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5103202043"],"corresponding_institution_ids":["https://openalex.org/I76130692"],"apc_list":null,"apc_paid":null,"fwci":16.5746,"has_fulltext":false,"cited_by_count":35,"citation_normalized_percentile":{"value":0.99317994,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"93","last_page":"105"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11326","display_name":"Stock Market Forecasting Methods","score":0.9799000024795532,"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/T11326","display_name":"Stock Market Forecasting Methods","score":0.9799000024795532,"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/T11653","display_name":"Financial Distress and Bankruptcy Prediction","score":0.9118000268936157,"subfield":{"id":"https://openalex.org/subfields/1402","display_name":"Accounting"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6759344339370728},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5635126233100891},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3682206869125366}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6759344339370728},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5635126233100891},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3682206869125366}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3626246.3653375","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3626246.3653375","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2024 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Decent work and economic growth","score":0.4099999964237213,"id":"https://metadata.un.org/sdg/8"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W2945102109","https://openalex.org/W2970641574","https://openalex.org/W3034835156","https://openalex.org/W3093517588","https://openalex.org/W3102020135","https://openalex.org/W4205991051","https://openalex.org/W4224308101","https://openalex.org/W4317716303","https://openalex.org/W6601926947","https://openalex.org/W6810081322"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052","https://openalex.org/W2382290278","https://openalex.org/W4395014643"],"abstract_inverted_index":{"Text-to-SQL,":[0],"which":[1],"provides":[2,115],"zero-code":[3],"interface":[4],"for":[5,36,81,102,119],"operating":[6],"relational":[7],"databases,":[8],"has":[9],"gained":[10],"much":[11],"attention":[12],"in":[13,23,51,152],"financial":[14,17,37,52,82,93,120],"analysis;":[15],"because":[16],"professionals":[18],"may":[19],"not":[20,44],"be":[21],"well-skilled":[22],"SQL":[24],"programming.":[25],"However,":[26],"until":[27],"now,":[28],"there":[29],"is":[30,88],"no":[31],"practical":[32,67,92],"Text-to-SQL":[33,41,68,79,112,121],"benchmark":[34,69,85],"dataset":[35,70],"analysis,":[38],"and":[39,71,105,130,145],"existing":[40,57],"methods":[42],"have":[43],"considered":[45],"the":[46,91,109,123],"unique":[47],"characteristics":[48],"of":[49,96,125],"databases":[50,101],"applications,":[53],"such":[54],"as":[55],"commonly":[56],"wide":[58],"tables.":[59],"To":[60],"address":[61],"these":[62],"issues,":[63],"we":[64],"collect":[65],"a":[66,73,116],"propose":[72],"model-agnostic":[74],"Large":[75],"Language":[76],"Model":[77],"(LLMs)-based":[78],"framework":[80],"analysis.":[83],"The":[84],"dataset,":[86],"BULL,":[87],"collected":[89],"from":[90,122],"analysis":[94],"business":[95],"Hundsun":[97],"Technologies":[98],"Inc.,":[99],"including":[100],"fund,":[103],"stock,":[104],"macro":[106],"economy.":[107],"Besides,":[108],"proposed":[110],"LLMs-based":[111],"framework,":[113],"FinSQL,":[114],"systematic":[117],"treatment":[118],"perspectives":[124],"prompt":[126],"construction,":[127],"parameter-efficient":[128],"fine-tuning":[129],"output":[131],"calibration.":[132],"Experiments":[133],"on":[134],"BULL":[135],"demonstrate":[136],"that":[137],"FinSQL":[138],"achieves":[139],"state-of-the-art":[140],"performance":[141],"at":[142],"low":[143],"cost,":[144],"it":[146],"brings":[147],"up":[148],"to":[149],"36.64%":[150],"improvement":[151],"few-shot":[153],"cross-database":[154],"scenarios.":[155]},"counts_by_year":[{"year":2026,"cited_by_count":9},{"year":2025,"cited_by_count":21},{"year":2024,"cited_by_count":5}],"updated_date":"2026-04-18T07:56:08.524223","created_date":"2025-10-10T00:00:00"}