In this article, we are going to discuss Cassandra and Relational overview in which we will cover and able to learn how Cassandra differentiates the Relational overview. Let’s discuss one by one.
1. Relational Overview :
In Relational Database, you can handle and manage Small, Medium Data such that Postgres, MySQL, Oracle, etc. is fine and It also supports hundreds of concurrent users and one of the most important properties in a relational database is the ACID property which makes us feel proud.
Limitation for handling Big data
- In Relational Overview Data scales vertically which take more hardware and storage that’s why it is expensive for handling Big Data.
- In a Relational database, Query is a lengthy task for managing data.
- In Relational database managing schema of a database is a huge burden.
- The relational database has master-slave architecture in which if the master fail over then who will be responsible for that.
- High Availability is not really if any node goes down.
- Downtime is frequent in a relational database and multi Dc is a mess.
- Manual resharding and re-balancing are hard and every moving part makes the system more complex in a relational database.
Let’s see the Master-slave architecture.
Now, you will see here Cassandra Overview.
Solution for handling Big Data.
- In Cassandra, peer to peer architecture which means there is no master. In terms of Scalability, Cassandra is one of the databases which automatically configured the node when the number of users will increase.
- As you can see in the diagram, It has 3 replica means has 3 copies of data that is for high availability.
- Fault tolerance is also the key feature in Cassandra, which gives you zero downtime which directly implies high availability.
Cassandra is not replacing the relational database. Relational Database is also useful for Medium Scale Data and also can handle Big data as well but If users want scalability, High availability, fault-tolerant system and have big data so, you can go for Cassandra. It depends on the user requirement and data model. So choose wisely.
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.
- Difference between Relational Algebra and Relational Calculus
- Difference between Tuple Relational Calculus (TRC) and Domain Relational Calculus (DRC)
- Overview of User Defined Type (UDT) in Cassandra
- Overview of Data modeling in Apache Cassandra
- Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
- Introduction of Relational Algebra in DBMS
- Relational Model in DBMS
- Mapping from ER Model to Relational Model
- Extended Operators in Relational Algebra
- Basic Operators in Relational Algebra
- How to solve Relational Algebra problems for GATE
- Introduction of Relational Model and Codd Rules in DBMS
- Anomalies in Relational Model
- Query Optimization in Relational Algebra
- Tuple Relational Calculus (TRC) in DBMS
- Domain Relational Calculus in DBMS
- Properties of Relational Decomposition
- Violation of constraints in relational database
- Set Theory Operations in Relational Algebra
- Constraints on Relational database model
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.