DB-EnginesCrateDB bannerEnglish
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 modelsKey-value storeDocument store
Key-value store
Document store
Graph DBMS
Key-value store
Key-value store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Rank#32  Overall
#19  Relational DBMS
Rank#38  Overall
#23  Relational DBMS
Rank#26  Overall
#15  Relational DBMS
Rank#108  Overall
#55  Relational DBMS
Technical documentationdocs.aws.amazon.com/­redshiftgpdb.docs.pivotal.iodocs.microsoft.com/­en-us/­azure/­sql-database
DeveloperAmazon (based on PostgreSQL)Pivotal Software Inc.MicrosoftTeradata
Initial release2012200520102005
Current release5.10.0, July 2018V12
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0commercialcommercial
Cloud-based only infoOnly available as a cloud serviceyesnoyesno
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
Supported programming languagesAll languages supporting JDBC/ODBCC
JavaScript (Node.js)
Server-side scripts infoStored proceduresuser defined functions infoin PythonyesTransact SQLR packages
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesMaster-slave 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 partiesDBHawk: a web-based Amazon Redshift Workbench and Cloud database tool.
» more

Progress DataDirect: Data connectivity across standard SQL and REST
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more
Progress DataDirect: Data connectivity across standard SQL and REST
» 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

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

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

show all

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

Recent citations in the news

Amazon Redshift Spectrum Expert Tips for Maximizing the Power of Spectrum
6 November 2018, CIO

“This is What Happens Larry”: Amazon Finally Dumps Oracle Data Warehouse
13 November 2018, Computer Business Review

What To Expect From AWS re:Invent 2018?
14 November 2018, Forbes

Zendesk Announces New Open CRM Platform, Zendesk Sunshine, Powered by Amazon Web Services
14 November 2018, MarTech Series

AWS, Oracle trash talk spotlights cloud database migration
14 November 2018, TechTarget

provided by Google News

The 10 Best Data Management Solutions for Analytics for 2019
3 November 2018, Solutions Review

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

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

Pivotal Software is Latest Tech IPO
20 April 2018, Datanami

Pivotal Greenplum is alive and kicking
14 September 2017, ZDNet

provided by Google News

Microsoft Describes Latest SQL Server 2019 Preview and Azure SQL Improvements
7 November 2018, Redmondmag.com

Improvements Coming to Azure SQL, SQL Server 2019 Preview
8 November 2018, Redmond Channel Partner

Overview of Azure SQL Database Information Protection
1 November 2018, Database Journal

New and Improved Services in Microsoft Azure
5 November 2018, Virtualization Review

SentryOne Announces Expansion of Software Development Engineering Team
16 November 2018, Read IT Quik

provided by Google News

Inside Teradata's Audacious Plan to Consolidate Analytics
17 October 2018, Datanami

アナリティクスではなく“答え”を提供するプラットフォームに――、日本テラデータ「Teradata Vantage」の国内提供開始
11 November 2018, クラウド Watch

New Teradata Focuses on Answers, Not Analytics
9 October 2018, Datanami

Teradata's bet on subscriptions is paying off
18 June 2018, ZDNet

日本テラデータが分析基盤ソフト「Teradata Vantage」を提供、データ分析のサイロ化を解消
7 November 2018, IT Leaders

provided by Google News

Job opportunities

AWS Database Services SDE, Amazon Redshift
Amazon.com, Seattle, WA

AWS Database Services SDE, Amazon Redshift
Lab126, Seattle, WA

Big Data Consultant
Amazon.com, Dallas, TX

Database Administration Lead
Amazon.com, Santa Monica, CA

AWS Solution Builder
Amazon.com, Seattle, WA

Software Testing Manager
Leidos, Lanham, MD

PostGres DBA
Alltech International, New Carrollton, MD

Senior Cloud Centric Greenplum DBA
AllianceData, Leesburg, VA

Senior Cloud Centric Greenplum DBA
Conversant Media, Leesburg, VA

Datastage Developer
enherent Corp, New York, NY

Data Engineer
Microsoft, Redmond, WA

Azure Data Engineer
HFF, L.P., Houston, TX

Cloud Data Engineer
Impact Makers, Inc., Richmond, VA

Data Engineer
Southern Poverty Law Center, Alabama

SQL Database Administrator / SSIS Developer
Plante & Moran, Southfield, MI

Data Scientist
Verizon, Ashburn, VA

Aster Consultant
NTT DATA Services, Charlotte, NC

Data Scientists – Machine Learning
Brielle Technologies, Alpharetta, GA

Data Scientist Manager
Verizon, Alpharetta, GA

Fraud Analytics Leader, Analytic Manager 5
Wells Fargo, Irving, TX

jobs by Indeed

Share this page

Featured Products

RavenDB logo

Runs on Windows, Linux, Raspberry Pi. Easy to Operate, Fast Performance.
APIs for JS, .NET, Python.
Take a Free Download

Neo4j logo

New to the world of graph databases? Become an expert today with your copy of the Graph Databases for Beginners ebook.

Redis logo

Start now with Redis Cloud
Secure, highly available Redis as a serverless, hosted, fully managed cloud service.
Sign up here.

Couchbase logo

Power, flexibility & scale.
All open source.
Get started now.

Present your product here