Graph Representation of Linear Infrastructure in Smart City IoT Systems

2019 ◽  
Author(s):  
Michal Gorawski ◽  
Krzysztof Grochla
Keyword(s):  
Smart City ◽  
Graph Representation ◽  
Linear Infrastructure

scholarly journals Performance Tests of Smart City IoT Data Repositories for Universal Linear Infrastructure Data and Graph Databases

2019 ◽  
Vol 1 (1) ◽  
Author(s):  
Michał Gorawski ◽  
Krzysztof Grochla
Keyword(s):  
Smart City ◽  
Graph Representation ◽  
Sql Server ◽  
Graph Database ◽  
Performance Tests ◽  
Data Repositories ◽  
Device Management ◽  
Linear Infrastructure ◽  
Sql Server Database ◽  
The Difference

Abstract The infrastructure managed by Smart City systems includes mainly linear structures, such as pipelines, electric power lines, railway lines, etc.. In this paper, we propose the transcription of linear infrastructure to graph representation and storing needed meta-data in a graph database, merged with the traditional relational database used for device management. Such an approach enables fast acquisition of data about infrastructure’s properties and allows merging information about the structure of the managed infrastructure with information devices’ properties and statistics. We develop a graph generator that generates virtual network basing on representative examples of linear infrastructure, incorporation of a data from existing metering systems with the generated structure, which automates the deployment and allows to evaluate the performance of Smart City monitoring and management system. We present results of performance tests that show and the creation time of graph database structures in Neo4j and the difference between the performance of the Microsoft SQL Server database and the Neo4j database in a few Smart City use cases. The results show that the use of the graph database to execute queries related to linear infrastructure allows decreasing the response time up to 9 times.

L'applicazione del paradigma smart city in Italia. Luci ed ombre delle sperimentazioni nelle città metropolitane

2018 ◽  
pp. 26-50
Author(s):  
Rosaria Battarra ◽  
Carmela Gargiulo ◽  
Rosa Anna la Rocca ◽  
Laura Russo
Keyword(s):  
Smart City

Smart city and geology

2015 ◽  
Vol 33 ◽  
pp. 35-39
Author(s):  
Donatella De Rita
Keyword(s):  
Smart City

A Study on the IoT LED Streetlight Convergence Technology for Smart City Service

2020 ◽  
Vol 4 (2) ◽  
pp. 135-143
Author(s):  
Jin-Woo Hyun ◽  
◽  
Kyung-Sun Yoo ◽  
Dong-Hoon Hyun ◽  
Chang-kyu Kim
Keyword(s):  
Smart City

SenCity – Evaluating Users’ Experiences of Intelligent Lighting for Well-Being in Smart Cities

2018 ◽  
pp. 60-67
Author(s):  
Henrika Pihlajaniemi ◽  
Anna Luusua ◽  
Eveliina Juntunen
Keyword(s):  
Case Studies ◽  
Smart City ◽  
Smart Cities ◽  
Well Being ◽  
Evaluation Methods ◽  
Data Analyses ◽  
Sense Of Security ◽  
System Data

This paper presents the evaluation of usersХ experiences in three intelligent lighting pilots in Finland. Two of the case studies are related to the use of intelligent lighting in different kinds of traffic areas, having emphasis on aspects of visibility, traffic and movement safety, and sense of security. The last case study presents a more complex view to the experience of intelligent lighting in smart city contexts. The evaluation methods, tailored to each pilot context, include questionnaires, an urban dashboard, in-situ interviews and observations, evaluation probes, and system data analyses. The applicability of the selected and tested methods is discussed reflecting the process and achieved results.

Sign in / Sign up

Export Citation Format

Share Document