Solap query processing over IoT networks in smart cities: a novel architecture

Detalhes bibliográficos
Autor(a) principal: João Pedro de Carvalho Castro
Data de Publicação: 2020
Outros Autores: João Paulo Clarindo Dos Santos, Cristina Dutra de Aguiar Ciferri
Tipo de documento: Artigo de conferência
Idioma: eng
Título da fonte: Repositório Institucional da UFMG
Texto Completo: http://hdl.handle.net/1843/51298
https://orcid.org/0000-0003-3566-0415
https://orcid.org/0000-0001-9571-4951
https://orcid.org/0000-0002-7618-1405
Resumo: Spatial data generated by an Internet of Things (IoT) network is important to assist the decision-making in issues related to smart cities. In these cities, IoT devices generate spatial data constantly. Thus, data get increasingly voluminous very fast. In this paper, we investigate the challenge of managing these data through the use of a spatial data warehouse and spatial on-line analytical processing designed over a parallel and distributed processing framework extended with a spatial analytics system. We propose a novel architecture aimed to assist a smart city manager in decision-making, which integrates a cloud layer where these technologies are located with a fog computing layer for extracting, transforming and loading. Furthermore, we introduce a set of guidelines to aid smart cities managers to implement the proposed architecture. We validate our architecture with a case study that uses real data collected by IoT devices in a smart city.
id UFMG_613529516154bfbbf9dadfafe4b99116
oai_identifier_str oai:repositorio.ufmg.br:1843/51298
network_acronym_str UFMG
network_name_str Repositório Institucional da UFMG
repository_id_str
spelling 2023-03-28T20:34:21Z2023-03-28T20:34:21Z2020211181292179-4847http://hdl.handle.net/1843/51298https://orcid.org/0000-0003-3566-0415https://orcid.org/0000-0001-9571-4951https://orcid.org/0000-0002-7618-1405Spatial data generated by an Internet of Things (IoT) network is important to assist the decision-making in issues related to smart cities. In these cities, IoT devices generate spatial data constantly. Thus, data get increasingly voluminous very fast. In this paper, we investigate the challenge of managing these data through the use of a spatial data warehouse and spatial on-line analytical processing designed over a parallel and distributed processing framework extended with a spatial analytics system. We propose a novel architecture aimed to assist a smart city manager in decision-making, which integrates a cloud layer where these technologies are located with a fog computing layer for extracting, transforming and loading. Furthermore, we introduce a set of guidelines to aid smart cities managers to implement the proposed architecture. We validate our architecture with a case study that uses real data collected by IoT devices in a smart city.Dados espaciais gerados por uma rede de Internet das Coisas (IoT) são importantes para auxiliar a tomada de decisões em questões relacionadas a cidades inteligentes. Nessas cidades, os dispositivos IoT geram dados espaciais constantemente. Assim, os dados ficam cada vez mais volumosos muito rápido. Neste artigo, investigamos o desafio de gerenciar esses dados por meio do uso de um armazenamento de dados espaciais e processamento analítico espacial on-line projetado sobre uma estrutura de processamento paralelo e distribuído estendida com um sistema de análise espacial. Propomos uma nova arquitetura destinada a auxiliar o gestor de uma cidade inteligente na tomada de decisões, que integra uma camada de nuvem onde essas tecnologias estão localizadas com uma camada de fog computing para extração, transformação e carregamento. Além disso, apresentamos um conjunto de diretrizes para auxiliar os gestores de cidades inteligentes a implementar a arquitetura proposta. Validamos nossa arquitetura com um estudo de caso que utiliza dados reais coletados por dispositivos IoT em uma cidade inteligente.CNPq - Conselho Nacional de Desenvolvimento Científico e TecnológicoFAPESP - Fundação de Amparo à Pesquisa do Estado de São PauloengUniversidade Federal de Minas GeraisUFMGBrasilCECOM - CENTRO DE COMPUTACAOBrazilian Symposium on GeoinformaticsProcessamento eletrônico de dados - CongressosInternet das coisasInfraestrutura de dados espaciaisSOLAPInternet of ThingsSmart citySpatial dataSolap query processing over IoT networks in smart cities: a novel architectureProcessamento de consultas Solap em redes IoT em cidades inteligentes: uma nova arquiteturainfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/conferenceObjecthttp://urlib.net/ibi/8JMKD3MGPDW34P/43PRNMEJoão Pedro de Carvalho CastroJoão Paulo Clarindo Dos SantosCristina Dutra de Aguiar Ciferriapplication/pdfinfo:eu-repo/semantics/openAccessreponame:Repositório Institucional da UFMGinstname:Universidade Federal de Minas Gerais (UFMG)instacron:UFMGLICENSELicense.txtLicense.txttext/plain; charset=utf-82042https://repositorio.ufmg.br/bitstream/1843/51298/1/License.txtfa505098d172de0bc8864fc1287ffe22MD51ORIGINALSOLAP Query Processing over IoT Networks in Smart Cities A Novel Architecture.pdfSOLAP Query Processing over IoT Networks in Smart Cities A Novel Architecture.pdfapplication/pdf6203918https://repositorio.ufmg.br/bitstream/1843/51298/2/SOLAP%20Query%20Processing%20over%20IoT%20Networks%20in%20Smart%20Cities%20A%20Novel%20Architecture.pdfa947deec43ec718a2026b361b8e08fdbMD521843/512982023-03-28 17:34:21.263oai:repositorio.ufmg.br:1843/51298TElDRU7vv71BIERFIERJU1RSSUJVSe+/ve+/vU8gTu+/vU8tRVhDTFVTSVZBIERPIFJFUE9TSVTvv71SSU8gSU5TVElUVUNJT05BTCBEQSBVRk1HCiAKCkNvbSBhIGFwcmVzZW50Ye+/ve+/vW8gZGVzdGEgbGljZW7vv71hLCB2b2Pvv70gKG8gYXV0b3IgKGVzKSBvdSBvIHRpdHVsYXIgZG9zIGRpcmVpdG9zIGRlIGF1dG9yKSBjb25jZWRlIGFvIFJlcG9zaXTvv71yaW8gSW5zdGl0dWNpb25hbCBkYSBVRk1HIChSSS1VRk1HKSBvIGRpcmVpdG8gbu+/vW8gZXhjbHVzaXZvIGUgaXJyZXZvZ++/vXZlbCBkZSByZXByb2R1emlyIGUvb3UgZGlzdHJpYnVpciBhIHN1YSBwdWJsaWNh77+977+9byAoaW5jbHVpbmRvIG8gcmVzdW1vKSBwb3IgdG9kbyBvIG11bmRvIG5vIGZvcm1hdG8gaW1wcmVzc28gZSBlbGV0cu+/vW5pY28gZSBlbSBxdWFscXVlciBtZWlvLCBpbmNsdWluZG8gb3MgZm9ybWF0b3Mg77+9dWRpbyBvdSB277+9ZGVvLgoKVm9j77+9IGRlY2xhcmEgcXVlIGNvbmhlY2UgYSBwb2zvv710aWNhIGRlIGNvcHlyaWdodCBkYSBlZGl0b3JhIGRvIHNldSBkb2N1bWVudG8gZSBxdWUgY29uaGVjZSBlIGFjZWl0YSBhcyBEaXJldHJpemVzIGRvIFJJLVVGTUcuCgpWb2Pvv70gY29uY29yZGEgcXVlIG8gUmVwb3NpdO+/vXJpbyBJbnN0aXR1Y2lvbmFsIGRhIFVGTUcgcG9kZSwgc2VtIGFsdGVyYXIgbyBjb250Ze+/vWRvLCB0cmFuc3BvciBhIHN1YSBwdWJsaWNh77+977+9byBwYXJhIHF1YWxxdWVyIG1laW8gb3UgZm9ybWF0byBwYXJhIGZpbnMgZGUgcHJlc2VydmHvv73vv71vLgoKVm9j77+9IHRhbWLvv71tIGNvbmNvcmRhIHF1ZSBvIFJlcG9zaXTvv71yaW8gSW5zdGl0dWNpb25hbCBkYSBVRk1HIHBvZGUgbWFudGVyIG1haXMgZGUgdW1hIGPvv71waWEgZGUgc3VhIHB1YmxpY2Hvv73vv71vIHBhcmEgZmlucyBkZSBzZWd1cmFu77+9YSwgYmFjay11cCBlIHByZXNlcnZh77+977+9by4KClZvY++/vSBkZWNsYXJhIHF1ZSBhIHN1YSBwdWJsaWNh77+977+9byDvv70gb3JpZ2luYWwgZSBxdWUgdm9j77+9IHRlbSBvIHBvZGVyIGRlIGNvbmNlZGVyIG9zIGRpcmVpdG9zIGNvbnRpZG9zIG5lc3RhIGxpY2Vu77+9YS4gVm9j77+9IHRhbWLvv71tIGRlY2xhcmEgcXVlIG8gZGVw77+9c2l0byBkZSBzdWEgcHVibGljYe+/ve+/vW8gbu+/vW8sIHF1ZSBzZWphIGRlIHNldSBjb25oZWNpbWVudG8sIGluZnJpbmdlIGRpcmVpdG9zIGF1dG9yYWlzIGRlIG5pbmd177+9bS4KCkNhc28gYSBzdWEgcHVibGljYe+/ve+/vW8gY29udGVuaGEgbWF0ZXJpYWwgcXVlIHZvY++/vSBu77+9byBwb3NzdWkgYSB0aXR1bGFyaWRhZGUgZG9zIGRpcmVpdG9zIGF1dG9yYWlzLCB2b2Pvv70gZGVjbGFyYSBxdWUgb2J0ZXZlIGEgcGVybWlzc++/vW8gaXJyZXN0cml0YSBkbyBkZXRlbnRvciBkb3MgZGlyZWl0b3MgYXV0b3JhaXMgcGFyYSBjb25jZWRlciBhbyBSZXBvc2l077+9cmlvIEluc3RpdHVjaW9uYWwgZGEgVUZNRyBvcyBkaXJlaXRvcyBhcHJlc2VudGFkb3MgbmVzdGEgbGljZW7vv71hLCBlIHF1ZSBlc3NlIG1hdGVyaWFsIGRlIHByb3ByaWVkYWRlIGRlIHRlcmNlaXJvcyBlc3Tvv70gY2xhcmFtZW50ZSBpZGVudGlmaWNhZG8gZSByZWNvbmhlY2lkbyBubyB0ZXh0byBvdSBubyBjb250Ze+/vWRvIGRhIHB1YmxpY2Hvv73vv71vIG9yYSBkZXBvc2l0YWRhLgoKQ0FTTyBBIFBVQkxJQ0Hvv73vv71PIE9SQSBERVBPU0lUQURBIFRFTkhBIFNJRE8gUkVTVUxUQURPIERFIFVNIFBBVFJPQ++/vU5JTyBPVSBBUE9JTyBERSBVTUEgQUfvv71OQ0lBIERFIEZPTUVOVE8gT1UgT1VUUk8gT1JHQU5JU01PLCBWT0Pvv70gREVDTEFSQSBRVUUgUkVTUEVJVE9VIFRPRE9TIEUgUVVBSVNRVUVSIERJUkVJVE9TIERFIFJFVklT77+9TyBDT01PIFRBTULvv71NIEFTIERFTUFJUyBPQlJJR0Hvv73vv71FUyBFWElHSURBUyBQT1IgQ09OVFJBVE8gT1UgQUNPUkRPLgoKTyBSZXBvc2l077+9cmlvIEluc3RpdHVjaW9uYWwgZGEgVUZNRyBzZSBjb21wcm9tZXRlIGEgaWRlbnRpZmljYXIgY2xhcmFtZW50ZSBvIHNldSBub21lKHMpIG91IG8ocykgbm9tZXMocykgZG8ocykgZGV0ZW50b3IoZXMpIGRvcyBkaXJlaXRvcyBhdXRvcmFpcyBkYSBwdWJsaWNh77+977+9bywgZSBu77+9byBmYXLvv70gcXVhbHF1ZXIgYWx0ZXJh77+977+9bywgYWzvv71tIGRhcXVlbGFzIGNvbmNlZGlkYXMgcG9yIGVzdGEgbGljZW7vv71hLgo=Repositório de PublicaçõesPUBhttps://repositorio.ufmg.br/oaiopendoar:2023-03-28T20:34:21Repositório Institucional da UFMG - Universidade Federal de Minas Gerais (UFMG)false
dc.title.pt_BR.fl_str_mv Solap query processing over IoT networks in smart cities: a novel architecture
dc.title.alternative.pt_BR.fl_str_mv Processamento de consultas Solap em redes IoT em cidades inteligentes: uma nova arquitetura
title Solap query processing over IoT networks in smart cities: a novel architecture
spellingShingle Solap query processing over IoT networks in smart cities: a novel architecture
João Pedro de Carvalho Castro
SOLAP
Internet of Things
Smart city
Spatial data
Processamento eletrônico de dados - Congressos
Internet das coisas
Infraestrutura de dados espaciais
title_short Solap query processing over IoT networks in smart cities: a novel architecture
title_full Solap query processing over IoT networks in smart cities: a novel architecture
title_fullStr Solap query processing over IoT networks in smart cities: a novel architecture
title_full_unstemmed Solap query processing over IoT networks in smart cities: a novel architecture
title_sort Solap query processing over IoT networks in smart cities: a novel architecture
author João Pedro de Carvalho Castro
author_facet João Pedro de Carvalho Castro
João Paulo Clarindo Dos Santos
Cristina Dutra de Aguiar Ciferri
author_role author
author2 João Paulo Clarindo Dos Santos
Cristina Dutra de Aguiar Ciferri
author2_role author
author
dc.contributor.author.fl_str_mv João Pedro de Carvalho Castro
João Paulo Clarindo Dos Santos
Cristina Dutra de Aguiar Ciferri
dc.subject.por.fl_str_mv SOLAP
Internet of Things
Smart city
Spatial data
topic SOLAP
Internet of Things
Smart city
Spatial data
Processamento eletrônico de dados - Congressos
Internet das coisas
Infraestrutura de dados espaciais
dc.subject.other.pt_BR.fl_str_mv Processamento eletrônico de dados - Congressos
Internet das coisas
Infraestrutura de dados espaciais
description Spatial data generated by an Internet of Things (IoT) network is important to assist the decision-making in issues related to smart cities. In these cities, IoT devices generate spatial data constantly. Thus, data get increasingly voluminous very fast. In this paper, we investigate the challenge of managing these data through the use of a spatial data warehouse and spatial on-line analytical processing designed over a parallel and distributed processing framework extended with a spatial analytics system. We propose a novel architecture aimed to assist a smart city manager in decision-making, which integrates a cloud layer where these technologies are located with a fog computing layer for extracting, transforming and loading. Furthermore, we introduce a set of guidelines to aid smart cities managers to implement the proposed architecture. We validate our architecture with a case study that uses real data collected by IoT devices in a smart city.
publishDate 2020
dc.date.issued.fl_str_mv 2020
dc.date.accessioned.fl_str_mv 2023-03-28T20:34:21Z
dc.date.available.fl_str_mv 2023-03-28T20:34:21Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/conferenceObject
format conferenceObject
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://hdl.handle.net/1843/51298
dc.identifier.issn.pt_BR.fl_str_mv 2179-4847
dc.identifier.orcid.pt_BR.fl_str_mv https://orcid.org/0000-0003-3566-0415
https://orcid.org/0000-0001-9571-4951
https://orcid.org/0000-0002-7618-1405
identifier_str_mv 2179-4847
url http://hdl.handle.net/1843/51298
https://orcid.org/0000-0003-3566-0415
https://orcid.org/0000-0001-9571-4951
https://orcid.org/0000-0002-7618-1405
dc.language.iso.fl_str_mv eng
language eng
dc.relation.ispartof.pt_BR.fl_str_mv Brazilian Symposium on Geoinformatics
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv Universidade Federal de Minas Gerais
dc.publisher.initials.fl_str_mv UFMG
dc.publisher.country.fl_str_mv Brasil
dc.publisher.department.fl_str_mv CECOM - CENTRO DE COMPUTACAO
publisher.none.fl_str_mv Universidade Federal de Minas Gerais
dc.source.none.fl_str_mv reponame:Repositório Institucional da UFMG
instname:Universidade Federal de Minas Gerais (UFMG)
instacron:UFMG
instname_str Universidade Federal de Minas Gerais (UFMG)
instacron_str UFMG
institution UFMG
reponame_str Repositório Institucional da UFMG
collection Repositório Institucional da UFMG
bitstream.url.fl_str_mv https://repositorio.ufmg.br/bitstream/1843/51298/1/License.txt
https://repositorio.ufmg.br/bitstream/1843/51298/2/SOLAP%20Query%20Processing%20over%20IoT%20Networks%20in%20Smart%20Cities%20A%20Novel%20Architecture.pdf
bitstream.checksum.fl_str_mv fa505098d172de0bc8864fc1287ffe22
a947deec43ec718a2026b361b8e08fdb
bitstream.checksumAlgorithm.fl_str_mv MD5
MD5
repository.name.fl_str_mv Repositório Institucional da UFMG - Universidade Federal de Minas Gerais (UFMG)
repository.mail.fl_str_mv
_version_ 1801676766372167680