Tuesday, February 16, 2021

Difference between Oracle and MongoDB

Oracle, MongoDB, Oracle Database Exam Prep, Oracle Database Certifications, Database Preparation, Database Career

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 :

ORACLE MONGODB 
It was developed by Oracle Corporation in 1980.  It was developed by MongoDB Inc. in 2009.
It is written in C and C++.  It is written in C++, Go, JavaScript, Python languages. 
It is a commercial software.  It is an open-source software. 
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. 
It uses Horizontal partitioning method for storing different data on different nodes.  It uses Sharding partitioning method for storing different data on different nodes. 
Referential integrity is used in Oracle.  No concept of referential integrity and no Foreign keys. 
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. 
The replication methods that Oracle supports are Master-Slave Replication and Master-Master Replication.  The replication method that MongoDB supports is Master-Slave Replication. 
It provides fine grained access rights according to SQL-standard.  It provides access rights for users and roles. 
Immediate Consistency method ensures consistency in Oracle.  Eventual Consistency and Immediate Consistency methods ensures consistency in MongoDB. 

Related Posts

0 comments:

Post a Comment