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

DBMS > Amazon Aurora vs. Cassandra vs. Microsoft SQL Server vs. Oracle Berkeley DB vs. YugabyteDB

System Properties Comparison Amazon Aurora vs. Cassandra vs. Microsoft SQL Server vs. Oracle Berkeley DB vs. YugabyteDB

Editorial information provided by DB-Engines
NameAmazon Aurora  Xexclude from comparisonCassandra  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonOracle Berkeley DB  Xexclude from comparisonYugabyteDB  Xexclude from comparison
DescriptionMySQL and PostgreSQL compatible cloud service by AmazonWide-column store based on ideas of BigTable and DynamoDB infoOptimized for write accessMicrosofts flagship relational DBMSWidely used in-process key-value storeHigh-performance distributed SQL database for global, internet-scale applications. Wire and feature compatible with PostgreSQL.
Primary database modelRelational DBMSWide column storeRelational DBMSKey-value store infosupports sorted and unsorted key sets
Native XML DBMS infoin the Oracle Berkeley DB XML version
Relational DBMS
Secondary database modelsDocument storeVector DBMS infostarting with release V5Document store
Graph DBMS
Spatial DBMS
Document store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score7.91
Rank#50  Overall
#32  Relational DBMS
Score101.89
Rank#12  Overall
#1  Wide column stores
Score824.29
Rank#3  Overall
#3  Relational DBMS
Score2.21
Rank#117  Overall
#20  Key-value stores
#3  Native XML DBMS
Score2.91
Rank#102  Overall
#51  Relational DBMS
Websiteaws.amazon.com/­rds/­auroracassandra.apache.orgwww.microsoft.com/­en-us/­sql-serverwww.oracle.com/­database/­technologies/­related/­berkeleydb.htmlwww.yugabyte.com
Technical documentationdocs.aws.amazon.com/­AmazonRDS/­latest/­AuroraUserGuide/­CHAP_Aurora.htmlcassandra.apache.org/­doc/­latestlearn.microsoft.com/­en-US/­sql/­sql-serverdocs.oracle.com/­cd/­E17076_05/­html/­index.htmldocs.yugabyte.com
github.com/­yugabyte/­yugabyte-db
DeveloperAmazonApache Software Foundation infoApache top level project, originally developped by FacebookMicrosoftOracle infooriginally developed by Sleepycat, which was acquired by OracleYugabyte Inc.
Initial release20152008198919942017
Current release4.1.3, July 2023SQL Server 2022, November 202218.1.40, May 20202.19, September 2023
License infoCommercial or Open SourcecommercialOpen Source infoApache version 2commercial inforestricted free version is availableOpen Source infocommercial license availableOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Astra DB: Multi-cloud DBaaS built on Apache Cassandra.YugabyteDB Managed is the fully managed database-as-a-service offering of YugabyteDB. Get started quickly, and effortlessly ensure continuous availability and limitless scale of your cloud native applications.
Implementation languageJavaC++C, Java, C++ (depending on the Berkeley DB edition)C and C++
Server operating systemshostedBSD
Linux
OS X
Windows
Linux
Windows
AIX
Android
FreeBSD
iOS
Linux
OS X
Solaris
VxWorks
Windows
Linux
OS X
Data schemeyesschema-freeyesschema-freedepending on used data model
Typing infopredefined data types such as float or dateyesyesyesnoyes
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.yesnoyesyes infoonly with the Berkeley DB XML editionno
Secondary indexesyesrestricted infoonly equality queries, not always the best performing solutionyesyesyes
SQL infoSupport of SQLyesSQL-like SELECT, DML and DDL statements (CQL)yesyes infoSQL interfaced based on SQLite is availableyes, PostgreSQL compatible
APIs and other access methodsADO.NET
JDBC
ODBC
Proprietary protocol infoCQL (Cassandra Query Language, an SQL-like language)
Thrift
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
JDBC
YCQL, an SQL-based flexible-schema API with its roots in Cassandra Query Language
YSQL - a fully relational SQL API that is wire compatible with the SQL language in PostgreSQL
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++
Clojure
Erlang
Go
Haskell
Java
JavaScript infoNode.js
Perl
PHP
Python
Ruby
Scala
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
.Net infoFigaro is a .Net framework assembly that extends Berkeley DB XML into an embeddable database engine for .NET
others infoThird-party libraries to manipulate Berkeley DB files are available for many languages
C
C#
C++
Java
JavaScript (Node.js) info3rd party binding
Perl
Python
Tcl
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
Scala
Server-side scripts infoStored proceduresyesnoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javanoyes infosql, plpgsql, C
Triggersyesyesyesyes infoonly for the SQL APIyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioningSharding infono "single point of failure"tables can be distributed across several files (horizontal partitioning); sharding through federationnoneHash and Range Sharding, row-level geo-partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationselectable replication factor infoRepresentation of geographical distribution of servers is possibleyes, but depending on the SQL-Server EditionSource-replica replicationBased on Raft distributed consensus protocol, minimum 3 replicas for continuous availability
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency infocan be individually decided for each write operation
Immediate ConsistencyStrong consistency on writes and tunable consistency on reads
Foreign keys infoReferential integrityyesnoyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoAtomicity and isolation are supported for single operationsACIDACIDDistributed ACID with Serializable & Snapshot Isolation. Inspired by Google Spanner architecture.
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes infobased on RocksDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesyesno
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users can be defined per objectfine grained access rights according to SQL-standardnoyes
More information provided by the system vendor
Amazon AuroraCassandraMicrosoft SQL ServerOracle Berkeley DBYugabyteDB
Specific characteristicsApache Cassandra is the leading NoSQL, distributed database management system, well...
» more
YugabyteDB is an open source distributed SQL database for cloud native transactional...
» more
Competitive advantagesNo single point of failure ensures 100% availability . Operational simplicity for...
» more
PostgreSQL compatible: Get instantly productive with a PostgreSQL compatible RDBMS....
» more
Typical application scenariosInternet of Things (IOT), fraud detection applications, recommendation engines, product...
» more
Systems of record and engagement for cloud native applications that require resilience,...
» more
Key customersApple, Netflix, Uber, ING,, Intuit,Fidelity, NY Times, Outbrain, BazaarVoice, Best...
» more
Market metricsCassandra is used by 40% of the Fortune 100.
» more
2 Million+ lifetime clusters deployed, 6.5K+ GitHub stars, 7K YugabyteDB Community...
» more
Licensing and pricing modelsApache license  Pricing for commercial distributions provided by DataStax and available...
» more
Apache 2.0 license for the database
» more
News

