Article(id=1329419612044767459, tenantId=1146029695717560320, journalId=1324759914146529478, issueId=1329419577676641015, articleNumber=null, orderNo=null, doi=10.7544/issn1000-1239.202550355, pmid=null, cstr=null, oa=null, hot=null, price=null, onlineType=0, articleFormat=0, articleType=null, articleTypeStr=null, receivedDate=1748188800000, receivedDateStr=2025-05-26, revisedDate=1765123200000, revisedDateStr=2025-12-08, acceptedDate=1767715200000, acceptedDateStr=2026-01-07, onlineDate=1794887934933, onlineDateStr=2026-11-17, pubDate=1777564800000, pubDateStr=2026-05-01, doiRegisterDate=null, doiRegisterDateStr=null, onlineIssueDate=1794887934933, onlineIssueDateStr=2026-11-17, onlineJustAcceptDate=null, onlineJustAcceptDateStr=null, onlineFirstDate=null, onlineFirstDateStr=null, sourceXml=null, magXml=null, createTime=1794887934933, creator=13701087609, updateTime=1794887934933, updator=13701087609, issue=Issue{id=1329419577676641015, tenantId=1146029695717560320, journalId=1324759914146529478, year='2026', volume='63', issue='5', pageStart='1095', pageEnd='1375', issueExtLink='null', onlineDate='null', pubDate='1777564800000', pubDateStr='2026-05-01', beforeIssueId=null, nextIssueId=null, price=null, status=1, issueComplete=1, articleOrder=1, issueType=-1, specialIssue=null, createTime=1794887926739, creator='13701087609', updateTime=1794887926739, updator='13701087609', preIssue=null, nextIssue=null, articleTotal=null, ext=null, issueFiles=null, downloadFileDto=null}, startPage=1261, endPage=1272, ext={EN=ArticleExt(id=1329419612208345316, articleId=1329419612044767459, tenantId=1146029695717560320, journalId=1324759914146529478, language=EN, title=Iterative Two-Stage Schema-Enhanced SQL Generation with Large Language Models, columnId=1325489891789910943, journalTitle=Journal of Computer Research and Development, columnName=Artificial Intelligence, runingTitle=null, highlight=null, articleAbstract=
With the advent of the big data era, various enterprises and organizations have accumulated massive amounts of data driven by the growing demands for business expansion and information. This data are typically stored in relational databases in structured or semi-structured formats. SQL, as a structured database query language, has long been widely used for data retrieval and processing. It provides professionals with an efficient way to interact with databases, thereby facilitating quicker and more convenient data sharing and analysis. With the exponential advancement of large language models (LLMs), in-context learning (ICL) has shown significant promise for the text-to-SQL task, where LLMs utilize reference examples to accurately generate SQL queries. To fully harness the potential of LLMs through ICL for text-to-SQL, we propose a new SQL generation pipeline comprising three parts: first, we propose a schema enhancement component to strengthen LLMs’ focus on question-related information. Second, we leverage the inherent structure of SQL to preselect semantically similar, aiding in the generation of initial pseudo-SQL queries. Third, a selection strategy is proposed for selecting reference examples, which considers the similarities between the question and the pseudo-SQL structure to enhance the accuracy of the generated SQL queries. We implement an iterative refinement process in both stages, employing a boosting-like mechanism that progressively improves selection until stabilization is achieved. Extensive experiments across various models and datasets demonstrate the effectiveness of our approach.
, authors=Wei Zhang
1, 2, Dong’ao Zhou
3, *, Yongshun Gong
1, Yilong Yin
1, authorsList=Wei Zhang, Dong’ao Zhou, Yongshun Gong, Yilong Yin, authorCompany=null, correspAuthors=Dong’ao Zhou, authorNote=
born in 1999. Master. His main research interests include natural language processing and data mining
born in 1990. PhD, assistant researcher. His main research interests include artificial intelligence and signal detection
born in 1990. PhD, professor. His main research interests include data mining and machine learning
born in 1972. PhD, professor. His main research interests include data mining and machine learning
, correspAuthorsNote=null, copyrightStatement=Copyright © 2026 Journal of Computer Research and Development. All rights reserved., copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=null, magXml=null, pdfUrl=null, pdf=null, pdfFileSize=null, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=null, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=null, mapNumber=null, fund=null), CN=ArticleExt(id=1329419614074810617, articleId=1329419612044767459, tenantId=1146029695717560320, journalId=1324759914146529478, language=CN, title=基于大语言模型的2阶段迭代模式增强SQL生成, columnId=1325489892104483745, journalTitle=计算机研究与发展, columnName=人工智能, runingTitle=null, highlight=null, articleAbstract=
随着大数据时代的到来,各种企业和组织在日益增长的业务拓展以及信息需求的推动下积累了海量的数据。这些数据通常以结构化或半结构化的形式存储在对应的关系型数据库中。SQL作为一种结构化的数据库查询语言,长期以来被广泛应用于数据的检索和处理。它为相关专业技术人员提供了一种高效的方式来与数据库进行交互,从而能够更快捷方便地实现对于数据的分析。随着大语言模型(large language models,LLMs)的快速发展,上下文学习(in-context learning,ICL)在文本生成SQL(text-to-SQL)任务中展现出巨大潜力。ICL能够使大语言模型通过利用参考示例生成准确的SQL查询。为了充分利用大语言模型在ICL机制下进行文本生成SQL,提出了一个新的SQL生成流程,该流程包括3个部分:首先,提出了迭代式的模式增强,以强化大语言模型对解决问题相关信息的关注。其次,利用SQL的骨架结构进行语义相似度筛选,从而辅助生成伪SQL(pseudo-SQL)查询。最后设计了一种参考示例选择策略,该策略结合问题与伪SQL骨架之间的相似性,以提高生成SQL查询的准确性。同时,在2个关键阶段中都引入了迭代优化过程,以逐步优化示例选择策略,直至达到稳定状态。在多个大语言模型和数据集上进行了广泛的实验,验证了所提出方法的有效性。
, authors=张伟
1, 2, 周东傲
3, *, 宫永顺
1, 尹义龙
1, authorsList=张伟, 周东傲, 宫永顺, 尹义龙, authorCompany=null, correspAuthors=周东傲, authorNote=
作者贡献声明
张伟提出算法思路,完成实验并撰写论文;周东傲、宫永顺和尹义龙提出指导意见并修改论文。
 |
1999年生。硕士。主要研究方向为自然语言处理、数据挖掘 |
 |
1990年生。博士,助理研究员。主要研究方向为人工智能、信号检测 |
 |
1990年生。博士,教授。主要研究方向为数据挖掘、机器学习 |
 |
1972年生。博士,教授。主要研究方向为数据挖掘、机器学习 |
, correspAuthorsNote=
, copyrightStatement=版权所有 © 2026 计算机研究与发展编辑部, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=3c04soLeaCgqnkk/ODD4IA==, magXml=qkyUOi1ubFAsp3Z5JOZKkA==, pdfUrl=null, pdf=WOe6DbSo7JBcqpRg4zrdBw==, pdfFileSize=1304299, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=Ef834vNg5J2Wz1PC3IALBA==, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=yJI0jk/UVoGoend9oM7wbQ==, mapNumber=null, fund=null)}, authors=[Author(id=1329419614565544196, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, orderNo=0, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=zhangwei4@sd.chinamobile.com, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1329419614657818887, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, authorId=1329419614565544196, language=EN, stringName=Wei Zhang, firstName=Wei, middleName=null, lastName=Zhang, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, 2, address=
1School of Software, Shandong University, Jinan 250101
2China Mobile Qilu Innovation Research Institute, Jinan 250102, bio={"content":"
born in 1999. Master. His main research interests include natural language processing and data mining
"}, bioImg=null, bioContent=
born in 1999. Master. His main research interests include natural language processing and data mining
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329419614720733448, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, authorId=1329419614565544196, language=CN, stringName=张伟, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, 2, address=
1山东大学软件学院 济南 250101
2中国移动通信集团山东有限公司中移齐鲁创新院分公司 济南 250102, bio={"img":"PEnX18KgBht6ogdNGHHAXw==","content":"
1999年生。硕士。主要研究方向为自然语言处理、数据挖掘
"}, bioImg=PEnX18KgBht6ogdNGHHAXw==, bioContent=
1999年生。硕士。主要研究方向为自然语言处理、数据挖掘
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329419614305497338, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, xref=1, ext=[AuthorCompanyExt(id=1329419614313885947, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614305497338, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Software, Shandong University, Jinan 250101), AuthorCompanyExt(id=1329419614322274556, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614305497338, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1山东大学软件学院 济南 250101)]), AuthorCompany(id=1329419614385189117, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, xref=2, ext=[AuthorCompanyExt(id=1329419614389383422, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614385189117, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2China Mobile Qilu Innovation Research Institute, Jinan 250102), AuthorCompanyExt(id=1329419614397772031, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614385189117, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2中国移动通信集团山东有限公司中移齐鲁创新院分公司 济南 250102)])]), Author(id=1329419614783648010, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, orderNo=1, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=zhoudongao08@nudt.edu.cn, emailSecond=null, emailThird=null, correspondingAuthor=1, authorType=1, ext={EN=AuthorExt(id=1329419614859145484, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, authorId=1329419614783648010, language=EN, stringName=Dong’ao Zhou, firstName=Dong’ao, middleName=null, lastName=Zhou, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
3, *, address=
3Academy of Military Science, Beijing 100080, bio={"content":"
born in 1990. PhD, assistant researcher. His main research interests include artificial intelligence and signal detection
"}, bioImg=null, bioContent=
born in 1990. PhD, assistant researcher. His main research interests include artificial intelligence and signal detection
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329419614922060045, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, authorId=1329419614783648010, language=CN, stringName=周东傲, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
3, *, address=
3中国人民解放军军事科学院 北京 100080, bio={"img":"VhpXexrwzLxereaXqBccsg==","content":"
1990年生。博士,助理研究员。主要研究方向为人工智能、信号检测
"}, bioImg=VhpXexrwzLxereaXqBccsg==, bioContent=
1990年生。博士,助理研究员。主要研究方向为人工智能、信号检测
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329419614473269504, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, xref=3, ext=[AuthorCompanyExt(id=1329419614481658113, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614473269504, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
3Academy of Military Science, Beijing 100080), AuthorCompanyExt(id=1329419614490046722, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614473269504, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
3中国人民解放军军事科学院 北京 100080)])]), Author(id=1329419614984974607, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, orderNo=2, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1329419615064666385, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, authorId=1329419614984974607, language=EN, stringName=Yongshun Gong, firstName=Yongshun, middleName=null, lastName=Gong, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, address=
1School of Software, Shandong University, Jinan 250101, bio={"content":"
born in 1990. PhD, professor. His main research interests include data mining and machine learning
"}, bioImg=null, bioContent=
born in 1990. PhD, professor. His main research interests include data mining and machine learning
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329419615123386642, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, authorId=1329419614984974607, language=CN, stringName=宫永顺, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, address=
1山东大学软件学院 济南 250101, bio={"img":"MQvEkN30J0ZDEzIMZcZiDA==","content":"
1990年生。博士,教授。主要研究方向为数据挖掘、机器学习
"}, bioImg=MQvEkN30J0ZDEzIMZcZiDA==, bioContent=
1990年生。博士,教授。主要研究方向为数据挖掘、机器学习
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329419614305497338, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, xref=1, ext=[AuthorCompanyExt(id=1329419614313885947, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614305497338, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Software, Shandong University, Jinan 250101), AuthorCompanyExt(id=1329419614322274556, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614305497338, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1山东大学软件学院 济南 250101)])]), Author(id=1329419615190495508, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, orderNo=3, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1329419615261798678, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, authorId=1329419615190495508, language=EN, stringName=Yilong Yin, firstName=Yilong, middleName=null, lastName=Yin, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, address=
1School of Software, Shandong University, Jinan 250101, bio={"content":"
born in 1972. PhD, professor. His main research interests include data mining and machine learning
"}, bioImg=null, bioContent=
born in 1972. PhD, professor. His main research interests include data mining and machine learning
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329419615328907543, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, authorId=1329419615190495508, language=CN, stringName=尹义龙, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, address=
1山东大学软件学院 济南 250101, bio={"img":"KmhdD0sUuGObKb4/nl8Rgw==","content":"
1972年生。博士,教授。主要研究方向为数据挖掘、机器学习
"}, bioImg=KmhdD0sUuGObKb4/nl8Rgw==, bioContent=
1972年生。博士,教授。主要研究方向为数据挖掘、机器学习
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329419614305497338, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, xref=1, ext=[AuthorCompanyExt(id=1329419614313885947, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614305497338, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Software, Shandong University, Jinan 250101), AuthorCompanyExt(id=1329419614322274556, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614305497338, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1山东大学软件学院 济南 250101)])])], keywords=[Keyword(id=1329419615421182232, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, orderNo=1, keyword=large language models), Keyword(id=1329419615492485401, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, orderNo=2, keyword=text-to-SQL), Keyword(id=1329419615567982874, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, orderNo=3, keyword=in-context learning), Keyword(id=1329419615635091739, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, orderNo=4, keyword=database management), Keyword(id=1329419615698006300, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, orderNo=5, keyword=data analysis), Keyword(id=1329419615756726557, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, orderNo=1, keyword=大语言模型), Keyword(id=1329419615815446814, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, orderNo=2, keyword=文本生成SQL), Keyword(id=1329419615874167071, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, orderNo=3, keyword=上下文学习), Keyword(id=1329419615941275936, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, orderNo=4, keyword=数据库管理), Keyword(id=1329419616008384801, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, orderNo=5, keyword=数据分析)], refs=[Reference(id=1329419618105536827, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=1, rfOrder=0, authorNames=null, journalName=null, refType=null, unstructuredReference=Labrinidis A, Jagadish H V. Challenges and opportunities with big data[J]. Proceedings of the VLDB Endowment, 2012, 5(12): 2032−2033, articleTitle=null, refAbstract=null), Reference(id=1329419618172645692, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=2, rfOrder=1, authorNames=null, journalName=null, refType=null, unstructuredReference=潘青峰, 徐辰. 基于查询编译的SQL执行技术研究进展[J]. 计算机研究与发展, 2024, 61(7): 1754−1770, articleTitle=null, refAbstract=null), Reference(id=1329419618243948861, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=2, rfOrder=2, authorNames=null, journalName=null, refType=null, unstructuredReference=Pan Qingfeng, Xu Chen. Advances in SQL execution techniques based on query compilation[J]. Journal of Computer Research and Development, 2024, 61(7): 1754−1770 (in Chinese), articleTitle=null, refAbstract=null), Reference(id=1329419618302669118, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=3, rfOrder=3, authorNames=null, journalName=null, refType=null, unstructuredReference=Agarwal S, Mozafari B, Panda A, et al. BlinkDB: Queries with bounded errors and bounded response times on very large data[C]//Proc of the 8th ACM European Conf on Computer Systems. New York: ACM, 2013: 29−42, articleTitle=null, refAbstract=null), Reference(id=1329419618365583679, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=4, rfOrder=4, authorNames=null, journalName=null, refType=null, unstructuredReference=Deng Naihao, Chen Yulong, Zhang Yue. Recent advances in text-to-SQL: A survey of what we have and what we expect[C]//Proc of the 29th Int Conf on Computational Linguistics. Stroudsburg, PA: ACL, 2022: 2166−2187, articleTitle=null, refAbstract=null), Reference(id=1329419618462052672, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=5, rfOrder=5, authorNames=null, journalName=null, refType=null, unstructuredReference=Katsogiannis-Meimarakis G, Koutrika G. A survey on deep learning approaches for text-to-SQL[J]. The VLDB Journal, 2023, 32(4): 905−936, articleTitle=null, refAbstract=null), Reference(id=1329419618545938753, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=6, rfOrder=6, authorNames=null, journalName=null, refType=null, unstructuredReference=Khot T, Trivedi H, Finlayson M, et al. Decomposed prompting: A modular approach for solving complex tasks[J]. arXiv preprint, arXiv: 2210.02406, 2022, articleTitle=null, refAbstract=null), Reference(id=1329419618663379266, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=7, rfOrder=7, authorNames=null, journalName=null, refType=null, unstructuredReference=Chowdhery A, Narang S, Devlin J, et al. Palm: Scaling language modeling with pathways[J]. Journal of Machine Learning Research, 2023, 24(240): 1−113, articleTitle=null, refAbstract=null), Reference(id=1329419618722099523, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=8, rfOrder=8, authorNames=null, journalName=null, refType=null, unstructuredReference=Yu Tao, Zhang Rui, Yang Kai, et al. Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-SQL task[C]// Proc of the 27th Conf on Empirical Methods in Natural Language Processing. Stroudsburg, PA: ACL, 2018: 3911−3921, articleTitle=null, refAbstract=null), Reference(id=1329419618785014084, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=9, rfOrder=9, authorNames=null, journalName=null, refType=null, unstructuredReference=Josh A, Steven A, Sandhini A, et al. GPT-4 technical report[J]. arXiv preprint, arXiv: 2303.08774, 2024, articleTitle=null, refAbstract=null), Reference(id=1329419618856317253, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=10, rfOrder=10, authorNames=null, journalName=null, refType=null, unstructuredReference=Qu Ge, Li Jinyang, Li Bowen, et al. Before generation, align it! A novel and effective strategy for mitigating hallucinations in text-to-SQL generation[J]. arXiv preprint, arXiv: 2405.15307, 2024, articleTitle=null, refAbstract=null), Reference(id=1329419618923426118, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=11, rfOrder=11, authorNames=null, journalName=null, refType=null, unstructuredReference=Parciak M, Vandevoort B, Neven F, et al. Schema matching with large language models: An experimental study[J]. arXiv preprint, arXiv: 2307.07306, 2023, articleTitle=null, refAbstract=null), Reference(id=1329419618986340679, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=12, rfOrder=12, authorNames=null, journalName=null, refType=null, unstructuredReference=Dong Qingxiu, Li Lei, Dai Damai, et al. A survey on in-context learning[C]//Proc of the 29th Conf on Empirical Methods in Natural Language Processing. Stroudsburg, PA : ACL, 2024: 1107−1128, articleTitle=null, refAbstract=null), Reference(id=1329419619053449544, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=13, rfOrder=13, authorNames=null, journalName=null, refType=null, unstructuredReference=Liu Jiachang, Shen Dinghan, Zhang Yizhe, et al. What makes good in-context examples for GPT-3? [J]. arXiv preprint, arXiv: 2101.06804, 2021, articleTitle=null, refAbstract=null), Reference(id=1329419619116364105, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=14, rfOrder=14, authorNames=null, journalName=null, refType=null, unstructuredReference=Wang Liang, Yang Nan, Wei Furu. Learning to retrieve in-context examples for large language models[C]//Proc of the 18th Conf of the European Chapter of the Association for Computational Linguistics. Stroudsburg, PA : ACL, 2024: 1752−1767, articleTitle=null, refAbstract=null), Reference(id=1329419619187667274, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=15, rfOrder=15, authorNames=null, journalName=null, refType=null, unstructuredReference=Nguyen T, Wong E. In-context example selection with influences[J]. arXiv preprint, arXiv: 2302.11042, 2023, articleTitle=null, refAbstract=null), Reference(id=1329419619263164747, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=16, rfOrder=16, authorNames=null, journalName=null, refType=null, unstructuredReference=Radford A, Narasimhan K, Salimans T, et al. Improving language understanding by generative pre-training[EB/OL]. 2018[2025-03-02]. https://cdn.openai.com/research-covers/language-unsupervised/language_understanding_paper.pdf, articleTitle=null, refAbstract=null), Reference(id=1329419619330273612, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=17, rfOrder=17, authorNames=null, journalName=null, refType=null, unstructuredReference=Anil R, Borgeaud S, Alayrac J, et al. Gemini: A family of highly capable multimodal models[J]. arXiv preprint, arXiv: 2312.11805, 2025, articleTitle=null, refAbstract=null), Reference(id=1329419619405771085, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=18, rfOrder=18, authorNames=null, journalName=null, refType=null, unstructuredReference=Touvron H, Lavril T, Izacard G, et al. LLaMA: Open and efficient foundation language models[J]. arXiv preprint, arXiv: 2302.13971, 2023, articleTitle=null, refAbstract=null), Reference(id=1329419619472879950, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=19, rfOrder=19, authorNames=null, journalName=null, refType=null, unstructuredReference=Bi Xiao, Chen Deli, Chen Guanting, et al. DeepSeek LLM: Scaling open-source language models with long termism[J]. arXiv preprint, arXiv: 2401.02954, 2024, articleTitle=null, refAbstract=null), Reference(id=1329419619556766031, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=20, rfOrder=20, authorNames=null, journalName=null, refType=null, unstructuredReference=Radford A, Wu J, Child R, et al. Language models are unsupervised multitask learners[EB/OL]. 2019[2024-04-23]. https://cdn.openai.com/better-language-models/language_models_are_unsupervised_multitask_learners.pdf, articleTitle=null, refAbstract=null), Reference(id=1329419619636457808, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=21, rfOrder=21, authorNames=null, journalName=null, refType=null, unstructuredReference=Pourreza M, Rafiei D. DIN-SQL: Decomposed in-context learning of text-to-SQL with self-correction[C]// Proc of the 37th Int Conf on Neural Information Processing Systems. New York: ACM, 2023: 36339−36348, articleTitle=null, refAbstract=null), Reference(id=1329419619707760977, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=22, rfOrder=22, authorNames=null, journalName=null, refType=null, unstructuredReference=Gao Dawei, Wang Haibin, Li Yaliang, et al. Text-to-SQL empowered by large language models: A benchmark evaluation[J]. Proceedings of the VLDB Endowment, 2024, 17(5): 1132−1145, articleTitle=null, refAbstract=null), Reference(id=1329419619787452754, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=23, rfOrder=23, authorNames=null, journalName=null, refType=null, unstructuredReference=Dong Xuemei, Zhang Chao, Ge Yuhang, et al. C3: Zero-shot text-to-SQL with ChatGPT[J]. arXiv preprint, arXiv: 2307.07306, 2023, articleTitle=null, refAbstract=null), Reference(id=1329419619862950227, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=24, rfOrder=24, authorNames=null, journalName=null, refType=null, unstructuredReference=Wang Bing, Ren Changyu, Yang Jian, et al. MAC-SQL: A multi-agent collaborative framework for text-to-SQL[C]//Proc of the 32nd Int Conf on Computational Linguistics. Stroudsburg, PA : ACL, 2025: 540−557, articleTitle=null, refAbstract=null), Reference(id=1329419619934253396, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=25, rfOrder=25, authorNames=null, journalName=null, refType=null, unstructuredReference=Maamari K, Abubaker F, Jaroslawicz D, et al. The death of schema linking? Text-to-SQL in the age of well-reasoned language models[C]//Proc of the 38th Advances in Neural Information Processing Systems. New York: ACM, 2024: 1−10, articleTitle=null, refAbstract=null), Reference(id=1329419620001362261, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=26, rfOrder=26, authorNames=null, journalName=null, refType=null, unstructuredReference=Hasan A C, Özgür U. E-SQL: Direct schema linking via question enrichment in text-to-SQL[J]. arXiv preprint, arXiv: 2409.16751, 2025, articleTitle=null, refAbstract=null), Reference(id=1329419620072665430, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=27, rfOrder=27, authorNames=null, journalName=null, refType=null, unstructuredReference=Li Haoyang, Zhang Jing, Liu Hanbing, et al. Codes: Towards building open-source language models for text-to-sSQL[J]. Proceedings of the ACM on Management of Data, 2024, 2(3): 1−28, articleTitle=null, refAbstract=null), Reference(id=1329419620152357207, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=28, rfOrder=28, authorNames=null, journalName=null, refType=null, unstructuredReference=Peter F B, Vincent P J D, Peter V D, et al. Class-based n-gram models of natural language[J]. Computational Linguistics, 1992, 18(4): 467−480, articleTitle=null, refAbstract=null), Reference(id=1329419620236243288, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=29, rfOrder=29, authorNames=null, journalName=null, refType=null, unstructuredReference=Li Zehan, Zhang Xin, Zhang Yanzhao, et al. Towards general text embeddings with multi-stage contrastive learning[J]. arXiv preprint, arXiv: 2308.03281, 2023, articleTitle=null, refAbstract=null), Reference(id=1329419620303352153, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=30, rfOrder=30, authorNames=null, journalName=null, refType=null, unstructuredReference=Alomari Z, Halimi O E, Sivaprasad K, et al. Comparative studies of six programming languages[J]. arXiv preprint, arXiv: 1504.00693, 2015, articleTitle=null, refAbstract=null), Reference(id=1329419620374655322, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=31, rfOrder=31, authorNames=null, journalName=null, refType=null, unstructuredReference=Li Jinyang, Hui Binyuan, Qu Ge, et al. Can LLM already serve as a database interface? A big bench for large-scale database grounded text-to-SQLs[C]//Proc of the 37th Int Conf on Neural Information Processing Systems. New York: ACM, 2024: 42330−42357, articleTitle=null, refAbstract=null)], funds=null, companyList=[AuthorCompany(id=1329419614305497338, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, xref=1, ext=[AuthorCompanyExt(id=1329419614313885947, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614305497338, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Software, Shandong University, Jinan 250101), AuthorCompanyExt(id=1329419614322274556, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614305497338, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1山东大学软件学院 济南 250101)]), AuthorCompany(id=1329419614385189117, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, xref=2, ext=[AuthorCompanyExt(id=1329419614389383422, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614385189117, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2China Mobile Qilu Innovation Research Institute, Jinan 250102), AuthorCompanyExt(id=1329419614397772031, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614385189117, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2中国移动通信集团山东有限公司中移齐鲁创新院分公司 济南 250102)]), AuthorCompany(id=1329419614473269504, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, xref=3, ext=[AuthorCompanyExt(id=1329419614481658113, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614473269504, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
3Academy of Military Science, Beijing 100080), AuthorCompanyExt(id=1329419614490046722, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, companyId=1329419614473269504, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
3中国人民解放军军事科学院 北京 100080)])], figs=[ArticleFig(id=1329419616113242402, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Figure 1, caption=
Database schema enhancement, figureFileSmall=TIdh/wDi/X7qeZ06H7R+vw==, figureFileBig=Ef834vNg5J2Wz1PC3IALBA==, tableContent=null), ArticleFig(id=1329419616180351267, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=图1, caption=
数据库模式增强, figureFileSmall=TIdh/wDi/X7qeZ06H7R+vw==, figureFileBig=Ef834vNg5J2Wz1PC3IALBA==, tableContent=null), ArticleFig(id=1329419616377483556, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Figure 2, caption=
Filtration mode deletes key information by mistake, resulting in wrong results, figureFileSmall=zsx/I/Zq2A998fqDjRkMjg==, figureFileBig=EXwznl581s3yDN7AQKvckg==, tableContent=null), ArticleFig(id=1329419616440398117, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=图2, caption=
模式过滤误删关键信息导致错误结果, figureFileSmall=zsx/I/Zq2A998fqDjRkMjg==, figureFileBig=EXwznl581s3yDN7AQKvckg==, tableContent=null), ArticleFig(id=1329419616528478502, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Figure 3, caption=
Misleading example prompt, figureFileSmall=JAdMLG+0arQQTtawhDTuyQ==, figureFileBig=P9zzRpJL++D+CPgsgNihwg==, tableContent=null), ArticleFig(id=1329419616603975975, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=图3, caption=
误导性的示例提示, figureFileSmall=JAdMLG+0arQQTtawhDTuyQ==, figureFileBig=P9zzRpJL++D+CPgsgNihwg==, tableContent=null), ArticleFig(id=1329419616692056360, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Figure 4, caption=
Flowchart of ITS-SQL, figureFileSmall=9k9ZVSbkDESO/xf67qYfMQ==, figureFileBig=dqzo+6UZkIQHcEmeV6Vo3g==, tableContent=null), ArticleFig(id=1329419616759165225, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=图4, caption=
ITS-SQL 流程图, figureFileSmall=9k9ZVSbkDESO/xf67qYfMQ==, figureFileBig=dqzo+6UZkIQHcEmeV6Vo3g==, tableContent=null), ArticleFig(id=1329419616830468394, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Figure 5, caption=
Improving performance on different difficulty levels of BIRD dataset, figureFileSmall=NTwt+h6URpp8FuXtd4RQnQ==, figureFileBig=QgHMOfTy+WeHMIEqSfqSOw==, tableContent=null), ArticleFig(id=1329419616952103211, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=图5, caption=
在BIRD数据集不同难度部分的性能改进, figureFileSmall=NTwt+h6URpp8FuXtd4RQnQ==, figureFileBig=QgHMOfTy+WeHMIEqSfqSOw==, tableContent=null), ArticleFig(id=1329419617048572204, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Figure 6, caption=
Detailed case study, figureFileSmall=e7g/iCpd03RxNQoAVv0Kag==, figureFileBig=lErW2qmTbthBG9V9Lnje0w==, tableContent=null), ArticleFig(id=1329419617124069677, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=图6, caption=
详细案例研究, figureFileSmall=e7g/iCpd03RxNQoAVv0Kag==, figureFileBig=lErW2qmTbthBG9V9Lnje0w==, tableContent=null), ArticleFig(id=1329419617191178542, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Table 1, caption=
Execution Accuracy of Large Language Models on Spider-dev Dataset Under Different Few-Shot Example Selections %
, figureFileSmall=null, figureFileBig=null, tableContent=
| 样本数量 | 样本选择策略 | CodeLlama | DeepSeek | DeepSeek-V2 | Qwen2.5 | Llama3 | Qwen2 | DeepSeek-V3 |
|---|
| 0-shot | | 71.0 | 72.6 | 75.0 | 83.0 | 75.5 | 79.2 | 78.6 |
| 1-shot | 随机 | 69.5 | 74.2 | 75.0 | 85.0 | 78.0 | 81.8 | 80.4 |
| 问题语义相似度 | 69.4 | 75.6 | 76.2 | 84.8 | 78.2 | 79.6 | 81.1 |
| 掩码问题相似度 | 69.6 | 76.5 | 75.8 | 86.0 | 78.2 | 79.8 | 81.2 |
| SQL语义相似度 | 69.9 | 74.1 | 75.3 | 84.8 | 79.0 | 80.7 | 81.4 |
| SQL骨架相似度 | 71.6 | 75.1 | 75.6 | 84.2 | 80.0 | 80.8 | 81.2 |
| ITS-SQL(本文) | 71.9 | 78.7 | 76.8 | 85.8 | 82.4 | 83.4 | 82.3 |
| 3-shot | 随机 | 70.6 | 75.4 | 74.0 | 85.4 | 79.4 | 80.9 | 80.5 |
| 问题语义相似度 | 70.9 | 76.1 | 76.5 | 84.3 | 78.7 | 80.9 | 82.3 |
| 掩码问题相似度 | 69.4 | 75.6 | 76.9 | 85.4 | 78.2 | 79.6 | 82.4 |
| SQL语义相似度 | 72.0 | 76.2 | 75.3 | 84.4 | 78.8 | 82.5 | 80.2 |
| SQL骨架相似度 | 72.3 | 75.1 | 75.1 | 85.1 | 78.8 | 81.8 | 80.9 |
| ITS-SQL(本文) | 73.4 | 80.8 | 77.2 | 86.3 | 82.9 | 84.4 | 82.5 |
| 5-shot | 随机 | 72.9 | 76.2 | 75.1 | 85.5 | 78.9 | 80.8 | 80.3 |
| 问题语义相似度 | 71.5 | 76.7 | 76.3 | 84.6 | 78.7 | 81.0 | 82.4 |
| 掩码问题相似度 | 69.4 | 75.6 | 77.1 | 84.8 | 78.2 | 79.6 | 81.8 |
| SQL语义相似度 | 72.2 | 77.1 | 74.4 | 85.1 | 78.9 | 82.0 | 81.8 |
| SQL骨架相似度 | 72.0 | 75.3 | 74.7 | 85.3 | 78.7 | 81.1 | 82.3 |
| ITS-SQL(本文) | 73.9 | 80.7 | 77.7 | 86.8 | 82.9 | 84.5 | 83.1 |
), ArticleFig(id=1329419617283453231, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=表1, caption=
各大语言模型在不同少样本示例选择下 Spider-dev 数据集上的执行正确率
, figureFileSmall=null, figureFileBig=null, tableContent=
| 样本数量 | 样本选择策略 | CodeLlama | DeepSeek | DeepSeek-V2 | Qwen2.5 | Llama3 | Qwen2 | DeepSeek-V3 |
|---|
| 0-shot | | 71.0 | 72.6 | 75.0 | 83.0 | 75.5 | 79.2 | 78.6 |
| 1-shot | 随机 | 69.5 | 74.2 | 75.0 | 85.0 | 78.0 | 81.8 | 80.4 |
| 问题语义相似度 | 69.4 | 75.6 | 76.2 | 84.8 | 78.2 | 79.6 | 81.1 |
| 掩码问题相似度 | 69.6 | 76.5 | 75.8 | 86.0 | 78.2 | 79.8 | 81.2 |
| SQL语义相似度 | 69.9 | 74.1 | 75.3 | 84.8 | 79.0 | 80.7 | 81.4 |
| SQL骨架相似度 | 71.6 | 75.1 | 75.6 | 84.2 | 80.0 | 80.8 | 81.2 |
| ITS-SQL(本文) | 71.9 | 78.7 | 76.8 | 85.8 | 82.4 | 83.4 | 82.3 |
| 3-shot | 随机 | 70.6 | 75.4 | 74.0 | 85.4 | 79.4 | 80.9 | 80.5 |
| 问题语义相似度 | 70.9 | 76.1 | 76.5 | 84.3 | 78.7 | 80.9 | 82.3 |
| 掩码问题相似度 | 69.4 | 75.6 | 76.9 | 85.4 | 78.2 | 79.6 | 82.4 |
| SQL语义相似度 | 72.0 | 76.2 | 75.3 | 84.4 | 78.8 | 82.5 | 80.2 |
| SQL骨架相似度 | 72.3 | 75.1 | 75.1 | 85.1 | 78.8 | 81.8 | 80.9 |
| ITS-SQL(本文) | 73.4 | 80.8 | 77.2 | 86.3 | 82.9 | 84.4 | 82.5 |
| 5-shot | 随机 | 72.9 | 76.2 | 75.1 | 85.5 | 78.9 | 80.8 | 80.3 |
| 问题语义相似度 | 71.5 | 76.7 | 76.3 | 84.6 | 78.7 | 81.0 | 82.4 |
| 掩码问题相似度 | 69.4 | 75.6 | 77.1 | 84.8 | 78.2 | 79.6 | 81.8 |
| SQL语义相似度 | 72.2 | 77.1 | 74.4 | 85.1 | 78.9 | 82.0 | 81.8 |
| SQL骨架相似度 | 72.0 | 75.3 | 74.7 | 85.3 | 78.7 | 81.1 | 82.3 |
| ITS-SQL(本文) | 73.9 | 80.7 | 77.7 | 86.8 | 82.9 | 84.5 | 83.1 |
), ArticleFig(id=1329419617358950704, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Table 2, caption=
Execution Accuracy on Spider %
, figureFileSmall=null, figureFileBig=null, tableContent=
| 方法 | 验证集 | 测试集 |
|---|
| T5-3B | 71.5 | 74.4 |
| RAT-SQL | 75.0 | 73.3 |
| RATSAT+PICARD | 80.5 | 75.5 |
| Graphix-T5 | 81.0 | 77.6 |
| RESDSQL-3B | 84.1 | 79.9 |
| Codex | 71.7 | 72.1 |
| PaLM-2 | 69.9 | 70.5 |
| ChatGPT | 72.8 | 74.3 |
| COT+ChatGPT | 75.5 | 76.7 |
| GPT-4 | 76.6 | 83.9 |
| COT+GPT-4 | 78.2 | 83.9 |
| C3+ChatGPT | 81.8 | 82.3 |
| DAIL-SQL+GPT-4 | 82.4 | 86.6 |
| DINSQL+GPT-4 | 82.8 | 85.3 |
| GPT-4o | 77.8 | 82.8 |
| ITS-SQL+GPT-4o(本文) | 85.8 | 86.9 |
| ITS-SQL+Qwen2.5-Coder(本文) | 86.8 | 87.5 |
), ArticleFig(id=1329419617434448177, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=表2, caption=
在Spider上的执行正确率
, figureFileSmall=null, figureFileBig=null, tableContent=
| 方法 | 验证集 | 测试集 |
|---|
| T5-3B | 71.5 | 74.4 |
| RAT-SQL | 75.0 | 73.3 |
| RATSAT+PICARD | 80.5 | 75.5 |
| Graphix-T5 | 81.0 | 77.6 |
| RESDSQL-3B | 84.1 | 79.9 |
| Codex | 71.7 | 72.1 |
| PaLM-2 | 69.9 | 70.5 |
| ChatGPT | 72.8 | 74.3 |
| COT+ChatGPT | 75.5 | 76.7 |
| GPT-4 | 76.6 | 83.9 |
| COT+GPT-4 | 78.2 | 83.9 |
| C3+ChatGPT | 81.8 | 82.3 |
| DAIL-SQL+GPT-4 | 82.4 | 86.6 |
| DINSQL+GPT-4 | 82.8 | 85.3 |
| GPT-4o | 77.8 | 82.8 |
| ITS-SQL+GPT-4o(本文) | 85.8 | 86.9 |
| ITS-SQL+Qwen2.5-Coder(本文) | 86.8 | 87.5 |
), ArticleFig(id=1329419617493168434, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Table 3, caption=
Execution Accuracy on BIRD Validation Set %
, figureFileSmall=null, figureFileBig=null, tableContent=
| 方法 | 执行正确率 |
|---|
| RESDSQL-3B | 43.9 |
| T5-3B | 23.34 |
| Palm-2 | 27.38 |
| Codex | 34.35 |
| ChatGPT | 37.22 |
| ChatGPT+COT | 36.64 |
| Claude-2 | 42.70 |
| GPT-4 | 46.35 |
| C3+ChatGPT | 50.2 |
| DIN-SQL+GPT-4 | 50.72 |
| DAIL-SQL+GPT-4 | 54.76 |
| TA-SQL+GPT-4 | 56.19 |
| ITS-SQL+Qwen2.5-Coder(本文) | 60.17 |
| ITS-SQL+GPT-4o(本文) | 60.23 |
), ArticleFig(id=1329419617560277300, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=表3, caption=
在BIRD验证集上的执行正确率
, figureFileSmall=null, figureFileBig=null, tableContent=
| 方法 | 执行正确率 |
|---|
| RESDSQL-3B | 43.9 |
| T5-3B | 23.34 |
| Palm-2 | 27.38 |
| Codex | 34.35 |
| ChatGPT | 37.22 |
| ChatGPT+COT | 36.64 |
| Claude-2 | 42.70 |
| GPT-4 | 46.35 |
| C3+ChatGPT | 50.2 |
| DIN-SQL+GPT-4 | 50.72 |
| DAIL-SQL+GPT-4 | 54.76 |
| TA-SQL+GPT-4 | 56.19 |
| ITS-SQL+Qwen2.5-Coder(本文) | 60.17 |
| ITS-SQL+GPT-4o(本文) | 60.23 |
), ArticleFig(id=1329419617644163381, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Table 4, caption=
Execution Accuracy of Module Ablation study of Different Models on Spider Dataset %
, figureFileSmall=null, figureFileBig=null, tableContent=
| 模型 | w/o 伪 SQL | w/o 最终 SQL | w/o 模式 增强 | ITS-SQL (本文) | 上限 |
|---|
| CodeLlama | 73.8 | 73.0 | 73.9 | 74.5 | 76.7 |
| DeepSeek-Coder | 80.4 | 78.3 | 78.7 | 80.7 | 82.7 |
| DeepSeek-Coder-V2 | 77.1 | 74.4 | 75.7 | 77.7 | 79.5 |
| Qwen2.5-Coder | 85.4 | 85.1 | 85.3 | 86.8 | 88.1 |
| Llama3 | 81.2 | 80.6 | 80.7 | 82.9 | 85.0 |
| Qwen2 | 83.2 | 82.1 | 84.0 | 84.5 | 85.8 |
| DeepSeek-V3 | 82.3 | 82.4 | 82.1 | 83.1 | 84.5 |
), ArticleFig(id=1329419617715466550, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=表4, caption=
各模型在Spider数据集上的模块消融实验执行正确率
, figureFileSmall=null, figureFileBig=null, tableContent=
| 模型 | w/o 伪 SQL | w/o 最终 SQL | w/o 模式 增强 | ITS-SQL (本文) | 上限 |
|---|
| CodeLlama | 73.8 | 73.0 | 73.9 | 74.5 | 76.7 |
| DeepSeek-Coder | 80.4 | 78.3 | 78.7 | 80.7 | 82.7 |
| DeepSeek-Coder-V2 | 77.1 | 74.4 | 75.7 | 77.7 | 79.5 |
| Qwen2.5-Coder | 85.4 | 85.1 | 85.3 | 86.8 | 88.1 |
| Llama3 | 81.2 | 80.6 | 80.7 | 82.9 | 85.0 |
| Qwen2 | 83.2 | 82.1 | 84.0 | 84.5 | 85.8 |
| DeepSeek-V3 | 82.3 | 82.4 | 82.1 | 83.1 | 84.5 |
), ArticleFig(id=1329419617782575415, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Table 5, caption=
Execution Accuracy of Module Ablation study of Different Models on BIRD Dataset %
, figureFileSmall=null, figureFileBig=null, tableContent=
| 模型 | w/o 伪 SQL | w/o 最终 SQL | w/o 模式 增强 | ITS-SQL (本文) | 上限 |
|---|
| CodeLlama | 34.03 | 33.77 | 34.32 | 34.42 | 36.44 |
| DeepSeek-Coder | 46.28 | 45.76 | 47.20 | 47.33 | 49.67 |
| DeepSeek-Coder-V2 | 43.02 | 39.77 | 44.33 | 44.92 | 46.22 |
| Qwen2.5-Coder | 59.45 | 57.37 | 57.91 | 60.17 | 60.82 |
| Llama3 | 50.98 | 50.85 | 51.24 | 54.50 | 56.39 |
| Qwen2 | 54.30 | 53.98 | 54.95 | 56.45 | 58.28 |
| DeepSeek-V3 | 51.04 | 48.89 | 51.50 | 52.15 | 53.72 |
), ArticleFig(id=1329419617858072888, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=表5, caption=
各模型在BIRD数据集上的模块消融实验执行正确率
, figureFileSmall=null, figureFileBig=null, tableContent=
| 模型 | w/o 伪 SQL | w/o 最终 SQL | w/o 模式 增强 | ITS-SQL (本文) | 上限 |
|---|
| CodeLlama | 34.03 | 33.77 | 34.32 | 34.42 | 36.44 |
| DeepSeek-Coder | 46.28 | 45.76 | 47.20 | 47.33 | 49.67 |
| DeepSeek-Coder-V2 | 43.02 | 39.77 | 44.33 | 44.92 | 46.22 |
| Qwen2.5-Coder | 59.45 | 57.37 | 57.91 | 60.17 | 60.82 |
| Llama3 | 50.98 | 50.85 | 51.24 | 54.50 | 56.39 |
| Qwen2 | 54.30 | 53.98 | 54.95 | 56.45 | 58.28 |
| DeepSeek-V3 | 51.04 | 48.89 | 51.50 | 52.15 | 53.72 |
), ArticleFig(id=1329419617946153273, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=EN, label=Table 6, caption=
Execution Accuracy on Different Databases Within BIRD-dev Dataset
, figureFileSmall=null, figureFileBig=null, tableContent=
| 数据库 | 数量 | 困难比/% | 不同方法的执行正确率/% | 变化 |
|---|
| GPT-4o | ITS-SQL(本文) |
|---|
| california_schools | 89 | 39.33 | 25.84 | 40.45 | +14.61个百分点 |
| card_games | 191 | 34.55 | 39.27 | 52.36 | +13.09个百分点 |
| codebase_community | 186 | 18.82 | 56.99 | 64.52 | +7.53个百分点 |
| debit_card_specializing | 64 | 32.81 | 39.06 | 56.25 | +17.19个百分点 |
| european_football_2 | 129 | 49.61 | 51.94 | 69.77 | +17.83个百分点 |
| financial | 106 | 40.57 | 36.79 | 47.17 | +10.38个百分点 |
| formula_1 | 174 | 32.76 | 35.06 | 47.13 | +12.07个百分点 |
| student_club | 158 | 36.08 | 53.80 | 76.58 | +22.78个百分点 |
| superhero | 129 | 37.21 | 71.32 | 84.50 | +13.18个百分点 |
| thrombosis_prediction | 163 | 69.94 | 28.83 | 53.37 | +25.54个百分点 |
| toxicology | 145 | 47.59 | 48.97 | 64.14 | +15.17个百分点 |
), ArticleFig(id=1329419618013262138, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329419612044767459, language=CN, label=表6, caption=
BIRD-dev数据集的不同数据库上的执行正确率
, figureFileSmall=null, figureFileBig=null, tableContent=
| 数据库 | 数量 | 困难比/% | 不同方法的执行正确率/% | 变化 |
|---|
| GPT-4o | ITS-SQL(本文) |
|---|
| california_schools | 89 | 39.33 | 25.84 | 40.45 | +14.61个百分点 |
| card_games | 191 | 34.55 | 39.27 | 52.36 | +13.09个百分点 |
| codebase_community | 186 | 18.82 | 56.99 | 64.52 | +7.53个百分点 |
| debit_card_specializing | 64 | 32.81 | 39.06 | 56.25 | +17.19个百分点 |
| european_football_2 | 129 | 49.61 | 51.94 | 69.77 | +17.83个百分点 |
| financial | 106 | 40.57 | 36.79 | 47.17 | +10.38个百分点 |
| formula_1 | 174 | 32.76 | 35.06 | 47.13 | +12.07个百分点 |
| student_club | 158 | 36.08 | 53.80 | 76.58 | +22.78个百分点 |
| superhero | 129 | 37.21 | 71.32 | 84.50 | +13.18个百分点 |
| thrombosis_prediction | 163 | 69.94 | 28.83 | 53.37 | +25.54个百分点 |
| toxicology | 145 | 47.59 | 48.97 | 64.14 | +15.17个百分点 |
)], attaches=null, journal=Journal(id=1324759606947315908, delFlag=0, nameCn=计算机研究与发展, nameEn=Journal of Computer Research and Development, nameHistory1=null, nameHistory2=null, issn=1000-1239, eissn=null, cn=11-1777/TP, coden=null, periodic=0, language=CN, oaType=null, ccby=null, superviseOffice=null, ownerOffice=null, pubOffice=null, editorOffice=null, officeType=null, aims=null, clcCode=null, officeProv=null, officeCity=null, officeAddr=null, officeZip=null, officeEmail=null, officePhone=null, editDirector=null, officeDirector=null, officeDirectorPhone=null, officeStaffNum=null, officeEmpNum=null, coverPicUrl=k2l8zgqwstuxxevFX2qxVA==, journalPrice=null, startedYear=null, abbrevIsoEn=Journal of Computer Research and Development, journalRemark=null, publicationField=null, createdTime=1793776903141, updatedTime=1793850698612, createdBy=18614031015, updatedBy=13701087609, firstLetterCn=J, firstLetterEn=J, subjectCode=Electronic Information, subjectName=null, subjectCodeEn=Electronic Information, subjectNameEn=null, picCn=k2l8zgqwstuxxevFX2qxVA==, picEn=r6k0Ry+RD+c/VXj5QarmDw==, jcr=null, cjcr=null, exts=[JournalExt(id=1325069127710286688, language=CN, name=计算机研究与发展, nameHistory1=null, nameHistory2=null, managedBy=, sponsoredBy=, publishedBy=, editorOffice=, officeProv=null, officeCity=null, officeAddr=, officeZip=, editDirector=, officeDirector=null, officePhone=null, coverPicUrl=null, journalRemark=, submitArticleUrl=null, websiteUrl=, createdTime=1793850698640, updatedTime=1793850698640, createdBy=13701087609, updatedBy=13701087609, submissionGuidelinesUrl=, submissionAuthorUrl=https://crad.ict.ac.cn/journalx/authorLogOn.action, submissionEditorUrl=https://crad.ict.ac.cn/journalx/editorLogOn.action, submissionReviewUrl=https://crad.ict.ac.cn/journalx/expertLogOn.action, submissionCeEditorUrl=https://crad.ict.ac.cn/journalx/editorInChiefLogOn.action, submissionAeEditorUrl=, option={"copyright":""}), JournalExt(id=1325069127777395553, language=EN, name=Journal of Computer Research and Development, nameHistory1=null, nameHistory2=null, managedBy=, sponsoredBy=, publishedBy=, editorOffice=, officeProv=null, officeCity=null, officeAddr=, officeZip=, editDirector=, officeDirector=null, officePhone=null, coverPicUrl=null, journalRemark=, submitArticleUrl=null, websiteUrl=, createdTime=1793850698656, updatedTime=1793850698656, createdBy=13701087609, updatedBy=13701087609, submissionGuidelinesUrl=, submissionAuthorUrl=https://crad.ict.ac.cn/journalx/authorLogOn.action, submissionEditorUrl=https://crad.ict.ac.cn/journalx/editorLogOn.action, submissionReviewUrl=https://crad.ict.ac.cn/journalx/expertLogOn.action, submissionCeEditorUrl=https://crad.ict.ac.cn/journalx/editorInChiefLogOn.action, submissionAeEditorUrl=, option={"copyright":""})], databaseList=null, tenantJournalId=1324759914146529478, websiteList=[Website(id=1325070300139892771, webName=null, webTitle=null, webDomain=null, webCopyrigh=null, webIpcNo=null, seoTitle=null, seoKeywords=null, seoDescription=null, tenantJournalId=null, journalId=1324759914146529478, journalNameCn=null, journalNameEn=null, grayFlag=null, tenantId=1146029695717560320, platformId=null, journalGroupId=null, journalGroupNameCn=null, journalGroupNameEn=null, type=1, domain=https://castjournals.cast.org.cn/joweb/jsjyjyfz/CN, language=CN, createTime=1793850978169, createBy=18614031015, updateTime=1793851040259, updateBy=18614031015, name=计算机研究与发展-中文, tplId=1146099689490845704, title=计算机研究与发展, delFlag=0, indexPage=/home, props=[WebsiteProps(id=1325070893751349360, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=articleTextType, value=kx, createTime=1793851119697, updateTime=1793851119697, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070893730377837, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=banner, value=null, createTime=1793851119692, updateTime=1793851119692, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070893772320883, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=grayFlag, value=0, createTime=1793851119702, updateTime=1793851119702, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070893721989228, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=logo, value=https://castjournals.cast.org.cn/joweb/jsjyjyfz/CN/file/pic?fileId=U27tDsy717YF7XSPA+Vwdw==, createTime=1793851119690, updateTime=1793851119690, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070893784903797, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=minRunFlag, value=0, createTime=1793851119705, updateTime=1793851119705, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070893742960751, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=picServerUrl, value=https://castjournals.cast.org.cn/joweb/jsjyjyfz/CN/file/pic, createTime=1793851119695, updateTime=1793851119695, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070893780709492, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=silenceFlag, value=0, createTime=1793851119704, updateTime=1793851119704, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070893738766446, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=staticResourcePath, value=https://castjournals.cast.org.cn/joweb/cast_kjdb_cn_619/, createTime=1793851119694, updateTime=1793851119694, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070893755543665, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=themeColor, value=null, createTime=1793851119698, updateTime=1793851119698, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070893763932274, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300139892771, code=themeStyle, value=null, createTime=1793851119700, updateTime=1793851119700, creator=18614031015, updator=18614031015)]), Website(id=1325070300580294698, webName=null, webTitle=null, webDomain=null, webCopyrigh=null, webIpcNo=null, seoTitle=null, seoKeywords=null, seoDescription=null, tenantJournalId=null, journalId=1324759914146529478, journalNameCn=null, journalNameEn=null, grayFlag=null, tenantId=1146029695717560320, platformId=null, journalGroupId=null, journalGroupNameCn=null, journalGroupNameEn=null, type=1, domain=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN, language=EN, createTime=1793850978274, createBy=18614031015, updateTime=1793851036638, updateBy=18614031015, name=计算机研究与发展-英文, tplId=1146101810881728533, title=Journal of Computer Research and Development, delFlag=0, indexPage=/home, props=[WebsiteProps(id=1325070925288321148, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=articleTextType, value=kx, createTime=1793851127216, updateTime=1793851127216, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070925263155321, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=banner, value=null, createTime=1793851127210, updateTime=1793851127210, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070925309292671, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=grayFlag, value=0, createTime=1793851127221, updateTime=1793851127221, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070925254766712, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=logo, value=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/file/pic?fileId=U27tDsy717YF7XSPA+Vwdw==, createTime=1793851127208, updateTime=1793851127208, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070925326069889, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=minRunFlag, value=0, createTime=1793851127225, updateTime=1793851127225, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070925279932539, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=picServerUrl, value=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/file/pic, createTime=1793851127214, updateTime=1793851127214, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070925317681280, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=silenceFlag, value=0, createTime=1793851127223, updateTime=1793851127223, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070925271543930, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=staticResourcePath, value=https://castjournals.cast.org.cn/joweb/cast_kjdb_en_623/, createTime=1793851127212, updateTime=1793851127212, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070925292515453, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=themeColor, value=null, createTime=1793851127217, updateTime=1793851127217, creator=18614031015, updator=18614031015), WebsiteProps(id=1325070925300904062, tenantId=1146029695717560320, journalId=null, journalGroupId=null, siteId=1325070300580294698, code=themeStyle, value=null, createTime=1793851127219, updateTime=1793851127219, creator=18614031015, updator=18614031015)])], journalTitle=计算机研究与发展, weixinUrl=null, journalUrl=https://crad.ict.ac.cn/, iacademicId=null, status=1, seqNo=null, journalTitleEn=Journal of Computer Research and Development, journalPhotoCn=k2l8zgqwstuxxevFX2qxVA==, journalPhotoEn=r6k0Ry+RD+c/VXj5QarmDw==, journalFirstLetter=J, journalRecommend=null, journalNew=null, journalCollection=null, jcrJf=null, cjcrJf=null, jcrJfStr=null, cjcrJfStr=null, submissionFirstDecision=null, sciSubjectClassification=null, casSubjectClassification=null, citeScore=null, totalCitationFrequency=null, icpCode=null, psCode=null, advertisingLicenseCode=null, copyrightInformation=null, country=null, option=, provinceCode=null, provinceName=null, collectFlag=false, interPubPlatform=, interPubPlatformUrl=null), detailUrlCn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/CN/10.7544/issn1000-1239.202550355, detailUrlEn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/10.7544/issn1000-1239.202550355, pdfUrlCn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/CN/PDF/10.7544/issn1000-1239.202550355, pdfUrlEn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/PDF/10.7544/issn1000-1239.202550355, aliStartDate=0, aliEndDate=0, collectionFlag=false, citedCount=null, citedUrl=null, previewStatus=0, delFlag=0, hasFullText=1, orderTime=1777564800000, fullTextJson=null, articleText=null, reference=null)