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

DBMS > Amazon Aurora vs. MySQL vs. RDF4J vs. Teradata

System Properties Comparison Amazon Aurora vs. MySQL vs. RDF4J vs. Teradata

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon Aurora  Xexclude from comparisonMySQL  Xexclude from comparisonRDF4J infoformerly known as Sesame  Xexclude from comparisonTeradata  Xexclude from comparison
DescriptionMySQL and PostgreSQL compatible cloud service by AmazonWidely used open source RDBMSRDF4J is a Java framework for processing RDF data, supporting both memory-based and a disk-based storage.A hybrid cloud data analytics software platform (Teradata Vantage)
Primary database modelRelational DBMSRelational DBMS infoKey/Value like access via memcached APIRDF storeRelational DBMS
Secondary database modelsDocument storeDocument storeDocument store
Graph DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score7.97
Rank#47  Overall
#28  Relational DBMS
Score1268.35
Rank#2  Overall
#2  Relational DBMS
Score0.42
Rank#220  Overall
#9  RDF stores
Score76.59
Rank#15  Overall
#10  Relational DBMS
Websiteaws.amazon.com/­rds/­aurorawww.mysql.comrdf4j.orgwww.teradata.com
Technical documentationdocs.aws.amazon.com/­AmazonRDS/­latest/­AuroraUserGuide/­CHAP_Aurora.htmldev.mysql.com/­docdocs.rdf4j.orgdocs.teradata.com
DeveloperAmazonOracle infosince 2010, originally MySQL AB, then SunSince 2016 officially forked into an Eclipse project, former developer was Aduna Software.Teradata
Initial release2015199520041984
Current release8.0.19, 2020Teradata Vantage 1.0 MU2, January 2019
License infoCommercial or Open SourcecommercialOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availableOpen Source infoEclipse Distribution License (EDL), v1.0.commercial
Cloud-based only infoOnly available as a cloud serviceyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Azure Database for MySQL: A fully managed, scalable MySQL relational database with high availability and security built in at no extra cost
Implementation languageC and C++Java
Server operating systemshostedFreeBSD
Linux
OS X
Solaris
Windows
Linux
OS X
Unix
Windows
hosted
Linux
Data schemeyesyesyes infoRDF Schemasyes
Typing infopredefined data types such as float or dateyesyesyesyes
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.yesyesyes
Secondary indexesyesyesyesyes infoJoin-index to prejoin tables, aggregate index, sparse index, hash index
SQL infoSupport of SQLyesyes infowith proprietary extensionsnoyes infoSQL 2016 + extensions
APIs and other access methodsADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
Proprietary native API
Java API
RIO infoRDF Input/Output
Sail API
SeRQL infoSesame RDF Query Language
Sesame REST HTTP Protocol
SPARQL
.NET Client API
HTTP REST
JDBC
JMS Adapter
ODBC
OLE DB
Supported programming languagesAda
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Java
PHP
Python
C
C++
Cobol
Java (JDBC-ODBC)
Perl
PL/1
Python
R
Ruby
Server-side scripts infoStored proceduresyesyes infoproprietary syntaxyesyes infoUDFs, stored procedures, table functions in parallel
Triggersyesyesyesyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioninghorizontal partitioning, sharding with MySQL Cluster or MySQL FabricnoneSharding infoHashing
Replication methods infoMethods for redundantly storing data on multiple nodesMaster-slave replicationMaster-master replication
Master-slave replication
noneMaster-master replication
Master-slave replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyes infonot for MyISAM storage engineyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infonot for MyISAM storage engineACID infoIsolation support depends on the API usedACID
Concurrency infoSupport for concurrent manipulation of datayesyes infotable locks or row locks depending on storage engineyesyes
Durability infoSupport for making data persistentyesyesyes infoin-memory storage is supported as wellyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes
User concepts infoAccess controlfine grained access rights according to SQL-standardUsers with fine-grained authorization concept infono user groups or rolesnofine 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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

