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

DBMS > GridGain vs. Hazelcast vs. Microsoft Azure Data Explorer vs. Prometheus vs. Sqrrl

System Properties Comparison GridGain vs. Hazelcast vs. Microsoft Azure Data Explorer vs. Prometheus vs. Sqrrl

Editorial information provided by DB-Engines
NameGridGain  Xexclude from comparisonHazelcast  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonPrometheus  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.
DescriptionGridGain is an in-memory computing platform, built on Apache IgniteA widely adopted in-memory data gridFully managed big data interactive analytics platformOpen-source TimeSeries DBMS and monitoring systemAdaptable, secure NoSQL built on Apache Accumulo
Primary database modelKey-value store
Relational DBMS
Key-value storeRelational DBMS infocolumn orientedTime Series DBMSDocument store
Graph DBMS
Key-value store
Wide column store
Secondary database modelsDocument 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
Score2.16
Rank#116  Overall
#23  Key-value stores
#56  Relational DBMS
Score8.45
Rank#48  Overall
#6  Key-value stores
Score3.58
Rank#84  Overall
#42  Relational DBMS
Score4.86
Rank#72  Overall
#3  Time Series DBMS
Websitewww.gridgain.comhazelcast.comazure.microsoft.com/­services/­data-explorerprometheus.iosqrrl.com
Technical documentationwww.gridgain.com/­docs/­latesthazelcast.org/­imdg/­docsdocs.microsoft.com/­en-us/­azure/­data-explorerprometheus.io/­docs
DeveloperGridGain Systems, Inc.HazelcastMicrosoftAmazon infooriginally Sqrrl Data, Inc.
Initial release20072008201920152012
Current releaseGridGain 8.5.14.0, February 2020cloud service with continuous releases
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2; commercial licenses availablecommercialOpen Source infoApache 2.0commercial
Cloud-based only infoOnly available as a cloud servicenonoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJava, C++, .NetJavaGoJava
Server operating systemsLinux
OS X
Solaris
Windows
All OS with a Java VMhostedLinux
Windows
Linux
Data schemeyesschema-freeFixed schema with schema-less datatypes (dynamic)yesschema-free
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-typesNumeric data onlyyes
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.yesyes infothe object must implement a serialization strategyyesno infoImport of XML data possible
Secondary indexesyesyesall fields are automatically indexednoyes
SQL infoSupport of SQLANSI-99 for query and DML statements, subset of DDLSQL-like query languageKusto Query Language (KQL), SQL subsetnono
APIs and other access methodsHDFS API
Hibernate
JCache
JDBC
ODBC
Proprietary protocol
RESTful HTTP API
Spring Data
JCache
JPA
Memcached protocol
RESTful HTTP API
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
RESTful HTTP/JSON APIAccumulo Shell
Java API
JDBC
ODBC
RESTful HTTP API
Thrift
Supported programming languagesC#
C++
Java
PHP
Python
Ruby
Scala
.Net
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
Python
Scala
.Net
Java
JavaScript (Node.js)
PowerShell
Python
R
.Net
C++
Go
Haskell
Java
JavaScript (Node.js)
Python
Ruby
Actionscript
C infousing GLib
C#
C++
Cocoa
Delphi
Erlang
Go
Haskell
Java
JavaScript
OCaml
Perl
PHP
Python
Ruby
Smalltalk
Server-side scripts infoStored proceduresyes (compute grid and cache interceptors can be used instead)yes infoEvent Listeners, Executor ServicesYes, possible languages: KQL, Python, Rnono
Triggersyes (cache interceptors and events)yes infoEventsyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicynono
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infoImplicit feature of the cloud serviceShardingSharding infomaking use of Hadoop
Replication methods infoMethods for redundantly storing data on multiple nodesyes (replicated cache)yes infoReplicated Mapyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.yes infoby Federationselectable replication factor infomaking use of Hadoop
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes (compute grid and hadoop accelerator)yesnonoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency selectable by user infoRaft Consensus AlgorithmEventual Consistency
Immediate Consistency
noneImmediate 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 dataACIDone or two-phase-commit; repeatable reads; read commitednonoAtomic updates per row, document, or graph entity
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesnono
User concepts infoAccess controlSecurity Hooks for custom implementationsRole-based access controlAzure Active Directory AuthenticationnoCell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)
More information provided by the system vendor
GridGainHazelcastMicrosoft Azure Data ExplorerPrometheusSqrrl
Specific characteristicsHazelcast 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 advantagesHazelcast 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 scenariosHazelcast 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 customersHazelcast customers include 50 of the world’s largest financial services companies,...
» more
Microsoft, 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 modelsHazelcast 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

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

More resources
GridGainHazelcastMicrosoft Azure Data ExplorerPrometheusSqrrl
Recent citations in the news

GridGain Experts Share In-Memory Computing Strategies, Provide Practical Advice at Worldwide Virtual Events
16 June 2020, GlobeNewswire

In-Memory Data Grid Market 2020 Size, Forecast 2027, Major Players – Hazelcast, Gridgain Systems, Gigaspaces, Hitachi, Pivotal, etc.
7 July 2020, Jewish Life News

