Difference between IBM DB2 and Amazon DynamoDB

Difference between IBM DB2 and Amazon DynamoDB

Last Updated : 02 Jul, 2020

1. IBM DB2 : IBM DB2 is a relational database which was developed by IBM in 1983. It is considered as a family of database management products which are build for AI. It has enhanced capabilities for performing transactions. It works on the principle of ACID and has high flexibility and performance. It has efficient backup facilities and is considered very secure. It is extremely reliable and is supported by Linux, Unix and Windows operating systems. It has a commercial license and has high scalability. 2. Amazon DynamoDB : Amazon DynamoDB is a document database that has high scalability. It was given by Amazon in 2012. It has a Primary database model as document store and key value store. It has a commercial license. It uses transactions and follows ACID properties. It has backup facilities and has high security. Amazon DynamoDB is a durable and robust database. It can handle enormous number of requests in a day and is fully managed.
Difference between IBM DB2 and Amazon DynamoDB :

S.NO.	IBM DB2	Amazon DynamoDB
1.	IBM DB2 is a relational database model.	Amazon DynamoDB is a key-value storage database model.
2.	Pessimistic Locking model is there in IBM DB2.	Optimistic Locking model is there in Amazon DynamoDB.
3.	IBM DB2 has schema.	It is free from schema.
4.	It was developed by IBM in 1983.	It was developed by Amazon in 2012.
5.	It supports AIX, HP-UX, Linux, Solaris, Windows, z/OS.	It supports all hosted operating system.
6.	Foreign keys are present in IBM DB2.	It does not have foreign key concept.
7.	It is not cloud based database.	It is cloud based database.
8.	It uses SQL queries for processing query.	It does not have SQL queries.
9.	It support server side scripts.	It does not support server side script.
10.	It is considered more than Amazon DynamoDB in terms of ranking.	It is considered less than IBM DB2 in terms of ranking.

Difference between IBM DB2 and Amazon DynamoDB

ypsjnv2013

Improve

Article Tags :

Similar Reads

Difference between MariaDB and Amazon DynamoDB

1. Maria DB : Maria DB is an enhanced version of MySQL which was made by the original developers of MySQL to increase the functionality. Maria DB is an open source software. It is used worldwide because of its speed and its robust nature. It was developed by Maria DB enterprise in 2009. It is secure

Difference between MS SQL and Amazon DynamoDB

1. MS SQL : MS SQL is a relational database management system developed by Microsoft in 1989. It is highly scalable and secure platform for data storage. It offers smart analytics features with high performance and security. The core component of MS SQL server is the SQL server database engine, whic

Difference between MongoDB and Amazon DynamoDB

1. MongoDB : MongoDB is a document oriented Database model which is a open source software. It was developed by MongoDB Inc. in 2009.It is implemented in C++ language. MongoDB uses the documents like JSON. It can be used as a standalone program and provides backup facility. It has a high ranking and

Difference between Amazon DynamoDB and Amazon SimpleDB

1. Amazon DynamoDB : Amazon DynamoDB is a fully-managed database and supports both document and key-value data models. Features are as follows â€“ fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. It is a hosted, scalable

Difference between Elasticsearch and Amazon DynamoDB

1. Elasticsearch : Elasticsearch is a distributed search and analytics engine. It is open source and can be used for all types of data. It is implemented in Java programming language and supports all operating systems having java virtual machines (J.V.M). It is the main component of Elastic Stack, w

Difference between Amazon DynamoDB and Amazon Redshift

1. Amazon DynamoDB : Amazon DynamoDB is a fully-managed database and supports both document and key-value data models. Features are as follows â€“ fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. It is hosted, scalable d

Difference between MongoDB and Amazon SimpleDB

1. MongoDB : MongoDB is an open-source document-oriented database used for high volume data storage. It falls under classification of NoSQL database. NoSQL tool means that it doesnâ€™t utilize usual rows and columns. MongoDB uses BSON (document storage format) which is binary style of JSON documents.

Difference between Amazon Aurora and Amazon DynamoDB

1. Amazon Aurora : Amazon Aurora is a fully managed relational database engine from Amazon Web Services that are compatible with MySQL and PostgreSQL. It is approx five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. Features of Aurora have distr

Difference between MongoDB and Amazon Redshift

1. MongoDB : MongoDB is an open-source document-oriented database used for high volume data storage. It falls under classification of NoSQL database. NoSQL tool means that it doesnâ€™t utilize usual rows and columns. MongoDB uses BSON (document storage format) which is binary style of JSON documents.

Difference between MongoDB and Amazon DocumentDB

1. MongoDB : MongoDB is an open-source document-oriented database used for high volume data storage. It falls under classification of NoSQL database. NoSQL tool means that it doesnâ€™t utilize usual rows and columns. MongoDB uses BSON (document storage format) which is binary style of JSON documents.