Hostname: page-component-7c8c6479df-xxrs7 Total loading time: 0 Render date: 2024-03-29T06:15:36.368Z Has data issue: false hasContentIssue false

MSARI: A Database for Large Volume Storage and Utilisation of Maritime Data

Published online by Cambridge University Press:  31 August 2016

Anthony W. Isenor*
Affiliation:
(Defence Research and Development Canada, Dartmouth, Nova Scotia, Canada)
Marie-Odette St-Hilaire
Affiliation:
(OODA Technologies Inc., Montreal, Quebec, Canada)
Sean Webb
Affiliation:
(Defence Research and Development Canada, Dartmouth, Nova Scotia, Canada)
Michel Mayrand
Affiliation:
(OODA Technologies Inc., Montreal, Quebec, Canada)

Abstract

The volume of maritime vessel data, such as available from the Automatic Identification System (AIS), places considerable burden on systems designed and developed to manage data pertaining to maritime traffic. A properly designed and implemented data management infrastructure can provide benefits to the maritime domain awareness research community by supporting data volumes, diverse user needs, and product management. Such an infrastructure has been constructed on a modest budget by utilising open-source technologies. This paper describes the Maritime Situational Awareness Research Infrastructure (MSARI), and the design of the underlying database to meet data volume and user analysis needs. The resulting infrastructure currently handles input rates of approximately two billion vessel reports per month. This work is of potential benefit to those in the navigational community interested in the long-term storage and usage of global vessel data such as that available from AIS.

Type
Research Article
Copyright
Copyright © The Royal Institute of Navigation 2016 

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

References

REFERENCES

Claus, S., Hauwere, N.D., Vanhoorne, B., Dias, F.S., Hernandez, F., Mees, J. and Institute), F. M. (2015). Marine Regions. http://www.marineregions.org, Last Accessed: 15-Oct-2015.Google Scholar
Creech, J.A. and Ryan, J.F. (2003). AIS: The Cornerstone of National Security? Journal of Navigation, 56, 3144.CrossRefGoogle Scholar
Digital Equipment Corporation (ed) (1992). Information Technology - Database Language SQL. International Organization for Standardization.Google Scholar
Dinua, V. and Nadkarnia, P. (2007). Guidelines for the effective use of entity–attribute–value modeling for biomedical databases. International Journal of Medical Informatics, 76, 769-779.CrossRefGoogle Scholar
Eiden, G. and Goldsmith, R. (2010). Performance of AIS sensors in space - PASTA-MARE project final report executive summary. pp. 12.Google Scholar
European Commission (2010). Maritime traffice density - results of PASTA MARE project. https://webgate.ec.europa.eu/maritimeforum/en/node/1603, Last Accessed: 20 January 2015.Google Scholar
exactEarth (2015). exactEarth AIS Vessel Tracking and Maritime Ship Monitoring. http://www.exactearth.com/, Last Accessed: 05 Sept 2015.Google Scholar
Glynn, A. (2010). Safe Seas: New system improves maritime security. In Agora, pp. 6667. Agora.Google Scholar
Hadzagic, M., St-Hilaire, M.-O. and Webb, S. (2013). Maritime Traffic Data Mining Using R. Proceedings of the 2013 16th International Conference on Information Fusion (FUSION), Istanbul, Turkey.Google Scholar
Intergovernmental Oceanographic Commission of UNESCO (2002). The WMO Voluntary Observing Ship Programme: An Enduring Partnership. World Meteorological Organization.Google Scholar
Isenor, A.W., Cross, R., Webb, S. and Lapinski, A.-L.S. (2013). Utilizing wide area Maritime Domain Awareness (MDA) data to cue a remote surveillance system. Proceedings of the SPIE Security+Defence 2013, Dresden, Germany.Google Scholar
Isenor, A.W. and Spears, T.W. (2014). Combining the Arc Marine Framework with Geographic Metadata to Support Ocean Acoustic Modeling. Transactions in GIS, 18, 183200.CrossRefGoogle Scholar
Kearney, G. and Millar, J. (2004). Canadian Security and Defence: The Maritime Dimension. Canadian Military Journal, Autumn 2004, 6369.Google Scholar
Lai, E. (2008). Size matters: Yahoo claims 2-petabyte database is world's biggest, busiest. http://www.computerworld.com/article/2535825/business-intelligence/size-matters--yahoo-claims-2-petabyte-database-is-world-s-biggest--busiest.html, Last Accessed: 17-Jan-2015.Google Scholar
Lapinski, A.-L.S. and Isenor, A.W. (2011). Estimating Reception Coverage Characteristics of AIS. Journal of Navigation, 64, 609623.Google Scholar
Ou, Z. and Zhu, J. (2008). AIS Database Powered by GIS Technology for Maritime Safety and Security. The Journal of Navigation, 61, 655665.Google Scholar
Pan, Z. and Deng, S. (2009). Vessel Real-Time Monitoring System Based on AIS Temporal Database. Proceedings of the International Conference on Infomration Management, Innovation Management and Industrial Engineering.CrossRefGoogle Scholar
Pokorny, J. (2013). NoSQL databases: a step to database scalability in web environment. International Journal of Web Information Systems, 9, 6982.Google Scholar
PostGIS (2009). PostGIS: Home. http://postgis.refractions.net/, Last Accessed: 15 July 2016.Google Scholar
PostgreSQL (2011). PostgreSQL: The worlds most advanced open source database. http://www.postgresql.org/, Last Accessed: 15 July 2016.Google Scholar
QGIS (2014). Quantum GIS Geographic Information System, Open Source Geospatial Foundation Project. http://www2.qgis.org/en/site/, Last Accessed: 28 Feb 2015.Google Scholar
Simsion, G. (2007). Data Modeling Theory and Practice. Technics Publications, LLC.Google Scholar
Transport Canada (2012). Maritime Domain Awareness. https://www.tc.gc.ca/eng/marinesecurity/initiatives-235.htm, Last Accessed: 17-Jan-2015.Google Scholar