{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,19]],"date-time":"2026-03-19T02:25:52Z","timestamp":1773887152169,"version":"3.50.1"},"reference-count":48,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2023,8]]},"abstract":"<jats:p>In the ongoing evolution of the OceanBase database system, it is essential to enhance its adaptability to small-scale enterprises. The OceanBase database system has demonstrated its stability and effectiveness within the Ant Group and other commercial organizations, besides through the TPC-C and TPC-H tests. In this paper, we have designed a stand-alone and distributed integrated architecture named Paetica to address the overhead caused by the distributed components in the stand-alone mode, with respect to the OceanBase system. Paetica enables adaptive configuration of the database that allows OceanBase to support both serial and parallel executions in stand-alone and distributed scenarios, thus providing efficiency and economy. This design has been implemented in version 4.0 of the OceanBase system, and the experiments show that Paetica exhibits notable scalability and outperforms alternative stand-alone or distributed databases. Furthermore, it enables the transition of OceanBase from primarily serving large enterprises to truly catering to small and medium enterprises, by employing a single OceanBase database for the successive stages of enterprise or business development, without the requirement for migration. Our experiments confirm that Paetica has achieved linear scalability with the increasing CPU core number within the stand-alone mode. It also outperforms MySQL and Greenplum in the Sysbench and TPC-H evaluations.<\/jats:p>","DOI":"10.14778\/3611540.3611560","type":"journal-article","created":{"date-parts":[[2023,9,15]],"date-time":"2023-09-15T11:32:37Z","timestamp":1694777557000},"page":"3728-3740","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":25,"title":["OceanBase Paetica: A Hybrid Shared-Nothing\/Shared-Everything Database for Supporting Single Machine and Distributed Cluster"],"prefix":"10.14778","volume":"16","author":[{"given":"Zhifeng","family":"Yang","sequence":"first","affiliation":[{"name":"OceanBase, Ant Group"}]},{"given":"Quanqing","family":"Xu","sequence":"additional","affiliation":[{"name":"OceanBase, Ant Group"}]},{"given":"Shanyan","family":"Gao","sequence":"additional","affiliation":[{"name":"OceanBase, Ant Group"}]},{"given":"Chuanhui","family":"Yang","sequence":"additional","affiliation":[{"name":"OceanBase, Ant Group"}]},{"given":"Guoping","family":"Wang","sequence":"additional","affiliation":[{"name":"OceanBase, Ant Group"}]},{"given":"Yuzhong","family":"Zhao","sequence":"additional","affiliation":[{"name":"OceanBase, Ant Group"}]},{"given":"Fanyu","family":"Kong","sequence":"additional","affiliation":[{"name":"OceanBase, Ant Group"}]},{"given":"Hao","family":"Liu","sequence":"additional","affiliation":[{"name":"OceanBase, Ant Group"}]},{"given":"Wanhong","family":"Wang","sequence":"additional","affiliation":[{"name":"OceanBase, Ant Group"}]},{"given":"Jinliang","family":"Xiao","sequence":"additional","affiliation":[{"name":"OceanBase, Ant Group"}]}],"member":"320","published-online":{"date-parts":[[2023,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"2021. Favorite of Taobao.com. https:\/\/shoucang.taobao.com."},{"key":"e_1_2_1_2_1","unstructured":"2021. MulanPubL-2.0. https:\/\/license.coscl.org.cn\/MulanPubL-2.0\/index.html."},{"key":"e_1_2_1_3_1","unstructured":"2021. OceanBase. https:\/\/gitee.com\/oceanbase."},{"key":"e_1_2_1_4_1","unstructured":"2021. OceanBase. https:\/\/github.com\/oceanbase."},{"key":"e_1_2_1_5_1","unstructured":"2021. OceanBase: 15 million QphH@30 000GB. http:\/\/tpc.org\/3375."},{"key":"e_1_2_1_6_1","unstructured":"2021. OceanBase: 707 million tmpC. http:\/\/tpc.org\/1803."},{"key":"e_1_2_1_7_1","unstructured":"2023. TPC-H. https:\/\/www.tpc.org\/tpch\/."},{"key":"e_1_2_1_8_1","volume-title":"Int. Conf. on Parallel and Distributed Computing Systems (PDCS). Citeseer.","author":"Al-Houmaily Y","year":"1995","unstructured":"Y Al-Houmaily and P Chrysanthis. 1995. Two-phase commit in gigabit-networked distributed databases. In Int. Conf. on Parallel and Distributed Computing Systems (PDCS). Citeseer."},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056103"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.14778\/3358701.3358702"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/319996.319998"},{"key":"e_1_2_1_12_1","unstructured":"William Bridge Ashok Joshi M Keihl Tirthankar Lahiri Juan Loaiza and N MacNaughton. 1997. The oracle universal server buffer manager. In PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON VERY LARGE DATA BASES. Citeseer 590--594."},{"key":"e_1_2_1_13_1","volume-title":"POLARDB Meets Computational Storage: Efficiently Support Analytical Workloads in Cloud-Native Relational Database. In 18th USENIX Conference on File and Storage Technologies, FAST 2020","author":"Cao Wei","year":"2020","unstructured":"Wei Cao, Yang Liu, Zhushi Cheng, Ning Zheng, Wei Li, Wenjie Wu, Linqiang Ouyang, Peng Wang, Yijing Wang, Ray Kuan, Zhenjun Liu, Feng Zhu, and Tong Zhang. 2020. POLARDB Meets Computational Storage: Efficiently Support Analytical Workloads in Cloud-Native Relational Database. In 18th USENIX Conference on File and Storage Technologies, FAST 2020, Santa Clara, CA, USA, February 24--27, 2020, Sam H. Noh and Brent Welch (Eds.). USENIX Association, 29--41."},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/6513.6517"},{"key":"e_1_2_1_15_1","volume-title":"Apache cassandra. Website. Available online at http:\/\/planetcassandra.org\/what-isapache-cassandra 13","author":"Cassandra Apache","year":"2014","unstructured":"Apache Cassandra. 2014. Apache cassandra. Website. Available online at http:\/\/planetcassandra.org\/what-isapache-cassandra 13 (2014)."},{"key":"e_1_2_1_16_1","unstructured":"Transaction Processing Performance Council. 2010. TPC BENCHMARK\u2122 C Standard Specification Revision 5.11 Standard Specification."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457551"},{"key":"e_1_2_1_18_1","unstructured":"Maxwell Dayvson Da Silva and Hugo Lopes Tavares. 2015. Redis Essentials. Packt Publishing Ltd."},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1294261.1294281"},{"key":"e_1_2_1_20_1","volume-title":"2022 USENIX Annual Technical Conference (USENIX ATC 22)","author":"Elhemali Mostafa","year":"2022","unstructured":"Mostafa Elhemali, Niall Gallagher, Bin Tang, Nick Gordon, Hao Huang, Haibo Chen, Joseph Idziorek, Mengtian Wang, Richard Krog, Zongpeng Zhu, et al. 2022. Amazon {DynamoDB}: A Scalable, Predictably Performant, and Fully Managed {NoSQL} Database Service. In 2022 USENIX Annual Technical Conference (USENIX ATC 22). 1037--1048."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1109\/SPDP.1994.346175"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/1132863.1132867"},{"key":"e_1_2_1_23_1","volume-title":"Oracle essentials: Oracle database 12c. \" O'Reilly Media","author":"Greenwald Rick","unstructured":"Rick Greenwald, Robert Stackowiak, and Jonathan Stern. 2013. Oracle essentials: Oracle database 12c. \" O'Reilly Media, Inc.\"."},{"key":"e_1_2_1_24_1","volume-title":"Group Commit Timers and High","author":"Helland Pat","year":"1987","unstructured":"Pat Helland, Harald Sammer, Jim Lyon, Richard Carr, Phil Garrett, and Andreas Reuter. 1987. Group Commit Timers and High Volume Transaction Systems. In High Performance Transaction Systems, 2nd International Workshop, Asilomar Conference Center, Pacific Grove, California, USA, September 28--30, 1987, Proceedings (Lecture Notes in Computer Science), Dieter Gawlick, Mark N. Haynie, and Andreas Reuter (Eds.), Vol. 359. Springer, 301--329."},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415535"},{"key":"e_1_2_1_26_1","volume-title":"Sysbench: Scriptable database and system performance benchmark.","author":"Kopytov Alexey","year":"2018","unstructured":"Alexey Kopytov. 2018. Sysbench: Scriptable database and system performance benchmark."},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1109\/BigData.2013.6691589"},{"key":"e_1_2_1_28_1","first-page":"4","article-title":"Paxos made simple","volume":"32","author":"Lamport Leslie","year":"2001","unstructured":"Leslie Lamport. 2001. Paxos made simple. ACM SIGACT News (Distributed Computing Column) 32, 4 (Whole Number 121, December 2001) (2001), 51--58.","journal-title":"ACM SIGACT News (Distributed Computing Column)"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.14778\/3352063.3352141"},{"key":"e_1_2_1_30_1","doi-asserted-by":"crossref","unstructured":"Yi Lu Xiangyao Yu Lei Cao and Samuel Madden. 2021. Epoch-based commit and replication in distributed OLTP databases. (2021).","DOI":"10.14778\/3446095.3446098"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457562"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536360.2536366"},{"key":"e_1_2_1_33_1","unstructured":"DB Mongo. 2015. Mongodb."},{"key":"e_1_2_1_34_1","unstructured":"AB MySQL. 2001. MySQL."},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1109\/BigData.2014.7004224"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1007\/s002360050048"},{"key":"e_1_2_1_37_1","volume-title":"Web resource: http:\/\/www.PostgreSQL.org\/about","author":"Behandelt","year":"1996","unstructured":"Behandelt PostgreSQL. 1996. PostgreSQL. Web resource: http:\/\/www.PostgreSQL.org\/about (1996)."},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1007\/BF01299677"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1017\/S0956796818000102"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.1109\/MSST.2010.5496972"},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1109\/ISPA.2011.43"},{"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.1145\/3035918.3056101"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.14778\/3547305.3547307"},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICCSNT.2011.6182030"},{"key":"e_1_2_1_46_1","volume-title":"LCL: A Lock Chain Length-based Distributed Algorithm for Deadlock Detection and Resolution. In 2023 IEEE 39th International Conference on Data Engineering. IEEE, xxx--xxx.","author":"Yang Zhenkun","year":"2023","unstructured":"Zhenkun Yang, Chen Qian, Xuwang Teng, Fanyu Kong, Fusheng Han, and Quanqing Xu. 2023. LCL: A Lock Chain Length-based Distributed Algorithm for Deadlock Detection and Resolution. In 2023 IEEE 39th International Conference on Data Engineering. IEEE, xxx--xxx."},{"key":"e_1_2_1_47_1","doi-asserted-by":"publisher","DOI":"10.14778\/3554821.3554830"},{"key":"e_1_2_1_48_1","doi-asserted-by":"publisher","DOI":"10.14778\/3583140.3583153"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3611540.3611560","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,10]],"date-time":"2025-09-10T22:34:09Z","timestamp":1757543649000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3611540.3611560"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,8]]},"references-count":48,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2023,8]]}},"alternative-id":["10.14778\/3611540.3611560"],"URL":"https:\/\/doi.org\/10.14778\/3611540.3611560","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2023,8]]},"assertion":[{"value":"2023-08-01","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}