M&O AIS Database Solution

Working together

for a safer world

M&O AIS Solution - Proposal

James Norris

Lloyd's Register

19.02.2020

Requirement

M&O, have recently acquired global historical vessel AIS data from Spire and require a service that includes:

Current Access requirements:

Proposed Infrastructure Design

5000 gzipped csv files.

Annually or when new data available

Remove spurious points e.g. on land

Partitioned tables on Postgresql database.

TImescaleDB (fast performance very expensive)

Timescale DB (optional)

Advanced

User

Standard User

API commands calling geospatial functions to extract data by area, attribute and time frame, downsampled based on requirement.

Access through existing apps e.g. VesMet but potentially create a stripped down standalone tool for data extraction.

With AWS, we can build a scalable environment which incorporate the ability to perform big data analytics machine learning behind the API.

RoadMap

Currently in the process of switching to AWS.

Environment has been set up and tested.

Transition will commence following approval.

Up and running within the next 2 months.

AIS data warehouse with API calls within next 3 months.

Maintenance & Costs

Maintenance

- Annual or semi-annual data processing.

- Data backup and restore.

- Monthly server checks/maintenance.

- Prompt Response Times and SLA.

- Additional ad-hoc hours for tweaks/improvements

Costs

- AWS RDS - Price varies based on monthly usage/amount stored.

- Initial set up - Up to 4 weeks depending on use cases.

- Hourly rate for monthly maintenance, ad-hoc requests.

Working together

for a safer world

James Norris

Lloyd's Register Survey & GeoEngineering

+44 (0)1225 485800

James.Norris@lr.org