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

DBMS > Adabas vs. Derby vs. Hive vs. Ignite

System Properties Comparison Adabas vs. Derby vs. Hive vs. Ignite

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB  Xexclude from comparisonHive  Xexclude from comparisonIgnite  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.data warehouse software for querying and managing large distributed datasets, built on HadoopApache Ignite is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads, delivering in-memory speeds at petabyte scale.
Primary database modelMultivalue DBMSRelational DBMSRelational DBMSKey-value store
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.11
Rank#75  Overall
#1  Multivalue DBMS
Score5.90
Rank#63  Overall
#36  Relational DBMS
Score70.27
Rank#15  Overall
#10  Relational DBMS
Score5.32
Rank#71  Overall
#11  Key-value stores
#39  Relational DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmldb.apache.org/­derbyhive.apache.orgignite.apache.org
Technical documentationdb.apache.org/­derby/­manuals/­index.htmlcwiki.apache.org/­confluence/­display/­Hive/­Homeapacheignite.readme.io/­docs
DeveloperSoftware AGApache Software FoundationApache Software Foundation infoinitially developed by FacebookApache Software Foundation
Initial release1971199720122015
Current release10.15.2.0, March 20203.1.2, August 2019Apache Ignite 2.6
License infoCommercial or Open SourcecommercialOpen Source infoApache version 2Open Source infoApache Version 2Open Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJavaC++, Java, .Net
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
All OS with a Java VMAll OS with a Java VMLinux
OS X
Solaris
Windows
Data schemeyesyesyesyes
Typing infopredefined data types such as float or dateyesyesyesyes
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.noyesyes
Secondary indexesyesyesyesyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewayyesSQL-like DML and DDL statementsANSI-99 for query and DML statements, subset of DDL
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
JDBCJDBC
ODBC
Thrift
HDFS API
Hibernate
JCache
JDBC
ODBC
Proprietary protocol
RESTful HTTP API
Spring Data
Supported programming languagesNaturalJavaC++
Java
PHP
Python
C#
C++
Java
PHP
Python
Ruby
Scala
Server-side scripts infoStored proceduresin NaturalJava Stored Proceduresyes infouser defined functions and integration of map-reduceyes (compute grid and cache interceptors can be used instead)
Triggersnoyesnoyes (cache interceptors and events)
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas VistanoneShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event ReplicatorSource-replica replicationselectable replication factoryes (replicated cache)
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infoquery execution via MapReduceyes (compute grid and hadoop accelerator)
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
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.noyesyes
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 rolesSecurity Hooks for custom implementations

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"Derby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBHiveIgnite
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

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

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

Global Database Management Software Market By Leading Key Players- IBM MySQL SAP SolarWinds ADABAS Oracle Informix Teradata Microsoft FileMaker Redis SQLite DbVisualizer MongoDB PostgreSQL Amazon RDS
26 November 2020, Tri State Observer

Covid-19 Impact on Global Database Management Software Market (2020-2026) | Potential growth, attractive valuation make it is a long-term investment | Top Players: IBM, SolarWinds, Oracle, SAP, Microsoft, etc. | InForGrowth
28 November 2020, Cheshire Media

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

provided by Google News

JDBC tutorial: Easy installation and setup with Apache Derby
20 December 2019, TheServerSide.com

Staying in sync with your data
14 May 2020, SDTimes.com

Six free databases with commercial-quality features
3 December 2012, Network World

The Ultimate Open Source Database List Profiling 16 Software Tools
30 May 2019, Solutions Review

How-to: Use the New Apache Oozie Database Migration Tool
12 November 2016, DZone News

provided by Google News

Analytics Insight Predicts 3 million Job Openings in Data Science in 2021
1 December 2020, Analytics Insight

Open-Source Database Software Market A Latest Research Report, Share Insights and Dynamics with Key Manufactureres – SQLite, Redis, Couchbase, Neo4j, MariaDB, Titan, Apache Hive, MySQL, MongoDB
30 November 2020, Murphy's Hockey Law

Global Open-Source Database Software Market Expected To Reach Highest CAGR by 2026 : MySQL, Redis, MongoDB, Couchbase, Apache Hive, etc.
29 November 2020, Cheshire Media

AWS Announces Three New Analytics Capabilities
1 December 2020, StreetInsider.com

AWS Announces General Availability of Amazon Managed Workflows for Apache Airflow
24 November 2020, Business Wire

provided by Google News

GridGain Virtual Events Offer Expert Advice and Best Practices for Deploying In-Memory Computing Solutions
30 November 2020, GlobeNewswire

GridGain Webinar and Online Resources Chart Path for Accelerating Digital Transformation Using GridGain or Apache Ignite In-Memory Computing Solutions
23 November 2020, GlobeNewswire

In-Memory Computing Summit 2020 Worldwide Conference Offers Insights to Nearly 1,100 Registrants
5 November 2020, GlobeNewswire

Optimizing the Relationship Between Apache Ignite and Kubernetes
9 October 2020, Container Journal

GridGain Systems Named to Deloitte 2020 Technology Fast 500™ for Third Consecutive Year
19 November 2020, Yahoo Finance

provided by Google News

Job opportunities

ADABAS Natural Developer
The Casey Group, Newark, NJ

Adabas Developer
Cybermedia Technologies (CTEC), Remote

Adabas Developer
CTEC, Remote

ADABAS NATURAL Programmer
Peer Solutions Group, Columbia, SC

Adabas Natural Programmer Analyst
Peer Solutions Group, Columbia, SC

Technical Lead
LYRASIS, Atlanta, GA

Data Engineer
Tredence Inc., Remote

Database Administrator - Remote work
TWD, Washington, DC

Hadoop Administrator
Logic Loops, Atlanta, GA

Data Engineer
ITResonance, Dearborn, MI

Big Data Consultant Financials
Amazon Web Services, Inc., Virginia

Software Engineers (all levels) - Charles River Development
State Street, Burlington, MA

Enterprise Java Software Engineer (Apache Ignite / Python)
BlackRock, New York, NY

Software Engineer I
State Street, Burlington, MA

Product Support
TCS, Dallas, TX

Java App Developer
SAIC, Albuquerque, NM

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.

Datastax Astra logo

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

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.

Present your product here