Database Answers London Heathrow Terminal 5
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Airport Operations   
An Access Database is available on demand.

The Specifications are derived from our consulting assignments in Travel, Transport and Logistics.

We would be glad to have your comments.

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

This is a Top-Level Model which shows only the Subject Areas, each of which is shown in its own Model.

We have also designed a Dimensional Model for Airline Operations, which is very useful for
providing data for Reports and Business Intelligence.

1. Damaged Baggage and Passenger

2. Sleeping Passenger missing his Flight

3. Baggage KPI Data

4. Passenger KPI Data

5. Semantic Layer
The Semantic Layer provides a 'User-Friendly' interface to a Database by translating Database terms into business terms.
Here is a simple example, where we can see that the term 'Party' is translated into 'Passenger' in an Airport environment.

Approved by
(Data Steward)
Approved Date Database Business
Joe Bloggs April 1st. 2017 PartyPassenger

6. POC Baggage Data Mart
This Data Mart holds only the data for our POC (Proof-of-Concept)

7. POC Passenger Data Mart

8. POC Airport Management Platform (Layers)

9. Data Mart (Dimensional) Model
(on this page)

10. Proof-of-Concept Canonical Data Model
Phase 1 tables are in orange

11. Airport Operations Logical Data Model

Print version of the Top-Level Data Model for Airline Operations

12. Conceptual version of our Airport Management Data Model
Canonical Data Model

13. UML version of our Airport Managemen Data Model

ERwin Canonical Data Model
14. Top-level ERD Data Model

15. Operational Data Store

16. Real-Time Data Feed


We have also created Data Models for these Subject Areas :-
  • Aircraft Maintenance
  • Airline Operations
  • Airline Reservations
  • Airport Management
  • Passengers Online Bookings

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    April 24th. 2017

  • © Database Answers Ltd. 2017
    About Us Contact Us