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 > Microsoft Azure Data Explorer vs. NebulaGraph vs. Oracle vs. Sphinx

System Properties Comparison Microsoft Azure Data Explorer vs. NebulaGraph vs. Oracle vs. Sphinx

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameMicrosoft Azure Data Explorer  Xexclude from comparisonNebulaGraph  Xexclude from comparisonOracle  Xexclude from comparisonSphinx  Xexclude from comparison
DescriptionFully managed big data interactive analytics platformA distributed, linear scalable, high perfomant Graph DBMSWidely used RDBMSOpen source search engine for searching in data from different sources, e.g. relational databases
Primary database modelRelational DBMS infocolumn orientedGraph DBMSRelational DBMSSearch engine
Secondary database modelsDocument 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
Document store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
Spatial DBMS infowith Oracle Spatial and Graph
Vector DBMS infosince Oracle 23
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.16
Rank#69  Overall
#37  Relational DBMS
Score2.12
Rank#125  Overall
#10  Graph DBMS
Score1234.27
Rank#1  Overall
#1  Relational DBMS
Score6.03
Rank#60  Overall
#6  Search engines
Websiteazure.microsoft.com/­services/­data-explorergithub.com/­vesoft-inc/­nebula
www.nebula-graph.io
www.oracle.com/­databasesphinxsearch.com
Technical documentationdocs.microsoft.com/­en-us/­azure/­data-explorerdocs.nebula-graph.iodocs.oracle.com/­en/­databasesphinxsearch.com/­docs
DeveloperMicrosoftVesoft Inc.OracleSphinx Technologies Inc.
Initial release2019201919802001
Current releasecloud service with continuous releases23c, September 20233.5.1, February 2023
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2.0 + Common Clause 1.0commercial inforestricted free version is availableOpen Source infoGPL version 2, commercial licence available
Cloud-based only infoOnly available as a cloud serviceyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C and C++C++
Server operating systemshostedLinuxAIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
FreeBSD
Linux
NetBSD
OS X
Solaris
Windows
Data schemeFixed schema with schema-less datatypes (dynamic)Strong typed schemayes infoSchemaless in JSON and XML columnsyes
Typing infopredefined data types such as float or dateyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesyesyesno
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.yesnoyes
Secondary indexesall fields are automatically indexedyes infoNebula Graph internally uses the Key-Value store RocksDB for persistency. The vertices, edges, and their properties are stored as Key while their values are stored as Value. The primary indexes are per Key and secondary indexes are per Value.yesyes infofull-text index on all search fields
SQL infoSupport of SQLKusto Query Language (KQL), SQL subsetSQL-like query languageyes infowith proprietary extensionsSQL-like query language (SphinxQL)
APIs and other access methodsMicrosoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
Browser interface
console (shell)
Cypher Query Language
GO Object Graph Mapper
Java Object Graph Mapper
NGBatis infoORM framework for NebulaGraph and Spring-Boot
Proprietary native API
Python Object Graph Mapper
Query language nGQL
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Proprietary protocol
Supported programming languages.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
.Net
C++
Go
Java
PHP
Python
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
C++ infounofficial client library
Java
Perl infounofficial client library
PHP
Python
Ruby infounofficial client library
Server-side scripts infoStored proceduresYes, possible languages: KQL, Python, Ruser defined functionsPL/SQL infoalso stored procedures in Java possibleno
Triggersyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceShardingSharding, horizontal partitioningSharding infoPartitioning is done manually, search queries against distributed index is supported
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.Causal Clustering using Raft protocolMulti-source replication
Source-replica replication
none
MapReduce infoOffers an API for user-defined Map/Reduce methodsSpark connector (open source): github.com/­Azure/­azure-kusto-sparknono infocan be realized in PL/SQLno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyes infoRelationships in graphsyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACID infoisolation level can be parameterizedno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyes infousing RocksDByesyes infoThe original contents of fields are not stored in the Sphinx index.
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'
User concepts infoAccess controlAzure Active Directory AuthenticationRole-based access controlfine grained access rights according to SQL-standardno
More information provided by the system vendor
Microsoft Azure Data ExplorerNebulaGraphOracleSphinx
Specific characteristicsNebulaGraph is a truly distributed, linearly scalable, lightning-fast graph database,...
» more
Competitive advantagesNebulaGraph boasts the world's only graph database solution that is able to host...
» more
Typical application scenariosSocial networking Fraud detection Knowledge graph Data warehouse management Anti...
» more
Key customersCompanies from a variety of industries have implemented NebulaGraph Database in production,...
» more
Market metricsAt our very early stage, NebulaGraph has already received over 10,000 stars on GitHub...
» more
Licensing and pricing modelsNebulaGraph is open source and free to use under Apache 2.0 license.
» 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 partiesDevart ODBC driver for Oracle accesses Oracle databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32 and 64-bit Windows, macOS, and Linux.
» more

Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

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

More resources
Microsoft Azure Data ExplorerNebulaGraphOracleSphinx
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

The DB-Engines ranking includes now search engines
4 February 2013, Paul Andlinger

show all

Conferences, events and webinars

Oracle Cloud World
Las Vegas, 9-12 September 2024

Recent citations in the news

Azure Data Explorer: Log and telemetry analytics benchmark
16 August 2022, azure.microsoft.com

Providing modern data transfer and storage service at Microsoft with Microsoft Azure - Inside Track Blog
13 July 2023, Microsoft

General availability: New KQL function to enrich your data analysis with geographic context | Azure updates
6 June 2023, azure.microsoft.com

Public Preview: Azure Cosmos DB to Azure Data Explorer Synapse Link | Azure updates
9 January 2023, azure.microsoft.com

Azure Data Explorer and Stream Analytics for anomaly detection
16 January 2020, azure.microsoft.com

provided by Google News

NebulaGraph Enterprise v5.0: The First Distributed Graph Database to Offer Native GQL Support
18 April 2024, PR Newswire

NebulaGraph Enterprise v3.7.0 Empowers Enterprises to Build Knowledge Graphs with a Few Clicks
3 April 2024, PR Newswire

Celebrating 10,000 GitHub Stars for NebulaGraph
26 March 2024, Yahoo Finance

NebulaGraph reaps from China’s growing appetite for graph databases
16 September 2022, TechCrunch

Beginner’s Guide to NebulaGraph Database | by Ng Wai Foong
26 October 2022, Towards Data Science

provided by Google News

Blog Theme - Details
30 April 2024, blogs.oracle.com

What's New: April 2024
26 April 2024, blogs.oracle.com

Conduent and Voya Financial adopt Oracle Database@Azure for cloud migration
26 April 2024, DatacenterDynamics

Blog Theme - Details
19 April 2024, blogs.oracle.com

Oracle and Microsoft bring Oracle Database@Azure to Europe
14 March 2024, blogs.oracle.com

provided by Google News

Switching From Sphinx to MkDocs Documentation — What Did I Gain and Lose
2 February 2024, Towards Data Science

Manticore is a Faster Alternative to Elasticsearch in C++
25 July 2022, hackernoon.com

Perplexity AI: From Its Use To Operation, Everything You Need To Know About Googles Newest Challenger
11 January 2024, Free Press Journal

How to Build 600+ Links in One Month
4 September 2020, Search Engine Journal

Beyond the Concert Hall: 5 Organizations Making a Difference in Classical Music in 2018 | WQXR Editorial
22 December 2018, WQXR Radio

provided by Google News



Share this page

Featured Products

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

AllegroGraph logo

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

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.

Milvus logo

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

Present your product here