Managing IoT data using relational schema and JSON fields, a comparative study
Journal Title: IOSR Journals (IOSR Journal of Computer Engineering) - Year 2018, Vol 20, Issue 6
Abstract
Data transmitted from sensors and actuators as part of the Internet of Things (IoT) infrastructure are stored either in database tables following relational schema and normalization forms or in schema less collections using JSON string or binary formulation. As data content in such repositories radically increases, the selection and use of the appropriate storage types are essential in terms of performance and robustness. Furthermore, taking into account the amount of database capacity and processing needed, as well as the exponential increase and use of IoT devices, storage and retrieval of sensory data are the main bottlenecks and set the boundary requirements for IoT services functionalities. This paper tries to identify the performance characteristics that derive from data operations over IoT big datasets that are stored as records in relational schema tables or documents in tables containing JSON fields. Trying to pose an answer to the question which one performs better than the other the PostgreSQL open source relational database has been selected and examined for insert, select/find and aggregation function queries. The comparative study results are presented and thoroughly discussed
Authors and Affiliations
Christodoulos Asiminidis, George Kokkonis, Sotirios Kontogiannis
Keywords
Related Articles
- EP ID EP431583
- DOI 10.9790/0661-2006034652.
- Views 123
- Downloads 0
An Overview of the Research on Plant Leaves Disease detection using Image Processing Techniques
Diseases in plants cause major production and economic losses as well as reduction in both quality and quantity of agricultural products. Now a day’s plant diseases detection has received increasing attention in...
Segmentation of Tumor Region from Brain Mri Images Using Fuzzy C-Means Clustering And Seeded Region Growing
Abstract: The detection of brain tumor is one of the most challenging tasks in the field of medical image processing, since brain images are very complicated and tumors can be analyzed efficiently only by the expert radi...
Video Segmentation Using Global Motion Estimation and Compensation
Abstract : Video has to be segmented into objects for content-based processing. A number of video object segmentation algorithms have been proposed such as semiautomatic and automatic. Semiautomatic methods adds burden t...
Performance Analysis of Conventional Diversity Combining Schemes in Rayleigh and Rician Fading Channels
Abstract: Diversity is the powerful technique used in wireless communication system to improve the performance over a fading radio channel [1] [2]. Here receiver is provided with multiple copies of the same infor...
An Efficient And Secure Cryptography Techniques Usingunimodular Matrix
Abstract: In day to day life, transmission of data from sender to receiver with security is very difficult. "Cryptography" is one of the famous techniques which provide security for confidential data. Cryptography is one...