NoSQL versus SQL

Already this post has started out like many other posts comparing NoSQL to SQL, pitted against each other.  So let’s change that.  The new title of this post is: NoSQL and SQL! What is NoSQL? There are two types of NoSQL: The original NoSQL, which has been around for about two decades and is a relational database, does not use the Structured Query Language (SQL). The recycled NoSQL, which comes in a variety of flavors, vendors, and either uses SQL, does not use SQL, can use SQL but does not prefer SQL, is relational or isn’t rational, and so on.  It’s new technologies borrowing an already taken moniker.  A better name might be just calling each technology what it is instead of trying to lump them together, i.e. MongoDB, Cassandra, Riak, etc. They are two different types of tools and one or the other or both can be used in the same environment to perform different tasks.  Let’s look at storing data to highlight a major difference. Data Design in SQL and NoSQL A SQL database, such as MySQL or MS SQL, traditionally stores information in tables, rows, and columns you determine during the design phase.  You end up with small, “virtual spreadsheets” that are inter-related to each other through unique identifiers.  The data going into the spreadsheet must fit the constraints of the design of the column the data is going...

Read More