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 > Amazon DynamoDB vs. IBM Db2 vs. Informix vs. Riak KV

System Properties Comparison Amazon DynamoDB vs. IBM Db2 vs. Informix vs. Riak KV

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon DynamoDB  Xexclude from comparisonIBM Db2 infoformerly named DB2 or IBM Database 2  Xexclude from comparisonInformix  Xexclude from comparisonRiak KV  Xexclude from comparison
DescriptionHosted, scalable database service by Amazon with the data stored in Amazons cloudCommon in IBM host environments, 2 different versions for host and Windows/LinuxA secure embeddable database from IBM, positioned besides IBM Db2 as a relatively low-cost product optimized for OLTP and Internet of Things dataDistributed, fault tolerant key-value store
Primary database modelDocument store
Key-value store
Relational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDBRelational DBMS infoSince Version 12.10 support for JSON/BSON datatypes compatible with MongoDBKey-value store infowith links between data sets and object tags for the creation of secondary indexes
Secondary database modelsDocument store
RDF store infoin Db2 LUW (Linux, Unix, Windows)
Spatial DBMS infowith Db2 Spatial Extender
Document store
Spatial DBMS
Time Series DBMS infowith Informix TimeSeries Extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score87.26
Rank#15  Overall
#2  Document stores
#2  Key-value stores
Score157.23
Rank#7  Overall
#5  Relational DBMS
Score24.16
Rank#34  Overall
#20  Relational DBMS
Score6.29
Rank#69  Overall
#10  Key-value stores
Websiteaws.amazon.com/­dynamodbwww.ibm.com/­analytics/­db2www.ibm.com/­products/­informixriak.com/­products/­riak-kv
Technical documentationdocs.aws.amazon.com/­dynamodbwww.ibm.com/­support/­knowledgecenter/­SSEPGGinformix.hcldoc.com
www.ibm.com/­support/­knowledgecenter/­SSGU8G/­welcomeIfxServers.html
DeveloperAmazonIBMIBM, HCL Technologies infoEffective May 1st, 2017, HCL took on development, technical support, and product management teams, and works jointly with IBM on product strategy, marketing, and sales.Basho Technologies
Initial release20121983 infohost version19842009
Current release12.1, October 201614.10.FC5, November 20202.1.0, April 2015
License infoCommercial or Open Sourcecommercial infofree tier for a limited amount of database operationscommercial infofree version is availablecommercial infofree developer edition availableOpen Source infoApache version 2, commercial enterprise edition
Cloud-based only infoOnly available as a cloud serviceyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++C, C++ and JavaErlang
Server operating systemshostedAIX
HP-UX
Linux
Solaris
Windows
z/OS
AIX
HP-UX
Linux
macOS
Solaris
Windows
Linux
OS X
Data schemeschema-freeyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyes infoSince Version 12.10 support for JSON/BSON datatypesno
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.no
Secondary indexesyesyesyesrestricted
SQL infoSupport of SQLnoyesyesno
APIs and other access methodsRESTful HTTP APIADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
JDBC
JSON API infoMongoDB compatible
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
HTTP API
Native Erlang Interface
Supported programming languages.Net
ColdFusion
Erlang
Groovy
Java
JavaScript
Perl
PHP
Python
Ruby
C
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
.Net
C
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
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 proceduresnoyesyesJavaScript and Erlang
Triggersyes infoby integration with AWS Lambdayesyesyes infopre-commit hooks and post-commit hooks
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoonly with Windows/Unix/Linux VersionShardingSharding infono "single point of failure"
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes infowith separate tools (MQ, InfoSphere)Multi-source replication
Source-replica replication
selectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsno infomay be implemented via Amazon Elastic MapReduce (Amazon EMR)nonoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyEventual Consistency
Foreign keys infoReferential integritynoyesyesno infolinks between data sets can be stored
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infoACID across one or more tables within a single AWS account and regionACIDACIDno
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.yes
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)fine grained access rights according to SQL-standardUsers with fine-grained authentication, authorization, and auditing controlsno

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
Amazon DynamoDBIBM Db2 infoformerly named DB2 or IBM Database 2InformixRiak KV
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

