DB-EngineseXtremeDB Telecom and Networking featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Amazon Redshift vs. RethinkDB vs. SingleStore

System Properties Comparison Adabas vs. Amazon Redshift vs. RethinkDB vs. SingleStore

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonAmazon Redshift  Xexclude from comparisonRethinkDB  Xexclude from comparisonSingleStore infoformer name was MemSQL  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 toolsDBMS for the Web with a mechanism to push updated query results to applications in realtime.MySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage
Primary database modelMultivalue DBMSRelational DBMSDocument storeRelational DBMS
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.24
Rank#73  Overall
#1  Multivalue DBMS
Score22.99
Rank#29  Overall
#16  Relational DBMS
Score4.05
Rank#84  Overall
#14  Document stores
Score6.04
Rank#63  Overall
#36  Relational DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlaws.amazon.com/­redshiftrethinkdb.comwww.singlestore.com
Technical documentationdocs.aws.amazon.com/­redshiftrethinkdb.com/­docsdocs.singlestore.com
DeveloperSoftware AGAmazon (based on PostgreSQL)The Linux Foundation infosince July 2017SingleStore Inc.
Initial release1971201220092013
Current release2.4.0, December 20197.1.10, October 2020
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache Version 2commercial infofree developer edition available
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.
SingleStore Managed Service: The world's fastest, most capable cloud database for operational analytics, machine learning, & AI. Available instantly with multi-cloud and hybrid-cloud capabilities.
Implementation languageCC++C++
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
hostedLinux
OS X
Windows
Linux info64 bit version required
Data schemeyesyesschema-freeyes
Typing infopredefined data types such as float or dateyesyesyes infostring, binary, float, bool, date, geometryyes
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.nononono
Secondary indexesyesrestrictedyesyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL Gatewayyes infodoes not fully support an SQL-standardnoyes, but no triggers and foreign keys
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
JDBC
ODBC
Supported programming languagesNaturalAll languages supporting JDBC/ODBCC infocommunity-supported driver
C# infocommunity-supported driver
C++ infocommunity-supported driver
Clojure infocommunity-supported driver
Dart infocommunity-supported driver
Erlang infocommunity-supported driver
Go infocommunity-supported driver
Haskell infocommunity-supported driver
Java infoofficial driver
JavaScript (Node.js) infoofficial driver
Lisp infocommunity-supported driver
Lua infocommunity-supported driver
Objective-C infocommunity-supported driver
Perl infocommunity-supported driver
PHP infocommunity-supported driver
Python infoofficial driver
Ruby infoofficial driver
Scala infocommunity-supported driver
Bash
C
C#
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresin Naturaluser defined functions infoin Pythonyes
TriggersnonoClient-side triggers through changefeedsno
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistaShardingSharding inforange basedSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatoryesSource-replica replicationSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency only within each node
Foreign keys infoReferential integritynoyes infoinformational only, not enforced by the systemnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDAtomic single-document operationsACID infoOnly isolation level: READ COMMITED
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoMVCC basedyes, multi-version concurrency control (MVCC)
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesnoyes
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)fine grained access rights according to SQL-standardyes infousers and table-level permissionsfine grained access rights according to SQL-standard

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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» 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 RedshiftRethinkDBSingleStore infoformer name was MemSQL
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

Meet some database management systems you are likely to hear more about in the future
4 August 2014, Paul Andlinger

show all

Recent citations in the news

PR: Increased 2020 bookings guidance following a strong third consecutive quarter of transformation success
18 November 2020, Marketscreener.com

ADABAS DBA & Systems Programmer - Ensono
14 July 2020, Built In Chicago

New Trends Updates for Database Management Software Market 2020 By Size, Share, Applications & Forecast To 2026
19 November 2020, PRnews Leader

conXion
28 October 2020, IoT For All

Software AG Announces New “Adabas & Natural 2050” Agenda
31 August 2016, Business Wire

provided by Google News

Protegrity supports Amazon Redshift to provide advanced data protection
27 October 2020, Help Net Security

Protegrity Announces Support for Amazon Redshift to Secure Sensitive Cloud Data
27 October 2020, AiThority

SnapLogic Now Available on AWS Marketplace
17 November 2020, StreetInsider.com

SnapLogic Announces its Availability on AWS Marketplace
17 November 2020, AiThority

Amazon Kinesis Data Firehose Gains Delivery to HTTP Endpoints
30 October 2020, InfoQ.com

provided by Google News

Open Source Software Market, Global Key Players, Trends, Share, Industry Size, Growth, Opportunities, Forecast To 2025 · Wall Street Call
17 November 2020, Reported Times

Open Source Software Market SWOT Analysis, by Key Players: Intel, Epson, IBM, Transcend, Oracle, Acquia, Actuate, Alfresco Software Inc, Astaro Corp, RethinkDB, Canonical, ClearCenter, Cleversafe, Compiere Inc.
20 November 2020, Cheshire Media

Open Source Software Market Growth, Trends, Analysis By Top Key Players- Intel Epson IBM Transcend Oracle Acquia Actuate Alfresco Software Inc Astaro Corp RethinkDB Canonical ClearCenter Cleversafe Compiere Inc.
16 November 2020, ICOTodayMagazine

Open Source Software Market – increasing demand with Industry Professionals: Intel, Epson, IBM
18 November 2020, KYT24

Open Source Software Market Growth with COVID19 Impact, Industry Outlook & Business Opportunity by Top Key Players Intel, Epson, IBM, etc.
18 November 2020, Eurowire

provided by Google News

MemSQL Changes Name to SingleStore
27 October 2020, Business Wire

MemSQL Re-Brands to SingleStore to Reflect New Product Vision
29 October 2020, Solutions Review

Sponsored post: Business innovation requires underlying systems that offer speed, efficiency and agility
3 November 2020, TechCrunch

news digest: MemSQL rebrands as SingleStore, .NET for Apache Spark 1.0, and Intel acquires SigOpt - SD Times
30 October 2020, SDTimes.com

Nextgen scores APAC SingleStore distribution deal - Digital - Software
6 November 2020, CRN Australia

provided by Google News

Job opportunities

Adabas Developer
CTEC, Remote

Adabas Developer
Cybermedia Technologies (CTEC), Remote

ADABAS NATURAL Programmer
Peer Solutions Group, Columbia, SC

Senior Natural/ADABAS Developer
West Advanced Technologies (WATI), Sacramento, CA

Adabas Natural Programmer Analyst
Peer Solutions Group, Columbia, SC

Amazon Redshift-Lead
Wipro LTD, Chicago, IL

ETL Developer
The Green Technology Group, LLC, United States

Data Analyst
ShootProof, Atlanta, GA

Data Analytics Intern (Spring 2021)
BDO, Oak Brook, IL

Software Developer Engineer Intern – Redshift
Amazon Web Services, Inc., Seattle, WA

Full Stack Engineer
Showcase IDX, Remote

Lead Ruby Engineer
Showcase IDX, Remote

Java Software Engineer (Java 11, Spring, Spring Boot, Hibernate ORM)
Zscaler, Burlington, MA

Director, Software Engineering
Samsung Electronics, Bellevue, WA

Engineer II, Software Process Engineering
Samsung Electronics, Bellevue, WA

Software Engineer, University Graduate
SingleStore, San Francisco, CA

Software Engineer, Intern (Summer 2021)
SingleStore, San Francisco, CA

Support Engineer. 2nd Shift
SingleStore, Oregon

Community Manager
SingleStore, California

Product Manager, Ecosystem
SingleStore, Seattle, WA

jobs by Indeed




Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Neo4j logo

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

Couchbase logo

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

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Present your product here