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. |
0 comments:
Post a Comment