Metoda importu danych eksploatacyjnych urządzeń sterowania ruchem kolejowym do bazy danych

Method of importing operational data of railway traffic control devices into the database

  • Waldemar Nowakowski Uniwersytet Technologiczno-Humanistyczny w Radomiu, Wydział Transportu i Elektrotechniki
  • Piotr Bojarczak Uniwersytet Technologiczno-Humanistyczny w Radomiu, Wydział Transportu i Elektrotechniki
  • Zbigniew Łukasik Uniwersytet Technologiczno-Humanistyczny w Radomiu, Wydział Transportu i Elektrotechniki
Keywords: urządzenia sterowania ruchem kolejowym, diagnostyka, baza MS SQL

Abstract

Railway control devices are responsible for the safe and efficient operation of railway traffic. Despite the continuous development of these devices, like other technical solutions, they are being damaged. However, since railway control devices are safety-related, they are not only required to be reliable, but also to be free from unacceptable risks. The very large number of control devices, the variety of their types, the variety of technical solutions, as well as the specific failure rate make it very difficult to ensure the efficiency of these equipment. Therefore, their operation must be supported by technical diagnostics. Information obtained as a result of technical diagnostics about changes in the technical condition of devices is stored in specific data sets. However, in the case of individual railway lines plants of PKP PLK S.A. these are most often Excel spreadsheets of Microsoft Office. The authors of the article proposed to transfer these data to the MS SQL relational database with the use of proprietary software developed for this purpose.

References

1. Bergquist B., Soederholm P.: Data Analysis for Condition-Based Railway Infrastructure Maintenance, Quality and Reliability Engineering International, Volume 31, Issue 5, pp. 773-781, 2015.
2. Będkowski L. Dąbrowski T.: Podstawy eksploatacji. Część 1. Podstawy diagnostyki technicznej, WAT, 2000.
3. Cao Y., Li P., Zhang Y.: Parallel processing algorithm for railway signal fault diagnosis data based on cloud computing, Future Generation Computer Systems - The International Journal of eScience, Volume 88, pp. 279-283,2018.
4. Flammini F. Railway Safety, Reliability, and Security: Technologies and Systems Engineering. IGI Global, 2012.
5. Ie-7 (E-14), Instrukcja diagnostyki technicznej i kontroli okresowych urządzeń sterowania ruchem kolejowym, PKP PLK S.A. 2018.
6. Lewiński, A., Perzyński, T.: The reliability and safety of railway control systems based on new information technologies. Mikulski, J. (ed.), TST 2010, Communications in Computer and Information Science, Volume 104, pp. 427-433, 2010.
7. Lovetei I.F., Szabo G.: Safety Modeling of Centralized Railway Traffic Control, Proceedings of 19th International Conference Transport Means 2015, pp. 294-297, 2015.
8. Łukasik Z., Nowakowski W.: Sieciowe narzędzia diagnostyczne systemów sterowania ruchem kolejowym, Technika Transportu Szynowego (TTS) 12/2015, str. 2715-2718, 2015.
9. Łukasik Z., Nowakowski W., Ciszewski T.: Bezpieczeństwo danych w diagnostyce systemów sterowania ruchem kolejowym, Autobusy: technika, eksploatacja, systemy transportowe, R.17 nr 6, str. 264-267, 2016.
10. Łukasik Z., Nowakowski W., Ciszewski T.: Ujednolicenie struktur danych stosowanych w diagnostyce systemów sterowania ruchem kolejowym, Autobusy: technika, eksploatacja, systemy transportowe, R.17 nr 6, str. 995-998, 2016.
11. Łukasik Z., Nowakowski W., Ciszewski T., Freimane J.: A fault diagnostic methodology for railway automatics systems, ICTE in Transportation and Logistics 2018 (ICTE 2018), Procedia Computer Science, Volume 149, pp. 159-166, 2019.
12. Nowakowski W.: Diagnostyka systemów automatyki kolejowej jako metoda poprawy bezpieczeństwa. Wydawnictwo Uniwersytetu Technologiczno-Humanistycznego im. K. Pułaskiego w Radomiu. Seria Monografie, Nr 218. Radom 2018.
13. Nowakowski W., Bojarczak P., Łukasik Z.: A concept of diagnosis of railway automation systems. Proceedings of 22nd International Scientific Conference “Transport Means 2018”, Part II, pp. 920-925, 2018.
14. Nowakowski W., Bojarczak P., Łukasik Z.: A Diagnostic Method for Axle Counting Systems Based on the SNMP Protocol. In: Ko-váčiková T., Buzna Ľ., Pourhashem G., Lugano G., Cornet Y., Lugano N. (Eds.), Intelligent Transport Systems – From Re-search and Development to the Market Uptake (INTSYS 2017), Lecture Notes of the Institute for Computer Sciences, Social Informatics and Telecommunications Engineering, Vol. 222, pp. 51-60, Springer, Cham, 2018.
15. Nowakowski W., Ciszewski T., Bukalski W., Łukasik Ł.: Symulator uszkodzeń urządzeń sterowania ruchem kolejowym, Autobusy: technika, eksploatacja, systemy transportowe, 12/2018, str. 575-578, ISSN 1509-5878, DOI 10.24136/atest.2018.455, 2018.
16. Nowakowski W., Ciszewski T., Łukasik Z.: The Concept of Rail-way Traffic Control Systems Remote Diagnostic. Communications in Computer and Information Science, Smart Solutions in Today's Transport, Vol. 715, pp. 471-481, Mikulski J. (Eds.), Springer-Verlag, 2017.
17. Nowakowski W., Łukasik Z., Łukomski K.: Diagnostyka urządzeń sterowania ruchem kolejowym. Autobusy: technika, eksploatacja, systemy transportowe, 6/2018, str. 632-635, 2018.
18. Mikulski J.: Evaluation of Railway Stations Reliability. Mikulski, J. (ed.), TST 2013, Communications in Computer and Information Science, Volume 395, pp. 105-114, 2013.
19. Perpinya X. (ed.): Reliability and Safety in Railway. InTech, 2012.
20. Tang L.: Reliability assessments of railway signaling systems: A comparison and evaluation of approaches. Norwegian University of Science and Technology, 2015.
21. Wu G: Design on Fault Diagnosis Expert System for Railway Signal Equipment, Proceedings of the 2018 6th International Conference on Machinery, Materials and Computing Technology (ICMMCT 2018), AER-Advances in Engineering Research, Vol-ume 152, pp. 36-41, 2018.
22. Żółtowski B.: Podstawy diagnostyki maszyn, Wydawnictwo Akademii Techniczno-Rolniczej w Bydgoszczy, Bydgoszcz 1996.
23. http://www.delphi-jedi.org
24. https://www.devart.com/unidac
25. https://www.lmdinnovative.com
Published
2019-07-10
Section
Eksploatacja i Testy/Exploitation and Tests