DB-EngineseXtremeDB: embedded, distributed, client/server databaseEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Aurora vs. Google Cloud Bigtable vs. Microsoft SQL Server

System Properties Comparison Amazon Aurora vs. Google Cloud Bigtable vs. Microsoft SQL Server

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon Aurora  Xexclude from comparisonGoogle Cloud Bigtable  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparison
DescriptionMySQL and PostgreSQL compatible cloud service by AmazonGoogle's NoSQL Big Data database service. It's the same database that powers many core Google services, including Search, Analytics, Maps, and Gmail.Microsofts relational DBMS
Primary database modelRelational DBMSWide column storeRelational DBMS
Secondary database modelsDocument storeDocument store
Graph DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score8.64
Rank#45  Overall
#28  Relational DBMS
Score3.16
Rank#90  Overall
#7  Wide column stores
Score1059.72
Rank#3  Overall
#3  Relational DBMS
Websiteaws.amazon.com/­rds/­auroracloud.google.com/­bigtablewww.microsoft.com/­en-us/­sql-server
Technical documentationdocs.aws.amazon.com/­AmazonRDS/­latest/­AuroraUserGuide/­CHAP_Aurora.htmlcloud.google.com/­bigtable/­docsdocs.microsoft.com/­en-ie/­sql/­sql-server/­sql-server-technical-documentation
DeveloperAmazonGoogleMicrosoft
Initial release201520151989
Current releaseSQL Server 2019, November 2019
License infoCommercial or Open Sourcecommercialcommercialcommercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud serviceyesyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++
Server operating systemshostedhostedLinux
Windows
Data schemeyesschema-freeyes
Typing infopredefined data types such as float or dateyesnoyes
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.yesnoyes
Secondary indexesyesnoyes
SQL infoSupport of SQLyesnoyes
APIs and other access methodsADO.NET
JDBC
ODBC
gRPC (using protocol buffers) API
HappyBase (Python library)
HBase compatible API (Java)
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesAda
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
C#
C++
Go
Java
JavaScript (Node.js)
Python
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scripts infoStored proceduresyesnoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Java
Triggersyesnoyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioningShardingtables can be distributed across several files (horizontal partitioning); sharding through federation
Replication methods infoMethods for redundantly storing data on multiple nodesMaster-slave replicationInternal replication in Colossus, and regional replication between two clusters in different zonesyes, but depending on the SQL-Server Edition
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.yesnoyes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)fine 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 partiesGeneral SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Amazon AuroraGoogle Cloud BigtableMicrosoft SQL Server
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

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

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

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

Best practices for exporting and importing data from Amazon Aurora MySQL to Amazon S3
16 June 2020, idk.dev

Building globally distributed MySQL applications using write forwarding in Amazon Aurora Global Database
19 June 2020, idk.dev

Improving application availability with Amazon RDS Proxy
1 July 2020, idk.dev

Amazon RDS Proxy – Now Generally Available
2 July 2020, idk.dev

Introducing the serverless LAMP stack – part 2 relational databases
16 June 2020, idk.dev

provided by Google News

Google Cloud rides the wave but remains a distant third place
13 July 2020, SiliconANGLE

MadHive announces $50M deal with SADA to expand its Google Cloud deployment
9 July 2020, SiliconANGLE

MadHive Selects SADA to Lead $50 Million Google Cloud Initiative
9 July 2020, GlobeNewswire

MadHive Turns To SADA Systems For $50 Million Google Cloud Ramp-Up
9 July 2020, CRN: Technology news for channel partners and solution providers

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

provided by Google News

Tintri delivers database-aware storage – Blocks and Files
14 July 2020, Blocks and Files

Use of External Component or SQL Server with Dialing System May Not Qualify as an ATDS
9 July 2020, Manatt, Phelps & Phillips, LLP

SQL Server Monitoring Tools Market to Witness Robust Expansion Throughout the Forecast Period 2020 – 2025
14 July 2020, 3rd Watch News

SQL Server Transformation Market Projected to Grow Steadily During 2019-2029
15 July 2020, Owned

NoSQL Market Report 2020 Top Companies- (Microsoft SQL Server ,MySQL ,MongoDB ,PostgreSQL ,Oracle Database )
14 July 2020, 3rd Watch News

provided by Google News

Job opportunities

Remote PHP/JavaScript Developer (Intermediate+)
Scopic Software LLC, Rutland, MA

Sr. Software Development Manager - Aurora Storage
Amazon.com Services LLC, Seattle, WA

Software Developer -- Aurora
Amazon.com Services LLC, East Palo Alto, CA

Director, Aurora Storage
Amazon Web Services, Inc., Seattle, WA

WW Principal Specialist - Amazon RDS PostgreSQL
Amazon Web Services, Inc., San Francisco, CA

Google Cloud PlatformArchitect
Cognizant Technology Solutions, Teaneck, NJ

Google Cloud Data Engineer
Caserta, New York, NY

MSP - Data & Analytics (DA)
Daugherty Business Solutions, Bloomington, MN

Backend and Data Engineer – Content Platform
Spotify, New York, NY

NYA - Data & Analytics (DA)
Daugherty Business Solutions, Franklin Lakes, NJ

Sql Server Developer
SDH Systems, Redmond, WA

SQL Server DBA
CGI Group, Inc., Wausau, WI

SQL Server Developer
Systems Plus, Washington, DC

SQL Server Developer
Blackstone & Cullen, Atlanta, GA

SQL Developer
Practice Paradigm, United States

jobs by Indeed




Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

Datastax Astra logo

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

AllegroGraph logo

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

Couchbase logo

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

Present your product here