The Scheldt Radar Chain (SRC) consists out of traffic centers and operators under the supervision of the Common Nautical Authority (CNA). CNA ensures the safety and guidance for maritime traffic between the North Sea and Antwerp. The CNA is a co-operation between the Agency for Maritime Services and Coastal Affairs of the Flemish Government and the Ministry of Infrastructure en Environment, Department of Public Works Zeeland of the Dutch Government.
SRC mainly uses 2 operational systems for the coordination of shipping traffic.
The Information Processing System (IPS) supports shipping in the Scheldt area by recording data on future, current and past vessels voyages.
RADAR and Automated Identification System (AIS) technology paint a graphic picture of shipping traffic in the Scheldt area.
IPS ship and voyage data are linked to the radar targets. This results in a complete picture of the traffic situation on the River Scheldt.
The figure below gives a conceptual overview of the BI-SRC solution
Business Intelligence solution realized for the SRC uses 2 operational systems as data sources:
- IPS voyage data is used for analyzing voyage and ship related information.
- AIS data is being used for geographical presentation and for AIS network load measurement.
AIS and IPS data is added to the data warehouse on a daily basis by making use of SQL Server Integration Services
- Approximately 8 million AIS messages a day are read from binary files and converted into table data in the data warehouse.
- On average 400 IPS voyages and their related data are being added to the data warehouse from an Oracle data source.
For the Reporting and Analytical component cubes, created in SQL Server Analysis Services, have been built on top op the data warehouse. These cubes are available through predefined reports, created in SQL Server Reporting Services.
A custom report item has been developed allowing geographical presentation of data warehouse data in SQL Server Reporting Services reports, projected on an Inland ECDIS map. This custom report item can show different types geographical data:
- AIS tracks showing actual maritime vessel traffic density for a given period of time.
- IPS incidents shown by region and provide with bar charts indicating the number of incidents.
The reports created for BI-SRC are made accessible on the internet through the secured part of the VTS-Scheldt website. Users can request a user account. After logging in they are able to view and subscribe to reports on the VTS-Scheldt website. The subscription and login information is automatically being synchronized between the website and BI systems.
Regular tabular reports are also important as they can provide detail voyage and vessel information. For key users a Report Model has been designed, allowing them to build their custom reports from their own computer by using the Report Builder tool.