Thursday, September 5, 2013

Performance comparison for SQL and NoSQL databases

The following 3 charts show how diff erent database systems can effectively handle large amount of  heterogeneous data (such as from internet of things or devices). Two classes of databases were considered in the charts, namely, SQL and NoSQL databases. While SQL databases are relational and focus on data consistency, NoSQL databases are normally schema-less and provide higher scalability and availability.

Please note that results may vary based on many factors but the following is a good starting point.

comparison of NoSQL and SQL databases for writes


comparison of NoSQL and SQL databases for reads




Reference

  • Cloud Databases for Internet-of-Things Data, Thi Anh Mai Phan, Kongens Lyngby 2013, Technical University of Denmark Informatics and Mathematical Modelling