DB-EnginesextremeDB - solve IoT connectivity disruptionsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Adabas vs. AlaSQL vs. ArangoDB vs. Informix vs. SAP Advantage Database Server

System Properties Comparison Adabas vs. AlaSQL vs. ArangoDB vs. Informix vs. SAP Advantage Database Server

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonAlaSQL  Xexclude from comparisonArangoDB  Xexclude from comparisonInformix  Xexclude from comparisonSAP Advantage Database Server infoformer name: Sybase ADS  Xexclude from comparison
SAP Advantage Database Server seems to be discontinued. Therefore it is excluded from the DB-Engines Ranking.
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformJavaScript DBMS libraryNative multi-model DBMS for graph, document, key/value and search. All in one engine and accessible with one query language.A secure embeddable database from IBM, positioned besides IBM Db2 as a relatively low-cost product optimized for OLTP and Internet of Things dataLow-cost RDBMS with access to ISAM and FoxPro data structures
Primary database modelMultivalue DBMSDocument store
Relational DBMS
Document store
Graph DBMS
Key-value store
Search engine
Relational DBMS infoSince Version 12.10 support for JSON/BSON datatypes compatible with MongoDBRelational DBMS
Secondary database modelsDocument store
Spatial DBMS
Time Series DBMS infowith Informix TimeSeries Extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.86
Rank#89  Overall
#1  Multivalue DBMS
Score0.35
Rank#268  Overall
#42  Document stores
#123  Relational DBMS
Score2.91
Rank#86  Overall
#15  Document stores
#5  Graph DBMS
#12  Key-value stores
#10  Search engines
Score15.47
Rank#36  Overall
#21  Relational DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlalasql.orgarangodb.comwww.ibm.com/­products/­informixwww.sap.com/products/advantage-database-server.html
Technical documentationgithub.com/­AlaSQL/­alasqldocs.arangodb.cominformix.hcldoc.com
www.ibm.com/­support/­knowledgecenter/­SSGU8G/­welcomeIfxServers.html
DeveloperSoftware AGAndrey Gershun & Mathias R. WulffArangoDB Inc.IBM, HCL Technologies infoEffective May 1st, 2017, HCL took on development, technical support, and product management teams, and works jointly with IBM on product strategy, marketing, and sales.Sybase, SAP
Initial release19712014201219841993
Current release3.11.5, November 202314.10.FC5, November 2020
License infoCommercial or Open SourcecommercialOpen Source infoMIT-LicenseOpen Source infoApache Version 2; Commercial license (Enterprise) availablecommercial infofree developer edition availablecommercial
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScriptC++C, C++ and Java
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
server-less, requires a JavaScript environment (browser, Node.js)Linux
OS X
Windows
AIX
HP-UX
Linux
macOS
Solaris
Windows
Linux
Windows
Data schemeyesschema-freeschema-free infoautomatically recognizes schema within a collectionyesyes
Typing infopredefined data types such as float or dateyesnoyes infostring, double, boolean, list, hashyes infoSince Version 12.10 support for JSON/BSON datatypesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono
Secondary indexesyesnoyesyesyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewayClose to SQL99, but no user access control, stored procedures and host language bindings.noyesyes
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
JavaScript APIAQL
Foxx Framework
Graph API (Gremlin)
GraphQL query language
HTTP API
Java & SpringData
JSON style queries
VelocyPack/VelocyStream
JDBC
JSON API infoMongoDB compatible
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
.NET Client API
ADO.NET
JDBC
ODBC
OLE DB
Supported programming languagesNaturalJavaScriptC#
C++
Clojure
Elixir
Go
Java
JavaScript (Node.js)
PHP
Python
R
Rust
.Net
C
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
Delphi
Perl
PHP
Server-side scripts infoStored proceduresin NaturalnoJavaScriptyesyes
Triggersnoyesnoyesyes
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistanoneSharding infosince version 2.0Shardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatornoneSource-replica replication with configurable replication factorMulti-source replication
Source-replica replication
Multi-source replication infoCONFLICT Trigger to resolve replication conflicts
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono infocan be done with stored procedures in JavaScriptnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencynoneEventual Consistency infoconfigurable per collection or per write
Immediate Consistency
OneShard (highly available, fault-tolerant deployment mode with ACID semantics)
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyes inforelationships in graphsyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDyes infoonly for local storage and DOM-storageACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyesno infocaching of (temporary) tables can be configured
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)noyesUsers with fine-grained authentication, authorization, and auditing controlsfine grained access rights according to SQL-standard
More information provided by the system vendor
Adabas infodenotes "adaptable data base"AlaSQLArangoDBInformixSAP Advantage Database Server infoformer name: Sybase ADS
Specific characteristicsGraph and Beyond. With more than 11,000 stargazers on GitHub, ArangoDB is the leading...
» more
Competitive advantagesConsolidation: As a native multi-model database, can be used as a full blown document...
» more
Typical application scenariosNative multi-model in ArangoDB is being used for a broad range of projects across...
» more
Key customersCisco, Barclays, Refinitive, Siemens Mentor, Kabbage, Liaison, Douglas, MakeMyTrip,...
» more
Market metricsArangoDB is the leading native multi-model database with over 11,000 stargazers on...
» more
Licensing and pricing modelsVery permissive Apache 2 License for Community Edition & commercial licenses are...
» more

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Adabas infodenotes "adaptable data base"AlaSQLArangoDBInformixSAP Advantage Database Server infoformer name: Sybase ADS
DB-Engines blog posts

The Weight of Relational Databases: Time for Multi-Model?
29 August 2017, Luca Olivari (guest author)

show all

Recent citations in the news

Modernize Natural and Adabas Workloads on AWS with IBM ModernSystems accelerator | Amazon Web Services
27 January 2025, AWS Blog

Software AG retrenches to its core ARIS process management and A&N mainframe tools
8 January 2025, diginomica

Re-evaluating legacy: Should you leave Adabas (and Natural) behind?
30 May 2024, ITWeb

Software AG: Pioneering process management solutions
15 May 2024, SiliconANGLE News

IBM buys 50-year-old Software AG's enterprise tech units for €2.13B in cash
18 December 2023, The Register

provided by Google News

Scrape any Website/Service/API with a single SQL Select Statement
18 January 2017, hackernoon.com

provided by Google News

ArangoDB raises $10 million for NoSQL database management
14 March 2019, VentureBeat

Here's the pitch deck a German software startup used to raise $10 million to move to San Francisco and take on Oracle
23 June 2019, Business Insider

ArangoDB 3.5 update improves multi-model database platform
22 August 2019, TechTarget

How to Build Knowledge Graph Enhanced Chatbot with ChatGPT and ArangoDB
30 June 2023, DataDrivenInvestor

fastgraphml: A Low-code framework to accelerate the Graph Machine Learning model development...
15 November 2022, Towards Data Science

provided by Google News

Unlock the value of your Informix data for advanced analytics and AI with watsonx.data
24 April 2024, IBM

Migrate an Informix database to Amazon Aurora PostgreSQL using CData Connect Cloud from within AWS Glue Studio
8 June 2023, AWS Blog

IBM Informix review: What you need to know about the software
12 December 2022, TechRepublic

IBM Informix: A key part of IBM’s hybrid cloud and AI strategy
11 January 2024, IBM

IBM Informix Database in the Cloud
1 May 2009, AWS Blog

provided by Google News

SAP Slams Oracle's Ad Tactics, Calls Rival's Campaign Imitative
26 July 2004, The Wall Street Journal

SAP Announces Q3 2023 Results: Asia Pacific and Japan View
19 October 2023, SAP News

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here