DB-EnginesExtremeDB: the hard real time dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > IBM Db2 warehouse vs. RRDtool vs. Snowflake vs. SQream DB vs. Yandex Database (YDB)

System Properties Comparison IBM Db2 warehouse vs. RRDtool vs. Snowflake vs. SQream DB vs. Yandex Database (YDB)

Editorial information provided by DB-Engines
NameIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparisonRRDtool  Xexclude from comparisonSnowflake  Xexclude from comparisonSQream DB  Xexclude from comparisonYandex Database (YDB)  Xexclude from comparison
DescriptionCloud-based data warehousing serviceIndustry standard data logging and graphing tool for time series data. RRD is an acronym for round-robin database. infoThe data is stored in a circular buffer, thus the system storage footprint remains constant over time.Cloud-based data warehousing service for structured and semi-structured dataa GPU-based, columnar RDBMS for big data analytics workloadsA distributed fault-tolerant database service, with high availability, scalability, immediate consistency and ACID transactions and providing an Amazon DynamoDB compatible API
Primary database modelRelational DBMSTime Series DBMSRelational DBMSRelational DBMSDocument store
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.86
Rank#129  Overall
#63  Relational DBMS
Score2.50
Rank#115  Overall
#7  Time Series DBMS
Score93.51
Rank#14  Overall
#9  Relational DBMS
Score0.60
Rank#221  Overall
#108  Relational DBMS
Score0.51
Rank#240  Overall
#38  Document stores
#115  Relational DBMS
Websitewww.ibm.com/­products/­db2-warehouseoss.oetiker.ch/­rrdtoolwww.snowflake.comsqream.comcloud.yandex.com/­en/­services/­ydb
github.com/­ydb-platform/­ydb
ydb.tech
Technical documentationoss.oetiker.ch/­rrdtool/­docdocs.snowflake.net/­manuals/­index.htmldocs.sqream.comcloud.yandex.com/­en/­docs/­ydb
ydb.tech/­en/­docs
DeveloperIBMTobias OetikerSnowflake Computing Inc.SQream TechnologiesYandex
Initial release20141999201420142019
Current release1.7.2, May 20192021.2, September 2021
License infoCommercial or Open SourcecommercialOpen Source infoGPL V2 and FLOSScommercialcommercialOpen Source infoApache 2.0; commercial license available
Cloud-based only infoOnly available as a cloud serviceyesnoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC infoImplementations in Java (e.g. RRD4J) and C# availableC++, CUDA, Haskell, Java, Scala
Server operating systemshostedHP-UX
Linux
hostedLinuxLinux
Data schemeyesyesyes infosupport of semi-structured data formats (JSON, XML, Avro)yesFlexible Schema (defined schema, partial schema, schema free)
Typing infopredefined data types such as float or dateyesNumeric data onlyyesyes, ANSI Standard SQL Typesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.no infoImport/export of XML data possibleno infoExporting into and restoring from XML files possibleyesno
Secondary indexesyesnoyesyes
SQL infoSupport of SQLyesnoyesyesSQL-like query language (YQL)
APIs and other access methods.NET Client API
JDBC
ODBC
OLE DB
in-process shared library
Pipes
CLI Client
JDBC
ODBC
.Net
JDBC
ODBC
RESTful HTTP API (DynamoDB compatible)
Supported programming languagesJava
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
C infowith librrd library
C# infowith a different implementation of RRDTool
Java infowith a different implementation of RRDTool
JavaScript (Node.js) infowith a different implementation of RRDTool
Lua
Perl
PHP infowith a wrapper library
Python
Ruby
JavaScript (Node.js)
Python
C++
Java
JavaScript (Node.js)
Python
Go
Java
JavaScript (Node.js)
PHP
Python
Server-side scripts infoStored proceduresPL/SQL, SQL PLnouser defined functionsuser defined functions in Pythonno
Triggersyesnono infosimilar concept for controling cloud resourcesno
Partitioning methods infoMethods for storing different data on different nodesShardingnoneyeshorizontal and vertical partitioningSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesnoneyesnoneActive-passive shard replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencynoneImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoby using the rrdcached daemonyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesnono
User concepts infoAccess controlfine grained access rights according to SQL-standardnoUsers with fine-grained authorization concept, user roles and pluggable authenticationAccess rights defined for Yandex Cloud users
More information provided by the system vendor
IBM Db2 warehouse infoformerly named IBM dashDBRRDtoolSnowflakeSQream DBYandex Database (YDB)
Specific characteristicsDue to exponentially growing data, organizations today are facing slowdowns, with...
» more
Competitive advantagesMuch faster time to insight Analyze significantly more data Achieve previously unobtainable...
» more
Typical application scenariosWhat can you do with 100x faster SQL analytics? Better and more timely decision making...
» more
Key customersSome of our customers include: LG Uplus, AIS (Advanced Info Service), ACL Mobile,...
» more
News

