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

DBMS > AgensGraph vs. Elasticsearch vs. Graph Engine vs. Microsoft Azure Data Explorer

System Properties Comparison AgensGraph vs. Elasticsearch vs. Graph Engine vs. Microsoft Azure Data Explorer

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAgensGraph  Xexclude from comparisonElasticsearch  Xexclude from comparisonGraph Engine infoformer name: Trinity  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparison
DescriptionMulti-model database supporting relational and graph data models and built upon PostgreSQLA 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 distributed in-memory data processing engine, underpinned by a strongly-typed RAM store and a general distributed computation engineFully managed big data interactive analytics platform
Primary database modelGraph DBMS
Relational DBMS
Search engineGraph DBMS
Key-value store
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)
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
Score0.07
Rank#330  Overall
#34  Graph DBMS
#148  Relational DBMS
Score151.44
Rank#7  Overall
#1  Search engines
Score0.93
Rank#189  Overall
#16  Graph DBMS
#32  Key-value stores
Score7.34
Rank#60  Overall
#34  Relational DBMS
Websitebitnine.netwww.elastic.co/­elasticsearchwww.graphengine.ioazure.microsoft.com/­services/­data-explorer
Technical documentationbitnine.net/­documentationwww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmlwww.graphengine.io/­docs/­manualdocs.microsoft.com/­en-us/­azure/­data-explorer
DeveloperBitnine Global Inc.ElasticMicrosoftMicrosoft
Initial release2016201020102019
Current release2.1, December 20187.8.0, June 2020cloud service with continuous releases
License infoCommercial or Open SourceOpen Source infoApache License 2.0Open Source infoElastic LicenseOpen Source infoMIT Licensecommercial
Cloud-based only infoOnly available as a cloud servicenononoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCJava.NET and C
Server operating systemsLinux
OS X
Windows
All OS with a Java VM.NEThosted
Data schemedepending on used data modelschema-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 dateyesyesyesyes 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.nononoyes
Secondary indexesyesyes infoAll search fields are automatically indexedall fields are automatically indexed
SQL infoSupport of SQLyesSQL-like query languagenoKusto Query Language (KQL), SQL subset
APIs and other access methodsCypher Query Language
JDBC
Java API
RESTful HTTP/JSON API
RESTful HTTP APIMicrosoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
Supported programming languagesC
Java
JavaScript
Python
.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby
C#
C++
F#
Visual Basic
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
Server-side scripts infoStored proceduresyesyesyesYes, possible languages: KQL, Python, R
Triggersnoyes infoby using the 'percolation' featurenoyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicy
Partitioning methods infoMethods for storing different data on different nodesno, but can be realized using table inheritanceShardinghorizontal partitioningSharding infoImplicit feature of the cloud service
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyesyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoES-Hadoop ConnectorSpark connector (open source): github.com/­Azure/­azure-kusto-spark
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual 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 integrityyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonono
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesoptional: either by committing a write-ahead log (WAL) to the local persistent storage or by dumping the memory to a persistent storageyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noMemcached and Redis integrationyesno
User concepts infoAccess controlfine grained access rights according to SQL-standardAzure Active Directory Authentication
More information provided by the system vendor
AgensGraphElasticsearchGraph Engine infoformer name: TrinityMicrosoft 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
AgensGraphElasticsearchGraph Engine infoformer name: TrinityMicrosoft 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

AGE - The Open Source PostgreSQL Extension For Graph Database Functionality
27 June 2022, iProgrammer

Graph DBMS Performance Comparison AgensGraph vs. Neo4j
29 June 2017, businesswire.com

Bitnine Announces Plans for New Business with Apache AGE's Top-Level Promotion
14 June 2022, businesswire.com

Bitnine Promoting a First IPO in the Graph Database Industry This Year
2 March 2021, businesswire.com

provided by Google News

Kyndryl and Elastic expand partnership to help users enhance data-driven digital transformation initiatives
24 September 2022, Help Net Security

floragunn GmbH, Amazon, and Elastic Issue Joint Statement Regarding Settlement of Search Guard Litigation
8 September 2022, Business Wire

Elastic to Host Financial Analyst Day on September 19, 2022
6 September 2022, Business Wire

Elastic Announces New Capabilities to Help Customers Solve Their Biggest Business Challenges
3 May 2022, Business Wire

Elastic to Present in Upcoming Investor Conferences
29 August 2022, Business Wire

provided by Google News

How Google and Microsoft taught search to “understand” the Web
6 June 2012, Ars Technica

Cutting-edge Katana Graph scores $28.5 million Series A Led by Intel Capital
24 February 2021, ZDNet

provided by Google News

Azure Data Explorer Supports Native Ingestion from Amazon S3
7 September 2022, InfoQ.com

Product News: Cirrus Link's IoT Bridge to connect OT data to Microsoft Azure
20 September 2022, Smart Industry

📉 Kaggle Datasets in Colab, Azure AI 🤖, Time Series Analysis & PowerBI 📊 Certification Bundle.
23 September 2022, Packt Hub

Microsoft Azure Managed Grafana Tool Improves Data Visualizations
1 September 2022, Petri.com

Azure Managed Grafana Now Generally Available
8 September 2022, InfoQ.com

provided by Google News

Job opportunities

Full stack Developer
Extend Your Team, Remote

Node.JS Developer (100% Remote)
Piper Companies, Remote

2023 Software Engineering Recent Grad Positions – Cat Digital
Caterpillar, Westminster, CO

Front End Developer - US [Remote]
Braintrust, San Francisco, CA

Research Scientist - NLP
Kensho, Remote

Embedded Escalation Engineer - Azure Data Explorer
Microsoft, United States

Principal Applied Data Scientist
Microsoft, Mountain View, CA

Data Engineer/Senior Data Engineer, IT Analytics
American Airlines, Dallas, TX

Software Engineer II (Azure Data Factory)
Microsoft, Redmond, WA

Azure Data Engineer
DHL eCommerce, Remote

jobs by Indeed



Share this page

Featured Products

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

Redis logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Present your product here