MONGODB Versus SQL: A Case Study on Electricity Data

Abstract

The relational database model widely used to store and process the data is not effective to deal with large amounts of data formally known as Big Data. To handle this large amount of unstructured data, the research community has come up with the concept of NoSQL, a nonrelational database model. The major advantage of NoSQL is that there is no need to fix schema in advance, no need of a join operation, and many other such advantages, making it a best candidate for Big Data query and analysis. This paper attempts to provide a case study of comparative analysis of NoSQL with a relational database by applying different operations over electricity data of one of the northern Indian states, Punjab, and compares the key parameters of two models.