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 > Elasticsearch vs. Ignite vs. Microsoft Azure Data Explorer

System Properties Comparison Elasticsearch vs. Ignite vs. Microsoft Azure Data Explorer

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameElasticsearch  Xexclude from comparisonIgnite  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 metricApache Ignite is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads, delivering in-memory speeds at petabyte scale.Fully managed big data interactive analytics platform
Primary database modelSearch engineKey-value store
Relational DBMS
Relational DBMS infocolumn oriented
Secondary database modelsDocument store
Spatial 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)
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
Score154.71
Rank#8  Overall
#1  Search engines
Score4.93
Rank#71  Overall
#10  Key-value stores
#40  Relational DBMS
Score4.95
Rank#70  Overall
#39  Relational DBMS
Websitewww.elastic.co/­elasticsearchignite.apache.orgazure.microsoft.com/­services/­data-explorer
Technical documentationwww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmlapacheignite.readme.io/­docsdocs.microsoft.com/­en-us/­azure/­data-explorer
DeveloperElasticApache Software FoundationMicrosoft
Initial release201020152019
Current release7.8.0, June 2020Apache Ignite 2.6cloud service with continuous releases
License infoCommercial or Open SourceOpen Source infoApache Version 2; Elastic LicenseOpen Source infoApache 2.0commercial
Cloud-based only infoOnly available as a cloud servicenonoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Elasticsearch Service on Elastic Cloud: Try out the official hosted Elasticsearch and Kibana offering available on Amazon Web Services, Google Cloud and Microsoft Azure that's powered by the creators of Elasticsearch.
Implementation languageJavaC++, Java, .Net
Server operating systemsAll OS with a Java VMLinux
OS X
Solaris
Windows
hosted
Data schemeschema-free infoFlexible type definitions. Once a type is defined, it is persistentyesFixed schema with schema-less datatypes (dynamic)
Typing infopredefined data types such as float or dateyesyesyes 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.noyesyes
Secondary indexesyes infoAll search fields are automatically indexedyesall fields are automatically indexed
SQL infoSupport of SQLSQL-like query languageANSI-99 for query and DML statements, subset of DDLKusto Query Language (KQL), SQL subset
APIs and other access methodsJava API
RESTful HTTP/JSON API
HDFS API
Hibernate
JCache
JDBC
ODBC
Proprietary protocol
RESTful HTTP API
Spring Data
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
Supported programming languages.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby
C#
C++
Java
PHP
Python
Ruby
Scala
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
Server-side scripts infoStored proceduresyesyes (compute grid and cache interceptors can be used instead)Yes, possible languages: KQL, Python, R
Triggersyes infoby using the 'percolation' featureyes (cache interceptors and events)yes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicy
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infoImplicit feature of the cloud service
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes (replicated cache)yes 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 Connectoryes (compute grid and hadoop accelerator)no
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, allImmediate ConsistencyEventual Consistency
Immediate Consistency
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.Memcached and Redis integrationyesno
User concepts infoAccess controlSecurity Hooks for custom implementationsAzure Active Directory Authentication
More information provided by the system vendor
ElasticsearchIgniteMicrosoft Azure Data Explorer
Specific characteristicsElasticsearch is an open source search and analytics engine. As the heart of the...
» more
Azure Data Explorer is a fast and highly scalable data exploration service for log...
» more
Competitive advantagesOpen source Real-time indexsearch, and analysis Horizontally scalable Distributed...
» more
Kusto Query Language (innovative query language, optimized for high performance data...
» more
Typical application scenariosEnterprise search (search experiences for your workplace, apps, and websites), observability...
» more
IoT applications IoT devices generate billions of sensor readings. Normalizing and...
» more
Key customersThousands of organizations worldwide, including Cisco, eBay, Goldman Sachs, Microsoft,...
» more
Microsoft, DocuSign, Taboola, Bosch, Siemens Healthineers, Bühler, Ecolab, Zoomd
» more
Market metricsPublic as of October 2018 Distributed workforce with 1900+ employees around the globe​...
» more
Azure Data Explorer is the data service for Azure Monitor, Azure Time Series Insights,...
» more
Licensing and pricing modelsThe Elastic Stack (Elasticsearch, Kibana, Beats, and Logstash) is free and open source...
» 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 partiesElastic Cloud: Try the official managed Elasticsearch.
» more

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

More resources
ElasticsearchIgniteMicrosoft 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

Instaclustr Achieves PCI-DSS Certification for its Managed
14 June 2021, GlobeNewswire

Instaclustr's Managed Elasticsearch Offering on AWS for Data Logging, Search, and Analytics Earns PCI-DSS Certification
14 June 2021, Analytics Insight

Microsoft and Elastic Partner to Offer Elastic Stack on Azure – InfoQ.com
30 May 2021, InfoQ.com

Elastic's stock rises sharply on strong quarterly revenue beat
2 June 2021, SiliconANGLE News

Elastic 7.13 stretches to runtime fields, searchable object stores and Azure integration • DEVCLASS
26 May 2021, DevClass

provided by Google News

First Apache Ignite Summit Energizes Global Audience
10 June 2021, GlobeNewswire

Optimizing the Relationship Between Apache Ignite and Kubernetes
9 October 2020, Container Journal

The Apache® Software Foundation Welcomes its Global Community Online at ApacheCon(TM) Asia 2021
9 June 2021, StreetInsider.com

Data Warehouse Software Market Size, Industry Trends and Forecast to 2028 | Major Players – BI360 Data Warehouse, Microsoft, Qlik Compose, Acho, Anzo, Apache Ignite – The Courier
17 June 2021, The Courier

GridGain Publishes Full Conference Schedule for Ignite Summit
12 May 2021, GlobeNewswire

provided by Google News

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

Get Started with Accessing Azure Data Explorer using Apache Spark for Azure Synapse Analytics - Microsoft
8 April 2021, Channel 9

Microsoft Azure Data Lake Storage Is Now Generally Available
20 February 2019, eWeek

Azure Data Explorer is now using AMD EPYC processor-based virtual machines
6 November 2020, Backend News

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

provided by Google News

Job opportunities

Elasticsearch Data Scientist
Belay Technologies, Inc, Annapolis Junction, MD

ELK Developer
Amdocs, Alpharetta, GA

Software Engineer (Remote, EST or GNV)
SharpSpring, Remote

Front-End Web Developer
SpyFu.com, Scottsdale, AZ

Elasticsearch Developer
Summit Racing Equipment, Tallmadge, OH

Social Media & Community Marketing Manager (Remote U.S.)
GridGain, Foster City, CA

Social Media & Community Marketing Manager (Remote U.S.)
GridGain Systems, Foster City, CA

Java Apache Camel Developer - C79099 5.4 Charlotte, NC
CapB InfoteK, Charlotte, NC

Software Engineer
Intelliforce IT Solutions Group, Ellicott City, MD

Software Engineering
JPMorgan Chase Bank, N.A., Jersey City, NJ

Azure Data Engineer
Nuvento Inc, Remote

Data Engineer- Turn10 Studios
Microsoft, Redmond, WA

Business Intelligence Program Manager
Microsoft, Redmond, WA

Data & Applied Scientist
Microsoft, Redmond, WA

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

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

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!

Couchbase logo

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

Present your product here