 |
|
Printer-friendly version
|
|
|
 |
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.
|
||||||||
|
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 
|
|||||||
|
12. Conceptual version of our Airport Management Data Model 
|
13. UML version of our Airport Managemen 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 :-
Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
April 24th. 2017