Next Article in Journal
Geographic Object-Based Image Analysis for Automated Landslide Detection Using Open Source GIS Software
Previous Article in Journal
WeatherNet: Recognising Weather and Visual Conditions from Street-Level Images Using Deep Residual Learning
Open AccessArticle

Optimization of Shortest-Path Search on RDBMS-Based Graphs

1
Department of Computer Engineering, Hoseo University, Asan 31499, Korea
2
Department of Management Information Systems, Jeju National University, Jeju 63243, Korea
*
Author to whom correspondence should be addressed.
ISPRS Int. J. Geo-Inf. 2019, 8(12), 550; https://doi.org/10.3390/ijgi8120550
Received: 28 August 2019 / Revised: 14 November 2019 / Accepted: 28 November 2019 / Published: 1 December 2019
Calculation of the shortest path between two nodes in a graph is a popular operation used in graph queries in applications such as map information systems, social networking services, and biotechnology. Recent shortest-path search techniques based on graphs stored in relational databases are able to calculate the shortest path efficiently, even in large data using frontier-expand-merge operations. However, previous approaches used a sequential bidirectional search method that causes a bottleneck, thus degrading performance. The repeated use of an aggregate SQL function also degrades performance. This paper proposes a parallel bi-directional search method using multithreading. In addition, an efficient optimization method is proposed that uses B-tree indexing instead of an aggregate SQL function. Various experiments using synthetic and real data reveal that the proposed optimization technique performs more efficiently than conventional methods. As the size of data in practical applications continues to grow, these optimizations will enable the shortest path in a graph to be found quickly and accurately.
Keywords: relational database; graph; shortest path; bi-directional search; thread relational database; graph; shortest path; bi-directional search; thread
MDPI and ACS Style

Seo, K.; Ahn, J.; Im, D.-H. Optimization of Shortest-Path Search on RDBMS-Based Graphs. ISPRS Int. J. Geo-Inf. 2019, 8, 550.

Show more citation formats Show less citations formats
Note that from the first issue of 2016, MDPI journals use article numbers instead of page numbers. See further details here.

Article Access Map by Country/Region

1
Back to TopTop