DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Alibaba Cloud AnalyticDB for PostgreSQL vs. Amazon DynamoDB vs. Amazon SimpleDB vs. EDB Postgres vs. STSdb

System Properties Comparison Alibaba Cloud AnalyticDB for PostgreSQL vs. Amazon DynamoDB vs. Amazon SimpleDB vs. EDB Postgres vs. STSdb

Editorial information provided by DB-Engines
NameAlibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDB  Xexclude from comparisonAmazon DynamoDB  Xexclude from comparisonAmazon SimpleDB  Xexclude from comparisonEDB Postgres  Xexclude from comparisonSTSdb  Xexclude from comparison
DescriptionAn online MPP (Massively Parallel Processing) data warehousing service based on GreenplumHosted, scalable database service by Amazon with the data stored in Amazons cloudHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreThe EDB Postgres Platform is an enterprise-class data management platform based on the open source database PostgreSQL with flexible deployment options and Oracle compatibility features, complemented by tool kits for management, integration, and migration.Key-Value Store with special method for indexing infooptimized for high performance using a special indexing method
Primary database modelRelational DBMSDocument store
Key-value store
Key-value storeRelational DBMSKey-value store
Secondary database modelsDocument store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.33
Rank#291  Overall
#135  Relational DBMS
Score83.85
Rank#15  Overall
#2  Document stores
#2  Key-value stores
Score2.43
Rank#122  Overall
#23  Key-value stores
Score2.59
Rank#117  Overall
#59  Relational DBMS
Score0.15
Rank#345  Overall
#50  Key-value stores
Websitewww.alibabacloud.com/­product/­hybriddb-postgresqlaws.amazon.com/­dynamodbaws.amazon.com/­simpledbwww.enterprisedb.comgithub.com/­STSSoft/­STSdb4
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­35387.htmdocs.aws.amazon.com/­dynamodbdocs.aws.amazon.com/­simpledbwww.enterprisedb.com/­edb-docs
DeveloperAlibaba / Pivotal Software Inc. / PostgreSQL Global Development GroupAmazonAmazonEnterpriseDBSTS Soft SC
Initial release20162012200720052011
Current release14, December 20214.0.8, September 2015
License infoCommercial or Open Sourcecommercialcommercial infofree tier for a limited amount of database operationscommercialcommercial infoBSD for PostgreSQL-componentsOpen Source infoGPLv2, commercial license available
Cloud-based only infoOnly available as a cloud serviceyesyesyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC#
Server operating systemshostedhostedhostedLinux
Windows
Windows
Data schemeyesschema-freeschema-freeyesyes
Typing infopredefined data types such as float or dateyesyesnoyesyes infoprimitive types and user defined types (classes)
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.yesyes infospecific XML-type available, but no XML query functionality.
Secondary indexesyesyesyes infoAll columns are indexed automaticallyyesno
SQL infoSupport of SQLyesnonoyes infostandard with numerous extensionsno
APIs and other access methodsJDBC
ODBC
RESTful HTTP APIRESTful HTTP APIADO.NET
JDBC
native C library
ODBC
streaming API for large objects
.NET Client API
Supported programming languagesC
Java
Perl
Python
R
.Net
ColdFusion
Erlang
Groovy
Java
JavaScript
Perl
PHP
Python
Ruby
.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
.Net
C
C++
Delphi
Java
Perl
PHP
Python
Tcl
C#
Java
Server-side scripts infoStored proceduresyesnonouser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.no
Triggersyesyes infoby integration with AWS Lambdanoyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceShardingnone infoSharding must be implemented in the applicationhorizontal partitioning infoby hash, list or rangenone
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceyesyesMulti-source replicationnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono infomay be implemented via Amazon Elastic MapReduce (Amazon EMR)nonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency infocan be specified for read operations
Eventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate Consistency
Foreign keys infoReferential integrityyesnonoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infoACID across one or more tables within a single AWS account and regionno infoConcurrent data updates can be detected by the applicationACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Access rights for users and roles can be defined via the AWS Identity and Access Management (IAM)fine grained access rights according to SQL-standardno
More information provided by the system vendor
Alibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDBAmazon DynamoDBAmazon SimpleDBEDB PostgresSTSdb
Specific characteristicsPostgreSQL with added Security, Performance, DBA, Developer, and Oracle compatibile...
» more
Competitive advantagesComplete Postgres platform with enterprise-class Postgres, Management, Integration,...
» more
Typical application scenariosNew applications for transactional, reporting and mixed workloads that need to integrate...
» more
Key customersMasterCard, Hewlett Packard Enterprise, Ericsson, AT&T, Alibaba, Korea Telecom and...
» more
Market metricsListed in Gartner Magic Quadrant 2013-2018 with over 4,000 customers.
» more
Licensing and pricing modelsOpen Source and Commercial core based licensing.
» more

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 DynamoDBAmazon SimpleDBEDB PostgresSTSdb
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

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

