DBMS > Apache Druid vs. Elasticsearch vs. RocksDB

System Properties Comparison Apache Druid vs. Elasticsearch vs. RocksDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines

Name

Description

Open-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality data

A distributed, RESTful modern search and analytics engine based on Apache Lucene

Elasticsearch lets you perform and combine many types of searches such as structured, unstructured, geo, and metric

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

Primary database model

Relational DBMS
Time Series DBMS

Search engine

Key-value store

Secondary database models

Document store
Spatial DBMS

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

Score	2.69
Rank	#103	Overall
	#51	Relational DBMS
	#7	Time Series DBMS

Score	152.34
Rank	#8	Overall
	#1	Search engines

Score	3.29
Rank	#88	Overall
	#15	Key-value stores

Website

druid.apache.org

www.elastic.co/elasticsearch

rocksdb.org

Technical documentation

druid.apache.org/docs/latest/design

www.elastic.co/guide/en/elasticsearch/reference/current/index.html

github.com/facebook/rocksdb/wiki

Developer

Apache Software Foundation and contributors

Elastic

Facebook, Inc.

Initial release

2012

2010

2013

Current release

0.20.1, January 2021

7.8.0, June 2020

6.14.6 , December 2020

License

Commercial or Open Source

Open Source

Apache license v2

Open Source

Apache Version 2; Elastic License

Open Source

BSD

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.

Elasticsearch Service on Elastic Cloud: Try out the official hosted Elasticsearch and Kibana offering available on Amazon Web Services, Google Cloud and Microsoft Azure that's powered by the creators of Elasticsearch.

Implementation language

Java

C++

Server operating systems

Linux
OS X
Unix

All OS with a Java VM

Data scheme

yes

schema-less columns are supported

schema-free

Flexible type definitions. Once a type is defined, it is persistent

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

All search fields are automatically indexed

SQL

Support of SQL

SQL for querying

SQL-like query language

APIs and other access methods

JDBC
RESTful HTTP/JSON API

Java API
RESTful HTTP/JSON API

C++ API
Java API

Supported programming languages

Clojure
JavaScript
PHP
Python
R
Ruby
Scala

.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby

C++
Java

Server-side scripts

Stored procedures

yes

Triggers

yes

by using the 'percolation' feature

Partitioning methods

Methods for storing different data on different nodes

Sharding

manual/auto, time-based

Sharding

none

Replication methods

Methods for redundantly storing data on multiple nodes

yes, via HDFS, S3 or other storage engines

yes

none

MapReduce

Offers an API for user-defined Map/Reduce methods

ES-Hadoop Connector

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency

Eventual Consistency

Synchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, all

Foreign keys

Referential integrity

Transaction concepts

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

yes

Concurrency

Support for concurrent manipulation of data

yes

Durability

Support for making data persistent

yes

In-memory capabilities

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

Memcached and Redis integration

yes

User concepts

Access control

RBAC using LDAP or Druid internals for users and groups for read/write by datasource and system

More information provided by the system vendor

Specific characteristics

Elasticsearch is an open source search and analytics engine. As the heart of the...
» more

Competitive advantages

Open source Real-time indexsearch, and analysis Horizontally scalable Distributed...
» more

Typical application scenarios

Enterprise search (search experiences for your workplace, apps, and websites), observability...
» more

Key customers

Thousands of organizations worldwide, including Cisco, eBay, Goldman Sachs, Microsoft,...
» more

Market metrics

Public as of October 2018 Distributed workforce with 1900+ employees around the globe...
» more

Licensing and pricing models

The Elastic Stack (Elasticsearch, Kibana, Beats, and Logstash) is free and open source...
» 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.