End2End View for the POC Hotels Platform
Back to the Home Page


10) Revenue Data Mart (a starting-point for discussion)

Conceptual Data Model for Hotels Platform

9) Conceptual Bookings Data Mart


8) Logical Data Model for Reporting Services

Logical Data Model for Hotels Platform

7) Layers in Hotel Platform

Conceptual Data Model for Hotels Platform
 

6) Customers and Guests Data Model

Customers and Guests Data Model

5) DBA Business Platform showing Services

Generic Data Platform

4) Apex Logical Data Model

Generic Data Platform
Data Dictionary
CRUD Operations are required for these Entities :-
1) Transaction Data - Bookings, Check-ins,Check-outs, Guests, events, Payments
2) Master Data - Hotels, Hotel Users, Rooms, Services.
3) Reference Data - Booking Status, Calendar, Country Codes, Event Types, Payment Methods.
TRANSACTIONS and PSEUDO-SQL
Transaction 1) - 'Customer makes a Booking' -
Create - INSERT INTO Hotel_Events (Customer_ID '1', Platform_Code 'Hotel', Service_Code 'Make Booking' Date_Time SYSDATE(Now'))
Transaction 2) - 'Customer checks in' -
Update - UPATE Event
Customer_ID 'Customer_ID',
Platform_Code 'Hotel',
Service_Code 'Check in'
Date_Time SYSDATE(Now)
WHERE Customer_Name = 'John Doe'
Transaction 3) - 'Customer makes Payment' -
Upate - UPDATE Event
Customer_ID 'Customer_ID',
Platform_Code 'Hotel',
Customer_ID,
Service_Code 'Make Payment'
Date_Time SYSDATE(Now')
Transaction 4) - 'Customer checks out' -
Update - UPDATE Event
Customer_ID 'Customer_ID',
Platform_Code 'Hotel',
Service_Code 'Check out'
Date_Time SYSDATE(Now')

3.1) Events and Sub-Events

Generic Data Platform

3.2) Gen Events and Sub-Events


2) Generic Data Platform

Generic Data Platform

1) Canonical Data Model

Canonical Data Model


© Database Answers Ltd. 2017