Recent citations in the news

Alibaba Cloud launches ModelScope platform
7 November 2022, CloudTech News

Alibaba Cloud Launches ‘ModelScope,’ An Open-Source Model-as-a-Service (MaaS) Platform that Comes with Hundreds of Artificial Intelligence (AI) Models
21 November 2022, MarkTechPost

Alibaba Cloud launches ModelScope and new serverless solutions
17 November 2022, Gulf News

Alibaba Cloud launches ModelScope platform and new solutions
9 November 2022, TechCity

Alibaba Cloud launches open source Model-as-a-Service platform
4 November 2022, IT Brief Australia

provided by Google News

ISO Better Scaling, Instacart Drops Postgres for Amazon DynamoDB
29 November 2022, thenewstack.io

How To Use AWS DynamoDB With Python
5 December 2022, Digital Journal

DynamoDB Data Transformation Safety: from Manual Toil to Automated and Open Source
23 November 2022, InfoQ.com

Meet the database that supports Amazon.com
14 November 2022, The Register

Breaking: AWS Experienced an Outage in Its US-East 2 Availability Zone
5 December 2022, Data Center Knowledge

provided by Google News

Meet the database that supports Amazon.com
14 November 2022, The Register

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed Product On AWS
13 November 2013, TechCrunch

How to deploy the Adminer database admin tool on Ubuntu Server 22.04
11 August 2022, TechRepublic

provided by Google News

3 key features in EDB PostgreSQL 15
29 November 2022, InfoWorld

Real-time Analytics News for Week Ending December 3
5 December 2022, RTInsights

PostgreSQL® 15 Reflects EDB's Significant History as
13 October 2022, GlobeNewswire

EDB Releases Fully-managed ‘BigAnimal’ Postgres Service on AWS, Azure
1 June 2022, CDOTrends

EDB 14 Supercharges PostgreSQL for Mission-critical Applications
9 December 2021, Business Wire

provided by Google News

Job opportunities

BIG data engineer with AWS
Freemind solutions, Remote

Data Engineer Apprenticeship
Fetch, Chicago, IL

SQL Developer
Fetch, Chicago, IL

Node.js(Backend) Developer
AIT GLOBAL INC, Remote

Backend Developer
Aeroflow Healthcare, Remote

Ruby Developer
element^n, New York, NY

DevOps Engineer - ArcGIS Enterprise
ESRI, Inc., Remote

AWS Solution Architect
Tech Intellectuals, Edison, NJ

AWS Solutions Architect
proit-inc, Edison, NJ

Oracle DBA
Encore Theme, O'Fallon, MO

Database Administrator
Ardor IT Solutions, Charlotte, NC

Postgre SQL + Oracle DBA
Encore Theme, O'Fallon, MO

AWS PostgreSQL ETL Data Modeling
Silver Tree Consulting and Services, Raleigh, NC

Senior PostgreSQL Application DBA
eSystems Inc., Linthicum, MD

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

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.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

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

Redis logo

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

Present your product here