RDBMS vs MongoDB



Hello everyone, in this article we will learn the difference between RDBMS (Relational Database Management System) vs MongoDB. Let’s go.
Following are the difference between RDBMS (Relational Database Management System) vs MongoDB

MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

v RDBMS is a relational database.
MongoDB is a non-relational database.

v In RDBMS row represents implicitly structured data in a table.
In MongoDB, the data is stored in documents.

v RDBMS is a table based. You can store data using columns and rows it contains a table.
In MongoDB Collection based and key-value pair. The collection contains documents known as Fields.

v In RDBMS you need design table structure, relations after that you can start writing code.
In MongoDB, you can start without a design table structure. In development, you can modify your objects at a lesser cost.
MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

v RDBMS firstly required normalized data.
MongoDB is flexible and it doesn’t need normalized data.

v RDBMS is supported to Structured Query Language.
MongoDB also support JSON (JavaScript Object Notation).

v In RDBMS are known for enforcing data integrity.
In MongoDB, data integrity is not an explicit requirement.

v In RDBMS emphasizes on ACID (Atomicity, Consistency, Isolation, and Durability) properties.
In MongoDB emphasizes on CAP (Consistency, Availability, and Partition tolerance) theorem.

MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

v RDBMS is a Column based.
MongoDB is a Field-based.

v RDBMS is using Group by function.
MongoDB is using Aggregation.

v RDBMS is not suitable for hierarchical data storage.
MongoDB is best suitable for hierarchical data storage.

v In RDBMS Primary Key using uniquely identifies each record in the table.
In MongoDB Primary key (default key_id provided by MongoDB itself).

MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

v RDBMS supports to Foreign key constraint.
MongoDB does not support Foreign key constraint, but if you need foreign key constraint then you have to handle foreign key constraint in the code.

v RDBMS is support for Joins (you can join two or more tables).
MongoDB is not supported to Joins, but you can change your document structure (keep in mind MongoDB has a maximum document size of 16MB.).

v RDBMS supports triggers.
MongoDB does not support triggers.

v In RDBMS you can retrieve data from the table then you write following query
SELECT * FROM table_name;
In MongoDB you can retrieve data from the table then you write following code
db.collection_name.find();

v In RDBMS if you want to insert data into the table then you write following query
INSERT INTO table_name (column_1, column_2, column_3, ….) VALUES (value_1, value_2, value_3, ….)
In MongoDB, if you want to insert data into the collection then you write following code
db.collection_name.insert
({
                                   field_1:         value_1,
                                   field_2:         value_2,
                                   field_3:         value_3
})


MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

v RDBMS if you want to update your existing data then you write following query:
UPDATE student
SET stud_remark = ‘Pass’
WHERE stud_mark > 35;
MongoDB if you want to update your existing data then you write following code:
db.student.update
({        stud_mark:  {         $gt:  35         }          },
                       {          $set:  {   stud_remark: ‘Pass’   }          },
                       {          multi:   true      })
Terminology & Concepts
Many terminology and concepts in MySQL have near equivalents in MongoDB. Following are the common concepts across MySQL and MongoDB.

                       MySQL                           MongoDB
                       Table                                               Collection
                       Row                                                 Document
                       Column                                           Field
                       Join’s                                                Embedded documents
                       Group by                                        Aggregation Pipeline

MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/
Click on: https://expertwithsagarjaybhay.com/


Comments

Post a Comment

Popular posts from this blog

ALTER statement in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the ALTER table statement in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ MySQL ALTER command is used to modify the table, view an existing database. When you have completed your database design and after that, you realize some of the information was left out when creating a database. You want to change without losing existing data, and then you can change data using ALTER command. MySQL ALTER command is used to add a column with an existing table, add multiple columns, drop a column, modify a column, rename a column, and rename the table. ALTER command also used to add and drop constraints on the existing table. N
Read more

Order By Clause in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the Order By Clause in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ MySQL Order by clause is used to sort the records or data in ascending or descending order. Order by clause allows us to sort records or data by a single column or multiple columns in ascending or descending order. There are two key using in Order by clause:          ASC: - sorting data or records by ascending order.          DESC: - sorting data or records by descending order. Syntax:          SELECT column_name_1, column_name_2, …          FROM table_name          WHERE condition ORDER BY column_name_1 [ ASC | DESC ], column_name_2 [ ASC
Read more

MySQL Constraint – UNIQUE

Image
C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ Hello everyone in the previous article we learn about MySQL Constraint – NOT NULL and in this article, we will learn UNIQUE constraint with example. Let’s go. What is a UNIQUE key? The MySQL UNIQUE key used to specify that you don’t want to see duplicate data in a given field means all the values in a column are different. In MySQL, UNIQUE key is implemented through a constraint that is called UNIQUE Constraint. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ What is a UNIQUE Constraint? MySQL UNIQUE constraint does not allow inserting a duplicate value in a column and each data value of a column that has the unique value. If you add to insert an already existing duplicate value in the unique colum
Read more