CST363.7 Module 7

  

 CST363.6 Module 7

Comparing MongoDB with MySQL:

There are many similarities between MongoDB and MySQL, both are capable of generating unique identifiers for their entities, both have tooling which can be integrated into Java and other programming languages. They both offer indexing. Some differences which are unique to MySQL is that joining tables is possible, where as in MongoDB that is not possible due to the structure holding the data. Another difference is that MySQL is capable of transactions, in order to run transactions through MongoDB you would need to build through a programming language like Java. MongoDB also implements sharding and replication where as in MySQL support for which is only offered through their NDB server edition.

When to use MongoDB:

Consider using MongoDB when the initial cost of database needs to be low. Also dependent on if handling Big data, where the volume of querying and inserting are high. Consider using when managing web site views, or data associated with the users of websites.

When to use MySQL:

Consider using MySQL when transactions are priority, and ensuring and consistency across the database is accurate. Consider using if using in a financial, or government ran application.