DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AlaSQL vs. H2 vs. Microsoft Azure SQL Database vs. Redis vs. RRDtool

System Properties Comparison AlaSQL vs. H2 vs. Microsoft Azure SQL Database vs. Redis vs. RRDtool

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonH2  Xexclude from comparisonMicrosoft Azure SQL Database infoformerly SQL Azure  Xexclude from comparisonRedis  Xexclude from comparisonRRDtool  Xexclude from comparison
DescriptionJavaScript DBMS libraryFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.Database as a Service offering with high compatibility to Microsoft SQL ServerPopular in-memory data platform used as a cache, message broker, and database that can be deployed on-premises, across clouds, and hybrid environments infoRedis focuses on performance so most of its design decisions prioritize high performance and very low latencies.Industry 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.
Primary database modelDocument store
Relational DBMS
Relational DBMSRelational DBMSKey-value store infoMultiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistenceTime Series DBMS
Secondary database modelsSpatial DBMSDocument store
Graph DBMS
Spatial DBMS
Document store infowith RedisJSON
Graph DBMS infowith RedisGraph
Spatial DBMS
Search engine infowith RediSearch
Time Series DBMS infowith RedisTimeSeries
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.67
Rank#215  Overall
#32  Document stores
#108  Relational DBMS
Score9.69
Rank#48  Overall
#30  Relational DBMS
Score78.26
Rank#15  Overall
#10  Relational DBMS
Score171.94
Rank#6  Overall
#1  Key-value stores
Score2.44
Rank#112  Overall
#7  Time Series DBMS
Websitealasql.orgwww.h2database.comazure.microsoft.com/­en-us/­services/­sql-databaseredis.com
redis.io
oss.oetiker.ch/­rrdtool
Technical documentationgithub.com/­agershun/­alasqlwww.h2database.com/­html/­main.htmldocs.microsoft.com/­en-us/­azure/­azure-sqldocs.redis.com/­latest/­index.html
redis.io/­documentation
oss.oetiker.ch/­rrdtool/­doc
DeveloperAndrey Gershun & Mathias R. WulffThomas MuellerMicrosoftRedis project core team, inspired by Salvatore Sanfilippo infoDevelopment sponsored by Redis LabsTobias Oetiker
Initial release20142005201020091999
Current release1.4.200, October 2019V126.2.5, July 20211.7.2, May 2019
License infoCommercial or Open SourceOpen Source infoMIT-LicenseOpen Source infodual-licence (Mozilla public license, Eclipse public license)commercialOpen Source infosource-available extensions (modules), commercial licenses for Redis EnterpriseOpen Source infoGPL V2 and FLOSS
Cloud-based only infoOnly available as a cloud servicenonoyesnono
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 languageJavaScriptJavaC++CC infoImplementations in Java (e.g. RRD4J) and C# available
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)All OS with a Java VMhostedBSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
HP-UX
Linux
Data schemeschema-freeyesyesschema-freeyes
Typing infopredefined data types such as float or datenoyesyespartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexesNumeric data only
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.nonoyesnono infoExporting into and restoring from XML files possible
Secondary indexesnoyesyesyes infowith RediSearch moduleno
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.yesyesnono
APIs and other access methodsJavaScript APIJDBC
ODBC
ADO.NET
JDBC
ODBC
proprietary protocol infoRESP - REdis Serialization Protocolin-process shared library
Pipes
Supported programming languagesJavaScriptJava.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
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
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
Server-side scripts infoStored proceduresnoJava Stored Procedures and User-Defined FunctionsTransact SQLLua; Redis Functions coming in Redis 7 (slides and Github)no
Triggersyesyesyespublish/subscribe channels provide some trigger functionality; RedisGearsno
Partitioning methods infoMethods for storing different data on different nodesnonenoneSharding infoAutomatic hash-based sharding with support for hash-tags for manual shardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesnoneWith clustering: 2 database servers on different computers operate on identical copies of a databaseyes, with always 3 replicas availableMulti-source replication infowith Redis Enterprise Pack
Source-replica replication infoChained replication is supported
none
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononothrough RedisGearsno
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate ConsistencyEventual Consistency
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active
none
Foreign keys infoReferential integrityyesyesyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storageACIDACIDAtomic execution of command blocks and scripts and optimistic lockingno
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyes infoData access is serialized by the serveryes infoby using the rrdcached daemon
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesyesyes 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.yesyesyesyes
User concepts infoAccess controlnofine grained access rights according to SQL-standardfine grained access rights according to SQL-standardAccess Control Lists (ACLs): redis.io/­topics/­acl
LDAP and Role-Based Access Control (RBAC) for Redis Enterprise
Mutual TLS authentication: redis.io/­topics/­encryption
Password-based authentication
no
More information provided by the system vendor
AlaSQLH2Microsoft Azure SQL Database infoformerly SQL AzureRedisRRDtool
Specific characteristicsThe Redis real-time data platform builds upon the unmatched simplicity and speed...
» more
Competitive advantagesRedis Enterprise is a robust in-memory database platform built by the people who...
» more
Typical application scenariosRedis Enterprise is used by large enterprise, startup, and government organizations...
» more
Key customersVerizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,...
» more
Market metricsMost launched Docker container per day according to Docker Hub (7.2M launches per...
» more
Licensing and pricing modelsRedis Enterprise Cloud lets users scale up and down instantly, and pay only for the...
» 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 partiesRedisson PRO: The ultra-fast Redis Java Client.
» more

Read the Redis NoSQL benchmark report.
» 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
AlaSQLH2Microsoft Azure SQL Database infoformerly SQL AzureRedisRRDtool
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2020
4 January 2021, Paul Andlinger, Matthias Gelbmann

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

show all

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

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

Recent citations in the news

Meet AlaSQL, a speedy SQL database for JavaScript
15 January 2019, JAXenter

Introduction to Apache Spark: Big Data Analytics Simplified
4 September 2018, Business 2 Community

indexeddb | Read the Tea Leaves
10 April 2016, nolanlawson.com

provided by Google News

Best cloud databases of 2021
14 September 2021, ITProPortal

Microsoft builds distributed ledger for Azure SQL database
26 May 2021, TechTarget

How To Automate Tasks in Azure SQL Database
22 January 2021, Redmondmag.com

Azure SQL Database Ranked Among Top 3 Databases of 2020
14 January 2021, Visual Studio Magazine

Setup Azure SQL Database to use with Azure Static Web Apps [Bonus] | Azure Tips and Tricks: Static Web Apps - Microsoft
25 June 2021, Channel 9

provided by Google News

Amazon Releases MemoryDB For Redis
2 September 2021, iProgrammer

AWS Announces the General Availability of Amazon MemoryDB for Redis
24 August 2021, InfoQ.com

Database Management Software Market Size, Share and Top Vendors – RingLead, Redis Enterprise, MongoDB, SingleStore.com, Teradata Vantage, SAP HANA, HarperDB – Stillwater Current
22 September 2021, Stillwater Current

Benchmark Your Serverless Database with Thundra
14 September 2021, Security Boulevard

HUAWEI CLOUD GaussDB(for Redis) Releases Version with Dual Updates
19 September 2021, ACROFAN USA

provided by Google News

Bare-Bones Monitoring with Monit and RRDtool
21 March 2019, Linux Journal

How to install and use RRDTool to speed up MRTG monitoring
24 June 2009, SearchDataCenter.com

How to install Cacti SNMP Monitor on Ubuntu
24 November 2017, TechRepublic

On-premises server monitoring tools meet business needs, budget
31 December 2019, TechTarget

The Best Open Source Network Monitoring Tools To Know in 2021 - Best Network Monitoring Vendors, Software, Tools and Performance Solutions
7 September 2021, Solutions Review

provided by Google News

Job opportunities

Developer
Axle Informatics, Rockville, MD

Applications Developer
Axle Informatics, Rockville, MD

Advisor Azure SQL Database Administrator (DBA)
Gainwell Technologies, Texas

SQL DBA Administrator, Remote North America
Ciena, Baltimore, MD

SQL Database Developer
ShipBob Inc, Remote

Software Engineer II, SQL Database team
Microsoft, Atlanta, GA

Junior SQL Database Administrator (Remote)
Drips, Dallas, TX

Database Management Engineer II
Battelle, Columbus, OH

Database Reliability Engineer, SRE
Etsy, Brooklyn, NY

Database App Server Engineer
Maryland Courts, Annapolis, MD

Database Engineer I
Renaissance, Remote

Staff Database Reliability Engineer, SRE
Etsy, Brooklyn, NY

Systems Engineer
Domeyard LP, Boston, MA

Technical Support Engineer/Unix Admin
DigiLink, Marina del Rey, 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.

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..

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Present your product here