CORRELATION AND COMPARISON OF NOSQL SPECIMEN WITH RELATIONAL DATA STORE

Sangeeta Gupta, G.Narsimha

Abstract: Relational Databases are a traditional approach of data storage more suitable for structured data formats and are constrained by ACID properties. As the modern world data in the form of word documents, pdf files, audio and video formats is unstructured, where tables and schema definition is not a major concern, Relational Databases such as Mysql may not be suitable to serve such Bigdata. An alternate approach is to use the emerging Nosql databases. This paper presents a comparative analysis of Nosql types such as Hbase, Mongodb, SimpleDB and BigTable with Relational Database like Mysql and specifies their limitations when applied to real world problems. It also proposes solution to overcome these limitations using an integrated data store which serve to be beneficial over the mentioned Nosql and Mysql stores in terms of efficiently implementing simple and complex queries yielding better performance.

Keywords: Mysql, Nosql, Bigdata, HBase, MongoDB, Simple DB, BigTable, Integrated store.

DOI: https://doi.org/10.15623/ijret.2015.0418001