Article(id=1329456485941228021, tenantId=1146029695717560320, journalId=1324759914146529478, issueId=1329456279791186761, articleNumber=null, orderNo=null, doi=10.7544/issn1000-1239.202220931, pmid=null, cstr=null, oa=null, hot=null, price=null, onlineType=0, articleFormat=0, articleType=null, articleTypeStr=null, receivedDate=1668096000000, receivedDateStr=2022-11-11, revisedDate=1686585600000, revisedDateStr=2023-06-13, acceptedDate=null, acceptedDateStr=null, onlineDate=1794896726355, onlineDateStr=2026-11-17, pubDate=1711900800000, pubDateStr=2024-04-01, doiRegisterDate=null, doiRegisterDateStr=null, onlineIssueDate=1794896726355, onlineIssueDateStr=2026-11-17, onlineJustAcceptDate=null, onlineJustAcceptDateStr=null, onlineFirstDate=null, onlineFirstDateStr=null, sourceXml=null, magXml=null, createTime=1794896726355, creator=13701087609, updateTime=1794896726355, updator=13701087609, issue=Issue{id=1329456279791186761, tenantId=1146029695717560320, journalId=1324759914146529478, year='2024', volume='61', issue='4', pageStart='809', pageEnd='1084', issueExtLink='null', onlineDate='null', pubDate='1711900800000', pubDateStr='2024-04-01', beforeIssueId=null, nextIssueId=null, price=null, status=1, issueComplete=1, articleOrder=1, issueType=-1, specialIssue=null, createTime=1794896677204, creator='13701087609', updateTime=1794899232988, updator='13701087609', preIssue=null, nextIssue=null, articleTotal=null, ext={EN=IssueExt(id=1329466999882756515, tenantId=1146029695717560320, journalId=1324759914146529478, issueId=1329456279791186761, language=EN, specialIssueTitle=, coverIllustrator=null, specialIssueEditor=, specialIssueAbout=), CN=IssueExt(id=1329466999882756516, tenantId=1146029695717560320, journalId=1324759914146529478, issueId=1329456279791186761, language=CN, specialIssueTitle=, coverIllustrator=null, specialIssueEditor=, specialIssueAbout=)}, issueFiles=null, downloadFileDto=null}, startPage=929, endPage=954, ext={EN=ArticleExt(id=1329456486134166006, articleId=1329456485941228021, tenantId=1146029695717560320, journalId=1324759914146529478, language=EN, title=Survey on Database Index Tuning Techniques, columnId=1327010930744996407, journalTitle=Journal of Computer Research and Development, columnName=Software Technology, runingTitle=null, highlight=null, articleAbstract=
Index tuning is an important problem in database performance tuning and has been studied consistently by worldwide researchers. Due to the theoretical complexity of index tuning as well as the advent of the big data era, manual tuning by DBA is no longer feasible for modern database systems, hence automated and intelligent solutions have been developed. With the development of machine learning techniques, more and more index tuning solutions have integrated with machine learning techniques for better performance and significant progress has been made recently. In this survey, we formulate the problem of index tuning under a search-based paradigm, and under this context, we analyze the main tasks and challenges of this problem. We categorize relevant studies into three main components of the search-based paradigm, namely the generation of the index configurations’ search space, the evaluation of specific index configurations, and the enumeration or the search of index configurations. Then we discuss and compare the related work in each category. We further identify and analyze new challenges for the online index tuning problem where the workload is ad hoc, dynamic, and shifting. We summarize the existing solutions under the online feedback control loop framework. Finally, we discuss the state-of-the-art index tuning tools. Hopefully, with the thorough discussion and evaluation of current research, this survey can provide insights to interested researchers and conclude with future research directions for index tuning.
, authors=Sichao Lai
1, Xiaoying Wu
1, Yuwei Peng
1, Zhiyong Peng
1, 2, *, authorsList=Sichao Lai, Xiaoying Wu, Yuwei Peng, Zhiyong Peng, authorCompany=null, correspAuthors=Zhiyong Peng, authorNote=
born in 1993. PhD candidate. Student member of CCF. His main research interests include database tuning, database indexes, and AI4DB
born in 1973. PhD, associate professor. Member of CCF. Her main research interests include data management, data processing and optimization, keyword search, pattern mining, web net, and data integration
born in 1980. PhD, associate professor. Member of CCF. His main research interests include database systems and digital watermarks
born in 1963. PhD, professor. Fellow of CCF. His main research interests include databases, big data management and analysis, trusted data management, and complex data management
, correspAuthorsNote=null, copyrightStatement=Copyright © 2024 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=1329456489544135177, articleId=1329456485941228021, tenantId=1146029695717560320, journalId=1324759914146529478, language=CN, title=数据库索引调优技术综述, columnId=1327010930908574265, journalTitle=计算机研究与发展, columnName=软件技术, runingTitle=null, highlight=null, articleAbstract=
索引调优是数据库调优的重要组成部分,一直受到广泛关注. 由于索引调优问题的理论复杂性和大数据时代的到来,通过DBA手动调优的方案已经无法满足现代数据库的发展需求,调优方案逐渐开始向自动化、智能化的方向发展. 随着机器学习技术的发展,越来越多的索引选择方案开始引入机器学习技术,并取得了一定的研究成果. 将索引调优问题的解决方案归结为一种基于搜索的调优范式,归纳了其研究内容,阐述了其面临的挑战,对调优范式内的索引配置空间的生成、索引配置的评价以及索引配置的枚举与搜索3方面的研究成果进行了归纳、总结和对比. 对动态工作负载下的索引选择问题(index selection problem,ISP)所面临的新挑战进行了分析,并基于在线反馈控制回路框架对其解决方案进行梳理. 讨论了索引调优工具的发展与现状,通过对现有研究的分析论述,为后来研究者提供参考和研究思路,并对索引选择方案的未来进行了展望.
, authors=赖思超
1, 吴小莹
1, 彭煜玮
1, 彭智勇
1, 2, *, authorsList=赖思超, 吴小莹, 彭煜玮, 彭智勇, authorCompany=null, correspAuthors=彭智勇, authorNote=
 |
1993年生. 博士研究生. CCF学生会员. 主要研究方向为数据库调优、数据库索引、AI4DB |
 |
1973年生. 博士,副教授. CCF会员. 主要研究方向为数据管理、数据查询处理和优化、关键字查询、模式挖掘、语义网、数据集成 |
 |
1980年生. 博士,副教授. CCF会员. 主要研究方向为数据库系统、数字水印 |
 |
1963年生. 博士,教授. CCF会士. 主要研究方向为数据库、大数据管理与分析、可信数据管理、复杂数据管理 |
, correspAuthorsNote=
, copyrightStatement=版权所有 © 2024 计算机研究与发展编辑部, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=1x6VMPQYwCwbRRtM3c+aYA==, magXml=G6UaEi5rgRqAsCAMHIL6kg==, pdfUrl=null, pdf=of9AioScv8TBRUjECCQ09g==, pdfFileSize=1268634, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=tU8mAbf9berxF3o43xSMhg==, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=uOEifPFwVbw2GaSs3sS15g==, mapNumber=null, fund=null)}, authors=[Author(id=1329456489959371281, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, orderNo=0, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=sichaolai@whu.edu.cn, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1329456490043257363, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, authorId=1329456489959371281, language=EN, stringName=Sichao Lai, firstName=Sichao, middleName=null, lastName=Lai, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, address=
1School of Computer Science, Wuhan University, Wuhan 430072, bio={"content":"
born in 1993. PhD candidate. Student member of CCF. His main research interests include database tuning, database indexes, and AI4DB
"}, bioImg=null, bioContent=
born in 1993. PhD candidate. Student member of CCF. His main research interests include database tuning, database indexes, and AI4DB
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329456490127143444, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, authorId=1329456489959371281, 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武汉大学计算机学院 武汉 430072, bio={"img":"7AjVRXiX4cC9NEZdnuQ7LQ==","content":"
1993年生. 博士研究生. CCF学生会员. 主要研究方向为数据库调优、数据库索引、AI4DB
"}, bioImg=7AjVRXiX4cC9NEZdnuQ7LQ==, bioContent=
1993年生. 博士研究生. CCF学生会员. 主要研究方向为数据库调优、数据库索引、AI4DB
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329456489779016202, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, xref=1, ext=[AuthorCompanyExt(id=1329456489787404811, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Computer Science, Wuhan University, Wuhan 430072), AuthorCompanyExt(id=1329456489799987724, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1武汉大学计算机学院 武汉 430072)])]), Author(id=1329456490206835222, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, orderNo=1, 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=1329456490286527000, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, authorId=1329456490206835222, language=EN, stringName=Xiaoying Wu, firstName=Xiaoying, middleName=null, lastName=Wu, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, address=
1School of Computer Science, Wuhan University, Wuhan 430072, bio={"content":"
born in 1973. PhD, associate professor. Member of CCF. Her main research interests include data management, data processing and optimization, keyword search, pattern mining, web net, and data integration
"}, bioImg=null, bioContent=
born in 1973. PhD, associate professor. Member of CCF. Her main research interests include data management, data processing and optimization, keyword search, pattern mining, web net, and data integration
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329456490362024473, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, authorId=1329456490206835222, 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武汉大学计算机学院 武汉 430072, bio={"img":"xJuWcT49p9Yy1f6rr3jadw==","content":"
1973年生. 博士,副教授. CCF会员. 主要研究方向为数据管理、数据查询处理和优化、关键字查询、模式挖掘、语义网、数据集成
"}, bioImg=xJuWcT49p9Yy1f6rr3jadw==, bioContent=
1973年生. 博士,副教授. CCF会员. 主要研究方向为数据管理、数据查询处理和优化、关键字查询、模式挖掘、语义网、数据集成
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329456489779016202, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, xref=1, ext=[AuthorCompanyExt(id=1329456489787404811, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Computer Science, Wuhan University, Wuhan 430072), AuthorCompanyExt(id=1329456489799987724, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1武汉大学计算机学院 武汉 430072)])]), Author(id=1329456490429133339, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=1329456490500436509, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, authorId=1329456490429133339, language=EN, stringName=Yuwei Peng, firstName=Yuwei, middleName=null, lastName=Peng, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, address=
1School of Computer Science, Wuhan University, Wuhan 430072, bio={"content":"
born in 1980. PhD, associate professor. Member of CCF. His main research interests include database systems and digital watermarks
"}, bioImg=null, bioContent=
born in 1980. PhD, associate professor. Member of CCF. His main research interests include database systems and digital watermarks
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329456490580128286, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, authorId=1329456490429133339, 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武汉大学计算机学院 武汉 430072, bio={"img":"xPvVQ3PaphtblwMZLAlZdQ==","content":"
1980年生. 博士,副教授. CCF会员. 主要研究方向为数据库系统、数字水印
"}, bioImg=xPvVQ3PaphtblwMZLAlZdQ==, bioContent=
1980年生. 博士,副教授. CCF会员. 主要研究方向为数据库系统、数字水印
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329456489779016202, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, xref=1, ext=[AuthorCompanyExt(id=1329456489787404811, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Computer Science, Wuhan University, Wuhan 430072), AuthorCompanyExt(id=1329456489799987724, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1武汉大学计算机学院 武汉 430072)])]), Author(id=1329456490643042848, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, orderNo=3, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=peng@whu.edu.cn, emailSecond=null, emailThird=null, correspondingAuthor=1, authorType=1, ext={EN=AuthorExt(id=1329456490731123235, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, authorId=1329456490643042848, language=EN, stringName=Zhiyong Peng, firstName=Zhiyong, middleName=null, lastName=Peng, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, 2, *, address=
1School of Computer Science, Wuhan University, Wuhan 430072
2Big Data Institute, Wuhan University, Wuhan 430072, bio={"content":"
born in 1963. PhD, professor. Fellow of CCF. His main research interests include databases, big data management and analysis, trusted data management, and complex data management
"}, bioImg=null, bioContent=
born in 1963. PhD, professor. Fellow of CCF. His main research interests include databases, big data management and analysis, trusted data management, and complex data management
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329456490810815012, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, authorId=1329456490643042848, 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武汉大学计算机学院 武汉 430072
2武汉大学大数据研究院 武汉 430072, bio={"img":"F33m65yLwnMvQxxvjx6XVw==","content":"
1963年生. 博士,教授. CCF会士. 主要研究方向为数据库、大数据管理与分析、可信数据管理、复杂数据管理
"}, bioImg=F33m65yLwnMvQxxvjx6XVw==, bioContent=
1963年生. 博士,教授. CCF会士. 主要研究方向为数据库、大数据管理与分析、可信数据管理、复杂数据管理
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329456489779016202, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, xref=1, ext=[AuthorCompanyExt(id=1329456489787404811, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Computer Science, Wuhan University, Wuhan 430072), AuthorCompanyExt(id=1329456489799987724, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1武汉大学计算机学院 武汉 430072)]), AuthorCompany(id=1329456489879679501, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, xref=2, ext=[AuthorCompanyExt(id=1329456489883873806, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489879679501, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2Big Data Institute, Wuhan University, Wuhan 430072), AuthorCompanyExt(id=1329456489892262415, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489879679501, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2武汉大学大数据研究院 武汉 430072)])])], keywords=[Keyword(id=1329456490915672613, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, orderNo=1, keyword=database index), Keyword(id=1329456490974392870, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, orderNo=2, keyword=index selection), Keyword(id=1329456491045696039, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, orderNo=3, keyword=index tuning), Keyword(id=1329456491108610600, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, orderNo=4, keyword=performance tuning), Keyword(id=1329456491167330857, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, orderNo=5, keyword=machine learning), Keyword(id=1329456491226051114, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, orderNo=1, keyword=数据库索引), Keyword(id=1329456491288965675, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, orderNo=2, keyword=索引选择), Keyword(id=1329456491356074540, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, orderNo=3, keyword=索引调优), Keyword(id=1329456491423183405, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, orderNo=4, keyword=性能调优), Keyword(id=1329456491486097966, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, orderNo=5, keyword=机器学习)], refs=[Reference(id=1329456493990097465, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Van Aken D, Pavlo A, Gordon G J, et al. Automatic database management system tuning through large-scale machine learning [C] //Proc of the 2017 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2017: 1009–1024, articleTitle=null, refAbstract=null), Reference(id=1329456494069789242, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=崔跃生,张勇,曾春,等. 数据库物理结构优化技术[J]. 软件学报,2013,24(4):761−780, articleTitle=null, refAbstract=null), Reference(id=1329456494145286715, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Cui Yuesheng, Zhang Yong, Zeng Chun, et al. Database physical structure optimization technology[J]. Journal of Software, 2013, 24(4): 761−780 (in Chinese), articleTitle=null, refAbstract=null), Reference(id=1329456494313058876, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Chaudhuri S, Narasayya V R. An efficient cost-driven index selection tool for Microsoft SQL Server [C] //Proc of the 23rd Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 1997: 146–155, articleTitle=null, refAbstract=null), Reference(id=1329456494443082301, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Lum V Y, Ling H. An optimization problem on the selection of secondary keys [C] //Proc of the 26th Annual Conf. New York: ACM, 1971: 349–356, articleTitle=null, refAbstract=null), Reference(id=1329456494518579774, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Bayer R, McCreight E. Organization and maintenance of large ordered indices [C] //Proc of the 1970 ACM SIGFIDET Workshop on Data Description, Access and Control. New York: ACM, 1970: 107–141, articleTitle=null, refAbstract=null), Reference(id=1329456494602465855, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Lum V Y. Multi-attribute retrieval with combined indexes[J]. Communications of the ACM, 1970, 13(11): 660−665, articleTitle=null, refAbstract=null), Reference(id=1329456494661186112, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Stonebraker M. The choice of partial inversions and combined indices[J]. International Journal of Computer & Information Sciences, 1974, 3(2): 167−188, articleTitle=null, refAbstract=null), Reference(id=1329456494732489281, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Comer D. The difficulty of optimum index selection[J]. ACM Transactions on Database Systems, 1978, 3(4): 440−445, articleTitle=null, refAbstract=null), Reference(id=1329456494845735490, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Chaudhuri S, Datar M, Narasayya V. Index selection for databases: A hardness study and a principled heuristic solution[J]. IEEE Transactions on Knowledge and Data Engineering, 2004, 16(11): 1313−1323, articleTitle=null, refAbstract=null), Reference(id=1329456494921232963, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Agrawal S, Chaudhuri S, Kollar L, et al. Database tuning advisor for Microsoft SQL Server 2005 [C] //Proc of the 30th Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 2004: 1110–1121, articleTitle=null, refAbstract=null), Reference(id=1329456495009313348, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Valentin G, Zuliani M, Zilio D C, et al. DB2Advisor: An optimizer smart enough to recommend its own indexes [C] //Proc of the 16th Int Conf on Data Engineering. Los Alamitos, CA: IEEE Computer Society, 2000: 101–110, articleTitle=null, refAbstract=null), Reference(id=1329456495130948165, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Zilio D C, Rao Jun, Lightstone S, et al. DB2 design advisor: Integrated automatic physical database design [C] //Proc of the 30th Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 2004: 1087–1097, articleTitle=null, refAbstract=null), Reference(id=1329456495206445638, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=Dageville B, Das D, Dias K, et al. Automatic SQL tuning in Oracle 10g [C] //Proc of the 30th Int Conf on Very Large Data bases. San Francisco, CA: Morgan Kaufmann, 2004: 1098–1109, articleTitle=null, refAbstract=null), Reference(id=1329456495277748807, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, 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=李国良,周煊赫,孙佶,等. 基于机器学习的数据库技术综述[J]. 计算机学报,2020,43(11):2019−2049, articleTitle=null, refAbstract=null), Reference(id=1329456495336469064, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=14, rfOrder=15, authorNames=null, journalName=null, refType=null, unstructuredReference=Li Guoliang, Zhou Xuanhe, Sun Ji, et. al. A survey of machine learning based database techniques[J]. Chinese Journal of Computers, 2020, 43(11): 2019−2049 (in Chinese), articleTitle=null, refAbstract=null), Reference(id=1329456495390995017, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=15, rfOrder=16, authorNames=null, journalName=null, refType=null, unstructuredReference=Sadri Z, Gruenwald L, Lead E. DRLindex: Deep reinforcement learning index advisor for a cluster database [C/OL] //Proc of the 24th Symp on Int Database Engineering & Applications. New York: ACM, 2020[2022-09-01].https://dl.acm.org/doi/10.1145/3410566.3410603, articleTitle=null, refAbstract=null), Reference(id=1329456495449715274, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=16, rfOrder=17, authorNames=null, journalName=null, refType=null, unstructuredReference=Das S, Grbic M, Ilic I, et al. Automatically indexing millions of databases in Microsoft Azure SQL database [C] //Proc of the 2019 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2019: 666–679, articleTitle=null, refAbstract=null), Reference(id=1329456495533601355, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=17, rfOrder=18, authorNames=null, journalName=null, refType=null, unstructuredReference=Idreos S, Kersten M L, Manegold S. Database cracking [C/OL] //Proc of the 3rd Biennial Conf on Innovative Data Systems Research. 2007[2020-09-01].https://www.cidrdb.org/cidr2007/, articleTitle=null, refAbstract=null), Reference(id=1329456495600710220, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=18, rfOrder=19, authorNames=null, journalName=null, refType=null, unstructuredReference=Graefe G, Kuno H. Adaptive indexing for relational keys [C] //Proc of the 26th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2010: 69–74, articleTitle=null, refAbstract=null), Reference(id=1329456495688790605, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=19, rfOrder=20, authorNames=null, journalName=null, refType=null, unstructuredReference=Graefe G, Idreos S, Kuno H, et al. Benchmarking adaptive indexing [G]//LNPSE 6417: Proc of the 2nd Technology Conf on Performance Evaluation and Benchmarking. Berlin: Springer, 2011: 169–184, articleTitle=null, refAbstract=null), Reference(id=1329456495755899470, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=20, rfOrder=21, authorNames=null, journalName=null, refType=null, unstructuredReference=Bruno N. Automated Physical Database Design and Tuning [M]. 1st ed. Boca Raton, FL: CRC Press, 2011, articleTitle=null, refAbstract=null), Reference(id=1329456495831396943, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=21, rfOrder=22, authorNames=null, journalName=null, refType=null, unstructuredReference=Kossmann J, Halfpap S, Jankrift M, et al. Magic mirror in my hand, which is the best in the land? An experimental evaluation of index selection algorithms[J]. Proceedings of the VLDB Endowment, 2020, 13(11): 2382−2395, articleTitle=null, refAbstract=null), Reference(id=1329456495911088720, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=22, rfOrder=23, authorNames=null, journalName=null, refType=null, unstructuredReference=Faerber F, Kemper A, Larson P Å, et al. Main memory database systems[J]. Foundations and Trends in Databases, 2017, 8(1/2): 1−130, articleTitle=null, refAbstract=null), Reference(id=1329456495969808977, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=23, rfOrder=24, authorNames=null, journalName=null, refType=null, unstructuredReference=Schlosser R, Kossmann J, Boissier M. Efficient scalable multi-attribute index selection using recursive strategies [C] //Proc of the 35th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2019: 1238–1249, articleTitle=null, refAbstract=null), Reference(id=1329456496053695058, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=24, rfOrder=25, authorNames=null, journalName=null, refType=null, unstructuredReference=Weikum G, Moenkeberg A, Hasse C, et al. Self-tuning database technology and information services: From wishful thinking to viable engineering [C] //Proc of the 28th Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 2002: 20–31, articleTitle=null, refAbstract=null), Reference(id=1329456496120803923, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=25, rfOrder=26, authorNames=null, journalName=null, refType=null, unstructuredReference=Chaudhuri S, Narasayya V. AutoAdmin “what-if” index analysis utility [C] //Proc of the 1998 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 1998: 367–378, articleTitle=null, refAbstract=null), Reference(id=1329456496166941268, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=26, rfOrder=27, authorNames=null, journalName=null, refType=null, unstructuredReference=Dias K, Ramacher M, Shaft U, et al. Automatic performance diagnosis and tuning in Oracle [C/OL] //Proc of the 2nd Biennial Conf on Innovative Data Systems Research. 2005[2022-09-01].https://www.cidrdb.org/cidr2005/, articleTitle=null, refAbstract=null), Reference(id=1329456496280187477, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=27, rfOrder=28, authorNames=null, journalName=null, refType=null, unstructuredReference=Chaudhuri S, Narasayya V, Weikum G. Database tuning using combinatorial search [M]//Encyclopedia of Database Systems. New York: Springer Press, 2018: 985–989, articleTitle=null, refAbstract=null), Reference(id=1329456496343102038, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=28, rfOrder=29, authorNames=null, journalName=null, refType=null, unstructuredReference=Bruno N, Nehme R V. Configuration-parametric query optimization for physical design tuning [C] //Proc of the 2008 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2008: 941−952, articleTitle=null, refAbstract=null), Reference(id=1329456496460542551, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=29, rfOrder=30, authorNames=null, journalName=null, refType=null, unstructuredReference=Ding Bailu, Das S, Marcus R, et al. AI meets AI: Leveraging query executions to improve index recommendations [C] //Proc of the 2019 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2019: 1241–1258, articleTitle=null, refAbstract=null), Reference(id=1329456496523457112, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=30, rfOrder=31, authorNames=null, journalName=null, refType=null, unstructuredReference=Schnaitter K, Polyzotis N, Getoor L. Index interactions in physical design tuning: Modeling, analysis, and applications[J]. Proceedings of the VLDB Endowment, 2009, 2(1): 1234−1245, articleTitle=null, refAbstract=null), Reference(id=1329456496594760281, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=31, rfOrder=32, authorNames=null, journalName=null, refType=null, unstructuredReference=Finkelstein S, Schkolnick M, Tiberio P. Physical database design for relational databases[J]. ACM Transactions on Database Systems, 1988, 13(1): 91−128, articleTitle=null, refAbstract=null), Reference(id=1329456496670257754, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=32, rfOrder=33, authorNames=null, journalName=null, refType=null, unstructuredReference=Siddiqui T, Jo S, Wu Wentao, et al. ISUM: Efficiently compressing large and complex workloads for scalable index tuning [C] //Proc of the 2022 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2022: 660–673, articleTitle=null, refAbstract=null), Reference(id=1329456498301842011, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=33, rfOrder=34, authorNames=null, journalName=null, refType=null, unstructuredReference=Sattler K-U, Schallehn E, Geist I. Autonomous query-driven index tuning [C] //Proc of the 8th Int Database Engineering and Applications Symp. Los Alamitos, CA: IEEE Computer Society, 2004: 439–448, articleTitle=null, refAbstract=null), Reference(id=1329456498364756572, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=34, rfOrder=35, authorNames=null, journalName=null, refType=null, unstructuredReference=Schnaitter K, Abiteboul S, Milo T, et al. On-line index selection for shifting workloads [C] //Proc of the 23rd Int Conf on Data Engineering Workshop. Piscataway, NJ: IEEE, 2007: 459–468, articleTitle=null, refAbstract=null), Reference(id=1329456498431865437, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=35, rfOrder=36, authorNames=null, journalName=null, refType=null, unstructuredReference=Jimenez I, Sanchez H, Tran Q T, et al. Kaizen: A semi-automatic index advisor [C] //Proc of the 2012 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2012: 685−688, articleTitle=null, refAbstract=null), Reference(id=1329456498503168606, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=36, rfOrder=37, authorNames=null, journalName=null, refType=null, unstructuredReference=Bruno N, Chaudhuri S. Automatic physical database tuning: A relaxation-based approach [C] //Proc of the 2005 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2005: 227–238, articleTitle=null, refAbstract=null), Reference(id=1329456498570277471, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=37, rfOrder=38, authorNames=null, journalName=null, refType=null, unstructuredReference=Bruno N, Chaudhuri S. To tune or not to tune? A lightweight physical design alerter [C] //Proc of the 32nd Int Conf on Very Large Data Bases. New York: ACM, 2006: 499–510, articleTitle=null, refAbstract=null), Reference(id=1329456498641580640, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=38, rfOrder=39, authorNames=null, journalName=null, refType=null, unstructuredReference=Hammer M, Chan A. Index selection in a self-adaptive data base management system [C] //Proc of the 1976 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 1976: 1–8, articleTitle=null, refAbstract=null), Reference(id=1329456498712883809, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=39, rfOrder=40, authorNames=null, journalName=null, refType=null, unstructuredReference=Whang K Y. Index selection in relational databases [C] //Proc of the 2nd Int Conf on Foundations of Data Organization. New York: Plenum, 1985: 487–500, articleTitle=null, refAbstract=null), Reference(id=1329456498809352802, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=40, rfOrder=41, authorNames=null, journalName=null, refType=null, unstructuredReference=Schkolnick M. The optimal selection of secondary indices for files[J]. Information Systems, 1975, 1(4): 141−146, articleTitle=null, refAbstract=null), Reference(id=1329456498880655971, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=41, rfOrder=42, authorNames=null, journalName=null, refType=null, unstructuredReference=Ip M Y L, Saxton L V, Raghavan V V. On the selection of an optimal set of indexes[J]. IEEE Transactions on Software Engineering, 1983, SE-9(2): 135−143, articleTitle=null, refAbstract=null), Reference(id=1329456498951959140, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=42, rfOrder=43, authorNames=null, journalName=null, refType=null, unstructuredReference=Chaudhuri S, Narasayya V. Index merging [C] //Proc of the 15th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 1999: 296–303, articleTitle=null, refAbstract=null), Reference(id=1329456499044233829, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=43, rfOrder=44, authorNames=null, journalName=null, refType=null, unstructuredReference=Nehme R, Bruno N. Automated partitioning design in parallel database systems [C] //Proc of the 2011 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2011: 1137–1148, articleTitle=null, refAbstract=null), Reference(id=1329456499128119910, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=44, rfOrder=45, authorNames=null, journalName=null, refType=null, unstructuredReference=Bruno N, Chaudhuri S. Physical design refinement: The ‘merge-reduce’ approach[J]. ACM Transactions on Database Systems, 2007, 32(4): 28−71, articleTitle=null, refAbstract=null), Reference(id=1329456499216200295, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=45, rfOrder=46, authorNames=null, journalName=null, refType=null, unstructuredReference=Deep S, Gruenheid A, Koutris P, et al. Comprehensive and efficient workload compression[J]. Proceedings of the VLDB Endowment, 2020, 14(3): 418−430, articleTitle=null, refAbstract=null), Reference(id=1329456499316863592, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=46, rfOrder=47, authorNames=null, journalName=null, refType=null, unstructuredReference=Chaudhuri S, Gupta A K, Narasayya V. Compressing SQL workloads [C] //Proc of the 2002 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2002: 488–499, articleTitle=null, refAbstract=null), Reference(id=1329456499388166761, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=47, rfOrder=48, authorNames=null, journalName=null, refType=null, unstructuredReference=Kołaczkowski P. Compressing very large database workloads for continuous online index selection [G]//LNISA 5181: Proc of the 19th Int Conf on Database and Expert Systems Applications. Berlin: Springer, 2008: 791–799, articleTitle=null, refAbstract=null), Reference(id=1329456499455275626, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=48, rfOrder=49, authorNames=null, journalName=null, refType=null, unstructuredReference=Ma Lin, Van Aken D, Hefny A, et al. Query-based workload forecasting for self-driving database management systems [C] //Proc of the 2018 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2018: 631–645, articleTitle=null, refAbstract=null), Reference(id=1329456499522384491, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=49, rfOrder=50, authorNames=null, journalName=null, refType=null, unstructuredReference=Perera R M, Oetomo B, Rubinstein B I P, et al. DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees [C] //Proc of the 37th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2021: 600–611, articleTitle=null, refAbstract=null), Reference(id=1329456499597881964, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=50, rfOrder=51, authorNames=null, journalName=null, refType=null, unstructuredReference=Kossmann J, Kastius A, Schlosser R. SWIRL: Selection of workload-aware indexes using reinforcement learning [C/OL] //Proc of the 25th Int Conf on Extending Database Technology. 2022[2022-12-01].https://openproceedings.org/2022/conf/edbt/, articleTitle=null, refAbstract=null), Reference(id=1329456499669185133, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=51, rfOrder=52, authorNames=null, journalName=null, refType=null, unstructuredReference=Zhou Xuanhe, Liu Luyang, Li Wenbo, et al. AutoIndex: An incremental index management system for dynamic workloads [C] //Proc of the 38th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2022: 2196–2208, articleTitle=null, refAbstract=null), Reference(id=1329456499753071214, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=52, rfOrder=53, authorNames=null, journalName=null, refType=null, unstructuredReference=Dash D, Polyzotis N, Ailamaki A. CoPhy: A scalable, portable, and interactive index advisor for large workloads[J]. Proceedings of the VLDB Endowment, 2011, 4(6): 362−372, articleTitle=null, refAbstract=null), Reference(id=1329456499832762991, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=53, rfOrder=54, authorNames=null, journalName=null, refType=null, unstructuredReference=Jain S, Howe B, Yan Jiaqi, et al. Query2Vec: An evaluation of NLP techniques for generalized workload analytics [J]. arXiv preprint, arXiv: 1801.05613, 2018, articleTitle=null, refAbstract=null), Reference(id=1329456499904066160, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=54, rfOrder=55, authorNames=null, journalName=null, refType=null, unstructuredReference=Chaudhuri S, Ganesan P, Narasayya V R. Primitives for workload summarization and implications for SQL [C] //Proc of the 29th Int Conf on Very Large Data Bases. San Diego, CA: Morgan Kaufmann, 2003: 730–741, articleTitle=null, refAbstract=null), Reference(id=1329456499987952241, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=55, rfOrder=56, authorNames=null, journalName=null, refType=null, unstructuredReference=Kul G, Luong D, Xie T, et al. Ettu: Analyzing query intents in corporate databases [C] //Proc of the 25th Int Conf Companion on World Wide Web. Geneva: Int World Wide Web Conf Steering Committee, 2016: 463−466, articleTitle=null, refAbstract=null), Reference(id=1329456500084421234, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=56, rfOrder=57, authorNames=null, journalName=null, refType=null, unstructuredReference=Whang K Y, Wiederhold, Sagalowicz. Separability—An approach to physical database design[J]. IEEE Transactions on Computers, 1984, 33(3): 209−222, articleTitle=null, refAbstract=null), Reference(id=1329456500159918707, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=57, rfOrder=58, authorNames=null, journalName=null, refType=null, unstructuredReference=Choenni S, Blanken H M, Chang T. On the selection of secondary indices in relational databases[J]. Data & Knowledge Engineering, 1993, 11(3): 207−233, articleTitle=null, refAbstract=null), Reference(id=1329456500239610484, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=58, rfOrder=59, authorNames=null, journalName=null, refType=null, unstructuredReference=Papadomanolakis S, Dash D, Ailamaki A. Efficient use of the query optimizer for automated physical design [C] //Proc of the 33rd Int Conf on Very Large Data Bases. New York: ACM, 2007: 1093–1104, articleTitle=null, refAbstract=null), Reference(id=1329456500306719349, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=59, rfOrder=60, authorNames=null, journalName=null, refType=null, unstructuredReference=Papadomanolakis S, Ailamaki A. An integer linear programming approach to database design [C] //Proc of the 23rd Int Conf on Data Engineering Workshop. Piscataway, NJ: IEEE, 2007: 442–449, articleTitle=null, refAbstract=null), Reference(id=1329456500365439606, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=60, rfOrder=61, authorNames=null, journalName=null, refType=null, unstructuredReference=Chaudhuri S, Narasayya V. Anytime algorithm of database tuning advisor for Microsoft SQL Server [EB/OL]. [2020–11–11]. https://www.microsoft.com/en-us/research/publication/anytime-algorithm-of-database-tuning-advisor-for-microsoft-sql-server/, articleTitle=null, refAbstract=null), Reference(id=1329456500424159863, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=61, rfOrder=62, authorNames=null, journalName=null, refType=null, unstructuredReference=Konig A C, Nabar S U. Scalable exploration of physical database design [C] //Proc of the 22nd Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2006: 37–37, articleTitle=null, refAbstract=null), Reference(id=1329456500503851640, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=62, rfOrder=63, authorNames=null, journalName=null, refType=null, unstructuredReference=孟小峰,马超红,杨晨. 机器学习化数据库系统研究综述[J]. 计算机研究与发展,2019,56(9):1803−1820, articleTitle=null, refAbstract=null), Reference(id=1329456500570960505, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=62, rfOrder=64, authorNames=null, journalName=null, refType=null, unstructuredReference=Meng Xiaofeng, Ma Chaohong, Yang Chen. Survey on machine learning for database systems[J]. Journal of Computer Research and Development, 2019, 56(9): 1803−1820 (in Chinese), articleTitle=null, refAbstract=null), Reference(id=1329456500633875066, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=63, rfOrder=65, authorNames=null, journalName=null, refType=null, unstructuredReference=Leis V, Gubichev A, Mirchev A, et al. How good are query optimizers, really?[J]. Proceedings of the VLDB Endowment, 2015, 9(3): 204−215, articleTitle=null, refAbstract=null), Reference(id=1329456500709372539, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=64, rfOrder=66, authorNames=null, journalName=null, refType=null, unstructuredReference=Wang Xiaoying, Qu Changbo, Wu Weiyuan, et al. Are we ready for learned cardinality estimation?[J]. Proceedings of the VLDB Endowment, 2021, 14(9): 1640−1654, articleTitle=null, refAbstract=null), Reference(id=1329456500789064316, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=65, rfOrder=67, authorNames=null, journalName=null, refType=null, unstructuredReference=Kipf A, Kipf T, Radke B, et al. Learned cardinalities: Estimating correlated joins with deep learning [C/OL] //Proc of the 9th Biennial Conf on Innovative Data Systems Research. 2019[2022-09-01]. https://www.cidrdb.org/cidr2019/, articleTitle=null, refAbstract=null), Reference(id=1329456500872950397, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=66, rfOrder=68, authorNames=null, journalName=null, refType=null, unstructuredReference=Sun Ji, Li Guoliang. An end-to-end learning-based cost estimator[J]. Proceedings of the VLDB Endowment, 2019, 13(3): 307−319, articleTitle=null, refAbstract=null), Reference(id=1329456500969419390, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=67, rfOrder=69, authorNames=null, journalName=null, refType=null, unstructuredReference=Siddiqui T, Wu Wentao, Narasayya V, et al. DISTILL: Low-overhead data-driven techniques for filtering and costing indexes for scalable index tuning[J]. Proceedings of the VLDB Endowment, 2022, 15(10): 2019−2031, articleTitle=null, refAbstract=null), Reference(id=1329456501036528255, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=68, rfOrder=70, authorNames=null, journalName=null, refType=null, unstructuredReference=Gao Jianling, Zhao Nan, Wang Ning, et al. Automatic index selection with learned cost estimator[J]. Information Sciences, 2022, 612: 706−723, articleTitle=null, refAbstract=null), Reference(id=1329456501103637120, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=69, rfOrder=71, authorNames=null, journalName=null, refType=null, unstructuredReference=Yuan Haitao, Li Guoliang, Feng Ling, et al. Automatic view generation with deep learning and reinforcement learning [C] //Proc of the 36th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2020: 1501–1512, articleTitle=null, refAbstract=null), Reference(id=1329456502714249857, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=70, rfOrder=72, authorNames=null, journalName=null, refType=null, unstructuredReference=Kimura H, Huo G, Rasin A, et al. CORADD: Correlation aware database designer for materialized views and indexes[J]. Proceedings of the VLDB Endowment, 2010, 3(1/2): 1103−1113, articleTitle=null, refAbstract=null), Reference(id=1329456502806524546, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=71, rfOrder=73, authorNames=null, journalName=null, refType=null, unstructuredReference=Bruno N, Chaudhuri S. An online approach to physical design tuning [C] //Proc of the 23rd Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2007: 826–835, articleTitle=null, refAbstract=null), Reference(id=1329456502894604931, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=72, rfOrder=74, authorNames=null, journalName=null, refType=null, unstructuredReference=Bruno N, Chaudhuri S. Constrained physical design tuning[J]. Proceedings of the VLDB Endowment, 2008, 1(1): 4−15, articleTitle=null, refAbstract=null), Reference(id=1329456502982685316, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=73, rfOrder=75, authorNames=null, journalName=null, refType=null, unstructuredReference=Caprara A, Fischetti M, Maio D. Exact and approximate algorithms for the index selection problem in physical database design[J]. IEEE Transactions on Knowledge and Data Engineering, 1995, 7(6): 955−967, articleTitle=null, refAbstract=null), Reference(id=1329456503074960005, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=74, rfOrder=76, authorNames=null, journalName=null, refType=null, unstructuredReference=Frank M R, Omiecinski E, Navathe S B. Adaptive and automated index selection in RDBMS [G]//LNCS 580: Proc of the 3rd Int Conf on Extending Database Technology. Berlin: Springer, 1992: 277–292, articleTitle=null, refAbstract=null), Reference(id=1329456503137874566, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=75, rfOrder=77, authorNames=null, journalName=null, refType=null, unstructuredReference=Gurobi. Gurobi optimizer [EB/OL]. [2022-09-01].https://www.gurobi.com, articleTitle=null, refAbstract=null), Reference(id=1329456503217566343, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=76, rfOrder=78, authorNames=null, journalName=null, refType=null, unstructuredReference=IBM. IBM ILOG CPLEX optimizer [EB/OL]. [2022-09-01].https://www.ibm.com/products/ilog-cplex-optimization-studio/cplex-optimizer, articleTitle=null, refAbstract=null), Reference(id=1329456503293063816, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=77, rfOrder=79, authorNames=null, journalName=null, refType=null, unstructuredReference=Li Guoliang, Zhou Xuanhe, Li Shifu, et al. QTune: A query-aware database tuning system with deep reinforcement learning[J]. Proceedings of the VLDB Endowment, 2019, 12(12): 2118−2130, articleTitle=null, refAbstract=null), Reference(id=1329456503393727113, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=78, rfOrder=80, authorNames=null, journalName=null, refType=null, unstructuredReference=Zhang Ji, Zhou Ke, Li Guoliang, et al. CDBTune+: An efficient deep reinforcement learning-based automatic cloud database tuning system[J]. The VLDB Journal, 2021, 30(6): 959−987, articleTitle=null, refAbstract=null), Reference(id=1329456503469224586, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=79, rfOrder=81, authorNames=null, journalName=null, refType=null, unstructuredReference=Hilprecht B, Binnig C, Roehm U. Learning a partitioning advisor with deep reinforcement learning [J]. arXiv preprint, arXiv: 1904.01279, 2019, articleTitle=null, refAbstract=null), Reference(id=1329456503532139147, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=80, rfOrder=82, authorNames=null, journalName=null, refType=null, unstructuredReference=Heitz J, Stockinger K. Join query optimization with deep reinforcement learning algorithms [J]. arXiv preprint, arXiv: 1911.11689, 2019, articleTitle=null, refAbstract=null), Reference(id=1329456503603442316, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=81, rfOrder=83, authorNames=null, journalName=null, refType=null, unstructuredReference=Krishnan S, Yang Z, Goldberg K, et al. Learning to optimize join queries with deep reinforcement learning [J]. arXiv preprint, arXiv: 1808.03196, 2019, articleTitle=null, refAbstract=null), Reference(id=1329456503691522701, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=82, rfOrder=84, authorNames=null, journalName=null, refType=null, unstructuredReference=Marcus R, Papaemmanouil O. Deep reinforcement learning for join order enumeration [C/OL] //Proc of the 1st Int Workshop on Exploiting Artificial Intelligence Techniques for Data Management. New York: ACM, 2018[2020-09-01].https://dl.acm.org/doi/10.1145/3211954.3211957, articleTitle=null, refAbstract=null), Reference(id=1329456503754437262, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=83, rfOrder=85, authorNames=null, journalName=null, refType=null, unstructuredReference=Liang Xi, Elmore A J, Krishnan S. Opportunistic view materialization with deep reinforcement learning [J]. arXiv preprint, arXiv: 1903.01363, 2019, articleTitle=null, refAbstract=null), Reference(id=1329456503859294863, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=84, rfOrder=86, authorNames=null, journalName=null, refType=null, unstructuredReference=Basu D, Lin Qian, Chen Weidong, et al. Regularized cost-model oblivious database tuning with reinforcement learning [J]. Transactions on Large-Scale Data-and Knowledge-Centered Systems XXVIII. Berlin: Springer, 2016: 96–132, articleTitle=null, refAbstract=null), Reference(id=1329456503947375248, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=85, rfOrder=87, authorNames=null, journalName=null, refType=null, unstructuredReference=Sharma A, Schuhknecht F M, Dittrich J. The case for automatic database administration using deep reinforcement learning [J]. arXiv preprint, arXiv: 1801.05643, 2018, articleTitle=null, refAbstract=null), Reference(id=1329456504035455633, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=86, rfOrder=88, authorNames=null, journalName=null, refType=null, unstructuredReference=Lan Hai, Bao Zhifeng, Peng Yuwei. An index advisor using deep reinforcement learning [C] //Proc of the 29th ACM Int Conf on Information and Knowledge Management. New York: ACM, 2020: 2105–2108, articleTitle=null, refAbstract=null), Reference(id=1329456504102564498, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=87, rfOrder=89, authorNames=null, journalName=null, refType=null, unstructuredReference=Lai Sichao, Wu Xiaoying, Wang Senyang, et al. Learning an index advisor with deep reinforcement learning [G] // LNISA 12859: Proc of the 5th APWeb and WAIM Joint Int Conf on Web and Big Data. Berlin: Springer, 2021: 178–185, articleTitle=null, refAbstract=null), Reference(id=1329456504165479059, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=88, rfOrder=90, authorNames=null, journalName=null, refType=null, unstructuredReference=Wu Wentao, Wang Chi, Siddiqui T, et al. Budget-aware index tuning with reinforcement learning [C] //Proc of the 2022 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2022: 1528–1541, articleTitle=null, refAbstract=null), Reference(id=1329456504270336660, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=89, rfOrder=91, authorNames=null, journalName=null, refType=null, unstructuredReference=Schaarschmidt M, Kuhnle A, Ellis B, et al. LIFT: Reinforcement learning in computer systems by learning from demonstrations [J]. arXiv preprint, arXiv: 1808.07903, 2018, articleTitle=null, refAbstract=null), Reference(id=1329456504333251221, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=90, rfOrder=92, authorNames=null, journalName=null, refType=null, unstructuredReference=Sutton R S, Barto A G. Reinforcement Learning: An Introduction [M]. 2nd ed. Cambridge, MA: MIT Press, 2018, articleTitle=null, refAbstract=null), Reference(id=1329456504396165782, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=91, rfOrder=93, authorNames=null, journalName=null, refType=null, unstructuredReference=Licks G P, Couto J C, Miehe P F, et al. SmartIX: A database indexing agent based on reinforcement learning[J]. Applied Intelligence, 2020, 50(8): 2575−2588, articleTitle=null, refAbstract=null), Reference(id=1329456504501023383, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=92, rfOrder=94, authorNames=null, journalName=null, refType=null, unstructuredReference=Mnih V, Kavukcuoglu K, Silver D, et al. Playing Atari with deep reinforcement learning [J]. arXiv preprint, arXiv: 1312.5602, 2013, articleTitle=null, refAbstract=null), Reference(id=1329456504584909464, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=93, rfOrder=95, authorNames=null, journalName=null, refType=null, unstructuredReference=TPC. TPC-H benchmark [EB/OL]. [2022-09-01].https://www.tpc.org/tpch, articleTitle=null, refAbstract=null), Reference(id=1329456504685572761, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=94, rfOrder=96, authorNames=null, journalName=null, refType=null, unstructuredReference=TPC. TPC-DS benchmark [EB/OL]. [2022-09-01].https://www.tpc.org/tpcds, articleTitle=null, refAbstract=null), Reference(id=1329456504811401882, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=95, rfOrder=97, authorNames=null, journalName=null, refType=null, unstructuredReference=Schnaitter K, Polyzotis N. A benchmark for online index selection [C] //Proc of the 25th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2009: 1701–1708, articleTitle=null, refAbstract=null), Reference(id=1329456504928842395, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=96, rfOrder=98, authorNames=null, journalName=null, refType=null, unstructuredReference=Stillger M, Lohman G M, Markl V, et al. LEO-DB2’s learning optimizer [C] //Proc of the 27th Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 2001: 19–28, articleTitle=null, refAbstract=null), Reference(id=1329456505008534172, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=97, rfOrder=99, authorNames=null, journalName=null, refType=null, unstructuredReference=Holze M, Ritter N. Towards workload shift detection and prediction for autonomic databases [C]//Proc of the 1st ACM PhD Workshop in CIKM. New York: ACM, 2007: 109–116, articleTitle=null, refAbstract=null), Reference(id=1329456505100808861, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=98, rfOrder=100, authorNames=null, journalName=null, refType=null, unstructuredReference=Schnaitter K, Polyzotis N. Semi-automatic index tuning: Keeping DBAs in the loop[J]. Proceedings of the VLDB Endowment, 2012, 5(5): 478−489, articleTitle=null, refAbstract=null), Reference(id=1329456505167917726, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=99, rfOrder=101, authorNames=null, journalName=null, refType=null, unstructuredReference=Bruno N, Chaudhuri S. Interactive physical design tuning [C] //Proc of the 26th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2010: 1161–1164, articleTitle=null, refAbstract=null), Reference(id=1329456505272775327, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=100, rfOrder=102, authorNames=null, journalName=null, refType=null, unstructuredReference=Chaudhuri S, Konig A C, Narasayya V. SQLCM: A continuous monitoring framework for relational database engines [C] //Proc of the 20th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2004: 473–484, articleTitle=null, refAbstract=null), Reference(id=1329456505369244320, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=101, rfOrder=103, authorNames=null, journalName=null, refType=null, unstructuredReference=Thiem A, Sattler K U. An integrated approach to performance monitoring for autonomous tuning [C] //Proc of the 25th Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2009: 1671–1678, articleTitle=null, refAbstract=null), Reference(id=1329456505465713313, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=102, rfOrder=104, authorNames=null, journalName=null, refType=null, unstructuredReference=Calzarossa M, Serazzi G. Workload characterization: A survey[J]. Proceedings of the IEEE, 1993, 81(8): 1136−1150, articleTitle=null, refAbstract=null), Reference(id=1329456505541210786, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=103, rfOrder=105, authorNames=null, journalName=null, refType=null, unstructuredReference=Yu P S, Chen M S, Heiss H U, et al. On workload characterization of relational database environments[J]. IEEE Transactions on Software Engineering, 1992, 18(4): 347−355, articleTitle=null, refAbstract=null), Reference(id=1329456505637679779, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=104, rfOrder=106, authorNames=null, journalName=null, refType=null, unstructuredReference=Elnaffar S, Martin P, Schiefer B, et al. Is it DSS or OLTP: Automatically identifying DBMS workloads[J]. Journal of Intelligent Information Systems, 2008, 30(3): 249−271, articleTitle=null, refAbstract=null), Reference(id=1329456507252486822, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=105, rfOrder=107, authorNames=null, journalName=null, refType=null, unstructuredReference=Wasserman T J, Martin P, Skillicorn D B, et al. Developing a characterization of business intelligence workloads for sizing new database systems [C] //Proc of the 7th ACM Int Workshop on Data Warehousing and OLAP. New York: ACM, 2004: 7–13, articleTitle=null, refAbstract=null), Reference(id=1329456507340567207, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=106, rfOrder=108, authorNames=null, journalName=null, refType=null, unstructuredReference=Jain S, Yan Jiaqi, Cruanes T, et al. Database-agnostic workload management [C/OL] //Proc of the 9th Biennial Conf on Innovative Data Systems Research. 2019[2022-09-01]. www. cidrdb. org/cidr2019/, articleTitle=null, refAbstract=null), Reference(id=1329456507420258984, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=107, rfOrder=109, authorNames=null, journalName=null, refType=null, unstructuredReference=Paul D, Cao Jie, Li Feifei, et al. Database workload characterization with query plan encoders[J]. Proceedings of the VLDB Endowment, 2021, 15(4): 923−935, articleTitle=null, refAbstract=null), Reference(id=1329456507487367849, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=108, rfOrder=110, authorNames=null, journalName=null, refType=null, unstructuredReference=Elnaffar S S, Martin P. An intelligent framework for predicting shifts in the workloads of autonomic database management systems [C/OL] //Proc of the 2004 IEEE Int Conf on Advances in Intelligent Systems–Theory and Applications. Los Alamitos, CA. IEEE Computer Society, 2004[2022-09-01].https://research.cs.queensu.ca/home/cords2/aista04.pdf, articleTitle=null, refAbstract=null), Reference(id=1329456507558671018, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=109, rfOrder=111, authorNames=null, journalName=null, refType=null, unstructuredReference=Holze M, Ritter N. Autonomic databases: Detection of workload shifts with n-Gram-Models [G] // LNISA 5207: Proc of the 12th East European Conf on Advances in Databases and Information Systems. Berlin: Springer, 2008: 127–142, articleTitle=null, refAbstract=null), Reference(id=1329456507642557099, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=110, rfOrder=112, authorNames=null, journalName=null, refType=null, unstructuredReference=Huang Xiangji, Peng Fuchun, An Aijun, et al. Dynamic web log session identification with statistical language models[J]. Journal of the American Society for Information Science and Technology, 2004, 55(14): 1290−1303, articleTitle=null, refAbstract=null), Reference(id=1329456507747414700, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=111, rfOrder=113, authorNames=null, journalName=null, refType=null, unstructuredReference=Yao Qingsong, An Aijun, Huang Xiangqi. Finding and analyzing database user sessions [G] // LNISA 3453: Proc of the 10th Int Conf on Database Systems for Advanced Applications. Berlin: Springer, 2005: 851–862, articleTitle=null, refAbstract=null), Reference(id=1329456507818717869, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=112, rfOrder=114, authorNames=null, journalName=null, refType=null, unstructuredReference=Luhring M, Sattler K U, Schmidt K, et al. Autonomous management of soft indexes [C] //Proc of the 23rd Int Conf on Data Engineering Workshop. Piscataway, NJ: IEEE, 2007: 450–458, articleTitle=null, refAbstract=null), Reference(id=1329456507927769774, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=113, rfOrder=115, authorNames=null, journalName=null, refType=null, unstructuredReference=Sattler K U, Geist I, Schallehn E. QUIET: Continuous query-driven index tuning [C] //Proc of the 29th Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 2003: 1129–1132, articleTitle=null, refAbstract=null), Reference(id=1329456508007461551, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=114, rfOrder=116, authorNames=null, journalName=null, refType=null, unstructuredReference=Deerwester S, Dumais S T, Furnas G W, et al. Indexing by latent semantic analysis[J]. Journal of the American Society for Information Science, 1990, 41(6): 391−407, articleTitle=null, refAbstract=null), Reference(id=1329456508074570416, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=115, rfOrder=117, authorNames=null, journalName=null, refType=null, unstructuredReference=Agrawal S, Chu E, Narasayya V. Automatic physical design tuning: workload as a sequence [C] //Proc of the 2006 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2006: 683–694, articleTitle=null, refAbstract=null), Reference(id=1329456508158456497, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=116, rfOrder=118, authorNames=null, journalName=null, refType=null, unstructuredReference=Kimura H, Coffrin C, Rasin A, et al. Optimizing index deployment order for evolving OLAP [C] //Proc of the 15th Int Conf on Extending Database Technology. New York: ACM, 2012: 276–287, articleTitle=null, refAbstract=null), Reference(id=1329456508238148274, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=117, rfOrder=119, authorNames=null, journalName=null, refType=null, unstructuredReference=Agrawal S, Chaudhuri S, Narasayya V R. Automated selection of materialized views and indexes in SQL databases [C] //Proc of the 26th Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 2000: 496–505, articleTitle=null, refAbstract=null), Reference(id=1329456508326228659, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=118, rfOrder=120, authorNames=null, journalName=null, refType=null, unstructuredReference=Microsoft. AutoAdmin project [EB/OL]. [2022-09-01].https://www.microsoft.com/research/project/autoadmin, articleTitle=null, refAbstract=null), Reference(id=1329456508405920436, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=119, rfOrder=121, authorNames=null, journalName=null, refType=null, unstructuredReference=IBM. db2advis: Tools for designing indexes [EB/OL]. [2022-09-01].https://www.ibm.com/docs/en/db2/11.5?topic=indexes-tools-designing, articleTitle=null, refAbstract=null), Reference(id=1329456508502389429, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=120, rfOrder=122, authorNames=null, journalName=null, refType=null, unstructuredReference=Percona. pt-index-usage: Percona toolkit documentation [EB/OL]. [2022-09-01].https://docs.percona.com/percona-toolkit/pt-index-usage.html, articleTitle=null, refAbstract=null), Reference(id=1329456508733076150, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=121, rfOrder=123, authorNames=null, journalName=null, refType=null, unstructuredReference=ankane. dexter: The automatic indexer for Postgres [EB/OL]. [2022-09-01].https://github.com/ankane/dexter, articleTitle=null, refAbstract=null), Reference(id=1329456508871488183, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=122, rfOrder=124, authorNames=null, journalName=null, refType=null, unstructuredReference=powa-team. PoWA: PostgreSQL workload analyzer [EB/OL]. [2022-09-01].https://github.com/powa-team/powa, articleTitle=null, refAbstract=null), Reference(id=1329456508946985656, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=123, rfOrder=125, authorNames=null, journalName=null, refType=null, unstructuredReference=Duboce Labs, Inc. Index advisor (in-app in pganalyze) [EB/OL]. [2022-09-01].https://pganalyze.com/docs/index-advisor, articleTitle=null, refAbstract=null), Reference(id=1329456509014094521, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=124, rfOrder=126, authorNames=null, journalName=null, refType=null, unstructuredReference=EnterpriseDB. EDB Postgres advanced server guide: Index advisor [EB/OL]. [2022-09-01].https://www.enterprisedb.com/docs/epas/latest/epas_guide/03_database_administration/02_index_advisor, articleTitle=null, refAbstract=null), Reference(id=1329456509085397690, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=125, rfOrder=127, authorNames=null, journalName=null, refType=null, unstructuredReference=EverSQL. Online PostgreSQL/MySQL index advisor: Automatic indexing recommendations [EB/OL]. [2022-09-01].https://www.eversql.com/index-advisor-automatic-indexing-recommendations/, articleTitle=null, refAbstract=null), Reference(id=1329456509165089467, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=126, rfOrder=128, authorNames=null, journalName=null, refType=null, unstructuredReference=Oracle. Oracle database performance tuning guide: Release 21 [EB/OL]. [2022-09-01]. https://docs.oracle.com/en/database/oracle/oracle-database/21/tdppt/index.html, articleTitle=null, refAbstract=null), Reference(id=1329456509290918588, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=127, rfOrder=129, authorNames=null, journalName=null, refType=null, unstructuredReference=Microsoft. Automatic tuning [EB/OL]. [2022-09-01]. https://learn.microsoft.com/sql/relational-databases/automatic-tuning/automatic-tuning, articleTitle=null, refAbstract=null), Reference(id=1329456509366416061, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=128, rfOrder=130, authorNames=null, journalName=null, refType=null, unstructuredReference=openGauss. Index advisor: Index recommendation [EB/OL]. [2023-01-25]. https://docs.opengauss.org/en/docs/3.1.0/docs/Developerguide/index-advisor-index-recommendation.html, articleTitle=null, refAbstract=null), Reference(id=1329456509500633790, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=129, rfOrder=131, authorNames=null, journalName=null, refType=null, unstructuredReference=OtterTune. Index recommendations [EB/OL]. [2023-01-25].https://docs.ottertune.com/documentation/database-instance-dashboard-and-recommendations/recommendations/index-recommendations, articleTitle=null, refAbstract=null), Reference(id=1329456509567742655, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=130, rfOrder=132, authorNames=null, journalName=null, refType=null, unstructuredReference=Alibaba Cloud. Database autonomy service [EB/OL]. [2023-01-25].https://www.alibabacloud.com/help/en/database-autonomy-service, articleTitle=null, refAbstract=null), Reference(id=1329456509643240128, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=131, rfOrder=133, authorNames=null, journalName=null, refType=null, unstructuredReference=Microsoft. Azure SQL — Family of SQL cloud databases [DB/OL]. [2022-09-01].https://azure.microsoft.com/en-us/products/azure-sql/, articleTitle=null, refAbstract=null), Reference(id=1329456509706154689, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=132, rfOrder=134, authorNames=null, journalName=null, refType=null, unstructuredReference=Oracle. Oracle Exadata [DB/OL]. [2022-09-01].https://www.oracle.com/engineered-systems/exadata, articleTitle=null, refAbstract=null), Reference(id=1329456509785846466, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=133, rfOrder=135, authorNames=null, journalName=null, refType=null, unstructuredReference=IBM. IBM Cloud database solutions [DB/OL]. [2022-09-01].https://www.ibm.com/cloud/databases, articleTitle=null, refAbstract=null), Reference(id=1329456509861343939, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=134, rfOrder=136, authorNames=null, journalName=null, refType=null, unstructuredReference=Kraska T, Alizadeh M, Beutel A, et al. SageDB: A learned database system [C/OL] //Proc of the 9th Biennial Conf on Innovative Data Systems Research. 2019[2022-09-01]. http://www.cidrdb.org/cidr2019, articleTitle=null, refAbstract=null), Reference(id=1329456509928452804, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=135, rfOrder=137, authorNames=null, journalName=null, refType=null, unstructuredReference=Marcus R, Negi P, Mao Hongzi, et al. Bao: Making learned query optimization practical[J]. ACM SIGMOD Record, 2022, 51(1): 6−13, articleTitle=null, refAbstract=null), Reference(id=1329456510008144581, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=136, rfOrder=138, authorNames=null, journalName=null, refType=null, unstructuredReference=Chockchowwat S. Tuning hierarchical learned indexes on disk and beyond [C] //Proc of the 2022 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2022: 2515–2517, articleTitle=null, refAbstract=null), Reference(id=1329456510087836358, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=137, rfOrder=139, authorNames=null, journalName=null, refType=null, unstructuredReference=Abu-Libdeh H, Altınbüken D, Beutel A, et al. Learned indexes for a Google-scale disk-based database [J]. arXiv preprint, arXiv: 2012.12501, 2020, articleTitle=null, refAbstract=null)], funds=null, companyList=[AuthorCompany(id=1329456489779016202, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, xref=1, ext=[AuthorCompanyExt(id=1329456489787404811, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Computer Science, Wuhan University, Wuhan 430072), AuthorCompanyExt(id=1329456489799987724, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489779016202, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1武汉大学计算机学院 武汉 430072)]), AuthorCompany(id=1329456489879679501, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, xref=2, ext=[AuthorCompanyExt(id=1329456489883873806, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489879679501, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2Big Data Institute, Wuhan University, Wuhan 430072), AuthorCompanyExt(id=1329456489892262415, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, companyId=1329456489879679501, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2武汉大学大数据研究院 武汉 430072)])], figs=[ArticleFig(id=1329456491599344175, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, label=Figure 1, caption=
Search-based index selection framework, figureFileSmall=kKwBWtOf0vzSB6MXPr90NA==, figureFileBig=tU8mAbf9berxF3o43xSMhg==, tableContent=null), ArticleFig(id=1329456491658064432, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, label=图1, caption=
基于搜索的索引选择框架, figureFileSmall=kKwBWtOf0vzSB6MXPr90NA==, figureFileBig=tU8mAbf9berxF3o43xSMhg==, tableContent=null), ArticleFig(id=1329456491863585329, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, label=Figure 2, caption=
The search for the best index configuration, figureFileSmall=uKFlsX//CrxzSpi7UHqK+w==, figureFileBig=jSWZ8edDC9F48avT1eIyCQ==, tableContent=null), ArticleFig(id=1329456491922305586, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, label=图2, caption=
最优索引配置的搜索, figureFileSmall=uKFlsX//CrxzSpi7UHqK+w==, figureFileBig=jSWZ8edDC9F48avT1eIyCQ==, tableContent=null), ArticleFig(id=1329456491993608755, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, label=Figure 3, caption=
Classification of related ISP methods, figureFileSmall=cIVi/INm+AKfB0btzMHPyA==, figureFileBig=L0dsEftQG5JxiIbdKqMlnw==, tableContent=null), ArticleFig(id=1329456492048134709, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, label=图3, caption=
索引选择问题相关方法分类, figureFileSmall=cIVi/INm+AKfB0btzMHPyA==, figureFileBig=L0dsEftQG5JxiIbdKqMlnw==, tableContent=null), ArticleFig(id=1329456492115243573, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, label=Figure 4, caption=
Online index selection framework based on online feedback control loop, figureFileSmall=/akRP87xDimjdOOLCf/o5w==, figureFileBig=WQ7BGVHV9YMz4+zMjwg5BA==, tableContent=null), ArticleFig(id=1329456492178158134, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, label=图4, caption=
基于在线反馈控制回路的在线索引选择框架, figureFileSmall=/akRP87xDimjdOOLCf/o5w==, figureFileBig=WQ7BGVHV9YMz4+zMjwg5BA==, tableContent=null), ArticleFig(id=1329456492241072695, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=EN, label=Table 1, caption=
Comparison of Representative Methods
, figureFileSmall=null, figureFileBig=null, tableContent=
| 方法 | 搜索空间生成 | 配置评价 | 配置形成策略 | 导向指标 | 终止条件 | 索引间影响的考虑 |
|---|
| AutoAdmin[3] | 规则+优化器 | what-if+推导 | 自底向上 | 代价缩减 | 索引数量限额 | 隐式 |
| DB2Advis[11] | 规则+优化器 | what-if | 自底向上 | 每单位存储收益 | 存储空间限额 | 有限 |
| BEN_KNAP[9] | 规则+优化器 | what-if+推导 | 自底向上 | 每单位存储收益 | 存储空间限额 | 显式 |
| Extend[23] | 规则 | what-if | 自底向上 | 每单位存储代价缩减 | 存储空间限额 | 隐式 |
| DROP[39] | 完整 | 外部代价模型 | 自顶向下 | 最低代价 | 最低代价 | 隐式 |
| Relaxation[36] | 优化器 | what-if+推导 | 自顶向下 | 松弛惩罚 | 调优时间限额 | 隐式 |
| CoPhy[52] | 规则 | what-if+推导 | IP | IP | 求解结束 | 隐式 |
| DingIdxAdvis[29] | 规则+优化器 | 机器学习模型 | 自底向上 | 代价缩减 | 索引数量限额 | 隐式 |
| NoDBA[85] | 单列索引 | 实际执行 | 自底向上(RL) | 代价缩减 | 索引数量限额 | 隐式 |
| LanIdxAdvis[86] | 规则 | what-if | 自底向上(RL) | 代价缩减+ε-greedy | 约束破坏 | 隐式 |
| MCTS_IT[88] | 规则+优化器 | what-if+推导 | 自底向上(RL) | 代价缩减+ε-greedy | 索引数量限额 | 隐式 |
), ArticleFig(id=1329456493864268344, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329456485941228021, language=CN, label=表1, caption=
代表性方法对比
, figureFileSmall=null, figureFileBig=null, tableContent=
| 方法 | 搜索空间生成 | 配置评价 | 配置形成策略 | 导向指标 | 终止条件 | 索引间影响的考虑 |
|---|
| AutoAdmin[3] | 规则+优化器 | what-if+推导 | 自底向上 | 代价缩减 | 索引数量限额 | 隐式 |
| DB2Advis[11] | 规则+优化器 | what-if | 自底向上 | 每单位存储收益 | 存储空间限额 | 有限 |
| BEN_KNAP[9] | 规则+优化器 | what-if+推导 | 自底向上 | 每单位存储收益 | 存储空间限额 | 显式 |
| Extend[23] | 规则 | what-if | 自底向上 | 每单位存储代价缩减 | 存储空间限额 | 隐式 |
| DROP[39] | 完整 | 外部代价模型 | 自顶向下 | 最低代价 | 最低代价 | 隐式 |
| Relaxation[36] | 优化器 | what-if+推导 | 自顶向下 | 松弛惩罚 | 调优时间限额 | 隐式 |
| CoPhy[52] | 规则 | what-if+推导 | IP | IP | 求解结束 | 隐式 |
| DingIdxAdvis[29] | 规则+优化器 | 机器学习模型 | 自底向上 | 代价缩减 | 索引数量限额 | 隐式 |
| NoDBA[85] | 单列索引 | 实际执行 | 自底向上(RL) | 代价缩减 | 索引数量限额 | 隐式 |
| LanIdxAdvis[86] | 规则 | what-if | 自底向上(RL) | 代价缩减+ε-greedy | 约束破坏 | 隐式 |
| MCTS_IT[88] | 规则+优化器 | what-if+推导 | 自底向上(RL) | 代价缩减+ε-greedy | 索引数量限额 | 隐式 |
)], 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.202220931, detailUrlEn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/10.7544/issn1000-1239.202220931, pdfUrlCn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/CN/PDF/10.7544/issn1000-1239.202220931, pdfUrlEn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/PDF/10.7544/issn1000-1239.202220931, aliStartDate=0, aliEndDate=0, collectionFlag=false, citedCount=null, citedUrl=null, previewStatus=0, delFlag=0, hasFullText=1, orderTime=1711900800000, fullTextJson=null, articleText=null, reference=null)