DBMS > Apache Doris vs. Netezza vs. Prometheus vs. RRDtool

System Properties Comparison Apache Doris vs. Netezza vs. Prometheus vs. RRDtool

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Apache Doris  Xexclude from comparison	Netezza Also called PureData System for Analytics by IBM  Xexclude from comparison	Prometheus  Xexclude from comparison	RRDtool  Xexclude from comparison
Description	An MPP-based analytics DBMS embracing the MySQL protocol	Data warehouse and analytics appliance part of IBM PureSystems	Open-source TimeSeries DBMS and monitoring system	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	Time Series DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.27 Rank #273   Overall #127   Relational DBMS	Score 18.93 Rank #38   Overall #24   Relational DBMS	Score 6.69 Rank #63   Overall #3   Time Series DBMS	Score 2.40 Rank #117   Overall #7   Time Series DBMS
Website	doris.apache.org github.com/­apache/­doris	www.ibm.com/­products/­netezza	prometheus.io	oss.oetiker.ch/­rrdtool
Technical documentation	github.com/­apache/­doris/­wiki		prometheus.io/­docs	oss.oetiker.ch/­rrdtool/­doc
Developer	Apache Software Foundation, originally contributed from Baidu	IBM		Tobias Oetiker
Initial release	2017	2000	2015	1999
Current release	0.14, May 2021			1.7.2, May 2019
License Commercial or Open Source	Open Source Apache Version 2.0	commercial	Open Source Apache 2.0	Open Source GPL V2 and FLOSS
Cloud-based only Only available as a cloud service	no	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language	Java		Go	C Implementations in Java (e.g. RRD4J) and C# available
Server operating systems	Linux	Linux included in appliance	Linux Windows	HP-UX Linux
Data scheme	yes	yes	yes	yes
Typing predefined data types such as float or date	yes	yes	Numeric data only	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 Import of XML data possible	no Exporting into and restoring from XML files possible
Secondary indexes	yes	yes	no	no
SQL Support of SQL	yes	yes	no	no
APIs and other access methods	JDBC MySQL client	JDBC ODBC OLE DB	RESTful HTTP/JSON API	in-process shared library Pipes
Supported programming languages	Java	C C++ Fortran Java Lua Perl Python R	.Net C++ Go Haskell Java JavaScript (Node.js) 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	user defined functions	yes	no	no
Triggers	no	no	no	no
Partitioning methods Methods for storing different data on different nodes	horizontal partitioning	Sharding	Sharding	none
Replication methods Methods for redundantly storing data on multiple nodes	none	Source-replica replication	yes by Federation	none
MapReduce Offers an API for user-defined Map/Reduce methods	no	yes	no	no
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency		none	none
Foreign keys Referential integrity	no	no	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data		ACID	no	no
Concurrency Support for concurrent manipulation of data	yes	yes	yes	yes by using the rrdcached daemon
Durability Support for making data persistent	yes	yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	no		no	yes
User concepts Access control	fine grained access rights according to SQL-standard	Users with fine-grained authorization concept	no	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
	Apache Doris	Netezza Also called PureData System for Analytics by IBM	Prometheus	RRDtool
DB-Engines blog posts