RDBMS stands for Relational Database Management System. It stores data in form of entity as tables. It provides multiple layers on information security. Each table may or may not have a primary key which identifies a record uniquely in a table and a foreign key which indentifies the relationship between two tables. RDBMS uses SQL language to query databases. Examples of popular RDBMS are oracle, sql server, mysql etc.
MongoDB is a NoSQL database. It is open source. It is a document oriented database and it uses BSON which is binary version of JSON. BSON is a document storage format. MongoDB stores data in form of documents and do not use SQL to query databases. It supports distributed servers and provides a rich data model.
|1||Concept||RDBMS is a relational database management system and works on relational database.||MongoDB is a non-relational, document oriented database management system and works on document based database.|
|2||Hiearchical||Difficult to store hiearchical data.||Have inbuilt support to store hiearchical data.|
|3||Scalablity||RDBMS is vertically scalable. Performance increases with increase of RAM.||MongoDB is horizontally scalable as well. Its performance increases with addition of processor.|
|4||Schema||Schema need to be defined in RDBMS before using a database.||Schema can be dynamically created and accessed in MongoDB.|
|5||SQL Injection||Vulnerable to SQL Injection attack.||SQL injection is not possible.|
|6||Principle||Follows ACID principle, Atomicity, Consistency, Isolation, and Durability.||Follows CAP theorem, Consistency, Availability, and Partition tolerance.|
|7||Basis||Database uses Row.||Database uses Document.|
|8||Basis||Database uses Column.||Database uses Field.|
|9||Performance||RDBMS is slower in processing large hierachical data.||MongoDB is blazingly fast in processing large hierachical data.|
|10||Joins||RDBMS supports complex joins.||MongoDB has no support for complex joins.|
|12||Query Language||RDBMS uses SQL to query database.||MongoDB uses BSON to query database.|