Proceedings ArticleDOI
MySQL and NoSQL database comparison for IoT application
Sharvari Rautmare,D. M. Bhalerao +1 more
- Vol. 2016, pp 235-238
TLDR
This paper compares SQL and NoSQL databases for a small scale IoT application of water sprinkler system and investigates whether NoSQL performs better than SQL in different scenarios.Abstract:
Internet of Things (IoT) concept has been around in tech world for few years now. IoT focuses on connection of number of smart devices. In near future, IoT will have applications in various domains and these applications are going to produce tremendous amount of data. With the continuous generation of heterogeneous data, problem arises to store, transfer & manage the data efficiently. Traditional database systems used Structured Query Language (SQL) database which has supported all the user requirements along with simplicity, robustness, flexibility, scalability, performance. But the main limitation they are facing is their static schema which is making RDBMS not suitable for IoT applications. On the other hand, NoSQL databases emerging in market have claimed to perform better than SQL database. The NoSQL databases are non-relational, schema free, no joins, easy replication support, horizontally scalable, etc. Does NoSQL perform better than SQL in all application scenarios? An effort to answer the same has been made in this paper. This paper compares SQL and NoSQL databases for a small scale IoT application of water sprinkler system and investigates whether NoSQL performs better than SQL in different scenarios.read more
Citations
More filters
Proceedings ArticleDOI
Performance Analysis of RDBMS and No SQL Databases: PostgreSQL, MongoDB and Neo4j
TL;DR: This paper compares the performance of MongoDB and Neo4j in case of search queries executed on geotagged data and finds out suitable No SQL data base for GIS application.
Journal ArticleDOI
A real-time interaction platform for settlement control during shield tunnelling construction
TL;DR: A real-time mobile interaction and coordinated management platform was designed and developed with the instant messaging (IM) tool, which realized the settlement control goal of a maximum value of −4 mm in the project of Nanning metro line 1 crossing beneath Nanning railway station.
Journal ArticleDOI
SEER-MCache: A Prefetchable Memory Object Caching System for IoT Real-Time Data Processing
TL;DR: Seer-MCache, the memory object caches system with a smart prefetching (read-ahead) function, to fill up the caching system with the desired data before the intensive IoT queries arriving, and can improve the performance of read-intensive workload up to 61%.
Journal ArticleDOI
A Comprehensive Review on the Application of Internet of Thing (IoT) in Smart Agriculture
TL;DR: Based on the review of these exiting works and commercial products, some key challenges and future scope of research in this domain are found and presented in the article.
Journal ArticleDOI
Development of Mobile IoT Solutions: Approaches, Architectures, and Methodologies
Naercio Magaia,Pedro Gomes,Lion Silva,Breno Sousa,Constandinos X. Mavromoustakis,George Mastorakis +5 more
TL;DR: There is no generalized consensus on the selection of best architecture or even the most suitable communications protocols to be used on an IoT application development, so this article aims at presenting approaches, architectures, and methodologies relevant to the development of mobile IoT solutions.
References
More filters
Journal ArticleDOI
The Internet of Things for Health Care: A Comprehensive Survey
TL;DR: An intelligent collaborative security model to minimize security risk is proposed; how different innovations such as big data, ambient intelligence, and wearables can be leveraged in a health care context is discussed; and various IoT and eHealth policies and regulations are addressed to determine how they can facilitate economies and societies in terms of sustainable development.
Journal ArticleDOI
Ubiquitous Data Accessing Method in IoT-Based Information System for Emergency Medical Services
TL;DR: The result shows that the resource-based IoT data accessing method is effective in a distributed heterogeneous data environment for supporting data accessing timely and ubiquitously in a cloud and mobile computing platform.
Proceedings ArticleDOI
A performance comparison of SQL and NoSQL databases
TL;DR: This paper independently investigate the performance of some NoSQL and SQL databases in the light of key-value stores, and shows that not all NoSQL databases perform better than SQL databases.
Proceedings ArticleDOI
Comparison of Relational Database with Document-Oriented Database (MongoDB) for Big Data Applications
TL;DR: This paper is to illustrate how a problem being solved using MySQL will perform when MongoDB is used on a Big data dataset and the results are encouraging and clearly showcase the comparisons made.
Proceedings ArticleDOI
Investigating sensor data retrieval schemes for multi-sensor passive RFID tags
TL;DR: Three, fast and energy efficient multi-sensor data retrieval approaches to obtain sensor data from sensor tags are proposed and indicates that they can effectively be used in a range of real-world ubiquitous sensing applications such as fall prevention and food safety monitoring.