DB-EnginesExtremeDB: is hard real time possible with a dbms?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Amazon Aurora vs. Apache Drill vs. SWC-DB

System Properties Comparison Adabas vs. Amazon Aurora vs. Apache Drill vs. SWC-DB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonAmazon Aurora  Xexclude from comparisonApache Drill  Xexclude from comparisonSWC-DB infoSuper Wide Column Database  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformMySQL and PostgreSQL compatible cloud service by AmazonSchema-free SQL Query Engine for Hadoop, NoSQL and Cloud StorageA high performance, scalable Wide Column DBMS
Primary database modelMultivalue DBMSRelational DBMSDocument store
Relational DBMS
Wide column store
Secondary database modelsDocument storeTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.74
Rank#77  Overall
#1  Multivalue DBMS
Score11.74
Rank#45  Overall
#29  Relational DBMS
Score2.73
Rank#105  Overall
#19  Document stores
#54  Relational DBMS
Score0.09
Rank#309  Overall
#13  Wide column stores
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlaws.amazon.com/­rds/­auroradrill.apache.orggithub.com/­kashirin-alex/­swc-db
www.swcdb.org
Technical documentationdocs.aws.amazon.com/­AmazonRDS/­latest/­AuroraUserGuide/­CHAP_Aurora.htmldrill.apache.org/­docs
DeveloperSoftware AGAmazonApache Software FoundationAlex Kashirin
Initial release1971201520122020
Current release1.19.0, June 20210.5, April 2021
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache Version 2Open Source infoGPL V3
Cloud-based only infoOnly available as a cloud servicenoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
hostedLinux
OS X
Windows
Linux
Data schemeyesyesschema-freeschema-free
Typing infopredefined data types such as float or dateyesyesyes
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.noyesnono
Secondary indexesyesyesno
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewayyesSQL SELECT statement is SQL:2003 compliantSQL-like query language
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
JDBC
ODBC
JDBC
ODBC
RESTful HTTP API
Proprietary protocol
Thrift
Supported programming languagesNaturalAda
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
C++C++
Server-side scripts infoStored proceduresin Naturalyesuser defined functionsno
Triggersnoyesnono
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas Vistahorizontal partitioningShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatorSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencynoneImmediate Consistency
Foreign keys infoReferential integritynoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesDepending on the underlying data sourceyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesDepending on the underlying data sourceno
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)fine grained access rights according to SQL-standardDepending on the underlying data source

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"Amazon AuroraApache DrillSWC-DB infoSuper Wide Column Database
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

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

show all

Recent citations in the news

Amazon RDS Introduces Readable Standby Instances in Multi-AZ Deployments
1 January 2022, InfoQ.com

Randall Hunt joins Caylent as VP of Cloud Strategy & Solutions
26 January 2022, PRNewswire

Amazon Aurora Supports MySQL 8.0
28 November 2021, InfoQ.com

Amazon Aurora Supports PostgreSQL 13
5 September 2021, InfoQ.com

Cloudflare Introduces Support for Relational Database Connections Through Workers
20 January 2022, InfoQ.com

provided by Google News

Apache Drill improves big data SQL query engine
31 August 2021, TechTarget

Apache Drill Poised to Crack Tough Data Challenges
19 May 2015, Datanami

MapR Advances Support for Flexible and High Performance Analytics on JSON and S3 Data with Apache Drill
30 January 2019, Business Wire

Apache Drill Adds YARN Support
17 April 2018, iProgrammer

Google’s Real Time Big Data Tool Cloned By Apache Drill
17 August 2012, TechCrunch

provided by Google News

Job opportunities

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

ADABAS Natural Programmer
Evurge Solutions, Remote

Natural / Adabas Software Developer
ABB, Memphis, TN

Adabas Database Administrator
DMI, Remote

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

Software Development Manager - Amazon Aurora, Aurora
Amazon.com Services LLC, East Palo Alto, CA

SDE - AWS Aurora
Amazon Web Services, Inc., Seattle, WA

Performance Engineer, Amazon Aurora
Amazon Dev Center U.S., Inc., East Palo Alto, CA

Senior Database Administrator - Aurora - PostgreSQL
Zotec Partners, Remote

Principal Product Manager-Tech, Amazon Aurora
Amazon Dev Center U.S., Inc., Seattle, WA

Big Data/SQL Developer
LPL Financial, South Carolina

Software Engineer (Back-end and Full-stack Development)
Concourse Labs, Texas

Senior Architect/Software Engineer (Back-end and Full-stack Development)
Concourse Labs, Texas

jobs by Indeed



Share this page

Featured Products

AllegroGraph logo

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

Couchbase logo

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

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.

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here