DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Greenplum vs. Hive vs. Quasardb vs. Riak KV

System Properties Comparison Adabas vs. Greenplum vs. Hive vs. Quasardb vs. Riak KV

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonGreenplum  Xexclude from comparisonHive  Xexclude from comparisonQuasardb  Xexclude from comparisonRiak KV  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformAnalytic Database platform built on PostgreSQL. Full name is Pivotal Greenplum Database infoA logical database in Greenplum is an array of individual PostgreSQL databases working together to present a single database image.data warehouse software for querying and managing large distributed datasets, built on HadoopDistributed, high-performance timeseries databaseDistributed, fault tolerant key-value store
Primary database modelMultivalue DBMSRelational DBMSRelational DBMSTime Series DBMSKey-value store infowith links between data sets and object tags for the creation of secondary indexes
Secondary database modelsDocument store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.74
Rank#77  Overall
#1  Multivalue DBMS
Score13.96
Rank#42  Overall
#26  Relational DBMS
Score83.45
Rank#15  Overall
#10  Relational DBMS
Score0.15
Rank#297  Overall
#27  Time Series DBMS
Score6.09
Rank#64  Overall
#7  Key-value stores
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlgreenplum.orghive.apache.orgquasardb.netriak.com/­products/­riak-kv
Technical documentationdocs.greenplum.orgcwiki.apache.org/­confluence/­display/­Hive/­Homedoc.quasardb.net
DeveloperSoftware AGPivotal Software Inc.Apache Software Foundation infoinitially developed by FacebookquasardbBasho Technologies
Initial release19712005201220092009
Current release6.7.1, April 20203.1.2, August 20193.1, January 20192.1.0, April 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0Open Source infoApache Version 2commercial infoFree community edition, Non-profit organizations and non-commercial usage are eligible for free licensesOpen Source infoApache version 2, commercial enterprise edition
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++Erlang
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
LinuxAll OS with a Java VMBSD
Linux
OS X
Windows
Linux
OS X
Data schemeyesyesyesschema-freeschema-free
Typing infopredefined data types such as float or dateyesyesyesyes infointeger and binaryno
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.noyes infosince Version 4.2nono
Secondary indexesyesyesyesyes infowith tagsrestricted
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewayyesSQL-like DML and DDL statementsSQL-like query languageno
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
Thrift
HTTP APIHTTP API
Native Erlang Interface
Supported programming languagesNaturalC
Java
Perl
Python
R
C++
Java
PHP
Python
.Net
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
R
C infounofficial client library
C#
C++ infounofficial client library
Clojure infounofficial client library
Dart infounofficial client library
Erlang
Go infounofficial client library
Groovy infounofficial client library
Haskell infounofficial client library
Java
JavaScript infounofficial client library
Lisp infounofficial client library
Perl infounofficial client library
PHP
Python
Ruby
Scala infounofficial client library
Smalltalk infounofficial client library
Server-side scripts infoStored proceduresin Naturalyesyes infouser defined functions and integration of map-reducenoJavaScript and Erlang
Triggersnoyesnonoyes infopre-commit hooks and post-commit hooks
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistaShardingShardingSharding infoconsistent hashingSharding infono "single point of failure"
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatorSource-replica replicationselectable replication factorSource-replica replication with selectable replication factorselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesyes infoquery execution via MapReducewith Hadoop integrationyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual ConsistencyImmediate ConsistencyEventual Consistency
Foreign keys infoReferential integritynoyesnonono infolinks between data sets can be stored
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDnoACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infoby using LevelDByes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyes infoTransient mode
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)fine grained access rights according to SQL-standardAccess rights for users, groups and rolesCryptographically strong user authentication and audit trailno
More information provided by the system vendor
Adabas infodenotes "adaptable data base"GreenplumHiveQuasardbRiak KV
Specific characteristicsHigh-performance , high-speed, fully integrated timeseries database Seamlessly combines...
» more
Competitive advantagesHigh performance in a cost-effective small package Real-time results for even large...
» more
Typical application scenariosTick database Predictive maintenance Pre-deal checks Large scale monitoring
» more
Key customersLarge EU investment banks US based hedge funds Orolia Tellmeplus
» more
Market metricsHas been running in very demanding production environments since 2013 Rapid adoption...
» more
Licensing and pricing modelsCommunity edition limited to 2 nodes and 16 GiB of storage per node available for...
» more

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 partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» 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"GreenplumHiveQuasardbRiak KV
DB-Engines blog posts

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

