Cassandra Data Modeling Methodology

Learn how Cassandra's data modeling differs from traditional data modeling. You’ll leave knowing how to create data models that scale effectively as your system grows - meaning your users get the experience they deserve!

🔔 Sign up to our event alert:

💬 CHAT = DISCORD, ask questions live:

🎓Certifications Infos

🚀 🚀 ENJOY !! 🚀 🚀

[ayanSaha]

I am half way down the video and learnt a lot. Thanks a lot for the video.

[RandomShowerThoughts]

this video was fantastic, going over the basics and how to model data.

[davidmataviejo]

So basically Casandra is super fast to read because it makes you create small chunks of data, called partitions.
It makes you denormalize the data.
It makes you order the data in those partitios.
It makes you create indexes on the data you are going to filter.
It only allows you to filter given the partition and the indexed column.
It doesn't allow you to use joins

It obligates you to do all the good practices to have high speed reads that you will have in a RDBM if you follow the same rules.
The only new thing that I can see is that it takes care to distribute the data to have high availability.

[davidmataviejo]

In the time 1:07:52 you are creating a partition key with sensorId, month_year. That would create duplicated partition keys. What would happen if user search by only partition key? Would the query return a list? Or when writing it will override the row?

[nishantraval]

Design a data model for a music streaming service. Consider entities such as users, songs, playlists,
and play history. Define tables and relationships to efficiently support queries for user-specific
playlists, recently played songs, and popular songs. How to do this???

[amol_]

With denormalisation how it will deal with incase we update department name?? in that case we need to update department name for every record as we are storing name directly instead of id??

[septembermanu]

Comments by user has pk of user id only which means there can be only one comment per user?! Should the pk be (userid, commentid)

[MrNewAmerican]

Bro please you hurt me when you say "Shimma" - I kept looking for my Rabbi