{"id":"https://openalex.org/W4411549650","doi":"https://doi.org/10.1145/3701716.3715541","title":"SQLord: A Robust Enterprise Text-to-SQL Solution via Reverse Data Generation and Workflow Decomposition","display_name":"SQLord: A Robust Enterprise Text-to-SQL Solution via Reverse Data Generation and Workflow Decomposition","publication_year":2025,"publication_date":"2025-05-08","ids":{"openalex":"https://openalex.org/W4411549650","doi":"https://doi.org/10.1145/3701716.3715541"},"language":"en","primary_location":{"id":"doi:10.1145/3701716.3715541","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3701716.3715541","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion Proceedings of the ACM on Web Conference 2025","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2507.10629","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5109524056","display_name":"Song Cheng","orcid":"https://orcid.org/0000-0002-7514-8654"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Song Cheng","raw_affiliation_strings":["Alibaba Group, Hangzhou, Zhejiang, China"],"raw_orcid":"https://orcid.org/0000-0002-7514-8654","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, Zhejiang, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113334759","display_name":"Qifen Cheng","orcid":null},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Qiannan Cheng","raw_affiliation_strings":["Alibaba Group, Hangzhou, Zhejiang, China"],"raw_orcid":"https://orcid.org/0009-0009-1327-1583","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, Zhejiang, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075971838","display_name":"Linbo Jin","orcid":"https://orcid.org/0000-0003-3201-2113"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Linbo Jin","raw_affiliation_strings":["Alibaba Group, Hangzhou, Zhejiang, China"],"raw_orcid":"https://orcid.org/0000-0003-3201-2113","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, Zhejiang, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5118595700","display_name":"Lei Yi","orcid":null},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lei Yi","raw_affiliation_strings":["Alibaba Group, Hangzhou, Zhejiang, China"],"raw_orcid":"https://orcid.org/0009-0002-7173-2658","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, Zhejiang, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5031338085","display_name":"Guannan Zhang","orcid":"https://orcid.org/0000-0002-7091-2318"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guannan Zhang","raw_affiliation_strings":["Alibaba Group, Hangzhou, Zhejiang, China"],"raw_orcid":"https://orcid.org/0000-0002-7091-2318","affiliations":[{"raw_affiliation_string":"Alibaba Group, Hangzhou, Zhejiang, China","institution_ids":["https://openalex.org/I45928872"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5109524056"],"corresponding_institution_ids":["https://openalex.org/I45928872"],"apc_list":null,"apc_paid":null,"fwci":1.3517,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.82864365,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"919","last_page":"923"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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.9955999851226807,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9922999739646912,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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.7470769882202148},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.709941029548645},{"id":"https://openalex.org/keywords/workflow","display_name":"Workflow","score":0.6870719194412231},{"id":"https://openalex.org/keywords/decomposition","display_name":"Decomposition","score":0.6440779566764832},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4732387959957123},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3304100036621094},{"id":"https://openalex.org/keywords/chemistry","display_name":"Chemistry","score":0.07365906238555908}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7470769882202148},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.709941029548645},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.6870719194412231},{"id":"https://openalex.org/C124681953","wikidata":"https://www.wikidata.org/wiki/Q339062","display_name":"Decomposition","level":2,"score":0.6440779566764832},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4732387959957123},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3304100036621094},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.07365906238555908},{"id":"https://openalex.org/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3701716.3715541","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3701716.3715541","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion Proceedings of the ACM on Web Conference 2025","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2507.10629","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2507.10629","pdf_url":"https://arxiv.org/pdf/2507.10629","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":"pmh:oai:arXiv.org:2507.10629","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2507.10629","pdf_url":"https://arxiv.org/pdf/2507.10629","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"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W3034835156","https://openalex.org/W3122241445","https://openalex.org/W4285244831","https://openalex.org/W4312537169","https://openalex.org/W4327810158","https://openalex.org/W4382202531","https://openalex.org/W4382202695","https://openalex.org/W4389523875","https://openalex.org/W4396571402"],"related_works":["https://openalex.org/W1981780420","https://openalex.org/W2182707996","https://openalex.org/W45233828","https://openalex.org/W2964988449","https://openalex.org/W2397952901","https://openalex.org/W2029380707","https://openalex.org/W188202134","https://openalex.org/W4255934811","https://openalex.org/W2465382974","https://openalex.org/W4320802139"],"abstract_inverted_index":{"Transforming":[0],"natural":[1],"language":[2],"into":[3,71],"SQL":[4,69],"queries":[5,86],"(NL2SQL)":[6],"is":[7],"crucial":[8],"for":[9,28,74,84],"data-driven":[10],"business":[11,22],"applications.":[12],"Existing":[13],"frameworks,":[14],"trained":[15],"on":[16,144],"open-source":[17],"datasets,":[18],"struggle":[19],"with":[20],"complex":[21,85,133],"logic":[23],"and":[24,37,107,121,130],"lack":[25],"domain-specific":[26],"data":[27,36,62,73],"fine-tuning.":[29],"Additionally,":[30,92],"evaluation":[31,98],"methods":[32],"often":[33],"require":[34],"annotated":[35,72],"executable":[38],"database":[39],"environments,":[40],"which":[41],"are":[42],"scarce":[43],"in":[44,132],"real-world":[45,134],"scenarios.":[46,114,135],"To":[47],"address":[48],"these":[49],"challenges,":[50],"we":[51],"propose":[52],"SQLord,":[53],"an":[54,88],"enterprise-level":[55],"NL2SQL":[56],"framework.":[57],"First,":[58],"SQLord":[59,93,136],"introduces":[60],"a":[61,81,95],"reverse":[63],"generation":[64],"approach":[65],"to":[66,112],"convert":[67],"raw":[68],"statements":[70],"supervised":[75],"fine-tuning":[76],"(SFT).":[77],"Second,":[78],"it":[79],"proposes":[80],"decomposition":[82],"method":[83],"using":[87],"automated":[89],"workflow":[90],"generator.":[91],"features":[94],"comprehensive":[96],"GPT-Judge":[97],"framework,":[99],"including":[100],"Execution":[101],"Evaluation":[102,105,109],"(EXE),":[103],"Query-SQL":[104],"(QSE),":[106],"SQL-SQL":[108],"(SSE),":[110],"tailored":[111],"diverse":[113],"Offline":[115],"tests":[116],"significantly":[117],"outperform":[118],"state-of-the-art":[119],"baselines,":[120],"online":[122],"accuracy":[123],"consistently":[124],"exceeds":[125],"90,":[126],"highlighting":[127],"SQLord's":[128],"advantages":[129],"effectiveness":[131],"has":[137],"been":[138],"successfully":[139],"applied":[140],"across":[141],"multiple":[142],"scenarios":[143],"the":[145],"world's":[146],"largest":[147],"B2B":[148],"e-commerce":[149],"platform.":[150]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}