CST363 Module 6

 

  • Compare MongoDB with MySQL.  What are some similarities?  What are some differences?  When would you choose one over the other? 
    • MongoDB and MySQL have some surface level similarities such as both of them being suited for efficiently storing and accessing data sets. Beyond this they both support simple data types such as integers, strings, doubles, etc.
    • Some of the differences they have between each other mainly comes from MongoDB being a NoSQL structure, primarily meaning it doesn't use SQL queries to access data. SQL also stores data relationally in tables with predetermined columns or attributes while MongoDB stores data in the form of 'documents'. These documents have no pre-set size, data-types, etc.. Documents can have different attributes on the fly. This allows MongoDB to handle more non-uniform data sets.
    • At the moment I'm unsure which database I would rather use, it would probably depend on the project. The possibility to have non-uniform data using MongoDB is definitely interesting but I have had much more experience with SQL and its query's as of this moment. Whichever method, relational or document based, is better for any given project is what I would use.

Comments

Popular posts from this blog

CST489 / 499 Week 16

CST462S Module 8

CST489 / 499 Week 15