Skip to content
Related Articles
Open in App
Not now

Related Articles

Difference between Adabas and AlaSQL

Improve Article
Save Article
  • Last Updated : 23 Jun, 2020
Improve Article
Save Article

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 :

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.

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!