1. Adabas :
The Adabas stands for an Adaptable Database System. It was It was developed by Software AG to run on IBM mainframes. It was launched in 1971. It is an OLTP-DBMS for mainframes and Linux/Unix/Windows environments. Adabas is an enterprise database management system (DBMS) designed for reliability, high performance, scalability and low total cost of ownership.
2. Alibaba 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.
Difference between Adabas and Alibaba Cloud AnalyticDB for PostgreSQL :
|S.NO.||ADABAS||Alibaba Cloud AnalyticDB for PostgreSQL|
|1.||It was developed by Software AG in 1971.||It was developed by Alibaba, Pivotal Software Inc. and PostgreSQL Global Development Group in 2016.|
|2.||It is an OLTP-DBMS for mainframes and Linux/Unix/Windows environments.||It is an online MPP (Massively Parallel Processing) data warehousing service based on Greenplum.|
|3.||It does not support in-memory capabilities.||It also does not support In-memory capabilities.|
|4.||Server operating systems for Adabas are BS2000, Linux, Unix, Windows, z/OS and z/VSE.||In Alibaba Cloud AnalyticDB for PostgreSQL, there are Hosted server operating systems.|
|5.||It does not support XML Format.||It supports XML Format.|
|6.||Server-side scripting is done in Natural language.||It also supports the Server-side scripting.|
|7.||It supports partitioning methods.||Supported partitioning method is Sharding.|
|8.||It supports SQL query language with add-on product Adabas SQL Gateway.||It also supports SQL query language.|
|9.||It supports replication with add-on product Event Replicator.||It also supports replication methods.|
|10.||Adabas does not provide the concept of Referential Integrity. Hence, no Foreign Keys.||AnalyticDB for PostgreSQL provides the concept of Referential Integrity. Hence, there are Foreign Keys.|
|11.||The license of Adabas is commercial.||The license of Alibaba Cloud AnalyticDB for PostgreSQL is also commercial.|
|12.||The primary database model is Multivalue DBMS.||The primary database model is Relational DBMS.|
|13.||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.|
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.