1. Cloud AnalyticDB for PostgreSQL :
The AnalyticDB is an online analytical processing database system on Alibaba cloud. It offers both PostgreSQL and MySQL versions. The AnalyticDB for PostgreSQL is an online MPP (Massively Parallel Processing) data warehousing service based on the Greenplum Open Source Database program and is enhanced with some in-depth extensions by Alibaba Cloud.
2. Altibase :
The Altibase is an open-source relational database model system (RDBMS). The first version of Altibase was called Spiner which was released in 1999. It is an enterprise grade, in-memory, hybrid, high-performance RDBMS. It is manufactured by Altibase Corporation. It supports the complete SQL standard, features and Multi-Version Concurrency Control (MVCC) and also implements Fuzzy and Ping-Pong Checkpointing.
Difference between Alibaba Cloud AnalyticDB for PostgreSQL and Altibase :
|S.NO.||Alibaba Cloud AnalyticDB for PostgreSQL||ALTIBASE|
|1.||It was developed By Alibaba, Pivotal Software Inc. and PostgreSQL Global Development Group in 2016.||It was developed By Franz Inc. in 1999.|
|2.||It is an online MPP (Massively Parallel Processing) data warehousing service based on Greenplum.||It is an enterprise grade, high-performance RDBMS.|
|3.||In Alibaba Cloud AnalyticDB for PostgreSQL there are hosted server operating systems.||Server operating systems for Altibase are AIX, HP-UX and Linux.|
|4.||The license of Alibaba Cloud AnalyticDB for PostgreSQL is commercial.||The license of Altibase is a open-source.|
|5.||It supports XML Format.||It does not support XML Format.|
|6.||It supports the Server-side scripting.||It supports stored procedures and stored functions.|
|7.||It support partitioning methods.||The supported partitioning method is Sharding.|
|8.||It supports SQL query language.||It uses ANSI SQL-92 as a query language.|
|9.||It supports replication methods.||It also supports replication methods.|
|10.||AnalyticDB for PostgreSQL provides the concept of Referential Integrity. Hence, there are Foreign Keys.||Altibase provides the concept of Referential Integrity. Hence, there are Foreign Keys.|
|11.||It does not support in-memory capabilities.||It also does not support in-memory capabilities.|
|12.||It does not offer any API for user-defined Map/Reduce methods.||It also does not offer any API for user-defined Map/Reduce methods.|
|13.||It is available as a cloud service.||It is not available as a cloud service.|
|14.||Programming languages supported are C, Java, Perl, Python and R.||Programming languages supported are C, C++ and Java.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.