Open In App

Difference between Adabas and Alibaba Cloud AnalyticDB for MySQL

Improve
Improve
Like Article
Like
Save
Share
Report

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 MySQL :
The AnalyticDB is an online analytical processing database system on Alibaba cloud. It offers both PostgreSQL and MySQL versions. The AnalyticDB for MySQL is a real-time data warehousing service that can process petabytes of data with high concurrency and low latency. It is fully compatible with the MySQL protocol and SQL:2003 syntax. It is It was developed by Alibaba.


Difference between Adabas and Alibaba Cloud AnalyticDB for MySQL :

S.NO. ADABAS< Alibaba Cloud AnalyticDB for MySQL
1. It was developed by Software AG in 1971. It was developed by Alibaba in 2018.
2. It is an OLTP-DBMS for mainframes and Linux/Unix/Windows environments. It is a real-time data warehousing service that can process petabytes of data with high concurrency and low latency.
3. It does not support in-memory capabilities. It supports in-memory capabilities.
4. Server operating systems for Adabas are BS2000, Linux, Unix, Windows, z/OS and z/VSE. In Alibaba Cloud AnalyticDB for MySQL there are Hosted server operating systems.
5. It does not support XML Format. It also does not support 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 MySQL 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 MySQL is also commercial.
12. The primary database model of Adabas is Multivalue DBMS. The primary database model of AnalyticDB for MySQL 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.


Last Updated : 23 Jun, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads