DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > CrateDB vs. etcd vs. IBM Db2 warehouse vs. Newts vs. SAP HANA

System Properties Comparison CrateDB vs. etcd vs. IBM Db2 warehouse vs. Newts vs. SAP HANA

Editorial information provided by DB-Engines
NameCrateDB  Xexclude from comparisonetcd  Xexclude from comparisonIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparisonNewts  Xexclude from comparisonSAP HANA  Xexclude from comparison
DescriptionDistributed Date Store based on LuceneA distributed reliable key-value storeCloud-based data warehousing serviceTime Series DBMS based on CassandraIn-memory, column based data store. Available as appliance or cloud service
Primary database modelRelational DBMS
Search engine
Key-value storeRelational DBMSTime Series DBMSRelational DBMS
Secondary database modelsDocument store
Time Series DBMS
Document store
Graph DBMS infowith SAP Hana, Enterprise Edition
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.94
Rank#183  Overall
#88  Relational DBMS
#13  Search engines
Score10.31
Rank#48  Overall
#6  Key-value stores
Score1.73
Rank#133  Overall
#66  Relational DBMS
Score0.00
Rank#357  Overall
#33  Time Series DBMS
Score54.96
Rank#21  Overall
#13  Relational DBMS
Websitecrate.ioetcd.io
github.com/­etcd-io/­etcd
www.ibm.com/­products/­db2-warehouseopennms.github.io/­newtswww.sap.com/­products/­hana.html
Technical documentationcrate.io/­docsetcd.io/­docs
github.com/­etcd-io/­etcd/­tree/­master/­Documentation
github.com/­OpenNMS/­newts/­wikihelp.sap.com/­hana
DeveloperCrateIBMOpenNMS GroupSAP
Initial release2013201420142010
Current release3.4, August 20192.0 SPS05 (June 26, 2020), June 2020
License infoCommercial or Open SourceOpen SourceOpen Source infoApache Version 2.0commercialOpen Source infoApache 2.0commercial
Cloud-based only infoOnly available as a cloud servicenonoyesnono infoalso available as a cloud based service
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaGoJava
Server operating systemsAll OS with a Java 7 (and higher) VMFreeBSD
Linux
Windows infoexperimental
hostedLinux
OS X
Windows
Appliance or cloud-service
Data schemeFlexible Schema (defined schema, partial schema, schema free)schema-freeyesschema-freeyes
Typing infopredefined data types such as float or dateyesnoyesyesyes
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.nonono infoImport/export of XML data possiblenono
Secondary indexesyesnoyesnoyes
SQL infoSupport of SQLyes, but no triggers and constraintsnoyesnoyes
APIs and other access methodsADO.NET infocommunity maintained client
JDBC
MQTT (Message Queue Telemetry Transport)
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API
gRPC
JSON over HTTP
.NET Client API
JDBC
ODBC
OLE DB
HTTP REST
Java API
JDBC
ODBC
Supported programming languagesErlang
Go infocommunity maintained client
Java
JavaScript (Node.js) infocommunity maintained client
Perl infocommunity maintained client
PHP
Python
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
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Java
Server-side scripts infoStored proceduresuser defined functionsnoPL/SQL, SQL PLnoSQLScript, R
Triggersnoyes, watching key changesyesnoyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infobased on Cassandrayes
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorUsing Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.yesselectable replication factor infobased on Cassandrayes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Read Your Own Writes Consistency infofor primary key lookups
Immediate ConsistencyImmediate ConsistencyEventual Consistency infobased on Cassandra
Immediate Consistency infobased on Cassandra
Immediate Consistency
Foreign keys infoReferential integritynonoyesnoyes
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 strategynoACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
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.nonoyesnoyes
User concepts infoAccess controlrights management via user accountsnofine grained access rights according to SQL-standardnoyes
More information provided by the system vendor
CrateDBetcdIBM Db2 warehouse infoformerly named IBM dashDBNewtsSAP HANA
Specific characteristicsCrateDB is an open source distributed SQL database that spreads data and processing...
» more
Competitive advantagesCrateDB is typically used in operational analytics applications, particularly those...
» more
Typical application scenariosCrateDB is ideal for integrating and analyzing streams of data--often machine-generated--in...
» more
Key customersCrateDB customers include McAfee, Qualtrics , Nokia, NBC Golfnow , Digital Domain...
» more
Market metricsThe CrateDB open source project was started in 2014. CrateDB was the winner of TechCrunch...
» more
Licensing and pricing modelsCrateDB pricing CrateDB Community Edition is open source and free to use under the...
» more

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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
CrateDBetcdIBM Db2 warehouse infoformerly named IBM dashDBNewtsSAP HANA
Recent citations in the news

