Open In App

Difference between Cassandra and IBM Db2

Last Updated : 23 Jun, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

1. Cassandra :
Cassandra is a free and open-source, distributed, wide column store, NoSQL database management system. It was developed by Apache Software Foundation and initially released in July 2008. Cassandra is designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.

2. IBM Db2 :
Db2 is a family of data management products, including database servers, developed by IBM. It is a Relational Database Management System (RDBMS) which supports object-oriented features and non relational structure with XML. Db2 is designed to store, analyze and retrieve the data efficiently. It was initially released in 1983 and is written in C, C++, Java and Assembly language.


Difference between Cassandra and IBM Db2 :

S.NO. Cassandra IBM Db2
1. It was developed by Apache Software Foundation and released in July 2008. It was developed by IBM and initially released in 1983.
2. Cassandra is written only in Java language. Db2 is written in C, C++, Assembly language, Java languages.
3. The primary database model for Cassandra is Wide Column Store. The primary database model for Db2 is Relational DBMS.
4. Cassandra does not support XML data format. Db2 supports XML data format.
5. Secondary indexes in Cassandra are restricted. Db2 supports the secondary indexes without any restrictions.
6. Cassandra does not provide ACID transactions . Db2 provides ACID transactions.
7. Cassandra is free of data schema. In Db2 data schema is fixed.
8. Cassandra supports Map Reduce method. Db2 does not support of Map Reduce method.
9. Cassandra does not have the concept of Foreign keys. Db2 has the concept of Referential Integrity and Foreign keys.
10. Server operating systems for Cassandra are BSD, Linux, OS X, and Windows. Server operating systems for Db2 are AIX, HP-UX, Linux, Solaris, Windows and z/OS.
11. Some companies like Hulu, Instagram, Intuit, Netflix, Reddit, etc use Cassandra. Some companies like JPMorgan Chase, Bank of America, Scotiabank, Citi, etc use Db2.


Similar Reads

Difference between CouchDB and IBM Db2
1. CouchDB : CouchDB is an open-source document-oriented NoSQL database that uses multiple formats and protocols to store, transfer, and process its data, it uses JSON to store data, JavaScript as its query language using MapReduce, and HTTP for an API. It was developed by Apache Software Foundation and initially released in 2005. It is written in
4 min read
Difference between Couchbase and IBM Db2
1. Couchbase : Couchbase Server is an open-source, distributed, JSON document database that is enhanced for interactive applications. It is also known as Membase. It was developed by Couchbase, Inc. and initially released in August 2010. It is written using C++, Erlang, C, Go languages and its server is designed to provide us with easy-to-scale key
2 min read
Difference between MS SQL Server and IBM DB2
1. Microsoft SQL Server : It is relational database management system (RDBMS) developed by Microsoft Corporation and initially released on April 24, 1989. It is written in C and C++ languages. It is platform-dependent and it is both GUI and command based software. It supports a variety of transaction processing, analytics applications, and business
2 min read
Difference between PouchDB and IBM Db2
1. PouchDB : PouchDB is an open-source, NoSQL, in-line database. It is designed after CouchDB, which is a NoSQL database that powers npm. It is written in JavaScript language. There is no need to perform queries over the network as PouchDB resides inside the browser and thus it makes it extremely faster. It stores data locally using IndexedDB and W
2 min read
Difference between MariaDB and IBM Db2
1. MariaDB : MariaDB is an open-source relational database management system (RDBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. It is developed by MariaDB Foundation and initially released on 29 October 2009. MariaDB has a significantly high number of new features, which makes it better in terms of perfo
2 min read
Difference between MySQL and IBM Db2
1. MySQL : MySQL is an open-source relational database management system (RDBMS) based on Structured Query Language (SQL). It is developed and managed by oracle corporation and initially released on 23 May, 1995. It is widely being used in many small and large scale industrial applications and capable of handling a large volume of data. 2. IBM Db2
2 min read
Difference between SQLite and IBM DB2
1. SQLite : SQLite is a software library that provides a relational database management system (RDBMS). It was designed by D. Richard Hipp on August 2000. The design goals of SQLite were to allow the program to be operated without installing a database management system (DBMS) or requiring a database administrator. The lite in SQLite means light we
2 min read
Difference between MS SQL Server and IBM Db2
1. MS SQL Server : Microsoft SQL Server is a relational database management system (RDBMS) which is platform dependent and it is both GUI and command based software. It supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. It was developed by Microsoft Corporation and initi
2 min read
Difference between MongoDB and IBM Db2
1. MongoDB : MongoDB is an open-source document-oriented database used for high volume data storage. It falls under the classification of the NoSQL database. NoSQL tool means that it does not utilize usual rows and columns. MongoDB uses BSON (Document Storage Format), which is a binary style of JSON documents. It is a database that stores the data
2 min read
Difference between IBM DB2 and PostgreSQL
1. IBM DB2 : IBM DB2 is a database which has a relational model and is known for its performance. It has high scalability and is also known for its reliability. It is a commercial software and the main working principle of IBM DB2 is ACID. It was developed by IBM in the year 1983. The partitioning method which is used in IBM DB2 is sharding. It sup
2 min read
Article Tags :