DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Adabas vs. Amazon SimpleDB vs. Ignite vs. MarkLogic vs. MySQL

System Properties Comparison Adabas vs. Amazon SimpleDB vs. Ignite vs. MarkLogic vs. MySQL

Editorial information provided by DB-Engines
NameAdabas infodenotes "adaptable data base"  Xexclude from comparisonAmazon SimpleDB  Xexclude from comparisonIgnite  Xexclude from comparisonMarkLogic  Xexclude from comparisonMySQL  Xexclude from comparison
DescriptionOLTP - DBMS for mainframes and Linux/Unix/Windows environments infoused typically together with the Natural programming platformHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreApache Ignite is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads, delivering in-memory speeds at petabyte scale.Operational and transactional Enterprise NoSQL databaseWidely used open source RDBMS
Primary database modelMultivalue DBMSKey-value storeKey-value store
Relational DBMS
Document store
Native XML DBMS
RDF store infoas of version 7
Search engine
Relational DBMS infoKey/Value like access via memcached API
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
Score2.19
Rank#117  Overall
#22  Key-value stores
Score6.03
Rank#66  Overall
#9  Key-value stores
#36  Relational DBMS
Score9.19
Rank#51  Overall
#8  Document stores
#1  Native XML DBMS
#1  RDF stores
#4  Search engines
Score1206.05
Rank#2  Overall
#2  Relational DBMS
Websitewww.softwareag.com/­en_corporate/­platform/­adabas-natural.htmlaws.amazon.com/­simpledbignite.apache.orgwww.marklogic.comwww.mysql.com
Technical documentationdocs.aws.amazon.com/­simpledbapacheignite.readme.io/­docsdocs.marklogic.comdev.mysql.com/­doc
DeveloperSoftware AGAmazonApache Software FoundationMarkLogic Corp.Oracle infosince 2010, originally MySQL AB, then Sun
Initial release19712007201520011995
Current releaseApache Ignite 2.69.0, 20178.0.27, October 2021
License infoCommercial or Open SourcecommercialcommercialOpen Source infoApache 2.0commercial inforestricted free version is availableOpen Source infoGPL version 2. Commercial licenses with extended functionallity are available
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase 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 languageC++, Java, .NetC++C and C++
Server operating systemsBS2000
Linux
Unix
Windows
z/OS
z/VSE
hostedLinux
OS X
Solaris
Windows
Linux
OS X
Windows
FreeBSD
Linux
OS X
Solaris
Windows
Data schemeyesschema-freeyesschema-free infoSchema can be enforcedyes
Typing infopredefined data types such as float or dateyesnoyesyesyes
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.noyesyesyes
Secondary indexesyesyes infoAll columns are indexed automaticallyyesyesyes
SQL infoSupport of SQLyes infowith add-on product Adabas SQL GatewaynoANSI-99 for query and DML statements, subset of DDLyes infoSQL92yes infowith proprietary extensions
APIs and other access methodsHTTP API infowith add-on software Adabas SOA Gateway
SOAP-based API infowith add-on software Adabas SOA Gateway
RESTful HTTP APIHDFS API
Hibernate
JCache
JDBC
ODBC
Proprietary protocol
RESTful HTTP API
Spring Data
Java API
Node.js Client API
ODBC
proprietary Optic API infoProprietary Query API, introduced with version 9
RESTful HTTP API
SPARQL
WebDAV
XDBC
XQuery
XSLT
ADO.NET
JDBC
ODBC
Proprietary native API
Supported programming languagesNatural.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
C#
C++
Java
PHP
Python
Ruby
Scala
C
C#
C++
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresin Naturalnoyes (compute grid and cache interceptors can be used instead)yes infovia XQuery or JavaScriptyes infoproprietary syntax
Triggersnonoyes (cache interceptors and events)yesyes
Partitioning methods infoMethods for storing different data on different nodesyes, with additonal products like Adabas Cluster Services, Adabas Parallel Services, Adabas Vistanone infoSharding must be implemented in the applicationShardingShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabric
Replication methods infoMethods for redundantly storing data on multiple nodesyes, with add-on product Event Replicatoryesyes (replicated cache)yesMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes (compute grid and hadoop accelerator)yes infovia Hadoop Connector, HDFS Direct Access and in-database MapReduce jobsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonononoyes infonot for MyISAM storage engine
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoConcurrent data updates can be detected by the applicationACIDACID infocan act as a resource manager in an XA/JTA transactionACID infonot for MyISAM storage engine
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes infotable locks or row locks depending on storage engine
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes, with Range Indexesyes
User concepts infoAccess controlonly with OS-specific tools (e.g. IBM RACF, CA Top Secret)Access rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Security Hooks for custom implementationsRole-based access control at the document and subdocument levelsUsers with fine-grained authorization concept infono user groups or roles
More information provided by the system vendor
Adabas infodenotes "adaptable data base"Amazon SimpleDBIgniteMarkLogicMySQL
Specific characteristicsThe MarkLogic Multi-Model Database provides the simplest way to integrate data from...
» more
Competitive advantagesThe main benefit of MarkLogic is simplicity. By making things simpler, MarkLogic...
» more
Typical application scenariosMarkLogic’s main use case is the Operational Data Hub . A Data Hub is useful for...
» more
Key customersMarkLogic has proven results managing mission-critical data with over 1,000 global...
» more
Market metricsMarkLogic is well known within the Fortune 1000, with a strong presence in financial...
» more
Licensing and pricing modelsMarkLogic provides a variety of licenses and cloud services: MarkLogic Data Hub Service...
» 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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

