DBMS > Amazon Redshift vs. NSDb vs. OpenQM vs. RethinkDB vs. SpaceTime

System Properties Comparison Amazon Redshift vs. NSDb vs. OpenQM vs. RethinkDB vs. SpaceTime

Editorial information provided by DB-Engines

Name

Description

Large scale data warehouse service for use with business intelligence tools

Scalable, High-performance Time Series DBMS designed for Real-time Analytics on top of Kubernetes

QpenQM is a high-performance, self-tuning, multi-value DBMS

DBMS for the Web with a mechanism to push updated query results to applications in realtime.

SpaceTime is a spatio-temporal DBMS with a focus on performance.

Primary database model

Secondary database models

Spatial DBMS

Relational DBMS

DB-Engines Ranking measures the popularity of database management systems
Trend Chart

Score	19.03
Rank	#34	Overall
	#21	Relational DBMS

Score	0.00
Rank	#396	Overall
	#42	Time Series DBMS

Score	0.33
Rank	#286	Overall
	#10	Multivalue DBMS

Score	2.84
Rank	#106	Overall
	#19	Document stores

Score	0.00
Rank	#396	Overall
	#8	Spatial DBMS

Website

aws.amazon.com/redshift

nsdb.io

www.rocketsoftware.com/products/rocket-multivalue-application-development-platform/rocket-open-qm

rethinkdb.com

www.mireo.com/spacetime

Technical documentation

docs.aws.amazon.com/redshift

nsdb.io/Architecture

rethinkdb.com/docs

Developer

Amazon (based on PostgreSQL)

Rocket Software, originally Martin Phillips

The Linux Foundation

since July 2017

Mireo

Initial release

2012

2017

1993

2009

2020

Current release

3.4-12

2.4.1, August 2020

License

Commercial or Open Source

commercial

Open Source

Apache Version 2.0

Open Source

GPLv2, extended commercial license available

Open Source

Apache Version 2

commercial

Cloud-based only

Only available as a cloud service

yes

DBaaS offerings (sponsored links)

Database as a Service

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

Implementation language

Java, Scala

C++

Server operating systems

hosted

Linux
macOS

AIX
FreeBSD
Linux
macOS
Raspberry Pi
Solaris
Windows

Linux
OS X
Windows

Linux

Data scheme

yes

with some exceptions

schema-free

yes

Typing

predefined data types such as float or date

yes

yes: int, bigint, decimal, string

yes

string, binary, float, bool, date, geometry

yes

XML support

Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.

yes

Secondary indexes

restricted

all fields are automatically indexed

yes

SQL

Support of SQL

yes

does not fully support an SQL-standard

SQL-like query language

A subset of ANSI SQL is implemented

APIs and other access methods

JDBC
ODBC

gRPC
HTTP REST
WebSocket

RESTful HTTP API

Supported programming languages

All languages supporting JDBC/ODBC

Java
Scala

.Net
Basic
C
Java
Objective C
PHP
Python

community-supported driver
C#

community-supported driver
C++

community-supported driver
Clojure

community-supported driver
Dart

community-supported driver
Erlang

community-supported driver
Go

community-supported driver
Haskell

community-supported driver
Java

official driver
JavaScript (Node.js)

official driver
Lisp

community-supported driver
Lua

community-supported driver
Objective-C

community-supported driver
Perl

community-supported driver
PHP

community-supported driver
Python

official driver
Ruby

official driver
Scala

community-supported driver

C#
C++
Python

Server-side scripts

Stored procedures

user defined functions

in Python

yes

Triggers

yes

Client-side triggers through changefeeds

Partitioning methods

Methods for storing different data on different nodes

Sharding

yes

Sharding

range based

Fixed-grid hypercubes

Replication methods

Methods for redundantly storing data on multiple nodes

yes

Source-replica replication

Real-time block device replication (DRBD)

MapReduce

Offers an API for user-defined Map/Reduce methods

yes

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency

Eventual Consistency

Immediate Consistency

Foreign keys

Referential integrity

yes

informational only, not enforced by the system

Transaction concepts

Support to ensure data integrity after non-atomic manipulations of data

ACID

Atomic single-document operations

Concurrency

Support for concurrent manipulation of data

yes

MVCC based

yes

Durability

Support for making data persistent

yes

Using Apache Lucene

yes

In-memory capabilities

Is there an option to define some or all structures to be held in-memory only.

yes

User concepts

Access control

fine grained access rights according to SQL-standard

Access rights can be defined down to the item level

yes

users and table-level permissions

yes

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.