...

11. Voyage Businesses

by user

on
Category:

travel

37

views

Report

Comments

Transcript

11. Voyage Businesses
Adv. DBMS & DW
Chapter 11: Voyage Businesses
Hachim Haddouti
Hachim Haddouti, adv. DBMS & DW CSC5301, Ch11
Voyage Businesses: Needs
• The airline marketing department wants:
–
–
–
–
–
–
–
–
–
–
–
to see what flights the frequent flyers take,
which planes they fly,
which seats they sit in,
what the base fare they pay is,
how often they upgrade their tickets,
how they pay for their upgrades,
how they redeem their frequent flyer miles,
whether they respond to special fare promotions,
how many overnight destinations they stay in,
how long the overnight stays are,
what other airlines are used on the same trips, and what proportion
of these flyers have Platinum, Gold, or Aluminum status
– …
Hachim Haddouti, adv. DBMS & DW CSC5301, Ch11
Basic Dimensions
• Extracted Details: customer (frequent flyer
#), leg origin, leg destination, flight, fare
class, date flown, date purchased, sales
channel, status, ticket #, segment #.
• Dimensions:
• Customer
• airport (x4)
• flight(dep time, used aircraft,..)
• fare class(type of seat, promoted, ..)
• date(date flown,date purchased) (x2)
• sales channel(travel agency/online purchase)
• status(customer
status,
frequent
flyer
classification..).
see(P 156)
Hachim Haddouti, adv. DBMS & DW CSC5301, Ch11
Voyage Businesses cont.
• The most meaningful grain of the database is
the individual leg of the journey (specific
information such as airplane, fare class,
flight origin, flight destination).
• Flight dimension is slowly changing.
Hachim Haddouti, adv. DBMS & DW CSC5301, Ch11
Travel Credit card
• travel-oriented credit card: tracks airline flights, hotel
stays, and car rentals.
• Firstly starting with Frequent flyer incorporated in a
value chain -- travel credit card data. Add hotel and car
rental. See p. 157
• common dim: customer, date, ticket #, and flight
segment
• Drill cross on common dimensions
Hachim Haddouti, adv. DBMS & DW CSC5301, Ch11
Travel Credit card cont.
•
Grain for hotel is the entire stay
and for rental car is entire car rental
period.
• ticket #, and flight segment in hotel
and car rental schemas makes sence only
if these are part of a trip, otherwise
are NULL values.
• PD: ”The primary characteristic of a
voyage schema is the need to place
origin and destination dimensions in
the fact table.“
Hachim Haddouti, adv. DBMS & DW CSC5301, Ch11
Fly UP