MongoDB Vs Oracle Comparison Review

Download as pdf or txt
Download as pdf or txt
You are on page 1of 3

Rahul Maddikunta

Database Design and Management Sec 01

Discussion 1

Comparison between MongoDB and Oracle DB


Introduction
Traditional relational database use two-dimensional table to represent data, with strict consistency of database
transactions, real-time to read and write, can implement complex SQL queries, especially multi-table related query.
However, for a wide range of massive data queries, multi-table query is not effective. However, NoSQL is not a
Relational DMBS and uses non-relational model of data structure.
This paper presents you the basic differences between the Relations Databases (OracleDB) and Non-relational Databases
(MongoDB). It also presents the Advantages and disadvantages of the MonoDB.

Overview
Storage of the Data has become a huge concern these days as more and more data is getting accumulated. Many
Organizations like Facebook, and huge insurance companies, Banking companies have huge data to be stored with
minimal storage space. A good solution for this type of storage issues is to have a Non-relational DBMS like NoSQL,
MongoDB, Cassandra, and CouchDB.
It is in the best interest of the Organizations to effectively manage the huge data with effective storage capacity. One of
the main feature of the NoSQL databases is that it does not support the SQL to achieve the effectiveness and reliability
in terms of performances. These engines usually provide a query language that provides a subset of what SQL can do,
plus some additional features.
MongoDB is a document-oriented database. Instead of storing your data in tables made out of individual rows, like a
relational database does, it stores your data in collections made out of individual documents. In MongoDB, a document
is a big JSON blob with no particular format or schema
NoSQL is a class of database management system different from the traditional relational databases in that data is not
stored using fixed table schemas. Mainly its purpose is to serve as database system for huge web-scale applications
where they outperform traditional relational databases. MongoDB is a NoSQL database management system released in
2009. It stores data as JSON-like documents with dynamic schemas (the format is called BSON). MongoDB has his focus
oriented to four things: flexibility, power, speed and ease of use. It supports replicated servers and indexing and it offers
drivers for multiple programming languages
One of the Major difference between the SQL and NoSQL is that the NoSQL is a Schema less DB. One of the major
importance of this is that any changes to the DB can be done easily and without altering whole structure of the
Database. The query language used by the Oracle Database is SQL in comparison with the one used by MongoDB which
consists in API calls, JavaScript and REST.
Another major difference is that MongoDB accepts huge file size for a single file which is around 16MB, however, oracle
accepts only files which has maximum value size is 4 KB. Both the MongoDB and Oracle Database are cross platform
database management systems. Oracle Database was written in C++, C and Java, while MongoDB was written in C++.
Both engines are multi user and active databases. MongoDB is a free product, while Oracle Database is a licensed
product. None of the databases have compression support.

Rahul Maddikunta

Database Design and Management Sec 01

Discussion 1

Other Major difference is that both the DBs use different syntaxes in database management systems. Oracle Database
uses common SQL language. It uses data manipulation statements as SELECT, UPDATE, DELETE. MongoDB uses functions
for the operations of adding new records, updating and deleting existing records.

Advantages of MongoDB
There are some advantages of Using MonoDB.
1.
2.
3.
4.
5.

The Database is Very innovative and fast time to market.


It is globally scalable, reliable and inexpensive to operate.
With MongoDB, you can build applications that were never possible with traditional relational databases.
It consists of flexible data models and is more relaxed in terms of structure of the Data.
The MongoDB is very less expensive to manage and operate. Cost per gigabyte or transaction/second is cheaper
when compared to RDBMS.
6. It enables us to dramatically lower the cost of ownership.
7. It contains Fast and iterative deployment. Change in the Scope creep and changing business requirements no
longer stand between you and successful project delivery.

Disadvantages of Mongo DB.


There are some disadvantages with the MongoDB. Few of them are listed below.
1. To achieve the performance and scalability, MongoDB ditches the transaction support. This makes MongoDB
very easy to scale horizontally which utilize many cheap hardware to balance the load.
2. There is no schema in MongoDB, the document can have any number of fields, the fields can be add to existing
document at any time, dynamically.
3. Some of the statements like JOIN, TRANSACTION, LIMIT and non-indexed WHERE usually are not supported by
MongoDB.

Conclusion
MongoDB provides flexibility during the development process. It has built in support for horizontal scalability. It is easy
to deploy and copy databases from one server to another using export import tools. You can store complex data into
one field you can store and object, an array or a reference into one field.
MongoDB is a more rapid database management system. If you want a simple database that will respond very fast, this
is the choice you should make.
You can use the map-reduce function to aggregate results for reports. You can sum up the results, you can merge the
fields, and you can make whatever you want when youre doing map-reduce. Its fast and flexible.
The main difference between the two databases is that Oracle Database has relations between the tables. Those
relations can be one to one or one to many or many to many. With these relations you can join tables and make
complex queries. The main problem with the Oracle Database is the replication. You cannot copy the database so easily

Rahul Maddikunta

Database Design and Management Sec 01

Discussion 1

as in MongoDB. You have tools which do that but arent so fast. It is a much slower database in comparison with
MongoDB.
In conclusion, if you want to use a fast, flexible database, you can rely on MongoDB. If the rapidness of the database
isnt you main concern, and if you need relations between the tables and the collections, you can rely on the classic
solution, Oracle Database

You might also like