DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Google Cloud Datastore vs. HEAVY.AI vs. IBM Db2 vs. SAP Advantage Database Server

System Properties Comparison Adabas vs. Google Cloud Datastore vs. HEAVY.AI vs. IBM Db2 vs. SAP Advantage Database Server

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonGoogle Cloud Datastore  Xexclude from comparisonHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022  Xexclude from comparisonIBM Db2 infoformerly named DB2 or IBM Database 2  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 platformAutomatically scaling NoSQL Database as a Service (DBaaS) on the Google Cloud PlatformA high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardwareCommon in IBM host environments, 2 different versions for host and Windows/LinuxLow-cost RDBMS with access to ISAM and FoxPro data structures
Primary database modelMultivalue DBMSDocument storeRelational DBMSRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDBRelational DBMS
Secondary database modelsSpatial DBMSDocument store
RDF store infoin Db2 LUW (Linux, Unix, Windows)
Spatial DBMS infowith Db2 Spatial Extender
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.79
Rank#102  Overall
#2  Multivalue DBMS
Score4.36
Rank#72  Overall
#12  Document stores
Score1.64
Rank#145  Overall
#67  Relational DBMS
Score125.90
Rank#9  Overall
#6  Relational DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlcloud.google.com/­datastoregithub.com/­heavyai/­heavydb
www.heavy.ai
www.ibm.com/­products/­db2www.sap.com/products/advantage-database-server.html
Technical documentationcloud.google.com/­datastore/­docsdocs.heavy.aiwww.ibm.com/­docs/­en/­db2
DeveloperSoftware AGGoogleHEAVY.AI, Inc.IBMSybase, SAP
Initial release1971200820161983 infohost version1993
Current release5.10, January 202212.1, October 2016
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache Version 2; enterprise edition availablecommercial infofree version is availablecommercial
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++ and CUDAC and C++
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
hostedLinuxAIX
HP-UX
Linux
Solaris
Windows
z/OS
Linux
Windows
Data schemeyesschema-freeyesyesyes
Typing infopredefined data types such as float or dateyesyes, details hereyesyesyes
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 indexesyesyesnoyesyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewaySQL-like query language (GQL)yesyesyes
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
gRPC (using protocol buffers) API
RESTful HTTP/JSON API
JDBC
ODBC
Thrift
Vega
ADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
.NET Client API
ADO.NET
JDBC
ODBC
OLE DB
Supported programming languagesNatural.Net
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
All languages supporting JDBC/ODBC/Thrift
Python
C
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
Delphi
Perl
PHP
Server-side scripts infoStored proceduresin Naturalusing Google App Enginenoyesyes
TriggersnoCallbacks using the Google Apps Enginenoyesyes
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistaShardingSharding infoRound robinSharding infoonly with Windows/Unix/Linux Versionnone
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatorMulti-source replication using PaxosMulti-source replicationyes infowith separate tools (MQ, InfoSphere)Multi-source replication infoCONFLICT Trigger to resolve replication conflicts
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infousing Google Cloud Dataflownonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on type of query and configuration infoStrong Consistency is default for entity lookups and queries within an Entity Group (but can instead be made eventually consistent). Other queries are always eventual consistent.Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyes infovia ReferenceProperties or Ancestor pathsnoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infoSerializable Isolation within Transactions, Read Committed outside of TransactionsnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyesno infocaching of (temporary) tables can be configured
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Access rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)fine grained access rights according to SQL-standardfine grained access rights according to SQL-standardfine 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"Google Cloud DatastoreHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022IBM Db2 infoformerly named DB2 or IBM Database 2SAP Advantage Database Server infoformer name: Sybase ADS
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

Google Cloud Platform: Professional Data Engineer certification prep
11 June 2024, oreilly.com

Google Cloud Stops Exit Fees
12 January 2024, Spiceworks News and Insights

Best cloud storage of 2024
4 June 2024, TechRadar

BigID Data Intelligence Platform Now Available on Google Cloud Marketplace
6 November 2023, PR Newswire

Google says it'll stop charging fees to transfer data out of Google Cloud
11 January 2024, TechCrunch

provided by Google News

HEAVY.AI Launches HEAVY 7.0, Introducing Real-Time Machine Learning Capabilities
19 April 2023, businesswire.com

Big Data Analytics: A Game Changer for Infrastructure
13 July 2023, Spiceworks News and Insights

HEAVY.AI Partners with Bain, Maxar, and Nvidia to Provide Digital Twins for Telecom Networks
16 February 2023, Datanami

Making the most of geospatial intelligence
14 April 2023, InfoWorld

The insideBIGDATA IMPACT 50 List for Q4 2023
11 October 2023, insideBIGDATA

provided by Google News

Infotel Returns to IDUG North America 2024 in Charlotte to Showcase Latest Db2 Solutions and Feature Presentation ...
13 June 2024, PR Web

Use AWS DMS to migrate data from IBM Db2 DPF to an AWS target | Amazon Web Services
28 May 2024, AWS Blog

IBM Collaborates with AWS to Launch a New Cloud Database Offering, Enabling Customers to Optimize Data ...
27 November 2023, IBM Newsroom

IBM's vintage Db2 database jumps on AWS's cloud bandwagon
29 November 2023, The Register

Precisely Supports Amazon RDS for Db2 Service with Real-Time Data Integration Capabilities
3 April 2024, precisely.com

provided by Google News

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

provided by Google News



Share this page

Featured Products

Milvus logo

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

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

Neo4j logo

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

Present your product here