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...
| Main Authors: | , , , , |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
IOP Publishing
2019
|
| Subjects: | |
| Online Access: | 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 |
| _version_ | 1848822563122184192 |
|---|---|
| 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 |
| building | UMP Institutional Repository |
| collection | Online Access |
| 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. |
| first_indexed | 2025-11-15T02:43:13Z |
| format | Conference or Workshop Item |
| id | ump-26558 |
| institution | Universiti Malaysia Pahang |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T02:43:13Z |
| publishDate | 2019 |
| publisher | IOP Publishing |
| recordtype | eprints |
| repository_type | Digital Repository |
| 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 (Published) https://doi.org/10.1088/1757-899X/551/1/012048 10.1088/1757-899X/551/1/012048 |
| 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) |
| 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_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_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_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) |
| topic | QA75 Electronic computers. Computer science QA76 Computer software ZA Information resources ZA4450 Databases |
| 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 |