DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Elasticsearch vs. GridGain vs. Microsoft Azure Data Explorer vs. Sqrrl vs. Tarantool

System Properties Comparison Elasticsearch vs. GridGain vs. Microsoft Azure Data Explorer vs. Sqrrl vs. Tarantool

Editorial information provided by DB-Engines
NameElasticsearch  Xexclude from comparisonGridGain  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonSqrrl  Xexclude from comparisonTarantool  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 metricGridGain is an in-memory computing platform, built on Apache IgniteFully managed big data interactive analytics platformAdaptable, secure NoSQL built on Apache AccumuloIn-memory computing platform with a flexible data schema for efficiently building high-performance applications
Primary database modelSearch engineKey-value store
Relational DBMS
Relational DBMS infocolumn orientedDocument store
Graph DBMS
Key-value store
Wide column store
Document store
Key-value store
Relational DBMS
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
Spatial DBMS infowith Tarantool/GIS extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score132.83
Rank#7  Overall
#1  Search engines
Score1.55
Rank#150  Overall
#26  Key-value stores
#70  Relational DBMS
Score3.80
Rank#81  Overall
#43  Relational DBMS
Score1.67
Rank#143  Overall
#25  Document stores
#25  Key-value stores
#65  Relational DBMS
Websitewww.elastic.co/­elasticsearchwww.gridgain.comazure.microsoft.com/­services/­data-explorersqrrl.comwww.tarantool.io
Technical documentationwww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmlwww.gridgain.com/­docs/­index.htmldocs.microsoft.com/­en-us/­azure/­data-explorerwww.tarantool.io/­en/­doc
DeveloperElasticGridGain Systems, Inc.MicrosoftAmazon infooriginally Sqrrl Data, Inc.VK
Initial release20102007201920122008
Current release8.6, January 2023GridGain 8.5.1cloud service with continuous releases2.10.0, May 2022
License infoCommercial or Open SourceOpen Source infoElastic LicensecommercialcommercialcommercialOpen Source infoBSD-2, source-available extensions (modules), commercial licenses for Tarantool Enterprise
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 languageJavaJava, C++, .NetJavaC and C++
Server operating systemsAll OS with a Java VMLinux
OS X
Solaris
Windows
hostedLinuxBSD
Linux
macOS
Data schemeschema-free infoFlexible type definitions. Once a type is defined, it is persistentyesFixed schema with schema-less datatypes (dynamic)schema-freeFlexible data schema: relational definition for tables with ability to store json-like documents in columns
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-typesyesstring, double, decimal, uuid, integer, blob, boolean, datetime
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.noyesyesno
Secondary indexesyes infoAll search fields are automatically indexedyesall fields are automatically indexedyesyes
SQL infoSupport of SQLSQL-like query languageANSI-99 for query and DML statements, subset of DDLKusto Query Language (KQL), SQL subsetnoFull-featured ANSI SQL support
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
Accumulo Shell
Java API
JDBC
ODBC
RESTful HTTP API
Thrift
Open binary protocol
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
Actionscript
C infousing GLib
C#
C++
Cocoa
Delphi
Erlang
Go
Haskell
Java
JavaScript
OCaml
Perl
PHP
Python
Ruby
Smalltalk
C
C#
C++
Erlang
Go
Java
JavaScript
Lua
Perl
PHP
Python
Rust
Server-side scripts infoStored proceduresyesyes (compute grid and cache interceptors can be used instead)Yes, possible languages: KQL, Python, RnoLua, C and SQL stored procedures
Triggersyes infoby using the 'percolation' featureyes (cache interceptors and events)yes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicynoyes, before/after data modification events, on replication events, client session events
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infoImplicit feature of the cloud serviceSharding infomaking use of HadoopSharding, partitioned with virtual buckets by user defined affinity key. Live resharding for scale up and scale down without maintenance downtime.
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.selectable replication factor infomaking use of HadoopAsynchronous replication with multi-master option
Configurable replication topology (full-mesh, chain, star)
Synchronous quorum replication (with Raft)
MapReduce infoOffers an API for user-defined Map/Reduce methodsES-Hadoop Connectoryes (compute grid and hadoop accelerator)Spark connector (open source): github.com/­Azure/­azure-kusto-sparkyes
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
Immediate Consistency infoDocument store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.Casual consistency across sharding partitions
Eventual consistency within replicaset partition infowhen using asyncronous replication
Immediate Consistency within single instance
Sequential consistency including linearizable read within replicaset partition infowhen using Raft
Foreign keys infoReferential integritynonononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDnoAtomic updates per row, document, or graph entityACID, with serializable isolation and linearizable read (within partition); Configurable MVCC (within partition); No cross-shard distributed transactions
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes, cooperative multitasking
Durability infoSupport for making data persistentyesyesyesyesyes, write ahead logging
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.Memcached and Redis integrationyesnoyes, full featured in-memory storage engine with persistence
User concepts infoAccess controlSecurity Hooks for custom implementationsAzure Active Directory AuthenticationCell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)Access Control Lists
Mutual TLS authentication for Tarantol Enterprise
Password based authentication
Role-based access control (RBAC) and LDAP for Tarantol Enterprise
Users and Roles

