RDBMS stands for Relational Database Management System. It stores data in entity form as tables. It provides multiple layers of information security. Each table may or may not have a primary key (used to uniquely identify records in the table) and foreign keys (used to identify the relationship between the two tables). RDBMS uses SQL language to query the database. Examples of popular RDBMS are oracle, sql server, mysql, etc.
MongoDB is a NoSQL database. It's open source. It is a document-oriented database that uses BSON (the binary version of JSON). BSON is a document storage format. MongoDB stores data in the form of documents and does not use SQL to query the database. It supports distributed servers and provides a rich data model.
| Sr. Number | Key | RDBMS | MongoDB | |
|---|---|---|---|---|
| 1 | Concept | RDBMS is a relational database management system that works on a relational database. | MongoDB is a non-relational, document-oriented database management system suitable for document-based databases. | |
| 2 | Hierarchical | It is difficult to store hierarchical data. | Has built-in support for storing hierarchical data. | Has built-in support for storing hierarchical data. td> |
| 3 | Scalability | RDBMS is vertically scalable. Performance improves with more RAM. | MongoDB can also scale horizontally. Its performance increases with the addition of processors. | |
| 4 | Schema | Schema needs to be defined in the RDBMS before using the database. | Schemas can be created and accessed dynamically in MongoDB. | |
| 5 | SQL injection | is vulnerable to SQL injection attacks. | SQL injection is not possible. | |
| 6 | Principles | Follow the ACID principles of atomicity, consistency, isolation, and durability. | Follow the CAP theorem, consistency, availability and partition tolerance. | |
| 7 | Basic | The database uses Row. | The database uses Document. | tr>|
| 8 | Basic | The database uses Column. | The database uses Field. | |
| 9 | Performance | RDBMS is slow when processing large hierarchical data. | MongoDB is very fast for processing large hierarchical data. | |
| 10 | Join | RDBMS supports complex joins. | MongoDB does not support complex joins | |
| 11 | JavaScript client | RDBMS does not provide a JavaScript-based client to query the database . | MongoDB provides a Javascript-based client to query the database. | |
| 12 | Query Language | RDBMS uses SQL to query the database. | MongoDB uses BSON to query the database. |
The above is the detailed content of Differences between RDBMS and MongoDB. For more information, please follow other related articles on the PHP Chinese website!