CrateDB 4.5 takes distributed SQL database open source
24 March 2021, TechTarget

Crate.io Provides New Tier Model for CrateDB Cloud
5 July 2022, Database Trends and Applications

Crate.io Open Sources the Entire Codebase of CrateDB – the Database Purpose Built for Machine Data
24 March 2021, GlobeNewswire

Crate.io extends database service offering to Google Cloud
13 April 2022, VentureBeat

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

provided by Google News

Ondat's Unlimited Nodes for Kubernetes Stateful Workloads – The New Stack
5 August 2022, thenewstack.io

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

Foreign portfolio investments to generate pace with new dimensions
25 July 2022, Economic Times

Ondat 2.8 Arrives in GA with Increased Support for Stateful Workloads in Kubernetes
29 June 2022, Business Wire

All about performance: etcd 3.5 looks to make Kubernetes users happy • DEVCLASS
17 June 2021, DevClass

provided by Google News

Review: Snowflake aces Python machine learning
3 August 2022, InfoWorld

The 10 Best Cloud Data Warehouse Solutions to Consider in 2022
22 December 2021, Solutions Review

Log4j: Major IT vendors rush out fixes for this flaw and more ahead of Christmas
17 December 2021, ZDNet

When efficiency is at stake, enterprises need a data warehouse
29 March 2022, TechHQ

Best Data Warehouse Tools for Managing Your Data | ESF
24 September 2021, Enterprise Storage Forum

provided by Google News

Natural England action plan 2022 to 2023
27 July 2022, GOV.UK

provided by Google News

Power10 Entry Machines: The Power S1024 And Power L1024
8 August 2022, IT Jungle

SAP Security Patch Day July 2022: Three Applications in Focus
12 July 2022, Security Boulevard

Hasso Plattner discusses the state of the SAP HANA database
14 May 2019, TechTarget

Veeam: Backup Portfolio Review | ESF
5 August 2022, Enterprise Storage Forum

SAP HANA: What It Is and What Enterprises Can Use It For
26 January 2022, TechAcute

provided by Google News

Job opportunities

Senior Cloud Operations Engineer
Aptos, Atlanta, GA

Staff/Principal Systems Engineer
EasyPost, Remote

32217 - IAAS DevOps Engineer with Python
Credit Suisse, Raleigh, NC

Staff/Principal Systems Engineer
EasyPost, Denver, CO

Cloud Engineering Senior Advisor- Work From Home
Cigna, Hartford, CT

Software Engineer
Braintree, Illinois

Middleware Administrator
Snap IT Solutions, Houston, TX

Data Engineer and Database Administrator, Senior Consultant
Guidehouse, Washington, DC

Technical Sales Specialist- Data and AI- NYC Market
IBM, New York, NY

Engineer Architect, SME
ManTech International Corporation, Annapolis Junction, MD

AWS Redshift Data Engineer with Python
ClearScale, Remote

S/4 HANA Data Engineers *REMOTE*
Vastika Inc, Remote

Package consultant - SAP BPC Embedded & HANA ABAP
Iver Solutions, LLC, Remote

SAP S/4 Hana ABAP Developer (100% REMOTE)
Kairos Technologies, Remote

Project Manager / Hana / SAP
Tellus Solutions Inc, North Chicago, IL

Business Analyst with SAP HANA
Laiba Technologies, San Jose, CA

jobs by Indeed



Share this page

Featured Products

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Redis logo

The world’s most loved real‑time data platform.
Try free

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here