DBMS > Adabas vs. Amazon Redshift vs. Datomic vs. MySQL vs. RethinkDB
System Properties Comparison Adabas vs. Amazon Redshift vs. Datomic vs. MySQL vs. RethinkDB
| Editorial information provided by DB-Engines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name | Adabas  denotes "adaptable data base" Xexclude from comparison | Amazon Redshift Xexclude from comparison | Datomic Xexclude from comparison | MySQL Xexclude from comparison | RethinkDB Xexclude from comparison | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Description | OLTP - DBMS for mainframes and Linux/Unix/Windows environments used typically together with the Natural programming platform | Large scale data warehouse service for use with business intelligence tools | Datomic builds on immutable values, supports point-in-time queries and uses 3rd party systems for durability | Widely used open source RDBMS | DBMS for the Web with a mechanism to push updated query results to applications in realtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Primary database model | Multivalue DBMS | Relational DBMS | Relational DBMS | Relational DBMS Key/Value like access via memcached API | Document store | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary database models | Document store | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Website | www.softwareag.com/en_corporate/platform/adabas-natural.html | aws.amazon.com/redshift | www.datomic.com | www.mysql.com | rethinkdb.com | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Technical documentation | docs.aws.amazon.com/redshift | docs.datomic.com | dev.mysql.com/doc | rethinkdb.com/docs | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Developer | Software AG | Amazon (based on PostgreSQL) | Cognitect | Oracle since 2010, originally MySQL AB, then Sun | The Linux Foundation since July 2017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Initial release | 1971 | 2012 | 2012 | 1995 | 2009 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Current release | 0.9.5951, July 2019 | 8.0.23 , January 2021 | 2.4.1, August 2020 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| License Commercial or Open Source | commercial | commercial | commercial limited edition free | Open Source GPL version 2. Commercial licenses with extended functionallity are available | Open Source Apache Version 2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Cloud-based only Only available as a cloud service | no | yes | no | no | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed. | ScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Implementation language | C | Java, Clojure | C and C++ | C++ | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Server operating systems | BS2000 Linux Unix Windows z/OS z/VSE | hosted | All OS with a Java VM | FreeBSD Linux OS X Solaris Windows | Linux OS X Windows | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data scheme | yes | yes | yes | yes | schema-free | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Typing predefined data types such as float or date | yes | yes | yes | yes | yes string, binary, float, bool, date, geometry | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT. | no | no | no | yes | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary indexes | yes | restricted | yes | yes | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQL Support of SQL | yes with add-on product Adabas SQL Gateway | yes does not fully support an SQL-standard | no | yes with proprietary extensions | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| APIs and other access methods | HTTP API with add-on software Adabas SOA Gateway SOAP-based API with add-on software Adabas SOA Gateway | JDBC ODBC | RESTful HTTP API | ADO.NET JDBC ODBC Proprietary native API | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Supported programming languages | Natural | All languages supporting JDBC/ODBC | Clojure Java | Ada C C# C++ D Delphi Eiffel Erlang Haskell Java JavaScript (Node.js) Objective-C OCaml Perl PHP Python Ruby Scheme Tcl | C community-supported driver C# community-supported driverC++ community-supported driverClojure community-supported driverDart community-supported driverErlang community-supported driverGo community-supported driverHaskell community-supported driverJava official driverJavaScript (Node.js) official driverLisp community-supported driverLua community-supported driverObjective-C community-supported driverPerl community-supported driverPHP community-supported driverPython official driverRuby official driverScala community-supported driver | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Server-side scripts Stored procedures | in Natural | user defined functions in Python | yes Transaction Functions | yes proprietary syntax | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Triggers | no | no | By using transaction functions | yes | Client-side triggers through changefeeds | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Partitioning methods Methods for storing different data on different nodes | yes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas Vista | Sharding | none But extensive use of caching in the application peers | horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric | Sharding range based | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Replication methods Methods for redundantly storing data on multiple nodes | yes, with add-on product Event Replicator | yes | none But extensive use of caching in the application peers | Multi-source replication Source-replica replication | Source-replica replication | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| MapReduce Offers an API for user-defined Map/Reduce methods | no | no | no | no | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Consistency concepts Methods to ensure consistency in a distributed system | Immediate Consistency | Immediate Consistency | Immediate Consistency | Immediate Consistency | Immediate Consistency | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Foreign keys Referential integrity | no | yes informational only, not enforced by the system | no | yes not for MyISAM storage engine | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transaction concepts Support to ensure data integrity after non-atomic manipulations of data | ACID | ACID | ACID | ACID not for MyISAM storage engine | Atomic single-document operations | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Concurrency Support for concurrent manipulation of data | yes | yes | yes | yes table locks or row locks depending on storage engine | yes MVCC based | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Durability Support for making data persistent | yes | yes | yes using external storage systems (e.g. Cassandra, DynamoDB, PostgreSQL, Couchbase and others) | yes | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| In-memory capabilities Is there an option to define some or all structures to be held in-memory only. | no | yes | yes recommended only for testing and development | yes | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| User concepts Access control | only with OS-specific tools (e.g. IBM RACF, CA Top Secret) | fine grained access rights according to SQL-standard | no | Users with fine-grained authorization concept no user groups or roles | yes users and table-level permissions | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
More information provided by the system vendorWe invite representatives of system vendors to contact us for updating and extending the system information, | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Related products and services | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 3rd parties | CData: Connect to Big Data & NoSQL through standard Drivers. » more | General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products. » more Datadog: Improve MySQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards. » more ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure. » more CData: Connect to Big Data & NoSQL through standard Drivers. » more Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development. » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
We invite representatives of vendors of related products to contact us for presenting information about their offerings here. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| More resources | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Adabas denotes "adaptable data base" | Amazon Redshift | Datomic | MySQL | RethinkDB | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DB-Engines blog posts | Cloud-based DBMS's popularity grows at high rates The popularity of cloud-based DBMSs has increased tenfold in four years Increased popularity for consuming DBMS services out of the cloud | MySQL is the DBMS of the Year 2019 MariaDB strengthens its position in the open source RDBMS market The struggle for the hegemony in Oracle's database empire | Meet some database management systems you are likely to hear more about in the future Software AG Announces New “Adabas & Natural 2050” Agenda Software AG hits its Q2 mark as customers respond to accelerated change. We speak with CEO Sanjay Brahmawar Database Management Software Market Analysis Report by Product Type, Industry A Database Management Software Market 2021-2026 Strategical Assessment of IBM, SolarWinds, Oracle, SAP, Microsoft, Teradata, and more | Affluence – The Bisouv Network Air Force Looks to Modernize and Migrate Legacy Systems – MeriTalk provided by Google News The future of healthcare in the cloud Cloud Data Warehouse Performance Testing – Gigaom Immuta Announces Record Annual Growth and Rising Market Share in DataOps Technology Market AWS unveils three analytics capabilities to improve Amazon Redshift performance - Help Net Security Diyotta Launches AI Driven, Cloud Data Pipeline Platform for Enterprise Business provided by Google News Brazil's Nubank Acquires US Software Firm Cognitect Nubank buys firm behind Clojure programming language Latin American banking giant Nubank snaps up US software company Fintech Powerhouse Nubank Buys U.S. Software Firm Cognitect Datomic, a New Database System, Launches with Early Experience Program provided by Google News Global Relational Databases Software Market 2025: Microsoft, MySQL, Oracle, SAP, PostgreSQL, Amazon RDS, IBM, MariaDB, Informix, Teradata, SQLite – The Bisouv Network How To Set Up Redis as a Cache for MySQL with PHP on Ubuntu 20.04 Global Relational Databases Software Market 2021 – Microsoft, MySQL, Oracle, SAP, PostgreSQL – KSU | The Sentinel Newspaper MySQL Training Service Market 2021 by Companies: Oracle, Udemy, Pluralsight, Infopro Learning, Trainocate Holdings, Judge Learning Solutions Cloud Spanner Adds Support for Liquibase provided by Google News Global Open Source Software Market Insights Report 2021-2026 : Alfresco, Canonical, RethinkDB, Epson, Acquia, Cleversafe, OpenText Global NoSQL Databases Software Market Report 2021: Top Companies MongoDB, Amazon, ArangoDB, Azure Cosmos DB, Couchbase, MarkLogic, RethinkDB, CouchDB, SQL-RD, OrientDB, RavenDB, Redis etc – The Bisouv Network Open Source Software Market is Expected to Move Up After Covid-19 – Report 2021-2026 | OpenText, ClearCenter, Astaro, Comiit, Epson Global Open Source Software Market 2025: Intel, Epson, IBM, Transcend, Oracle, Acquia, OpenText, Alfresco, Astaro, RethinkDB, Canonical, ClearCenter, Cleversafe, Compiere, Continuent provided by Google News Database Administrator - ITS4 Mainframe Developer - Natural / ADABAS | Richmond, VA (Will be remote during Covid) Snr Cloud Consultant (Mainframe Modernization focus), AWS Professional Services Mainframe Support Adabas Natural Programmer Analyst Sales Operations Analyst - Deal Desk Performance Engineer Database Engineer - AWS, Amazon Redshift Data Labs Analyst Role SQL Developer/SSIS Expert Manager, Engineering (Product Graph/ Data Team) Engineering Leader - Head of Development Senior Full Stack Frontend Engineer, Data Sr. Product Manager Software Developer – Entry Level Data Analyst - Entry Level Entry Level Data Analyst Position- Full Time Job Opportunity Jr. QA Analyst Trainee Technical Support Representative Full Stack Data Scientist Full Stack Ruby Engineer Senior Level System Development Engineer Java Software Engineer (Java 11, Spring, Spring Boot, Hibernate ORM) Sr. Java Software Engineer | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Share this page