More information provided by the system vendor

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
ElasticsearchGridGainMicrosoft Azure Data ExplorerSqrrlTarantool
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

Data processing speed and reliability: in-memory synchronous replication
9 November 2021,  Vladimir Perepelytsya, Tarantool (sponsor) 

show all

Recent citations in the news

8 Powerful Alternatives to Elasticsearch
25 April 2024, Yahoo Finance

Splunk vs Elasticsearch | A Comparison and How to Choose
12 January 2024, SentinelOne

Netflix Uses Elasticsearch Percolate Queries to Implement Reverse Searches Efficiently
29 April 2024, InfoQ.com

Introducing Elasticsearch Vector Database to Azure OpenAI Service On Your Data (Preview)
26 March 2024, GovTech

Elasticsearch Open Inference API Supports Cohere Rerank 3
11 April 2024, Business Wire

provided by Google News

GridGain in-memory data and generative AI – Blocks and Files
10 May 2024, Blocks and Files

GridGain's 2023 Growth Positions Company for Strong 2024
24 January 2024, PR Newswire

GridGain Unified Real-Time Data Platform Version 8.9 Addresses Today's More Complex Real-Time Data Processing ...
12 October 2023, GlobeNewswire

GridGain Showcases Power of Apache Ignite at Community Over Code Conference
5 October 2023, Datanami

GridGain Announces Call for Speakers for Virtual Apache Ignite Summit 2024
8 February 2024, PR Newswire

provided by Google News

We’re retiring Azure Time Series Insights on 7 July 2024 – transition to Azure Data Explorer | Azure updates
31 May 2024, Microsoft

Update records in a Kusto Database (public preview) | Azure updates
20 February 2024, Microsoft

Public Preview: Azure Data Explorer connector for Apache Flink | Azure updates
8 January 2024, Microsoft

Announcing General Availability to migrate Virtual Network injected Azure Data Explorer Cluster to Private Endpoints ...
5 February 2024, Microsoft

New Features for graph-match KQL Operator: Enhanced Pattern Matching and Cycle Control | Azure updates
24 January 2024, Microsoft

provided by Google News

Splunk details Sqrrl 'screw-ups' that hampered threat hunting
6 May 2024, TechTarget

Amazon's cloud business acquires Sqrrl, a security start-up with NSA roots
23 January 2018, CNBC

Millennials possess the advantage of time for wealth creation, says Yashoraj Tyagi of Sqrrl | Mint
18 September 2023, Mint

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

Amazon acquires cybersecurity startup Sqrrl
8 June 2023, cisomag.com

provided by Google News

Tarantool Announces New Enterprise Version With Enhanced Scaling and Monitoring Capabilities
18 May 2018, Newswire

Deploying Tarantool Cartridge applications with zero effort (Part 1)
16 December 2019, Хабр

VShard — horizontal scaling in Tarantool
7 March 2019, Хабр

Accelerating PHP connectors for Tarantool using Async, Swoole, and Parallel
18 December 2019, Хабр

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

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.

Present your product here