SQLFlow: 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

Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» 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 SimpleDBIgniteMarkLogicMySQL
DB-Engines blog posts

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

show all

Recent citations in the news

Astadia Poised for Record Growth as Positive Momentum Continues for the Mainframe to Cloud Sector
12 January 2022, Yahoo Finance

The Future of Mainframe Modernization: Where Are We Headed?
19 January 2022, Toolbox

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

provided by Google News

Introducing Amazon SimpleDB
18 August 2010, Database Journal

Why AWS Keeps It Simple
13 December 2021, Datanami

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed Product On AWS
13 November 2013, TechCrunch

AWS, Microsoft and Google should retire these cloud services
2 June 2020, TechTarget

The cloud has changed everything–except how we market it
15 October 2021, TechRepublic

provided by Google News

GridGain Launches Service to Recognize Non-Code Contributors to the Apache Ignite Community
9 December 2021, GlobeNewswire

First Apache Ignite Summit Energizes Global Audience
10 June 2021, GlobeNewswire

GridGain Expands SaaS Portfolio, Makes GridGain Nebula Available to All Apache Ignite Users
28 October 2021, GlobeNewswire

Microsoft Releases Open Source Distributed Machine Learning Library
4 January 2022, iProgrammer

GridGain Expands Ignite Summit, Adds Pre-conference Day
5 October 2021, GlobeNewswire

provided by Google News

Global Document Databases Market 2021 Development Status, Competition Analysis, Type and Application 2027 – Discovery Sports Media
18 January 2022, Discovery Sports Media

MarkLogic Acquires Leading Metadata Management Provider Smartlogic
23 November 2021, Business Wire

Vector Capital-Backed MarkLogic Buys Semantic Tech Maker Smartlogic
29 November 2021, GovCon Wire

Data Management Platform Software Market 2022 Comprehensive Growth, Industry Share-Size Estimate, Future Demand, Top Leading Players, Emerging Trends and Forecast to 2025
18 January 2022, Taiwan News

NoSQL Software Market Is Likely to Experience a Tremendous Growth in Near Future | MongoDB, Amazon, ArangoDB, Azure Cosmos DB, Couchbase
10 January 2022, Digital Journal

provided by Google News

Connect to an MySQL Database via Python | by Christianlauer | CodeX | Jan, 2022
13 January 2022, Medium

PostgreSQL vs MySQL | Compare Database Management Systems
20 December 2021, Server Watch

The best Help Guide To MySQL TIME and Day Features
18 January 2022, ADOTAS

How to Install Vtiger CRM Open Source Edition on Rocky Linux 8
19 January 2022, H2S Media

Open source software is not a problem
19 January 2022, TechCentral.ie

provided by Google News

Job opportunities

Adabas DBA with Knowledge of Database Systems and Software AG Products
Treehouse Software, Inc., Remote

Adabas Database Administrator
DMI, Remote

ADABAS Database Architect
Dutech, Austin, TX

ADABAS Database Administrator
Peer Solutions Group, Columbia, SC

ADABAS NATURAL Programmer
Peer Solutions Group, Columbia, SC

Cloud Infrastructure Architect - Non Profits
Amazon Web Services, Inc., United States

Software Development Engineer
Amazon.com Services LLC, Seattle, WA

Global Strategic Alliances Leader – AWS
Amazon Web Services, Inc., Dallas, TX

Senior Data Architect (remote)
LinQuest Corporation, Beavercreek, OH

Senior Business Development Manager
Amazon Web Services, Inc., Chicago, IL

Performance Tester
Appian Infotech, Austin, TX

Director, Customer Success - Remote U.S. and Canada
GridGain Systems, Foster City, CA

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

Director, Customer Success
GridGain, Foster City, CA

Software Engineer - Ingestion - Data Collection
Lacework, California

Marklogic Developer
Horizon Corp, Charlotte, NC

Semantic Data Modeler (NO C2C!)
Braintrust, Remote

MarkLogic Developer
Digi Upaay Solution Pvt. LTD, Raritan, NJ

Senior UI Developer
Digi Upaay Solutions, Raritan, NJ

Programmer/MarkLogic
Intelligent Waves LLC, Fort Meade, MD

PHP/MySQL Developer
VS Media, Manhattan, NY

MySQL DBA
XTIVIA, Inc., Remote

MySQL Renewal Sales Representative
Oracle, Texas

Software Engineer, Backend - Slack (Senior and Staff)
Slack, Remote

PHP/MySQL Developer
SportsSwaps, Fort Lauderdale, FL

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

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

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.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here