DB-EnginesExtremeDB: white paper about the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Elasticsearch vs. Microsoft Azure Data Explorer

System Properties Comparison Elasticsearch vs. Microsoft Azure Data Explorer

Please select another system to include it in the comparison.

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

Editorial information provided by DB-Engines
NameElasticsearch  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparison
DescriptionA distributed, RESTful modern search and analytics engine based on Apache Lucene infoElasticsearch lets you perform and combine many types of searches such as structured, unstructured, geo, and metricFully managed big data interactive analytics platform
Primary database modelSearch engineRelational DBMS infocolumn oriented
Secondary database modelsDocument store
Spatial DBMS
Vector DBMS
Document 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)
Spatial DBMS
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
Score137.15
Rank#7  Overall
#1  Search engines
Score6.55
Rank#62  Overall
#36  Relational DBMS
Websitewww.elastic.co/­elasticsearchazure.microsoft.com/­services/­data-explorer
Technical documentationwww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmldocs.microsoft.com/­en-us/­azure/­data-explorer
DeveloperElasticMicrosoft
Initial release20102019
Current release8.6, January 2023cloud service with continuous releases
License infoCommercial or Open SourceOpen Source infoElastic Licensecommercial
Cloud-based only infoOnly available as a cloud servicenoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJava
Server operating systemsAll OS with a Java VMhosted
Data schemeschema-free infoFlexible type definitions. Once a type is defined, it is persistentFixed schema with schema-less datatypes (dynamic)
Typing infopredefined data types such as float or dateyesyes 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 indexesyes infoAll search fields are automatically indexedall fields are automatically indexed
SQL infoSupport of SQLSQL-like query languageKusto Query Language (KQL), SQL subset
APIs and other access methodsJava API
RESTful HTTP/JSON API
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
Supported programming languages.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
Server-side scripts infoStored proceduresyesYes, possible languages: KQL, Python, R
Triggersyes infoby using the 'percolation' featureyes 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 service
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.
MapReduce infoOffers an API for user-defined Map/Reduce methodsES-Hadoop ConnectorSpark connector (open source): github.com/­Azure/­azure-kusto-spark
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allEventual Consistency
Immediate Consistency
Foreign keys infoReferential integritynono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanono
Concurrency infoSupport for concurrent manipulation of datayesyes
Durability infoSupport for making data persistentyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.Memcached and Redis integrationno
User concepts infoAccess controlAzure Active Directory Authentication
More information provided by the system vendor
ElasticsearchMicrosoft Azure Data Explorer
Specific characteristicsAzure Data Explorer is a fast and highly scalable data exploration service for log...
» more
Competitive advantagesKusto Query Language (innovative query language, optimized for high performance data...
» more
Typical application scenariosIoT applications IoT devices generate billions of sensor readings. Normalizing and...
» more
Key customersMicrosoft, DocuSign, Taboola, Bosch, Siemens Healthineers, Bühler, Ecolab, Zoomd
» more
Market metricsAzure Data Explorer is the data service for Azure Monitor, Azure Time Series Insights,...
» more
Licensing and pricing modelsAn Azure Data Explorer cluster is a pair of engine and data management clusters which...
» 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

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

More resources
ElasticsearchMicrosoft Azure Data Explorer
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

Elasticsearch moved into the top 10 most popular database management systems
3 July 2017, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

Making sense of data retrieval with Elasticsearch
29 May 2023, MSDynamicsWorld

How to Reindex a Database in Elasticsearch
10 September 2023, hackernoon.com

DarkBeam leaks billions of email and password combinations
27 September 2023, Security Affairs

Elastic announces AI assistant for observability, general availability of universal profiling
20 September 2023, Times of India

Cisco Catalyst SD-WAN Manager flaw allows remote server access
28 September 2023, BleepingComputer

provided by Google News

Azure at Microsoft Ignite 2022: Key updates for the Microsoft cloud ...
12 October 2022, MSDynamicsWorld

Introducing Microsoft Fabric: The data platform for the era of AI ...
23 May 2023, azure.microsoft.com

Microsoft Fabric Defragments Analytics, Enters Public Preview
23 May 2023, The New Stack

Introducing Microsoft Fabric: The Impact on Power BI
26 May 2023, DataDrivenInvestor

Streamlining Azure Data Explorer Table Creation, Mapping, and ...
16 July 2023, Medium

provided by Google News

Job opportunities

Entry Level Python Developer - 93
I28 Technologies Corporation, Remote

Elasticsearch Engineer (ELK)
Aalpha Prime Tech Global, San Antonio, TX

Elasticsearch Engineer (ELK)
Sira Consulting Inc, San Antonio, TX

.Net core
eTeam Inc., Texas

Software Engineer 0
SilverEdge, Fort Meade, MD

Data Analyst
Redcloud Consulting, Redmond, WA

Senior Software Engineer in Data, Game Creation
Electronic Arts, Austin, TX

Lead Software Engineer – Data Platforms
Adobe, San Jose, CA

Principal Software Engineer - Azure Data
Microsoft, Redmond, WA

Senior Azure Architect
IFG Companies, Arizona

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here