Performance Comparison of NOSQL Database Cassandra and SQL Server for Large Databases

Abstract

The new category of databases, the NoSQL databases are horizontally scalable as such these databases are very compatible for use at data centers that require very large size databases with variety of data types. Performance of SQL Server2012 and Cassandra was compared in a limited scenario but it was quite clear that for kind of database required for business, the relational databases are the choice. NoSQL technology is improving at a fast pace and different types of databases are coming into the market. New schema free environments and flexible table designs offer a lot to look forward. The four different types of NoSQL databases are providing specialized utilization for specific technology areas.

Big social data provenance framework for Zero-Information Loss Key-Value Pair (KVP) Database

“…But these databases are not scalable for handling big data which encompasses not just structured data, but also semi-structured and unstructured data. Not only SQL (NoSQL) databases have been proposed as an alternative to SQL databases to handle the challenges posed by big data, as these databases efficiently support to a low latency, horizontal scalability, efficient storage, high availability, high concurrency, and reduced operational costs [8,17,35]. Apache Cassandra is one of the most popular key-value pair (KVP) database which belongs to the NoSQL family.…”