DB-EngineseXtremeDB Telecom and Networking featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Machbase vs. Microsoft Azure Cosmos DB vs. Microsoft Azure Data Explorer

System Properties Comparison Machbase vs. Microsoft Azure Cosmos DB vs. Microsoft Azure Data Explorer

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 Cosmos DB infoformer name was Azure DocumentDB  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparison
DescriptionTimeSeries DBMS for IoT and BigDataGlobally distributed, horizontally scalable, multi-model database serviceFully managed big data interactive analytics platform
Primary database modelTime Series DBMSDocument store
Graph DBMS
Key-value store
Wide column store
Relational DBMS infocolumn oriented
Secondary database modelsDocument store infoIf a column is of type dynamic docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types/­dynamic then it's possible to add arbitrary JSON documents in this cell
Event Store infothis is the general usage pattern at Microsoft. Billing, Logs, Telemetry events are stored in ADX and the state of an individual entity is defined by the arg_max(timestamps)
Search engine infosupport for complex search expressions docs.microsoft.com/­en-us/­azure/­kusto/­query/­parseoperator FTS, Geospatial docs.microsoft.com/­en-us/­azure/­kusto/­query/­geo-point-to-geohash-function distributed search -> ADX acts as a distributed search engine
Time Series DBMS infosee docs.microsoft.com/­en-us/­azure/­data-explorer/­time-series-analysis
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.36
Rank#255  Overall
#19  Time Series DBMS
Score32.50
Rank#25  Overall
#3  Document stores
#2  Graph DBMS
#3  Key-value stores
#3  Wide column stores
Score4.20
Rank#80  Overall
#43  Relational DBMS
Websitewww.machbase.comazure.microsoft.com/­services/­cosmos-dbazure.microsoft.com/­services/­data-explorer
Technical documentationendoc.machbase.comdocs.microsoft.com/­azure/­cosmos-dbdocs.microsoft.com/­en-us/­azure/­data-explorer
DeveloperMachbaseMicrosoftMicrosoft
Initial release201320142019
Current releaseV4.0cloud service with continuous releases
License infoCommercial or Open Sourcecommercial infofree test version availablecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenoyesyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC
Server operating systemsLinux
Windows
hostedhosted
Data schemeyesschema-freeFixed schema with schema-less datatypes (dynamic)
Typing infopredefined data types such as float or dateyesyes infoJSON typesyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types
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.noyes
Secondary indexesyesyes infoAll properties auto-indexed by defaultall fields are automatically indexed
SQL infoSupport of SQLSQL-like query languageSQL-like query languageKusto Query Language (KQL), SQL subset
APIs and other access methodsHTTP REST
JDBC
ODBC
DocumentDB API
Graph API (Gremlin)
MongoDB API
RESTful HTTP API
Table API
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
Supported programming languagesC
C#
C++
Java
JavaScript
PHP infovia ODBC
Python
R infovia ODBC
Scala
.Net
C#
Java
JavaScript
JavaScript (Node.js)
MongoDB client drivers written for various programming languages
Python
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
Server-side scripts infoStored proceduresnoJavaScriptYes, possible languages: KQL, Python, R
TriggersnoJavaScriptyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicy
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoImplicit feature of the cloud serviceSharding infoImplicit feature of the cloud service
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryes infoImplicit feature of the cloud serviceyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnowith Hadoop integration infoIntegration with Hadoop/HDInsight on Azure*no
Consistency concepts infoMethods to ensure consistency in a distributed systemBounded Staleness
Consistent Prefix
Eventual Consistency
Immediate Consistency infoConsistency level configurable on request level
Session Consistency
Eventual Consistency
Immediate Consistency
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoMulti-item ACID transactions with snapshot isolation within a partitionno
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentnoyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infovolatile and lookup tableno
User concepts infoAccess controlsimple password-based access controlAccess rights can be defined down to the item levelAzure Active Directory Authentication
More information provided by the system vendor
Machbase infoFormer name was InfinifluxMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDBMicrosoft Azure Data Explorer
Specific characteristicsMachbase is an extremely fast time series database which processes large volumes...
» more
Azure Data Explorer is a fast and highly scalable data exploration service for log...
» more
Competitive advantagesFastest Database for IIoT, Independently verified, on Industry Standard Benchmarks....
» more
Kusto Query Language (innovative query language, optimized for high performance data...
» more
Typical application scenariosDistributed Query In Machbase Cluster Edition, a broker node, which is responsible...
» more
IoT applications IoT devices generate billions of sensor readings. Normalizing and...
» more
Key customersSamsung, POSCO, Hyundai
» more
Microsoft, DocuSign, Taboola, Bosch, Siemens Healthineers, Bühler, Ecolab, Zoomd
» more
Market metricsReal-time data processing Real-time index creation Optimized DBMS for processing...
» more
Azure Data Explorer is the data service for Azure Monitor, Azure Time Series Insights,...
» 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

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 Cosmos DB infoformer name was Azure DocumentDBMicrosoft Azure Data Explorer
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

Machbase Signs Reseller Agreement with SL Corp. to Enhance RT Analytics Offering
29 July 2019, PRNewswire

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

provided by Google News

Microsoft Announces a New Pricing Model Option for Azure Cosmos DB and More Capabilities
3 June 2020, InfoQ.com

Microsoft introduces major Azure Cosmos DB changes
29 May 2020, TechRadar

Microsoft to introduce a free tier of its Cosmos DB NoSQL database
5 March 2020, ZDNet

NoSQL Databases Software Market 2020 to Global Forecast 2023 By Key Companies – MongoDB, Amazon, ArangoDB, Azure Cosmos DB, Couchbase, MarkLogic, RethinkDB, CouchDB, SQL-RD, OrientDB, RavenDB, Redis
25 November 2020, The Haitian-Caribbean News Network

Microsoft introduces a more cost-effective way to use Azure Cosmos DB - MSPoweruser
25 May 2020, MSPoweruser

provided by Google News

Azure Data Explorer gets new engine, numerous enhancements and Synapse integration
14 October 2020, ZDNet

AMD Boosts Microsoft Azure Data Explorer Performance
16 October 2020, SDxCentral

Azure Data Explorer gets Synapse integration and other enhancements
15 October 2020, EnterpriseTalk

AMD EPYC Processors Power Microsoft Azure Data Explorer, Offers Users 30 Percent Better Performance
15 October 2020, HPCwire

AMD releases Azure Data Explorer PaaS solution
19 October 2020, IT Brief Australia

provided by Google News

Job opportunities

Product Marketing Manager- Azure Cosmos DB
Microsoft, Redmond, WA

Azure Cosmos DB Consultant
JDA TSG, Remote

Azure Data Engineer (GC/USC) 100% Remote
Thought Storm LLC, Plano, TX

BI Developer
Insight Enterprises, Inc., Atlanta, GA

Azure Data Technologist
Slalom Consulting, Detroit, MI

Data Engineer
Intone Networks, Tempe, AZ

Data Engineer - Minecraft
Microsoft, Redmond, WA

Senior Data Engineer
PK, Portland, OR

Data Engineer
Disys India Private Limited, United States

Software Design Engineer
Microsoft, Redmond, WA

jobs by Indeed




Share this page

Featured Products

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

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

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Present your product here