Introduction to NoSQL databases

  Рет қаралды 795,454

Gaurav Sen

Gaurav Sen

Күн бұрын

Пікірлер
@RameshAdavi
@RameshAdavi 5 жыл бұрын
Great Teaching Skills. As a 63 year old, I found learning from a youngster, really cool!
@gkcs
@gkcs 5 жыл бұрын
Thank you!
@paragsomani5696
@paragsomani5696 4 жыл бұрын
I m 44 but wanted to say the same.Now no need.
@N_poet
@N_poet 4 жыл бұрын
i m 30+ and fan of them too
@codelucky
@codelucky 3 жыл бұрын
You're 64 and still leaning. I got to learn from you. Take care, stay safe.
@pran322
@pran322 3 жыл бұрын
Me too; learning at 55:-) from GKCS
@SurajSharma-sd3ws
@SurajSharma-sd3ws 5 жыл бұрын
Gaurav, you have tremendous ability to articulate modern day computer science concepts. Its great to see someone so young having this charisma and tech flair which is a rare combo. I have been in software for 20 years and sadly i was never taught like this or then around early 2000's there were no youtube channels like yours. You are redefining online learning with your videos. Keep it up mate.
@gkcs
@gkcs 5 жыл бұрын
Thank you Suraj!
@tarunpothulapati3425
@tarunpothulapati3425 6 жыл бұрын
Great Video! A small point to add, Most of the NoSQL offerings also offer, Consistency levels for users to choose. So, If I want to make sure my users read always consistent data I can have strong consistency which means a write is acknowledged only when a quorum of replicas have also acknowledged it. This makes sure, consistency is present even when one of the replicas go down. But obviously the tradeoff is the writes are slow. If availability is preferred over consistency, then Eventual consistency can be choosen in which the writes are acknowledged when the present replica writes it in memory, hoping that all other replicas catch up with the write "eventually" .
@gkcs
@gkcs 6 жыл бұрын
Agree! This is what allows us to aggregate and read fast on NoSQL. I made a mistake in the video by stating that reads are slow. Reads are in fact faster in NoSQL than standard RDBMS as long as consistency requirements are relaxed.
@lakshaysagarrana3965
@lakshaysagarrana3965 6 жыл бұрын
a great summary of cap ❤️✔️
@InvestWithRishi
@InvestWithRishi 5 жыл бұрын
Writes are fast in Cassandra if replication factor is local_One. Although if you change it to quorum then obviously it adds to the throughput of the transaction. It’s all about the system requirement at the end of the day. 😃
@ananyasharma1201
@ananyasharma1201 4 жыл бұрын
@@gkcs Has anything changed with MongoDB 4.2, are the writes any faster considering we get to keep our consistency? Also, We know that NoSQLs go for Availability over Consistency but with MongoDB 4.2, you can guarantee the consistency and also I get to keep my availability by scaling across many shards. MongoDB 4.2 (FULLY ACID kzbin.info/www/bejne/n6bNZXueaqqErNE) They claim that they're "the only database to fully combine the ACID guarantees of traditional relational databases with the speed, flexibility, and power of the document model, and an intelligent distributed systems design to scale-out and place data where you need it." (www.mongodb.com/collateral/mongodb-multi-document-acid-transactions) Which also puts me to a question that why should I use RDBMS over MongoDB when with horizontal scaling I will have a hard time but with MongoDB 4.2 it's built-in with all it brings. Does MongoDB > RDBMS in 2020 after the 4.2?
@mdxytop
@mdxytop 4 жыл бұрын
@@ananyasharma1201 "why should I use RDBMS over MongoDB " -> because MongoDB is buggy as fuck. It's not reliable.
@RamziLebanon
@RamziLebanon 5 жыл бұрын
In a strange way, I watched this Video like a proud father lol You are amazing and it shows how much you care to explain rather than show off.
@gkcs
@gkcs 5 жыл бұрын
Thanks Ramzi!
@andys7384
@andys7384 5 жыл бұрын
It is a difficult skill to be able to understand/comprehend the lower layers of a given technology AND also be able to present it in a clear, concise manner that many can grasp. You have this skill and are able to present the data in a way that is simple with stacks that are complex. This is why being an "instructor" or "presenter" requires skills beyond just knowing the technology really well. Anyway, I appreciate the videos as its a wealth of valuable information!
@gkcs
@gkcs 5 жыл бұрын
Thank you!
@MdSheraj
@MdSheraj 3 жыл бұрын
In Cassandra, “strong consistency” is typically expressed as W + R > RF, where W is the write consistency level, R is the read consistency level, and RF is the replication factor.
@karthikeyansrinivasan52
@karthikeyansrinivasan52 4 жыл бұрын
When a Non DB guy can understand this.... there is nothing else as better ! Thanks a Ton for you Videos. Your Videos are one of the things that helped me through 2020 Lockdown.
@azurelearningsimplified1349
@azurelearningsimplified1349 3 жыл бұрын
Was just randomly browsing to know about NOSQL and I must say i couldn't move forward without watching full video and I feel confident with the concept. Thank you Gaurav
@shubhamqweasd
@shubhamqweasd 6 жыл бұрын
Great video as always :D, Just one correction , data is kept in self sorted structures like (AVL/ Red-Black Trees) in memory, and once the memory is past some threshold value (say ~50kb), then the entire memtable(the self sorted trees) are dumped into a SSTable (on disk) which is efficient as the data is already sorted.
@guruprashanthrao1093
@guruprashanthrao1093 5 жыл бұрын
Truth has been spoken at 9:26 "inner join,outer join,left join the things that we didn't read in college"
@deeproy7292
@deeproy7292 4 жыл бұрын
very true bro...after working in a job only we start to get to understand the real use of join and group by😜
@sandeepmishra5145
@sandeepmishra5145 4 жыл бұрын
College mai toh kuch bhi nhi batate hume khud hi krna padta h..😅😅😅 gfg h na
@deepanshuh_
@deepanshuh_ 6 жыл бұрын
Tomorrow is my Big data and data analytics exam and You uploaded this...........what a coincidence!
@gkcs
@gkcs 6 жыл бұрын
Yey!
@br34k3r2
@br34k3r2 6 жыл бұрын
kaisa hua exam XD
@samarthurs8000
@samarthurs8000 5 жыл бұрын
Greetings from Munich, Germany. Great video Gaurav. It needs a lot of preparation behind such great content. Kudos man!
@ShubhamJain-kb7zf
@ShubhamJain-kb7zf 6 жыл бұрын
One of the best explanation for nosql over youtube...so far... Keep up the good work
@gkcs
@gkcs 6 жыл бұрын
Thanks!
@karthikb6828
@karthikb6828 5 жыл бұрын
Hi Gaurav, Thanks for this great video and all other videos. I'm extremely benefiting by your videos. Basically, I'm a Mechanical Engineering graduate, with zero CS/dev background but currently work as a Technical Writer with one of top technology Giant in the world. I want to transition to product management and one of areas I lack is technical design. Yours videos are helping me in those aspects. Kudos your great effort. Appreciate every bit of it.
@gkcs
@gkcs 5 жыл бұрын
Thanks Karthik!
@juancpgo
@juancpgo 6 жыл бұрын
Sir, you are truly a great teacher. Thanks for sharing your knowledge so wisely.
@gkcs
@gkcs 6 жыл бұрын
Thank you!
@Happymejoyus
@Happymejoyus 5 жыл бұрын
wow, I am understanding now many things which I had already worked on and faced the technical issues and never used to get the "why" part from my architect's talks. Thank you Gaurav.
@paulkersey2424
@paulkersey2424 3 жыл бұрын
Then you were never an actual architect. Most people think they are architects, it takes time... Unless you got 20 years in multiple industries, companies, environments you can't be truly an architect. Working in MS, JAVA, WEB, Service, Networking, Infrastructure, CICD, UX, Security from every possible way I think I have a better understanding. This video is your novices or juniors not architects
@Happymejoyus
@Happymejoyus 3 жыл бұрын
@@paulkersey2424 I'm not.. I was a developer. I mean to say.. my project's architect - my boss. 😳
@rajcodingworld7768
@rajcodingworld7768 5 жыл бұрын
21:50 Two corrections 1) Cassandra do not store log file in-memory. Rather it stores on disk. That's how it can recover from during failures 2) Cassandra do not append in-memory it rather appends to commit log on disk. So, in-memory the data is sorted Memtable. When it reaches certain limit then it flushes to the disk on SSTable
@prathibhapb
@prathibhapb 3 жыл бұрын
7:35 - usually most NoSQL databases have secondary indexes that make that kind of querying faster. Great video, thanks
@RohitSharma-cw2ii
@RohitSharma-cw2ii 6 жыл бұрын
Great little bro..you looks so young but good skill on explanation..
@gkcs
@gkcs 6 жыл бұрын
Thanks!
@hellbird1381
@hellbird1381 4 жыл бұрын
omg bhai..u jus like my frnd who teaches me one day b4 exam and i get salvation enlightened whole universe gets cleared which i try to understand and learn whole 6 months with teachers faculty staff and didn't understand :)
@griseldabalmaceda4943
@griseldabalmaceda4943 5 жыл бұрын
THANK YOU SO MUCH!! Read my reading assignment for my NoSQL class and understood most of the things but needed to see all these new concepts in action! Thank you for providing an excellent run through and example! LIKED AND SUBSCRIBED!!!
@gkcs
@gkcs 5 жыл бұрын
Glad to hear that!
@interviewchamp
@interviewchamp 5 жыл бұрын
This boy is really good.Great content
@iamshadmirza
@iamshadmirza 5 жыл бұрын
I am wondering how much time it took you to grasp this much knowledge. Recently followed your channel and it feels like I found a treasure of knowledge. I love to learn and this is a delight.
@gkcs
@gkcs 5 жыл бұрын
Thank you!
@msvardhan19
@msvardhan19 2 жыл бұрын
Hey, Gaurav. I appreciate all of the work you put into this series. I had no prior knowledge of system design, but after watching these videos in 3 days, I was able to pass the system design round at a reputable company. I can't thank you enough for this.
@gkcs
@gkcs 2 жыл бұрын
That's amazing, congratulations!
@pallavisingh2912
@pallavisingh2912 5 жыл бұрын
You've made System design a real fun concept to read about! Thanks a lot
@gkcs
@gkcs 5 жыл бұрын
Thanks Pallavi!
@debsworld3784
@debsworld3784 Жыл бұрын
Great video , it’s like going back to college after 14 years in the industry .. Thanks and keep it up
@aishr11
@aishr11 11 ай бұрын
Superb teaching! Very intuitive, practical and actionable. I'm glad I found this channel & everyone who finds this is lucky. I wish our high school or college teachers would be this adept at teaching. Kudos!
@skdh2006
@skdh2006 6 жыл бұрын
Guarav, thank you for the awesome videos. I am applying for entry-level software engineering jobs and this is helping me a lot for companies which test system design skill of their candidates.
@gkcs
@gkcs 6 жыл бұрын
Great to hear that 😁
@arezanet
@arezanet 2 жыл бұрын
thank you. i finally understand 'schema'. i'm only 4:44 in, paused the video to post this.
@learnandsharelive
@learnandsharelive 5 жыл бұрын
How I look RDBMS and NoSQL databases are used based on the requirements or use cases. So, while designing any application we need to understand them first which @GS has done very well. I love your presentation skills @GS and I won't mind mentioning the same in your videos. Keep it up👍
@victorcaldentey6295
@victorcaldentey6295 5 жыл бұрын
About Cassandra, you are explaining the concept of Consistency Hashing, is used in Cassandra but also in many other systems!
@mathematicalninja2756
@mathematicalninja2756 6 жыл бұрын
dude this format is awesome i just love your channel man may you get all success in life
@gkcs
@gkcs 6 жыл бұрын
Thank you!
@ManishPushkarVideos
@ManishPushkarVideos 4 жыл бұрын
Every time I am preparing for Interview, I will revise all the topics by watching your videos. Thanks for the awesome content.
@SarabjotSingh294
@SarabjotSingh294 5 жыл бұрын
Truly amazing video. So perfectly described NoSql and RDBMS. Thank you so much.
@jayaram.ramanarayanan
@jayaram.ramanarayanan 6 жыл бұрын
11 seconds passed and I gave a like to the video. Great job!
@gkcs
@gkcs 6 жыл бұрын
😁
@bilguunchinzorig9532
@bilguunchinzorig9532 6 жыл бұрын
this is the first IT explanation video made by Indian guy, that I enjoyed watching
@gkcs
@gkcs 6 жыл бұрын
I hope you find many more in future 😁
@ansumansatapathy8914
@ansumansatapathy8914 6 жыл бұрын
Maybe start looking at people as the person instead of viewing them in terms of race, nationality, gender. etc.
@deepak9976
@deepak9976 5 жыл бұрын
if your are in java u should watch tutorial from java brains .. ur perception will change.
@NiiAnikin
@NiiAnikin 4 жыл бұрын
Wow. The first intuitive video tutorial on NoSQL ... Finally
@ArjunSingh-oo1mh
@ArjunSingh-oo1mh 5 жыл бұрын
the great thing in your video is that you give practical examples. THANK YOU. I will continue watching your videos.
@ARCHITSANGHVI13
@ARCHITSANGHVI13 5 жыл бұрын
The way you represent your knowledge is just amazing. Many people on youtube have good knowledge but don't know how to represent their knowledge to others and explain them. Your way of explaining is just fabulous. Enjoying system design series as a Netflix series. haha.
@gkcs
@gkcs 5 жыл бұрын
Haha 😁
@viveksharma9564
@viveksharma9564 4 жыл бұрын
Damn!! why does liking something complex gives me a vicarious feel of being intelligent?
@naveentrivedi8074
@naveentrivedi8074 5 жыл бұрын
This is by far the best explanation for SQL vs No SQL DBs. Kudos.
@kratitiwari2850
@kratitiwari2850 3 жыл бұрын
Thanks dude for explaining Cassandra in such a simple manner.. kudos
@AnkitaNallana
@AnkitaNallana 4 жыл бұрын
Great video as always! Really enjoyed the bit where you talk about major applications using RDBMS (the intro). Thank you for this - I learnt a lot!
@gkcs
@gkcs 4 жыл бұрын
Thank you 😁
@KartheekGanesh
@KartheekGanesh 6 жыл бұрын
"Why don't we become optimists as engineers?" 🤣🤣 Yea right I wish. Thanks for the upload !
@gkcs
@gkcs 6 жыл бұрын
Hahaha 😛
@sdfg204
@sdfg204 6 жыл бұрын
Awesome video bro, very simple explanation of pros and cons. Also good coverage with the cassandra cluster. Some add-on information: All companies at this time, do use a combination of these DBs, obviously using RDBMS at priority transactions. NoSQL though is maintained for ever-changing attributes, which are of lesser importance, e.g. Editable/non editable comments, vote count etc., basically every attribute that company can term under eventual consistency(refer computerphile on ytb). The reason here is because of the nature of NoSQL being a document-based db, one could simply queue all the requests onto isps or the client side, and merge these updates in form of an inverted tree. NoSQL is also used extensively as cache for Sql based data, which needs extensive join operations, or simply for basic but simultaneous queries. In this way many companies buy time for development of a proper solution(db/model overhaul is last of them as opposed to the obvious belief) without losing trust amongst consumers. Cluster of NoSQL db would be of slightly much less use than of sql based one. NoSQL is made majorly for handling client-side, because of its state conforming nature. Its a request to discuss master slave db configuration pros and cons too, it makes your Quorom problem both simpler to understand, and also solve the scaling perspective of things, without taking any unusually extra space.
@gkcs
@gkcs 6 жыл бұрын
I will be discussing master slave soon. I am not entirely sure of your claim that NoSQL is used mainly for client side stuff though 🙂
@sdfg204
@sdfg204 6 жыл бұрын
@@gkcs mostly for handling multiple request from client, do see eventual consistency I mentioned. Obviously, its a tool with many different applications, with good use it can be made out to be anything. Just a noob, happy to learn 😉
@gkcs
@gkcs 6 жыл бұрын
I see. You are right, it has many applications :D
@susmitapatil4847
@susmitapatil4847 10 ай бұрын
Great teacher I ever saw. I was really confused about the system design concept but after watching your videos it is very clear. Really thanks for such amazing content. Keep doing good work.
@gkcs
@gkcs 10 ай бұрын
Thank you!
@vaibhavsouveer
@vaibhavsouveer 3 жыл бұрын
Great video Gaurav. You have simplified it so much. I have one doubt though... At 6.20 when you are mentioning the 4th point, you say NoSQL are good for metrics/analysis, etc. because it easier to perform operations like average age, total salary, etc. At 7.30 you are saying these are not read optimized because data will have to be read from each blob of data and then perform some operation like sum or average. I am confused about this part.
@india01061992
@india01061992 26 күн бұрын
I had the same question and on little research turns out that noSQLs are not read optimized for any "out of syllabus" queries. "NoSQLs are good for metrics/analysis/aggregation" when 1. patterns are pre-defined 2. related data is inserted in the same document (denormalization) using this information 3. indexing is used "data will have to be read from each blob" is a problem when 1. the query is not a direct key-lookup 2. the query requires analytics/aggregation on non-indexed data 3. the query requires fetching data from multiple nodes in a distributed architecture causing network latency 4. DB with eventual consistency might cause delay reading the most up-to-date data 5. DB with strong consistency read level might cause delay in reading from multiple replicas and fetching correct response with quorum This is my understanding so far.
@fsl4faisal
@fsl4faisal 6 жыл бұрын
the beginning was some ninja editing skills..!! the video as always very informative.. Thank you..!
@gkcs
@gkcs 6 жыл бұрын
Thank you!
@techable7524
@techable7524 5 жыл бұрын
Love your videos dude! Just watched about 8 of them and I now use them in the gym because you can pretty much follow along just listening to you :-) Quick Tip: Set your camera to manual focus and increase the aperture (will keep everything in focus) a little as your camera 'hunt's for focus and is a bit distracting on the eye. Love the quality your producing so please keep them coming!
@gkcs
@gkcs 5 жыл бұрын
Thanks! I'll make sure to apply these tips 😁
@designrknight
@designrknight 4 жыл бұрын
Just to put an example, Royal Bank of Scotland uses MongoDB, a No-SQL database. So both SQL and No-SQL are in present day screnario, equally lucrative
@amith1989
@amith1989 4 жыл бұрын
This is the first video of yours that I saw but amazing way of explaining bro. This video is great for someone like me who had absolutely zero idea about NoSQL Databases since I have always worked with Relational Databases only. Subscribed!
@justicedoesntexist1919
@justicedoesntexist1919 2 жыл бұрын
The cute double role in the beginning gets me in his videos!
@anastasianaumko923
@anastasianaumko923 Жыл бұрын
Introduction is hilarious, so cool 🤣🤣🤣 The video is elaborate and educative, thank you! 🤩
@killbuzzygamer3220
@killbuzzygamer3220 3 жыл бұрын
sir bohut badiy TARIKE SE explain kiya hain apne ......dhonnobad
@logicsandtrolls3616
@logicsandtrolls3616 3 жыл бұрын
Nice. You could add below - 1. NoSql might have a upper limit on amount of data you can store. 2. If you have to write to multiple tables/rows at the same time and do like a group commit, this might get limited in noSql.
@RachitJain
@RachitJain 6 жыл бұрын
Hey, 1. When you say that NoSQL is better for insertion and retrieval, you say that Relational DBs are slower because you will have to join the two tables with address as foreign key. If that's the scenario, we should not normalize the table here and have address also in the same table for faster reads. Also, locks are still present in implementations of NoSQL DBs because of concurrency. So both are comparable actually and anyone can be slower than the other as it depends on the way you have decided the structure to store data. Ofcourse, retrieving data with a join in SQL will turn out to be slower. 2. Then at 7:58 you say NoSQL is not read-optimized and in advantages you mentioned its used for aggregations as well as. I think it makes sense not to have such comparisons made out as NoSQL databases can be implemented in variety of ways. In-memory databases are also subset of NoSQL and pretty pretty fast to read because of RAM coming into play. Talking about consistency at scale, one is user's choice of stronger v/s eventual but we can't say that Relational DBs will be slow because locks will still be there in implementations of NoSQL databases because of concurrency. To win that, we have concept of granular locks in Relational Databases so that lock is placed only on necessary part. I think the journey to scale any database is pretty complex and only experience can teach us exactly how to do that. KZbin is running on Relational DB after all - but I am sure its much more complex with portions of NoSQL, CDNs, caching, and what not flying around in their backend architecture.
@gkcs
@gkcs 6 жыл бұрын
Hey Rachit, thanks for the good insights. Here are my thoughts: 1. We "shouldn't" normalize a table is a difficult decision to make. Normalizing offers a logical break up of the data, ACID properties and is the way SQL databases are designed to run. It's true that a lot of systems run their analytics on NoSQL databases. The reason for this is the non-normalized form of data in these tables. 2. I made a mistake here, you can have a look at the pinned comment for clarifications. Reads and writes are usually faster in NoSQL, because it is rare to take a ton of locks in these tables. Aggregations are faster if you have a columnar database, and that along with faster read times contribute to the performance. The implementation decisions influence a lot of how a database performs, but the core ideas on which it runs are very important. The NoSQL databases are, by definition, denormalized and expected to take fewer locks. Eventual consistency, Quorum and Fast updates are selling points of databases like Cassandra. Using them for diametrically opposite goals wouldn't be wise, in my opinion.
@indiansoftwareengineer4899
@indiansoftwareengineer4899 6 жыл бұрын
So finally, which is faster to retrieve all values in Age-column?
@gkcs
@gkcs 6 жыл бұрын
@@indiansoftwareengineer4899 NoSQL.
@indiansoftwareengineer4899
@indiansoftwareengineer4899 6 жыл бұрын
@@gkcs Thanks Gaurav Bhai for reply.
@TrulyLordOfNothing
@TrulyLordOfNothing 5 жыл бұрын
@@gkcs I don't get the part that aggregates are faster in NOSQL than SQL at 06:21. How is total salary at 06:21 in NOSQL faster than find all ages of all employees in company at 7:30? Both will require getting each blob, parsing etc which won't happen in SQL columnar table. appreciate your reply.
@borisvoychev7534
@borisvoychev7534 3 жыл бұрын
Great Video Gaurav! I just want to add that apache Cassandra use LSM (Log Structured Merge Trees). The idea is that they want to avoid updating records when using SSD(Solid State Drive) due to the fact that they allow X number of updates before they die. Using LSM they just append new values no matter if they exists or no and as you mentioned they mark the old records with a tombstones.
@gkcs
@gkcs 3 жыл бұрын
kzbin.info/www/bejne/lWbZo5mrrM2porM
@bonniwanamaker6296
@bonniwanamaker6296 5 жыл бұрын
Hey this is great refresher. Not only is it well explained but you make it entertaining :) Keep it up!
@mayankshrivastava1051
@mayankshrivastava1051 2 жыл бұрын
Thanks!
@gkcs
@gkcs 2 жыл бұрын
Thank you!
@mihirit7137
@mihirit7137 2 жыл бұрын
the editing in the first 2 mins was on point!
@vmohakrish
@vmohakrish 2 жыл бұрын
vow are your videos always so fun.Dont know how I got to know this channel to late
@gero8049
@gero8049 3 жыл бұрын
Thats the first introduction that was acctualy an introduction. Great Video.
@rakshitkoyani1655
@rakshitkoyani1655 2 жыл бұрын
nice explanation. now a days very few teachers teaches on the board which is easy to grab a concept at 1st pace
@starlord9220
@starlord9220 6 жыл бұрын
😍ur content quality is increasing + information provided is clear
@gkcs
@gkcs 6 жыл бұрын
Thank you!
@umaer2044
@umaer2044 6 жыл бұрын
@Gaurav_Sen bother hope you are doing well. I just saw you on KZbin.. I really appreciate for what you are doing... Sharing knowledge.. 🙏 🙏 🙏 🙏 🙏.
@gkcs
@gkcs 6 жыл бұрын
Thank you!
@ru2979
@ru2979 2 жыл бұрын
The plot of this video is dope 🔥🔥🔥
@jksharma7
@jksharma7 5 жыл бұрын
Mr. Gaurav..... You are a BORN TEACHER Sir.... Thanks.
@gkcs
@gkcs 5 жыл бұрын
Thank you!
@yashjain-wj1eg
@yashjain-wj1eg 4 жыл бұрын
Thanks man! I was asked sharding and sql vs no sql in my interview and was able to answer them perfectly and crack the interview as well. Thanyou Again.
@gkcs
@gkcs 4 жыл бұрын
Yey, congratulations 😁
@yashjain-wj1eg
@yashjain-wj1eg 4 жыл бұрын
@@gkcs keep making such videos to help students like us! Thankyou!
@rshankarVids
@rshankarVids 4 жыл бұрын
The video is great, with lots of information, but there are many controversial statements like: 1. Joins are pretty expensive. 2. You need locks to maintain consistency when adding a new column. 3. NoSQL data bases can be optimized for reads. 4. The example taken for the noSQL database is very naive too. You can have N number of columns storing the same data in deserialized format. etc. The video gives a good bookish knowledge but be ready to get cross questioned when you use the concepts.
@abhijitghatnekar9347
@abhijitghatnekar9347 4 жыл бұрын
Great video, Gaurav! I wanted to add a point. In the video you mentioned a disadvantage that Joins are hard in NoSQL. When you're dealing with extremely large data-sets, you probably would want to avoid joins. If you -use a NoSQL database in a relational manner, i think its probably not worth it. In that case, you're better off using an RDBMS..
@serez18
@serez18 3 жыл бұрын
Great video. Very informative and well organized! I'd like to update that RavenDB is a noSQL database that offers ACID certification for transactions.
@Manwithsteelnerves
@Manwithsteelnerves 4 жыл бұрын
Upcoming video idea : Give a brief on all current trending databases, pros and cons and when to pick each
@mufty9006
@mufty9006 2 жыл бұрын
The intro was extra fun😀 and educative I LOVE IT❤😂
@dhananjaynagargoje6487
@dhananjaynagargoje6487 6 жыл бұрын
Saturday morning breakfast while watching your video 😁
@christophersamk5584
@christophersamk5584 5 жыл бұрын
Regarding quorum of 3 and missing data, if you want your system to be highly consistent, you can do it while writing the data. Say, if you have 3 replicas, make sure the write succeeds only if they data is written on all the three nodes. This obviously has some drawbacks of delay in write but if consistency is all you care about, this approach would help overcome missing data. In CAP, you are compromising on availability here.
@gkcs
@gkcs 5 жыл бұрын
That's correct.
@AndhraKitchenFoods
@AndhraKitchenFoods 3 жыл бұрын
Excellent presentation on NoSQL DBs.
@navjhs
@navjhs 3 жыл бұрын
Gaurav....you are just awesome. What a great skill you have. Thank you.
@Kesodhya
@Kesodhya 4 жыл бұрын
You guys rock! I loved the way you have explained things here.....AND, humor always helps :)
@gkcs
@gkcs 4 жыл бұрын
Thank you!
@swarajgupta3087
@swarajgupta3087 2 жыл бұрын
Thanks Gaurav ! Quorum: सदस्‍यों की वह न्‍यूनतम संख्‍या जिसके होने पर ही बैठक में निर्णय लिए जा सकें !
@gkcs
@gkcs 2 жыл бұрын
Wow!
@adnanbadar6981
@adnanbadar6981 4 жыл бұрын
Very Precise, Keep it up Gaurav. Excellent Job!
@fiveyearclub6024
@fiveyearclub6024 5 жыл бұрын
Another awesome video. I've been using mongodb successfully for 6+ years but never got into the weeds about how it compared to MySQL.
@md.abdullahal-alamin8059
@md.abdullahal-alamin8059 6 жыл бұрын
Great video. Please make a detailed video on Redis or distributed cache system
@gkcs
@gkcs 6 жыл бұрын
Coming up 😁
@Manu-mr4mn
@Manu-mr4mn 6 жыл бұрын
Wow usually I avoid videos with people who are Indian or something like that, just because the accent is hard to understand and the quality is not so good. But this video is amazing! Great job, I’ve subscribed!
@gkcs
@gkcs 6 жыл бұрын
Thank you 😁
@Manu-mr4mn
@Manu-mr4mn 6 жыл бұрын
Gaurav Sen No problem! Great content I like your channel. I would love to see more videos like this! :)
@gkcs
@gkcs 6 жыл бұрын
@@Manu-mr4mn They will be coming soon!
@TusharParekhtpar2014
@TusharParekhtpar2014 4 жыл бұрын
Very Good explanations and correlations . Thank you very much for the knowledge shared !
@shubhranshukumar1814
@shubhranshukumar1814 5 жыл бұрын
I am kind of confused that how No-SQL databases can have the read time as a disadvantage along with data aggregation as an advantage. Isn't a lot of read required for aggregating the data?
@amythpaddy8527
@amythpaddy8527 5 жыл бұрын
Same question. And from my experience I did not find data aggregation easy for nosql data. Am I doing something wrong?
@sigfrido86
@sigfrido86 5 жыл бұрын
I think that the key is database sharding and partitions. If you don't take this into account, read across partitions its a very expensive operation. If your database is well design, then you are ok.
@vitthalsarode5149
@vitthalsarode5149 5 жыл бұрын
@@amythpaddy8527 I think what Gaurav means is most of NoSQL databases give inbuilt support for aggregation like mongo. Please go through this link you might get your answer docs.mongodb.com/manual/core/aggregation-pipeline/
@obiwon84
@obiwon84 5 жыл бұрын
I think read performance can vary a lot for each NoSQL database. To further complicate the matter small reads vs large batch reads could have vastly different performances. Data aggregation tends to be large batch reads I would assume. Perhaps that is the reason for his statements?
@Manoj-tb1lv
@Manoj-tb1lv 4 жыл бұрын
if consistency is relaxed, then read is faster in Nosql, else consistency adds an overhead .
@MrJosejohny
@MrJosejohny 5 жыл бұрын
Very crisp, clear and simple explanation Gaurav Sen ...Thanks a lot...
@vimleshkumarkanaujiya
@vimleshkumarkanaujiya 4 жыл бұрын
Bahut Sahi Kar raho Ho Sen Bro. People want videos from video. Expectations from you.
@praveenjayaraman2644
@praveenjayaraman2644 5 жыл бұрын
Amazing video. Can't wait for the quorum and consensus video. Thank you for sharing your knowledge.
@lukebakare9423
@lukebakare9423 6 жыл бұрын
10 seconds in subscribed First video I am watching. Know I will enjoy your content
@gkcs
@gkcs 6 жыл бұрын
Thanks!
@FiorianCanuck
@FiorianCanuck 5 жыл бұрын
Bro! I just found your channel, new sub! This was funny and very informative. You're a rare gem!
@myth00s
@myth00s 3 жыл бұрын
The term "relation" in RDBMSs does not refer to the referential integrity achieved with foreign keys, but to the structure we more commonly refer to as "table" - a set of rows / tuples.
@NileshwarShukla
@NileshwarShukla 6 жыл бұрын
Apart from technical expertise you are also trying to specialise in video effects 😊
@gkcs
@gkcs 6 жыл бұрын
Yup!
@bhaskaraggarwal8971
@bhaskaraggarwal8971 3 жыл бұрын
Superb! Very clearly explained...and the beginning was hilarious😃
@paragsomani5696
@paragsomani5696 4 жыл бұрын
You are doing a super work in a super excellent way.Best wishes.
@RaviKumar-vk6ib
@RaviKumar-vk6ib 5 жыл бұрын
I feel like watching a movie...Your videos are entertainment+enjoyment+knowledgeable uniqueness awesomeness
@abdulsalamibrahim2927
@abdulsalamibrahim2927 5 жыл бұрын
You're really awesome gaurav... Really appreciate taking your time to teach these concepts... Hoping for more eye opening contents!!
@gkcs
@gkcs 5 жыл бұрын
Thanks 😁
@ujjwal94roy
@ujjwal94roy 6 жыл бұрын
Amazing explaination for a noob. Nice job
@gkcs
@gkcs 6 жыл бұрын
Thanks!
@starkhunt2684
@starkhunt2684 2 жыл бұрын
Bro you should upload 1 min or 30 sec separate video of that intro clip which discusses Difference between NOSQL & SQL!! It is great🤣🤑
@swarnendu86
@swarnendu86 3 жыл бұрын
Very compact and informative, thanks
What is an API and how do you design it? 🗒️✅
15:26
Gaurav Sen
Рет қаралды 756 М.
What is DATABASE SHARDING?
8:56
Gaurav Sen
Рет қаралды 961 М.
Une nouvelle voiture pour Noël 🥹
00:28
Nicocapone
Рет қаралды 9 МЛН
Introduction to NoSQL • Martin Fowler • GOTO 2012
54:52
GOTO Conferences
Рет қаралды 995 М.
Google system design interview: Design Spotify (with ex-Google EM)
42:13
IGotAnOffer: Engineering
Рет қаралды 1,2 МЛН
7 Database Paradigms
9:53
Fireship
Рет қаралды 1,7 МЛН
SQL vs NoSQL or MySQL vs MongoDB
21:30
Academind
Рет қаралды 1,9 МЛН
Database Sharding and Partitioning
23:53
Arpit Bhayani
Рет қаралды 114 М.
WHATSAPP System Design: Chat Messaging Systems for Interviews
25:15
Gaurav Sen
Рет қаралды 1,9 МЛН