Thanks Aakash for suggesting. After your comment, I thought about it. To improve video quality, now I've purchased Drawing tablet, which will be helpful in explaining diagrams. In recent videos I used it & found extremely helpful in explaining. Thanks again for constructive feedback.
Great Video Sir, Its very helpful to learn about the techniques and how we can implement in different scenarios. I have a question on Sharding drawback while applying joins on the tables in SQL db which resides in different regions- how can we tackle this problem and how should we approach this? Thanks.
Hi, thanks for liking the video. Generally, if we want to apply sharding on SQL db, we do de-normalization, which means that we copy those tables on other servers which are involved in Join queries. Doing this will make sure that all join queries are happening on same server. But this will lead to data duplication on several servers, which is not good and as well on real world scenario not feasible to copy on every join query. Let me know if you still have doubts
He did that for the most part of the video. Just narrating the bullet points. And using half a sentence to explain those points. No a series of good videos.
Sure, I'll make about it. Thanks for suggestion. By the way, Hash partitioning is just another way of sharding, where we shard based on hashcode of key, where key is any attribute through which we want to distribute data.
We need sharding when our database is that big that it can't accommodate in 1 server; it requires more servers to fit in. So we shard the database, now how database will be shard, according to that tables of database will be distributed in servers.
Hello Sir, Your videos are just what I needed to prepare for interviews. May I ask one help, Can you provide me any reference for the books where I can read more about these topics. I need basic introduction to designing and coding these. Please help. I have been searching but it hasn't been fruitful.
Even I could not find any System Design related books. All info i gathered from different sources & captured all together in videos. Being said that, if you see any issue in understanding any topic, you can ask me by posting comments. Thanks for showing interest in channel.
Great Video, lucid, well explained and structured... Thank you
Thanks. Keep watching.
Nice Video.
Suggestion - Try making videos more interactive like drawing on whiteboard or having animations instead of going through PPTs.
Thanks for suggestions. Sure, will improve on this part.
Thanks Aakash for suggesting. After your comment, I thought about it. To improve video quality, now I've purchased Drawing tablet, which will be helpful in explaining diagrams. In recent videos I used it & found extremely helpful in explaining. Thanks again for constructive feedback.
Great Video Sir, Its very helpful to learn about the techniques and how we can implement in different scenarios. I have a question on Sharding drawback while applying joins on the tables in SQL db which resides in different regions- how can we tackle this problem and how should we approach this? Thanks.
Hi, thanks for liking the video. Generally, if we want to apply sharding on SQL db, we do de-normalization, which means that we copy those tables on other servers which are involved in Join queries. Doing this will make sure that all join queries are happening on same server.
But this will lead to data duplication on several servers, which is not good and as well on real world scenario not feasible to copy on every join query.
Let me know if you still have doubts
Good and clear explanation
Thanks. Keep watching.
@@CodingSimplified Can you provide a link which explains this practically ?
nice explanation.
Thanks. Keep Watching.
Yes, nice collection, just saw your playlist, I will go through all.
You did not explain how ACID compliance is not met. You gave hardly a minute on it.
He did that for the most part of the video. Just narrating the bullet points. And using half a sentence to explain those points. No a series of good videos.
Is partitioning and sharding the same??
Can u make a video of hash partitioning
Sure, I'll make about it. Thanks for suggestion. By the way, Hash partitioning is just another way of sharding, where we shard based on hashcode of key, where key is any attribute through which we want to distribute data.
so, sharding means to divide the database or the tables in it.
We need sharding when our database is that big that it can't accommodate in 1 server; it requires more servers to fit in.
So we shard the database, now how database will be shard, according to that tables of database will be distributed in servers.
Hello Sir, Your videos are just what I needed to prepare for interviews. May I ask one help, Can you provide me any reference for the books where I can read more about these topics.
I need basic introduction to designing and coding these. Please help. I have been searching but it hasn't been fruitful.
Even I could not find any System Design related books. All info i gathered from different sources & captured all together in videos.
Being said that, if you see any issue in understanding any topic, you can ask me by posting comments.
Thanks for showing interest in channel.
Check out Designing Data-Intensive Applications