Proof-of-Concept for Airport Operations
Back to the Home Page
Click here to see the Slide-Show for this Scenario.


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



 


© Database Answers Ltd. 2017