DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > FaunaDB vs. Google Cloud Bigtable vs. Microsoft Azure SQL Data Warehouse

System Properties Comparison FaunaDB vs. Google Cloud Bigtable vs. Microsoft Azure SQL Data Warehouse

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFaunaDB  Xexclude from comparisonGoogle Cloud Bigtable  Xexclude from comparisonMicrosoft Azure SQL Data Warehouse  Xexclude from comparison
DescriptionStrongly consistent database capable of global horizontal scale with a focus on operational simplicityGoogle's NoSQL Big Data database service. It's the same database that powers many core Google services, including Search, Analytics, Maps, and Gmail.Elastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelDocument store
Graph DBMS
Relational DBMS
Time Series DBMS
Wide column storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.48
Rank#136  Overall
#20  Document stores
#9  Graph DBMS
#67  Relational DBMS
#9  Time Series DBMS
Score3.16
Rank#90  Overall
#7  Wide column stores
Score8.81
Rank#43  Overall
#27  Relational DBMS
Websitefauna.comcloud.google.com/­bigtableazure.microsoft.com/­services/­sql-data-warehouse
Technical documentationdocs.fauna.comcloud.google.com/­bigtable/­docsdocs.microsoft.com/­azure/­sql-data-warehouse
DeveloperFauna, Inc.GoogleMicrosoft
Initial release201420152016
License infoCommercial or Open Sourcecommercialcommercialcommercial
Cloud-based only infoOnly available as a cloud servicenoyesyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageScalaC++
Server operating systemsLinuxhostedhosted
Data schemeschema-freeschema-freeyes
Typing infopredefined data types such as float or datenonoyes
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.nonono
Secondary indexesyesnoyes
SQL infoSupport of SQLnonoyes
APIs and other access methodsRESTful HTTP APIgRPC (using protocol buffers) API
HappyBase (Python library)
HBase compatible API (Java)
ADO.NET
JDBC
ODBC
Supported programming languagesC#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
C#
C++
Go
Java
JavaScript (Node.js)
Python
C#
Java
PHP
Server-side scripts infoStored proceduresuser defined functionsnoTransact SQL
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoconsistent hashingShardingSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMasterlessInternal replication in Colossus, and regional replication between two clusters in different zonesyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate consistency (for a single cluster), Eventual consistency (for two or more replicated clusters)Immediate Consistency
Foreign keys infoReferential integrityyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDAtomic single-row operationsACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlIdentity management, authentication, and access controlAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)yes

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
FaunaDBGoogle Cloud BigtableMicrosoft Azure SQL Data Warehouse
DB-Engines blog posts

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

Azure SQL Data Warehouse, the hub for a trusted and performance optimized cloud data warehouse
1 November 2017,  Arnaud Comet, Microsoft (sponsor) 

show all

Recent citations in the news

FaunaDB Closes $27M Series A, Welcomes New Leadership
1 July 2020, Crunchbase News

Fauna Raises $27 Million to Continue Providing Cutting Edge Solutions for Developers
2 July 2020, Database Trends and Applications

Fauna: $27 Million Funding And New Executive Leadership
6 July 2020, Pulse 2.0

S.F.-based Fauna raises $27 million, onboards former Okta and Snowflake execs
1 July 2020, San Francisco Business Times

Another globally distributed cloud native SQL database on the rise: Yugabyte Raises $30 million in Series B...
9 June 2020, ZDNet

provided by Google News

Google’s Data QnA is an AI service that helps business users get answers to analytical queries
8 July 2020, VentureBeat

Google Cloud Launches Region in Market with 'Great Potential to Grow'
24 June 2020, Channel Futures

Google Cloud and Telefónica partner on cloud region and 5G
11 June 2020, Capacity Media

Google plans Spanish cloud region, Telefónica partnership
12 June 2020, DatacenterDynamics

Google Cloud goes live in Indonesia, launches landmark Jakarta region
24 June 2020, Channel Asia Singapore

provided by Google News

Trifacta Now Available for Direct Purchase and Activation in the Microsoft Azure Marketplace
25 June 2020, MarTech Series

Snowflake files for IPO after months of speculation
9 June 2020, TechTarget

Aginity to Bring the Power of Analytics Management to Microsoft Azure SQL Data Warehouse
6 August 2019, PRNewswire

Azure Synapse Analytics combines data warehouse, lake and pipelines
4 November 2019, ZDNet

A first look at Azure Synapse
10 December 2019, InfoWorld

provided by Google News

Job opportunities

Sr. Content Marketing Manager - Remote
Fauna, Inc., Remote

Vice President of Engineering - US Remote
Fauna, Inc., Remote

Director, Product Marketing - Remote
Fauna, Inc., Remote

Computer Science Tutor/Teacher
Wyzant, Heavener, OK

Scala Engineer, Core Platform (Remote, Boston or San Francisco)
Fauna Inc, San Francisco, CA

Google Cloud PlatformArchitect
Cognizant Technology Solutions, Teaneck, NJ

Jr. Java Developer
Promevo, Burlington, KY

Google Cloud Developer
Sri Technologies, Denver, CO

Google Cloud Data Engineer
Caserta, New York, NY

Data Architect
Quantiphi Inc., Princeton, NJ

Data Warehouse DataStage Developer
DXC, El Paso, TX

Azure Data Modeler
Medline Industries Inc, Northfield, IL

Data and Analytics (D&A) Architect
Centric Consulting, Indianapolis, IN

Azure Data Architect
Perficient, Inc, Irvine, CA

Manager of Data and Analytics
Piper Companies, Durham, NC

jobs by Indeed




Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

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

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Neo4j logo

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here