DB-EnginesCrateDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Spark SQL

System Properties Comparison Adabas vs. Spark SQL

Please select another system to include it in the comparison.

Our visitors often compare Adabas and Spark SQL with Oracle, Microsoft SQL Server and IBM Db2.

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonSpark SQL  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformSpark SQL is a component on top of 'Spark Core' for structured data processing
Primary database modelMultivalue DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.33
Rank#69  Overall
#1  Multivalue DBMS
Score16.76
Rank#35  Overall
#21  Relational DBMS
Websitewww.softwareag.com/­corporate/­products/­adabas_natural/­adabas/­default.htmlspark.apache.org/­sql
Technical documentationspark.apache.org/­docs/­latest/­sql-programming-guide.html
DeveloperSoftware AGApache Software Foundation
Initial release19712014
Current releasev2.4.3, May 2019
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageScala
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
Linux
OS X
Windows
Data schemeyesyes
Typing infopredefined data types such as float or dateyesyes
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.nono
Secondary indexesyesno
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewaySQL-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
Supported programming languagesNaturalJava
Python
R
Scala
Server-side scripts infoStored proceduresin Naturalno
Triggersnono
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas Vistayes, utilizing Spark Core
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event Replicatornone
MapReduce infoOffers an API for user-defined Map/Reduce methodsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integritynono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno
Concurrency infoSupport for concurrent manipulation of datayesyes
Durability infoSupport for making data persistentyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)no

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"Spark SQL
Conferences and events

Spark Summit Europe 2019
Amsterdam, Netherlands, 15-17 October 2019

Recent citations in the news

Software AG (OTCMKTS:STWRY) Given Consensus Rating of “Hold” by Analysts
17 July 2019, Mayfield Recorder

Barclays Analysts Give Software (ETR:SOW) a €33.50 Price Target
17 July 2019, Slater Sentinel

Software AG (ETR:SOW) Receives €38.41 Average PT from Brokerages
15 July 2019, Riverton Roll

Software (OTCMKTS:STWRY) Stock Rating Reaffirmed by DZ Bank
11 July 2019, Mayfield Recorder

Software (OTCMKTS:STWRY) Receives Buy Rating from DZ Bank
5 July 2019, Riverton Roll

provided by Google News

Dagster Emerges to Simplify Data App Development
16 July 2019, Datanami

Have Your Say On .NET For Spark
5 July 2019, iProgrammer

A Decade Later, Apache Spark Still Going Strong
8 March 2019, Datanami

Delta Lake gives Apache Spark data sets new powers
24 April 2019, InfoWorld

High-performance data processing technology through a new database partitioning method
3 June 2019, EurekAlert

provided by Google News

Job opportunities

Mainframe Applications Support (Journey Level - IT App Development)
State of Washington Dept. of Transportation, Tumwater, WA

Data Analyst
Central Hudson Gas & Electric Corporation, Poughkeepsie, NY

Junior Software Engineer
Software AG, Denver, CO

SENIOR ARCHITECT, STUDENT INFORMATION SYSTEMS, IS&T Applications
Boston University, Boston, MA

Senior Systems Engineer- Pre-Sales
Software AG Government Solutions, Herndon, VA

Big Data Software Engineer
JP Morgan Chase, Chicago, IL

Principal Big Data Software Engineer
Zscaler, San Jose, CA

Database Software Developer
CGG, Houston, TX

Senior Graph Database Developer
GEICO, Chevy Chase, MD

Data Developer
Moody's Analytics, New York, NY

jobs by Indeed




Share this page

Featured Products

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

AllegroGraph logo

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

Redis logo

Start now with Redis Cloud
Secure, highly available Redis as a serverless, hosted, fully managed cloud service.
Sign up here.

Present your product here