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

DBMS > JaguarDB vs. mSQL vs. Netezza vs. Redis vs. Snowflake

System Properties Comparison JaguarDB vs. mSQL vs. Netezza vs. Redis vs. Snowflake

Editorial information provided by DB-Engines
NameJaguarDB  Xexclude from comparisonmSQL infoMini SQL  Xexclude from comparisonNetezza infoAlso called PureData System for Analytics by IBM  Xexclude from comparisonRedis  Xexclude from comparisonSnowflake  Xexclude from comparison
DescriptionPerformant, highly scalable DBMS for AI and IoT applicationsmSQL (Mini SQL) is a simple and lightweight RDBMSData 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 modelKey-value storeRelational DBMSRelational 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
Spatial DBMS
Search engine infowith Redis Modules
Time Series DBMS infowith Redis Modules
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.02
Rank#328  Overall
#53  Key-value stores
Score1.83
Rank#124  Overall
#63  Relational DBMS
Score18.67
Rank#35  Overall
#22  Relational DBMS
Score154.15
Rank#7  Overall
#1  Key-value stores
Score23.19
Rank#30  Overall
#17  Relational DBMS
Websitewww.datajaguar.comhughestech.com.au/­products/­msqlwww.ibm.com/­products/­netezzaredis.iowww.snowflake.com
Technical documentationwww.datajaguar.com/­support.phpredis.io/­documentationdocs.snowflake.net/­manuals/­index.html
DeveloperDataJaguar, Inc.Hughes TechnologiesIBMSalvatore Sanfilippo infoDevelopment sponsored by Redis LabsSnowflake Computing Inc.
Initial release20151994200020092014
Current release2.9.4 September 20184.2, April 20196.2.0 , February 2021
License infoCommercial or Open SourceOpen Source infoGPL V3.0commercial infofree licenses can be providedcommercialOpen Source infoBSD 3-Clause, commercial license availablecommercial
Cloud-based only infoOnly available as a cloud servicenonononoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • Redis Enterprise Cloud: Instantly scale and pay only for the resources you need - on any cloud - AWS, Azure or Google Cloud.
  • ScaleGrid for Redis: Fully managed hosting for Redis on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
Implementation languageC++ infothe server part. Clients available in other languagesCC
Server operating systemsLinuxAIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
Linux infoincluded in applianceBSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
hosted
Data schemeyesyesyesschema-freeyes infosupport of semi-structured data formats (JSON, XML, Avro)
Typing infopredefined data types such as float or dateyesyesyespartial 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.nononoyes
Secondary indexesyesyesyesyes infowith RediSearch module
SQL infoSupport of SQLA subset of ANSI SQL is implemented infobut no views, foreign keys, triggersA subset of ANSI SQL is implemented infono subqueries, aggregate functions, views, foreign keys, triggersyesnoyes
APIs and other access methodsJDBC
ODBC
JDBC
ODBC
JDBC
ODBC
OLE DB
proprietary protocol infoRESP - REdis Serialization ProtocolCLI Client
JDBC
ODBC
Supported programming languagesC
C++
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Scala
C
C++
Delphi
Java
Perl
PHP
Tcl
C
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 proceduresnonoyesLuauser defined functions
Triggersnononono infopublish/subscribe channels provide limited trigger functionalityno infosimilar concept for controling cloud resources
Partitioning methods infoMethods for storing different data on different nodesShardingnoneShardingShardingyes
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationnoneSource-replica replicationMulti-source replication infowith Redis Enterprise Pack
Source-replica replication infoChained replication is supported
yes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencynoneEventual Consistency
Strong eventual consistency with CRDTs
Immediate Consistency
Foreign keys infoReferential integritynonononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDOptimistic locking, atomic execution of commands blocks and scriptsACID
Concurrency infoSupport for concurrent manipulation of datayesnoyesyes infoData access is serialized by the serveryes
Durability infoSupport for making data persistentyesyesyesyes 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.nonoyesno
User concepts infoAccess controlrights management via user accountsnoUsers 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
JaguarDBmSQL infoMini SQLNetezza infoAlso called PureData System for Analytics by IBMRedisSnowflake
Specific characteristicsSQL support, group by, order by, join
» more
Redis, benchmarked as the world's fastest database, reduces application complexity,...
» more
Competitive advantagesExtremely easy to scale-out (in seconds) 100,000 times faster
» more
Redis is an in-memory database platform offering native support of wide range of...
» more
Typical application scenariosIoT data, time series data, AI data. Any type of numerical data.
» more
Redis powers personalization, real-time fraud detection, IoT, e-commerce, real-time...
» more
Key customersQuantea, 2PiDay, Synqy, SinoLogistics, IIVI
» more
Verizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,...
» more
Market metricsAdvertising awareness, installed base, brand image, market share
» more
Licensing and pricing modelsFree-trial license, per-node license, and subscription license.
» more
The licensing model is subscription based. Redis Enterprise Cloud is priced according...
» more

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 partiesDatadog: Monitor all Redis metrics: hit rates, clients, commands per second, and more.
» more

