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

作者: Michał Gorawski , Krzysztof Grochla

DOI: 10.1007/S42979-019-0031-Y

关键词:

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

参考文章(10)
Jean-Christophe Foltête, Xavier Girardet, Céline Clauzel, A methodological framework for the use of landscape graphs in land-use planning Landscape and Urban Planning. ,vol. 124, pp. 140- 150 ,(2014) , 10.1016/J.LANDURBPLAN.2013.12.012
Manuel Herrera, Edo Abraham, Ivan Stoianov, A Graph-Theoretic Framework for Assessing the Resilience of Sectorised Water Distribution Networks Water Resources Management. ,vol. 30, pp. 1685- 1699 ,(2016) , 10.1007/S11269-016-1245-6
Marcin Gorawski, Mirosław Skrzewski, Michał Gorawski, Anna Gorawska, Neural Networks in Petrol Station Objects Calibration international conference on algorithms and architectures for parallel processing. pp. 714- 723 ,(2015) , 10.1007/978-3-319-27161-3_65
Pavel Praks, Vytis Kopustinskas, Marcelo Masera, Monte-Carlo-based reliability and vulnerability assessment of a natural gas transmission system due to random network component failures Sustainable and Resilient Infrastructure. ,vol. 2, pp. 97- 107 ,(2017) , 10.1080/23789689.2017.1294881
M. Gorawski, A. Gorawska, K. Pasterak, The TUBE algorithm: Discovering trends in time series for the early detection of fuel leaks from underground storage tanks Expert Systems With Applications. ,vol. 90, pp. 356- 373 ,(2017) , 10.1016/J.ESWA.2017.08.016
Maarten Blommaert, R. Salenbien, Martine Baelmans, AN ADJOINT APPROACH TO THERMAL NETWORK TOPOLOGY OPTIMIZATION International Heat Transfer Conference 16. ,(2018) , 10.1615/IHTC16.CMS.024074
Mario Weber, Ivana Podnar Žarko, A Regulatory View on Smart City Services Sensors. ,vol. 19, pp. 415- ,(2019) , 10.3390/S19020415
Justus von Rhein, Gregor P. Henze, Nicholas Long, Yangyang Fu, Development of a topology analysis tool for fifth-generation district heating and cooling networks Energy Conversion and Management. ,vol. 196, pp. 705- 716 ,(2019) , 10.1016/J.ENCONMAN.2019.05.066
Michal Gorawski, Krzysztof Grochla, Graph Representation of Linear Infrastructure in Smart City IoT Systems international conference on ultra modern telecommunications. pp. 1- 4 ,(2019) , 10.1109/ICUMT48472.2019.8970674