DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Amazon Redshift vs. Google Cloud Datastore vs. Microsoft Azure Synapse Analytics vs. Spark SQL

System Properties Comparison Adabas vs. Amazon Redshift vs. Google Cloud Datastore vs. Microsoft Azure Synapse Analytics vs. Spark SQL

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonAmazon Redshift  Xexclude from comparisonGoogle Cloud Datastore  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonSpark SQL  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformLarge scale data warehouse service for use with business intelligence toolsAutomatically scaling NoSQL Database as a Service (DBaaS) on the Google Cloud PlatformElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerSpark SQL is a component on top of 'Spark Core' for structured data processing
Primary database modelMultivalue DBMSRelational DBMSDocument storeRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.74
Rank#77  Overall
#1  Multivalue DBMS
Score25.85
Rank#31  Overall
#18  Relational DBMS
Score4.84
Rank#76  Overall
#11  Document stores
Score18.49
Rank#38  Overall
#23  Relational DBMS
Score22.94
Rank#34  Overall
#20  Relational DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlaws.amazon.com/­redshiftcloud.google.com/­datastoreazure.microsoft.com/­services/­synapse-analyticsspark.apache.org/­sql
Technical documentationdocs.aws.amazon.com/­redshiftcloud.google.com/­datastore/­docsdocs.microsoft.com/­azure/­synapse-analyticsspark.apache.org/­docs/­latest/­sql-programming-guide.html
DeveloperSoftware AGAmazon (based on PostgreSQL)GoogleMicrosoftApache Software Foundation
Initial release19712012200820162014
Current release3.2.0, October 2021
License infoCommercial or Open SourcecommercialcommercialcommercialcommercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenoyesyesyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC++Scala
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
hostedhostedhostedLinux
OS X
Windows
Data schemeyesyesschema-freeyesyes
Typing infopredefined data types such as float or dateyesyesyes, details hereyesyes
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.nonononono
Secondary indexesyesrestrictedyesyesno
SQL infoSupport of SQLyes infowith add-on product Adabas SQL Gatewayyes infodoes not fully support an SQL-standardSQL-like query language (GQL)yesSQL-like DML and DDL statements
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
JDBC
ODBC
gRPC (using protocol buffers) API
RESTful HTTP/JSON API
ADO.NET
JDBC
ODBC
JDBC
ODBC
Supported programming languagesNaturalAll languages supporting JDBC/ODBC.Net
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
C#
Java
PHP
Java
Python
R
Scala
Server-side scripts infoStored proceduresin Naturaluser defined functions infoin Pythonusing Google App EngineTransact SQLno
TriggersnonoCallbacks using the Google Apps Enginenono
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistaShardingShardingSharding, horizontal partitioningyes, utilizing Spark Core
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatoryesMulti-source replication using Paxosyesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infousing Google Cloud Dataflowno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate 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 Consistency
Foreign keys infoReferential integritynoyes infoinformational only, not enforced by the systemyes infovia ReferenceProperties or Ancestor pathsno infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID infoSerializable Isolation within Transactions, Read Committed outside of TransactionsACIDno
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.noyesnono
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)fine grained access rights according to SQL-standardAccess rights for users, groups and roles based on Google Cloud Identity and Access Management (IAM)yesno

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
3rd partiesDBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more
SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

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"Amazon RedshiftGoogle Cloud DatastoreMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseSpark SQL
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Recent citations in the news

Astadia Poised for Record Growth as Positive Momentum Continues for the Mainframe to Cloud Sector
12 January 2022, Yahoo Finance

Software AG says it has turned the corner in shift to a subscription business
21 July 2021, SiliconANGLE News

Astadia Migration Factory to Reduce the Duration of Mainframe to AWS Migrations by up to 90%
30 November 2021, Business Wire

Silver Lake Invests $388 Million in Germany's Software AG
14 December 2021, Bloomberg

Software AG Draws Interest From CVC, Silver Lake, Thoma Bravo
3 December 2021, swissinfo.ch

provided by Google News

