{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,1]],"date-time":"2026-06-01T20:39:18Z","timestamp":1780346358744,"version":"3.54.1"},"reference-count":43,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2022,8]]},"abstract":"<jats:p>We have designed and developed OceanBase, a distributed relational database system from the very basics for a decade. Being a scale-out multi-tenant system, OceanBase is cross-region fault tolerant, which is based on the shared-nothing architecture. Besides sharing many similar goals with alternative distributed DBMS, such as horizontal scalability, fault-tolerance, etc., our design has been driven by the demands of typical RDBMS compatibility as well as both on-premise and off-premise deployments. OceanBase has fulfilled its design goal. It implements the salient features of certain mainstream classical RDBMS, and most applications on them can run on OceanBase, with or without a few minor modifications. Tens of thousands of OceanBase servers have been deployed in Alipay.com as well as many other commercial organizations. It has also successfully passed the TPC-C benchmark test and seized the first place with more than 707 million tpmC. This paper presents the goals, design criteria, infrastructure, and key components of OceanBase including its engines for storage and transaction processing. Further, it details how OceanBase achieves the above leading TPC-C benchmark in a distributed cluster with more than 1,500 servers from 3 zones. It also describes lessons what we have learnt in building OceanBase for more than a decade.<\/jats:p>","DOI":"10.14778\/3554821.3554830","type":"journal-article","created":{"date-parts":[[2022,9,29]],"date-time":"2022-09-29T22:28:39Z","timestamp":1664490519000},"page":"3385-3397","source":"Crossref","is-referenced-by-count":89,"title":["OceanBase"],"prefix":"10.14778","volume":"15","author":[{"given":"Zhenkun","family":"Yang","sequence":"first","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Chuanhui","family":"Yang","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Fusheng","family":"Han","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Mingqiang","family":"Zhuang","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Bing","family":"Yang","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Zhifeng","family":"Yang","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Xiaojun","family":"Cheng","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yuzhong","family":"Zhao","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Wenhui","family":"Shi","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Huafeng","family":"Xi","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Huang","family":"Yu","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Bin","family":"Liu","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Yi","family":"Pan","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Boxue","family":"Yin","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Junquan","family":"Chen","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Quanqing","family":"Xu","sequence":"additional","affiliation":[{"name":"OceanBase"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2022,9,29]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"2019. OceanBase: 60 million tpmC. http:\/\/tpc.org\/1799.  2019. OceanBase: 60 million tpmC. http:\/\/tpc.org\/1799."},{"key":"e_1_2_1_2_1","unstructured":"2020. Ant Financial TPC Benchmark\u2122 C Full Disclosure Report. http:\/\/tpc.org\/results\/fdr\/tpcc\/ant_financial~tpcc~alibaba_cloud_elastic_compute_service_cluster~fdr~2020-05-17~v01.pdf.  2020. Ant Financial TPC Benchmark\u2122 C Full Disclosure Report. http:\/\/tpc.org\/results\/fdr\/tpcc\/ant_financial~tpcc~alibaba_cloud_elastic_compute_service_cluster~fdr~2020-05-17~v01.pdf."},{"key":"e_1_2_1_3_1","unstructured":"2021. Favorite of Taobao.com. https:\/\/shoucang.taobao.com.  2021. Favorite of Taobao.com. https:\/\/shoucang.taobao.com."},{"key":"e_1_2_1_4_1","unstructured":"2021. LevelDB. https:\/\/github.com\/google\/leveldb.  2021. LevelDB. https:\/\/github.com\/google\/leveldb."},{"key":"e_1_2_1_5_1","unstructured":"2021. MulanPubL-2.0. https:\/\/license.coscl.org.cn\/MulanPubL-2.0\/index.html.  2021. MulanPubL-2.0. https:\/\/license.coscl.org.cn\/MulanPubL-2.0\/index.html."},{"key":"e_1_2_1_6_1","unstructured":"2021. OceanBase. https:\/\/gitee.com\/oceanbase.  2021. OceanBase. https:\/\/gitee.com\/oceanbase."},{"key":"e_1_2_1_7_1","unstructured":"2021. OceanBase. https:\/\/github.com\/oceanbase.  2021. OceanBase. https:\/\/github.com\/oceanbase."},{"key":"e_1_2_1_8_1","unstructured":"2021. OceanBase: 707 million tmpC. http:\/\/tpc.org\/1803.  2021. OceanBase: 707 million tmpC. http:\/\/tpc.org\/1803."},{"key":"e_1_2_1_9_1","unstructured":"2021. RocksDB. https:\/\/rocksdb.org\/.  2021. RocksDB. https:\/\/rocksdb.org\/."},{"key":"e_1_2_1_10_1","unstructured":"2021. RPO and RTO in OceanBase. https:\/\/github.com\/kioco\/oceanbase-1.  2021. RPO and RTO in OceanBase. https:\/\/github.com\/kioco\/oceanbase-1."},{"key":"e_1_2_1_11_1","unstructured":"2021. Wish List of Amazon.com. https:\/\/www.amazon.com\/hz\/wishlist\/intro.  2021. Wish List of Amazon.com. https:\/\/www.amazon.com\/hz\/wishlist\/intro."},{"key":"e_1_2_1_12_1","unstructured":"2021. YugabyteDB. https:\/\/www.yugabyte.com.  2021. YugabyteDB. https:\/\/www.yugabyte.com."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2742797"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2915231"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056103"},{"key":"e_1_2_1_16_1","volume-title":"Proceedings of the 27th International Conference on Data Engineering, ICDE 2011, April 11--16","author":"Cao Yu","year":"2011","unstructured":"Yu Cao , Chun Chen , Fei Guo , Dawei Jiang , Yuting Lin , Beng Chin Ooi , Hoang Tam Vo , Sai Wu , and Quanqing Xu . 2011 . ES2: A cloud data storage system for supporting both OLTP and OLAP . In Proceedings of the 27th International Conference on Data Engineering, ICDE 2011, April 11--16 , 2011, Hannover, Germany, Serge Abiteboul, Klemens B\u00f6hm, Christoph Koch, and Kian-Lee Tan (Eds.). IEEE Computer Society, 291--302. Yu Cao, Chun Chen, Fei Guo, Dawei Jiang, Yuting Lin, Beng Chin Ooi, Hoang Tam Vo, Sai Wu, and Quanqing Xu. 2011. ES2: A cloud data storage system for supporting both OLTP and OLAP. In Proceedings of the 27th International Conference on Data Engineering, ICDE 2011, April 11--16, 2011, Hannover, Germany, Serge Abiteboul, Klemens B\u00f6hm, Christoph Koch, and Kian-Lee Tan (Eds.). IEEE Computer Society, 291--302."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1365815.1365816"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.14778\/3007263.3007277"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/2491245"},{"key":"e_1_2_1_20_1","volume-title":"10th USENIX Symposium on Operating Systems Design and Implementation, OSDI 2012","author":"Corbett James C.","year":"2012","unstructured":"James C. Corbett , Jeffrey Dean , Michael Epstein , Andrew Fikes , Christopher Frost , J. J. Furman , Sanjay Ghemawat , Andrey Gubarev , Christopher Heiser , Peter Hochschild , Wilson C. Hsieh , Sebastian Kanthak , Eugene Kogan , Hongyi Li , Alexander Lloyd , Sergey Melnik , David Mwaura , David Nagle , Sean Quinlan , Rajesh Rao , Lindsay Rolig , Yasushi Saito , Michal Szymaniak , Christopher Taylor , Ruth Wang , and Dale Woodford . 2012 . Spanner: Google's Globally-Distributed Database . In 10th USENIX Symposium on Operating Systems Design and Implementation, OSDI 2012 , Hollywood, CA, USA, October 8--10 , 2012, Chandu Thekkath and Amin Vahdat (Eds.). USENIX Association, 251--264. James C. Corbett, Jeffrey Dean, Michael Epstein, Andrew Fikes, Christopher Frost, J. J. Furman, Sanjay Ghemawat, Andrey Gubarev, Christopher Heiser, Peter Hochschild, Wilson C. Hsieh, Sebastian Kanthak, Eugene Kogan, Hongyi Li, Alexander Lloyd, Sergey Melnik, David Mwaura, David Nagle, Sean Quinlan, Rajesh Rao, Lindsay Rolig, Yasushi Saito, Michal Szymaniak, Christopher Taylor, Ruth Wang, and Dale Woodford. 2012. Spanner: Google's Globally-Distributed Database. In 10th USENIX Symposium on Operating Systems Design and Implementation, OSDI 2012, Hollywood, CA, USA, October 8--10, 2012, Chandu Thekkath and Amin Vahdat (Eds.). USENIX Association, 251--264."},{"key":"e_1_2_1_21_1","unstructured":"Transaction Processing Performance Council. 2010. TPC BENCHMARK\u2122 C Standard Specification Revision 5.11 Standard Specification.  Transaction Processing Performance Council. 2010. TPC BENCHMARK\u2122 C Standard Specification Revision 5.11 Standard Specification."},{"key":"e_1_2_1_22_1","first-page":"28","article-title":"The SAP HANA Database - An Architecture Overview","volume":"35","author":"F\u00e4rber Franz","year":"2012","unstructured":"Franz F\u00e4rber , Norman May , Wolfgang Lehner , Philipp Gro\u00dfe , Ingo M\u00fcller , Hannes Rauhe , and Jonathan Dees . 2012 . The SAP HANA Database - An Architecture Overview . IEEE Data Eng. Bull. 35 , 1 (2012), 28 -- 33 . Franz F\u00e4rber, Norman May, Wolfgang Lehner, Philipp Gro\u00dfe, Ingo M\u00fcller, Hannes Rauhe, and Jonathan Dees. 2012. The SAP HANA Database - An Architecture Overview. IEEE Data Eng. Bull. 35, 1 (2012), 28--33.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.14778\/2824032.2824069"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/1132863.1132867"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415535"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767867"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/279227.279229"},{"key":"e_1_2_1_28_1","volume-title":"EDBT 2019","author":"Luo Chen","year":"2019","unstructured":"Chen Luo , Pinar T\u00f6z\u00fcn , Yuanyuan Tian , Ronald Barber , Vijayshankar Raman , and Richard Sidle . 2019 . Umzi: Unified Multi-Zone Indexing for Large-Scale HTAP. In Advances in Database Technology - 22nd International Conference on Extending Database Technology , EDBT 2019 , Lisbon, Portugal, March 26--29 , 2019, Melanie Herschel, Helena Galhardas, Berthold Reinwald, Irini Fundulaki, Carsten Binnig, and Zoi Kaoudi (Eds.). 1--12. Chen Luo, Pinar T\u00f6z\u00fcn, Yuanyuan Tian, Ronald Barber, Vijayshankar Raman, and Richard Sidle. 2019. Umzi: Unified Multi-Zone Indexing for Large-Scale HTAP. In Advances in Database Technology - 22nd International Conference on Extending Database Technology, EDBT 2019, Lisbon, Portugal, March 26--29, 2019, Melanie Herschel, Helena Galhardas, Berthold Reinwald, Irini Fundulaki, Carsten Binnig, and Zoi Kaoudi (Eds.). 1--12."},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457562"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3035959"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/1284320.1284321"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/7239.7266"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2749436"},{"key":"e_1_2_1_34_1","volume-title":"2014 USENIX Annual Technical Conference, USENIX ATC '14","author":"Ongaro Diego","year":"2014","unstructured":"Diego Ongaro and John K. Ousterhout . 2014. In Search of an Understandable Consensus Algorithm . In 2014 USENIX Annual Technical Conference, USENIX ATC '14 , Philadelphia, PA, USA, June 19--20 , 2014 , Garth Gibson and Nickolai Zeldovich (Eds.). USENIX Association, 305--319. Diego Ongaro and John K. Ousterhout. 2014. In Search of an Understandable Consensus Algorithm. In 2014 USENIX Annual Technical Conference, USENIX ATC '14, Philadelphia, PA, USA, June 19--20, 2014, Garth Gibson and Nickolai Zeldovich (Eds.). USENIX Association, 305--319."},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1007\/s002360050048"},{"key":"e_1_2_1_36_1","volume-title":"Self-Driving Database Management Systems. In 8th Biennial Conference on Innovative Data Systems Research, CIDR 2017, Chaminade, CA, USA, January 8--11, 2017, Online Proceedings.","author":"Pavlo Andrew","year":"2017","unstructured":"Andrew Pavlo , Gustavo Angulo , Joy Arulraj , Haibin Lin , Jiexi Lin , Lin Ma , Prashanth Menon , Todd C. Mowry , Matthew Perron , Ian Quah , Siddharth Santurkar , Anthony Tomasic , Skye Toor , Dana Van Aken , Ziqi Wang , Yingjun Wu , Ran Xian , and Tieying Zhang . 2017 . Self-Driving Database Management Systems. In 8th Biennial Conference on Innovative Data Systems Research, CIDR 2017, Chaminade, CA, USA, January 8--11, 2017, Online Proceedings. Andrew Pavlo, Gustavo Angulo, Joy Arulraj, Haibin Lin, Jiexi Lin, Lin Ma, Prashanth Menon, Todd C. Mowry, Matthew Perron, Ian Quah, Siddharth Santurkar, Anthony Tomasic, Skye Toor, Dana Van Aken, Ziqi Wang, Yingjun Wu, Ran Xian, and Tieying Zhang. 2017. Self-Driving Database Management Systems. In 8th Biennial Conference on Innovative Data Systems Research, CIDR 2017, Chaminade, CA, USA, January 8--11, 2017, Online Proceedings."},{"key":"e_1_2_1_37_1","volume-title":"9th USENIX Symposium on Operating Systems Design and Implementation, OSDI","author":"Peng Daniel","year":"2010","unstructured":"Daniel Peng and Frank Dabek . 2010. Large-scale Incremental Processing Using Distributed Transactions and Notifications . In 9th USENIX Symposium on Operating Systems Design and Implementation, OSDI 2010 , October 4--6, 2010, Vancouver, BC, Canada, Proceedings, Remzi H. Arpaci-Dusseau and Brad Chen (Eds.). USENIX Association , 251--264. Daniel Peng and Frank Dabek. 2010. Large-scale Incremental Processing Using Distributed Transactions and Notifications. In 9th USENIX Symposium on Operating Systems Design and Implementation, OSDI 2010, October 4--6, 2010, Vancouver, BC, Canada, Proceedings, Remzi H. Arpaci-Dusseau and Brad Chen (Eds.). USENIX Association, 251--264."},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3389783"},{"key":"e_1_2_1_39_1","volume-title":"Proceedings of the 2nd International Workshop on In Memory Data Management and Analytics, IMDM 2014","author":"Shamgunov Nikita","year":"2014","unstructured":"Nikita Shamgunov . 2014 . The MemSQL In-Memory Database System . In Proceedings of the 2nd International Workshop on In Memory Data Management and Analytics, IMDM 2014 , Hangzhou, China , September 1, 2014, Justin J. Levandoski and Andrew Pavlo (Eds.). Nikita Shamgunov. 2014. The MemSQL In-Memory Database System. In Proceedings of the 2nd International Workshop on In Memory Data Management and Analytics, IMDM 2014, Hangzhou, China, September 1, 2014, Justin J. Levandoski and Andrew Pavlo (Eds.)."},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213954"},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536222.2536232"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3386134"},{"key":"e_1_2_1_43_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415553"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3554821.3554830","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:23:50Z","timestamp":1672226630000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3554821.3554830"}},"subtitle":["a 707 million tpmC distributed relational database system"],"short-title":[],"issued":{"date-parts":[[2022,8]]},"references-count":43,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2022,8]]}},"alternative-id":["10.14778\/3554821.3554830"],"URL":"https:\/\/doi.org\/10.14778\/3554821.3554830","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2022,8]]}}}