SQream Appoints Naama Saar as New COO
16 May 2022

Panoply Partners with Square to Offer Simplified Business Intelligence
16 May 2022

PANOPLY PARTNERS WITH SQUARE
16 May 2022

The 50 most promising Israeli startups – 2022
11 May 2022

The Big Data ‘Tribrid’ Dump: Cloud And Edge Are Actually On-Prem
11 May 2022

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
3rd partiesDBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
IBM Db2 warehouse infoformerly named IBM dashDBRRDtoolSnowflakeSQream DBYandex Database (YDB)
DB-Engines blog posts

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

Time Series DBMS as a new trend?
1 June 2015, Paul Andlinger

show all

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Nucleus Research Analyzes Adoption of Modern Data Warehouse Technology in New Value Matrix
15 February 2022, Business Wire

When efficiency is at stake, enterprises need a data warehouse
29 March 2022, TechHQ

Log4j: Major IT vendors rush out fixes for this flaw and more ahead of Christmas
17 December 2021, ZDNet

The 10 Best Cloud Data Warehouse Solutions to Consider in 2022
22 December 2021, Solutions Review

Databricks claims warehouse supremacy with benchmark test - others say not so fast
2 November 2021, SiliconANGLE News

provided by Google News

How To Install Cacti monitoring on Ubuntu 22.04 | 20.04
22 April 2022, BollyInside

How to install and use RRDTool to speed up MRTG monitoring
24 June 2009, TechTarget

NaviSec Discovers Critical Zero-Day Exploit for Cacti Services
9 April 2022, PR Web

How To Install Cacti monitoring Debian 11 Bullseye
10 March 2022, Linux Shout

How to install lighttpd web server on Debian 11 Bullseye or Ubuntu 20.04
22 October 2021, Linux Shout

provided by Google News

Snowflake vs. AWS Redshift: 2022 Data Warehouse Comparison | eWEEK
18 May 2022, eWeek

Pure Storage, Snowflake partner for on-premises data warehousing
18 May 2022, Network World

Databricks Invests in Orchestration As It Takes on Rival Snowflake
19 May 2022, Business Insider

ALTR Attending Snowflake Summit June 13-16
19 May 2022, Business Wire

Novartis and Snowflake: Driving healthcare data innovation
25 April 2022, VentureBeat

provided by Google News

SQream Technologies raises $39.4 million for GPU-accelerated databases
24 June 2020, VentureBeat

Accelerated Databases In The Fast Lane
25 June 2020, The Next Platform

How big data can save lives
24 August 2015, ISRAEL21c

In A Parallel Universe, Data Warehouses Run On GPUs
4 October 2018, The Next Platform

Chinese giant Alibaba leads investment round in Israel big-data startup
30 May 2018, The Times of Israel

provided by Google News

Data leak from Russian delivery app shows dining habits of the secret police
3 April 2022, The Verge

provided by Google News

Job opportunities

Middleware Administrator
Snap IT Solutions, Houston, TX

AWS Redshift Data Engineer with Python
ClearScale, Remote

Data Science Platform Administrator - Senior Consultant
Guidehouse, Washington, DC

Data Engineer and Database Administrator - Senior Consultant
Guidehouse, Washington, DC

AWS Redshift Data Engineer
ClearScale, Remote

Systems Engineer
Domeyard LP, Boston, MA

DevOps Development Engineer
Trax Group, Dallas, TX

Technical Support Engineer/Unix Admin
DigiLink, Marina del Rey, CA

Snowflake Developer
Xtivia Inc, Remote

Senior Data Scientist - Remote
New Balance, Massachusetts

Senior Data and Analytics Platform Engineer - Snowflake
Blue Cross and Blue Shield of North Carolina, Remote

Technical Architect – MS SQL server / Synapse Database – Remote
WALGREENS, Deerfield, IL

Database Engineer
Zuora, Redwood City, CA

jobs by Indeed



Share this page

Featured Products

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

The world’s most loved real‑time data platform.
Try free

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Present your product here