I am searching web to understand the underlying concept of how actually information is stored in RDBMS and Nosql databases and found this:
In the world of database technology, there are two main types of
databases: SQL and NoSQL—or, relational databases and non-relational
databases. The difference speaks to how they’re built, the type of
information they store, and how they store it. Relational databases
are structured, like phone books that store phone numbers and
addresses. Non-relational databases are document-oriented and
distributed, like file folders that hold everything from a person’s
address and phone number to their Facebook likes and online shopping
preferences.
Here i can understand that in SQL based databases data is stored in form address and data and in NoSql everything is stored in one document.
Please correct me if I am wrong.
Can someone explain this with help of example.
Best Answer
RDBMS (Relational database management system) : is using SQL (Structured Query Language) to define and manipulate data. and it is used for large and complex query handling. in-order to work with RDBMS you need to define a structure (schema, table, constraints, ...etc). as an example (out of a town in-order for the people to live together they need to speak the same language, have a infrastructure, laws,..etc
NoSQL (Not only SQL "none relational database"): it is like a blog, you can store the data any way you like (some use a something like table called column oriented, document oriented, graph-base, KeyValue (one of the most common uses of keyValue to call data and store them in JSON file). as an example earth since there is no common structure to be used or a define language that all people speak, the way they build houses, and infrastructure is different but differences between one place and another doesn't effect other places.
I found this image as an example in https://www.upwork.com it explain a the differences between RDBMS and NoSQL in another way.
Useful URLs:
https://www.upwork.com/hiring/data/sql-vs-nosql-databases-whats-the-difference/
https://medium.com/xplenty-blog/the-sql-vs-nosql-difference-mysql-vs-mongodb-32c9980e67b2 (this can be used as an exmaple)
What are the differences between NoSQL and a traditional RDBMS?