DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > IBM Cloudant vs. OceanBase vs. Postgres-XL vs. SAP SQL Anywhere

System Properties Comparison IBM Cloudant vs. OceanBase vs. Postgres-XL vs. SAP SQL Anywhere

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameIBM Cloudant  Xexclude from comparisonOceanBase  Xexclude from comparisonPostgres-XL  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparison
DescriptionDatabase as a Service offering based on Apache CouchDBA distributed, high available RDBMS compatible with Oracle and MySQLBased on PostgreSQL enhanced with MPP and write-scale-out cluster featuresRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelDocument storeRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument store
Wide column store
Document store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.77
Rank#99  Overall
#18  Document stores
Score2.03
Rank#119  Overall
#58  Relational DBMS
Score0.42
Rank#261  Overall
#120  Relational DBMS
Score3.64
Rank#79  Overall
#43  Relational DBMS
Websitewww.ibm.com/­products/­cloudanten.oceanbase.comwww.postgres-xl.orgwww.sap.com/­products/­technology-platform/­sql-anywhere.html
Technical documentationcloud.ibm.com/­docs/­Cloudanten.oceanbase.com/­docs/­oceanbase-databasewww.postgres-xl.org/­documentationhelp.sap.com/­docs/­SAP_SQL_Anywhere
DeveloperIBM, Apache Software Foundation infoIBM acquired Cloudant in February 2014OceanBase infopreviously Alibaba and Ant GroupSAP infoformerly Sybase
Initial release201020102014 infosince 2012, originally named StormDB1992
Current release4.3.0, April 202410 R1, October 201817, July 2015
License infoCommercial or Open SourcecommercialOpen Source infoCommercial license availableOpen Source infoMozilla public licensecommercial
Cloud-based only infoOnly available as a cloud serviceyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageErlangC++C
Server operating systemshostedLinuxLinux
macOS
AIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemeschema-freeyesyesyes
Typing infopredefined data types such as float or datenoyesyesyes
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.noyesyes infoXML type, but no XML query functionalityyes
Secondary indexesyesyesyesyes
SQL infoSupport of SQLnoyesyes infodistributed, parallel query executionyes
APIs and other access methodsRESTful HTTP/JSON APIJDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Proprietary native API
Table API
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languagesC#
Java
JavaScript
Objective-C
PHP
Ruby
Ada 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
.Net
C
C++
Delphi
Erlang
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresView functions (Map-Reduce) in JavaScriptPL/SQL in oracle-compatible mode, MySQL Stored Procedure in mysql-compatible modeuser defined functionsyes, in C/C++, Java, .Net or Perl
Triggersyesyesyesyes
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning (by hash, key, range, range columns, list, and list columns)horizontal partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
Multi-source replication using PaxosSource-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoatomic operations within a document possibleACIDACID infoMVCCACID
Concurrency infoSupport for concurrent manipulation of datayes infoOptimistic lockingyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyes
User concepts infoAccess controlAccess rights for users can be defined per databaseAccess rights for users, groups and roles according to SQL-standardfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

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

More resources
IBM CloudantOceanBasePostgres-XLSAP SQL Anywhere infoformerly called Adaptive Server Anywhere
Recent citations in the news

IBM Code Engine and IBM Cloudant: Serverless Data and Infrastructure
16 August 2021, IBM

IBM Cloud Data Services Newsletter
22 July 2020, IBM

Truck Tracker: An IoT Pattern Using IBM Cloud Services
6 January 2022, IBM

IBM Recognized in the TrustRadius 2022 Top Rated Awards
12 May 2022, IBM

Introducing the IBM Cloud Developer Console
16 March 2017, IBM

provided by Google News

Fintech giant Ant Group spins off database firm as Alibaba affiliates take stake
4 October 2024, South China Morning Post

Meet the Database Built for Modern-Day Pressures (And Your AI Dreams Too)
24 June 2024, CDOTrends

How GCash leverages OceanBase database solution to accelerate its growth and serve over 90 million users
8 October 2024, Asian Business Review

OceanBase announces its listing on Google Cloud Marketplace, expanding cloud database services to 80 availability zones worldwide
27 June 2024, PR Newswire

OceanBase Cloud Database Will Be Available on Google Cloud Marketplace
27 June 2024, Fintech News Singapore

provided by Google News

Rimini Street expands support beyond SAP and Oracle
11 June 2022, InsideSAP

SAP Products & Services Data Portfolio
2 July 2021, Datamation

Securing SAP with AWS Network Firewall: Part 2 – Managed Rules
17 July 2023, AWS Blog

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

MindsDB is now the leading and fastest growing applied ML platform in the world
3 November 2022, PR Newswire

provided by Google News



Share this page

Featured Products

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

Milvus logo

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

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Neo4j logo

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

Present your product here