Article(id=1329455724637302789, tenantId=1146029695717560320, journalId=1324759914146529478, issueId=1329455653363495339, articleNumber=null, orderNo=null, doi=10.7544/issn1000-1239.202220649, pmid=null, cstr=null, oa=null, hot=null, price=null, onlineType=0, articleFormat=0, articleType=null, articleTypeStr=null, receivedDate=1658592000000, receivedDateStr=2022-07-24, revisedDate=1681833600000, revisedDateStr=2023-04-19, acceptedDate=null, acceptedDateStr=null, onlineDate=1794896544846, onlineDateStr=2026-11-17, pubDate=1706803200000, pubDateStr=2024-02-02, doiRegisterDate=null, doiRegisterDateStr=null, onlineIssueDate=1794896544846, onlineIssueDateStr=2026-11-17, onlineJustAcceptDate=null, onlineJustAcceptDateStr=null, onlineFirstDate=null, onlineFirstDateStr=null, sourceXml=null, magXml=null, createTime=1794896544846, creator=13701087609, updateTime=1794896544846, updator=13701087609, issue=Issue{id=1329455653363495339, tenantId=1146029695717560320, journalId=1324759914146529478, year='2024', volume='61', issue='2', pageStart='273', pageEnd='538', issueExtLink='null', onlineDate='null', pubDate='1706803200000', pubDateStr='2024-02-02', beforeIssueId=null, nextIssueId=null, price=null, status=1, issueComplete=1, articleOrder=1, issueType=-1, specialIssue=null, createTime=1794896527853, creator='13701087609', updateTime=1794896527853, updator='13701087609', preIssue=null, nextIssue=null, articleTotal=null, ext=null, issueFiles=null, downloadFileDto=null}, startPage=413, endPage=427, ext={EN=ArticleExt(id=1329455724809269254, articleId=1329455724637302789, tenantId=1146029695717560320, journalId=1324759914146529478, language=EN, title=Survey of Cardinality Estimation Techniques Based on Machine Learning, columnId=1329455694815802127, journalTitle=Journal of Computer Research and Development, columnName=Artificial Intelligence and Pattern Recognition, runingTitle=null, highlight=null, articleAbstract=
Cardinality estimation is the basis and core of query optimizer for the database management system (DBMS). With the development of artificial intelligence (AI) technology, AI technology has shown superior performance in data processing and extracting the relationship from the data. In recent years, the research of the cardinality estimation method based on machine learning has made significant progress and received wide attention from the academic community. Firstly, we introduce the technical background and development status of cardinality estimation methods based on machine learning. Secondly, we give the definition and the feature encoding technology of the related concepts of cardinality estimation. Then, we expound on the classification structure of cardinality estimation technology from two aspects: traditional cardinality estimation and cardinality estimation based on machine learning. Then, we further subdivide cardinality estimation based on machine learning into three types of cardinality estimation techniques: query-driven, data-driven, and hybrid models. Then, we focus on analyzing the modeling flow, typical methodologies, and characteristics of each type of model. In addition, we analyze and summarize the application of cardinality estimation in SQL and NoSQL. Finally, we discuss the challenges and future research directions on cardinality estimation methods based on machine learning.
, authors=Wenjing Yue
1, 2, Wenwen Qu
1, Kuan Lin
3, Xiaoling Wang
1, *, authorsList=Wenjing Yue, Wenwen Qu, Kuan Lin, Xiaoling Wang, authorCompany=null, correspAuthors=Xiaoling Wang, authorNote=
born in 1996. PhD candidate. Student member of CCF. Her main research interests include database, cardinality estimation techniques, machine learning, and recommender system
born in 1995. PhD candidate. His main research interests include database, graph processing, and distributed graph mining system. (wenwenqu@stu.ecnu.edu.cn)
born in 1982. Master, associate professor. Her main research interest includes signal and information processing. (linkuan@aircas.ac.cn)
born in 1975. PhD, professor, PhD supervisor. Senior member of CCF. Her main research interests include knowledge graph, personalized recommendation, and privacy protection
, 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=1329455726596042775, articleId=1329455724637302789, tenantId=1146029695717560320, journalId=1324759914146529478, language=CN, title=基于机器学习的基数估计技术综述, columnId=1329455694975185681, journalTitle=计算机研究与发展, columnName=人工智能和模式识别, runingTitle=null, highlight=null, articleAbstract=
基数估计是数据库关系系统查询优化器的基础和核心. 随着人工智能技术的发展,其在数据处理、提取数据之间的关系等方面显现出优越的性能. 近年来,基于机器学习的基数估计技术取得了显著的进展,受到了学术界的广泛关注. 首先总结了基于机器学习的技术估计技术的发展现状,其次给出了基数估计的相关概念及其特征编码技术.接着建立了基数估计技术的分类体系.在此基础上,进一步将基于机器学习的基数估计技术细分为查询驱动、数据驱动和混合模型这3类基数估计技术.然后重点分析了每一类技术的建模流程、典型技术和模型特点,并对其在SQL和NoSQL中的应用进行了分析和总结.最后讨论了基于机器学习的基数估计技术面临的挑战和未来的研究方向。
, authors=岳文静
1, 2, 屈稳稳
1, 林宽
3, 王晓玲
1, *, authorsList=岳文静, 屈稳稳, 林宽, 王晓玲, authorCompany=null, correspAuthors=王晓玲, authorNote=
 |
1996年生. 博士研究生. CCF学生会员. 主要研究方向为数据库、基数估计技术、机器学习、推荐系统 |
 |
1995年生. 博士研究生. 主要研究方向为数据库、图计算、分布式图挖掘系统 |
 |
1982年生. 硕士,副研究员. 主要研究方向为信号与信息处理 |
 |
1975年生. 博士,教授,博士生导师. CCF高级会员. 主要研究方向为知识图谱、个性化推荐、隐私保护 |
, correspAuthorsNote=
, copyrightStatement=版权所有 © 2024 计算机研究与发展编辑部, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=cXDXOFpFYvRb15sCxatGmg==, magXml=TbKEPlQ9VqaoEHmY53N8dg==, pdfUrl=null, pdf=x5MsCbcIDzPMUoMLkBEWmg==, pdfFileSize=1560724, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=9VzI4Xa/URY8UiCEnelH0Q==, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=3pR/XJObDVHMVGF3ZakDxA==, mapNumber=null, fund=null)}, authors=[Author(id=1329455728529616930, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, orderNo=0, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=wjyue@stu.ecnu.edu.cn, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1329455728600920101, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, authorId=1329455728529616930, language=EN, stringName=Wenjing Yue, firstName=Wenjing, middleName=null, lastName=Yue, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, 2, address=
1School of Computer Science and Technology, East China Normal University, Shanghai 200062
2Shanghai Institute of AI for Education, East China Normal University, Shanghai 200062, bio={"content":"
born in 1996. PhD candidate. Student member of CCF. Her main research interests include database, cardinality estimation techniques, machine learning, and recommender system
"}, bioImg=null, bioContent=
born in 1996. PhD candidate. Student member of CCF. Her main research interests include database, cardinality estimation techniques, machine learning, and recommender system
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455728697389094, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, authorId=1329455728529616930, 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华东师范大学计算机科学与技术学院 上海 200062
2华东师范大学上海智能教育研究院 上海 200062, bio={"img":"iyDcpycKiEERzkP0yOSfSQ==","content":"
1996年生. 博士研究生. CCF学生会员. 主要研究方向为数据库、基数估计技术、机器学习、推荐系统
"}, bioImg=iyDcpycKiEERzkP0yOSfSQ==, bioContent=
1996年生. 博士研究生. CCF学生会员. 主要研究方向为数据库、基数估计技术、机器学习、推荐系统
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455726885449752, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, xref=1, ext=[AuthorCompanyExt(id=1329455726893838361, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455726885449752, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Computer Science and Technology, East China Normal University, Shanghai 200062), AuthorCompanyExt(id=1329455726902226970, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455726885449752, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1华东师范大学计算机科学与技术学院 上海 200062)]), AuthorCompany(id=1329455728345067547, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, xref=2, ext=[AuthorCompanyExt(id=1329455728353456156, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455728345067547, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2Shanghai Institute of AI for Education, East China Normal University, Shanghai 200062), AuthorCompanyExt(id=1329455728357650461, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455728345067547, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2华东师范大学上海智能教育研究院 上海 200062)])]), Author(id=1329455728777080872, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, orderNo=1, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=wenwenqu@stu.ecnu.edu.cn, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1329455728865161258, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, authorId=1329455728777080872, language=EN, stringName=Wenwen Qu, firstName=Wenwen, middleName=null, lastName=Qu, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, address=
1School of Computer Science and Technology, East China Normal University, Shanghai 200062, bio={"content":"
born in 1995. PhD candidate. His main research interests include database, graph processing, and distributed graph mining system. (wenwenqu@stu.ecnu.edu.cn)
"}, bioImg=null, bioContent=
born in 1995. PhD candidate. His main research interests include database, graph processing, and distributed graph mining system. (wenwenqu@stu.ecnu.edu.cn)
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455728982601771, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, authorId=1329455728777080872, 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华东师范大学计算机科学与技术学院 上海 200062, bio={"img":"7mXhldlrOmbdVXLndVkqFg==","content":"
1995年生. 博士研究生. 主要研究方向为数据库、图计算、分布式图挖掘系统
"}, bioImg=7mXhldlrOmbdVXLndVkqFg==, bioContent=
1995年生. 博士研究生. 主要研究方向为数据库、图计算、分布式图挖掘系统
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455726885449752, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, xref=1, ext=[AuthorCompanyExt(id=1329455726893838361, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455726885449752, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Computer Science and Technology, East China Normal University, Shanghai 200062), AuthorCompanyExt(id=1329455726902226970, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455726885449752, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1华东师范大学计算机科学与技术学院 上海 200062)])]), Author(id=1329455729070682157, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, orderNo=2, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=linkuan@aircas.ac.cn, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1329455729146179631, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, authorId=1329455729070682157, language=EN, stringName=Kuan Lin, firstName=Kuan, middleName=null, lastName=Lin, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
3, address=
3Aerospace Information Research Institute, Chinese Academy of Sciences, Beijing 100190, bio={"content":"
born in 1982. Master, associate professor. Her main research interest includes signal and information processing. (linkuan@aircas.ac.cn)
"}, bioImg=null, bioContent=
born in 1982. Master, associate professor. Her main research interest includes signal and information processing. (linkuan@aircas.ac.cn)
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455729221677104, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, authorId=1329455729070682157, language=CN, stringName=林宽, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
3, address=
3中国科学院空天信息创新研究院 北京 100190, bio={"img":"JmwGe2uPAK/deLV6eN83UA==","content":"
1982年生. 硕士,副研究员. 主要研究方向为信号与信息处理
"}, bioImg=JmwGe2uPAK/deLV6eN83UA==, bioContent=
1982年生. 硕士,副研究员. 主要研究方向为信号与信息处理
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455728437342238, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, xref=3, ext=[AuthorCompanyExt(id=1329455728441536543, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455728437342238, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
3Aerospace Information Research Institute, Chinese Academy of Sciences, Beijing 100190), AuthorCompanyExt(id=1329455728445730848, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455728437342238, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
3中国科学院空天信息创新研究院 北京 100190)])]), Author(id=1329455729301368882, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, orderNo=3, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=xlwang@cs.ecnu.edu.cn, emailSecond=null, emailThird=null, correspondingAuthor=1, authorType=1, ext={EN=AuthorExt(id=1329455729389449268, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, authorId=1329455729301368882, language=EN, stringName=Xiaoling Wang, firstName=Xiaoling, middleName=null, lastName=Wang, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=
1, *, address=
1School of Computer Science and Technology, East China Normal University, Shanghai 200062, bio={"content":"
born in 1975. PhD, professor, PhD supervisor. Senior member of CCF. Her main research interests include knowledge graph, personalized recommendation, and privacy protection
"}, bioImg=null, bioContent=
born in 1975. PhD, professor, PhD supervisor. Senior member of CCF. Her main research interests include knowledge graph, personalized recommendation, and privacy protection
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455729477529653, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, authorId=1329455729301368882, 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华东师范大学计算机科学与技术学院 上海 200062, bio={"img":"Oyi6RnO3MLGC7cSsj4EGmQ==","content":"
1975年生. 博士,教授,博士生导师. CCF高级会员. 主要研究方向为知识图谱、个性化推荐、隐私保护
"}, bioImg=Oyi6RnO3MLGC7cSsj4EGmQ==, bioContent=
1975年生. 博士,教授,博士生导师. CCF高级会员. 主要研究方向为知识图谱、个性化推荐、隐私保护
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455726885449752, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, xref=1, ext=[AuthorCompanyExt(id=1329455726893838361, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455726885449752, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Computer Science and Technology, East China Normal University, Shanghai 200062), AuthorCompanyExt(id=1329455726902226970, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455726885449752, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1华东师范大学计算机科学与技术学院 上海 200062)])])], keywords=[Keyword(id=1329455729603358774, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, orderNo=1, keyword=database), Keyword(id=1329455729704022071, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, orderNo=2, keyword=cardinality estimation), Keyword(id=1329455729783713848, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, orderNo=3, keyword=machine learning), Keyword(id=1329455729838239801, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, orderNo=4, keyword=query optimization), Keyword(id=1329455729917931578, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, orderNo=5, keyword=neural network), Keyword(id=1329455730001817659, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, orderNo=1, keyword=数据库), Keyword(id=1329455730068926524, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, orderNo=2, keyword=基数估计), Keyword(id=1329455730165395517, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, orderNo=3, keyword=机器学习), Keyword(id=1329455730253475902, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, orderNo=4, keyword=查询优化), Keyword(id=1329455730341556287, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, orderNo=5, keyword=神经网络)], refs=[Reference(id=1329455733470507086, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, 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=Lakshmi S, Zhou Shaoyu. Selectivity estimation in extensible databases−A neural network approach[C] //Proc of the 24th Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 1998: 623−627, articleTitle=null, refAbstract=null), Reference(id=1329455733541810255, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, 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=Lu Hongju, Setiono R. Effective query size estimation using neural networks[J]. Applied Intelligence, 2002, 16(3): 173−183, articleTitle=null, refAbstract=null), Reference(id=1329455733608919120, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=3, rfOrder=2, authorNames=null, journalName=null, refType=null, unstructuredReference=Ortiz J, Balazinska M, Gehrke J, et al. Learning state representations for query optimization with deep reinforcement learning[C/OL] //Proc of the 2nd Workshop on Data Management for End-to-End Machine Learning. New York: ACM. 2018[2023-03-08]. https://dl.acm.org/doi/pdf/10.1145/3209889.3209890, articleTitle=null, refAbstract=null), Reference(id=1329455733684416593, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=4, rfOrder=3, authorNames=null, journalName=null, refType=null, unstructuredReference=Woltmann L, Hartmann C, Thiele M, et al. Cardinality estimation with local deep learning models[C/OL] //Proc of the 2nd Int Workshop on Exploiting Artificial Intelligence Techniques for Data Management. New York: ACM, 2019 [2023-03-08]. https://dl.acm.org/doi/10.1145/3329859.3329875, articleTitle=null, refAbstract=null), Reference(id=1329455733768302674, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=5, rfOrder=4, 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[2023-03-08].https://www.cidrdb.org/cidr2019/papers/p101-kipf-cidr19.pdf, articleTitle=null, refAbstract=null), Reference(id=1329455733839605843, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=6, rfOrder=5, authorNames=null, journalName=null, refType=null, unstructuredReference=Ortiz J, Balazinska M, Gehrke J, et al. An empirical analysis of deep learning for cardinality estimation[J]. arXiv preprint, arXiv: 1905. 06425, 2019, articleTitle=null, refAbstract=null), Reference(id=1329455733915103316, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=7, rfOrder=6, authorNames=null, journalName=null, refType=null, unstructuredReference=Malik T, Burns R C, Chawla N V. A black-box approach to query cardinality estimation[C/OL] //Proc of the 3rd Biennial Conf on Innovative Data Systems Research. 2007[2023-03-08]. https://www.cidrdb.org/cidr2007/papers/cidr07p06.pdf, articleTitle=null, refAbstract=null), Reference(id=1329455734032543829, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=8, rfOrder=7, 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=1329455734103846998, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=9, rfOrder=8, authorNames=null, journalName=null, refType=null, unstructuredReference=Dutt A, Wang Chi, Nazi A, et al. Selectivity estimation for range predicates using lightweight models[J]. Proceedings of the VLDB Endowment, 2019, 12(9): 1044−1057, articleTitle=null, refAbstract=null), Reference(id=1329455734191927383, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=10, rfOrder=9, authorNames=null, journalName=null, refType=null, unstructuredReference=Marcus R, Papaemmanouil O. Towards a hands-free query optimizer through deep learning[J]. arXiv preprint, arXiv: 1809. 10212, 2018, articleTitle=null, refAbstract=null), Reference(id=1329455734267424856, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=11, rfOrder=10, authorNames=null, journalName=null, refType=null, unstructuredReference=Liu H, Xu Mingbin, Yu Ziting, et al. Cardinality estimation using neural networks[C] //Proc of the 25th Annual Int Conf on Computer Science and Software Engineering. New York: ACM, 2019: 53−59, articleTitle=null, refAbstract=null), Reference(id=1329455734355505241, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=12, rfOrder=11, authorNames=null, journalName=null, refType=null, unstructuredReference=Liu Jie, Dong Wenqian, Li Dong, et al. Fauce: Fast and accurate deep ensembles with uncertainty for cardinality estimation[J]. Proceedings of the VLDB Endowment, 2021, 14(11): 1950−1963, articleTitle=null, refAbstract=null), Reference(id=1329455734456168538, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=13, rfOrder=12, authorNames=null, journalName=null, refType=null, unstructuredReference=Marcus R, Kipf A, Van Renen A, et al. Flow-loss: Learning cardinality estimates that matter[J]. Proceedings of the VLDB Endowment, 2021, 14(11): 2019−2032, articleTitle=null, refAbstract=null), Reference(id=1329455734535860315, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=14, rfOrder=13, authorNames=null, journalName=null, refType=null, unstructuredReference=Tzoumas K, Deshpande A, Jensen C S. Lightweight graphical models for selectivity estimation without independence assumptions[J]. Proceedings of the VLDB Endowment, 2011, 4(11): 852−863, articleTitle=null, refAbstract=null), Reference(id=1329455734615552092, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=15, rfOrder=14, authorNames=null, journalName=null, refType=null, unstructuredReference=Heimel M, Kiefer M, Markl V. Self-tuning, GPU-accelerated kernel density models for multidimensional selectivity estimation[C] //Proc of the 2015 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2015: 1477−1492, articleTitle=null, refAbstract=null), Reference(id=1329455734716215389, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=16, rfOrder=15, authorNames=null, journalName=null, refType=null, unstructuredReference=Park Y, Zhong Shucheng, Mozafari B. QuickSel: Quick selectivity learning with mixture models[C] //Proc of the 2020 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2020: 1017−1033, articleTitle=null, refAbstract=null), Reference(id=1329455734791712862, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=17, rfOrder=16, authorNames=null, journalName=null, refType=null, unstructuredReference=Yang Zongheng, Liang E, Kamsetty A, et al. Deep unsupervised cardinality estimation[J]. Proceedings of the VLDB Endowment, 2019, 13(3): 279−292, articleTitle=null, refAbstract=null), Reference(id=1329455734913347679, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=18, rfOrder=17, authorNames=null, journalName=null, refType=null, unstructuredReference=Hasan S, Thirumuruganathan S, Augustine J, et al. Deep learning models for selectivity estimation of multi-attribute queries[C] //Proc of the 2020 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2020: 1035−1050, articleTitle=null, refAbstract=null), Reference(id=1329455735005622368, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=19, rfOrder=18, authorNames=null, journalName=null, refType=null, unstructuredReference=Yang Zongheng, Kamsetty A, Luan Sifei, et al. NeuroCard: One cardinality estimator for all tables[J]. Proceedings of the VLDB Endowment, 2021, 14(1): 61−73, articleTitle=null, refAbstract=null), Reference(id=1329455735102091361, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=20, rfOrder=19, authorNames=null, journalName=null, refType=null, unstructuredReference=Hilprecht B, Schmidt A, Kulessa M, et al. DeepDB: Learn from data, not from queries![J]. Proceedings of the VLDB Endowment, 2020, 13(7): 992−1005, articleTitle=null, refAbstract=null), Reference(id=1329455735177588834, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=21, rfOrder=20, authorNames=null, journalName=null, refType=null, unstructuredReference=Zhu Rong, Wu Ziniu, Han Yuxing, et al. FLAT: Fast, lightweight and accurate method for cardinality estimation[J]. arXiv preprint, arXiv: 2011. 09022, 2020, articleTitle=null, refAbstract=null), Reference(id=1329455735320195171, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=22, rfOrder=21, authorNames=null, journalName=null, refType=null, unstructuredReference=Lan Hai, Bao Zhifeng, Peng Yuwei. A survey on advancing the dbms query optimizer: Cardinality estimation, cost model, and plan enumeration[J]. Data Science and Engineering, 2021, 6(1): 86−101, articleTitle=null, refAbstract=null), Reference(id=1329455735395692644, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=23, rfOrder=22, authorNames=null, journalName=null, refType=null, unstructuredReference=Sun Ji, Zhang Jintao, Sun Zhaoyan, et al. Learned cardinality estimation: A design space exploration and a comparative evaluation[J]. Proceedings of the VLDB Endowment, 2021, 15(1): 85−97, articleTitle=null, refAbstract=null), Reference(id=1329455735500550245, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=24, rfOrder=23, 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=1329455735584436326, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=25, rfOrder=24, authorNames=null, journalName=null, refType=null, unstructuredReference=李国良,周煊赫,孙佶,等. 基于机器学习的数据库技术综述[J]. 计算机学报,2020,43(11):2019−2049, articleTitle=null, refAbstract=null), Reference(id=1329455737207631975, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=25, rfOrder=25, authorNames=null, journalName=null, refType=null, unstructuredReference=Li Guoliang, Zhou Xuanhe, Sun Ji, et al. Survey on database technology based on machine learning[J]. Chinese Journal of Computers, 2020, 43(11): 2019−2049 (in Chinese), articleTitle=null, refAbstract=null), Reference(id=1329455737358626920, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=26, rfOrder=26, authorNames=null, journalName=null, refType=null, unstructuredReference=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=1329455737450901609, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=27, rfOrder=27, authorNames=null, journalName=null, refType=null, unstructuredReference=Sun Ji, Li Guoliang, Tang Nan. Learned cardinality estimation for similarity queries[C] // Proc of the 2021 Int Conf on Management of Data. New York: ACM, 2021: 1745−1757, articleTitle=null, refAbstract=null), Reference(id=1329455737513816170, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=28, rfOrder=28, authorNames=null, journalName=null, refType=null, unstructuredReference=Dutt A, Wang Chi, Narasayya V, et al. Efficiently approximating selectivity functions using low overhead regression models[J]. Proceedings of the VLDB Endowment, 2020, 13(11): 2215−2228, articleTitle=null, refAbstract=null), Reference(id=1329455737580925035, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=29, rfOrder=29, authorNames=null, journalName=null, refType=null, unstructuredReference=Acharya J, Diakonikolas I, Hegde C, et al. Fast and near-optimal algorithms for approximating distributions by histograms[C] //Proc of the 34th ACM SIGMOD-SIGACT-SIGAI Symp on Principles of Database Systems. New York: ACM, 2015: 249−263, articleTitle=null, refAbstract=null), Reference(id=1329455737660616812, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=30, rfOrder=30, authorNames=null, journalName=null, refType=null, unstructuredReference=Xu Jia, Zhang Zhenjie, Xiao Xiaokui, et al. Differentially private histogram publication[J]. The VLDB Journal, 2013, 22(6): 797−822, articleTitle=null, refAbstract=null), Reference(id=1329455737731919981, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=31, rfOrder=31, authorNames=null, journalName=null, refType=null, unstructuredReference=Ioannidis Y. The history of histograms (abridged)[C] //Proc of the 29th Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 2003: 19−30, articleTitle=null, refAbstract=null), Reference(id=1329455737790640238, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=32, rfOrder=32, authorNames=null, journalName=null, refType=null, unstructuredReference=Tschorsch F, Scheuermann B. An algorithm for privacy-preserving distributed user statistics[J]. Computer Networks, 2013, 57(14): 2775−2787, articleTitle=null, refAbstract=null), Reference(id=1329455737861943407, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=33, rfOrder=33, authorNames=null, journalName=null, refType=null, unstructuredReference=Flajolet P, Éric F, Gandouet O, et al. HyperLogLog: The analysis of a near-optimal cardinality estimation algorithm[J]. Analysis of Algorithms , 2007: 137−156, articleTitle=null, refAbstract=null), Reference(id=1329455737941635184, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=34, rfOrder=34, authorNames=null, journalName=null, refType=null, unstructuredReference=Alon N, Matias Y, Szegedy M. The space complexity of approximating the frequency moments[J]. Journal of Computer and System Sciences, 1999, 58(1): 137−147, articleTitle=null, refAbstract=null), Reference(id=1329455738012938353, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=35, rfOrder=35, authorNames=null, journalName=null, refType=null, unstructuredReference=Durand M, Flajolet P. Loglog counting of large cardinalities[C] //Proc of the 11th Annual European Symp. Berlin: Springer, 2003: 605−617, articleTitle=null, refAbstract=null), Reference(id=1329455738109407346, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=36, rfOrder=36, authorNames=null, journalName=null, refType=null, unstructuredReference=Wu Wentao, Naughton J F, Singh H. Sampling-based query re-optimization[C] //Proc of the 2016 Int Conf on Management of Data. New York: ACM, 2016: 1721−1736, articleTitle=null, refAbstract=null), Reference(id=1329455738180710515, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=37, rfOrder=37, authorNames=null, journalName=null, refType=null, unstructuredReference=Chen Yun, Yi Ke. Two-level sampling for join size estimation[C] // Proc of the 2017 ACM Int Conf on Management of Data. New York: ACM, 2017: 759−774, articleTitle=null, refAbstract=null), Reference(id=1329455738247819380, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=38, rfOrder=38, authorNames=null, journalName=null, refType=null, unstructuredReference=Leis V, Radke B, Gubichev A, et al. Cardinality estimation done right: Index-based join sampling[C/OL] //Proc of the 8th Biennial Conf on Innovative Data Systems Research. 2017[2023-03-08].https://www.cidrdb.org/cidr2017/papers/p9-leis-cidr17.pdf, articleTitle=null, refAbstract=null), Reference(id=1329455738344288373, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=39, rfOrder=39, authorNames=null, journalName=null, refType=null, unstructuredReference=Lipton R J, Naughton J F, Schneider D A. Practical selectivity estimation through adaptive sampling[C] //Proc of the 1990 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 1990: 1−11, articleTitle=null, refAbstract=null), Reference(id=1329455738432368758, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=40, rfOrder=40, authorNames=null, journalName=null, refType=null, unstructuredReference=Olken F, Rotem D. Random sampling from database files: A survey[C] //Proc of the 5th Int Conf on Scientific and Statistical Database Management. Berlin: Springer, 1990: 92−111, articleTitle=null, refAbstract=null), Reference(id=1329455738520449143, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=41, rfOrder=41, authorNames=null, journalName=null, refType=null, unstructuredReference=Hasan R. Predicting sparql query performance and explaining linked data[C] //Proc of the 11th Int Conf on Semantic Web: Trends and Challenges. Berlin: Springer, 2014: 795−805, articleTitle=null, refAbstract=null), Reference(id=1329455738587558008, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=42, rfOrder=42, authorNames=null, journalName=null, refType=null, unstructuredReference=Zhang W E, Sheng Q Z, Qin Yongrui, et al. Learning-based SPARQL query performance modeling and prediction[J]. World Wide Web, 2018, 21(4): 1015−1035, articleTitle=null, refAbstract=null), Reference(id=1329455738663055481, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=43, rfOrder=43, authorNames=null, journalName=null, refType=null, unstructuredReference=Neumann T, Weikum G. The RDF-3X engine for scalable management of RDF data[J]. The VLDB Journal, 2010, 19(1): 91−113, articleTitle=null, refAbstract=null), Reference(id=1329455738734358650, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=44, rfOrder=44, authorNames=null, journalName=null, refType=null, unstructuredReference=Stocker M, Seaborne A, Bernstein A, et al. SPARQL basic graph pattern optimization using selectivity estimation[C] //Proc of the 17th Int Conf on World Wide Web. New York: ACM, 2008: 595−604, articleTitle=null, refAbstract=null), Reference(id=1329455738797273211, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=45, rfOrder=45, authorNames=null, journalName=null, refType=null, unstructuredReference=Vidal M E, Ruckhaus E, Lampo T, et al. Efficiently joining group patterns in SPARQL queries[C] //Proc of the 7th Extended Semantic Web Conf. Berlin: Springer, 2010: 228−242, articleTitle=null, refAbstract=null), Reference(id=1329455738889547900, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=46, rfOrder=46, authorNames=null, journalName=null, refType=null, unstructuredReference=Huang Hai, Liu Chengfei. Estimating selectivity for joined RDF triple patterns[C] //Proc of the 20th ACM Int Conf on Information and Knowledge Management. New York: ACM, 2011: 1435−1444, articleTitle=null, refAbstract=null), Reference(id=1329455738965045373, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=47, rfOrder=47, authorNames=null, journalName=null, refType=null, unstructuredReference=Davitkova A, Gjurovski D, Michel S. LMKG: Learned models for cardinality estimation in knowledge Graphs[J]. arXiv preprint, arXiv: 2102. 10588, 2021, articleTitle=null, refAbstract=null), Reference(id=1329455739027959934, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=48, rfOrder=48, authorNames=null, journalName=null, refType=null, unstructuredReference=Halford M, Saint-Pierre P, Morvan F. An approach based on Bayesian networks for query selectivity estimation[C] // Proc of the 24th Int Conf on Database Systems for Advanced Applications. Berlin: Springer, 2019: 3−19, articleTitle=null, refAbstract=null), Reference(id=1329455739082485887, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=49, rfOrder=49, authorNames=null, journalName=null, refType=null, unstructuredReference=Liu Qiyu, Shen Yanyan, Chen Lei. LHist: Towards learning multi-dimensional histogram for massive spatial data[C] // Proc of the 37th IEEE Int Conf on Data Engineering. Piscataway, NJ: IEEE, 2021: 1188−1199, articleTitle=null, refAbstract=null), Reference(id=1329455739149594752, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=50, rfOrder=50, authorNames=null, journalName=null, refType=null, unstructuredReference=Kraska T, Beutel A, Chi E H, et al. The case for learned index structures[C] //Proc of the 2018 Int Conf on Management of Data. New York: ACM, 2018: 489−504, articleTitle=null, refAbstract=null), Reference(id=1329455739237675137, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=51, rfOrder=51, authorNames=null, journalName=null, refType=null, unstructuredReference=Muralikrishna M, Dewitt D J. Equi-depth histograms for estimating selectivity factors for multi-dimensional[C] //Proc of the 1988 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 1988: 28−36, articleTitle=null, refAbstract=null), Reference(id=1329455739321561218, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=52, rfOrder=52, authorNames=null, journalName=null, refType=null, unstructuredReference=Wu Peizhi, Cong Gao. A unified deep model of learning from both data and queries for cardinality estimation[C] //Proc of the 2021 Int Conf on Management of Data. New York: ACM, 2021: 2009−2022, articleTitle=null, refAbstract=null)], funds=null, companyList=[AuthorCompany(id=1329455726885449752, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, xref=1, ext=[AuthorCompanyExt(id=1329455726893838361, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455726885449752, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1School of Computer Science and Technology, East China Normal University, Shanghai 200062), AuthorCompanyExt(id=1329455726902226970, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455726885449752, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1华东师范大学计算机科学与技术学院 上海 200062)]), AuthorCompany(id=1329455728345067547, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, xref=2, ext=[AuthorCompanyExt(id=1329455728353456156, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455728345067547, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2Shanghai Institute of AI for Education, East China Normal University, Shanghai 200062), AuthorCompanyExt(id=1329455728357650461, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455728345067547, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
2华东师范大学上海智能教育研究院 上海 200062)]), AuthorCompany(id=1329455728437342238, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, xref=3, ext=[AuthorCompanyExt(id=1329455728441536543, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455728437342238, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
3Aerospace Information Research Institute, Chinese Academy of Sciences, Beijing 100190), AuthorCompanyExt(id=1329455728445730848, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, companyId=1329455728437342238, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
3中国科学院空天信息创新研究院 北京 100190)])], figs=[ArticleFig(id=1329455730484162624, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, label=Figure 1, caption=
The classification system of cardinality estimation, figureFileSmall=e3skD2i1unPM37t7CL619g==, figureFileBig=9VzI4Xa/URY8UiCEnelH0Q==, tableContent=null), ArticleFig(id=1329455730563854401, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, label=图1, caption=
基数估计分类体系, figureFileSmall=e3skD2i1unPM37t7CL619g==, figureFileBig=9VzI4Xa/URY8UiCEnelH0Q==, tableContent=null), ArticleFig(id=1329455730790346818, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, label=Figure 2, caption=
General modeling flow for query-driven cardinality estimation, figureFileSmall=GW46AxNtBfo3oAq8QQznBA==, figureFileBig=7kaURsLdfujRnLc5KJRW8Q==, tableContent=null), ArticleFig(id=1329455730907787331, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, label=图2, caption=
查询驱动的基数估计的一般性建模流程, figureFileSmall=GW46AxNtBfo3oAq8QQznBA==, figureFileBig=7kaURsLdfujRnLc5KJRW8Q==, tableContent=null), ArticleFig(id=1329455730991673412, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, label=Figure 3, caption=
General modeling flow for data-driven cardinality estimation, figureFileSmall=MoE4ZEaeHCpphMCvaOxY4Q==, figureFileBig=Q9l262wZWPgBemVzDaJtDg==, tableContent=null), ArticleFig(id=1329455731058782277, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, label=图3, caption=
数据驱动的基数估计的一般性建模流程, figureFileSmall=MoE4ZEaeHCpphMCvaOxY4Q==, figureFileBig=Q9l262wZWPgBemVzDaJtDg==, tableContent=null), ArticleFig(id=1329455731121696838, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, label=Figure 4, caption=
General modeling flow for hybrid model cardinality estimation, figureFileSmall=HlBRQk7wLfmQyP4pK4oM4g==, figureFileBig=352Z5cWWQA+Ky3BMM8GsCA==, tableContent=null), ArticleFig(id=1329455732736503879, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, label=图4, caption=
混合模型基数估计的一般性建模流程, figureFileSmall=HlBRQk7wLfmQyP4pK4oM4g==, figureFileBig=352Z5cWWQA+Ky3BMM8GsCA==, tableContent=null), ArticleFig(id=1329455732845555784, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, label=Table 1, caption=
Feature Encoding Techniques Based on Machine Learned Cardinality Estimation Techniques
, figureFileSmall=null, figureFileBig=null, tableContent=
| 编码方式 | 模型 | 特征类型 |
|---|
| 谓词 | 连接类型 | 数据库元数据 | 数据表数据 | 其他 |
|---|
One-Hot 编码 | NNST [3] | 等值连接谓词和范围选择谓词中的查询值 | | 最大值、最小值、基数和1维等宽直方图表示 | | |
| Local NN [4] | 每个谓词的单一 运算符<,=,> | | | | |
| MSCN [5] | 列id、运算符id | 连接类型id | 所有数据表的id | | |
| 文献[6] | 等值连接谓词和单向范围选择谓词 | | 所有数据表的id | | |
| 文献[8] | 数值型的查询谓词中的列id和运算符id | 连接类型id | | | 扫描、聚合和 排序算子 |
| Naru [17] | | | | 不同取值数较小的列 | |
| NeuroCard [19] | | | | 不同取值数较小的列 | |
| GL(global-local)[27] | 相似性查询中高维图片或者文本等查询值 | | | | 相似距离 阈值 |
| Embedding编码 | Naru [17] | | | | 不同取值数较大的列 | |
| NeuroCard [19] | | | | 不同取值数较大的列 | |
| GL [27] | 相似性查询中高维图片或者文本等查询值 | | | | 相似距离 阈值 |
| 其他编码 | Local NN [4] | 使用归一化公式或字典编码查询值 | | | | |
| 文献[7] | 运算符、查询值使用不超过参数域范围的值编码为数值 | | | | 模型参数、聚合、UDF的参数 |
| 文献[8] | 字符串编码技术编码字符串型的查询谓词 | | | | 使用位图编码 样本位图 |
| Tree-based ensembles/NN [9] | 范围查询的上下界 | | | | 选择度估计 |
| DLM [18] | | | | 将每列数据的序号编码为二进制 | |
| 自动确定规模的XGBoost [28] | 范围查询的上下界与十进制的分类谓词查询值 | | | | 选择度估计 |
), ArticleFig(id=1329455732954607689, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, label=表1, caption=
基于机器学习的基数估计技术的特征编码技术
, figureFileSmall=null, figureFileBig=null, tableContent=
| 编码方式 | 模型 | 特征类型 |
|---|
| 谓词 | 连接类型 | 数据库元数据 | 数据表数据 | 其他 |
|---|
One-Hot 编码 | NNST [3] | 等值连接谓词和范围选择谓词中的查询值 | | 最大值、最小值、基数和1维等宽直方图表示 | | |
| Local NN [4] | 每个谓词的单一 运算符<,=,> | | | | |
| MSCN [5] | 列id、运算符id | 连接类型id | 所有数据表的id | | |
| 文献[6] | 等值连接谓词和单向范围选择谓词 | | 所有数据表的id | | |
| 文献[8] | 数值型的查询谓词中的列id和运算符id | 连接类型id | | | 扫描、聚合和 排序算子 |
| Naru [17] | | | | 不同取值数较小的列 | |
| NeuroCard [19] | | | | 不同取值数较小的列 | |
| GL(global-local)[27] | 相似性查询中高维图片或者文本等查询值 | | | | 相似距离 阈值 |
| Embedding编码 | Naru [17] | | | | 不同取值数较大的列 | |
| NeuroCard [19] | | | | 不同取值数较大的列 | |
| GL [27] | 相似性查询中高维图片或者文本等查询值 | | | | 相似距离 阈值 |
| 其他编码 | Local NN [4] | 使用归一化公式或字典编码查询值 | | | | |
| 文献[7] | 运算符、查询值使用不超过参数域范围的值编码为数值 | | | | 模型参数、聚合、UDF的参数 |
| 文献[8] | 字符串编码技术编码字符串型的查询谓词 | | | | 使用位图编码 样本位图 |
| Tree-based ensembles/NN [9] | 范围查询的上下界 | | | | 选择度估计 |
| DLM [18] | | | | 将每列数据的序号编码为二进制 | |
| 自动确定规模的XGBoost [28] | 范围查询的上下界与十进制的分类谓词查询值 | | | | 选择度估计 |
), ArticleFig(id=1329455733046882378, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, label=Table 2, caption=
Comparison of Query-Driven Cardinality Estimation Models
, figureFileSmall=null, figureFileBig=null, tableContent=
| 模型 | 方法论 | 监督学习模型 | 支持的操作 | 输入 | 参数更新方法 | 查询编码 |
|---|
| NNST[3] | 回归模型/强化学习 | 神经神经网络 | 查询和连接 | 查询、基数 | 梯度更新 | 数据库属性信息、单一操作运算符 |
| MSCN[5] | 回归模型 | 卷积神经网络 | 查询和多表连接 | 查询、数据和基数 | 梯度更新 | 谓词、表和连接 |
| Tree-based ensembles/NN[9] | 回归模型 | XGboost | 查询 | 查询、数据和基数 | 梯度更新和贪心超参调整 | 谓词 |
| XGBoost[28] | 回归模型 | XGboost | 查询和多表连接 | 查询、数据 | 迭代更新 | 谓词和表的选择度 |
| GL[27] | 回归模型 | 深度神经网络 | 图片、文本相似性查询和连接 | 查询、数据、阈值和基数 | 梯度更新 | 查询、距离和阈值 |
| LMKG[47] | 回归模型/自回归模型 | 深度神经网络/深度自回归模型 | SPARQL查询 | RDF查询三元组、基数 | 梯度更新 | 查询的子图模式 |
), ArticleFig(id=1329455733172711499, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, label=表2, caption=
查询驱动的基数估计模型比较
, figureFileSmall=null, figureFileBig=null, tableContent=
| 模型 | 方法论 | 监督学习模型 | 支持的操作 | 输入 | 参数更新方法 | 查询编码 |
|---|
| NNST[3] | 回归模型/强化学习 | 神经神经网络 | 查询和连接 | 查询、基数 | 梯度更新 | 数据库属性信息、单一操作运算符 |
| MSCN[5] | 回归模型 | 卷积神经网络 | 查询和多表连接 | 查询、数据和基数 | 梯度更新 | 谓词、表和连接 |
| Tree-based ensembles/NN[9] | 回归模型 | XGboost | 查询 | 查询、数据和基数 | 梯度更新和贪心超参调整 | 谓词 |
| XGBoost[28] | 回归模型 | XGboost | 查询和多表连接 | 查询、数据 | 迭代更新 | 谓词和表的选择度 |
| GL[27] | 回归模型 | 深度神经网络 | 图片、文本相似性查询和连接 | 查询、数据、阈值和基数 | 梯度更新 | 查询、距离和阈值 |
| LMKG[47] | 回归模型/自回归模型 | 深度神经网络/深度自回归模型 | SPARQL查询 | RDF查询三元组、基数 | 梯度更新 | 查询的子图模式 |
), ArticleFig(id=1329455733248208972, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=EN, label=Table 3, caption=
Comparison of Data-Driven Cardinality Estimation Models
, figureFileSmall=null, figureFileBig=null, tableContent=
| 模型 | 学习方式 | 方法论 | 模型 | 多列查询 | 多表查询 | 采样方式 |
|---|
| Feedback-KDE[15] | 监督学习 | 联合数据分布 | 基于高斯的核密度模型 | √ | × | 随机采样 |
| QuickSel[16] | 监督学习 | 联合数据分布 | 均匀混合模型 | √ | × | 基于查询的样本 |
| Naru[17] | 无监督学习 | 联合数据分布 | 自回归模型 | √ | × | 渐进式采样 |
| DLM[18] | 无监督学习 | 联合数据分布 | 自回归模型 | √ | × | 重要性采样 |
| NeuroCard[19] | 无监督学习 | 联合数据分布 | 自回归模型 | √ | √ | 渐进式采样 |
| DeepDB[20] | 无监督学习 | 联合数据分布 | 和积网络 | √ | √ | 没有使用 |
| Extended Chow-Liu trees [48] | 无监督学习 | 联合数据分布 | 贝叶斯网络 | √ | × | 没有使用 |
| LHist[49] | 无监督学习 | 联合数据分布 +回归模型 | 多维直方图 | √ | × | 没有使用 |
), ArticleFig(id=1329455733353066573, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455724637302789, language=CN, label=表3, caption=
数据驱动的基数估计模型比较
, figureFileSmall=null, figureFileBig=null, tableContent=
| 模型 | 学习方式 | 方法论 | 模型 | 多列查询 | 多表查询 | 采样方式 |
|---|
| Feedback-KDE[15] | 监督学习 | 联合数据分布 | 基于高斯的核密度模型 | √ | × | 随机采样 |
| QuickSel[16] | 监督学习 | 联合数据分布 | 均匀混合模型 | √ | × | 基于查询的样本 |
| Naru[17] | 无监督学习 | 联合数据分布 | 自回归模型 | √ | × | 渐进式采样 |
| DLM[18] | 无监督学习 | 联合数据分布 | 自回归模型 | √ | × | 重要性采样 |
| NeuroCard[19] | 无监督学习 | 联合数据分布 | 自回归模型 | √ | √ | 渐进式采样 |
| DeepDB[20] | 无监督学习 | 联合数据分布 | 和积网络 | √ | √ | 没有使用 |
| Extended Chow-Liu trees [48] | 无监督学习 | 联合数据分布 | 贝叶斯网络 | √ | × | 没有使用 |
| LHist[49] | 无监督学习 | 联合数据分布 +回归模型 | 多维直方图 | √ | × | 没有使用 |
)], 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.202220649, detailUrlEn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/10.7544/issn1000-1239.202220649, pdfUrlCn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/CN/PDF/10.7544/issn1000-1239.202220649, pdfUrlEn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/PDF/10.7544/issn1000-1239.202220649, aliStartDate=0, aliEndDate=0, collectionFlag=false, citedCount=null, citedUrl=null, previewStatus=0, delFlag=0, hasFullText=1, orderTime=1706803200000, fullTextJson=null, articleText=null, reference=null)