GridGain Experts Share In-Memory Computing Strategies, Offer Practical Advice at Virtual Events Around the World
1 April 2020, GlobeNewswire

GridGain Shares Deep In-Memory Computing Expertise at Industry Events Around the World
14 January 2020, GlobeNewswire

GridGain Systems Named to Inaugural The Financial Times The Americas' Fastest Growing Companies 2020 List
9 April 2020, GlobeNewswire

provided by Google News

Global In-Memory Data Grid Market 2020 Top Key Players | Oracle, IBM, Hazelcast, Scale Out Software, Tibco Software
2 July 2020, Bandera County Courier

In-Memory Data Grid Market 2020 Business Scenario – Scale Out Software, IBM, Hitachi, Gigaspaces, Oracle, Pivotal, Gridgain Systems, Hazelcast
3 July 2020, 3rd Watch News

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

Latest News 2020: In-Memory Data Grid Market by Coronavirus-COVID19 Impact Analysis With Top Manufacturers Analysis | Top Players: Oracle, IBM, Hazelcast, Scale Out Software, Tibco Software, etc. | InForGrowth
16 June 2020, Jewish Life News

Hazelcast Simplifies High-Performance Stream Processing for Edge Computing Environments
13 May 2020, PRNewswire

provided by Google News

Azure Updates: Covid-19; Teams; SAP; VMs; IoT Hub
23 June 2020, MSDynamicsWorld.com

IS Engineering Lead
22 June 2020, OilVoice

Zoomd Takes Another Step Towards Becoming an Industry Leader After Adopting Microsoft's Azure Data Explorer
4 December 2019, PRNewswire

Fastly, Microsoft partner on real-time analytics with Azure Data Explorer
29 January 2019, ZDNet

How to use Azure Data Explorer for large-scale data analysis
12 February 2019, InfoWorld

provided by Google News

Monitoring system Prometheus 2.19 gives storage layer a polish
11 June 2020, DevClass

Time Series Databases Software Market Precise Outlook 2020-2026: InfluxData, Trendalyze, Amazon Timestream, DataStax, Prometheus
11 June 2020, 3rd Watch News

Grafana 7 Adds New Visualizations
8 June 2020, iProgrammer

Time Series Databases Software Market Next Big Thing | Major Giants- InfluxData, Trendalyze, Amazon Timestream
4 July 2020, Owned

Two in Five Fortune 500 Companies Choose Alibaba Cloud
2 July 2020, GuruFocus.com

provided by Google News

Stock brokerage startup Fyers expands with direct mutual fund platform
16 June 2020, Livemint

Microsoft, Amazon Push Into Cybersecurity As Cloud Computing Grows
11 June 2020, Investor's Business Daily

User And Entity Behavior Analytics (UEBA) Market Size, Global Industry Share, Growth Opportunities and Forecast to 2026
4 July 2020, Jewish Life News

[Tech30] These industry veterans’ startup encourages millennials to save and invest money smartly
28 October 2019, YourStory

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

provided by Google News

Job opportunities

Sales Engineer
GridGain, Foster City, CA

Site Reliability Engineering (SRE) Deployment Engineer
RingCentral, Inc., Denver, CO

Senior Consultant - Remote (U.S. and Canada)
GridGain, Foster City, CA

Contracts Manager
GridGain, Foster City, CA

SRE Lab Infrastructure Engineer
RingCentral, Denver, CO

Java Developers
Nithya Information Systems, Ann Arbor, MI

Assistant Vice President
Deutsche Bank, New York, NY

Associate, Engineer
Deutsche Bank, Cary, NC

Java Developer
NSW Nokia Software, Austin, TX

LEAD, APPLICATION DEVELOPMENT
S&P DOW JONES INDICES, New York, NY

Senior Data Engineer - Turn 10 Studios
Microsoft, Redmond, WA

Program Manager 2
Microsoft, Redmond, WA

Service Engineer II
Microsoft, Redmond, WA

Site Reliability Engineer
Microsoft, Redmond, WA

Software Engineer - CTJ
Microsoft, Elkridge, MD

System Architect
Cisco Systems, Iselin, NJ

Network Development Engineer
Vultr Holdings, LLC., West Palm Beach, FL

Software Engineer
Leidos, Annapolis Junction, MD

DevOps Inventory Engineer Analyst
Medical Science & Computing, Bethesda, MD

NETWORK AUTOMATION ENGINEER
VeriSign, Reston, VA

Cybersecurity Threat Hunter
Arete Advisors, New York, NY

Network Security Engineer
Cambium Learning Group, Washington, DC

Cyber Defense Analyst
Attain, LLC, Washington, DC

Sr. Cyber Security Analyst
XOR Security, Arlington County, VA

Cyber Hunt SME
XOR Security, Arlington County, VA

jobs by Indeed




Share this page

Featured Products

Arangodb logo

One open-source engine for graph, document & search. Simplify your deployment
stack on Prem, in the cloud - Anywhere.

Couchbase logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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

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

Present your product here