DBMS > Redis vs. Snowflake vs. Trino
System Properties Comparison Redis vs. Snowflake vs. Trino
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Redis Xexclude from comparison||Snowflake Xexclude from comparison||Trino Xexclude from comparison|
|Description||Popular in-memory data platform used as a cache, message broker, and database that can be deployed on-premises, across clouds, and hybrid environments Redis 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||Fast distributed SQL query engine for big data analytics. Forked from Presto and originally named PrestoSQL|
|Primary database model||Key-value store Multiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistence||Relational DBMS||Relational DBMS|
|Secondary database models||Document store with RedisJSON|
Graph DBMS with RedisGraph
Search engine with RediSearch
Time Series DBMS with RedisTimeSeries
Time Series DBMS
Wide column store
|Social network pages|
|Developer||Redis project core team, inspired by Salvatore Sanfilippo Development sponsored by Redis Inc.||Snowflake Computing Inc.||Trino Software Foundation|
|Initial release||2009||2014||2012 2020 rebranded from PrestoSQL|
|Current release||7.2.1, September 2023|
|License Commercial or Open Source||Open Source source-available extensions (modules), commercial licenses for Redis Enterprise||commercial||Open Source Apache Version 2.0|
|Cloud-based only Only available as a cloud service||no||yes||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Starburst Galaxy offers a feature-rich user interface to connect all your data sources, manage your Trino clusters, and query your data.|
|Server operating systems||BSD|
Windows ported and maintained by Microsoft Open Technologies, Inc.
macOS for devlopment
|Data scheme||schema-free||yes support of semi-structured data formats (JSON, XML, Avro)||yes|
|Typing predefined data types such as float or date||partial Supported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes||yes||yes|
|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||yes||no|
|Secondary indexes||yes with RediSearch module||depending on connected data-source|
|SQL Support of SQL||no||yes||yes|
|APIs and other access methods||proprietary protocol RESP - REdis Serialization Protocol||CLI Client|
RESTful HTTP API
|Supported programming languages||C|
|Server-side scripts Stored procedures||Lua; Redis Functions coming in Redis 7 (slides and Github)||user defined functions||yes, depending on connected data-source|
|Triggers||publish/subscribe channels provide some trigger functionality; RedisGears||no similar concept for controling cloud resources||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding Automatic hash-based sharding with support for hash-tags for manual sharding||yes||depending on connected data-source|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-source replication with Redis Enterprise Pack|
Source-replica replication Chained replication is supported
|yes||depending on connected data-source|
|MapReduce Offers an API for user-defined Map/Reduce methods||through RedisGears||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Eventual Consistency|
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active
|Immediate Consistency||depending on connected data-source|
|Foreign keys Referential integrity||no||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||Atomic execution of command blocks and scripts and optimistic locking||ACID||depending on connected data-source|
|Concurrency Support for concurrent manipulation of data||yes Data access is serialized by the server||yes||yes|
|Durability Support for making data persistent||yes Configurable mechanisms for persistency via snapshots and/or operations logs||yes||depending on connected data-source|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||no|
|User concepts Access control||Access Control Lists (ACLs): redis.io/docs/management/security/acl|
LDAP and Role-Based Access Control (RBAC) for Redis Enterprise
Mutual TLS authentication: redis.io/docs/management/security/encryption
|Users with fine-grained authorization concept, user roles and pluggable authentication||SQL standard access control|
|More information provided by the system vendor|
|Specific characteristics||The Redis real-time data platform builds upon the unmatched simplicity and speed...|
|Trino is the fastest open source, massively parallel processing SQL query engine...|
|Competitive advantages||Redis Enterprise is a robust in-memory database platform built by the people who...|
|High performance analtyics and data processing of very large data sets Powerful ANSI...|
|Typical application scenarios||Redis Enterprise is used by large enterprise, startup, and government organizations...|
|Performant analytics query engine for data warehouses, data lakes, and data lakehouses...|
|Key customers||Verizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,...|
|Trino is widely adopted across the globe as freely-available open source software....|
|Market metrics||Most launched Docker container per day according to Docker Hub (7.2M launches per...|
|33000+ commits in GitHub 8200+ stargazers in GitHub 1200+ pull requests merged in...|
|Licensing and pricing models||Redis Enterprise Cloud lets users scale up and down instantly, and pay only for the...|
|Trino is an open source project and usage is therefore free. Commercial offerings...|
Trino Gateway has arrived
Learning SQL with Trino from the experts
Chinese edition of Trino: The Definitive Guide
Join us for Trino Summit 2023
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Redisson PRO: The ultra-fast Redis Java Client.|
Navicat for Redis: the award-winning Redis management tool with an intuitive and powerful graphical interface.
CData: Connect to Big Data & NoSQL through standard Drivers.
Read the Redis NoSQL benchmark report.
Aiven for Redis: Fully managed in-memory key-value store for all your caching and speedy lookup needs.
|CData: Connect to Big Data & NoSQL through standard Drivers.|
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
PostgreSQL is the DBMS of the Year 2018 MySQL, PostgreSQL and Redis are the winners of the March ranking MongoDB is the DBMS of the year, defending the title from last year
MySQL, PostgreSQL and Redis are the winners of the March ranking MongoDB is the DBMS of the year, defending the title from last year
MongoDB is the DBMS of the year, defending the title from last year
Snowflake is the DBMS of the Year 2022, defending the title from last year
|Recent citations in the news|
NoSQL Database Market to See Massive Growth by 2029 ...
Redis Enterprise Cloud Integration with Amazon Bedrock Now ...
P2Pinfect botnet targets Redis and SSH services
Implementing Cache using Redis in a Spring Boot API that uses ...
The 12 Best Enterprise Data Lake Solutions for 2023
provided by Google News
Coalesce Joins Snowflake for the 2023 Data Cloud World Tour
Environics Analytics Expands Partnership with Snowflake to ...
Leveraging Informatica Solutions for Optimized Data Management ...
Databricks Versus Snowflake: Comparing Data Giants
Salesforce links with Databricks, Snowflake to build stronger ...
provided by Google News
Starburst Brings Dataframes Into Trino Platform
Speed Trino Queries with These Performance-Tuning Tips
Starburst accelerates Trino to 'Warp Speed' to accelerate data ...
Trino and dbt open source data tools snuggle closer with integrated SaaS
Trino: The Open-source Data Query Engine That Split from Facebook
provided by Google News
Postgres Database Administrator III
Weekend Backend Engineer
Database Automation Engineer
IT PROFESSIONAL 3
Director, Marketing Operations
Distributed Systems Engineer (L4) - Data Platform
Analyst 4, Enterprise Data Analytics - VIRTUAL
Sr. Business Intelligence Architect (Hadoop)
Share this page