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

DBMS > Elasticsearch vs. Hazelcast vs. JSqlDb vs. Microsoft Azure Data Explorer vs. Sqrrl

System Properties Comparison Elasticsearch vs. Hazelcast vs. JSqlDb vs. Microsoft Azure Data Explorer vs. Sqrrl

Editorial information provided by DB-Engines
NameElasticsearch  Xexclude from comparisonHazelcast  Xexclude from comparisonJSqlDb  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonSqrrl  Xexclude from comparison
Sqrrl has been acquired by Amazon and became a part of Amazon Web Services. It has been removed from the DB-Engines ranking.
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 metricA widely adopted in-memory data gridJavaScript Query Language Database, stores JavaScript objects and primitivesFully managed big data interactive analytics platformAdaptable, secure NoSQL built on Apache Accumulo
Primary database modelSearch engineKey-value storeDocument store
Object oriented DBMS
Relational DBMS infocolumn orientedDocument store
Graph DBMS
Key-value store
Wide column store
Secondary database modelsDocument storeDocument store infoJSON support with IMDG 3.12Document 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
Score148.91
Rank#7  Overall
#1  Search engines
Score9.16
Rank#44  Overall
#5  Key-value stores
Score0.00
Rank#342  Overall
#47  Document stores
#21  Object oriented DBMS
Score2.75
Rank#89  Overall
#45  Relational DBMS
Websitewww.elastic.co/­products/­elasticsearchhazelcast.comjsqldb.orgazure.microsoft.com/­services/­data-explorersqrrl.com
Technical documentationwww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmlhazelcast.org/­documentationdocs.microsoft.com/­en-us/­azure/­data-explorer
DeveloperElasticHazelcastKonrad von BackstromMicrosoftAmazon infooriginally Sqrrl Data, Inc.
Initial release20102008201820192012
Current release7.3.0, August 20194.0, February 20200.8, December 2018cloud service with continuous releases
License infoCommercial or Open SourceOpen Source infoApache Version 2; Elastic LicenseOpen Source infoApache Version 2; commercial licenses availableOpen Sourcecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenononoyesno
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 AWS and GCP that's powered by the creators of Elasticsearch.
Implementation languageJavaJavaJava
Server operating systemsAll OS with a Java VMAll OS with a Java VMLinux
macOS
Windows
hostedLinux
Data schemeschema-free infoFlexible type definitions. Once a type is defined, it is persistentschema-freeschema-freeFixed schema with schema-less datatypes (dynamic)schema-free
Typing infopredefined data types such as float or dateyesyesnoyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesyes
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 infothe object must implement a serialization strategynoyes
Secondary indexesyes infoAll search fields are automatically indexedyesnoall fields are automatically indexedyes
SQL infoSupport of SQLSQL-like query languageSQL-like query languagenoKusto Query Language (KQL), SQL subsetno
APIs and other access methodsJava API
RESTful HTTP/JSON API
JCache
JPA
Memcached protocol
RESTful HTTP API
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
Accumulo Shell
Java API
JDBC
ODBC
RESTful HTTP API
Thrift
Supported programming languages.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby
.Net
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
Python
Scala
JavaScript.Net
Java
JavaScript (Node.js)
PowerShell
Python
R
Actionscript
C infousing GLib
C#
C++
Cocoa
Delphi
Erlang
Go
Haskell
Java
JavaScript
OCaml
Perl
PHP
Python
Ruby
Smalltalk
Server-side scripts infoStored proceduresyesyes infoEvent Listeners, Executor Servicesfunctions in JavaScriptYes, possible languages: KQL, Python, Rno
Triggersyes infoby using the 'percolation' featureyes infoEventsnoyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingnoneSharding infoImplicit feature of the cloud serviceSharding infomaking use of Hadoop
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes infoReplicated Mapnoneyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.selectable replication factor infomaking use of Hadoop
MapReduce infoOffers an API for user-defined Map/Reduce methodsES-Hadoop Connectoryesnonoyes
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 Consistency or Eventual Consistency selectable by user infoRaft Consensus AlgorithmEventual Consistency
Immediate Consistency
Immediate Consistency infoDocument store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.
Foreign keys infoReferential integritynonononono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoone or two-phase-commit; repeatable reads; read commitednoAtomic updates per row, document, or graph entity
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyes infousing RocksDByesyes
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 controlRole-based access controlAzure Active Directory AuthenticationCell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)
More information provided by the system vendor
ElasticsearchHazelcastJSqlDbMicrosoft Azure Data ExplorerSqrrl
Specific characteristicsElasticsearch is a highly scalable open source full-text search and analytics engine....
» more
Hazelcast is an in-memory computing platform that runs applications with extremely...
» more
Azure Data Explorer is a fast and highly scalable data exploration service for log...
» more
Competitive advantagesOpen source, real-time index, search and analysis, horizontally scalable, distributed,...
» more
Hazelcast has an optimized, multi-threaded architecture that enables the highest...
» more
Kusto Query Language (innovative query language, optimized for high performance data...
» more
Typical application scenariosSearch, logging, security, metrics, maps and business analytics use cases.
» more
Hazelcast powers many types of large-scale, data processing applications. A sample...
» more
IoT applications IoT devices generate billions of sensor readings. Normalizing and...
» more
Key customers
» more
Hazelcast customers include 50 of the world’s largest financial services companies,...
» more
Microsoft, DocuSign, Taboola, Bosch, Siemens Healthineers, Bühler, Ecolab, Zoomd
» more
Market metricsMore than 400 million cumulative downloads More than 100,000 community members in...
» 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
Hazelcast provides both open source and commercial software. The open source offering...
» 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 partiesDremio: Analyze your data with standard SQL and any BI tool. Accelerate your queries up to 1,000x.
» more

Elastic Cloud: Try the official hosted Elasticsearch.
» more

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

More resources
ElasticsearchHazelcastJSqlDbMicrosoft Azure Data ExplorerSqrrl
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

A hacker has wiped, defaced more than 15,000 Elasticsearch servers
3 April 2020, ZDNet

Instaclustr Adds Elasticsearch to its Band of Managed Open Source Data-Layer Technologies
30 March 2020, Database Trends and Applications

Instaclustr Offering Fully Managed Open Source Elasticsearch on AWS
30 March 2020, Yahoo Finance

Unprotected Elasticsearch Server Leaks 5 Billion Records
20 March 2020, CISO MAG

Misconfigured Elasticsearch Instance Exposes More ...
19 March 2020, Dark Reading

provided by Google News

Hazelcast Announces Managed Service for Simplified Management of Multi-Cloud and Cloud-to-Edge Applications
1 April 2020, EnterpriseTalk

Hazelcast Releases Cloud Enterprise on AWS
31 March 2020, Database Trends and Applications

Hazelcast Jet Simplifies Enterprise Python and Java AI/ML Deployments
11 March 2020, ADT Magazine

Hazelcast Jet 4.0 boosts event streaming data platform
17 March 2020, TechTarget

Hazelcast raises $50 million to deliver speedy in-memory compute services
12 February 2020, VentureBeat

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

Microsoft announces reserved capacity offerings for six more Azure services
13 November 2019, Neowin

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

AWS security options grow with Amazon Detective
1 April 2020, TechTarget

Insights on the Global Behavior Analytics Industry - Featuring Splunk, Rapid7 & Varonis Systems Among Others
30 March 2020, Yahoo Finance

Anne Arundel libraries offer virtual storytelling and activities, spend $150,000 on digital collections
20 March 2020, Baltimore Sun

Global Behavior Analytics Market (2018 to 2024) - By Component, Deployment, End User and Region
27 March 2020, Yahoo Finance

AWS beefs up threat detection with Sqrrl acquisition
24 January 2018, TechCrunch

provided by Google News

Job opportunities

DevOps Engineer - Remote - Jr. Level
Pagely, Remote

Elasticsearch Engineer (ELK - Elastic, Logstash, Kibana)
ShorePoint, Reston, VA

Golang Backend Developer
Essani International LLC, Remote

Infrastructure DevOps
eTek IT Service, Newark, CA

Research Programmer II
The Scripps Research Institute, San Diego, CA

Java Developer
PRAXIS, S.A. DE C.V, Columbus, OH

Java Application Developer - Chicago, IL
Atlas, Inc., Chicago, IL

Senior Java Engineer
Sierra Wireless Inc., Atlanta, GA

Java Developer- Jersey City
Bank of America, Jersey City, NJ

Python Developer – Compliance Technology
IBKR, Greenwich, CT

Monetization Data Scientist – Minecraft DnA
Microsoft, Redmond, WA

Azure Data Engineer
Denken Solutions Inc, Grand Rapids, MI

Game Health Analyst
Microsoft, Redmond, WA

Data and Applied Scientist II
Microsoft, Redmond, WA

Data Architect – Minecraft DnA
Microsoft, Redmond, WA

Cybersecurity Threat Hunter
Arete Advisors, New York, NY

Security Operations Center (SOC) Analyst (Day Shift)
XOR Security, Herndon, VA

Cyber Hunt SME
XOR Security, Arrington, VA

Security Engineer
XOR Security, Herndon, VA

Cyber Security Engineer
XOR Security, Springfield, VA

jobs by Indeed




Share this page

Featured Products

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.

Datastax Luna logo

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Neo4j logo

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

Present your product here