DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > CockroachDB vs. FatDB vs. Hazelcast vs. IBM Db2 Event Store vs. SAP Adaptive Server

System Properties Comparison CockroachDB vs. FatDB vs. Hazelcast vs. IBM Db2 Event Store vs. SAP Adaptive Server

Editorial information provided by DB-Engines
NameCockroachDB  Xexclude from comparisonFatDB  Xexclude from comparisonHazelcast  Xexclude from comparisonIBM Db2 Event Store  Xexclude from comparisonSAP Adaptive Server infoformer name: Sybase ASE  Xexclude from comparison
FatDB/FatCloud has ceased operations as a company with February 2014. FatDB is discontinued and excluded from the ranking.
DescriptionCockroachDB is a distributed database architected for modern cloud applications. It is wire compatible with PostgreSQL and backed by a Key-Value Store, which is either RocksDB or a purpose-built derivative, called Pebble.A .NET NoSQL DBMS that can integrate with and extend SQL Server.A widely adopted in-memory data gridDistributed Event Store optimized for Internet of Things use casesThe SAP (Sybase) Adaptive Server Enterprise (ASE) is an enterprise-class RDBMS
Primary database modelRelational DBMSDocument store
Key-value store
Key-value storeEvent Store
Time Series DBMS
Relational DBMS
Secondary database modelsDocument store infoJSON support with IMDG 3.12Spatial DBMS infowith Boeing's Spatial Query Server
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.73
Rank#58  Overall
#34  Relational DBMS
Score5.46
Rank#61  Overall
#7  Key-value stores
Score0.27
Rank#309  Overall
#2  Event Stores
#28  Time Series DBMS
Score35.09
Rank#25  Overall
#17  Relational DBMS
Websitewww.cockroachlabs.comhazelcast.comwww.ibm.com/­products/­db2-event-storewww.sap.com/­products/­technology-platform/­sybase-ase.html
Technical documentationwww.cockroachlabs.com/­docshazelcast.org/­imdg/­docswww.ibm.com/­docs/­en/­db2-event-storehelp.sap.com/­docs/­SAP_ASE
DeveloperCockroach LabsFatCloudHazelcastIBMSAP, Sybase
Initial release20152012200820171987
Current release24.1.0, May 20245.3.6, November 20232.016.0
License infoCommercial or Open SourceOpen Source infoApache 2.0, commercial license availablecommercialOpen Source infoApache Version 2; commercial licenses availablecommercial infofree developer edition availablecommercial
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageGoC#JavaC and C++C and C++
Server operating systemsLinux
macOS
Windows
WindowsAll OS with a Java VMLinux infoLinux, macOS, Windows for the developer additionAIX
HP-UX
Linux
Solaris
Unix
Windows
Data schemedynamic schemaschema-freeschema-freeyesyes
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.noyes infothe object must implement a serialization strategynono
Secondary indexesyesyesyesnoyes
SQL infoSupport of SQLyes, wire compatible with PostgreSQLno infoVia inetgration in SQL ServerSQL-like query languageyes infothrough the embedded Spark runtimeyes
APIs and other access methodsJDBC.NET Client API
LINQ
RESTful HTTP API
RPC
Windows WCF Bindings
JCache
JPA
Memcached protocol
RESTful HTTP API
ADO.NET
DB2 Connect
JDBC
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesC#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
C#.Net
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
Python
Scala
C
C#
C++
Cobol
Delphi
Fortran
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Scala
Visual Basic
C
C++
Cobol
Java
Java
Perl
PHP
Python
Server-side scripts infoStored proceduresnoyes infovia applicationsyes infoEvent Listeners, Executor ServicesyesJava and Transact-SQL
Triggersnoyes infovia applicationsyes infoEventsnoyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning (by key range) infoall tables are translated to an ordered KV store and then broken down into 64MB ranges, which are then used as replicas in RAFTShardingShardingShardinghorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication using RAFTselectable replication factoryes infoReplicated MapActive-active shard replicationMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency
Immediate Consistency or Eventual Consistency selectable by user infoRaft Consensus AlgorithmEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoone or two-phase-commit; repeatable reads; read commitednoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesNo - written data is immutableyes
Durability infoSupport for making data persistentyesyesyesYes - Synchronous writes to local disk combined with replication and asynchronous writes in parquet format to permanent shared storageyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes
User concepts infoAccess controlRole-based access controlno infoCan implement custom security layer via applicationsRole-based access controlfine 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
CockroachDBFatDBHazelcastIBM Db2 Event StoreSAP Adaptive Server infoformer name: Sybase ASE
Recent citations in the news

Cockroach Labs Deepens Partnership with Google Cloud, CockroachDB Selected to Join Google Distributed Cloud
9 April 2024, PR Newswire

CockroachDB tempts legacy databases to crawl into the cloud age
29 January 2024, The Register

How DoorDash Migrated from Aurora Postgres to CockroachDB
5 December 2023, The New Stack

DoorDash Uses CockroachDB to Create Config Management Platform for Microservices
14 February 2024, InfoQ.com

How to Unlock Real-Time Data Streams with CockroachDB and Amazon MSK | Amazon Web Services
6 November 2023, AWS Blog

provided by Google News

Hazelcast Weaves Wider Logic Threads Through The Data Fabric
7 March 2024, Forbes

Hazelcast 5.4 real time data processing platform boosts AI and consistency
17 April 2024, VentureBeat

Hazelcast appoints Anthony Griffin as Chief Architect -
11 June 2024, Enterprise Times

Hazelcast Showcases Real-Time Data Platform at 2024 Gartner Summit
15 May 2024, Datanami

Hazelcast Versus Redis: A Practical Comparison
4 January 2024, Database Trends and Applications

provided by Google News

Advancements in streaming data storage, real-time analysis and machine learning
25 July 2019, IBM

How IBM Is Turning Db2 into an 'AI Database'
3 June 2019, Datanami

Best cloud databases of 2022
4 October 2022, ITPro

Why a robust data management strategy is essential today | IBM HDM
19 September 2019, Express Computer

provided by Google News

Achieve zero RPO for your SAP ASE (Sybase) databases with Amazon FSx for NetApp ONTAP | Amazon Web Services
7 May 2024, AWS Blog

New Services for SAP HANA Cloud Database
7 April 2021, SAP News

Patch SAP Adaptive Server Enterprise now to avoid takeover risk
3 June 2020, BleepingComputer

AWS Launch Wizard is now available in Melbourne, Spain, and Zurich Regions
26 January 2024, AWS Blog

Newly Patched SAP ASE Flaws Could Let Attackers Hack Database Servers
3 June 2020, The Hacker News

provided by Google News



Share this page

Featured Products

Neo4j logo

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus 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

Present your product here