How to Build a Crystal Image Search App with Vector Search
25 April 2024

Knowledge Graphs for RAG without a GraphDB
18 April 2024

How Winweb Built its AI Assistant with DataStax Astra DB and LangChain
17 April 2024

Vercel + Astra DB: Get Data into Your GenAI Apps Fast
16 April 2024

Simplifying Agent Development with Astra DB Connector for Vertex AI Search
11 April 2024

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

Cassandra Forward event: Want to level up your Cassandra game? Watch now replays of the March 2023 sessions.
» 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 AuroraCassandraMicrosoft SQL ServerOracle Berkeley DBYugabyteDB
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

Cassandra keeps climbing the ranks of the DB-Engines Ranking
3 May 2016, Matthias Gelbmann

Oracle is the DBMS of the Year
5 January 2016, Paul Andlinger, Matthias Gelbmann

Winners, losers and an attractive newcomer in Novembers DB-Engines ranking
2 November 2015, 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

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

show all

Recent citations in the news

Baffle enables computation on encrypted Amazon RDS and Aurora data – Blocks and Files
1 May 2024, Blocks and Files

Join the preview of Amazon Aurora Limitless Database | Amazon Web Services
27 November 2023, AWS Blog

Handle tables without primary keys while creating Amazon Aurora PostgreSQL zero-ETL integrations with Amazon ...
18 April 2024, AWS Blog

Baffle Delivers Enterprise-Grade Data Security for PostgreSQL on Amazon RDS and Amazon Aurora
1 May 2024, Yahoo Finance

New – Amazon Aurora Optimized Reads for Aurora PostgreSQL with up to 8x query latency improvement for I/O ...
8 November 2023, AWS Blog

provided by Google News

What Is Cassandra? Working, Features, and Uses - Spiceworks Inc
17 August 2023, Spiceworks News and Insights

Here's What to Know About Apache Cassandra 5.0
15 April 2024, hackernoon.com

How Uber Optimized Cassandra Operations At Scale
20 July 2023, Uber

Microsoft extends life support for aging Apache Cassandra 3.11 database
10 October 2023, The Register

Cassandra is the “best f*cking database for gen AI,” says DataStax CEO
13 December 2023, VentureBeat

provided by Google News

Why migrate Windows Server and SQL Server to Azure: ROI, innovation, and free offers
25 April 2024, Microsoft

RDS Custom for SQL Server supports SQL Server Developer Edition
17 November 2023, AWS Blog

How to Know When It's Time for a Microsoft SQL Server Upgrade
31 October 2023, BizTech Magazine

Deploying a highly available Microsoft SQL Server database on Oracle Cloud Infrastructure (OCI) using AlwaysON ...
9 October 2023, Oracle

Install and Use SQL Server Report Builder
10 April 2024, Petri.com

provided by Google News

Margo Seltzer Named ACM Athena Lecturer for Technical and Mentoring Contributions
26 April 2023, HPCwire

ACM recognizes far-reaching technical achievements with special awards
26 May 2021, EurekAlert

EC will investigate the Oracle/Sun takeover due to concerns about MySQL
3 September 2009, The Guardian

Database Trends Report: SQL Beats NoSQL, MySQL Most Popular -- ADTmag
5 March 2019, ADT Magazine

The importance of bitcoin nodes and how to start one
9 May 2014, The Merkle News

provided by Google News

Yugabyte Achieves PCI DSS Level 1 Compliance, Validating Secure and Scalable Distributed PostgreSQL for ...
14 March 2024, Business Wire

YugabyteDB 2.21 Introduces Industry's First Native Disaster Recovery Orchestration Solution for a Distributed SQL ...
30 April 2024, Yahoo Finance

YugabyteDB Becomes First Distributed SQL Database Vendor to Complete CIS Benchmark
1 February 2024, Datanami

The surprising link between Formula One and enterprise PostgreSQL optimisation
28 March 2024, The Stack

YUGABYTE'S DSS ASIA 2024: UNEARTH POWER, VERSATILITY OF DISTRIBUTED SQL
18 April 2024, BERNAMA

provided by Google News



Share this page

Featured Products

Milvus logo

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

AllegroGraph logo

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

Neo4j logo

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB 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