Performance of AIS geoinformation extraction using SQL and NoSQL TranStat databases

• Autorzy: Czapliński Wojciech , Gąsowski Wojciech

Identyfikatory

DOI

10.17402/522

• Języki publikacji: EN

Abstrakty

EN

The Automatic Identification System (AIS) device is mandatory for ships that comply with the International Convention for the Safety of Life at Sea (SOLAS). AIS is intended for vessel traffic monitoring to improve shipping safety. In the examined area, the base station received 22 128 345 messages in April 2019. Approximately 80% of these messages included position reports, which were subjected to geospatial analysis. One possible utilization of AIS messages is used in an intelligent maritime transport statistics production system called TranStat in the Gospostrateg project. This specific study compares the speed of executing geospatial queries in a relational PostgreSQL database engine and a non-relational MongoDB database engine. For the purpose of this research, we have defined four AIS datasets, four test polygons of varied number of vertices, and a reference point on a fairway. The tests were used to assess the execution of the queries in a database that returns the number of ships located in a predefined area and the number of ships located at a preset distance from the defined point. It has been determined from the test results that test queries are performed faster and data stored in the database occupy less disk space in MongoDB than in PostgreSQL. Faster geospatial analysis of AIS messages may improve the navigation safety by earlier detection of dangerous situations.

Słowa kluczowe

EN

database; AIS; spatial; geospatial; PostgreSQL; postgis; MongoDB

• Wydawca: Wydawnictwo Naukowe Akademii Morskiej w Szczecinie
• Czasopismo: Zeszyty Naukowe Akademii Morskiej w Szczecinie
• Rocznik: 2022
• Tom: nr 71 (143)
• Strony: 93--101
• Opis fizyczny: Bibliogr. 11 poz., rys., tab.

Twórcy

autor

Czapliński Wojciech

• Maritime University of Szczecin 1-2 Wały Chrobrego St., 70-500 Szczecin, Poland

• https://orcid.org/0000-0002-9503-4742

autor

Gąsowski Wojciech

• Maritime University of Szczecin 1-2 Wały Chrobrego St., 70-500 Szczecin, Poland

• https://orcid.org/0000-0001-6804-8324

Bibliografia

• 1. Baralis, E., Dalla Valle A., Garza, P., Rossi, C. & Scullina, F. (2017) SQL versus NoSQL databases for geospatial applications. Boston, MA, USA, 2017 IEEE International Conference on Big Data.
• 2. Garcia-Molina, H., Ullman, J.D. & Widom, J. (2006) Systemy baz danych. Pełny Wykład. Warszawa: Wydawnictwo Naukowo-Techniczne.
• 3. ITU (2014) Recommendation ITU-R M.1371-5: Technical characteristics for an automatic identification system using time division multiple access in the VHF maritime mobile frequency band. [Online] Available at: https://www.itu.int/ rec/R-REC-M.1371-5-201402-I/en [Accessed: 15th June 2019].
• 4. Matthew, N. & Stones, R. (2005) Beginning Databases with PostgreSQL: From Novice to Professional, Berkley (US): Apress.
• 5. MongoDB Inc. (2019) MongoDB Documentation. [Online] Available at: https://www.mongodb.com [Accessed: June 13, 2019].
• 6. OGC (2019) Open Geospatial Consortium. [Online] Available at: http://www.opengeospatial.org [Accessed: 15th June 2019].
• 7. Pandley, V., Kipf, A., Neuman, T. & Kemper, A. (2018) How good are modern spatial analytics systems? Proceedings of the VLDB Endowment 11, pp. 1661–1673.
• 8. Plugge, E., Membrey, P. & Hawkins, T. (2010) The Definitive Guide to MongoDB: The noSQL Database for Cloud and Desktop Computing. Berlin: Springer-Verlag.
• 9. PostGIS (2019) PostGIS Documentation. [Online] Available at: https://postgis.net [Accessed June 2019].
• 10. Varlamis, I., Tserpes, K. & Sardianos, C. (2018) Detecting search and rescue missions from AIS Data. 2018 IEEE 34th International Conference on Data Engineering Workshops (ICDEW), pp. 60–65.
• 11. Xu, T., Hu, Q., Xiang, Z., Yang, C. & Wang, D. (2016) The comparison study on AIS signal reception rate with directional antenna and omni antenna. TransNav The International Journal on Marine Navigation and Safety of Sea Transportation 10, pp. 205–211.

Uwagi

Opracowanie rekordu ze środków MEiN, umowa nr SONP/SP/546092/2022 w ramach programu „Społeczna odpowiedzialność nauki” - moduł: Popularyzacja nauki i promocja sportu (2022-2023).