Go to main content
1/23
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I Logical and Physical Data Model
1
Introducing
Oracle Airlines Data Model
What is
Oracle Airlines Data Model
?
What Are the Benefits of Using
Oracle Airlines Data Model
?
What Are the Components of
Oracle Airlines Data Model
?
Oracle Products That Make Up
Oracle Airlines Data Model
2
Logical Data Model
Reference Entities
Lookup Entities
Base Entities
Derived Entities
Aggregate Entities
Logical Data Model Entity Dictionary
3
Oracle Airlines Data Model
Physical Data Model
Introduction to
Oracle Airlines Data Model
Physical Data Model
Reference Tables
Base Tables
Derived Tables
Aggregate Tables
Lookup Tables
Mining Tables
Database Sequences
Metadata Tables
Oracle Airlines Data Model
OLAP Cube MV, Cube View
4
Oracle Airlines Data Model
Logical to Physical Mapping
Logical to Physical Mappings for
Oracle Airlines Data Model
5
Oracle Airlines Data Model
Partitioning
Partitioning Strategy for
Oracle Airlines Data Model
Part II Intra-ETL, OLAP, Data Mining, and Utility Scripts
6
Oracle Airlines Data Model
Intra-ETL
Introduction to
Oracle Airlines Data Model
Intra-ETL
Value Lookup Models for PL/SQL Procedures
Intra-ETL PL/SQL Mapping Source and Target Tables
PKG_DWA_CUST_SRVY Mapping
PKG_DWA_DLY_BKG Mapping
PKG_DWA_DLY_CALL_CNTR_PRFMNC Mapping
PKG_DWA_DLY_FLT_DTLS Mapping
PKG_DWA_DLY_LYALTY_ACCT_BKG Mapping
PKG_DWA_DLY_LYALTY_ACCT Mapping
PKG_DWD_BKG_FCT Mapping
PKG_DWD_CALL_CNTR_PRFMNC Mapping
PKG_DWD_CHKIN Mapping
PKG_DWD_CUST_SRVY Mapping
PKG_DWD_FLT_DTLS Mapping
PKG_DWD_FLT_OPRN Mapping
PKG_DWD_LYLTY_ACCT_BAL_HIST Mapping
PKG_DWD_LYLTY_ACCT_LVL_HIST Mapping
PKG_DWD_NON_RUTNE_DRVD Mapping
PKG_DWD_RVN_CST Mapping
PKG_DWD_TCKT Mapping
Intra-ETL Process Flows
7
Oracle Airlines Data Model
OLAP Model Dimensions
Oracle Airlines Data Model
Introduction to OLAP Dimensions
Oracle Airlines Data Model
OLAP Dimensions
Booking Class: BKCLS
Booking Office: BKOFC
Geography: GEO
Interaction Reason: IRSN
Loyalty Level: LOYLV
Operating Flight: OPFLT
Operating Segment: OPSMT
Route: ROUTE
Service: SRVC
Time: TIME
8
Oracle Airlines Data Model
OLAP Model Cubes
Oracle Airlines Data Model
OLAP Cubes Overview
Booking Segment Departure Fact Cube: BSDF
Booking Segment Departure Fact Forecast Cube: BSDF_F
Call Center Performance Fact Cube: CCPF
Customer Survey Daily Fact Cube: CSDF
Flight Detail Daily Fact Cube: FDDF
Loyalty Account Fact Cube: LYAF
Loyalty Booking Fact Cube: LYBF
9
Oracle Airlines Data Model
Data Mining Models
About Data Mining in
Oracle Airlines Data Model
Understanding the
Oracle Airlines Data Model
Data Mining Architecture
Using the Mining Model Refresh Procedure
Oracle Airlines Data Model
Mining Result Tables
Model 1: Customer Segmentation Analysis
Customer Segmentation Source
Customer Segmentation Output
Customer Segmentation Algorithm
Model 2: Customer Loyalty Analysis
Target Variables
Customer Loyalty Source
Customer Loyalty Output
Customer Loyalty Algorithms
Model 3: Customer Life Time Value Analysis
Target Variables
Customer Life Time Value Source
Customer Life Time Value Output
Customer Life Time Value Algorithm
Model 4: Frequent Flyer Passenger Prediction
Target Variables
Non-Frequent Flyer Passenger Source
Non-Frequent Flyer Passenger Output
Non-Frequent Flyer Passenger Algorithm
10
Oracle Airlines Data Model
Utility Scripts
Calendar Population
Calendar Population Scripts
How to Populate Calendar Data
11
Oracle Airlines Data Model
Sample Reports
Agent Performance Analysis
Agent Performance Analysis Confirmed
Agent Performance Analysis PCT CANCEL
Agent Performance Analysis Total Revenue
Booking Analysis
Agent Booking Analysis
Booking Segment Analysis
Daily Booking Analysis
Flight booking Analysis
Group Booking Analysis
Monthly Booking Analysis
Quarterly Booking Analysis
Service Class Analysis
Weekly Booking Analysis
Channel Performance Analysis
Agent Booking Analysis
Sales Channel Performance Analysis
Revenue Analysis
Agent Revenue Analysis in USD
Booking Class Revenue Analysis in USD
Channel Revenue Analysis in USD
Flight Revenue Analysis in USD
Flown Revenue Per Sales Region
Flown Revenue per Sales Region and Service Class
Sales: Net Revenue Flown Channel Bottom 10
Sales - Net Revenue Flown Channel Top 10
Sales - Net Revenue Flown Bottom 10 Countries (Flop 10)
Sales - Net Revenue Flown Top 10 Countries
Sales - Net Revenue Per Agency - Top 10 Revenue
Segment Revenue Analysis in USD
Service Class Revenue Analysis in USD
Route Analysis Reports
Route Ranking on Bookings
ASK Analysis
Route Passenger Count Forecast
Call Center Performance Analysis
Call Center Performance
Call Center Sales Performance
Customer Loyalty Analysis
Airline Contribution
Earn / Redemption
Membership Development
Frequent Flyer Customer Mining
Non-Frequent Flyer Customer Mining
Customer Interaction Analysis
Customer Satisfaction Survey Summary
Customer Satisfaction Onboard Survey Detail
Customer Satisfaction Ground Survey Detail
Customer Relations Customer Comments
Flight Operations Reports
In Flight Aircraft Details
Historical Resolution Time
Outstanding Defects
Flight Tracking
Maintenance and Operations Control Reports
Passenger Load
Number of Defects
Average MEL Clearance Time
Non Routine Resolution Analysis
Non Routine Analysis
Slot Discrepancy
Defect Aging
Special Location Gate Reports
Delay Hot Spots
Departures and Delays
Ground Time Control
Special Location Passenger Reports
Passenger Connections
Passenger Trip Delay
TAT Analysis Reports
Aircraft Dispatch Reliability
Appendices
A
Control Tables
Intra-ETL Load Parameters Control Table
Intra-ETL OLAP Mapping Control Table
Intra-ETL Monitoring Process Control Tables
Intra-ETL Parameter Management Tables
Intra-ETL Error Management Table
B
Database Users and Privileges
Oracle Airlines Data Model
Database Users and Privileges
Index
Scripting on this page enhances content navigation, but does not change the content in any way.