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
Published in:IOP conference series. Materials Science and Engineering Vol. 551; no. 1; pp. 12048 - 12052
Main Authors: Nor Azhar, A, Nur Ayuni Hasna, S, Roslina, AH, Fauziah, Z, Rahmah, M
Format: Journal Article
Language:English
Published: Bristol IOP Publishing 01.08.2019
Subjects:
Data transmission
Internet of Things
Query languages
Structured Query Language-SQL
Transmission rate (communications)
Wireless sensor networks
ISSN:1757-8981, 1757-899X
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Abstract 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.
AbstractList 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.
Author Nor Azhar, A
Rahmah, M
Roslina, AH
Nur Ayuni Hasna, S
Fauziah, Z
Author_xml – sequence: 1
  givenname: A
  surname: Nor Azhar
  fullname: Nor Azhar, A
  email: nazhar@ump.edu.my
  organization: Department of Computer Science
– sequence: 2
  givenname: S
  surname: Nur Ayuni Hasna
  fullname: Nur Ayuni Hasna, S
  organization: Department of Computer Systems & Networking
– sequence: 3
  givenname: AH
  surname: Roslina
  fullname: Roslina, AH
  organization: Department of Software Engineering
– sequence: 4
  givenname: Z
  surname: Fauziah
  fullname: Fauziah, Z
  organization: Department of Software Engineering
– sequence: 5
  givenname: M
  surname: Rahmah
  fullname: Rahmah, M
  organization: Department of Graphic & Multimedia Technology, Faculty of Computer Systems & Software Engineering, Universiti Malaysia Pahang, Lebuhraya Tun Razak , Malaysia
BookMark eNqFkVFP2zAUhS3EJCjjL0yWeGkfSu20dZxHaDuo1G2gFGlv1q1zXVJaO9jJEH-LX4izTiCkSTz5Xvl851g-HXJonUVCvnF2zpmUA56O077Mst-D8ZgP-IDxhI3kATl-uzh8myU_Ip0QNoyJdDRix-Rlbs22QauROkN_Yv3k_APNK8SCOkvz2je6bnzcbhv0z3QBdt3AGmk3v1306BRqWEHAvwNderBhV4ZQRvQGvXF-B611aSlYOrc1eot1m7S8L-060O7cLXs0RxviSqf4p2wfEnPjukV66cAXdOJ2VRPRKM8vJ72v5IuBbcDTf-cJufs-W06u-4tfV_PJxaKvE5HJvoFMQAYiBQEFS0WhC8mKVINcwQgS4JlhRmoAianmmgmUHFZpkaFkQmZ6eELO9r6Vd48NhlptXONtjFTJWHDOEjHkUSX2Ku1dCB6Nqny5A_-sOFNtP6r9etXWoGI_iqt9PxFM9mDpqnfnT6Huf6Af-eyDTFWFGb4CA42i2Q
Cites_doi 10.15282/ijsecs.4.1.2018.8.0041
10.1016/j.future.2018.06.040
10.1088/1742-6596/1018/1/012019
10.1166/asl.2018.12965
ContentType Journal Article
Copyright Published under licence by IOP Publishing Ltd
2019. This work is published under http://creativecommons.org/licenses/by/3.0/ (the “License”). Notwithstanding the ProQuest Terms and Conditions, you may use this content in accordance with the terms of the License.
Copyright_xml – notice: Published under licence by IOP Publishing Ltd
– notice: 2019. This work is published under http://creativecommons.org/licenses/by/3.0/ (the “License”). Notwithstanding the ProQuest Terms and Conditions, you may use this content in accordance with the terms of the License.
DBID O3W
TSCCA
AAYXX
CITATION
8FE
8FG
ABJCF
ABUWG
AFKRA
AZQEC
BENPR
BGLVJ
CCPQU
D1I
DWQXO
HCIFZ
KB.
L6V
M7S
PDBOC
PHGZM
PHGZT
PIMPY
PKEHL
PQEST
PQGLB
PQQKQ
PQUKI
PRINS
PTHSS
DOI 10.1088/1757-899X/551/1/012048
DatabaseName Institute of Physics Open Access Journal Titles
IOPscience (Open Access)
CrossRef
ProQuest SciTech Collection
ProQuest Technology Collection
Materials Science & Engineering Collection
ProQuest Central (Alumni)
ProQuest Central UK/Ireland
ProQuest Central Essentials
ProQuest Central (subscription)
ProQuest Technology Collection
ProQuest One Community College
ProQuest Materials Science Collection
ProQuest Central
SciTech Premium Collection
Materials Science Database
ProQuest Engineering Collection
Engineering Database
Materials Science Collection
ProQuest Central Premium
ProQuest One Academic (New)
Publicly Available Content Database
ProQuest One Academic Middle East (New)
ProQuest One Academic Eastern Edition (DO NOT USE)
ProQuest One Applied & Life Sciences
ProQuest One Academic (retired)
ProQuest One Academic UKI Edition
ProQuest Central China
Engineering Collection
DatabaseTitle CrossRef
Publicly Available Content Database
Technology Collection
ProQuest One Academic Middle East (New)
ProQuest Central Essentials
Materials Science Collection
ProQuest Central (Alumni Edition)
SciTech Premium Collection
ProQuest One Community College
ProQuest Central China
ProQuest Central
ProQuest One Applied & Life Sciences
ProQuest Engineering Collection
ProQuest Central Korea
Materials Science Database
ProQuest Central (New)
Engineering Collection
ProQuest Materials Science Collection
Engineering Database
ProQuest One Academic Eastern Edition
ProQuest Technology Collection
ProQuest SciTech Collection
ProQuest One Academic UKI Edition
Materials Science & Engineering Collection
ProQuest One Academic
ProQuest One Academic (New)
DatabaseTitleList
Publicly Available Content Database
CrossRef
Database_xml – sequence: 1
  dbid: O3W
  name: Institute of Physics Open Access Journal Titles
  url: http://iopscience.iop.org/
  sourceTypes:
    Enrichment Source
    Publisher
