February 15, 2020
George Hiroshi Silva
The universe of innovation progresses each second thus the universe of business should be adjusted to such advances. In the online business world finding the ideal database model is a migraine. As the organization develops the measure of information develops, so finding a database that can cling to the load is significant.
Relational databases (MySQL, Oracle, MS SQL) were the first as a main priority for such organizations, be that as it may, the circumstances are different and the interest is high for something basic and adaptable.
Therefore it is essential to understand the importance of
MongoDB and
MySQL and observe what the contrasts are.
What is MongoDB ?
MongoDB is the most mainstream document- based database following NoSQL. It was first discharged in 2010 by the organization MongoDB inc.
MongoDB utilizes key-value sets, called record store. These record stores made are put away in BSON(Binary JSON) documents. BSONs are altered JSON(JavaScript Object Notation).
JSON permits the information trade among customers and servers to be done in human documentation.
Since MongoDB is schema less,a fixed model structure isn't required. Additionally MongoDB will give an immense lift to execution and give solid unwavering quality and effectiveness.
What is MySQL ?
MySQL is an open-source Relational Database Management System (RDBMS).
MySQL uses Structured Query Language (SQL) to conduct the CRUD (Create, Read, Update,Delete) operations. The CRUD operations are what is used to conduct all the operations related to database functions, starting from reading data to inserting, updating and deleting. It follows a concept of creating tables and inserting columns of data with the appropriate row.
Regardless of whether different tables are available in a database the utilization of JOIN is an amazing way to construct an association between numerous schema.
Flexibility of schema
MongoDB
- There are no restrictions on the schema creation, using collections documents can be added, without ever needing to create any relationships.
- High flexibility.
MySQL
- Tables needs to be defined before any data can be added, rows needs to be defined,and rows adjacent to columns needs to be defined.
- Due to normalization there is no flexibility in the manner of storing data.
 |
| Rigid table design is observed |
Querying language
MongoDB
- un-Structured Query language
- A document(JSON) is needed to be build containing the properties that matches the values.
MySQL
- Structured Query language
- Consists of 2 main parts
- DDL(Data Definition Language)
- DML(Data Manipulation Language)
 |
| Comparison of MySQL vs MongoDB query writing |
To be continued....
