DBMS > Apache Drill vs. OrientDB vs. RethinkDB

System Properties Comparison Apache Drill vs. OrientDB vs. RethinkDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Apache Drill  Xexclude from comparison	OrientDB  Xexclude from comparison	RethinkDB  Xexclude from comparison
Description	Schema-free SQL Query Engine for Hadoop, NoSQL and Cloud Storage	Multi-model DBMS (Document, Graph, Key/Value)	DBMS for the Web with a mechanism to push updated query results to applications in realtime.
Primary database model	Document store Relational DBMS	Document store Graph DBMS Key-value store	Document store
Secondary database models			Spatial DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 2.79 Rank #107   Overall #20   Document stores #55   Relational DBMS	Score 4.67 Rank #80   Overall #14   Document stores #5   Graph DBMS #12   Key-value stores	Score 3.07 Rank #99   Overall #18   Document stores
Website	drill.apache.org	orientdb.org	rethinkdb.com
Technical documentation	drill.apache.org/­docs	www.orientdb.com/­docs/­last/­index.html	rethinkdb.com/­docs
Developer	Apache Software Foundation	OrientDB LTD; CallidusCloud; SAP	The Linux Foundation since July 2017
Initial release	2012	2010	2009
Current release	1.19.0, June 2021	3.1.9, February 2021	2.4.1, August 2020
License Commercial or Open Source	Open Source Apache Version 2	Open Source Apache version 2	Open Source Apache Version 2
Cloud-based only Only available as a cloud service	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language		Java	C++
Server operating systems	Linux OS X Windows	All OS with a Java JDK (>= JDK 6)	Linux OS X Windows
Data scheme	schema-free	schema-free Schema can be enforced for whole record ("schema-full") or for some fields only ("schema-hybrid")	schema-free
Typing predefined data types such as float or date	yes	yes	yes string, binary, float, bool, date, geometry
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.	no	no	no
Secondary indexes	no	yes	yes
SQL Support of SQL	SQL SELECT statement is SQL:2003 compliant	SQL-like query language, no joins	no
APIs and other access methods	JDBC ODBC RESTful HTTP API	Tinkerpop technology stack with Blueprints, Gremlin, Pipes Java API RESTful HTTP/JSON API
Supported programming languages	C++	.Net C C# C++ Clojure Java JavaScript JavaScript (Node.js) PHP Python Ruby Scala	C 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
Server-side scripts Stored procedures	user defined functions	Java, Javascript
Triggers	no	Hooks	Client-side triggers through changefeeds
Partitioning methods Methods for storing different data on different nodes	Sharding	Sharding	Sharding range based
Replication methods Methods for redundantly storing data on multiple nodes		Multi-source replication	Source-replica replication
MapReduce Offers an API for user-defined Map/Reduce methods	yes	no could be achieved with distributed queries	yes
Consistency concepts Methods to ensure consistency in a distributed system	none		Immediate Consistency
Foreign keys Referential integrity	no	yes relationship in graphs	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	no	ACID	Atomic single-document operations
Concurrency Support for concurrent manipulation of data	yes	yes	yes MVCC based
Durability Support for making data persistent	Depending on the underlying data source	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	Depending on the underlying data source		no
User concepts Access control	Depending on the underlying data source	Access rights for users and roles; record level security configurable	yes users and table-level permissions
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.
Related products and services We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
	Apache Drill	OrientDB	RethinkDB
DB-Engines blog posts