DBMS > ClickHouse vs. CrateDB vs. RavenDB vs. Tarantool vs. WakandaDB

Vergleich der Systemeigenschaften ClickHouse vs. CrateDB vs. RavenDB vs. Tarantool vs. WakandaDB

Redaktionelle Informationen bereitgestellt von DB-Engines

Name

Kurzbeschreibung

A high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.

Verteilter Data Store basierend auf Lucene

Open Source Operational and Transactional Enterprise NoSQL Document Database

In-memory computing platform with a flexible data schema for efficiently building high-performance applications

WakandaDB is embedded in a server that provides a REST API and a server-side javascript engine to access data

Primäres Datenbankmodell

Relational DBMS

Document Store
Spatial DBMS
Suchmaschine
Time Series DBMS
Vektor DBMS

Document Store

Document Store
Key-Value Store
Relational DBMS

Object oriented DBMS

Sekundäre Datenbankmodelle

Time Series DBMS

Relational DBMS

Graph DBMS
Spatial DBMS
Time Series DBMS

Spatial DBMS

with Tarantool/GIS extension

DB-Engines Ranking misst die Popularität von Datenbankmanagement- systemen
Trend Chart

Punkte	16,34
Rang	#38	Overall
	#23	Relational DBMS

Punkte	0,73
Rang	#224	Overall
	#37	Document Stores
	#5	Spatial DBMS
	#16	Suchmaschinen
	#19	Time Series DBMS
	#8	Vektor DBMS

Punkte	2,92
Rang	#101	Overall
	#18	Document Stores

Punkte	1,72
Rang	#144	Overall
	#25	Document Stores
	#25	Key-Value Stores
	#66	Relational DBMS

Punkte	0,03
Rang	#364	Overall
	#17	Object oriented DBMS

Website

Technische Dokumentation

clickhouse.com/docs

cratedb.com/docs

ravendb.net/docs

www.tarantool.io/en/doc

wakanda.github.io/doc

Entwickler

Clickhouse Inc.

Crate

Hibernating Rhinos

Wakanda SAS

Erscheinungsjahr

2016

2013

2010

2008

2012

Aktuelle Version

v24.4.1.2088-stable, Mai 2024

5.4, Juli 2022

2.10.0, Mai 2022

2.7.0 (April 29, 2019), April 2019

Lizenz

Commercial or Open Source

Open Source

Apache 2.0

Open Source

AGPL Version 3, kommerzielle Lizenz verfügbar

Open Source

BSD-2, source-available extensions (modules), commercial licenses for Tarantool Enterprise

Open Source

AGPLv3, erweiterte kommerzielle Lizenz verfügbar

Ausschließlich ein Cloud-Service

Nur als Cloud-Service verfügbar

nein

DBaaS Angebote (gesponserte Links)

Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
ClickHouse Cloud: Get the performance you love from open source ClickHouse in a serverless offering that takes care of the details so you can spend more time getting insight out of the fastest database on earth.

CrateDB Cloud: a distributed SQL database that spreads data and processing across an elastic cluster of shared nothing nodes. CrateDB Cloud enables data insights at scale on Microsoft Azure, AWS and Google Cloud Platform.

Implementierungssprache

C++

Java

C und C++

C++, JavaScript

Server Betriebssysteme

FreeBSD
Linux
macOS

All Operating Systems, including Kubernetes with CrateDB Kubernetes Operator support

Linux
macOS
Raspberry Pi
Windows

BSD
Linux
macOS

Linux
OS X
Windows

Datenschema

Flexible Schema (defined schema, partial schema, schema free)

schemafrei

Flexible data schema: relational definition for tables with ability to store json-like documents in columns

Typisierung

vordefinierte Datentypen, z.B. float oder date

nein

string, double, decimal, uuid, integer, blob, boolean, datetime

XML Unterstützung

Verarbeitung von Daten in XML Format, beispielsweise Speicherung von XML-Strukturen und/oder Unterstützung von XPath, XQuery, XSLT

nein

Sekundärindizes

yes

SQL

Support of SQL

Close to ANSI SQL (SQL/JSON + extensions)

yes, but no triggers and constraints, and PostgreSQL compatibility

SQL-like query language (RQL)

Full-featured ANSI SQL support

nein

APIs und andere Zugriffskonzepte

gRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietäres Protokoll

ADO.NET
JDBC
ODBC
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API

.NET Client API
F# Client API
Go Client API
Java Client API
NodeJS Client API
PHP Client API
Python Client API
RESTful HTTP API

Open binary protocol

RESTful HTTP API

Unterstützte Programmiersprachen

3rd party library
C++
Elixir

3rd party library
Go

3rd party library
Java

3rd party library
JavaScript (Node.js)

3rd party library
Kotlin

3rd party library
Nim

3rd party library
Perl

3rd party library
PHP

3rd party library
Python

3rd party library
R

3rd party library
Ruby

3rd party library
Rust
Scala

3rd party library

.NET
Erlang
Go

community maintained client
Java
JavaScript (Node.js)

community maintained client
Perl

community maintained client
PHP
Python
R
Ruby

community maintained client
Scala

community maintained client

.Net
C#
F#
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby

C
C#
C++
Erlang
Go
Java
JavaScript
Lua
Perl
PHP
Python
Rust

JavaScript

Server-seitige Scripts

Stored Procedures

benutzerdefinierte Funktionen

Lua, C and SQL stored procedures

Triggers

nein

Partitionierungsmechanismen

Methoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen Knoten

key based and custom

Sharding

Sharding, partitioned with virtual buckets by user defined affinity key. Live resharding for scale up and scale down without maintenance downtime.

keine

Replikationsmechanismen

Methoden zum redundanten Speichern von Daten auf mehreren Knoten

Asynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.

Configurable replication on table/partition-level

Multi-Source Replikation

Asynchronous replication with multi-master option
Configurable replication topology (full-mesh, chain, star)
Synchronous quorum replication (with Raft)

keine

MapReduce

Bietet ein API für Map/Reduce Operationen

nein

Konsistenzkonzept

Methoden zur Sicherstellung der Konsistenz in einem verteilten System

Immediate Consistency

Eventual Consistency
Read-after-write consistency on record level

Default ACID transactions on the local node (eventually consistent across the cluster). Atomic operations with cluster-wide ACID transactions. Eventual consistency for indexes and full-text search indexes.

Casual consistency across sharding partitions
Eventual consistency within replicaset partition

when using asyncronous replication
Immediate Consistency within single instance
Sequential consistency including linearizable read within replicaset partition

when using Raft

Immediate Consistency

Fremdschlüssel

referenzielle Integrität

nein

yes

Transaktionskonzept

Unterstützung zur Sicherstellung der Datenintegrität bei nicht-atomaren Datenmanipulationen

nein

unique row identifiers can be used for implementing an optimistic concurrency control strategy

ACID, Cluster-wide transaction available

ACID, with serializable isolation and linearizable read (within partition); Configurable MVCC (within partition); No cross-shard distributed transactions

ACID

Concurrency

Unterstützung von gleichzeitig ausgeführten Datenmanipulationen

Durability

Dauerhafte Speicherung der Daten

yes, write ahead logging

In-Memory Unterstützung

Gibt es Möglichkeiten einige oder alle Strukturen nur im Hauptspeicher zu halten

nein

yes, full featured in-memory storage engine with persistence

nein

Berechtigungskonzept

Zugriffskontrolle

Access rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.

Rechteverwaltung mit Benutzeraccounts

Authorization levels configured per client per database

Access Control Lists
Mutual TLS authentication for Tarantol Enterprise
Password based authentication
Role-based access control (RBAC) and LDAP for Tarantol Enterprise
Users and Roles

Weitere Informationen bereitgestellt vom Systemhersteller

Specific characteristics

The enterprise database for time series, documents, and vectors. Distributed - Native...
» mehr

Competitive advantages

Response time in milliseconds: e ven for complex ad-hoc queries. Massive scaling...
» mehr

Typical application scenarios

IoT: accelerate your IIoT projects with CrateDB, delivering real-time analytics...
» mehr

Key customers

Across all continents, CrateDB is used by companies of all sizes to meet the most...
» mehr

Market metrics

The CrateDB open source project was started in 2013 Honorable Mention in 2021 Gartner®...
» mehr

Licensing and pricing models

See CrateDB pricing >
» mehr

Wir laden Vertreter der Systemhersteller ein uns zu kontaktieren, um die Systeminformationen zu aktualisieren und zu ergänzen,
sowie um Herstellerinformationen wie Schlüsselkunden, Vorteile gegenüber Konkurrenten und Marktmetriken anzuzeigen.

Zugehörige Produkte und Dienstleistungen

Drittanbieter

DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» mehr

Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» mehr

Wir laden Vertreter von Anbietern von zugehörigen Produkten ein uns zu kontaktieren, um hier Informationen über ihre Angebote zu präsentieren.

Weitere Ressourcen

DB-Engines Blog Posts

Data processing speed and reliability: in-memory synchronous replication
9. November 2021, Vladimir Perepelytsya, Tarantool (sponsor)

alle anzeigen

Erwähnungen in aktuellen Nachrichten

Ubuntu 24.04 + Linux 6.9 Intel & AMD Server Performance
23. Mai 2024, Phoronix

Why Clickhouse Should Be Your Next Database
6. Juli 2023, The New Stack

ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ...
28. November 2023, AWS Blog

ClickHouse Announces Launch of ClickPipes
26. September 2023, Datanami

From Open Source to SaaS: the Journey of ClickHouse
16. Januar 2024, InfoQ.com

bereitgestellt von Google News

CrateDB Announces Availability of CrateDB on Google Cloud Marketplace
8. April 2024, Datanami

CrateDB Appoints Sergey Gerasimenko as New CTO
20. Februar 2024, CIO News

How We Designed CrateDB as a Realtime SQL DBMS for the Internet of Things
29. August 2017, The New Stack

Crate.io Introduces CrateDB 2.0 Enterprise and Open Source Editions
16. Mai 2017, Business Wire

Crate.io Expands CrateDB Cloud with the Launch of CrateDB Edge
15. April 2021, GlobeNewswire

bereitgestellt von Google News

RavenDB Launches Version 6.0 Lightning Fast Queries, Data Integrations, Corax Indexing Engine, and Sharding
3. Oktober 2023, PR Newswire

RavenDB Welcomes David Baruc as Chief Revenue Officer: Seasoned Tech Leader to Drive Global Sales and ...
13. Juni 2023, PR Newswire

Oren Eini on RavenDB, Including Consistency Guarantees and C# as the Implementation Language
23. Mai 2022, InfoQ.com

Install the NoSQL RavenDB Data System
14. Mai 2021, The New Stack

RavenDB Adds Graph Queries
15. Mai 2019, Datanami

bereitgestellt von Google News

Deploying Tarantool Cartridge applications with zero effort (Part 1)
16. Dezember 2019, Хабр

Тarantool Cartridge: Sharding Lua Backend in Three Lines
9. Oktober 2019, Хабр

VShard — horizontal scaling in Tarantool
7. März 2019, Хабр

Accelerating PHP connectors for Tarantool using Async, Swoole, and Parallel
18. Dezember 2019, Хабр

bereitgestellt von Google News

Teilen sie diese Seite mit ihrem Netzwerk