DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Faircom DB vs. FatDB vs. IBM Cloudant vs. Yaacomo

System Properties Comparison Adabas vs. Faircom DB vs. FatDB vs. IBM Cloudant vs. Yaacomo

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonFaircom DB infoformerly c-treeACE  Xexclude from comparisonFatDB  Xexclude from comparisonIBM Cloudant  Xexclude from comparisonYaacomo  Xexclude from comparison
FatDB/FatCloud has ceased operations as a company with February 2014. FatDB is discontinued and excluded from the ranking.Yaacomo seems to be discontinued and is removed from the DB-Engines ranking
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformNative high-speed multi-model DBMS for relational and key-value store data simultaneously accessible through SQL and NoSQL APIs.A .NET NoSQL DBMS that can integrate with and extend SQL Server.Database as a Service offering based on Apache CouchDBOpenCL based in-memory RDBMS, designed for efficiently utilizing the hardware via parallel computing
Primary database modelMultivalue DBMSKey-value store
Relational DBMS
Document store
Key-value store
Document storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.79
Rank#102  Overall
#2  Multivalue DBMS
Score0.29
Rank#304  Overall
#43  Key-value stores
#136  Relational DBMS
Score2.75
Rank#104  Overall
#19  Document stores
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlwww.faircom.com/­products/­faircom-dbwww.ibm.com/­products/­cloudantyaacomo.com
Technical documentationdocs.faircom.com/­docs/­en/­UUID-7446ae34-a1a7-c843-c894-d5322e395184.htmlcloud.ibm.com/­docs/­Cloudant
DeveloperSoftware AGFairCom CorporationFatCloudIBM, Apache Software Foundation infoIBM acquired Cloudant in February 2014Q2WEB GmbH
Initial release19711979201220102009
Current releaseV12, November 2020
License infoCommercial or Open Sourcecommercialcommercial infoRestricted, free version availablecommercialcommercialcommercial
Cloud-based only infoOnly available as a cloud servicenononoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageANSI C, C++C#Erlang
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
AIX
FreeBSD
HP-UX
Linux
NetBSD
OS X
QNX
SCO
Solaris
VxWorks
Windows infoeasily portable to other OSs
WindowshostedAndroid
Linux
Windows
Data schemeyesschema free, schema optional, schema required, partial schema,schema-freeschema-freeyes
Typing infopredefined data types such as float or dateyesyes, ANSI SQL Types, JSON, typed binary structuresyesnoyes
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.nononono
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL Gatewayyes, ANSI SQL with proprietary extensionsno infoVia inetgration in SQL Servernoyes
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
ADO.NET
Direct SQL
JDBC
JPA
ODBC
RESTful HTTP/JSON API
RESTful MQTT/JSON API
RPC
.NET Client API
LINQ
RESTful HTTP API
RPC
Windows WCF Bindings
RESTful HTTP/JSON APIJDBC
ODBC
Supported programming languagesNatural.Net
C
C#
C++
Java
JavaScript (Node.js and browser)
PHP
Python
Visual Basic
C#C#
Java
JavaScript
Objective-C
PHP
Ruby
Server-side scripts infoStored proceduresin Naturalyes info.Net, JavaScript, C/C++yes infovia applicationsView functions (Map-Reduce) in JavaScript
Triggersnoyesyes infovia applicationsyesyes
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistaFile partitioning, horizontal partitioning, sharding infoCustomizable business rules for table partitioningShardingShardinghorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event Replicatoryes, configurable to be parallel or serial, synchronous or asynchronous, uni-directional or bi-directional, ACID-consistent or eventually consistent (with custom conflict resolution).selectable replication factorMulti-source replication
Source-replica replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency
Tunable consistency per server, database, table, and transaction
Eventual Consistency
Immediate Consistency
Eventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDtunable from ACID to Eventually Consistentnono infoatomic operations within a document possibleACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes infoOptimistic lockingyes
Durability infoSupport for making data persistentyesYes, tunable from durable to delayed durability to in-memoryyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesnoyes
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Fine grained access rights according to SQL-standard with additional protections for filesno infoCan implement custom security layer via applicationsAccess rights for users can be defined per databasefine grained access rights according to SQL-standard

More information provided by the system vendor

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"Faircom DB infoformerly c-treeACEFatDBIBM CloudantYaacomo
Recent citations in the news

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

State agency proves DevOps and mainframes can coexist
12 April 2024, SiliconANGLE News

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

Michael E. Jakes Obituary (1941 - 2023)
26 October 2023, Legacy.com

Is it the end of the road for Software AG after selling its integration business to IBM?
12 January 2024, diginomica

provided by Google News

FairCom Unveils New Look, FairCom DB v13: Introducing 'DB Made Simple'
4 June 2024, Business Wire

FairCom kicks off new era of database technology USA - English
10 November 2020, PR Newswire

provided by Google News

Cloudant Best (and Worst) Practices — Part 1
18 March 2019, IBM

Intro to Enterprise Cloud Storage: How to Set Up a Cloudant Database
1 December 2014, Linux.com

IBM Expands Cloud Database Services with Kubernetes
26 September 2019, EnterpriseAI

IBM Code Engine and IBM Cloudant: Serverless Data and Infrastructure
16 August 2021, IBM

IBM to Purchase Cloudant Database as a service (DBaaS) Provider
22 March 2014, App Developer Magazine

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus 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