CST 363 Weekly Journal #7

 Compare MongoDB with MySQL. 

What are some similarities? 

- Some similarities' are both MySQL and MongoDB are used to store data. Another similarity would be Indexing because both use this to improve the query performance.

What are some differences? 

- A NoSQL database that stores data in flexible, JSON-like documents. It uses a document-oriented data model which allows for varying data structures within a collection. A relational database that stores data in tables and uses SQL for data management. It enforces a structured schema with predefined tables and columns. A few more differences would be MongoDB uses a query language based on JSON-like syntax for querying documents. However, SQL uses a standardized and widely used language for querying and managing relational databases. SQL is known for its powerful querying capabilities and transactional support.

When would you choose one over the other? 

I would choose MySQL over MongDB because you are working with a smaller to medium-sized dataset that fits well within the relational model in MySQL while, in MongDB you are building applications that benefit from document-based storage, such as content management systems, real-time analytics, or big data applications.