DBMS > CockroachDB vs. QuestDB vs. Redis

Vergleich der Systemeigenschaften CockroachDB vs. QuestDB vs. Redis

Bitte wählen Sie ein weiteres System aus, um es in den Vergleich aufzunehmen.

Redaktionelle Informationen bereitgestellt von DB-Engines

Name

Kurzbeschreibung

CockroachDB 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 high performance open source SQL database for time series data

Popular in-memory data platform used as a cache, message broker, and database that can be deployed on-premises, across clouds, and hybrid environments

Redis legt höchsten Wert auf Performanz. Bei Designentscheidungen wird typischerweise Performanz der Vorzug vor Features oder Speicherbedarf gegeben.

Primäres Datenbankmodell

Relational DBMS

Time Series DBMS

Key-Value Store

Multiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistence

Sekundäre Datenbankmodelle

Relational DBMS

Document Store

with RedisJSON
Graph DBMS

with RedisGraph
Spatial DBMS
Suchmaschine

with RediSearch
Time Series DBMS

with RedisTimeSeries

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

Punkte	7,53
Rang	#59	Overall
	#33	Relational DBMS

Punkte	1,28
Rang	#154	Overall
	#11	Time Series DBMS

Punkte	176,39
Rang	#6	Overall
	#1	Key-Value Stores

Website

www.cockroachlabs.com

questdb.io

redis.com
redis.io

Technische Dokumentation

www.cockroachlabs.com/docs

questdb.io/docs/introduction

docs.redis.com/latest/index.html
redis.io/documentation

Social network pages

Entwickler

Cockroach Labs

QuestDB Limited

Redis project core team, inspired by Salvatore Sanfilippo

Entwicklung von Redis Inc finanziert

Erscheinungsjahr

2015

2014

2009

Aktuelle Version

21.1.2, Juni 2021

7.0.3, Juli 2022

Lizenz

Commercial or Open Source

Open Source

Apache 2.0, commercial license available

Open Source

Apache 2.0

Open Source

source-available extensions (modules), commercial licenses for Redis Enterprise

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.

CockroachDB: A cloud-native, distributed SQL database designed for speed, scale, and survival. Get started for free today with a fully-managed CockroachDB cluster -- leave operations behind and get your app to market faster.

Aiven for Redis: Fully managed in-memory key-value store, for all your caching and speedy lookup needs.
Redis Enterprise Cloud: Instantly scale and pay only for the resources you need - on any cloud - AWS, Azure or Google Cloud.
ScaleGrid for Redis: Fully managed hosting for Redis on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.

Implementierungssprache

Java

Server Betriebssysteme

Linux
macOS
Windows

BSD
Linux
OS X
Windows

portiert und gewartet durch Microsoft Open Technologies, Inc.

Datenschema

dynamic schema

schema-free via InfluxDB Line Protocol

schemafrei

Typisierung

vordefinierte Datentypen, z.B. float oder date

teilweise

Supported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes

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

nein

with RediSearch module

SQL

Support of SQL

yes, wire compatible with PostgreSQL

SQL-like query language

nein

APIs und andere Zugriffskonzepte

JDBC

HTTP REST
InfluxDB Line Protocol (TCP/UDP)
JDBC

Proprietäres Protokoll

RESP - REdis Serialization Protocol

Unterstützte Programmiersprachen

C#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust

PostgreSQL driver
C++
Go
Java
JavaScript (Node.js)
Python
Rust

over HTTP

C
C#
C++
Clojure
Crystal
D
Dart
Elixir
Erlang
Fancy
Go
Haskell
Haxe
Java
JavaScript (Node.js)
Lisp
Lua
MatLab
Objective-C
OCaml
Pascal
Perl
PHP
Prolog
Pure Data
Python
R
Rebol
Ruby
Rust
Scala
Scheme
Smalltalk
Swift
Tcl
Visual Basic

Server-seitige Scripts

Stored Procedures

nein

Lua; Redis Functions coming in Redis 7 (slides and Github)

Triggers

