Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC)

One of the crucial elements in an Internet of Things (IoT) environment is a database. IoT performance will be at stake if the wrong database is adopted. In this research, three Structured Query Language (SQL) databases were tested against multiple network speeds in an IoT device. Single board comput...

Full description

Bibliographic Details
Main Authors:	Nor Azhar, Ahmad, Nur Hasna Ayuni, Said, Roslina, Abd Hamid, Fauziah, Zainuddin, Rahmah, Mokhtar
Format:	Conference or Workshop Item
Language:	English
Published:	IOP Publishing 2019
Subjects:	QA75 Electronic computers. Computer science QA76 Computer software ZA Information resources ZA4450 Databases
Online Access:	http://umpir.ump.edu.my/id/eprint/26558/ http://umpir.ump.edu.my/id/eprint/26558/ http://umpir.ump.edu.my/id/eprint/26558/ http://umpir.ump.edu.my/id/eprint/26558/1/Nor_Azhar_2019_IOP_Conf._Ser.__Mater._Sci._Eng._551_012048%20%282%29.pdf

id	ump-26558
recordtype	eprints
spelling	ump-265582019-11-27T04:37:01Z http://umpir.ump.edu.my/id/eprint/26558/ Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC) Nor Azhar, Ahmad Nur Hasna Ayuni, Said Roslina, Abd Hamid Fauziah, Zainuddin Rahmah, Mokhtar QA75 Electronic computers. Computer science QA76 Computer software ZA Information resources ZA4450 Databases One of the crucial elements in an Internet of Things (IoT) environment is a database. IoT performance will be at stake if the wrong database is adopted. In this research, three Structured Query Language (SQL) databases were tested against multiple network speeds in an IoT device. Single board computers (SBC) were used as a media of testing instead of an ordinary computer. A controlled wireless sensor network (WSN) was developed with several uniform constants and variable network speeds. A new data transmission rate equation also was proposed and tested. From the result, it was found that not all SQL databases can cater IoT devices. Some of them showed that performance decreased along with network speed. The correlation, between 0.90 and 0.96, proved the strong influence between the research subjects. In addition, file-type database is the best option available for SQL-wise IoT storage. IOP Publishing 2019-08 Conference or Workshop Item PeerReviewed pdf en cc_by_nd http://umpir.ump.edu.my/id/eprint/26558/1/Nor_Azhar_2019_IOP_Conf._Ser.__Mater._Sci._Eng._551_012048%20%282%29.pdf Nor Azhar, Ahmad and Nur Hasna Ayuni, Said and Roslina, Abd Hamid and Fauziah, Zainuddin and Rahmah, Mokhtar (2019) Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC). In: IOP Conference Series: Materials Science and Engineering, Joint Conference on Green Engineering Technology & Applied Computing 2019, 4-5 February 2019 , Bangkok, Thailand. pp. 1-5., 551 (012048). ISSN 1757-899X https://doi.org/10.1088/1757-899X/551/1/012048 10.1088/1757-899X/551/1/012048
repository_type	Digital Repository
institution_category	Local University
institution	Universiti Malaysia Pahang
building	UMP Institutional Repository
collection	Online Access
language	English
topic	QA75 Electronic computers. Computer science QA76 Computer software ZA Information resources ZA4450 Databases
spellingShingle	QA75 Electronic computers. Computer science QA76 Computer software ZA Information resources ZA4450 Databases Nor Azhar, Ahmad Nur Hasna Ayuni, Said Roslina, Abd Hamid Fauziah, Zainuddin Rahmah, Mokhtar Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC)
description	One of the crucial elements in an Internet of Things (IoT) environment is a database. IoT performance will be at stake if the wrong database is adopted. In this research, three Structured Query Language (SQL) databases were tested against multiple network speeds in an IoT device. Single board computers (SBC) were used as a media of testing instead of an ordinary computer. A controlled wireless sensor network (WSN) was developed with several uniform constants and variable network speeds. A new data transmission rate equation also was proposed and tested. From the result, it was found that not all SQL databases can cater IoT devices. Some of them showed that performance decreased along with network speed. The correlation, between 0.90 and 0.96, proved the strong influence between the research subjects. In addition, file-type database is the best option available for SQL-wise IoT storage.
format	Conference or Workshop Item
author	Nor Azhar, Ahmad Nur Hasna Ayuni, Said Roslina, Abd Hamid Fauziah, Zainuddin Rahmah, Mokhtar
author_facet	Nor Azhar, Ahmad Nur Hasna Ayuni, Said Roslina, Abd Hamid Fauziah, Zainuddin Rahmah, Mokhtar
author_sort	Nor Azhar, Ahmad
title	Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC)
title_short	Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC)
title_full	Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC)
title_fullStr	Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC)
title_full_unstemmed	Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC)
title_sort	influence of network speed on structured query language (sql) database data transmission performance in an internet of things (iot) sensing device on single board computers (sbc)
publisher	IOP Publishing
publishDate	2019
url	http://umpir.ump.edu.my/id/eprint/26558/ http://umpir.ump.edu.my/id/eprint/26558/ http://umpir.ump.edu.my/id/eprint/26558/ http://umpir.ump.edu.my/id/eprint/26558/1/Nor_Azhar_2019_IOP_Conf._Ser.__Mater._Sci._Eng._551_012048%20%282%29.pdf
first_indexed	2023-09-18T22:41:25Z
last_indexed	2023-09-18T22:41:25Z
_version_	1777416940474597376

Influence of Network Speed on Structured Query Language (SQL) Database Data Transmission Performance in an Internet of Things (IoT) Sensing Device on Single Board Computers (SBC)

Similar Items