Week 7

 

• Compare MongoDB with MySQL. 
• MongoDB is a NoSQL database, which means that you can execute queries without using SQL. MySQL is a relational database. It uses structured tables and SQL syntax to manage data. MySQL is a relational database. It uses structured tables and SQL syntax to manage data.
• What are some similarities? 
• Both support CRUD operations and can integrate with Java frameworks.
• What are some differences? 
• MySQL is table based while MongoDB is document based. MongoDB uses MQL while MySQL uses SQL. MySQL structures data in rows and columns. MongoDB uses sharding (horizontal scaling) while MySQL uses replication (vertical scaling).
• When would you choose one over the other? 
• MongoDB is best used when a data model is evolving while MySQL would best be used for databases that are more consistent and require complex joins