Article(id=1329455983060955388, tenantId=1146029695717560320, journalId=1324759914146529478, issueId=1329455965163860100, articleNumber=null, orderNo=null, doi=10.7544/issn1000-1239.202330835, pmid=null, cstr=null, oa=null, hot=null, price=null, onlineType=0, articleFormat=0, articleType=null, articleTypeStr=null, receivedDate=1697644800000, receivedDateStr=2023-10-19, revisedDate=1702483200000, revisedDateStr=2023-12-14, acceptedDate=null, acceptedDateStr=null, onlineDate=1794896606459, onlineDateStr=2026-11-17, pubDate=1709308800000, pubDateStr=2024-03-02, doiRegisterDate=null, doiRegisterDateStr=null, onlineIssueDate=1794896606459, onlineIssueDateStr=2026-11-17, onlineJustAcceptDate=null, onlineJustAcceptDateStr=null, onlineFirstDate=null, onlineFirstDateStr=null, sourceXml=null, magXml=null, createTime=1794896606459, creator=13701087609, updateTime=1794896606459, updator=13701087609, issue=Issue{id=1329455965163860100, tenantId=1146029695717560320, journalId=1324759914146529478, year='2024', volume='61', issue='3', pageStart='539', pageEnd='807', issueExtLink='null', onlineDate='null', pubDate='1709308800000', pubDateStr='2024-03-02', beforeIssueId=null, nextIssueId=null, price=null, status=1, issueComplete=1, articleOrder=1, issueType=-1, specialIssue=null, createTime=1794896602192, creator='13701087609', updateTime=1794896602192, updator='13701087609', preIssue=null, nextIssue=null, articleTotal=null, ext=null, issueFiles=null, downloadFileDto=null}, startPage=540, endPage=554, ext={EN=ArticleExt(id=1329455983316807933, articleId=1329455983060955388, tenantId=1146029695717560320, journalId=1324759914146529478, language=EN, title=Architecture and Technology of OceanBase Distributed Relational Database, columnId=1325493570068689365, journalTitle=Journal of Computer Research and Development, columnName=Research Highlights, runingTitle=null, highlight=null, articleAbstract=
Relational database is the key information infrastructure of today’s society. The Internet and digitization have brought high concurrency and massive data. Due to their centralized architectures, the processing power and storage capacity of traditional relational databases are stretched. OceanBase is a distributed relational database based on commodity PC servers. It achieves online horizontal scalability, automatic lossless disaster recovery from data center failure and high-ratio data compression. It has been used in finance, government affairs, telecommunication systems, Internet, etc. We introduce the architecture and some key technologies of OceanBase, including distributed transaction processing, LSM-tree-based storage system and distributed SQL optimizer. In addition, we explain in detail the high availability and data consistency of OceanBase, which can ensure that RPO is 0 and RTO is less than 8 seconds. At the same time, it also introduces OceanBase’s multi-tenant mechanism, which adopts a native multi-tenant design within the cluster to implement multiple independent database services in the cluster. Based on the Sysbench and TPC-H evaluation benchmarks, comparative experimental results show that 1) in a stand-alone mode, the performance of OceanBase is 1.27 times to over 2 times that of MySQL; 2) in a single-master mode, the performance of OceanBase is 1.25 times to nearly 2 times that of MySQL; 3) in a multi-master mode, the performance of OceanBase is 1.09 to 3.1 times that of MySQL, and for complex OLAP queries, the performance of OceanBase is 6 to 327 times that of MySQL.
, authors=Zhenkun Yang, Chuanhui Yang*, Fusheng Han, Guoping Wang, Zhifeng Yang, Xiaojun Cheng, authorsList=Zhenkun Yang, Chuanhui Yang, Fusheng Han, Guoping Wang, Zhifeng Yang, Xiaojun Cheng, authorCompany=null, correspAuthors=Chuanhui Yang, authorNote=
born in 1965. PhD. CCF fellow. One of the 1st Cheung Kong Scholars, Peking University. His main research interests include distributed system and database system
born in 1985. Master. Member of CCF. His main research interests include distributed system and database system
born in 1985. Bachelor. His main research interests include transaction processing, storage engine, and consensus protocol in database system
born in 1986. PhD. His main research interests include query processing and optimization in database system
born in 1983. Master. His main research interests include query processing and resource scheduling in database system
born in 1982. Master. His main research interests include distributed system test and database system test
, 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=1329455987876016417, articleId=1329455983060955388, tenantId=1146029695717560320, journalId=1324759914146529478, language=CN, title=OceanBase分布式关系数据库架构与技术, columnId=1325493570202907095, journalTitle=计算机研究与发展, columnName=前沿亮点, runingTitle=null, highlight=null, articleAbstract=
关系数据库是当今社会的关键信息基础设施,互联网和数字化带来了高并发和海量数据,传统关系数据库均为集中式架构,处理能力和存储容量都捉襟见肘. OceanBase分布式关系数据库基于通用PC服务器,不仅实现了在线水平伸缩,还实现了机房故障自动无损容灾以及高倍率数据压缩等,已经应用于金融、政务、通信和互联网等行业. 介绍了OceanBase分布式关系数据库的系统架构和关键技术,包括分布式事务处理、基于LSM-tree 的存储系统以及分布式SQL优化器. 详细阐述了OceanBase数据库的高可用和数据一致性,包括RPO为0和RTO小于8 s. 也介绍了OceanBase数据库多租户机制,即采用了集群内原生多租户设计,在集群内实现多个互相独立的数据库服务. 基于Sysbench和TPC-H评测基准,对比实验结果表明:1)在单机模式下,OceanBase的性能是MySQL的1.27倍至2倍多;2)在单主模式下,OceanBase的性能是MySQL的1.25倍至近2倍;3)在多主模式下,OceanBase的性能是MySQL的1.09倍至3.1倍,对于OLAP的复杂查询,OceanBase 的性能是MySQL 的6 倍到327倍.
, authors=阳振坤, 杨传辉*, 韩富晟, 王国平, 杨志丰, 成肖君, authorsList=阳振坤, 杨传辉, 韩富晟, 王国平, 杨志丰, 成肖君, authorCompany=null, correspAuthors=杨传辉, authorNote=
 |
