DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Microsoft Azure Data Explorer vs. Oracle NoSQL vs. Sadas Engine vs. TempoIQ

System Properties Comparison Microsoft Azure Data Explorer vs. Oracle NoSQL vs. Sadas Engine vs. TempoIQ

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameMicrosoft Azure Data Explorer  Xexclude from comparisonOracle NoSQL  Xexclude from comparisonSadas Engine  Xexclude from comparisonTempoIQ infoformerly TempoDB  Xexclude from comparison
TempoIQ seems to be decommissioned. It will be removed from the DB-Engines ranking.
DescriptionFully managed big data interactive analytics platformA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodesSADAS Engine is a columnar DBMS specifically designed for high performance in data warehouse environmentsScalable analytics DBMS for sensor data, provided as a service (SaaS)
Primary database modelRelational DBMS infocolumn orientedDocument store
Key-value store
Relational DBMS
Relational 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
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.82
Rank#65  Overall
#37  Relational DBMS
Score3.26
Rank#101  Overall
#18  Document stores
#17  Key-value stores
#52  Relational DBMS
Score0.06
Rank#371  Overall
#155  Relational DBMS
Websiteazure.microsoft.com/­services/­data-explorerwww.oracle.com/­database/­nosql/­technologies/­nosqlwww.sadasengine.comtempoiq.com (offline)
Technical documentationdocs.microsoft.com/­en-us/­azure/­data-explorerdocs.oracle.com/­en/­database/­other-databases/­nosql-database/­index.htmlwww.sadasengine.com/­en/­sadas-engine-download-free-trial-and-documentation/­#documentation
DeveloperMicrosoftOracleSADAS s.r.l.TempoIQ
Initial release2019201120062012
Current releasecloud service with continuous releases23.3, December 20238.0
License infoCommercial or Open SourcecommercialOpen Source infoProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)commercial infofree trial version availablecommercial
Cloud-based only infoOnly available as a cloud serviceyesnonoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++
Server operating systemshostedLinux
Solaris SPARC/x86
AIX
Linux
Windows
Data schemeFixed schema with schema-less datatypes (dynamic)Support Fixed schema and Schema-less deployment with the ability to interoperate between them.yesschema-free
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-typesoptionalyesyes
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.yesnonono
Secondary indexesall fields are automatically indexedyesyes
SQL infoSupport of SQLKusto Query Language (KQL), SQL subsetSQL-like DML and DDL statementsyesno
APIs and other access methodsMicrosoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
RESTful HTTP APIJDBC
ODBC
Proprietary protocol
HTTP API
Supported programming languages.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
C
C#
Go
Java
JavaScript (Node.js)
Python
.Net
C
C#
C++
Groovy
Java
PHP
Python
C#
Java
JavaScript infoNode.js
Python
Ruby
Server-side scripts infoStored proceduresYes, possible languages: KQL, Python, Rnonono
Triggersyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicynonoyes infoRealtime Alerts
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceShardinghorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.Electable source-replica replication per shard. Support distributed global deployment with Multi-region table featurenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsSpark connector (open source): github.com/­Azure/­azure-kusto-sparkwith Hadoop integrationnono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Eventual Consistency
Immediate Consistency infodepending on configuration
Immediate Consistency
Foreign keys infoReferential integritynonoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoconfigurable infoACID within a storage node (=shard)no
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.noyes infooff heap cacheyes infomanaged by 'Learn by Usage'no
User concepts infoAccess controlAzure Active Directory AuthenticationAccess rights for users and rolesAccess rights for users, groups and roles according to SQL-standardsimple authentication-based access control

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
Microsoft Azure Data ExplorerOracle NoSQLSadas EngineTempoIQ infoformerly TempoDB
Recent citations in the news

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

Microsoft Introduces Azure Integration Environments and Business Process Tracking in Public Preview
23 November 2023, InfoQ.com

What is Microsoft Fabric? A big tech stack for big data
9 February 2024, InfoWorld

Why the Azure community should start planning for Microsoft Fabric today
20 June 2023, MSDynamicsWorld

Data Explorer processes unlabeled visual data, boosting creation of production-ready AI models
19 April 2023, VentureBeat

provided by Google News

Oracle Cloud Infrastructure Attains Expanded FedRAMP Authorization
7 February 2024, Yahoo Finance

Blog Theme - Details
21 August 2023, Oracle

Blog Theme - Details
4 April 2023, Oracle

Oracle NoSQL database comes to the cloud
2 April 2020, TechTarget

Rubrik adds Oracle, NoSQL and SAP Hana data protection
14 November 2018, ComputerWeekly.com

provided by Google News

Top Data Visualization Software in Canada in 2024
3 October 2023, Slashdot

provided by Google News



Share this page

Featured Products

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.

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.

Milvus logo

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

Present your product here