Cloud Databases for Internet-of-Things Data

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.

[1]  Imrich Chlamtac,et al.  Internet of things: Vision, applications and research challenges , 2012, Ad Hoc Networks.

[2]  Artemis Moroni,et al.  Vision and Challenges for Realising the Internet of Things , 2010 .

[3]  Cristian Bucur,et al.  A comparison between several NoSQL databases with comments and notes , 2011, 2011 RoEduNet International Conference 10th Edition: Networking in Education and Research.

[4]  Sahil Puri,et al.  A Survey and Comparison of Relational and Non-Relational Database , 2012 .

[5]  Rabi Prasad Padhy,et al.  RDBMS to NoSQL: Reviewing Some Next-Generation Non-Relational Database's , 2011 .

[6]  Ioannis Konstantinou,et al.  On the elasticity of NoSQL databases over cloud management platforms , 2011, CIKM '11.

[7]  Rune B. Lyngsø,et al.  Lecture Notes I , 2008 .

[8]  Vibhor Sharma,et al.  Near Field Communication , 2013, Encyclopedia of Biometrics.

[9]  Shashank Tiwari,et al.  Professional NoSQL , 2011 .

[10]  Dan Pritchett,et al.  BASE: An Acid Alternative , 2008, ACM Queue.

[11]  Guan Le,et al.  Survey on NoSQL database , 2011, 2011 6th International Conference on Pervasive Computing and Applications.

[12]  Charu C. Aggarwal,et al.  The Internet of Things: A Survey from the Data-Centric Perspective , 2013, Managing and Mining Sensor Data.

[13]  Tilmann Rabl,et al.  Solving Big Data Challenges for Enterprise Application Performance Management , 2012, Proc. VLDB Endow..

[14]  Vlad Trifa,et al.  Towards the Web of Things: Web Mashups for Embedded Devices , 2009 .

[15]  Robert J. Meijer,et al.  Sensor Data Storage Performance: SQL or NoSQL, Physical or Virtual , 2012, 2012 IEEE Fifth International Conference on Cloud Computing.

[16]  Randy H. Katz,et al.  A view of cloud computing , 2010, CACM.

[17]  Maurizio Tomasella,et al.  Vision and Challenges for Realising the Internet of Things , 2010 .

[18]  Yang Liu,et al.  A Storage Solution for Massive IoT Data Based on NoSQL , 2012, 2012 IEEE International Conference on Green Computing and Communications.

[19]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.

[20]  Jiajie Xu,et al.  SeaCloudDM: a database cluster framework for managing and querying massive heterogeneous sensor sampling data , 2013, The Journal of Supercomputing.

[21]  Nesime Tatbul,et al.  Proceedings of the VLDB Endowment , 2011 .

[22]  Jaydip Sen,et al.  Internet of Things -A Standardization Perspective , 2010 .

[23]  Kerry L. Taylor,et al.  Semantics for the Internet of Things: Early Progress and Back to the Future , 2019 .

[24]  Nadine Eberhardt,et al.  Wireless Sensor And Actuator Networks Technologies Analysis And Design , 2016 .

[25]  John Gantz,et al.  The Digital Universe in 2020: Big Data, Bigger Digital Shadows, and Biggest Growth in the Far East , 2012 .

[26]  Lida Xu,et al.  The internet of things: a survey , 2014, Information Systems Frontiers.

[27]  Andrea Conti,et al.  Wireless Sensor and Actuator Networks: Technologies, Analysis and Design , 2008 .

[28]  Charu C. Aggarwal,et al.  Managing and Mining Sensor Data , 2013, Springer US.

[29]  V Mateljan,et al.  Cloud Database-as-a-Service (DaaS) - ROI , 2010, The 33rd International Convention MIPRO.

[30]  Neal Leavitt,et al.  Will NoSQL Databases Live Up to Their Promise? , 2010, Computer.

[31]  Anne James,et al.  Challenges for Database Management in the Internet of Things , 2009 .

[32]  Roy Want,et al.  An introduction to RFID technology , 2006, IEEE Pervasive Computing.

[33]  Sanjay Ghemawat,et al.  MapReduce: Simplified Data Processing on Large Clusters , 2004, OSDI.

[34]  Ian F. Akyildiz,et al.  Wireless sensor networks: a survey , 2002, Comput. Networks.

[35]  Jean-Philippe Vasseur,et al.  Interconnecting Smart Objects with IP: The Next Internet , 2010 .

[36]  P. Cochat,et al.  Et al , 2008, Archives de pediatrie : organe officiel de la Societe francaise de pediatrie.

[37]  J. Chris Anderson,et al.  CouchDB - The Definitive Guide: Time to Relax , 2010 .

[38]  Stefan Jablonski,et al.  NoSQL evaluation: A use case oriented survey , 2011, 2011 International Conference on Cloud and Service Computing.

[39]  Sajal K. Das,et al.  A Storage Infrastructure for Heterogeneous and Multimedia Data in the Internet of Things , 2012, 2012 IEEE International Conference on Green Computing and Communications.

[40]  Douglas Crockford,et al.  The application/json Media Type for JavaScript Object Notation (JSON) , 2006, RFC.

[41]  Massimo Carro,et al.  NoSQL Databases , 2014, ArXiv.

[42]  Antonio Pintus,et al.  Paraimpu: a platform for a social web of things , 2012, WWW.