Это видео недоступно.
Сожалеем об этом.
Why are joins not possible in NO-SQL Databases ? | SQL vs NO-SQL | Arpit Bhayani | Part 2
HTML-код
- Опубликовано: 12 янв 2023
- Why are joins not possible in NO-SQL Databases? | Similarities and Differences | SQL vs NO-SQL | Arpit Bhayani | Techie007
Hello everyone,
Welcome back. This is part 2 of the podcast with @AsliEngineering in which we discuss more on SQL and No-SQL databases. We left part 1 on a cliffhanger where we were discussing why are joins not possible in No-SQL databases. Let's find out.
Connect with Arpit on LinkedIn: / arpitbhayani
Subscribe to his channel: / @asliengineering
#softwaredevelopment #sql #mongodb
Very informative questions, Looking for more content like this
Thank you so.much Adarsh.
Great discussion on SQL & NoSQL transactions. Some simple terms to add on:
SQL -> Transaction, CP, Master Slave, Raft
NoSQL -> No-Transaction, AP, Active-Active geo distribution, CRDT
NewSQL -> New-Transaction, CAP, Distributed, YugaByteDB
Thanks for sharing.
Video on How RUclips vanced and brave browser works?
How are blocking ads?
And why YT is not doing anything about that?
Will do
Awesome.... Just Awesome..
Thank you so much 😀
Amazing conversation. Thank you for posting this.
Glad you enjoyed it!
Both Part is Awesome👋👋👋
Thank you so much :)
I got confused in the part where earlier we said that SQL DB in a Master-Slave architecture is eventually consistent due to asynchronous replication but then we also recommended using SQL DB if ACID compliance is needed.
SQL DB in a Master-Slave architecture is very a common use-case and if we cannot guarantee ACID properties with it, then it makes SQL DB very restrictive in terms of the highly claimed ACID properties associated with it.
In most of the business use cases, you don't need strong consistency. Eventual consistency with read replicas serves the purpose. But if you want ACID, then it restricts SQL DB to single node and hence vertically scalable.
@@Techie007 But what about big banks like SBI, where you have to have strong consistency and data is also huge?
@@rkisdpeven financial transactions are not consistent..there is always a nightly settlement of all transactions where they can be considered committed
How Google Spanner combines NoSQL and SQL traits? How it ensures ACID along with CAP even after being a NoSQL database?
I really enjoyed watching the videos on databases, both Part 1 and Part 2 were fantastic.
Thank you so much.
Firstly great video. I did not understand the line that sql without foreign keys/constraints is similar to nosql. Maybe, some explanation or deeper dive on that with an example maybe.
It is simply because if there is no foreign key, then joins in SQL won't be possible the way they are today. You would have to do a join like you would do in No-SQL. Bring data from 2 tables and join them yourself.
Awesome 👍
Thanks 🤗
What about we have say cassandra just one node cluster then join should be possible atleast?
if SQL DBs are inherently used for ACID use cases and are predominantly single node ( compared to NoSQL which are mostly distributed ), doesnt it make SQL inherently less scalable by design, as you are restricted to a single node and hence can only do vertical scaling ?
P.S - great video btw , interesting topic !
Sometimes, we can tolerate eventual consistency even though we still want to use the interface provided by sql in terms of relationships. So, we drop the consistency constraint and use it.
Considering if we need ACID, then it is just vertically scalable.
With all due respect, you should stop all the 'Umm', 'Hmm' etc, that you do while the speaker is talking. It isn't very pleasant and hampers the whole flow.
Thanks for the feedback.
Video on How RUclips vanced and brave browser works?
How are blocking ads?
And why YT is not doing anything about that?
Will do