Serverless at re:Invent: Where should Amazon Redshift go?
6 December 2021, ZDNet

AWS Introduces Amazon Redshift Serverless
1 December 2021, InfoQ.com

Location, location, location: how the cloud handles geospatial data
4 January 2022, The Register

Continual raises $4M for its AI-powered data platform
16 December 2021, TechCrunch

The 10 Major Players in Cloud Database Management Systems, 2021
10 January 2022, Solutions Review

provided by Google News

Eureka emerges from stealth to secure cloud data stores with automation
12 January 2022, VentureBeat

How IIoT is Used by MachineMax, TIER Mobility, Bühler Group, Augury, and Port of Rotterdam: Case Studies
3 January 2022, Datamation

5 Channel Partner Program and MSP News Updates: 12 January 2022
12 January 2022, ChannelE2E

What's Changed: 2021 Gartner Magic Quadrant for Cloud Database Management Systems
13 January 2022, Solutions Review

The Basics of Serverless User Authentication
3 January 2022, Container Journal

provided by Google News

Microsoft Open-Sources Distributed Machine Learning Library SynapseML
28 December 2021, InfoQ.com

What's Microsoft's Play With Customer Experience Platform?
13 January 2022, CMSWire

Top 5 elements needed for a successful data warehouse
30 December 2021, TechTarget

At Ignite, Microsoft enhances its cloud database, warehouse and lake services
2 November 2021, ZDNet

5 Steps to Connect Business Intelligence to IoT Solutions
11 January 2022, IoT For All

provided by Google News

spark sql vs spark dataframe performance
8 April 2021, Newstime Africa

pyspark create dataframe from another dataframe
8 April 2021, Newstime Africa

Using Python for data engineering
14 January 2022, Technology Decisions

Top 10 Big Data Analytics Courses to Elevate Your Career in 2022
12 January 2022, Analytics Insight

Spark Gets Closer Hooks to Pandas, SQL with Version 3.2
26 October 2021, Datanami

provided by Google News

Job opportunities

Adabas Database Administrator
DMI, Remote

Mainframe Developer - Natural / ADABAS | Richmond, VA (Will be remote during Covid)
Apexon, Richmond, VA

Adabas Natural Programmer Analyst
Peer Solutions Group, Columbia, SC

Mainframe Developer
NYC Careers, Manhattan, NY

ADABAS NATURAL Programmer
Peer Solutions Group, Columbia, SC

Software Development Engineer - Amazon Redshift Query Processing, Query Processing
Amazon.com Services LLC, Boston, MA

Sr. Customer Success Engineer, Amazon Redshift Service
Amazon Dev Center U.S., Inc., Remote

Amazon Redshift - Software Development Engineer
Amazon.com Services LLC, East Palo Alto, CA

Applied Scientist - Amazon Redshift
Amazon Web Services, Inc., East Palo Alto, CA

Associate Professional Services
Amazon Web Services, Inc., Dallas, TX

Engineering Manager, Google Cloud Platform
Google, Mountain View, CA

Software Engineer - Core Data
Canva, Remote

Talent Acquisition
Altirnao, Paris, OR

Business Intelligence Analyst
CBT Nuggets, Eugene, OR

Cloud Engineer (US)
Redbrick Technologies Inc., Minneapolis, MN

Azure Data & AI Digital Sales Representative ( Synapse)
Microsoft, Atlanta, GA

Project Manager
Cognizant Technology Solutions, Advance, NC

Product Manager - Endpoint Security
Costco Wholesale, Seattle, WA

Support Engineer - Azure Synapse
Microsoft, Issaquah, WA

Software Engineer
Microsoft, Austin, TX

Healthcare Data Analyst - MedInsight
Milliman, Brookfield, WI

Process Manager
Capital One - US, Richmond, VA

Data Scientist
Ford Motor Company, Dearborn, MI

Associate Data Lake Consultant
Amazon Web Services, Inc., New York, NY

Data Scientist II – Hybrid remote work location for WI and IL residents
UW Health, Madison, WI

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here