Comparison of SQL, NoSQL and NewSQL databases for internet of things
Comparison of SQL, NoSQL and NewSQL databases for internet of things
复制标题
物联网SQL、NoSQL和NewSQL数据库的比较
DOI：
--
复制
发表时间：
2016
期刊：
影响因子：
--
通讯作者：
Kumud Wasnik
中科院分区：
文献类型：
--
作者：
Haleemunnisa Fatima;Kumud Wasnik
物联网（物联网）的所有本质都是紧密桥接在一起的传感器集合。因此，技术行业的当今发展提高了大量数据的重点。物联网有望很快从各种位置生成并收集大量数据。诸如存储和性能因素之类的功能的担忧是胁迫数据库以胜过自己。传统的关系数据库有一次又一次地被证明是有效的。 NOSQL以及最近获得动力的NewsQL数据库的性能要比经典的SQL对应物更好。本文比较了上述技术的三个数据库的性能； SQL（MySQL），NOSQL（MongoDB）和NewsQL（voltdb）分别用于传感器读数。传感器数据处理范围宽度（MB至GB）尺寸，并对其进行测试：单写，单读，单删除和多写操作。
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.