1965年生. 博士. CCF会士. 北京大学首批长江学者. 主要研究方向为分布式系统、数据库系统 |
 |
1985年生. 硕士. CCF会员. 主要研究方向为分布式系统、数据库系统 |
 |
1985年生. 学士. 主要研究方向为数据库系统事务处理、存储引擎、一致性协议 |
 |
1986年生. 博士. 主要研究方向为数据库领域的查询处理和优化 |
 |
1983年生. 硕士. 主要研究方向为数据库系统查询处理和资源调度 |
 |
1982年生. 硕士. 主要研究方向为分布式系统的测试、数据库系统的测试 |
, correspAuthorsNote=
, copyrightStatement=版权所有 © 2024 计算机研究与发展编辑部, copyrightOwner=null, extLink=null, articleAbsUrl=null, sourceXml=xbm8bnJaSnbwSO04N8GyUQ==, magXml=yKz0OBdvOcQ1HpwBi7tFew==, pdfUrl=null, pdf=OcyvGOORYLxLaBGBSMEJvg==, pdfFileSize=1585424, pdfExtLink=null, richHtmlUrl=null, mobilePdfUrl=null, reviewReport=null, pdfFirstPage=null, abstractGraph=qZcdesgj90fJrb3TlLazig==, abstractGraphContent=null, abstractVideo=null, citation=null, cebUrl=null, magXmlContent=epSFpBwXfgESXscWGLaSAg==, mapNumber=null, fund=null)}, authors=[Author(id=1329455988152840486, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, orderNo=0, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=zhengxiang@oceanbase.com, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1329455988228337960, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455988152840486, language=EN, stringName=Zhenkun Yang, firstName=Zhenkun, middleName=null, lastName=Yang, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102, bio={"content":"
born in 1965. PhD. CCF fellow. One of the 1st Cheung Kong Scholars, Peking University. His main research interests include distributed system and database system
"}, bioImg=null, bioContent=
born in 1965. PhD. CCF fellow. One of the 1st Cheung Kong Scholars, Peking University. His main research interests include distributed system and database system
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455988299641129, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455988152840486, language=CN, stringName=阳振坤, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1北京奥星贝斯科技有限公司 北京 100102, bio={"img":"BiIS8IpXOnXrUHcXlizi7Q==","content":"
1965年生. 博士. CCF会士. 北京大学首批长江学者. 主要研究方向为分布式系统、数据库系统
"}, bioImg=BiIS8IpXOnXrUHcXlizi7Q==, bioContent=
1965年生. 博士. CCF会士. 北京大学首批长江学者. 主要研究方向为分布式系统、数据库系统
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455988073148706, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, xref=1, ext=[AuthorCompanyExt(id=1329455988081537315, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102), AuthorCompanyExt(id=1329455988085731620, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1北京奥星贝斯科技有限公司 北京 100102)])]), Author(id=1329455988370944299, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, orderNo=1, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=rizhao.ych@oceanbase.com, emailSecond=null, emailThird=null, correspondingAuthor=1, authorType=1, ext={EN=AuthorExt(id=1329455988471607597, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455988370944299, language=EN, stringName=Chuanhui Yang, firstName=Chuanhui, middleName=null, lastName=Yang, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=*, address=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102, bio={"content":"
born in 1985. Master. Member of CCF. His main research interests include distributed system and database system
"}, bioImg=null, bioContent=
born in 1985. Master. Member of CCF. His main research interests include distributed system and database system
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455988719071534, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455988370944299, language=CN, stringName=杨传辉, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=*, address=
1北京奥星贝斯科技有限公司 北京 100102, bio={"img":"janTUMMP4ZZhVou4+Sj57w==","content":"
1985年生. 硕士. CCF会员. 主要研究方向为分布式系统、数据库系统
"}, bioImg=janTUMMP4ZZhVou4+Sj57w==, bioContent=
1985年生. 硕士. CCF会员. 主要研究方向为分布式系统、数据库系统
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455988073148706, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, xref=1, ext=[AuthorCompanyExt(id=1329455988081537315, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102), AuthorCompanyExt(id=1329455988085731620, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1北京奥星贝斯科技有限公司 北京 100102)])]), Author(id=1329455988798763312, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=1329455988878455090, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455988798763312, language=EN, stringName=Fusheng Han, firstName=Fusheng, middleName=null, lastName=Han, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102, bio={"content":"
born in 1985. Bachelor. His main research interests include transaction processing, storage engine, and consensus protocol in database system
"}, bioImg=null, bioContent=
born in 1985. Bachelor. His main research interests include transaction processing, storage engine, and consensus protocol in database system
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455988945563955, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455988798763312, language=CN, stringName=韩富晟, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1北京奥星贝斯科技有限公司 北京 100102, bio={"img":"YbZblStnOC7SBEL0lTkTkg==","content":"
1985年生. 学士. 主要研究方向为数据库系统事务处理、存储引擎、一致性协议
"}, bioImg=YbZblStnOC7SBEL0lTkTkg==, bioContent=
1985年生. 学士. 主要研究方向为数据库系统事务处理、存储引擎、一致性协议
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455988073148706, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, xref=1, ext=[AuthorCompanyExt(id=1329455988081537315, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102), AuthorCompanyExt(id=1329455988085731620, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1北京奥星贝斯科技有限公司 北京 100102)])]), Author(id=1329455989008478517, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, orderNo=3, firstName=null, middleName=null, lastName=null, nameCn=null, orcid=null, stid=null, country=null, authorPic=null, dead=0, email=null, emailSecond=null, emailThird=null, correspondingAuthor=0, authorType=1, ext={EN=AuthorExt(id=1329455989104947511, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455989008478517, language=EN, stringName=Guoping Wang, firstName=Guoping, middleName=null, lastName=Wang, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102, bio={"content":"
born in 1986. PhD. His main research interests include query processing and optimization in database system
"}, bioImg=null, bioContent=
born in 1986. PhD. His main research interests include query processing and optimization in database system
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455989264331065, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455989008478517, language=CN, stringName=王国平, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1北京奥星贝斯科技有限公司 北京 100102, bio={"img":"9/vhWm9Doxyx0qk65UHujA==","content":"
1986年生. 博士. 主要研究方向为数据库领域的查询处理和优化
"}, bioImg=9/vhWm9Doxyx0qk65UHujA==, bioContent=
1986年生. 博士. 主要研究方向为数据库领域的查询处理和优化
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455988073148706, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, xref=1, ext=[AuthorCompanyExt(id=1329455988081537315, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102), AuthorCompanyExt(id=1329455988085731620, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1北京奥星贝斯科技有限公司 北京 100102)])]), Author(id=1329455989398548796, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, orderNo=4, 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=1329455989507600702, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455989398548796, language=EN, stringName=Zhifeng Yang, firstName=Zhifeng, middleName=null, lastName=Yang, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102, bio={"content":"
born in 1983. Master. His main research interests include query processing and resource scheduling in database system
"}, bioImg=null, bioContent=
born in 1983. Master. His main research interests include query processing and resource scheduling in database system
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455989570515263, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455989398548796, language=CN, stringName=杨志丰, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1北京奥星贝斯科技有限公司 北京 100102, bio={"img":"44bLiJhRGRFqolbQZZnXkA==","content":"
1983年生. 硕士. 主要研究方向为数据库系统查询处理和资源调度
"}, bioImg=44bLiJhRGRFqolbQZZnXkA==, bioContent=
1983年生. 硕士. 主要研究方向为数据库系统查询处理和资源调度
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455988073148706, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, xref=1, ext=[AuthorCompanyExt(id=1329455988081537315, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102), AuthorCompanyExt(id=1329455988085731620, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1北京奥星贝斯科技有限公司 北京 100102)])]), Author(id=1329455989629235521, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, orderNo=5, 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=1329455989708927299, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455989629235521, language=EN, stringName=Xiaojun Cheng, firstName=Xiaojun, middleName=null, lastName=Cheng, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102, bio={"content":"
born in 1982. Master. His main research interests include distributed system test and database system test
"}, bioImg=null, bioContent=
born in 1982. Master. His main research interests include distributed system test and database system test
, aboutCorrespAuthor=null), CN=AuthorExt(id=1329455989780230468, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, authorId=1329455989629235521, language=CN, stringName=成肖君, firstName=null, middleName=null, lastName=null, prefix=null, suffix=null, authorComment=null, nameInitials=null, affiliation=null, department=null, xref=null, address=
1北京奥星贝斯科技有限公司 北京 100102, bio={"img":"HNBPT9KWgn2N8pnwheq+pw==","content":"
1982年生. 硕士. 主要研究方向为分布式系统的测试、数据库系统的测试
"}, bioImg=HNBPT9KWgn2N8pnwheq+pw==, bioContent=
1982年生. 硕士. 主要研究方向为分布式系统的测试、数据库系统的测试
, aboutCorrespAuthor=null)}, companyList=[AuthorCompany(id=1329455988073148706, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, xref=1, ext=[AuthorCompanyExt(id=1329455988081537315, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102), AuthorCompanyExt(id=1329455988085731620, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1北京奥星贝斯科技有限公司 北京 100102)])])], keywords=[Keyword(id=1329455989868310853, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, orderNo=1, keyword=relational database), Keyword(id=1329455989931225414, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, orderNo=2, keyword=distributed transaction), Keyword(id=1329455991608947015, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, orderNo=3, keyword=LSM-tree-based storage), Keyword(id=1329455991692833096, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, orderNo=4, keyword=distributed SQL optimizer), Keyword(id=1329455991785107785, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, orderNo=5, keyword=multi-tenant), Keyword(id=1329455991856410954, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, orderNo=1, keyword=关系数据库), Keyword(id=1329455991923519819, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, orderNo=2, keyword=分布式事务), Keyword(id=1329455992007405900, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, orderNo=3, keyword=基于LSM-tree存储), Keyword(id=1329455992074514765, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, orderNo=4, keyword=分布式SQL优化器), Keyword(id=1329455992137429326, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, orderNo=5, keyword=多租户)], refs=[Reference(id=1329455994167472489, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Codd E F. A relational model of data for large shared data banks[J]. Communications of the ACM, 1970, 13(6): 377−387, articleTitle=null, refAbstract=null), Reference(id=1329455994293301610, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Yang Zhenkun, Yang Chuanhui, Han Fusheng, et al. OceanBase: A 707 million tpmC distributed relational database system[J]. Proceedings of the VLDB Endowment, 2022, 15(12): 3385−3397, articleTitle=null, refAbstract=null), Reference(id=1329455994347827563, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Yang Zhifeng, Xu Quanqing, Gao Shanyan, et al. OceanBase Paetica: A hybrid shared-nothing/shared-everything database for supporting single machine and distributed cluster[J]. Proceedings of the VLDB Endowment, 2023, 16(12): 3728−3740, articleTitle=null, refAbstract=null), Reference(id=1329455994406547820, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Serlin O. TPC-C Details: 60, 880, 800 tpmC [EB/OL]. [2023-11-25]. https://www.tpc.org/1799, articleTitle=null, refAbstract=null), Reference(id=1329455996008771949, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Serlin O. TPC-H Result Details: 15, 265, 305 QphH@30000GB [EB/OL]. [2023-11-25]. https://www.tpc.org/3375, articleTitle=null, refAbstract=null), Reference(id=1329455996092658030, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Lamport L. The part-time parliament[J]. ACM Transactions on Computer Systems, 1998, 16(2): 133−169, articleTitle=null, refAbstract=null), Reference(id=1329455996159766895, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Gray J. The transaction concept: Virtues and limitations[C]//Proc of Int Conf on Very Large Data Bases. San Francisco: Morgan Kaufmann, 1981: 144−154, articleTitle=null, refAbstract=null), Reference(id=1329455996252041584, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Mohan C, Lindsay B, Obermarck R. Transaction management in the R* distributed database management system[J]. ACM Transactions on Database Systems, 1986, 11(4): 378−396, articleTitle=null, refAbstract=null), Reference(id=1329455996319150449, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Berenson H, Bernstein P, Gray J, et al. A critique of ANSI SQL isolation levels[C]//Proc of the 1995 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 1995: 1−10, articleTitle=null, refAbstract=null), Reference(id=1329455996382065010, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Bernstein P, Goodman N. Multiversion concurrency control−Theory and algorithms[J]. ACM Transactions on Database Systems, 1983, 8(4): 465−483, articleTitle=null, refAbstract=null), Reference(id=1329455996457562483, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=O’Neil P, Cheng E, Gawlick D, et al. The log-structured merge-tree (LSM-tree)[J]. Acta Informatica, 1996, 33(4): 351−385, articleTitle=null, refAbstract=null), Reference(id=1329455996524671348, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Selinger P, Astrahan M, Chamberlin D, et al. Access path selection in a relational database management system[C]//Proc of the ACM SIGMOD Conf on Management of Data. New York: ACM, 1979: 23−34, articleTitle=null, refAbstract=null), Reference(id=1329455996621140341, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Graefe G, McKenna W. The Volcano optimizer generator: Extensibility and efficient search[C]//Proc of the IEEE Conf on Data Engineering. Piscataway, NJ: IEEE, 1993: 209−218, articleTitle=null, refAbstract=null), Reference(id=1329455996746969462, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Graefe G. The Cascades framework for query optimization[J]. IEEE Data Engineering Bulletin, 1995, 18(3): 19−29, articleTitle=null, refAbstract=null), Reference(id=1329455996839244151, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Levy A, Mumick I, Sagiv Y. Query optimization by predicate move-around[C]//Proc of Int Conf on Very Large Data Bases. San Francisco: Morgan Kaufmann, 1994: 96–107, articleTitle=null, refAbstract=null), Reference(id=1329455996914741624, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Kim W. On optimizing an SQL-like nested query[J]. ACM Transactions on Database Systems, 1982, 7(3): 443−469, articleTitle=null, refAbstract=null), Reference(id=1329455997007016313, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Chaudhuri S, Shim K. An overview of cost-based optimization of queries with aggregates[J]. IEEE Data Engineering Bulletin, 1995, 18(3): 3−9, articleTitle=null, refAbstract=null), Reference(id=1329455997208342906, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Kornacker M, Behm A, Bittorf V, et al. Impala: A modern, open-source SQL engine for Hadoop[C]//Proc of the 7th Biennial Conf on Innovative Data Systems Research. New York: ACM, 2015: 1−10, articleTitle=null, refAbstract=null), Reference(id=1329455997267063163, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Oracle. Adaptive SQL Plan Management (SPM) in Oracle Database 12c Release 1 (12.1) [EB/OL]. [2023-11-25]. https://oracle-base.com/articles/12c/adaptive-sql-plan-management-12cr1, articleTitle=null, refAbstract=null), Reference(id=1329455997334172028, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=何宝宏. 中国通信标准化协会.数据库发展研究报告(2023)[EB/OL]. [2023-07-04]. https://www.c114.com.cn/market/39/a1236668.html, articleTitle=null, refAbstract=null), Reference(id=1329455997392892285, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=20, rfOrder=20, authorNames=null, journalName=null, refType=null, unstructuredReference=He Baohong. China Communications Standards Association. Database Development Research Report (2023) [EB/OL]. [2023-07-04]. https://www.c114.com.cn/market/39/a1236668.html(in Chinese), articleTitle=null, refAbstract=null), Reference(id=1329455997485166974, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=21, rfOrder=21, authorNames=null, journalName=null, refType=null, unstructuredReference=Ghemawat S, Gobioff H, Leung S. The Google file system[C]//Proc of the 19th Symp on Operating Systems Principles. Berkeley, CA: USENIX Association, 2003: 29−43, articleTitle=null, refAbstract=null), Reference(id=1329455997548081535, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=22, rfOrder=22, authorNames=null, journalName=null, refType=null, unstructuredReference=Dean J, Ghemawat S. MapReduce: Simplified data processing on large clusters[C]//Proc of the 6th Symp on Operating Systems Design and Implementation. Berkeley, CA: USENIX Association, 2012: 137−150, articleTitle=null, refAbstract=null), Reference(id=1329455997619384704, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=23, rfOrder=23, authorNames=null, journalName=null, refType=null, unstructuredReference=Chang F, Dean J, Ghemawat S, et al. Bigtable: A distributed storage system for structured data[J]. ACM Transactions on Computer Systems, 2008, 26(2): 1−26, articleTitle=null, refAbstract=null), Reference(id=1329455997678104961, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, doi=null, pmid=null, pmcid=null, year=null, volume=null, issue=null, pageStart=null, pageEnd=null, url=null, language=null, rfNumber=24, rfOrder=24, authorNames=null, journalName=null, refType=null, unstructuredReference=DeCandia G, Hastorun D, Jampani M, et al. Dynamo: Amazon’s highly available key-value store[C]//Proc of the ACM Symp on Operating Systems Principles. Berkeley, CA: USENIX Association, 2007: 205–220, articleTitle=null, refAbstract=null), Reference(id=1329455997753602434, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Peng D, Dabek F. Large-scale incremental processing using distributed transactions and notifications[C]//Proc of the USENIX Symp on Operating Systems Design and Implementation. Berkeley, CA: USENIX Association, 2010: 1–15, articleTitle=null, refAbstract=null), Reference(id=1329455997854265731, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Corbett J, Dean J, Epstein M, et al. Spanner: Google’s globally-distributed database[C]//Proc of the 10th USENIX Symp on Operating Systems Design and Implementation. Berkeley, CA: USENIX Association, 2012: 251–264, articleTitle=null, refAbstract=null), Reference(id=1329455997929763204, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Bacon D, Bales N, Bruno N, et al. Spanner: Becoming a SQL system[C]//Proc of the 2017 ACM Int Conf on Management of Data. New York: ACM, 2017: 331–343, articleTitle=null, refAbstract=null), Reference(id=1329455998013649285, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Taft R, Sharif I, Matei A, et al. CockroachDB: The resilient geo-distributed SQL database[C]//Proc of the 2020 ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2020: 1493−1509, articleTitle=null, refAbstract=null), Reference(id=1329455998080758150, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Cook B. YugabyteDB [EB/OL]. [2023-11-25]. https://www. yugabyte. com, articleTitle=null, refAbstract=null), Reference(id=1329455998156255623, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, 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=Yang Zhenkun. OceanBase [EB/OL]. [2023-11-25]. https://github.com/oceanbase, articleTitle=null, refAbstract=null)], funds=null, companyList=[AuthorCompany(id=1329455988073148706, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, xref=1, ext=[AuthorCompanyExt(id=1329455988081537315, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=EN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1Beijing OceanBase Technology Co., Ltd., Beijing 100102), AuthorCompanyExt(id=1329455988085731620, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, companyId=1329455988073148706, language=CN, country=null, province=null, city=null, postcode=null, companyName=null, departmentName=null, remark=
1北京奥星贝斯科技有限公司 北京 100102)])], figs=[ArticleFig(id=1329455992242286927, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 1, caption=
The system architecture of OceanBase, figureFileSmall=wkc/4LV/4HQ0HmN18qwuvg==, figureFileBig=qZcdesgj90fJrb3TlLazig==, tableContent=null), ArticleFig(id=1329455992305201488, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图1, caption=
OceanBase系统架构, figureFileSmall=wkc/4LV/4HQ0HmN18qwuvg==, figureFileBig=qZcdesgj90fJrb3TlLazig==, tableContent=null), ArticleFig(id=1329455992477167953, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 2, caption=
Three-replica distributed architecture of OceanBase, figureFileSmall=BgkMTyjyv6Vhi3em86qasQ==, figureFileBig=wJiqPQ1b8AN2hPaIndfYnw==, tableContent=null), ArticleFig(id=1329455992535888210, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图2, caption=
OceanBase的3副本分布式架构, figureFileSmall=BgkMTyjyv6Vhi3em86qasQ==, figureFileBig=wJiqPQ1b8AN2hPaIndfYnw==, tableContent=null), ArticleFig(id=1329455992611385683, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 3, caption=
Three replicas and five replicas in OceanBase, figureFileSmall=5ieRlYiO7+HHxYGbk9VuBw==, figureFileBig=LxTRTjczt3d4RZIw8P+8HA==, tableContent=null), ArticleFig(id=1329455992678494548, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图3, caption=
OceanBase的3副本和5副本, figureFileSmall=5ieRlYiO7+HHxYGbk9VuBw==, figureFileBig=LxTRTjczt3d4RZIw8P+8HA==, tableContent=null), ArticleFig(id=1329455992737214805, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 4, caption=
Two-Phase Commit Protocol in OceanBase, figureFileSmall=db6el3ADbBWJVsgXk4G1XA==, figureFileBig=rey2M0ZEV9Nv39TnDUOgng==, tableContent=null), ArticleFig(id=1329455992812712278, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图4, caption=
OceanBase两阶段提交协议, figureFileSmall=db6el3ADbBWJVsgXk4G1XA==, figureFileBig=rey2M0ZEV9Nv39TnDUOgng==, tableContent=null), ArticleFig(id=1329455992888209751, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 5, caption=
Storage engine of OceanBase, figureFileSmall=t1ibdq6Rp7et/BxPPM+evg==, figureFileBig=rM21ll1hW+8ouCqfNZy1ug==, tableContent=null), ArticleFig(id=1329455992951124312, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图5, caption=
OceanBase存储引擎, figureFileSmall=t1ibdq6Rp7et/BxPPM+evg==, figureFileBig=rM21ll1hW+8ouCqfNZy1ug==, tableContent=null), ArticleFig(id=1329455993014038873, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 6, caption=
Query optimizer framework of OceanBase, figureFileSmall=An0DMye1vwrY9G+2xB3RQQ==, figureFileBig=Yi2DR0UpW6WW5lNpNRX5Tg==, tableContent=null), ArticleFig(id=1329455993076953434, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图6, caption=
OceanBase查询优化器框架, figureFileSmall=An0DMye1vwrY9G+2xB3RQQ==, figureFileBig=Yi2DR0UpW6WW5lNpNRX5Tg==, tableContent=null), ArticleFig(id=1329455993144062299, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 7, caption=
Online plan evolution method of OceanBase, figureFileSmall=T3GT+B+X0CfF2UIpAokfPQ==, figureFileBig=WOIvKPhtGyxUrO9GCeb7Bw==, tableContent=null), ArticleFig(id=1329455993202782556, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图7, caption=
OceanBase在线计划演进方法, figureFileSmall=T3GT+B+X0CfF2UIpAokfPQ==, figureFileBig=WOIvKPhtGyxUrO9GCeb7Bw==, tableContent=null), ArticleFig(id=1329455993265697117, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 8, caption=
Performance comparison between OceanBase and MySQL in stand-alone mode, figureFileSmall=Nfd97tXFchtJ3bCQT/3DcQ==, figureFileBig=XLJROqSo8tv5A5yAvocG8Q==, tableContent=null), ArticleFig(id=1329455993341194590, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图8, caption=
单机模式下OceanBase和MySQL的性能对比, figureFileSmall=Nfd97tXFchtJ3bCQT/3DcQ==, figureFileBig=XLJROqSo8tv5A5yAvocG8Q==, tableContent=null), ArticleFig(id=1329455993416692063, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 9, caption=
Performance comparison between OceanBase and MySQL in three-replica single-master mode, figureFileSmall=7TcJIzggtSyZXRffDNkTcw==, figureFileBig=zqGZx7W1kO+WFgIcmbIFIQ==, tableContent=null), ArticleFig(id=1329455993492189536, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图9, caption=
3副本单主模式OceanBase和MySQL的性能对比, figureFileSmall=7TcJIzggtSyZXRffDNkTcw==, figureFileBig=zqGZx7W1kO+WFgIcmbIFIQ==, tableContent=null), ArticleFig(id=1329455993546715489, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 10, caption=
Performance comparison between OceanBase and MySQL in three-replica multi-master mode, figureFileSmall=fgxo+FyuEruT8JOzsMH7hw==, figureFileBig=QhQuEkw6ccLdfX8gMgELfQ==, tableContent=null), ArticleFig(id=1329455993601241442, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图10, caption=
3副本多主模式OceanBase和MySQL的性能对比, figureFileSmall=fgxo+FyuEruT8JOzsMH7hw==, figureFileBig=QhQuEkw6ccLdfX8gMgELfQ==, tableContent=null), ArticleFig(id=1329455993659961699, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Figure 11, caption=
Time-consuming comparison of TPC-H 22 SQL queries between OceanBase and MySQL, figureFileSmall=KTkEFxVQMrR3xKg0NgGVJg==, figureFileBig=U+vKBToJWl6FLYL+wCkAnA==, tableContent=null), ArticleFig(id=1329455993714487652, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=图11, caption=
OceanBase和MySQL的TPC-H 22条SQL查询耗时对比, figureFileSmall=KTkEFxVQMrR3xKg0NgGVJg==, figureFileBig=U+vKBToJWl6FLYL+wCkAnA==, tableContent=null), ArticleFig(id=1329455993777402213, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Table 1, caption=
Availability Rate of Distributed System %
, figureFileSmall=null, figureFileBig=null, tableContent=
| 单个节点的可用率 | 节点数 |
|---|
| 10 | 100 |
|---|
| 99.999 | 99.99 | 99.90 |
| 99.99 | 99.90 | 99.01 |
), ArticleFig(id=1329455993873871206, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=表1, caption=
分布式系统的可用率
, figureFileSmall=null, figureFileBig=null, tableContent=
| 单个节点的可用率 | 节点数 |
|---|
| 10 | 100 |
|---|
| 99.999 | 99.99 | 99.90 |
| 99.99 | 99.90 | 99.01 |
), ArticleFig(id=1329455993970340199, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=EN, label=Table 2, caption=
Some User Business Data Compression Rates of OceanBase
, figureFileSmall=null, figureFileBig=null, tableContent=
| 原数据库 | 原数据量 | OceanBase数据量 | 压缩倍率 |
|---|
| MySQL | 1.5 TB | 500 GB | 3.00 |
| MySQL | 2.7 TB | 900 GB | 3.00 |
| MySQL | 3.6 TB | 1.2 TB | 3.00 |
| Oracle | 1.8 TB | 500 GB | 3.60 |
| Oracle | 7.8 TB | 800 GB | 9.75 |
| Oracle | 12 TB | 3.5 TB | 3.43 |
| Oracle | 20 TB | 2 TB | 10.00 |
| Oracle | 30 TB | 10 TB | 3.00 |
), ArticleFig(id=1329455994066809192, tenantId=1146029695717560320, journalId=1324759914146529478, articleId=1329455983060955388, language=CN, label=表2, caption=
部分用户业务的OceanBase数据压缩率
, figureFileSmall=null, figureFileBig=null, tableContent=
| 原数据库 | 原数据量 | OceanBase数据量 | 压缩倍率 |
|---|
| MySQL | 1.5 TB | 500 GB | 3.00 |
| MySQL | 2.7 TB | 900 GB | 3.00 |
| MySQL | 3.6 TB | 1.2 TB | 3.00 |
| Oracle | 1.8 TB | 500 GB | 3.60 |
| Oracle | 7.8 TB | 800 GB | 9.75 |
| Oracle | 12 TB | 3.5 TB | 3.43 |
| Oracle | 20 TB | 2 TB | 10.00 |
| Oracle | 30 TB | 10 TB | 3.00 |
)], 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.202330835, detailUrlEn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/10.7544/issn1000-1239.202330835, pdfUrlCn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/CN/PDF/10.7544/issn1000-1239.202330835, pdfUrlEn=https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/PDF/10.7544/issn1000-1239.202330835, aliStartDate=0, aliEndDate=0, collectionFlag=false, citedCount=null, citedUrl=null, previewStatus=0, delFlag=0, hasFullText=1, orderTime=1709308800000, fullTextJson=null, articleText=null, reference=null)