Difference between Alibaba Cloud AnalyticDB for PostgreSQL and Altibase

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.

My Personal Notes arrow_drop_up

Small things always make you to think big

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.