Staff View: 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)

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

Saved in:

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/1/Nor_Azhar_2019_IOP_Conf._Ser.__Mater._Sci._Eng._551_012048%20%282%29.pdf http://umpir.ump.edu.my/id/eprint/26558/ https://doi.org/10.1088/1757-899X/551/1/012048
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my.ump.umpir.26558
record_format	eprints
spelling	my.ump.umpir.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
institution	Universiti Malaysia Pahang
building	UMP Library
collection	Institutional Repository
continent	Asia
country	Malaysia
content_provider	Universiti Malaysia Pahang
content_source	UMP Institutional Repository
url_provider	http://umpir.ump.edu.my/
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/1/Nor_Azhar_2019_IOP_Conf._Ser.__Mater._Sci._Eng._551_012048%20%282%29.pdf http://umpir.ump.edu.my/id/eprint/26558/ https://doi.org/10.1088/1757-899X/551/1/012048
_version_	1651866983341228032
score	13.211869

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