1. Oracle :
Oracle is a relational database management system (RDBMS). It was developed by Oracle Corporation in 1980. It is the first database designed for grid computing that provides the most flexible and cost-effective way to manage information and application. It runs on major platforms like Windows, Unix, Linux, and macOS. It is a relational database in which data is accessed by user through application or query language called SQL.
2. MongoDB :
Difference between Oracle and MongoDB :
|1.||It was developed by Oracle Corporation in 1980.||It was developed by MongoDB Inc. in 2009.|
|3.||It is a commercial software.||It is an open-source software.|
|4.||Server operating systems for Oracle are Solaris, Linux, OS X, Windows.||Server operating systems for MongoDB are Solaris, Linux, OS X, Windows, AIX, HP-UX.|
|5.||It uses Horizontal partitioning method for storing different data on different nodes.||It uses Sharding partitioning method for storing different data on different nodes.|
|6.||Referential integrity is used in Oracle.||No concept of referential integrity and no Foreign keys.|
|7.||JDBC, ODBC, ODP.NET, OCI are the APIs and access methods used in Oracle.||Proprietary protocol using JSON are the APIs and access methods used in MongoDB.|
|8.||The replication methods that Oracle supports are Master-Slave Replication and Master-Master Replication.||The replication method that MongoDB supports is Master-Slave Replication.|
|9.||It provides fine grained access rights according to SQL-standard.||It provides access rights for users and roles .|
|10.||Immediate Consistency method ensures consistency in Oracle.||Eventual Consistency and Immediate Consistency methods ensures consistency in MongoDB.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.