Comparison of SQL, NoSQL and NewSQL databases for internet of things
Citations Over TimeTop 10% of 2016 papers
Abstract
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.
Related Papers
- → Comparative Study of Role Based Access Control in Cloud Databases and NoSQL Databases(2017)9 cited
- Experimental Validation as Support in the Migration from SQL Databases to NoSQL Databases(2015)
- → Performance Analysis in NoSQL Databases, Relational Databases and NoSQL Databases as a Service in the Cloud(2021)2 cited
- Migration Between NoSQL Databases(2013)
- Comparison of relational, NoSQL and NewSQL databases(2015)