– sequence: 2
  dbid: KB.
  name: Materials Science Database
  url: http://search.proquest.com/materialsscijournals
  sourceTypes: Aggregation Database
DeliveryMethod fulltext_linktorsrc
Discipline Engineering
DocumentTitleAlternate 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)
EISSN 1757-899X
ExternalDocumentID 10_1088_1757_899X_551_1_012048
MSE_551_1_012048
GroupedDBID 1JI
5B3
5PX
5VS
AAJIO
AAJKP
ABHWH
ABJCF
ACAFW
ACGFO
ACHIP
ACIPV
AEFHF
AEJGL
AFKRA
AFYNE
AHSEE
AIYBF
AKPSB
ALMA_UNASSIGNED_HOLDINGS
ASPBG
ATQHT
AVWKF
AZFZN
BENPR
BGLVJ
CCPQU
CEBXE
CJUJL
CRLBU
EBS
EDWGO
EQZZN
GROUPED_DOAJ
GX1
HCIFZ
HH5
IJHAN
IOP
IZVLO
KB.
KNG
KQ8
M7S
N5L
O3W
OK1
P2P
PDBOC
PIMPY
PJBAE
PTHSS
RIN
RNS
SY9
T37
TR2
TSCCA
W28
AAYXX
AEINN
AFFHD
CITATION
PHGZM
PHGZT
PQGLB
8FE
8FG
ABUWG
AZQEC
D1I
DWQXO
L6V
PKEHL
PQEST
PQQKQ
PQUKI
PRINS
ID FETCH-LOGICAL-c2698-fa96a9a67a6ad076dcd80d7ca8ba4a2a19f0f8caa8e7c1c06e81ab7d9e80689c3
IEDL.DBID O3W
ISSN 1757-8981
IngestDate Wed Aug 13 04:57:30 EDT 2025
Sat Nov 29 06:33:27 EST 2025
Wed Aug 21 03:33:18 EDT 2024
Thu Jan 07 13:51:24 EST 2021
IsDoiOpenAccess true
IsOpenAccess true
IsPeerReviewed true
IsScholarly true
Issue 1
Language English
License Content from this work may be used under the terms of the Creative Commons Attribution 3.0 licence. Any further distribution of this work must maintain attribution to the author(s) and the title of the work, journal citation and DOI.
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-c2698-fa96a9a67a6ad076dcd80d7ca8ba4a2a19f0f8caa8e7c1c06e81ab7d9e80689c3
Notes ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
OpenAccessLink https://iopscience.iop.org/article/10.1088/1757-899X/551/1/012048
PQID 2561102631
PQPubID 4998670
PageCount 5
ParticipantIDs iop_journals_10_1088_1757_899X_551_1_012048
crossref_primary_10_1088_1757_899X_551_1_012048
proquest_journals_2561102631
PublicationCentury 2000
PublicationDate 20190801
PublicationDateYYYYMMDD 2019-08-01
PublicationDate_xml – month: 08
  year: 2019
  text: 20190801
  day: 01
