Databases

MySQL

MySQL is one of the most well known traditional relational database management system (RDBMS).This type of database presents data to users as a relationship between tables and has a set of commands that allow users to manipulate the relationships between tables. Critics of MySQL say that it's very hard to alter these type of databases and that the schemas(fields) of the databases need to be fixed in advance.

Here's are a couple of MySQL databases:

NoSQL

NoSQL is meant to fix the shortcomings of MySQL. There are a many variations of NoSQL databases including key-value storage, document databases, and wide-column storage. Key-value stores operate similarly to SQL databases but only have two fields (key and value). Document databases do not uses a table to store data, but rather store all relevant data in a single document. NoSQL databases are typically more dynamic than MySQL databases, allowing users to add new information and fields more quickly. And while MySQL databases must be scaled vertically (powering up a single server), NoSQL databases are scaled horizontally(can add more servers or cloud services). NoSQL databases are often unstructured in nature so that they can be spread across multiple servers. An enabler of this type of parallel computing is hadoop.

Here's are a couple of NoSQL databases:

My Thoughts

Having researched the traditional DBMS and the recent database model, I am more interested in learning NoSQL even though it isn't as structured as MySQL. The unstructured data model of NoSQL allows for quick scalability and users can quickly modify, add, and remove fields in their databases as necessary.

References

MongoDB Martin Fowler ZDnet