DB-EnginesExtremeDB: the hard real time dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Redshift vs. Greenplum vs. Microsoft Azure SQL Database vs. Teradata Aster

System Properties Comparison Amazon Redshift vs. Greenplum vs. Microsoft Azure SQL Database vs. Teradata Aster

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonGreenplum  Xexclude from comparisonMicrosoft Azure SQL Database infoformerly SQL Azure  Xexclude from comparisonTeradata Aster  Xexclude from comparison
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.
DescriptionLarge scale data warehouse service for use with business intelligence toolsAnalytic Database platform built on PostgreSQL. Full name is Pivotal Greenplum Database infoA logical database in Greenplum is an array of individual PostgreSQL databases working together to present a single database image.Database as a Service offering with high compatibility to Microsoft SQL ServerPlatform for big data analytics on multistructured data sources and types
Primary database modelRelational DBMSRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument store
Spatial DBMS
Document store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score25.94
Rank#31  Overall
#18  Relational DBMS
Score13.36
Rank#44  Overall
#28  Relational DBMS
Score85.33
Rank#15  Overall
#10  Relational DBMS
Websiteaws.amazon.com/­redshiftgreenplum.orgazure.microsoft.com/­en-us/­services/­sql-database
Technical documentationdocs.aws.amazon.com/­redshiftdocs.greenplum.orgdocs.microsoft.com/­en-us/­azure/­azure-sql
DeveloperAmazon (based on PostgreSQL)Pivotal Software Inc.MicrosoftTeradata
Initial release2012200520102005
Current release6.7.1, April 2020V12
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0commercialcommercial
Cloud-based only infoOnly available as a cloud serviceyesnoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC++
Server operating systemshostedLinuxhostedLinux
Data schemeyesyesyesFlexible Schema (defined schema, partial schema, schema free) infodefined schema within the relational store; partial schema or schema free in the Aster File Store
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.noyes infosince Version 4.2yesyes infoin Aster File Store
Secondary indexesrestrictedyesyesyes
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardyesyesyes
APIs and other access methodsJDBC
ODBC
JDBC
ODBC
ADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
OLE DB
Supported programming languagesAll languages supporting JDBC/ODBCC
Java
Perl
Python
R
.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
C
C#
C++
Java
Python
R
Server-side scripts infoStored proceduresuser defined functions infoin PythonyesTransact SQLR packages
Triggersnoyesyesno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesSource-replica replicationyes, with always 3 replicas availableyes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnoyes infoSQL Map-Reduce Framework
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configuration
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnono
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardfine 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

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

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

More resources
Amazon RedshiftGreenplumMicrosoft Azure SQL Database infoformerly SQL AzureTeradata Aster
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

PostgreSQL is the DBMS of the Year 2020
4 January 2021, Paul Andlinger, Matthias Gelbmann

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

show all

Recent citations in the news

(Server) less is more, ThoughtSpot on Amazon Redshift Serverless
11 May 2022, ComputerWeekly.com

Stripe's new Data Pipeline tool aims to ease syncing transaction data with Amazon Redshift and Snowflake
20 May 2022, SiliconANGLE News

Serverless at re:Invent: Where should Amazon Redshift go?
6 December 2021, ZDNet

AWS Introduces Amazon Redshift Serverless
1 December 2021, InfoQ.com

GRAX Launches in AWS Marketplace as AWS ISV Accelerate Partner
4 May 2022, Business Wire

provided by Google News

Pivotal Greenplum Analytic Database Adds Multicloud Support
18 September 2017, SDxCentral

Capitalizing on Analytics and AI at Dell Technologies
8 April 2021, CIO

Mature MADlib Moves Up Apache Development Chain
10 October 2017, Datanami

Has the time finally come for PostgreSQL?
20 April 2018, ZDNet

Big Data Suite Goes Open Source
17 February 2015, CIO

provided by Google News

SQL Server in Azure database choices and what they offer users
29 July 2019, TechTarget

How Microsoft made Azure SQL more available by making recovery faster
2 February 2022, TechRepublic

Microsoft's cloud-connected on-prem database: SQL Server 2022 rolls out in private preview
2 November 2021, ZDNet

Microsoft builds distributed ledger for Azure SQL database
26 May 2021, TechTarget

Professional Azure SQL Managed Database Administration, 3e
4 January 2022, iProgrammer

provided by Google News

Teradata Scales Up R Analytics On Aster
3 July 2014, InformationWeek

How to Select the Right Database for Time-Series Data
2 December 2021, thenewstack.io

Teradata, Lunexa Partnership Introduces Digital Marketing Attribution Solution for Teradata Aster Analytics Platforms
5 June 2012, PR Newswire

Case study: Siemens reduces train failures with Teradata Aster
12 September 2016, RCR Wireless News

What Is a Data Lakehouse?
5 March 2022, Coinspeaker

provided by Google News

Job opportunities

Security Engineer, Amazon Redshift
Amazon Web Services, Inc., East Palo Alto, CA

Software Development Engineer - Amazon Redshift Query Processing, Query Processing
Amazon.com Services LLC, East Palo Alto, CA

Sr. Database Engineer - AWS, Amazon Redshift
Amazon.com Services LLC, East Palo Alto, CA

Principal Developer Advocate, Amazon Redshift
Amazon Dev Center U.S., Inc., Seattle, WA

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

Member of Technical Staff – Greenplum Database Internals/Server - Opportunity for Working Remotely Palo Alto, CA
VMware, Palo Alto, CA

Member of Technical Staff - Query Processing - Tanzu Greenplum Database - Opportunity for Working Remotely Palo Alto, CA
VMware, Palo Alto, CA

Member of Technical Staff – Greenplum Database Internals/Server - Opportunity for Working Remotely San Francisco, CA
VMware, San Francisco, CA

Digital Data Analyst (Must have previous experience as an SQL Analyst)
Luth Research, LLC, San Diego, CA

PostGres DBA
Alltech International, Washington, DC

Senior Database Administrator - SQL Server
Bonterra, Washington, DC

Senior Oracle/SQL Server Database Administrator - REMOTE OPPORTUNITY
Superior Court of Orange County, Orange County, CA

Senior Database Engineer-SQL Server
WELLS FARGO BANK, West Des Moines, IA

SQL Server DBA
THORLABS INC, Newton, NJ

Advisor Azure SQL Database Administrator (DBA)
Gainwell Technologies, Texas

Data Scientists – Machine Learning
Brielle Technologies, Alpharetta, GA

Sr Analyst, DACI Analytics - Loyalty Analytics
Lowe's, Mooresville, NC

Consultant - Data Engineer
Insygnum, Chicago, IL

Sr Analyst, Digital Analytics
Lowe's, Charlotte, NC

Sr Analyst, DACI Analytics
Lowe's, Mooresville, NC

jobs by Indeed



Share this page

Featured Products

Datastax Astra logo

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

Neo4j logo

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

AllegroGraph logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here