- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference between RDBMS and MongoDB
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.|
- Difference between RDBMS and OODBMS
- Difference between DBMS and RDBMS
- Difference between RDBMS and HBase
- Difference between MySQL and MongoDB
- Difference between count() and find().count() in MongoDB?
- Difference between find() and findOne() methods in MongoDB?
- MongoDB difference between show dbs and show databases?
- RDBMS terminologies
- What is the difference between deleteOne() and findOneAndDelete() operation in MongoDB?
- Difference between NumberLong(x) and NumberLong(“x”) in MongoDB?
- Difference between “now” and a given date with MongoDB?
- Future of RDBMS
- Composite Key in RDBMS
- Secondary Key in RDBMS
- Super Key in RDBMS