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

The performance comparison of NoSQL database and a Relational Database Management Systems has been done to identify which database responds faster to specific types of requests and suitability of these databases for different scenarios. Cassandra was taken as sample NoSQL database and its performance was compared with front line relational database SQL Server 2012. 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.