Container Shipping Model


Printer-friendly version

Data Model for Container Shipping

An Access Database is available on demand.

A Glossary of Business Terms and the Business Rules have been drafted to establish the conditions that a Database must meet.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

There is also a design for a Data Warehouse and a Data Mart , which is very useful for providng data for Reports and Business Intelligence.

A Lifecycle of Containers and Customers is used to create Subject Area Data Models and here is a Subject Area for Containers.

You can download a Discussion Paper on the role of an Enterprise Data Model and the Data Warehouse in the overall scope of Data Management.

If you have any comments on the Data Model, we would be pleased to hear from you.
Teradata has published a Model covering Transportation and Logistics and a Roadmap for a Data Warehouse

Here's a useful link to a Transport Feed Specification.

ERD Container Shipments Data Model

Canonical Data Model (CDM) - this is very useful for loading data into a Data Warehouse. so that it presents a 'Single Version of the Truth'.

TBP Inheritance Data Model

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
September 3rd. 2011