DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > CrateDB vs. etcd vs. Faircom EDGE vs. SAP HANA vs. Transbase

System Properties Comparison CrateDB vs. etcd vs. Faircom EDGE vs. SAP HANA vs. Transbase

Editorial information provided by DB-Engines
NameCrateDB  Xexclude from comparisonetcd  Xexclude from comparisonFaircom EDGE infoformerly c-treeEDGE  Xexclude from comparisonSAP HANA  Xexclude from comparisonTransbase  Xexclude from comparison
DescriptionDistributed Database based on LuceneA distributed reliable key-value storeFairCom EDGE is an Industry 4.0 solution built to integrate, collect, aggregate and synchronize mission-critical data in edge computing environmentsIn-memory, column based data store. Available as appliance or cloud serviceA resource-optimized, high-performance, universally applicable RDBMS
Primary database modelDocument store
Spatial DBMS
Search engine
Time Series DBMS
Vector DBMS
Key-value storeKey-value store
Relational DBMS
Relational DBMSRelational DBMS
Secondary database modelsRelational DBMSDocument store
Graph DBMS infowith SAP Hana, Enterprise Edition
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.66
Rank#223  Overall
#37  Document stores
#5  Spatial DBMS
#17  Search engines
#19  Time Series DBMS
#15  Vector DBMS
Score7.06
Rank#47  Overall
#5  Key-value stores
Score0.02
Rank#364  Overall
#57  Key-value stores
#152  Relational DBMS
Score35.22
Rank#22  Overall
#15  Relational DBMS
Score0.00
Rank#381  Overall
#156  Relational DBMS
Websitecratedb.cometcd.io
github.com/­etcd-io/­etcd
www.faircom.com/­products/­faircom-edgewww.sap.com/­products/­hana.htmlwww.transaction.de/­en/­products/­transbase.html
Technical documentationcratedb.com/­docsetcd.io/­docs
github.com/­etcd-io/­etcd/­tree/­master/­Documentation
docs.faircom.com/­docs/­en/­UUID-23d4f1fd-d213-f6d5-b92e-9b7475baa14e.htmlhelp.sap.com/­hanawww.transaction.de/­en/­products/­transbase/­features.html
DeveloperCrateFairCom CorporationSAPTransaction Software GmbH
Initial release2013197920101987
Current release5.8.1, August 20243.4, August 2019V3, October 20202.0 SPS07 (April 4, 2023), April 2023Transbase 8.3, 2022
License infoCommercial or Open SourceOpen SourceOpen Source infoApache Version 2.0commercial infoRestricted, free version availablecommercialcommercial infofree development license
Cloud-based only infoOnly available as a cloud servicenononono infoalso available as a cloud based serviceno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaGoANSI C, C++C and C++
Server operating systemsAll Operating Systems, including Kubernetes with CrateDB Kubernetes Operator supportFreeBSD
Linux
Windows infoexperimental
Android
Linux infoARM, x86
Raspbian
Windows
Appliance or cloud-serviceFreeBSD
Linux
macOS
Solaris
Windows
Data schemeFlexible Schema (defined schema, partial schema, schema free)schema-freeFlexible Schema (defined schema, partial schema, schema free)yesyes
Typing infopredefined data types such as float or dateyesnoyes, ANSI Standard SQL Typesyesyes
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.nonoyesnono
Secondary indexesyesnoyesyesyes
SQL infoSupport of SQLyes, but no triggers and constraints, and PostgreSQL compatibilitynoyes infoANSI SQL queriesyesyes
APIs and other access methodsADO.NET
JDBC
ODBC
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API
gRPC
JSON over HTTP
ADO.NET
Direct SQL
IoT Microservice layer
JDBC
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
JDBC
ODBC
ADO.NET
JDBC
ODBC
Proprietary native API
Supported programming languages.NET
Erlang
Go infocommunity maintained client
Java
JavaScript (Node.js) infocommunity maintained client
Perl infocommunity maintained client
PHP
Python
R
Ruby infocommunity maintained client
Scala infocommunity maintained client
.Net
C
C++
Clojure
Erlang
Go
Haskell
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Rust
Scala
Tcl
C
C#
C++
Java
JavaScript
PHP
Python
VB.Net
C
C#
C++
Java
JavaScript
Kotlin
Objective-C
PHP
Python
Server-side scripts infoStored proceduresuser defined functions (Javascript)noyes info.Net, JavaScript, C/C++SQLScript, Ryes
Triggersnoyes, watching key changesyesyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingFile partitioning infoCustomizable business rules for partitioningyes
Replication methods infoMethods for redundantly storing data on multiple nodesConfigurable replication on table/partition-levelUsing Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.yes infoSynchronous and asynchronous realtime replication based on transaction logsyesSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Read-after-write consistency on record level
Immediate ConsistencyImmediate Consistency
Tunable Consistency
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyes infowhen using SQLyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infounique row identifiers can be used for implementing an optimistic concurrency control strategynoACIDACIDyes
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoacross SQL and NoSQLyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyesyesno
User concepts infoAccess controlrights management via user accountsnoFine grained user, group and file access rights managed across SQL (per ANSI standard) and NoSQL.yesfine 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
CrateDBetcdFaircom EDGE infoformerly c-treeEDGESAP HANATransbase
Recent citations in the news

CrateDB Collaborates with ABB for Their industrial IoT and AI Suite
3 December 2024, PR Newswire

ABB Revolutionizes Smart Charging with OPTIMAX® Cloud, Powered by CrateDB
21 January 2025, PR Newswire

Real-Time Analytics Database Company CrateDB Names Lars Färnström as New CEO
1 March 2023, Business Wire

Crate.io raises $10M to grow its database platform
15 June 2021, VentureBeat

Crate.io Taps Jodok Schäffler to Oversee the Company’s Growing IoT Data Solutions
6 March 2019, GlobeNewswire

provided by Google News

⎈ DIY: Create your own cloud, etcd and raft, Observability solution with ClickHouse, Pod with more than one network, port-forward explained
4 September 2024, substack.com

ETCD guidelines: RBI seeks to balance rupee stability, competitiveness | Policy Circle
8 April 2024, Policy Circle

etcd gets ready to graduate
17 November 2020, AWS Blog

How to restore a Kubernetes cluster from an etcd snapshot
16 December 2021, TechTarget

A Kubernetes Operator for etcd
13 October 2020, InfoQ.com

provided by Google News

Brokers, Protocols, Platform Move Manufacturing Data
26 July 2023, EE Times

Is MQTT Becoming the De Facto Standard of Industry 4.0?
3 February 2025, IoT For All

Trend-Setting Products in Data and Information Management for 2023
8 December 2022, Database Trends and Applications

Extending the Life of COBOL Applications
28 February 2022, IoT For All

Trend-Setting Products in Data and Information Management for 2024
6 December 2023, Database Trends and Applications

provided by Google News

SAP threatened by its own legacy software
14 February 2025, Computing

Combine the Power of AI with Business Context Using SAP HANA Cloud Vector Engine
2 April 2024, SAP News

SAPwned: SAP AI vulnerabilities expose customers’ cloud environments and private AI artifacts
17 July 2024, Wiz

Automate SAP S/4HANA infrastructure deployment on IBM Power Virtual Server with deployable architectures
6 December 2024, ibm.com

Customers enhance SAP availability with SUSE solutions on AWS | Amazon Web Services
9 October 2024, AWS Blog

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

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

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