Difference between Oracle and MongoDB

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 :
MongoDB is a cross-platform document-oriented and a non relational (i.e., NoSQL) database program. It is an open-source document database, that stores the data in the form of key-value pairs. MongoDB was developed by MongoDB Inc. and initially released on 11 February 2009. It is written in C++, Go, JavaScript, Python languages. MongoDB offers high speed, high availability, and high scalability. Once MongoDB is installed, users can make use of Mongo shell as well. Mongo shell provides a JavaScript interface through which the users can interact and carry out CRUD operations.


Difference between Oracle and MongoDB :

S.NO. ORACLE MONGODB
1. It was developed by Oracle Corporation in 1980. It was developed by MongoDB Inc. in 2009.
2. It is written in C and C++. It is written in C++, Go, JavaScript, Python languages.
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.

My Personal Notes arrow_drop_up

I am Student of ABES ENGINEERING COLLAGE ,I Still work in ARTICLE writing,MICROSOFT DYNAMICS 2012 AX AND dynamics 365

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.