DBMS > Microsoft SQL Server vs. Redis vs. ScyllaDB
System Properties Comparison Microsoft SQL Server vs. Redis vs. ScyllaDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Microsoft SQL Server Xexclude from comparison||Redis Xexclude from comparison||ScyllaDB Xexclude from comparison|
|Description||Microsofts relational DBMS||In-memory data structure store, used as database, cache and message broker Redis focuses on performance so most of its design decisions prioritize high performance and very low latencies.||Cassandra-compatible wide column store|
|Primary database model||Relational DBMS||Key-value store Multiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistence||Wide column store|
|Secondary database models||Document store|
|Document store with Redis Modules|
Graph DBMS with Redis Modules
Search engine with Redis Modules
Time Series DBMS with Redis Modules
|Developer||Microsoft||Salvatore Sanfilippo Development sponsored by Redis Labs||ScyllaDB|
|Current release||SQL Server 2019, November 2019||5.0.7, November 2019||Scylla Open Source 3.1.2, December 2019|
|License Commercial or Open Source||commercial restricted free version is available||Open Source BSD 3-Clause, commercial license available||Open Source Open Source (AGPL), commercial license available|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||Linux|
Windows ported and maintained by Microsoft Open Technologies, Inc.
|Typing predefined data types such as float or date||yes||partial Supported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes||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.||yes||no||no|
|Secondary indexes||yes||yes with RediSearch module||yes cluster global secondary indices|
|SQL Support of SQL||yes||no||SQL-like DML and DDL statements (CQL)|
|APIs and other access methods||ADO.NET|
Tabular Data Stream (TDS)
|proprietary protocol RESP - REdis Serialization Protocol||Proprietary protocol CQL (Cassandra Query Language, an SQL-like language)|
|Supported programming languages||C#|
|Server-side scripts Stored procedures||Transact SQL, .NET languages, R, Python and (with SQL Server 2019) Java||Lua||no|
|Partitioning methods Methods for storing different data on different nodes||tables can be distributed across several files (horizontal partitioning); sharding through federation||Sharding||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||yes, but depending on the SQL-Server Edition||Master-slave replication Chained replication is supported|
Multi-master replication with Redis Enterprise Pack
|selectable replication factor Representation of geographical distribution of servers is possible|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Eventual Consistency|
Strong eventual consistency with CRDTs
Immediate Consistency can be individually decided for each write operation
|Foreign keys Referential integrity||yes||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||Optimistic locking, atomic execution of commands blocks and scripts||no Atomicity and isolation are supported for single operations|
|Concurrency Support for concurrent manipulation of data||yes||yes Data access is serialized by the server||yes|
|Durability Support for making data persistent||yes||yes Configurable mechanisms for persistency via snapshots and/or operations logs||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||yes||yes in-memory tables|
|User concepts Access control||fine grained access rights according to SQL-standard||Simple password-based access control Access control lists and SSL are available in the commercial version||Access rights for users can be defined per object|
|More information provided by the system vendor|
|Microsoft SQL Server||Redis||ScyllaDB|
|Specific characteristics||Redis, benchmarked as the world's fastest database, reduces application complexity,...|
|Scylla is a highly-available, highly-scalable, highly-performant NoSQL database....|
|Competitive advantages||Redis is an in-memory database platform offering native support of wide range of...|
|Highly-performant (efficiently utilizes full resources of a node and network; millions...|
|Typical application scenarios||Redis powers personalization, real-time fraud detection, IoT, e-commerce, real-time...|
|AdTech (AdGear, AppNexus, Dstillery, Numberly, Sizmek) Cybersecurity (Veramine) Entertainment...|
|Key customers||Verizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,...|
|Comcast, Grab, Yahoo! Japan, IMVU, Adgear, Appnexus, Zenly, Natura, Snapfish, mParticle,...|
|Licensing and pricing models||The licensing model is subscription based. Redis Enterprise Cloud is priced according...|
|Scylla Open Source - free open source software (AGPL) Scylla Enterprise - subscription-based...|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Navicat for SQL Server gives you a fully graphical approach to database management and development.|
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
DBHawk is a web-based data management Tool for a SQL Server database.
Dremio is like magic for SQL Server accelerating your analytical queries up to 1,000x.
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
SQLPro for MSSQL: A simple but powerful Microsoft SQL Server database client available on iPhone and iPad as well as macOS.
ERBuilder provides all the features you would expect from a professional database modeling and design tool.
|Redis Labs is the open source home and the provider of enterprise-class Redis.|
ScaleGrid: Fully managed Redis-as-a-Service in the cloud.
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.
|Microsoft SQL Server||Redis||ScyllaDB|
|DB-Engines blog posts|
The struggle for the hegemony in Oracle's database empire Microsoft SQL Server is the DBMS of the Year Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
Microsoft SQL Server is the DBMS of the Year Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
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
|Recent citations in the news|
Turning off Parameter Sniffing for a SQL Server Database by Default
IDERA SQL Diagnostic Manager for SQL Server 10.5 Expands Performance Monitoring On-Premises and in the Cloud
SQL Server 2008's End of Life Opens New Role for Database as a Service
SQL Server Runs Faster on Azure Cloud VMs than AWS EC2, Report Says
Zadara Accelerates SQL Server Database Migration to the Cloud
provided by Google News
Redis Labs Leverages Kubernetes to Automate Database Recovery
Redis Labs Boosts Data Visualization, Cluster Recovery
Redis Labs bypasses the NoSQL storage bottleneck
Redis Labs eases database management with RedisInsight
Why use Redis Enterprise as a Database for Your Microservices?
provided by Google News
ScyllaDB Launches Scylla Cloud Database as a Service
IoT Pioneers Turn to Scylla for Low Latency, Out-of-the-Box Performance at Scale
ScyllaDB Unveils Highly Anticipated Features for High-Performance NoSQL Database
Scylla’s real-time NoSQL database tapped by 'super app'
ScyllaDB set to improve NoSQL database performance
provided by Google News
Sql Server Developer
SQL Server Developer
DEPARTMENTAL SYSTEM ANALYST (TALEO, ORACLE HR, AND SQL SERVER)
Senior SQL Server Database Administrator
SQL Server DBA
Database Engineer (MySQL)
PostgreSQL Database Admin
Database Engineer - NoSQL
Digital Solutions Senior Platform Engineer
Senior Software Engineer (Multiple Openings)
Database Administrator / Engineer
Data Architect & Database Developer
Senior Software Engineer - Backend
Share this page