DBMS > Impala vs. NuoDB vs. RRDtool

System Properties Comparison Impala vs. NuoDB vs. RRDtool

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Impala  Xexclude from comparison	NuoDB  Xexclude from comparison	RRDtool  Xexclude from comparison
Description	Analytic DBMS for Hadoop	NuoDB is a webscale distributed database that supports SQL and ACID transactions	Industry standard data logging and graphing tool for time series data. RRD is an acronym for round-robin database. The data is stored in a circular buffer, thus the system storage footprint remains constant over time.
Primary database model	Relational DBMS	Relational DBMS	Time Series DBMS
Secondary database models	Document store
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 17.79 Rank #40   Overall #25   Relational DBMS	Score 0.96 Rank #178   Overall #87   Relational DBMS	Score 2.43 Rank #116   Overall #7   Time Series DBMS
Website	www.cloudera.com/­products/­open-source/­apache-hadoop/­impala.html	nuodb.com	oss.oetiker.ch/­rrdtool
Technical documentation	docs.cloudera.com/­documentation/­enterprise/­latest/­topics/­impala.html	doc.nuodb.com	oss.oetiker.ch/­rrdtool/­doc
Developer	Cloudera	NuoDB, Inc.	Tobias Oetiker
Initial release	2013	2013	1999
Current release	4.0.0, July 2021		1.7.2, May 2019
License Commercial or Open Source	Open Source Apache Version 2	commercial limited edition free	Open Source GPL V2 and FLOSS
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	C++	C++	C Implementations in Java (e.g. RRD4J) and C# available
Server operating systems	Linux	hosted Amazon EC2, Windows Azure, SoftLayer Linux OS X Windows	HP-UX Linux
Data scheme	yes	yes	yes
Typing predefined data types such as float or date	yes	yes	Numeric data only
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 Exporting into and restoring from XML files possible
Secondary indexes	yes	yes	no
SQL Support of SQL	SQL-like DML and DDL statements	yes	no
APIs and other access methods	JDBC ODBC	ADO.NET JDBC ODBC	in-process shared library Pipes
Supported programming languages	All languages supporting JDBC/ODBC	.Net C C++ Go Java JavaScript JavaScript (Node.js) PHP Python Ruby	C with librrd library C# with a different implementation of RRDTool Java with a different implementation of RRDTool JavaScript (Node.js) with a different implementation of RRDTool Lua Perl PHP with a wrapper library Python Ruby
Server-side scripts Stored procedures	yes user defined functions and integration of map-reduce	Java, SQL	no
Triggers	no	yes	no
Partitioning methods Methods for storing different data on different nodes	Sharding	data is dynamically stored/cached on the nodes where it is read/written	none
Replication methods Methods for redundantly storing data on multiple nodes	selectable replication factor	yes Managed transparently by NuoDB	none
MapReduce Offers an API for user-defined Map/Reduce methods	yes query execution via MapReduce	no	no
Consistency concepts Methods to ensure consistency in a distributed system	Eventual Consistency	Immediate Consistency	none
Foreign keys Referential integrity	no	yes	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	no	ACID tunable commit protocol	no
Concurrency Support for concurrent manipulation of data	yes	yes MVCC	yes by using the rrdcached daemon
Durability Support for making data persistent	yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	no	yes Temporary table	yes
User concepts Access control	Access rights for users, groups and roles based on Apache Sentry and Kerberos	Standard SQL roles/ privileges, Administrative Users	no
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
	Impala	NuoDB	RRDtool
DB-Engines blog posts