DBMS > Adabas vs. Amazon Redshift vs. ClickHouse vs. Datomic vs. RethinkDB
System Properties Comparison Adabas vs. Amazon Redshift vs. ClickHouse vs. Datomic vs. RethinkDB
| Editorial information provided by DB-Engines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name | Adabas  denotes "adaptable data base" Xexclude from comparison | Amazon Redshift Xexclude from comparison | ClickHouse Xexclude from comparison | Datomic 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 | Column-oriented Relational DBMS powering Yandex | Datomic builds on immutable values, supports point-in-time queries and uses 3rd party systems for durability | 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 | Document store | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary database models | Time Series DBMS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Website | www.softwareag.com/en_corporate/platform/adabas-natural.html | aws.amazon.com/redshift | clickhouse.tech | www.datomic.com | rethinkdb.com | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Technical documentation | docs.aws.amazon.com/redshift | clickhouse.tech/docs | docs.datomic.com | rethinkdb.com/docs | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Developer | Software AG | Amazon (based on PostgreSQL) | Yandex LLC | Cognitect | The Linux Foundation since July 2017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Initial release | 1971 | 2012 | 2016 | 2012 | 2009 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Current release | v20.11.3.3-stable, November 2020 | 0.9.5951, July 2019 | 2.4.1, August 2020 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| License Commercial or Open Source | commercial | commercial | Open Source Apache 2.0 | commercial limited edition free | 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. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Implementation language | C | C++ | Java, Clojure | C++ | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Server operating systems | BS2000 Linux Unix Windows z/OS z/VSE | hosted | FreeBSD Linux macOS | All OS with a Java VM | 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 | no | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary indexes | yes | restricted | no | yes | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQL Support of SQL | yes with add-on product Adabas SQL Gateway | yes does not fully support an SQL-standard | Close to ANSI SQL | no | 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 | HTTP REST JDBC ODBC Proprietary protocol | RESTful HTTP API | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Supported programming languages | Natural | All languages supporting JDBC/ODBC | C# 3rd party library C++ Elixir 3rd party libraryGo 3rd party libraryJava 3rd party libraryJavaScript (Node.js) 3rd party libraryKotlin 3rd party libraryNim 3rd party libraryPerl 3rd party libraryPHP 3rd party libraryPython 3rd party libraryR 3rd party libraryRuby 3rd party libraryScala 3rd party library | Clojure Java | 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 | no | yes Transaction Functions | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Triggers | no | no | no | By using transaction functions | 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 | 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 | 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 | no | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transaction concepts Support to ensure data integrity after non-atomic manipulations of data | ACID | ACID | no | ACID | Atomic single-document operations | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Concurrency Support for concurrent manipulation of data | yes | yes | yes | yes | yes MVCC based | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Durability Support for making data persistent | yes | yes | yes | yes using external storage systems (e.g. Cassandra, DynamoDB, PostgreSQL, Couchbase and others) | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| In-memory capabilities Is there an option to define some or all structures to be held in-memory only. | no | yes | yes | yes recommended only for testing and development | 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 | Access rights for users and roles | no | 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 DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution. » 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 | ClickHouse | Datomic | 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 | Meet some database management systems you are likely to hear more about in the future Air Force Looks to Modernize and Migrate Legacy Systems – MeriTalk 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 AAFMAA Selects Software AG Adabas and Natural System for Self-Service Insurance and Financial Solutions COBOL Is Taking Heat, but These Other Legacy Languages Could Burn You provided by Google News Diyotta Launches Datom AI Enterprise Cloud Data Pipeline Tool Cloud Data Warehouse Performance Testing – Gigaom AWS unveils three analytics capabilities to improve Amazon Redshift performance 8 databases supporting in-database machine learning Immuta Announces Record Annual Growth and Rising Market Share in DataOps Technology Market provided by Google News Altinity grabs $4M seed to build cloud version of ClickHouse open-source data warehouse SENIOR BACK END DEVELOPER (PYTHON EXPERT + AWS) REMOTE, SPAIN (m/f) ClickHouse - from website clicks to ultra-fast analytics solution - ClickHouse Experiencing Explosive Growth in EU, US and Asia in Q1 2018 Machine Learning Capabilities Come to the Majority of Open Source Databases with MindsDB AI-Tables 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 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 Global Open Source Software Market 2025: Intel, Epson, IBM, Transcend, Oracle, Acquia, OpenText, Alfresco, Astaro, RethinkDB, Canonical, ClearCenter, Cleversafe, Compiere, Continuent Open Source Software Market is Expected to Move Up After Covid-19 – Report 2021-2026 | OpenText, ClearCenter, Astaro, Comiit, Epson NoSQL Software Market Demand, Booming Worldwide and Strategic Outlook to 2025 | MongoDB, OrientDB, Amazon, Azure Cosmos DB, Couchbase, ArangoDB, CouchDB, MarkLogic provided by Google News Database Administrator - ITS4 Snr Cloud Consultant (Mainframe Modernization focus), AWS Professional Services ADABAS Data Base Specialist Mainframe Developer - Natural / ADABAS | Richmond, VA (Will be remote during Covid) Mainframe Support Sales Operations Analyst - Deal Desk Database Engineer - AWS, Amazon Redshift Data Engineer, Amazon Prime Video Coordinator, CRM Technical Product Manager - Amazon Redshift Systems Engineer DevOps Engineer (Database) Systems Engineer Engineering Manager DevOps Engineer Manager, Engineering (Product Graph/ Data Team) Senior Full Stack Frontend Engineer, Data Engineering Leader - Head of Development Sr. Product Manager Full Stack Ruby Engineer Full Stack Data Scientist Senior Level System Development Engineer Sr. Java Software Engineer Java Software Engineer (Java 11, Spring, Spring Boot, Hibernate ORM) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Share this page