Dremio is like magic for MySQL accelerating your analytical queries up to 1,000x.
» more

SQLPro for MySQL: A simple but powerful MySQL database client available on iPhone and iPad as well as macOS.
» more

Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service
» more

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

ScaleGrid: Fully managed MySQL-as-a-Service.
» more
General 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

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

More resources
Amazon AuroraMySQLRDF4J infoformerly known as SesameTeradata
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

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

show all

Teradata is the most popular data warehouse DBMS
2 April 2013, Paul Andlinger

show all

Recent citations in the news

What is Amazon Aurora?
23 December 2019, TechRadar

Resource guide for Amazon Aurora users
13 September 2019, MIT Technology Review

Amazon Announces General Availability of Aurora Multi-Master
3 September 2019, InfoQ.com

PostgreSQL on Amazon Aurora Serverless goes live. Check the price tag before diving in, though
10 July 2019, The Register

6 Best Companies in the SQL Space
10 March 2020, TechBullion

provided by Google News

Connecting to a MySQL Database in .NET
16 March 2020, Database Journal

Cloud DB Combines Kubernetes with Open Middleware
1 April 2020, Datanami

MariaDB cuddles Kubernetes, snuggles ServiceNow and readies analytics with latest update to cloudy SkySQL
31 March 2020, The Register

Canonical launches Managed Apps for enterprise DevOps teams
1 April 2020, Cloud Pro

The No-Code Movement: From Technopreneur To Entrepreneur
1 April 2020, Forbes

provided by Google News

Big data database Apache Rya becomes a Top Level Project
10 October 2019, JAXenter

GraphDB Goes Open Source
27 January 2020, iProgrammer

Amazon Neptune review: A scalable graph database for OLTP
13 May 2019, InfoWorld

Ontotext's GraphDB 8.10 Makes Knowledge Graph Experience Faster and Richer
13 June 2019, Yahoo Finance

Apache Rya matures open source triple store database
17 October 2019, TechTarget

provided by Google News

Hedge Funds Have Never Been This Bullish On Teradata Corporation (TDC)
29 March 2020, Yahoo Finance

Have Insiders Been Buying Teradata Corporation (NYSE:TDC) Shares This Year?
17 March 2020, Yahoo Finance

Why Is Teradata (TDC) Down 16.1% Since Last Earnings Report?
7 March 2020, Yahoo Finance

Teradata Corporation (TDC) and Aurora Cannabis Inc. (ACB): Prospects For The Double-Digit
30 March 2020, BOV News

Chief Financial Officer Mark Culhane Just Bought Shares In Teradata Corporation (NYSE:TDC)
16 March 2020, Simply Wall St

provided by Google News

Job opportunities

Amazon DocumentDB Specialist SA
Amazon Web Services, Inc., New York, NY

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

Software Development Manager - Amazon Aurora
Amazon Web Services, Inc., East Palo Alto, CA

Software Development Engineer - Amazon Aurora
Amazon.com Services LLC, Seattle, WA

Database Engineer - Aurora
Amazon Web Services, Inc., East Palo Alto, CA

PostgreSQL and MySQL DBA
OneSource IT, Inc., Herndon, VA

MYSQL DBA Admin
Expedite Inc., Ipswich, MA

MySQL Database Architect
AGM Tech Solutions, Alpharetta, GA

MYSQL DBA OR MongoDB with MYsql
Canopy One Solutions, Inc., Dallas, TX

PHP/MySQL Developer
CyberTheory, Princeton, NJ

Sr. Teradata/ETL Developer
IB Systems, Dallas, TX

Data Scientist - People Analytics
Unum, Remote

QA Tester
Piper Companies, Durham, NC

Teradata DBA4
Wells Fargo, New York, NY

Teradata-Developer
Celandyne Software Solutions, United States

jobs by Indeed




Share this page

Featured Products

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandraâ„¢ from the Cassandra experts.
Learn more.

Couchbase logo

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

Neo4j logo

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

Present your product here