PublicationDecade 2010
PublicationPlace Bristol
PublicationPlace_xml – name: Bristol
PublicationTitle IOP conference series. Materials Science and Engineering
PublicationTitleAlternate IOP Conf. Ser.: Mater. Sci. Eng
PublicationYear 2019
Publisher IOP Publishing
Publisher_xml – name: IOP Publishing
References Haneen (MSE_551_1_012048bib10) 2018; 1018
Raza (MSE_551_1_012048bib8) 2018; 24
Zyrianoff (MSE_551_1_012048bib5) 2018; 688
Guha (MSE_551_1_012048bib3) 2018; 89
Syafrudin (MSE_551_1_012048bib6); 18
Rautmare (MSE_551_1_012048bib4) 2017; 235
Isakovic (MSE_551_1_012048bib9) 2018; 1153
Nasir (MSE_551_1_012048bib2) 2018
Maria (MSE_551_1_012048bib7) 2018; 4
Stylianopoulos (MSE_551_1_012048bib1) 2018; 187
References_xml – volume: 4
  start-page: 95
  year: 2018
  ident: MSE_551_1_012048bib7
  publication-title: Int. J. Softw. Eng. Comput. Syst.
  doi: 10.15282/ijsecs.4.1.2018.8.0041
– volume: 187
  year: 2018
  ident: MSE_551_1_012048bib1
  publication-title: Nordic Conf. on Secure IT Syst.
– volume: 89
  start-page: 300
  year: 2018
  ident: MSE_551_1_012048bib3
  publication-title: Futur. Gener. Comput. Syst.
  doi: 10.1016/j.future.2018.06.040
– volume: 235
  year: 2017
  ident: MSE_551_1_012048bib4
  publication-title: IEEE Int. Conf. Adv. Comput. Appl.
– volume: 1018
  start-page: 012019
  year: 2018
  ident: MSE_551_1_012048bib10
  publication-title: J. Phys. Conf. Ser.
  doi: 10.1088/1742-6596/1018/1/012019
– volume: 688
  year: 2018
  ident: MSE_551_1_012048bib5
  publication-title: IEEE Symp. Comput. Commum.
– volume: 18
  start-page: 9
  ident: MSE_551_1_012048bib6
  publication-title: Sensors
– volume: 24
  start-page: 7490
  year: 2018
  ident: MSE_551_1_012048bib8
  publication-title: Adv. Sci. Lett.
  doi: 10.1166/asl.2018.12965
– volume: 1153
  year: 2018
  ident: MSE_551_1_012048bib9
  publication-title: J. Comput. Syst. Softw. Eng.
– year: 2018
  ident: MSE_551_1_012048bib2
