No SQL? No! NoSQL!
NoSQL or No SQL?
Many people assume that NoSQL is a program to challenge SQL, however it is not a replacement for SQL but compliments the RDBMS. NoSQL, meaning Not Only SQL, is a relational database management system or RDBMS that is created for distributed data stores that require large scale data in a more efficient way. One of the advantages of NoSQL is that is performs the same functions as SQL but in different ways in order to manage large data needs. This means that instead of “fixed schema” and “joins” which are seen a lot in SQL, NoSQL uses a “scaling out” format. This means instead of having all your information in one database and analyzing it, NoSQL spreads the data out over commodity systems. This makes it cheaper and faster for the software to perform its user needs.
Remember “Not Only SQL” is not only SQL! As seen in MIS 2502 Data Analytics, SQL is able to run queries in order to gain information for its users, NoSQL does the same. NoSQL is able to grab information from the database, which is stored in RAM over its different commodities, and send the information to its user. However unlike SQL which require a lot of “joins” NoSQL uses document stores in order to store and retrieve information. Document Stores allow data to be grouped more logically and reduces the restriction on database schema. This allows NoSQL to keep up with what SQL can’t. Here is an example of how NoSQL can be used.
Guy Harrison gives a wonderful example of how a NoSQL program can be used. In his example a company that delivers leisure and mediation products adopts Cassandra, a Google BigTable model with concepts from Amazon Dynamo distributed key –value store. Cassandra unlike traditional techniques classifies data on the nature of the query instead of the data. IT also allows redundant data in order to better specify various question that may be asked.Because of this, Cassandra is able to distribute data redundantly across multiple data centers and handle large customer data-sets.
Works Cited
Document Databases. (n.d.). Retrieved April 16, 2015, from http://www.mongodb.com/document-databases
Perdue, T. (n.d.). NoSQL Databases Overview. Retrieved April 16, 2015, from http://newtech.about.com/od/databasemanagement/a/Nosql.htm
RealWorld NoSQL: Cassandra at Openwave. (2011, January 29). Retrieved April 16, 2015, from https://gigaom.com/2011/01/29/realworld-nosql-cassandra-at-openwave/