Solap query processing over IoT networks in smart cities: a novel architecture
Autor(a) principal: | |
---|---|
Data de Publicação: | 2020 |
Outros Autores: | , |
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_ |
1803589283540369408 |