Recent citations in the news

Using a NestJS Application with DynamoDB and Serverless Framework on AWS
22 July 2022, hackernoon.com

AWS: Here's how our cloud-computing infrastructure dealt with Amazon Prime day
26 July 2022, ZDNet

NoSQL Market Investment Analysis | Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database, MongoLab – Shanghaiist
8 August 2022, Shanghaiist

How to Manage Your Asynchronous API With DynamoDB Streams
15 June 2022, Built In

Imperva Extends its Data Security Fabric to Include Enterprise Data Lakes Built on AWS
26 July 2022, businesswire.com

provided by Google News

IBM launches Db2 operator for Kubenetes on AWS
20 July 2022, The Register

Thoroughly Modern: Latest IT Trends – Bring Security, Speed, And Consistency To IT With Automation
8 August 2022, IT Jungle

Db2, where are you? Big Blue is oddly reluctant to discuss recent enhancements to its flagship database
23 December 2021, The Register

AWS Announces AMD Based R6a Instances for Memory-Intensive Workloads
31 July 2022, InfoQ.com

Hands-on review: SolarWinds Database Performance Analyzer (DPA)
12 July 2022, DataCenterNews Asia

provided by Google News

Relational Databases Software Market to Witness Huge Growth by 2030 | Microsoft, MySQL, Oracle, SAP, PostgreSQL – This Is Ardee
26 July 2022, This Is Ardee

Embedded Database Management Systems Market Size, Scope, Growth Opportunities, Trends by Manufacturers And ...
27 July 2022, This Is Ardee

The Data Replication Market in 2022
24 February 2022, Datamation

Best Data Migration Tools and Software 2022 | ENP
29 December 2021, EnterpriseNetworkingPlanet

Fugitive Silicon Valley tech executive hauled into federal court
15 October 2019, The Mercury News

provided by Google News

Cloud Based Time Series Database Market See Huge Growth for New Normal | Alibaba, Amazon (AWS), AVEVA
25 July 2022, Digital Journal

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

Basho, Maker of Riak NoSQL Database, Raises $25M
13 January 2015, Data Center Knowledge

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

Riak TS for time series analysis at scale
29 September 2016, Opensource.com

provided by Google News

Job opportunities

QA Engineer
Via, New York, NY

Developer (Full Stack) - Entry
Bayer, St. Louis, MO

DevOps Engineer
Vidaloop, Remote

Senior DevOps Engineer
X2Logics, Remote

System Engineer, AWS DynamoDB
Amazon.com Services LLC, Seattle, WA

DB2 Database Engineer
Teamware Solutions, Loveland, CO

SQL Database Administrator-11316
Right Talents, Albany, NY

Database Analyst
BenchmarkRPO, Salem, OR

DB2 Database Administrator
Apptrics LLC, Remote

Senior Database Administrator
TDMK Digital, Arlington, VA

Warehouse Shipping and Receiving Clerk
Inmar, Remote

2nd Shift CSD Shipping Clerk
Inmar, Grand Prairie, TX

1st Shift Shipping Clerk
Inmar, Grand Prairie, TX

Software Engineer (Services) 3
WEX Inc., Remote

GUI Developer
Software Goldsmith, Holly Springs, NC

Cloud Support Eng. II (DB)
Amazon Web Services, Inc., Pennsylvania

Cloud Support Eng. II (DB)
Amazon Web Services, Inc., Herndon, VA

Cloud Support Eng. II (DB)
Amazon Web Services, Inc., Virginia

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

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

jobs by Indeed



Share this page

Featured Products

Redis logo

The world’s most loved real‑time data platform.
Try free

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Neo4j logo

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

Vertica logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here