收藏切换
Architecture and Technology of OceanBase Distributed Relational Database
收藏切换
Zhenkun Yang, Chuanhui Yang*, Fusheng Han, Guoping Wang, Zhifeng Yang, Xiaojun Cheng
Journal of Computer Research and Development | 2024, 61(3) : 540 - 554
Less
收藏切换
Journal of Computer Research and Development | 2024, 61(3): 540-554
• Research Highlights •
Architecture and Technology of OceanBase Distributed Relational Database
Full
Zhenkun Yang, Chuanhui Yang*, Fusheng Han, Guoping Wang, Zhifeng Yang, Xiaojun Cheng
Affiliations
  • 1Beijing OceanBase Technology Co., Ltd., Beijing 100102
  • 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

About Author:

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

Published: 2024-03-02 doi: 10.7544/issn1000-1239.202330835
Outline
收藏切换

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.

relational database  /  distributed transaction  /  LSM-tree-based storage  /  distributed SQL optimizer  /  multi-tenant
阳振坤, 杨传辉, 韩富晟, 王国平, 杨志丰, 成肖君. OceanBase分布式关系数据库架构与技术. 计算机研究与发展, 2024 , 61 (3) : 540 -554 . DOI: 10.7544/issn1000-1239.202330835
Zhenkun Yang, Chuanhui Yang, Fusheng Han, Guoping Wang, Zhifeng Yang, Xiaojun Cheng. Architecture and Technology of OceanBase Distributed Relational Database[J]. Journal of Computer Research and Development, 2024 , 61 (3) : 540 -554 . DOI: 10.7544/issn1000-1239.202330835
Year 2024 volume 61 Issue 3
69
34
Cite this Article
BibTeX
Article Info
doi: 10.7544/issn1000-1239.202330835
  • Receive Date:2023-10-19
  • Online Date:2026-11-17
  • Published:2024-03-02
Article Data
Affiliations
History
  • Received:2023-10-19
  • Revised:2023-12-14
Affiliations
    1Beijing OceanBase Technology Co., Ltd., Beijing 100102
References
Share
https://castjournals.cast.org.cn/joweb/jsjyjyfz/EN/10.7544/issn1000-1239.202330835
Share to
QR

Scan QR to access full text

Cite this article
BibTeX
Citations
表12种不同金属材料的力学参数
科
Family
属数
Number of
genus
种数
Number of
species
占总种数比例
Percentage of
total species (%)
属
Genus
种数
Number of
species
占总种数比例
Percentage of total
species (%)
鹅膏菌科Amanitaceae 2 11 5.26 鹅膏菌属 Amanita 10 4.78
小菇科 Mycenaceae 2 12 5.74 丝盖伞属 Inocybe 5 2.39
多孔菌科 Polyporaceae 8 14 6.70 蜡蘑属 Laccaria 5 2.39
红菇科 Russulaceae 3 23 11.00 小皮伞属 Marasmius 6 2.87
小菇属 Mycena 11 5.26
光柄菇属 Pluteus 5 2.39
红菇属 Russula 17 8.13
栓菌属 Trametes 5 2.39
关闭全屏
  • BibTeX
  • EndNote
  • RefWorks
  • TxT