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

DBMS > ArcadeDB vs. Microsoft Azure Data Explorer vs. SAP HANA vs. Warp 10

System Properties Comparison ArcadeDB vs. Microsoft Azure Data Explorer vs. SAP HANA vs. Warp 10

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameArcadeDB  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonSAP HANA  Xexclude from comparisonWarp 10  Xexclude from comparison
DescriptionFast and scalable multi-model DBMS, originally forked from OrientDB but most of the code has been rewrittenFully managed big data interactive analytics platformIn-memory, column based data store. Available as appliance or cloud serviceTimeSeries DBMS specialized on timestamped geo data based on LevelDB or HBase
Primary database modelDocument store
Graph DBMS
Key-value store
Time Series DBMS infoin next version
Relational DBMS infocolumn orientedRelational DBMSTime Series DBMS
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 SAP Hana, Enterprise Edition
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.10
Rank#358  Overall
#48  Document stores
#38  Graph DBMS
#52  Key-value stores
#35  Time Series DBMS
Score3.80
Rank#81  Overall
#43  Relational DBMS
Score44.27
Rank#23  Overall
#16  Relational DBMS
Score0.14
Rank#344  Overall
#32  Time Series DBMS
Websitearcadedb.comazure.microsoft.com/­services/­data-explorerwww.sap.com/­products/­hana.htmlwww.warp10.io
Technical documentationdocs.arcadedb.comdocs.microsoft.com/­en-us/­azure/­data-explorerhelp.sap.com/­hanawww.warp10.io/­content/­02_Getting_started
DeveloperArcade DataMicrosoftSAPSenX
Initial release2021201920102015
Current releaseSeptember 2021cloud service with continuous releases2.0 SPS07 (April 4, 2023), April 2023
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialcommercialOpen Source infoApache License 2.0
Cloud-based only infoOnly available as a cloud servicenoyesno infoalso available as a cloud based serviceno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJava
Server operating systemsAll OS with a Java VMhostedAppliance or cloud-serviceLinux
OS X
Windows
Data schemeschema-freeFixed schema with schema-less datatypes (dynamic)yesschema-free
Typing infopredefined data types such as float or dateyesyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesyesyes
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.noyesnono
Secondary indexesyesall fields are automatically indexedyesno
SQL infoSupport of SQLSQL-like query language, no joinsKusto Query Language (KQL), SQL subsetyesno
APIs and other access methodsJDBC
MongoDB API
OpenCypher
PostgreSQL wire protocol
Redis API
RESTful HTTP/JSON API
TinkerPop Gremlin
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
JDBC
ODBC
HTTP API
Jupyter
WebSocket
Supported programming languagesJava.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
Server-side scripts infoStored proceduresYes, possible languages: KQL, Python, RSQLScript, Ryes infoWarpScript
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 serviceyesSharding infobased on HBase
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.yesselectable replication factor infobased on HBase
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoSpark connector (open source): github.com/­Azure/­azure-kusto-sparknono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency
Immediate ConsistencyImmediate Consistency infobased on HBase
Foreign keys infoReferential integrityyes inforelationship in graphsnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes
User concepts infoAccess controlAzure Active Directory AuthenticationyesMandatory use of cryptographic tokens, containing fine-grained authorizations

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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
ArcadeDBMicrosoft Azure Data ExplorerSAP HANAWarp 10
Recent citations in the news

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

Azure Data Explorer: Log and telemetry analytics benchmark
16 August 2022, Microsoft

Controlling costs in Azure Data Explorer using down-sampling and aggregation
11 February 2019, Microsoft

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

Individually great, collectively unmatched: Announcing updates to 3 great Azure Data Services
7 February 2019, Microsoft

provided by Google News

AWS and SAP Unlock New Innovation with Generative AI
29 May 2024, SAP News

SAP teams up with Apple to bring SAP's HANA to iOS
30 May 2024, Yahoo Movies UK

SAP GenAI gets boost with AWS cloud and chips
30 May 2024, ERP Today

Automating application-consistent Amazon EBS Snapshots for SAP HANA databases | Amazon Web Services
6 February 2024, AWS Blog

Modernize consolidation in an SAP S/4 HANA environment | CCH Tagetik
9 April 2024, Wolters Kluwer

provided by Google News

Time Series Databases Software Market - A comprehensive study by Key Players | Warp 10, Amazon Timestream ...
6 February 2020, openPR

Time Series Databases Software market latest trends, CAGR, and forecast till 2026 | eSherpa Market Reports
13 April 2020, openPR

Time Series Databases Software Market [2024-2031] | InfluxData, Trendalyze, Amazon Timestream
11 May 2024, Motions Online

Time Series Intelligence Software Market Analysis and Revenue Prediction | Azure Time Series Insights, Trendalyze ...
20 May 2024, Weekly Post Gazette

provided by Google News



Share this page

Featured Products

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