CST 363 - Week 6

 MongoDB vs MySQL

Both of these database management systems efficiently and effectively allow the user, whether its front-end or back-end, to insert, delete, and select data.  Both also specialize in how those steps are done.  

MySQL uses the SQL language to select data from a relational database.  The data in the database is broken up into related tables through the use of primary and foreign keys.  MySQL also works best for data with a uniform structure because if the structure has to change then an entirely new schema will need to be constructed to allow for those changes.

MongoDB on the other hand is referred to as a NoSQL database management system.  Much like a table in MySQL MongoDB has collections where documents can be inserted.  This data does not have to be uniform by nature and can be created and populated at the same time.  This allows the schema of that data to be very different from document to document.  This type of database management system is used on data sets that are always changing such as Amazon's product page.

Comments

Popular posts from this blog

CST 499 - Week 10

CST 438 - Week 7

CST 438 - Week 3