DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Alibaba Cloud AnalyticDB for PostgreSQL vs. Atos Standard Common Repository vs. PostgreSQL vs. SWC-DB

System Properties Comparison Alibaba Cloud AnalyticDB for PostgreSQL vs. Atos Standard Common Repository vs. PostgreSQL vs. SWC-DB

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 comparisonAtos Standard Common Repository  Xexclude from comparisonPostgreSQL  Xexclude from comparisonSWC-DB infoSuper Wide Column Database  Xexclude from comparison
This system has been discontinued and will be removed from the DB-Engines ranking.
DescriptionAn online MPP (Massively Parallel Processing) data warehousing service based on GreenplumHighly scalable database system, designed for managing session and subscriber data in modern mobile communication networksWidely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQLA high performance, scalable Wide Column DBMS
Primary database modelRelational DBMSDocument store
Key-value store
Relational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.Wide column store
Secondary database modelsDocument store
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.53
Rank#238  Overall
#114  Relational DBMS
Score606.56
Rank#4  Overall
#4  Relational DBMS
Score0.09
Rank#309  Overall
#13  Wide column stores
Websitewww.alibabacloud.com/­product/­hybriddb-postgresqlatos.net/en/convergence-creators/portfolio/standard-common-repositorywww.postgresql.orggithub.com/­kashirin-alex/­swc-db
www.swcdb.org
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­35387.htmwww.postgresql.org/­docs
DeveloperAlibaba / Pivotal Software Inc. / PostgreSQL Global Development GroupAtos Convergence CreatorsPostgreSQL Global Development Group infowww.postgresql.org/­developerAlex Kashirin
Initial release201620161989 info1989: Postgres, 1996: PostgreSQL2020
Current release170314.1, November 20210.5, April 2021
License infoCommercial or Open SourcecommercialcommercialOpen Source infoBSDOpen Source infoGPL V3
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.
ScaleGrid for PostgreSQL: Fully managed PostgreSQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
Implementation languageJavaCC++
Server operating systemshostedLinuxFreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Linux
Data schemeyesSchema and schema-less with LDAP viewsyesschema-free
Typing infopredefined data types such as float or dateyesoptionalyes
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 infospecific XML-type available, but no XML query functionality.no
Secondary indexesyesyesyes
SQL infoSupport of SQLyesnoyes infostandard with numerous extensionsSQL-like query language
APIs and other access methodsJDBC
ODBC
LDAPADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Proprietary protocol
Thrift
Supported programming languagesC
Java
Perl
Python
R
All languages with LDAP bindings.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
C++
Server-side scripts infoStored proceduresyesnouser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.no
Triggersyesyesyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceSharding infocell divisionpartitioning by range, list and (since PostgreSQL 11) by hashSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceyesSource-replica replication infoother methods possible by using 3rd party extensions
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configurationImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDAtomic execution of specific operationsACID
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.noyesnono
User concepts infoAccess controlfine grained access rights according to SQL-standardLDAP bind authenticationfine 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 partiesSQLFlow: 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

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
» more

Instaclustr: Fully Hosted & Managed PostgreSQL
» more

Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» more

pgDash: In-Depth PostgreSQL Monitoring.
» more

CYBERTEC is your professional partner for PostgreSQL services and Data Science since 2000. With offices in Austria, Uruguay, Estonia, Poland, South Africa and Switzerland, CYBERTEC operates worldwide and is here for you 24/7!
» more

EDB: BigAnimal is fully-managed PostgreSQL in the cloud from the database fanatics at EDB.
» 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 HybridDBAtos Standard Common RepositoryPostgreSQLSWC-DB infoSuper Wide Column Database
DB-Engines blog posts

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

Driving the Future of PostgreSQL Adoption
15 November 2021,  Umair Shahid, Percona (sponsor) 

The Inexorable Rise of PostgreSQL
24 September 2021,  Matt Yonkovit, Percona (sponsor) 

show all

Recent citations in the news

Alibaba Cloud launches new cloud database solutions following market growth
1 October 2020, DataCenterNews Asia

Alibaba Cloud Unveils 'Magic' Behind the World's Largest Online Shopping Festival
19 November 2020, PRNewswire

Alibaba supports Singles Day with cloud computing, 3D models
19 November 2020, Chain Store Age

Alibaba Cloud reports strong Q1, hits $7 billion annual revenue run rate
20 August 2020, ZDNet

Alibaba Cloud Leader in Magic Quadrant for Cloud Database Management
1 December 2020, DataCenterNews Asia

provided by Google News

Relational Databases Software Market Technology, New Innovations, Forecast Report to 2026
10 January 2022, Get News Alert

All your database are belong to us: Snowflake named DBMS of the year by DB-Engines
6 January 2022, The Register

Operationalizing Analytics
12 January 2022, TechSpective

Amazon RDS Introduces Readable Standby Instances in Multi-AZ Deployments
1 January 2022, InfoQ.com

OceanBase Records Over 100% Increase in Number of Customers
13 January 2022, Business Wire

provided by Google News

Job opportunities

Data Analyst
Corporate Tools, Post Falls, ID

PostgreSQL Database Administrator
General Motors, Austin, TX

Oracle / PostgreSQL Database Administrator
Open Systems Technologies Corporation, Clarksburg, WV

JUNIOR DATABASE ADMINISTRATOR
Ignite Fueling Innovation, Huntsville, AL

MySQL Database Administrator
Wolfram, Remote

jobs by Indeed



Share this page

Featured Products

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

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

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!

Present your product here