Joint Conference on Green Engineering Technology & Applied Computing 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) | |
工业技术(总论);计算机科学 | |
Nor Azhar, A.^1 ; Nur Ayuni Hasna, S.^2 ; Roslina, A.H.^3 ; Fauziah, Z.^3 ; Rahmah, M.^4 | |
Department of Computer Science, Universiti Malaysia Pahang, Lebuhraya Tun Razak, Gambang, Pahang, Kuantan | |
26300, Malaysia^1 | |
Department of Computer Systems and Networking, Universiti Malaysia Pahang, Lebuhraya Tun Razak, Gambang, Pahang, Kuantan | |
26300, Malaysia^2 | |
Department of Software Engineering, Universiti Malaysia Pahang, Lebuhraya Tun Razak, Gambang, Pahang, Kuantan | |
26300, Malaysia^3 | |
Department of Graphic and Multimedia Technology, Faculty of Computer Systems and Software Engineering, Universiti Malaysia Pahang, Lebuhraya Tun Razak, Gambang, Pahang, Kuantan | |
26300, Malaysia^4 | |
关键词: Data transmission rates; Internet of Things (IOT); Multiple networks; Network speed; Research subjects; Sensing devices; Single board computers; Structured query languages; | |
Others : https://iopscience.iop.org/article/10.1088/1757-899X/551/1/012048/pdf DOI : 10.1088/1757-899X/551/1/012048 |
|
来源: IOP | |
【 摘 要 】
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.
【 预 览 】
Files | Size | Format | 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) | 632KB | download |