SSID ssj0067440
Score 2.1075118
Snippet 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...
SourceID proquest
crossref
iop
SourceType Aggregation Database
Index Database
Enrichment Source
Publisher
StartPage 12048
SubjectTerms Data transmission
Internet of Things
Query languages
Structured Query Language-SQL
Transmission rate (communications)
Wireless sensor networks
SummonAdditionalLinks – databaseName: ProQuest Central (subscription)
  dbid: BENPR
  link: http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwpV3da9swEBdruoftofssS9eNG-yhYRhbji1LT2NpU1boQjp3kDdxkeQRGLaXpIP9W_sLJ8kyaRlsD8MvlnUgw53vzvf1I-StcjO1XdkgMqYiKyF5hCqnUaoLjahT5BV6sIliNuOLhZiHgNsmlFX2OtErat0oFyOPrWm2liplY_q-_R451CiXXQ0QGntk300qywZkfzKdzT_3upi58Xe-JTK3ulhw2vcI29--8EwsYus0xDR2XaQOBeiWedpbNe0fOtobnvNH__vKj8lBcDnhQycjT8g9Uz8lD28NInxGfl30WCXQVDDrSsOhbK1pg6aG0g-ZvVnb1dWNWf-EyxDlhJPy6nIEZ7hFZw79DXjzZ8XHxeFgvmtMgFUNWEMXgzRbd1KHGgonF831CEpXS19_hTPjtJc_1y6_GZg0Voyhx5-w5OXkdPScfDmfXp9-jAKaQ6RSJnhUoWAokBXIUCcF00rzRBcK-RIzTJGKKqm4QuSmUFQlzHCKy0ILwxPGhRofkkHd1OYFAUwFXWp7LbM8M7nATPDc-jVjl1RORDIkcc9E2XZDO6RPtnMuHdulY7u0bJdUdmwfkneW1zJ8v5t_Ur-5Q_2pnN7Zl62uhuS4F4od4U4ijv6-_ZI8sJ6Z6CoNj8nAstm8IvfVj-1qs34dpPw3c5UA2g
  priority: 102
  providerName: ProQuest
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)
URI https://iopscience.iop.org/article/10.1088/1757-899X/551/1/012048
https://www.proquest.com/docview/2561102631
Volume 551
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
journalDatabaseRights – providerCode: PRVIOP
  databaseName: Institute of Physics Open Access Journal Titles
  customDbUrl:
  eissn: 1757-899X
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0067440
  issn: 1757-8981
  databaseCode: O3W
  dateStart: 20090201
  isFulltext: true
  titleUrlDefault: http://iopscience.iop.org/
  providerName: IOP Publishing
