Welcome to the discussion about this lecture. Here you can ask questions or post feedback about this specific lecture.
1 Like
@ivan, the final quiz question might be not consistent enough. See the explanation of my opinion below :
Not sure why âNO SQLâ database is not applicable to the mission critical finance app. I guess, it is supposed to have a âconsistentâ trait mentioned in the CAP theorem.
Maybe it should have âavailabilityâ trait given my understanding of âmission criticalâ is correct. It does not really matter if the database engine has SQL as a query language or not.
Here are some good examples :
- dBase
- Clipper
- Fox Pro
All of them were used in financial applications and they do not have SQL (since it has not been invented or popularized yet back then)
The statement NO SQL == MongoDB is incorrect since it is not transitive. Meaning mongo is a NO SQL database but Not any NO SQL database is Mongo DB.
P.S. Here is a good book on databases to mention if you have not done so yet
6 Likes
All good until now thanks for the course is really helpfull
1 Like
Thanks for these added details.
After that, I do think the 3rd quiz question should have been better precised: for instance, atomic updates needed or not? with excluding answers
Very helpful - thank you all.
Technology has come along way since I was in College, very enlightening, this digital world.
1 Like
Hi,
As per my understanding, an SQL database is also known as âRelational Databaseâ where data is structured. It also focuses on a relational model, and therefore I believe that the correct answer to the question is âWhenever you know that the data has a strict structure and relationshipsâ, instead of the first one, i.e., âwhenever you know that the data is semi-structuredâ.
Could someone please advise on this and correct me if Iâm wrong? Thank you in advance.
1 Like
Can someone give me more explanation on this. From my understanding SQL is all about well structured and Relational data, why then is the answer wrong?
1 Like
Hey @JoJo, @rishibehl4, hope you guys are well.
Not all the times you know the structure of the data, all you know if that the data might need some structure or relationships between them, so the correct answer is âwhenever you know that the data is semi-structuredâ. Because not always you will know that information from the data, so SQL is just applied to data that needs an structure or relations, when you know there must be some kind of structure between them (semi-strucutre).
Hope it helps.
Carlos Z
2 Likes