DBMS > RocksDB vs. SingleStore vs. SpaceTime vs. Spark SQL vs. TerarkDB

System Properties Comparison RocksDB vs. SingleStore vs. SpaceTime vs. Spark SQL vs. TerarkDB

Editorial information provided by DB-Engines

Name

Description

Embeddable persistent key-value store optimized for fast storage (flash and RAM)

MySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one single table type

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

Spark SQL is a component on top of 'Spark Core' for structured data processing

A key-value store forked from RocksDB with advanced compression algorithms. It can be used standalone or as a storage engine for MySQL and MongoDB

Primary database model

Secondary database models

Document store
Spatial DBMS
Time Series DBMS
Vector DBMS

Relational DBMS

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

Score	3.65
Rank	#85	Overall
	#11	Key-value stores

Score	5.60
Rank	#62	Overall
	#35	Relational DBMS

Score	0.00
Rank	#383	Overall
	#7	Spatial DBMS

Score	18.96
Rank	#33	Overall
	#20	Relational DBMS

Score	0.00
Rank	#383	Overall
	#60	Key-value stores

Website

rocksdb.org

www.singlestore.com

www.mireo.com/spacetime

spark.apache.org/sql

github.com/bytedance/terarkdb

Technical documentation

github.com/facebook/rocksdb/wiki

docs.singlestore.com

spark.apache.org/docs/latest/sql-programming-guide.html

bytedance.larkoffice.com/docs/doccnZmYFqHBm06BbvYgjsHHcKc

Developer

Facebook, Inc.

SingleStore Inc.

Mireo

Apache Software Foundation

ByteDance, originally Terark

Initial release

2013

2020

2014

2016

Current release

8.11.4, April 2024

8.5, January 2024

3.5.0 ( 2.13), September 2023

License

Commercial or Open Source

Open Source

BSD

commercial

free developer edition available

commercial

Open Source

Apache 2.0

commercial

restricted open source version available

Cloud-based only

Only available as a cloud service

DBaaS offerings (sponsored links)

Database as a Service

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

SingleStoreDB Cloud: The world's fastest, modern cloud database for both operational (OLTP) and analytical (OLAP) workloads. Available instantly with multi-cloud and hybrid-cloud capabilities

Implementation language

C++

C++, Go

C++

Scala

C++

Server operating systems

Linux

64 bit version required

Linux

Linux
OS X
Windows

Data scheme

schema-free

yes

schema-free

Typing

predefined data types such as float or date

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.

Secondary indexes

yes

SQL

Support of SQL

yes

but no triggers and foreign keys

A subset of ANSI SQL is implemented

SQL-like DML and DDL statements

APIs and other access methods

C++ API
Java API

Cluster Management API

as HTTP Rest and CLI
HTTP API
JDBC
MongoDB API
ODBC

RESTful HTTP API

JDBC
ODBC

C++ API
Java API

Supported programming languages

C
C++
Go
Java
Perl
Python
Ruby

Bash
C
C#
Java
JavaScript (Node.js)
Python

C#
C++
Python

Java
Python
R
Scala

C++
Java

Server-side scripts

Stored procedures

yes

Triggers

Partitioning methods

Methods for storing different data on different nodes

horizontal partitioning

Sharding

hash partitioning

Fixed-grid hypercubes

yes, utilizing Spark Core

none

Replication methods

Methods for redundantly storing data on multiple nodes

yes

Source-replica replication

stores two copies of each physical data partition on two separate nodes

Real-time block device replication (DRBD)

none

MapReduce

Offers an API for user-defined Map/Reduce methods

can define user-defined aggregate functions for map-reduce-style calculations

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency

Foreign keys

Referential integrity

Transaction concepts

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

yes

ACID

Concurrency

Support for concurrent manipulation of data

yes

yes, multi-version concurrency control (MVCC)

yes

Durability

Support for making data persistent

yes

All updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.

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 control via users, groups and roles

yes

More information provided by the system vendor

Specific characteristics

SingleStore offers a fully-managed , distributed, highly-scalable SQL database designed...
» more

Competitive advantages

SingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» more

Typical application scenarios

Driving Fast Analytics: SingleStore delivers the fastest and most scalable reporting...
» more

Key customers

IEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,...
» more

Market metrics

Customers in various industries worldwide including US and International Industry...
» more

Licensing and pricing models

F ree Tier and Enterprise Edition
» 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.