Cloud Databases for Internet-of-Things Data

Phan Thi Anh Mai, Jukka K. Nurminen, Mario Di Francesco

Research output: Chapter in Book/Report/Conference proceedingConference article in proceedingsScientificpeer-review

22 Citations (Scopus)

Abstract

The Internet of Things (IoT) is posing new challenges and opportunities for data management and analysis techniques. One of the major problems is how to handle an increasing amount of data, with a variety of data types and data sources, in order to meet application-specific performance requirements. In this article, we address the suitability of different types of databases for storing and accessing IoT data in the cloud. Specifically, we compare the performance of SQL (i.e., MySQL) and NoSQL databases (i.e., MongoDB, CouchDB, and Redis) in a cloud environment by using different types of IoT data, namely, sensor readings and multimedia. We conducted a performance evaluation of the considered database systems through extensive experiments in the cloud. Our results show that SQL and NoSQL databases are both viable for IoT data, even though there is a high variability in the performance of the different NoSQL databases considered.
Original languageEnglish
Title of host publication2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom)
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages117-124
Number of pages8
ISBN (Print)978-1-4799-5967-9
DOIs
Publication statusPublished - 12 Mar 2014
MoE publication typeNot Eligible
Event2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom) - Taipei, Taiwan, Province of China
Duration: 1 Sep 20143 Sep 2014

Conference

Conference2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom)
CountryTaiwan, Province of China
CityTaipei
Period1/09/143/09/14

Fingerprint

Information management
Internet of things
Sensors
Experiments

Keywords

  • Cloud
  • DBMS
  • Data
  • Database
  • Internet of things
  • IoT
  • NoSQL
  • RDBMS
  • SQL

Cite this

Mai, P. T. A., Nurminen, J. K., & Di Francesco, M. (2014). Cloud Databases for Internet-of-Things Data. In 2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom) (pp. 117-124). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/iThings.2014.26
Mai, Phan Thi Anh ; Nurminen, Jukka K. ; Di Francesco, Mario. / Cloud Databases for Internet-of-Things Data. 2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom). Institute of Electrical and Electronics Engineers Inc., 2014. pp. 117-124
@inproceedings{627d098bf51640fab88a4f439af0450f,
title = "Cloud Databases for Internet-of-Things Data",
abstract = "The Internet of Things (IoT) is posing new challenges and opportunities for data management and analysis techniques. One of the major problems is how to handle an increasing amount of data, with a variety of data types and data sources, in order to meet application-specific performance requirements. In this article, we address the suitability of different types of databases for storing and accessing IoT data in the cloud. Specifically, we compare the performance of SQL (i.e., MySQL) and NoSQL databases (i.e., MongoDB, CouchDB, and Redis) in a cloud environment by using different types of IoT data, namely, sensor readings and multimedia. We conducted a performance evaluation of the considered database systems through extensive experiments in the cloud. Our results show that SQL and NoSQL databases are both viable for IoT data, even though there is a high variability in the performance of the different NoSQL databases considered.",
keywords = "Cloud, DBMS, Data, Database, Internet of things, IoT, NoSQL, RDBMS, SQL",
author = "Mai, {Phan Thi Anh} and Nurminen, {Jukka K.} and {Di Francesco}, Mario",
year = "2014",
month = "3",
day = "12",
doi = "10.1109/iThings.2014.26",
language = "English",
isbn = "978-1-4799-5967-9",
pages = "117--124",
booktitle = "2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom)",
publisher = "Institute of Electrical and Electronics Engineers Inc.",
address = "United States",

}

Mai, PTA, Nurminen, JK & Di Francesco, M 2014, Cloud Databases for Internet-of-Things Data. in 2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom). Institute of Electrical and Electronics Engineers Inc., pp. 117-124, 2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom), Taipei, Taiwan, Province of China, 1/09/14. https://doi.org/10.1109/iThings.2014.26

Cloud Databases for Internet-of-Things Data. / Mai, Phan Thi Anh; Nurminen, Jukka K.; Di Francesco, Mario.

2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom). Institute of Electrical and Electronics Engineers Inc., 2014. p. 117-124.

Research output: Chapter in Book/Report/Conference proceedingConference article in proceedingsScientificpeer-review

TY - GEN

T1 - Cloud Databases for Internet-of-Things Data

AU - Mai, Phan Thi Anh

AU - Nurminen, Jukka K.

AU - Di Francesco, Mario

PY - 2014/3/12

Y1 - 2014/3/12

N2 - The Internet of Things (IoT) is posing new challenges and opportunities for data management and analysis techniques. One of the major problems is how to handle an increasing amount of data, with a variety of data types and data sources, in order to meet application-specific performance requirements. In this article, we address the suitability of different types of databases for storing and accessing IoT data in the cloud. Specifically, we compare the performance of SQL (i.e., MySQL) and NoSQL databases (i.e., MongoDB, CouchDB, and Redis) in a cloud environment by using different types of IoT data, namely, sensor readings and multimedia. We conducted a performance evaluation of the considered database systems through extensive experiments in the cloud. Our results show that SQL and NoSQL databases are both viable for IoT data, even though there is a high variability in the performance of the different NoSQL databases considered.

AB - The Internet of Things (IoT) is posing new challenges and opportunities for data management and analysis techniques. One of the major problems is how to handle an increasing amount of data, with a variety of data types and data sources, in order to meet application-specific performance requirements. In this article, we address the suitability of different types of databases for storing and accessing IoT data in the cloud. Specifically, we compare the performance of SQL (i.e., MySQL) and NoSQL databases (i.e., MongoDB, CouchDB, and Redis) in a cloud environment by using different types of IoT data, namely, sensor readings and multimedia. We conducted a performance evaluation of the considered database systems through extensive experiments in the cloud. Our results show that SQL and NoSQL databases are both viable for IoT data, even though there is a high variability in the performance of the different NoSQL databases considered.

KW - Cloud

KW - DBMS

KW - Data

KW - Database

KW - Internet of things

KW - IoT

KW - NoSQL

KW - RDBMS

KW - SQL

U2 - 10.1109/iThings.2014.26

DO - 10.1109/iThings.2014.26

M3 - Conference article in proceedings

SN - 978-1-4799-5967-9

SP - 117

EP - 124

BT - 2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom)

PB - Institute of Electrical and Electronics Engineers Inc.

ER -

Mai PTA, Nurminen JK, Di Francesco M. Cloud Databases for Internet-of-Things Data. In 2014 IEEE International Conference on Internet of Things (iThings), and IEEE Green Computing and Communications (GreenCom) and IEEE Cyber, Physical and Social Computing (CPSCom). Institute of Electrical and Electronics Engineers Inc. 2014. p. 117-124 https://doi.org/10.1109/iThings.2014.26