DB-EnginesCrateDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Netezza vs. Redis vs. Snowflake

System Properties Comparison Netezza vs. Redis vs. Snowflake

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameNetezza infoAlso called PureData System for Analytics by IBM  Xexclude from comparisonRedis  Xexclude from comparisonSnowflake  Xexclude from comparison
DescriptionData warehouse and analytics appliance part of IBM PureSystemsIn-memory data structure store, used as database, cache and message broker infoRedis focuses on performance so most of its design decisions prioritize high performance and very low latencies.Cloud-based data warehousing service for structured and semi-structured data
Primary database modelRelational DBMSKey-value store infoMultiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistenceRelational DBMS
Secondary database modelsDocument store infowith Redis Modules
Graph DBMS infowith Redis Modules
Search engine infowith Redis Modules
Time Series DBMS infowith Redis Modules
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score18.38
Rank#33  Overall
#20  Relational DBMS
Score145.64
Rank#8  Overall
#1  Key-value stores
Score2.53
Rank#101  Overall
#48  Relational DBMS
Websitewww.ibm.com/­analytics/­netezzaredis.iowww.snowflake.com
Technical documentationredis.io/­documentationdocs.snowflake.net/­manuals/­index.html
DeveloperIBMSalvatore Sanfilippo infoDevelopment sponsored by Redis LabsSnowflake Computing Inc.
Initial release200020092014
Current release6.0.1, May 2020
License infoCommercial or Open SourcecommercialOpen Source infoBSD 3-Clause, commercial license availablecommercial
Cloud-based only infoOnly available as a cloud servicenonoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC
Server operating systemsLinux infoincluded in applianceBSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
hosted
Data schemeyesschema-freeyes infosupport of semi-structured data formats (JSON, XML, Avro)
Typing infopredefined data types such as float or dateyespartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexesyes
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.noyes
Secondary indexesyesyes infowith RediSearch module
SQL infoSupport of SQLyesnoyes
APIs and other access methodsJDBC
ODBC
OLE DB
proprietary protocol infoRESP - REdis Serialization ProtocolCLI Client
JDBC
ODBC
Supported programming languagesC
C++
Fortran
Java
Lua
Perl
Python
R
C
C#
C++
Clojure
Crystal
D
Dart
Elixir
Erlang
Fancy
Go
Haskell
Haxe
Java
JavaScript (Node.js)
Lisp
Lua
MatLab
Objective-C
OCaml
Pascal
Perl
PHP
Prolog
Pure Data
Python
R
Rebol
Ruby
Rust
Scala
Scheme
Smalltalk
Swift
Tcl
Visual Basic
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresyesLuauser defined functions
Triggersnonono infosimilar concept for controling cloud resources
Partitioning methods infoMethods for storing different data on different nodesShardingShardingyes
Replication methods infoMethods for redundantly storing data on multiple nodesMaster-slave replicationMaster-slave replication infoChained replication is supported
Multi-master replication infowith Redis Enterprise Pack
yes
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Strong eventual consistency with CRDTs
Immediate Consistency
Foreign keys infoReferential integritynonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDOptimistic locking, atomic execution of commands blocks and scriptsACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoData access is serialized by the serveryes
Durability infoSupport for making data persistentyesyes infoConfigurable mechanisms for persistency via snapshots and/or operations logsyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlUsers with fine-grained authorization conceptSimple password-based access control infoAccess control lists and SSL are available in the commercial versionUsers with fine-grained authorization concept, user roles and pluggable authentication

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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

ScaleGrid: Fully managed Redis-as-a-Service in the cloud.
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
Netezza infoAlso called PureData System for Analytics by IBMRedisSnowflake
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2018
2 January 2019, Paul Andlinger, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

MongoDB is the DBMS of the year, defending the title from last year
7 January 2015, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Migrating your Netezza data warehouse to Amazon Redshift
28 May 2020, idk.dev

IBM resurrects Netezza data warehousing kit in the cloud, which will delight clients midway through migrating
27 May 2020, The Register

Active Data Warehousing Market 2020-2027 Covid-19 Impact on Major Companies – Netezza, Kognitio, Sybase, Oracle, Kognitio, etc.
4 June 2020, Farmers Ledger

Reader's storage digest: Backup, HPC storage, data lakes and more
11 May 2020, Blocks and Files

COVID – 19 Impact On Global Active Data Warehousing Market 2020 Analysis By Top Key Players – Teradata, Kognitio, HP, Netezza, Cloudera, IBM, Kognitio, Oracle, Sybase
25 May 2020, Bandera County Courier

provided by Google News

Database Week: Microsoft OEMs Redis Enterprise for Azure
12 May 2020, ZDNet

Redis Labs expands database to real-time data processing
13 May 2020, TechTarget

Cloud Database Market 2020 Size, Share, Top Manufacturers – Microsoft, Redis Labs, EnterpriseDB, Couchbase, Oracle and More, Forecast 2027
5 June 2020, Cole of Duty

Redis Labs Releases Platform with Real-Time AI Capabilities
27 May 2020, Database Trends and Applications

Why the future of enterprise data is open source
4 June 2020, TechRepublic

provided by Google News

erwin and Snowflake Partner to Enhance Cloud Migration and Data Governance
3 June 2020, Database Trends and Applications

Snowflake Role-Based Access Control simplified - Servian
20 May 2020, idk.dev

Global Database Platform as a Service Market 2020 Analysis by Latest COVID19/CORONA Virus Impact with Market Positioning of Key Vendors: Amazon Web Services, Microsoft, Google, Snowflake Computing, Salesforce, etc. | InForGrowth
4 June 2020, News Distinct

Five Minute Briefing: Information Management - June 3, 2020
3 June 2020, Database Trends and Applications

Database Platform As A Service Solutions Market Analysis by Key Players(Amazon Web Services, Teradata, Snowflake Computing, Microsoft) Trends & Development forecast to 2025
3 June 2020, News Distinct

provided by Google News

Job opportunities

Data Analyst
Perficient, Inc, San Francisco, CA

Informatica Developer
I3 Infotek, United States

Associate Data Scientist
Florida Blue, Jacksonville, FL

Data Engineer
Seattle Children's Hospital, Seattle, WA

Cognos developoer
NexZen, Germantown, MD

PostgreSQL Database Admin
AWeber, Philadelphia, PA

Senior Database Infrastructure Engineer
Etsy, Brooklyn, NY

Lead Database Administrator
VirtualHealth, New York, NY

Senior Database Engineer
Genity, New York, NY

Systems: Database Engineer
D. E. Shaw & Co., L.P., New York, NY

Research Analyst, Communications
Square, San Francisco, CA

Snowflake Architect
Akili, United States

Database Architect
McKesson, Township of Moon, PA

PGIM Fixed Income - Director, Database Administration
Prudential, Newark, NJ

PGIM Fixed Income - Manager, Database Administration
Prudential, Newark, NJ

jobs by Indeed




Share this page

Featured Products

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Present your product here