NoSQL databases
NoSQL databases
The NoSQL is a database solution that allows users to store data without the use of predefined schemas. The name, NoSQL, does not entirely prohibit structured query language but it gives the option of avoiding it to store data. With a NoSQL database, relational functionalities such as table schemas and join operations can be avoided. So instead of using tables, a NoSQL database can be organized into objects, key/value pairs or tuples. The NoSQL database is important because a large amount data is recorded quicker and easier than the traditional SQL database.
During the first few weeks of the semester, we learned how to use the traditional MySQL database. We spent time understanding how to pull data out and add data. The traditional database stores individual records as rows in table and each column storing a specific piece of data such as, “EmployeeID”, “Employee”, “Date Hired”, “Company”, “Department”, etc. However, depending on the database type, a NoSQL database has two columns, “Key” and “Value”. So all relevant data is stored in a single “document” in JSON, or XML. With this option, the table-and-row model are removed.
The largest streaming company is a fan of NoSQL databases. Netflix has moved away from the traditional SQL (Oracle) to a NoSQL database (Cassandra). As Netflix grew in subscribers and to more than 40 countries around the world, the company decided to rethink its data and storage strategies. Netflix spent years transitioning to the NoSQL database, Cassandra. This has allowed Netflix to improve availability of their content and essentially eliminating downtime incurred by database schema changes.
Works Cited
“What Is NoSQL (Not Only SQL Database)? – Definition from WhatIs.com.” SearchDataManagement. Apr. 2013. Web. 21 Apr. 2016.
Lampitt, Andrew. “Big Movies, Big Data: Netflix Embraces NoSQL in the Cloud.” InfoWorld. Web. 21 Apr. 2016.