Open In App

Difference between Adabas and AlaSQL

Improve
Improve
Like Article
Like
Save
Share
Report

1. Adabas :
The Adabas stands for an Adaptable Database System. 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. AlaSQL :
AlaSQL is a lightweight client-side in-memory SQL database designed to work in browser and Node.js. It is a free and open-source SQL database for Javascript with a strong focus on query speed and data source flexibility for relational data, schemaless data, and graph data. It is developed by Andrey Gershun Mathias R. Wulff in the year 2014.


Difference between Adabas and AlaSQL :

S.NO. ADABAS ALASQL
1. It was developed By Software AG in 1971. It was developed By Andrey Gershun Mathias R. Wulff in 2014.
2. It is an OLTP-DBMS for mainframes and Linux/Unix/Windows environments. It is a JavaScript DBMS library.
3. Adabas is written in Natural language. AlaSQL is written in JavaScript language.
4. Server operating systems for Adabas are BS2000, Linux, Unix, Windows, z/OS and z/VSE. It is a server-less and requires a JavaScript environment.
5. It does not support XML Format. It also does not support XML Format.
6. Server-side scripting is done in Natural language. It does not support the server-side scripting.
7. It supports partitioning methods. It does not support partitioning methods.
8. It supports SQL query language with add-on product Adabas SQL Gateway. It also supports SQL query language but no user access control, stored procedures and host language bindings.
9. It supports Replication with add-on product Event Replicator. It does not support any replication methods.
10. Adabas does not provide the concept of Referential Integrity. Hence, no Foreign Keys. AlaSQL provides the concept of Referential Integrity. Hence, there are Foreign Keys.
11. The license of Adabas is commercial. The license of AlaSQL is open-source.
12. The primary database model of Adabas is Multivalue DBMS. The primary database models of AlaSQL are Document Store and Relational DBMS.
13. It does not support in-memory capabilities. It supports in-memory capabilities.


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