CST 363 Module 7

What are some similarities between MongoDB and MySQL?

MongoDB and MySQL are similar to each other based on the following:

1. MongoDB and MySQL are both database systems used to store, retrieve, and manage data for applications. 
   
   
2. They support CRUB operations, while integrating into many different types of projects and languages. 
   
   
3. They are both query languages, as SQL is used for MySQL and MongoDB has a document-based query language, which both manipulate data.
   
   
4. MongoDB and MySQL can be deployed through cloud platforms as to handle datasets, authentication, access. 

What are some differences between MongoDB and MySQL?

MongoDB and MySQL are different from each other based on the following:

1. MongoDB is a NoSQL document-based database, while MySQL is a relational database.
   
   
2. MongoDB has its data stored in JSON documents, while MySQL has its data stored in tables with predefined schemas.
   
   
3. MongoDB is capable of handling large volumes of data that is unstructured, while MySQL is capable of handling structured data with complex relationships.
   

What situations would require MongoDB or MySQL?

MongoDB would be required for applications that deal with a constantly evolving database. Basically, MongoDB is able to provide flexibility in storing a user's information whether it be the data, posts, or content. Therefore, I would choose MongoDB whenever a database requires nested data that constantly evolves, as a social media app would require fast writes and scalability.

On the other hand, MySQL would be required for applications that aren't evolving. Basically, an application that is structured, consistent, and durable given that the applications themselves rely on relationships between data and require ACID compliance. In the end, I would choose MySQL for applications dealing with banking, inventory, and e-commerce, as they aren't constantly evolving and require consistent data with transactional support.