DB-EnginesExtremeDB: the embedded DBMS for embedded systemsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon DynamoDB vs. Google Cloud Firestore vs. Microsoft Azure Data Explorer vs. OrigoDB

System Properties Comparison Amazon DynamoDB vs. Google Cloud Firestore vs. Microsoft Azure Data Explorer vs. OrigoDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon DynamoDB  Xexclude from comparisonGoogle Cloud Firestore  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonOrigoDB  Xexclude from comparison
DescriptionHosted, scalable database service by Amazon with the data stored in Amazons cloudCloud 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 platformA fully ACID in-memory object graph database
Primary database modelDocument store
Key-value store
Document storeRelational DBMS infocolumn orientedDocument 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)
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
Score70.73
Rank#16  Overall
#2  Document stores
#2  Key-value stores
Score6.70
Rank#57  Overall
#9  Document stores
Score4.36
Rank#78  Overall
#43  Relational DBMS
Score0.00
Rank#346  Overall
#50  Document stores
#21  Object oriented DBMS
Websiteaws.amazon.com/­dynamodbfirebase.google.com/­products/­firestoreazure.microsoft.com/­services/­data-explorerorigodb.com
Technical documentationdocs.aws.amazon.com/­dynamodbfirebase.google.com/­docs/­firestoredocs.microsoft.com/­en-us/­azure/­data-explorerorigodb.com/­docs
DeveloperAmazonGoogleMicrosoftRobert Friberg et al
Initial release2012201720192009 infounder the name LiveDB
Current releasecloud service with continuous releases
License infoCommercial or Open Sourcecommercial infofree tier for a limited amount of database operationscommercialcommercialOpen Source
Cloud-based only infoOnly available as a cloud serviceyesyesyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC#
Server operating systemshostedhostedhostedLinux
Windows
Data schemeschema-freeschema-freeFixed schema with schema-less datatypes (dynamic)yes
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-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.noyesno infocan be achieved using .NET
Secondary indexesyesyesall fields are automatically indexedyes
SQL infoSupport of SQLnonoKusto Query Language (KQL), SQL subsetno
APIs and other access methodsRESTful HTTP APIAndroid
gRPC (using protocol buffers) API
iOS
JavaScript API
RESTful HTTP API
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
.NET Client API
HTTP API
LINQ
Supported programming languages.Net
ColdFusion
Erlang
Groovy
Java
JavaScript
Perl
PHP
Python
Ruby
Go
Java
JavaScript
JavaScript (Node.js)
Objective-C
Python
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
.Net
Server-side scripts infoStored proceduresnoyes, Firebase Rules & Cloud FunctionsYes, possible languages: KQL, Python, Ryes
Triggersyes infoby integration with AWS Lambdayes, with Cloud Functionsyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyyes infoDomain Events
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infoImplicit feature of the cloud servicehorizontal partitioning infoclient side managed; servers are not synchronized
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replicationyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsno infomay be implemented via Amazon Elastic MapReduce (Amazon EMR)Using Cloud Dataflownono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyEventual Consistency
Immediate Consistency
Foreign keys infoReferential integritynononodepending on model
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infoACID across one or more tables within a single AWS account and regionyesnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infoWrite ahead log
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Access 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 AuthenticationRole based authorization
More information provided by the system vendor
Amazon DynamoDBGoogle Cloud FirestoreMicrosoft Azure Data ExplorerOrigoDB
Specific characteristicsAzure Data Explorer is a fast and highly scalable data exploration service for log...
» more
Competitive advantagesKusto Query Language (innovative query language, optimized for high performance data...
» more
Typical application scenariosIoT applications IoT devices generate billions of sensor readings. Normalizing and...
» more
Key customersMicrosoft, DocuSign, Taboola, Bosch, Siemens Healthineers, Bühler, Ecolab, Zoomd
» more
Market metricsAzure Data Explorer is the data service for Azure Monitor, Azure Time Series Insights,...
» 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 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
Amazon DynamoDBGoogle Cloud FirestoreMicrosoft Azure Data ExplorerOrigoDB
DB-Engines blog posts

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

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

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

show all

Recent citations in the news

NoSQL Databases Market is Booming Worldwide with RavenDB,RavenDB, Amazon DynamoDB – The Courier
6 April 2021, The Courier

COVID-19 Impact on NoSQL Database Market Share, Size, Trends and Growth 2021 to 2027| DynamoDB, ObjectLabs Corporation, Skyll, MarkLogic – FLA News
20 April 2021, FLA News

Redis Labs unveils Redis Database 7.0
20 April 2021, ZDNet

Netflix Open Sources ConsoleMe to Manage Permissions and Access on AWS
18 April 2021, InfoQ.com

Game Recorder Software Market | Company Challenges And Essential Success Factors | RavenDB, Amazon DynamoDB, MongoDB, ArangoDB – KSU | The Sentinel Newspaper
17 April 2021, KSU | The Sentinel Newspaper

provided by Google News

Android Malware Introduced by Darknet Forum using Firebase -
15 April 2021, VENTS Magazine

Google Launches Flutter 2.0: Let's Dig Into Its Basics
17 April 2021, hackernoon.com

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 Launches Cloud Firestore, a Serverless NoSQL Database -- ADTmag
31 January 2019, ADT Magazine

provided by Google News

Get Started with Accessing Azure Data Explorer using Apache Spark for Azure Synapse Analytics - Microsoft
8 April 2021, Channel 9

Azure Data Explorer gets new engine, numerous enhancements and Synapse integration
14 October 2020, ZDNet

AMD EPYC Processors Power Microsoft Azure Data Explorer, Offers Users 30 Percent Better Performance
15 October 2020, HPCwire

AMD releases Azure Data Explorer PaaS solution
19 October 2020, IT Brief Australia

Azure Data Explorer is now using AMD EPYC processor-based virtual machines
6 November 2020, Backend News

provided by Google News

SuperSocket: Making Socket Programming in .NET Simpler
8 October 2014, InfoQ.com

provided by Google News

Job opportunities

QA Specialist
Ready, Remote

Junior Software Engineer
Extend, Remote

Jr. Full Stack Engineer
FightCamp, Costa Mesa, CA

Associate Software Engineer
Disney Streaming Services, New York, NY

Python Developer
Incsub, Remote

2021 Summer Intern - I.T. - Freshman/Sophomore
UNITED PARCEL SERVICE, Alpharetta, GA

2021 Summer Intern - I.T. - Junior/Senior
UNITED PARCEL SERVICE, Lutherville-Timonium, MD

SR PROGRAMMER VMS101150
ASAP Solutions, Parsippany, NJ

Software Development Engineer
Pocket RN, Remote

Software Developer
Connecticut RISE Network, New Haven, CT

Data Analyst
Designit, Washington State

Data Engineer Internship
Daimler, Portland, OR

Data Engineer - Minecraft
Microsoft, Redmond, WA

Data & Applied Scientist Manager
Microsoft, Redmond, WA

Data and Applied Scientist 2
Microsoft, Redmond, WA

jobs by Indeed




Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

Present your product here