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

DBMS > Alibaba Cloud AnalyticDB for PostgreSQL vs. Amazon Redshift vs. Postgres-XL vs. Raima Database Manager

System Properties Comparison Alibaba Cloud AnalyticDB for PostgreSQL vs. Amazon Redshift vs. Postgres-XL vs. Raima Database Manager

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDB  Xexclude from comparisonAmazon Redshift  Xexclude from comparisonPostgres-XL  Xexclude from comparisonRaima Database Manager infoformerly named db_Vista  Xexclude from comparison
DescriptionAn online MPP (Massively Parallel Processing) data warehousing service based on GreenplumLarge scale data warehouse service for use with business intelligence toolsBased on PostgreSQL enhanced with MPP and write-scale-out cluster featuresRDBMS with a small footprint, either embedded into an application or used as a database server
Primary database modelRelational DBMSRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.34
Rank#236  Overall
#112  Relational DBMS
Score20.96
Rank#31  Overall
#18  Relational DBMS
Score0.47
Rank#212  Overall
#102  Relational DBMS
Score0.32
Rank#240  Overall
#113  Relational DBMS
Websitewww.alibabacloud.com/­product/­hybriddb-postgresqlaws.amazon.com/­redshiftwww.postgres-xl.orgraima.com
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­35387.htmdocs.aws.amazon.com/­redshiftwww.postgres-xl.org/­documentationdocs.raima.com
DeveloperAlibaba / Pivotal Software Inc. / PostgreSQL Global Development GroupAmazon (based on PostgreSQL)Raima Inc.
Initial release201620122014 infosince 2012, originally named StormDB1984
Current release10 R1, October 201814.1
License infoCommercial or Open SourcecommercialcommercialOpen Source infoMozilla public licensecommercial
Cloud-based only infoOnly available as a cloud serviceyesyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCCC
Server operating systemshostedhostedLinux
macOS
Android
HP-UX
Integrity RTOS
iOS
Linux
OS X
QNX
Solaris
VxWorks
Windows
Data schemeyesyesyesyes
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.yesnoyes infoXML type, but no XML query functionalityno infoExporting/Importing of XML structures possible
Secondary indexesyesrestrictedyesyes
SQL infoSupport of SQLyesyes infodoes not fully support an SQL-standardyes infodistributed, parallel query executionyes
APIs and other access methodsJDBC
ODBC
JDBC
ODBC
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
ADO.NET
JDBC
ODBC
Supported programming languagesC
Java
Perl
Python
R
All languages supporting JDBC/ODBC.Net
C
C++
Delphi
Erlang
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
.Net
C
C++
Objective-C
PL/SQL
Server-side scripts infoStored proceduresyesuser defined functions infoin Pythonuser defined functionsyes infobased on the ANSI/ISO SQL Persistent Stored Modules (PSM) specification
Triggersyesnoyesyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceShardinghorizontal partitioninghorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceyesMaster-slave replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configuration
Foreign keys infoReferential integrityyesyes infoinformational only, not enforced by the systemyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID infoMVCCACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes, multi-version concurrency control (MVCC)
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.noyesnoyes
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardno
More information provided by the system vendor
Alibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDBAmazon RedshiftPostgres-XLRaima Database Manager infoformerly named db_Vista
News

Intelligence of Things with Raima at MWC Barcelona and Embedded World 2020
11 February 2020

Raima comes to FreeRTOS
19 July 2019

NO OS Support, New Geospatial Query Types and Optimization
24 April 2019

Raima Database Manager subsea in Aker Solutions’ Vectus™ 6.0 control system
9 April 2019

Raima Releases RDM v14.1 embedded database with support for VxWorks and Wind River Linux
12 April 2018

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

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

More resources
Alibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDBAmazon RedshiftPostgres-XLRaima Database Manager infoformerly named db_Vista
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

Recent citations in the news

Cloud DBaaS is the future of database management for the Enterprise
7 February 2020, Times of India

Alibaba Cloud DBaaS to digitalise businesses
10 January 2020, DATAQUEST

Alibaba Cloud offers DBaaS to digitalise India businesses in a cloud native era
23 December 2019, Wire19

Tableau expands data 'viz' toolsets & extensions - CW Developer Network
14 November 2019, ComputerWeekly.com

Tableau announces raft of integrations and offerings
19 November 2019, IT Brief Australia

provided by Google News

The State Of Enterprise Data Integration, 2020
29 March 2020, Forbes

What is Amazon Redshift?
10 December 2019, TechRadar

Amazon Redshift turns AQUA
11 December 2019, ZDNet

Data Platform Architect - McDonald's Technology
26 March 2020, Built In Chicago

Sinequa Is Now Available in AWS Marketplace
11 March 2020, Yahoo Finance

provided by Google News

The States Can’t Blockchain
1 March 2020, Yahoo Finance

Building a scalable PostgreSQL solution
14 April 2019, Packt Hub

Interview with Frank Huerta and Mason Sharp on PostGres-XL
13 May 2014, opensource.com

When PostgreSQL Doesn't Scale Well Enough
18 April 2016, DZone News

PostgreSQL vs. Hadoop
20 August 2016, DZone News

provided by Google News

Job opportunities

AWS Database Services SDE, Amazon Redshift
Amazon.com Services LLC, East Palo Alto, CA

AWS Database Services SDE, Amazon Redshift
Amazon.com Services LLC, Austin, TX

Amazon Redshift Development Manager
Amazon.com Services LLC, Arlington, VA

Amazon Redshift Development Manager
Amazon.com Services LLC, East Palo Alto, CA

Amazon Redshift - Design Engineer Intern
Amazon Web Services, Inc., East Palo Alto, CA

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

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.

Datastax Luna logo

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

MariaDB logo

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

Present your product here