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

DBMS > Machbase vs. Microsoft Azure Data Explorer vs. Redis

System Properties Comparison Machbase vs. Microsoft Azure Data Explorer vs. Redis

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameMachbase infoFormer name was Infiniflux  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonRedis  Xexclude from comparison
DescriptionTimeSeries DBMS for IoT and BigDataFully managed big data interactive analytics platformIn-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.
Primary database modelTime Series DBMSRelational DBMSKey-value store infoMultiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistence
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
Score0.06
Rank#303  Overall
#25  Time Series DBMS
Score2.33
Rank#104  Overall
#50  Relational DBMS
Score148.75
Rank#8  Overall
#1  Key-value stores
Websitewww.machbase.comazure.microsoft.com/­services/­data-explorerredis.io
Technical documentationdoc.machbase.comdocs.microsoft.com/­en-us/­azure/­data-explorerredis.io/­documentation
DeveloperMachbaseMicrosoftSalvatore Sanfilippo infoDevelopment sponsored by Redis Labs
Initial release201320192009
Current releaseV4.05.0.7, November 2019
License infoCommercial or Open Sourcecommercial infofree test version availablecommercialOpen Source infoBSD 3-Clause, commercial license available
Cloud-based only infoOnly available as a cloud servicenoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC
Server operating systemsLinux
Windows
hostedBSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
Data schemeyesyesschema-free
Typing infopredefined data types such as float or dateyesyespartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes
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.noyesno
Secondary indexesyesyes infowith RediSearch module
SQL infoSupport of SQLSQL-like query languageKusto Query Language (KQL), SQL subsetno
APIs and other access methodsHTTP REST
JDBC
ODBC
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
proprietary protocol infoRESP - REdis Serialization Protocol
Supported programming languagesC
C#
C++
Java
JavaScript
PHP infovia ODBC
Python
R infovia ODBC
Scala
.Net
Java
JavaScript (Node.js)
PowerShell
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
Server-side scripts infoStored proceduresnoYes. Languages: KQL, Python, RLua
TriggersnoTable-level update policy rules can be used to automatically run a query and ingest its results when data is ingested into another table.no
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoImplicit feature of the cloud serviceSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.Master-slave replication infoChained replication is supported
Multi-master replication infowith Redis Enterprise Pack
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Eventual Consistency
Strong eventual consistency with CRDTs
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoOptimistic locking, atomic execution of commands blocks and scripts
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoData access is serialized by the server
Durability infoSupport for making data persistentnoyesyes infoConfigurable mechanisms for persistency via snapshots and/or operations logs
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infovolatile and lookup tablenoyes
User concepts infoAccess controlsimple password-based access controlAzure Active Directory AuthenticationSimple password-based access control infoAccess control lists and SSL are available in the commercial version
More information provided by the system vendor
Machbase infoFormer name was InfinifluxMicrosoft Azure Data ExplorerRedis
Specific characteristicsMachbase is an extremely fast time series database which processes large volumes...
» more
Competitive advantagesFastest Database for IIoT, Independently verified, on Industry Standard Benchmarks....
» more
Typical application scenariosDistributed Query In Machbase Enterprise Edition, a broker node, which is responsible...
» more
Key customersSamsung, POSCO, Hyundai heavy industries, SFA
» more
Market metricsReal-time data processing Real-time index creation Optimized DBMS for processing...
» more
Licensing and pricing modelsMachbase provide several product editions, including: Intelligent Edge Device, Fog...
» 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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

ScaleGrid: Fully managed Redis-as-a-Service in the cloud.
» more

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

More resources
Machbase infoFormer name was InfinifluxMicrosoft Azure Data ExplorerRedis
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

MachBase Bests the Competition to Take Top Slot as Fastest IoT Database Ranks #1 in Industry standard TPCx-IoT Database Benchmark
20 November 2019, PR Web

Enabling the Edge, The True IIoT Opportunity; Machbase Makes "Smart" Possible with its Newly Introduced Edge Database Edition
8 April 2019, Business Wire

Machbase Enables Edge Analytics for Multiple Locations
2 July 2019, PRNewswire

IBM and DBmaestro Announce a Global Partnership on DevOps and Cloud Solutions
11 July 2019, EnterpriseTalk

Maxon Acquires Redshift Rendering Technologies
10 April 2019, AiThority

provided by Google News

How to share data in place from Azure Data Explorer - Microsoft
20 December 2019, Channel 9

Azure Data Explorer for IoT Data Analytics | Internet of Things Show - Microsoft
2 September 2019, Channel 9

How to use Azure Data Explorer for big data analysis
12 February 2019, InfoWorld

Fastly, Microsoft partner on real-time analytics with Azure Data Explorer
29 January 2019, ZDNet

Zoomd Takes Another Step Towards Becoming an Industry Leader After Adopting Microsoft's Azure Data Explorer
4 December 2019, PRNewswire

provided by Google News

“It's just not intuitive of the DevOps mindset” Redis's CMO talks all things developer
16 January 2020, DevOps Online

Epsagon bags $16M to bring more transparency to containers and serverless apps
16 January 2020, SiliconANGLE

The Business Benefits of Choosing Aerospike Database
16 January 2020, Appinventiv

Why Open Source Licenses With A Commons Clause May Become Less Common - Intellectual Property - United States
13 January 2020, Mondaq News Alerts

AWS hits back at open-source software critics
18 December 2019, ZDNet

provided by Google News

Job opportunities

Senior Data Scientist
Microsoft, Redmond, WA

Senior Data Engineer - Turn 10 Studios
Microsoft, Redmond, WA

Software Engineer - CTJ
Microsoft, Redmond, WA

Principal Program Manager
Microsoft, Redmond, WA

Support Engineer
Microsoft, Charlotte, NC

PostgreSQL Database Admin
AWeber, Chalfont, PA

Database Platform Engineer (RDBMS & No SQL )
Experian, Allen, TX

Database Administrator
Perfect World Entertainment, Redwood City, CA

Database Administrator
TMP WORLDWIDE, New York, NY

Database Architect
Kronos Incorporated, Lowell, MA

jobs by Indeed




Share this page

Featured Products

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

Datastax Luna logo

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

Neo4j logo

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

RavenDB logo

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

Couchbase logo

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

Present your product here