DBMS > Microsoft Azure Data Explorer vs. MongoDB

System Properties Comparison Microsoft Azure Data Explorer vs. MongoDB

Please select another system to include it in the comparison.

Our visitors often compare Microsoft Azure Data Explorer and MongoDB with Elasticsearch, Microsoft Azure Cosmos DB and InfluxDB.

Editorial information provided by DB-Engines
Name	Microsoft Azure Data Explorer  Xexclude from comparison	MongoDB  Xexclude from comparison
Description	Fully managed big data interactive analytics platform	One of the most popular document stores available both as a fully managed cloud service and for deployment on self-managed infrastructure
Primary database model	Relational DBMS column oriented	Document store
Secondary database models	Document store If 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 this 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 support 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 see docs.microsoft.com/­en-us/­azure/­data-explorer/­time-series-analysis	Spatial DBMS Search engine integrated Lucene index, currently in MongoDB Atlas only. Time Series DBMS Time Series Collections introduced in Release 5.0
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 7.34 Rank #59   Overall #34   Relational DBMS	Score 480.73 Rank #5   Overall #1   Document stores
Website	azure.microsoft.com/­services/­data-explorer	www.mongodb.com
Technical documentation	docs.microsoft.com/­en-us/­azure/­data-explorer	docs.mongodb.com/­manual
Developer	Microsoft	MongoDB, Inc
Initial release	2019	2009
Current release	cloud service with continuous releases	5.0.8, April 2022
License Commercial or Open Source	commercial	Open Source MongoDB Inc.'s Server Side Public License v1. Prior versions were published under GNU AGPL v3.0. Commercial licenses are also available.
Cloud-based only Only available as a cloud service	yes	no MongoDB available as DBaaS (MongoDB Atlas)
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.		ScaleGrid for MongoDB: Fully managed hosting for MongoDB database on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS. MongoDB Atlas: Global multi-cloud database with unmatched data distribution and mobility across AWS, Azure, and Google Cloud, built-in automation for resource and workload optimization, and so much more.
Implementation language		C++
Server operating systems	hosted	Linux OS X Solaris Windows
Data scheme	Fixed schema with schema-less datatypes (dynamic)	schema-free Although schema-free, documents of the same collection often follow the same structure. Optionally impose all or part of a schema by defining a JSON schema.
Typing predefined data types such as float or date	yes bool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types	yes string, integer, double, decimal, boolean, date, object_id, geospatial
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
Secondary indexes	all fields are automatically indexed	yes
SQL Support of SQL	Kusto Query Language (KQL), SQL subset	Read-only SQL queries via the MongoDB Connector for BI
APIs and other access methods	Microsoft SQL Server communication protocol (MS-TDS) RESTful HTTP API	proprietary protocol using JSON
Supported programming languages	.Net Go Java JavaScript (Node.js) PowerShell Python R	Actionscript unofficial driver C C# C++ Clojure unofficial driver ColdFusion unofficial driver D unofficial driver Dart unofficial driver Delphi unofficial driver Erlang Go Groovy unofficial driver Haskell Java JavaScript Lisp unofficial driver Lua unofficial driver MatLab unofficial driver Perl PHP PowerShell unofficial driver Prolog unofficial driver Python R unofficial driver Ruby Rust Scala Smalltalk unofficial driver Swift
Server-side scripts Stored procedures	Yes, possible languages: KQL, Python, R	JavaScript
Triggers	yes see docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicy	yes in MongoDB Atlas only
Partitioning methods Methods for storing different data on different nodes	Sharding Implicit feature of the cloud service	Sharding Partitioned by hashed, ranged, or zoned sharding keys. Live resharding allows users to change their shard keys as an online operation with zero downtime.
Replication methods Methods for redundantly storing data on multiple nodes	yes Implicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.	Multi-Source deployments with MongoDB Atlas Global Clusters Source-replica replication
MapReduce Offers an API for user-defined Map/Reduce methods	no	yes
Consistency concepts Methods to ensure consistency in a distributed system	Eventual Consistency Immediate Consistency	Eventual Consistency Immediate Consistency can be individually decided for each write operation
Foreign keys Referential integrity	no	no typically not used, however similar functionality with DBRef possible
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	no	Multi-document ACID Transactions with snapshot isolation
Concurrency Support for concurrent manipulation of data	yes	yes
Durability Support for making data persistent	yes	yes optional, enabled by default
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	no	yes In-memory storage engine introduced with MongoDB version 3.2
User concepts Access control	Azure Active Directory Authentication	Access rights for users and roles
More information provided by the system vendor
	Microsoft Azure Data Explorer	MongoDB
Specific characteristics	Azure Data Explorer is a fast and highly scalable data exploration service for log... » more	MongoDB’s application data platform provides developers a unified interface to power... » more
Competitive advantages	Kusto Query Language (innovative query language, optimized for high performance data... » more	The MongoDB platform can be used by developers building transactional, operational,... » more
Typical application scenarios	IoT applications IoT devices generate billions of sensor readings. Normalizing and... » more	Internet of Things and Time Series (Bosch, Jaguar Land Rover) Mobile (The Weather... » more
Key customers	Microsoft, DocuSign, Taboola, Bosch, Siemens Healthineers, Bühler, Ecolab, Zoomd » more	ADP, Adobe, Amadeus, AstraZeneca, Auto Trader, Barclays, BBVA, Bosch, Cisco, CERN,... » more
Market metrics	Azure Data Explorer is the data service for Azure Monitor, Azure Time Series Insights,... » more	200+ million downloads, over 1.5M Atlas database clusters under management handling... » more
Licensing and pricing models	An Azure Data Explorer cluster is a pair of engine and data management clusters which... » more	MongoDB database server: Server-Side Public License (SSPL) . Commercial licenses... » more
Related products and services
3rd parties		CData: Connect to Big Data & NoSQL through standard Drivers. » more Percona: Database problems? Not on your watch. Databases run better with Percona. » more Navicat for MongoDB gives you a highly effective GUI interface for MongoDB database management, administration and development. » more
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
	Microsoft Azure Data Explorer	MongoDB
DB-Engines blog posts