Recent citations in the news

Astadia Joins the AWS Mainframe Modernization Service
6 January 2022, Integration Developers

Software AG says it has turned the corner in shift to a subscription business
21 July 2021, SiliconANGLE News

Astadia Migration Factory to Reduce the Duration of Mainframe to AWS Migrations by up to 90%
30 November 2021, Business Wire

Silver Lake Invests $388 Million in Germany's Software AG
14 December 2021, Bloomberg

Get legacy ERP in the fast lane to modern infrastructure with APIs
2 June 2021, Diginomica

provided by Google News

Greenplum 6 ventures outside the analytic box
19 March 2019, ZDNet

Capitalizing on Analytics and AI at Dell Technologies
8 April 2021, CIO

Pivotal Greenplum streamlines big data query optimization
11 March 2016, TechTarget

Big Data = Big Money: EMC Buys Greenplum
6 July 2010, GigaOm

Has the time finally come for PostgreSQL?
20 April 2018, ZDNet

provided by Google News

WANdisco introduces Hive metadata migration to Databricks
24 May 2021, TechTarget

Open-Source Database Software Market to Witness Growth Acceleration During 2022-2029 – The Oxford Spokesman
24 January 2022, The Oxford Spokesman

Top 10 Apache projects in 2021, from Superset, to NuttX and Pulsar
5 January 2022, The Stack

The 8 Best Hadoop Tutorials on YouTube to Watch Right Now
19 January 2022, Solutions Review

Compare Hadoop vs. Spark vs. Kafka for your big data strategy
15 November 2021, TechTarget

provided by Google News

QuestDB gets $12M Series A funding amid growing interest in time-series databases
3 November 2021, SiliconANGLE News

Real-time analytics database startup Imply raises $70M in Series C funding
16 June 2021, SiliconANGLE News

Amazon Timestream time series database generally available
2 October 2020, TechTarget

Gartner Names Three 2020 Cool Vendors in Data Management
30 October 2020, Solutions Review

provided by Google News

Is Riak A Good NoSQL Database Option?
1 July 2019, Analytics India Magazine

Riak NoSQL Database: Use Cases and Best Practices
23 December 2011, InfoQ.com

​Basho's Riak 2.1 database zooms in on better write speeds
8 April 2015, ZDNet

Basho rolls out open source version of its Riak TS database
5 May 2016, ZDNet

Basho Revamps Riak Open-Source Database
17 September 2014, InformationWeek

provided by Google News

Job opportunities

ADABAS Natural Programmer
Evurge Solutions, Remote

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

Adabas Database Administrator
DMI, Remote

Senior Data Migration Architect
Cyber Resource LLC, New York, NY

Natural / Adabas Software Developer
ABB, Memphis, TN

Postgres/Greenplum database administrator
Intellibee Inc, Remote

Member of Technical Staff - Query Processing - Tanzu Greenplum Database - Opportunity for Working Remotely Boston, MA
VMware, Boston, MA

Member of Technical Staff - Query Processing - Tanzu Greenplum Database - Opportunity for Working Remotely Jacksonville, FL
VMware, Jacksonville, FL

Member of Technical Staff - Query Processing - Tanzu Greenplum Database - Opportunity for Working Remotely New York, NY
VMware, New York, NY

Associate Database Engineer
Purdue University, West Lafayette, IN

PDC Developer - Java
Orbis Global, Remote

Data Warehouse Architect
Accede Technologies Pvt Ltd, Remote

Software Developer - Experimentation Platform (Seattle or Remote)
Redfin, Seattle, WA

Java/J2EE Developer
Calypso Way, Remote

Big Data Engineer
WorkCog, Remote

Java Backend Developer
Modernagile Technologies, Richfield, MN

Elixir Engineer
Blitz App, Los Angeles, CA

DevOps Engineer II
Blitz App, California

Senior Elixir Engineer
Blitz App, Los Angeles, CA

Cloud Support Engineer I - Databases
Amazon Web Services, Inc., Remote

jobs by Indeed



Share this page

Featured Products

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!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

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.

Couchbase logo

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

Present your product here