In: Operations Management
A NoSQL is the abbreviation for ‘Not Only SQL’. NoSQL is a technology used to address problems that arise when massive scale up of RDBMS (Relational Database Management System) does not work. For example, in Facebook there are billions of users who update their profiles, details, posts on a daily basis. RDBMS was useful to an extent but when there was a massive increase in the number of users, then the traditional RDBMS broke down. NoSQL movement addresses this inefficiency as it does not use SQL to perform operations on the data. NoSQL is also known as schemaless because it does not use any schema, coding, indexes, relationships, constraints, SQL as in the traditional RDBMS. Instead, NoSQL movement is a technology in which the data is stored or retrieved using a single key. The term ‘Key-Value’ stores are used to denote NoSQL products that store data using these ‘keys’. The loads of information is stored in multiple master servers as against the traditional ones. Then, the strategy known as horizontal scaling or “sharding” of the data is used. In this strategy, certain subsets of the data are stored on one server and the remaining can be stored in another server which reduces the load capacity of the servers. Thus, NoSQL movement is the trending topic in handling massive loads of data.