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

DBMS > FatDB vs. Google Cloud Firestore vs. Microsoft Azure Data Explorer vs. Oracle vs. Yaacomo

System Properties Comparison FatDB vs. Google Cloud Firestore vs. Microsoft Azure Data Explorer vs. Oracle vs. Yaacomo

Editorial information provided by DB-Engines
NameFatDB  Xexclude from comparisonGoogle Cloud Firestore  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonOracle  Xexclude from comparisonYaacomo  Xexclude from comparison
FatDB/FatCloud has ceased operations as a company with February 2014. FatDB is discontinued and excluded from the ranking.Yaacomo seems to be discontinued and is removed from the DB-Engines ranking
DescriptionA .NET NoSQL DBMS that can integrate with and extend SQL Server.Cloud Firestore is an auto-scaling document database for storing, syncing, and querying data for mobile and web apps. It offers seamless integration with other Firebase and Google Cloud Platform products.Fully managed big data interactive analytics platformWidely used RDBMSOpenCL based in-memory RDBMS, designed for efficiently utilizing the hardware via parallel computing
Primary database modelDocument store
Key-value store
Document storeRelational DBMS infocolumn orientedRelational DBMSRelational 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 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
Score7.36
Rank#53  Overall
#9  Document stores
Score3.80
Rank#81  Overall
#43  Relational DBMS
Score1244.08
Rank#1  Overall
#1  Relational DBMS
Websitefirebase.google.com/­products/­firestoreazure.microsoft.com/­services/­data-explorerwww.oracle.com/­databaseyaacomo.com
Technical documentationfirebase.google.com/­docs/­firestoredocs.microsoft.com/­en-us/­azure/­data-explorerdocs.oracle.com/­en/­database
DeveloperFatCloudGoogleMicrosoftOracleQ2WEB GmbH
Initial release20122017201919802009
Current releasecloud service with continuous releases23c, September 2023
License infoCommercial or Open Sourcecommercialcommercialcommercialcommercial inforestricted free version is availablecommercial
Cloud-based only infoOnly available as a cloud servicenoyesyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC#C and C++
Server operating systemsWindowshostedhostedAIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Android
Linux
Windows
Data schemeschema-freeschema-freeFixed schema with schema-less datatypes (dynamic)yes infoSchemaless in JSON and XML columnsyes
Typing infopredefined data types such as float or dateyesyesyes 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.noyesyesno
Secondary indexesyesyesall fields are automatically indexedyesyes
SQL infoSupport of SQLno infoVia inetgration in SQL ServernoKusto Query Language (KQL), SQL subsetyes infowith proprietary extensionsyes
APIs and other access methods.NET Client API
LINQ
RESTful HTTP API
RPC
Windows WCF Bindings
Android
gRPC (using protocol buffers) API
iOS
JavaScript API
RESTful HTTP API
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
JDBC
ODBC
Supported programming languagesC#Go
Java
JavaScript
JavaScript (Node.js)
Objective-C
Python
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
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
Server-side scripts infoStored proceduresyes infovia applicationsyes, Firebase Rules & Cloud FunctionsYes, possible languages: KQL, Python, RPL/SQL infoalso stored procedures in Java possible
Triggersyes infovia applicationsyes, with Cloud Functionsyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infoImplicit feature of the cloud serviceSharding, horizontal partitioninghorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorMulti-source replicationyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.Multi-source replication
Source-replica replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesUsing Cloud DataflowSpark connector (open source): github.com/­Azure/­azure-kusto-sparkno infocan be realized in PL/SQLno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Immediate ConsistencyEventual Consistency
Immediate Consistency
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoyesnoACID infoisolation level can be parameterizedACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'yes
User concepts infoAccess controlno infoCan implement custom security layer via applicationsAccess rights for users, groups and roles based on Google Cloud Identity and Access Management. Security Rules for 3rd party authentication using Firebase Auth.Azure Active Directory Authenticationfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard

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 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
FatDBGoogle Cloud FirestoreMicrosoft Azure Data ExplorerOracleYaacomo
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

show all

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

Conferences, events and webinars

Oracle Cloud World
Las Vegas, 9-12 September 2024

Recent citations in the news

Google's AI-First Strategy Brings Vector Support To Cloud Databases
1 March 2024, Forbes

Realtime vs Cloud Firestore: Which Firebase Database to go?
8 March 2024, Appinventiv

Google's Cloud Firestore is now generally available
31 January 2019, ZDNet

Google launches Cloud Firestore, a new document database for app developers
3 October 2017, TechCrunch

Google's Cloud-Native NoSQL Database Cloud Firestore Is Now Generally Available
8 February 2019, InfoQ.com

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

Oracle And Google Partner To Deliver Multicloud Offering To Enterprises
13 June 2024, Forbes

Oracle to colocate database services and network interconnect in Google data centers
12 June 2024, DatacenterDynamics

Blog Theme - Details
14 June 2024, Oracle

Oracle and Google Cloud Announce a Groundbreaking Multicloud Partnership
11 June 2024, PR Newswire

Panasonic Information Systems Selects Oracle Cloud Infrastructure to Drive Modernization of Internal Systems Across ...
13 June 2024, PR Newswire

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

Milvus logo

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

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here