Difference between Cassandra and RDBMS
1. Cassandra :
Cassandra is a high performance and highly scalable distributed NoSQL database management system. Cassandra deals with unstructured data and it handles high volume of incoming data velocity. In Cassandra data written in many locations also data come from many locations and in this row represents a unit of replication and column represents a unit of storage.
2. RDBMS :
Relational Database Management System (RDBMS) is a Data base management system or software which is designed for relational databases and uses Structured Query Language (SQL) for querying and maintaining the database. It deals with structured data and handles moderate incoming data velocity. In RDBMS mainly data written in one location also data come from one/few location and row represents a single record column represents an attribute.
Difference between Cassandra and RDBMS :
|01.||Cassandra is a high performance and highly scalable distributed NoSQL database management system.||RDBMS is a Data base management system or software which is designed for relational databases.|
|02.||Cassandra is a NoSQL database.||RDBMS uses SQL for querying and maintaining the database.|
|03.||It deals with unstructured data.||It deals with structured data.|
|04.||It has flexible schema.||It has fixed schema.|
|05.||Cassandra has master-slave core architecture means no single point of failure.||RDBMS has master-slave core architecture means single point of failure.|
|06.||Cassandra handles high volume incoming data velocity.||RDBMS handles moderate incoming data velocity.|
|07.||In RDBMS there is limited data source means data come from many locations.||In Cassandra there are various data source means data come from one/few location.|
|08.||It supports simple transactions.||It supports complex and nested transactions.|
|09.||In Cassandra the outermost container is Keyspace.||In RDBMS the outermost container is database.|
|10.||Cassandra follows decentralized deployments.||RDBMS follows centralized deployments.|
|11.||In Cassandra data written in many locations.||In RDBMS mainly data written in one location.|
|12.||In Cassandra row represents a unit of replication.||In RDBMS row represents a single record.|
|13.||In Cassandra column represents a unit of storage.||In RDBMS column represents an attribute.|
|14.||In Cassandra relationships are represented using collections.||In RDBMS relationships are represented using keys and joins etc.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.