Issue |
E3S Web Conf.
Volume 164, 2020
Topical Problems of Green Architecture, Civil and Environmental Engineering 2019 (TPACEE 2019)
|
|
---|---|---|
Article Number | 10016 | |
Number of page(s) | 8 | |
Section | Environmental Planning and Management | |
DOI | https://doi.org/10.1051/e3sconf/202016410016 | |
Published online | 05 May 2020 |
Programmatic implementation of the Dijkstra algorithm in the Transact-SQL language using relational algebra
Don state technical university, chairs Computing systems and information security, 1, Gagarin square, 344000, Rostov-on-Don, Russia
* Corresponding author: mishanya005@ya.ru
The article is devoted to the topical issue of data processing in the database management systems. It presents a solution to the problem of finding paths in a graph using Dijkstra’s algorithm, set as a sequence of relational operations and functions of the Transact-SQL language. The efficiency of the known information system architectures and the impact of various ways of distributing functions between system components are reviewed. The article describes features of the relational algebra and the Transact-SQL operations, and provides a brief description of Dijkstra’s algorithm. For its programmatic implementation, several stages are defined, for each of which a formal description of the relational operations performed on it is given. The outputs of these operations are shown using the example of the database tables, and the algorithm to find the final path is given. The issues of the proposed method’s productivity and security of programmatic implementation of the path search in a graph are discussed separately.
© The Authors, published by EDP Sciences 2020
This is an Open Access article distributed under the terms of the Creative Commons Attribution License 4.0, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Current usage metrics show cumulative count of Article Views (full-text article views including HTML views, PDF and ePub downloads, according to the available data) and Abstracts Views on Vision4Press platform.
Data correspond to usage on the plateform after 2015. The current usage metrics is available 48-96 hours after online publication and is updated daily on week days.
Initial download of the metrics may take a while.