– providerCode: PRVPQU
  databaseName: Engineering Database
  customDbUrl:
  eissn: 1757-899X
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0067440
  issn: 1757-8981
  databaseCode: M7S
  dateStart: 20090201
  isFulltext: true
  titleUrlDefault: http://search.proquest.com
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Materials Science Database
  customDbUrl:
  eissn: 1757-899X
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0067440
  issn: 1757-8981
  databaseCode: KB.
  dateStart: 20090201
  isFulltext: true
  titleUrlDefault: http://search.proquest.com/materialsscijournals
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: ProQuest Central
  customDbUrl:
  eissn: 1757-899X
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0067440
  issn: 1757-8981
  databaseCode: BENPR
  dateStart: 20090201
  isFulltext: true
  titleUrlDefault: https://www.proquest.com/central
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Publicly Available Content Database
  customDbUrl:
  eissn: 1757-899X
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0067440
  issn: 1757-8981
  databaseCode: PIMPY
  dateStart: 20090201
  isFulltext: true
  titleUrlDefault: http://search.proquest.com/publiccontent
  providerName: ProQuest
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV3db9MwELfoxgM88I0ojOqQeFiFsnw79iPdOlGxlYwM0T1FV9tBk1BSdR0S_xZ_IWcn0agQQkgoL458jq3c-X4n-z4Ye61sTm3rNoicK48kJPVQpaEX6Uwj6ghFha7YRDafi8VC5p03oYuFaVad6j-gZpsouP2FnUOc8AnwSLFKufAJ7f3Qt-GfiRiw3Vik3Ir6h_hzr4y5zX_nYiLdGBH2QcJ__M4WPg1oDb8paYc8x_f_w5ofsHud2Qlv2wEP2S1TP2J3f0lG-Jj9mPX1SqCpYN66h0OxIniDpobCJZq9XtPb2bVZf4eT7qQT9ouzkzEc4QYtJLoGOAgkEbJncZDfBCfAZQ1YQ3sOaTZ2prZyKOzPmvMxFNafvv4CR8ZqMDcvvX41MGlIlKGvQUHkxeRw_IR9Op6eH77zuooOnoq4FF6FkqNEniFHHWRcKy0CnSkUS0wwwlBWQSUUojCZClXAjQhxmWlpRMCFVPFTtlM3tXnGACMZLjU9yyRNTCoxkSIl2ya2F8uBDIbM7_lYrtrEHaW7cBeitNwoLTdK4kYZli03huwNsa_s9vDVX6lfbVGfFtOt_nKlqyHb60XnhpBsTDK5Ih6Hz_9pwhfsDhlrsnU-3GM7xHXzkt1W3zaXV-sR251M5_nHERu8nxyMrAdrMXI7gXry2Wl-8RO66gH6
linkProvider IOP Publishing
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMw1V3daxNBEF_aVFAf_JZGq46g0CDHfeQ-dh9EbNPSo0lIuQjx6Zzs7pWA3J1JqvSf8sG_0Nn7IC2CPvVB7uX2driF3d_M7M7OB2NvpMmpbdwGMQylRQgJLJSBa3kqUojKQ55hVWwiGo_5bCYmW-xnGwtj3CpbmVgJalVIYyO3STWTpvLCvvuh_GaZqlHmdrUtoVHD4lRf_qAj2-p9PKD1fet5x0fTwxOrqSpgSS8U3MpQhCgwjDBERad4JRV3VCSRz9FHD12RORmXiFxH0pVOqLmL80gJzZ2QC9mn_26zHZ_AzjtsZxKPJp9b2R-adHtVCGZAsl9wt41JpmNm803MbNqk2K5tolZN1aEr6nB7UZR_6IRK0R3f_9-m6AG712yp4WPNAw_Zls4fsbtXEi0-Zr_ithYLFBmMa9d3SEpS3VDkkFRJdC-W1Dq70MtLGDZWXNhPzoY9GOAajbqvXqBS78Qexs4Ik03gBSxywBxqG6tem5HqqqiwHxfTHiQmViA_h4E20rkal5pfNRwUxKbQ1tcg8uTgsPeEfbqRSXvKOnmR610G6Al3ruiZ-4GvA4G-4AHt2_rm0twRTpfZLWjSsk5KklbOBJynBmapgVlKMEvdtIZZl70jbKWNfFr9k_r1NepRcnStPy1V1mV7LQg3hBsEPvt79yt2-2Q6GqbDeHz6nN2hXaiovSr3WIeWXL9gt-T39WK1fNlwGLAvN43Y33VMYQk
linkToPdf http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV3db9MwELe2gRA88I1WGHBIPKxCWb4ax35kaysqSumUIfpmXW0HTZqSquuQ-Lf4Czk7CaNCCCGhvNjKObZy5_ud7Ptg7LV2ObWd2yByrgOSkCxAncVBYnKDaBIUJfpiE_lsJhYLOd9ho5-xMPWqVf1H1GwSBTe_sHWIEyEBHilWKRchoX0Yhy78cyDClSl32Y0szVJXweFj-rlTyNzlwPNxkX6ciLtA4T9-awujdmkdvylqjz7je_9p3ffZ3db8hLfNoAdsx1YP2Z1fkhI-Yt8nXd0SqEuYNW7iUKwI5qCuoPAJZ6_W1Du9sutvMG1PPOGwOJ32YYgbdNDoG-ChkETJncnB_DpIAc4rwAqa80i7cTM1FUThcFKf9aFwfvXVFxhap8n8vNS9sHBck0hDV4uCyIvjk_5j9mk8Ojt5F7SVHQKdcCmCEiVHiTxHjibKudFGRCbXKJY4wARjWUal0IjC5jrWEbcixmVupBURF1KnT9heVVd2nwEmMl4aepaDbGAziQMpMrJxUnfBHMmox8KOl2rVJPBQ_uJdCOU4ohxHFHFExarhSI-9IRaqdi9f_pX61Rb1h2K09V4Rf3vsoBOfa0KyNcn0SngaP_2nCV-yW_PhWE0ns_fP2G2y32Tjj3jA9kgA7HN2U3_dnF-uX_hN8AMQcQI5
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Influence+of+Network+Speed+on+Structured+Query+Language+%28SQL%29+Database+Data+Transmission+Performance+in+an+Internet+of+Things+%28IoT%29+Sensing+Device+on+Single+Board+Computers+%28SBC%29&rft.jtitle=IOP+conference+series.+Materials+Science+and+Engineering&rft.au=Nor+Azhar%2C+A&rft.au=Nur+Ayuni+Hasna%2C+S&rft.au=Roslina%2C+AH&rft.au=Fauziah%2C+Z&rft.date=2019-08-01&rft.pub=IOP+Publishing&rft.issn=1757-8981&rft.eissn=1757-899X&rft.volume=551&rft.issue=1&rft_id=info:doi/10.1088%2F1757-899X%2F551%2F1%2F012048&rft.externalDocID=MSE_551_1_012048
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1757-8981&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1757-8981&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1757-8981&client=summon