DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > OceanBase

OceanBase System Properties

Please select another system to compare it with OceanBase.

Our visitors often compare OceanBase with TiDB, MySQL and Oracle.

Editorial information provided by DB-Engines
NameOceanBase
DescriptionA distributed, high available RDBMS compatible with Oracle and MySQL
Primary database modelRelational DBMS
Secondary database modelsDocument store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.66
Rank#147  Overall
#68  Relational DBMS
Websiteen.oceanbase.com
Technical documentationen.oceanbase.com/­docs/­oceanbase-database
DeveloperOceanBase infopreviously Alibaba and Ant Group
Initial release2010
Current release4.3.0, April 2024
License infoCommercial or Open SourceOpen Source infoCommercial license available
Cloud-based only infoOnly available as a cloud serviceno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++
Server operating systemsLinux
Data schemeyes
Typing infopredefined data types such as float or dateyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes
Secondary indexesyes
SQL infoSupport of SQLyes
APIs and other access methodsJDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Proprietary native API
Table API
Supported programming languagesAda infoin MySQL-compatible model
C infoin Oracle- and MySQL- compatible models
C++ infoin Oracle- and MySQL- compatible models
D infoin MySQL-compatible model
Delphi infoin MySQL-compatible model
Eiffel infoin MySQL-compatible model
Erlang infoin MySQL-compatible model
Haskell infoin MySQL-compatible model
Java infoin Oracle- and MySQL- compatible models
JavaScript (Node.js) infoin MySQL-compatible model
Objective-C infoin MySQL-compatible model
OCaml infoin MySQL-compatible model
Perl infoin MySQL-compatible model
PHP infoin MySQL-compatible model
Python infoin MySQL-compatible model
Ruby infoin MySQL-compatible model
Scheme infoin MySQL-compatible model
Tcl infoin MySQL-compatible model
Server-side scripts infoStored proceduresPL/SQL in oracle-compatible mode, MySQL Stored Procedure in mysql-compatible mode
Triggersyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning (by hash, key, range, range columns, list, and list columns)
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication using Paxos
MapReduce infoOffers an API for user-defined Map/Reduce methodsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integrityyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID
Concurrency infoSupport for concurrent manipulation of datayes
Durability infoSupport for making data persistentyes
User concepts infoAccess controlAccess rights for users, groups and roles according to SQL-standard
More information provided by the system vendor
OceanBase
Specific characteristics

OceanBase Database is the world’s only native distributed database that has set new world records in both the TPC-C and TPC-H benchmark tests.

It has been firmly supporting the Tmall Double 11 shopping event over the past consecutive ten years. Its creative solution of five IDCs across three sites sets a new standard for disaster recovery at city level. With integrated architecture, it achieves both the scalability of distributed databases and the performance of centralized databases. It can handle HTAP mixed loads with one set of computing engines at the same time.

OceanBase Database features strong data consistency, high availability, high performance, online scaling, high compatibility with SQL standards and other mainstream relational databases, transparency to applications, and high-cost efficiency. 

Competitive advantages
  • High Availability: The five IDCs across three sites disaster recovery solution sets a new standard for disaster recovery at city level.Based on the Paxos protocol for log transfer, OceanBase Database supports multiple data replicas and realizes automatical disaster recovery with zero data loss on ordinary servers.
     
  • High performance: OceanBase adopts a read/write splitting architecture. Data is divided into baseline data and incremental data. The incremental data is stored in memory in the memtable format, and the baseline data is stored on SSDs in the SSTable format. You can only modify incremental data in memtables. All DML operations are performed on memtables, providing excellent performance.
     
  • Real-time HTAP: With one single database, OceanBase Database can handle HTAP mixed loads with one set of high-performance parallel execution engines at the same time and isolates the computing resources of different workloads to keep away from resource contention.
     
  • Super Scale: Perform horizontal scalings without influencing your business, and rapidly realize business scaling in/out.OceanBase Database supports thousands of cluster nodes, the maximum data volume of a single cluster can be more than 3PB, and the maximum number of rows of a single table can reach trillions.
     
  • Cost Efficiency: OceanBase achieves a high compression ratio through data encoding and compression. Data encoding provides a series of encoding methods based on the value range and type information of different fields in the database relational table. Data encoding "knows" data better than general compression algorithms. Therefore, it offers a higher compression ratio.
     
  • High Compatibility: OceanBase is compatible with common MySQL/Oracle features and frontend/backend MySQL/Oracle protocols. You can migrate businesses from MySQL/Oracle databases to OceanBase Database with zero or a few modifications.
Key customers

OceanBase Database has helped over 400 customers across industries upgrade their core systems, including:

Find more OceanBase client reference.

Market metrics
  • TPC-C No.1 Performance, achieved a result of 707.35 million tpmC in the TPC-C benchmark based on ordinary cloud servers.
  • TPC-H No.3 Performance, achieved a result of 15.27 million QphH@30,000GB in the TPC-H benchmark based on ordinary cloud servers.
Licensing and pricing models
  • Mulan PubL v2 license for open source community edition.
  • Commercial license for enterprise edition.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
OceanBase
Recent citations in the news

OceanBase Inks Agreement with NTU Singapore in Database Optimization and Green Computing Advancements
31 January 2024, PR Newswire

Ant Group Will Cut Foreign Investors Out of Fast-Growing Database Business
22 August 2023, The Information

How Southeast Asia's Leading e-Wallets Saved Up to 40% in Database Costs - Fintech Singapore
25 March 2024, Fintech News Singapore

Haidilao’s 6-step recipe for successful digital transformation with OceanBase
4 August 2023, Tech in Asia

Alibaba's OceanBase distributed database aims at markets outside China
16 August 2022, InfoWorld

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here