Redis Enterprise Cloud: Try with 400$ usage credit.
» more

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

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

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

More resources
JaguarDBmSQL infoMini SQLNetezza 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

TransWare Offers New Translation Tools and Services for ARIS® 7.x, 9.x Full translation to Microsoft Visio® 2010, 2013 and 2016 and Many Other Modeling Tools
12 October 2015, PR Web

PHP at 20: From pet project to powerhouse
11 June 2015, InfoWorld

Writing a Web Service in Perl
8 May 2020, PCQuest

Higher Education PS rules out ghost students before PAC – Zambia
29 November 2018, diggers.news

provided by Google News

IBM Brings Back a Netezza, Attacks Yellowbrick
29 June 2020, Datanami

Netezza’s Not Dead: It’s Just Ascended
25 June 2020, Computer Business Review

Veteran IT Industry leader, Shigeru Harasawa, joins Sales Acceleration company, Vymo, as Japan President
9 February 2021, PR Newswire UK

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

CitiusTech's FAST+ Solution Now Utilizes IBM Cloud Paks to Help Increase Healthcare Interoperability
16 February 2021, Business Wire

provided by Google News

Redis Labs Announces Integrated Enterprise Tiers of Azure Cache for Redis
2 March 2021, Database Trends and Applications

Redis Labs Unveils RediSearch 2.0 Full-Text Search Engine
25 February 2021, Solutions Review

Redis Labs Delivers Real-Time Query, Index, and Full-Text Search Engine with RediSearch 2.0
18 February 2021, Business Wire

Global Database Autotmation market Strategy, Revenue Analysis, Future Opportunities And Premium Insights – KSU | The Sentinel Newspaper
8 March 2021, KSU | The Sentinel Newspaper

Open-Source Database Software Market Next Big Thing | Major Giants SQLite, Redis, Couchbase – NeighborWebSJ
23 February 2021, NeighborWebSJ

provided by Google News

Snowflake: 4 Big Steps on Journey to $1 Billion in Data Cloud Revenue
5 March 2021, Cloud Wars

Snowflake Stock Looks Like Better Value After Q4 Results, Recent Sell Off
8 March 2021, Trefis

DBmaestro Announces Support for Snowflake, to Enable Database Delivery Automation
2 March 2021, AiThority

Baffle Beefs Up Snowflake's Data Pipeline Security
18 February 2021, SDxCentral

Snowflake, BlackRock forge partnership, connect Aladdin platform with Snowflake Data Cloud
22 February 2021, ZDNet

provided by Google News

Job opportunities

ETL Informatica Developer
First Soft Solutions [ Direct], Nashville, TN

QA Test Analyst
Altice, Bethpage, NY

ETL Developer - Netezza
Oasys International Corporation, Washington, DC

ETL Tester
First Soft Solutions [ Direct], Horsham, PA

Data Engineer
Adobe, Lehi, UT

Redis Database Administrator | Remote
iknowvate technologies, Bellevue, WA

Database Administrator (DBA)
First American, Folsom, CA

Python/Django Developer
Weems Design Studio, Remote

Jr. SQL Developer
TechStyle Fashion Group, El Segundo, CA

SQL Developer / Database Administrator (Scottsdale, AZ)
Garmin, Scottsdale, AZ

Database Administrator - Remote
Dentsply Sirona, Pennsylvania

Associate Database Analyst/Database Analyst
Texas Mutual Insurance Company, Austin, TX

Database Administrator
Sciata, Phoenix, AZ

PowerBI Consultant
Capgemini, Remote

Database Administrator II
Sonora Quest Laboratories, Phoenix, AZ

jobs by Indeed




Share this page

Featured Products

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!

Neo4j logo

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

AllegroGraph logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

Present your product here