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

DBMS > Ehcache vs. FoundationDB vs. Microsoft Azure Data Explorer vs. OpenQM vs. OrigoDB

System Properties Comparison Ehcache vs. FoundationDB vs. Microsoft Azure Data Explorer vs. OpenQM vs. OrigoDB

Editorial information provided by DB-Engines
NameEhcache  Xexclude from comparisonFoundationDB  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonOpenQM infoalso called QM  Xexclude from comparisonOrigoDB  Xexclude from comparison
Created as commercial project in 2013, FoundationDB has been acquired by Apple in March 2015 and was withdrawn from the market. As a consequence, the product was removed from the DB-Engines ranking. In April 2018, Apple open-sourced FoundationDB and it therefore reappears in the ranking.
DescriptionA widely adopted Java cache with tiered storage optionsOrdered key-value store. Core features are complimented by layers.Fully managed big data interactive analytics platformQpenQM is a high-performance, self-tuning, multi-value DBMSA fully ACID in-memory object graph database
Primary database modelKey-value storeDocument store infosupported via specific layer
Key-value store
Relational DBMS infosupported via specific SQL-layer
Relational DBMS infocolumn orientedMultivalue DBMSDocument store
Object oriented 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
Score4.64
Rank#68  Overall
#8  Key-value stores
Score1.06
Rank#185  Overall
#31  Document stores
#28  Key-value stores
#85  Relational DBMS
Score3.80
Rank#81  Overall
#43  Relational DBMS
Score0.34
Rank#284  Overall
#10  Multivalue DBMS
Score0.06
Rank#380  Overall
#50  Document stores
#18  Object oriented DBMS
Websitewww.ehcache.orggithub.com/­apple/­foundationdbazure.microsoft.com/­services/­data-explorerwww.rocketsoftware.com/­products/­rocket-multivalue-application-development-platform/­rocket-open-qmorigodb.com
Technical documentationwww.ehcache.org/­documentationapple.github.io/­foundationdbdocs.microsoft.com/­en-us/­azure/­data-explorerorigodb.com/­docs
DeveloperTerracotta Inc, owned by Software AGFoundationDBMicrosoftRocket Software, originally Martin PhillipsRobert Friberg et al
Initial release20092013201919932009 infounder the name LiveDB
Current release3.10.0, March 20226.2.28, November 2020cloud service with continuous releases3.4-12
License infoCommercial or Open SourceOpen Source infoApache Version 2; commercial licenses availableOpen Source infoApache 2.0commercialOpen Source infoGPLv2, extended commercial license availableOpen Source
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 languageJavaC++C#
Server operating systemsAll OS with a Java VMLinux
OS X
Windows
hostedAIX
FreeBSD
Linux
macOS
Raspberry Pi
Solaris
Windows
Linux
Windows
Data schemeschema-freeschema-free infosome layers support schemasFixed schema with schema-less datatypes (dynamic)yes infowith some exceptionsyes
Typing infopredefined data types such as float or dateyesno infosome layers support typingyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesUser defined using .NET types and collections
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 infocan be achieved using .NET
Secondary indexesnonoall fields are automatically indexedyesyes
SQL infoSupport of SQLnosupported in specific SQL layer onlyKusto Query Language (KQL), SQL subsetnono
APIs and other access methodsJCacheMicrosoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
.NET Client API
HTTP API
LINQ
Supported programming languagesJava.Net
C
C++
Go
Java
JavaScript infoNode.js
PHP
Python
Ruby
Swift
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
.Net
Basic
C
Java
Objective C
PHP
Python
.Net
Server-side scripts infoStored proceduresnoin SQL-layer onlyYes, possible languages: KQL, Python, Ryesyes
Triggersyes infoCache Event Listenersnoyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyyesyes infoDomain Events
Partitioning methods infoMethods for storing different data on different nodesSharding infoby using Terracotta ServerShardingSharding infoImplicit feature of the cloud serviceyeshorizontal partitioning infoclient side managed; servers are not synchronized
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoby using Terracotta Serveryesyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.yesSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoSpark connector (open source): github.com/­Azure/­azure-kusto-sparknono
Consistency concepts infoMethods to ensure consistency in a distributed systemTunable Consistency (Strong, Eventual, Weak)Linearizable consistencyEventual Consistency
Immediate Consistency
Immediate Consistency
Foreign keys infoReferential integritynoin SQL-layer onlynonodepending on model
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infosupports JTA and can work as an XA resourceACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyes infousing a tiered cache-storage approachyesyesyesyes infoWrite ahead log
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes
User concepts infoAccess controlnonoAzure Active Directory AuthenticationAccess rights can be defined down to the item levelRole based authorization

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
EhcacheFoundationDBMicrosoft Azure Data ExplorerOpenQM infoalso called QMOrigoDB
Recent citations in the news

Scaling Australia's Most Popular Online News Sites with Ehcache
6 December 2010, InfoQ.com

Atlassian asks customers to patch critical Jira vulnerability
22 July 2021, BleepingComputer

Critical Jira Flaw in Atlassian Could Lead to RCE
22 July 2021, Threatpost

DZone Coding Java JBoss 5 to 7 in 11 steps
9 January 2014, dzone.com

provided by Google News

FoundationDB team's new venture, Antithesis, raises $47M to enhance software testing
13 February 2024, SiliconANGLE News

Stonebraker Seeks to Invert the Computing Paradigm with DBOS
12 March 2024, Datanami

Antithesis raises $47M to launch an automated testing platform for software
13 February 2024, TechCrunch

FoundationDB, a very interesting NoSQL database owned by Apple, is now an open-source project
19 April 2018, GeekWire

Apple Open Sources FoundationDB
19 April 2018, MacRumors

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



Share this page

Featured Products

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

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

Present your product here