Database Answers Container Shipping
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
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 a Data Mart (a Data Warehouse), 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'.
  • Canonical Data Model - ERD style
  • Containers for Ships
  • Containers for TBP
  • Subject Area for Containers from Draft document
  • ERD Version 3
  • TBP Inheritance Data Model

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


  • © DataBase Answers Ltd. 2011
    Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map