Comparison of SQL, NoSQL and NewSQL databases for internet of things

摘要

The Internet of Things (IoT) in all its essentiality is a collection of sensors bridged together tightly. The present day development in the technology industry has thus elevated the emphasis of large amounts of data. IoT is expected to generate and collect an enormous amount of data from varied locations very quickly. The concerns for features like storage and performance factors are coercing the databases to outperform themselves. Traditional relational databases have time and again proved to be efficient. NoSQL and more recently NewSQL databases having gained an impetus are asserted to perform better than the classic SQL counterpart. This paper compares the performance of three databases each from the said technologies; SQL (MySQL), NoSQL (MongoDB) and NewSQL (VoltDB) respectively for sensor readings. The sensor data handled ranges in vast (MB to GB) size and tested against: single write, single read, single delete and multi write operations.