In: Computer Science
Compare the Data Modeling difference between relational database and NoSQL MongoDB.
Relational Database | NoSQL MongoDB |
1.RDBMS is completely structured way of storing data. | 1.While the NoSQL is unstructured way of storing the data. |
2. And another main difference is that the amount of data stored mainly depends on the Physical memory of the system . | 2. While in the NoSQL you don't have any such limits as you can scale the system horizontally. |
3. Extremely large datasets are often event based transactions that occur in chronological order. Examples are weblogs, shopping transactions, manufacturing data from assembly line devices, scientific data collections, etc. These types of data accumulate in large numbers every second and can take a RDBMS with all of its overhead to its knees. But for OLTP processing, nothing beats the combination of data quality and performance of a well designed RDBMS." |
3. NoSQL is a very broad term and typically is referred to as meaning "Not Only SQL." The term is dropping out of favor in the non-RDBMS community. |
4. structures are less strict as relational schema | 4. NoSQL databases also have a structure to store data |
5. Relational databases are not complement in database field | 5.NoSQL databases are a complement in database field |
6.RDBMS you can't define this kind of relations except in terms of foreign keys and some other techniques. | 6. Graph Databases is also a very popolar NoSQL database. . Examples of the popular graphical database are Neo4j, OrientDB, InfiniteGraph, AllegroGraph etc. |
7. Software that relies on RDBMS can only use pure SQL (with some vendor-specific extensions ) to process data or ORM wrapper. | 7. Software, that use NoSQL, must be implement through usage of some wrapper that are build around the NoSQL database engine (use some API that are specific to every single NoSQL implementation). |
8.RDBMS stands for Relational Database Management System, but not for "Relational Model" proposed by Codd in 1970. First prototype of RDBMS (System R) appeared in 1974 and commercially available products appeared in 1980. So, it means that first "usable" and "stable" versions of RDBMS implemented around 10-15 years after Codd's first publication about relational models. | 8. NoSQL started to gain popularity after appearance of BigTable, published by Google in 2006, and they not only published "model", they already used BigTable implementation in the production. However, despite the fact that Google is using(or used) BigTable and there are multiple available implementations of NoSQL (Cassandra, HBase, MongoDB etc.) this filed is still in infant stage and needs to be researched more deeply . |