nein

publish/subscribe channels provide some trigger functionality; RedisGears

Partitionierungsmechanismen

Methoden zum Speichern von unterschiedlichen Daten auf unterschiedlichen Knoten

horizontal partitioning (by key range)

all tables are translated to an ordered KV store and then broken down into 64MB ranges, which are then used as replicas in RAFT

horizontal partitioning (by timestamps)

Sharding

Automatic hash-based sharding with support for hash-tags for manual sharding

Replikationsmechanismen

Methoden zum redundanten Speichern von Daten auf mehreren Knoten

Multi-source replication using RAFT

Configurable consistency for N replicas

Multi-Source Replikation

with Redis Enterprise Pack
Source-Replica Replikation

Chained replication wird unterstützt

MapReduce

Bietet ein API für Map/Reduce Operationen

nein

through RedisGears

Konsistenzkonzept

Methoden zur Sicherstellung der Konsistenz in einem verteilten System

Immediate Consistency

Eventual Consistency
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active

Fremdschlüssel

referenzielle Integrität

nein

Transaktionskonzept

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

ACID

ACID for single-table writes

Atomic execution of command blocks and scripts and optimistic locking

Concurrency

Unterstützung von gleichzeitig ausgeführten Datenmanipulationen

Datenzugriffe werden vom Server serialisiert

Durability

Dauerhafte Speicherung der Daten

konfigurierbare Persistenzmechanismen via snapshots oder logs

In-Memory Unterstützung

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

nein

through memory mapped files

Berechtigungskonzept

Zugriffskontrolle

Role-based access control

Access Control Lists (ACLs): redis.io/topics/acl
LDAP and Role-Based Access Control (RBAC) for Redis Enterprise
Mutual TLS authentication: redis.io/topics/encryption
Password-based authentication

Weitere Informationen bereitgestellt vom Systemhersteller

Specific characteristics

CockroachDB is a cloud-native, distributed SQL database architected for modern applications....
» mehr

Relational model with native time series support Column based storage and time partitioned...
» mehr

The Redis real-time data platform builds upon the unmatched simplicity and speed...
» mehr

Competitive advantages

- EFFORTLESS SCALE: Scale your applications, not operational complexity. CockroachDB...
» mehr

Real-time data ingestion and istant SQL queries for time series High performance...
» mehr

Redis Enterprise is a robust in-memory database platform built by the people who...
» mehr

Typical application scenarios

System of record (financial ledger, inventory management, transaction record), identity...
» mehr

Application metrics Financial market data and algo trading DevOps monitoring Real-time...
» mehr

Redis Enterprise is used by large enterprise, startup, and government organizations...
» mehr

Key customers

Comcast, DoorDash, Mythical Games, Norfolk Southern, LUSH, Bose, Shipt, MyDoc, Bitski,...
» mehr

Verizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,...
» mehr

Market metrics

8K+ long-running clusters 2.5K+ CockroachDB Self-Hosted clusters 15K+ CockroachDB...
» mehr

Most launched Docker container per day according to Docker Hub (7.2M launches per...
» mehr

Licensing and pricing models

- Apache 2.0 for core features released up to and including the 19.1 release - Time-limited...
» mehr

Apache 2.0.
» mehr

Redis Enterprise Cloud lets users scale up and down instantly, and pay only for the...
» mehr

Neuigkeiten

QuestDB 6.5 Release - CSV import
8. August 2022

Setting up Basic Authentication for QuestDB open source using Nginx
5. August 2022

Time Series Forecasting with TensorFlow and QuestDB
20. Juni 2022

Building a Data Pipeline using QuestDB and Confluent Kafka
7. Juni 2022

QuestDB 6.4 Release Highlights
31. Mai 2022

Zugehörige Produkte und Dienstleistungen

Drittanbieter

Read the Redis NoSQL benchmark report.
» mehr

CData: Connect to Big Data & NoSQL through standard Drivers.
» mehr

Aiven for Redis: Store and access your data quickly and efficiently.
» mehr