Contents

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
• Logical Data Model Dimensions 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
• Dimension 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 Inter-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_FACT Mapping
  • PKG_DWA_DLY_CALL_CNTR_PRFMNC Mapping
  • PKG_DWA_DLY_FLT_DETLS Mapping
  • PKG_DWA_DLY_LYLTY_ACCT_BKG Mapping
  • PKG_DWA_DLY_LYLTY_ACCT Mapping
  • PKG_DWD_BKG_FACT Mapping
  • PKG_DWD_CALL_CNTR_PRFMNC Mapping
  • PKG_DWD_CUST_SRVY Mapping
  • PKG_DWD_FLT_DETLS_FACT Mapping
  • PKG_DWD_LYLTY_ACCT_BAL_HIST Mapping
  • PKG_DWD_LYLTY_ACCT_LVL_HIST Mapping
  • PKG_DWD_LYLTY_PRG Mapping
  • PKG_DWD_PNR Mapping
  • PKG_DWD_TKT Mapping
  • PKG_DWM_ACCT Mapping
  • PKG_DWM_ACFT_VER Mapping
  • PKG_DWM_AIP Procedure
  • PKG_DWM_BKG_CLS_TYP Procedure
  • PKG_DWM_BKG_OFF Mapping
  • PKG_DWM_BKG_PAX Mapping
  • PKG_DWM_BKG_TST Mapping
  • PKG_DWM_CARR Mapping
  • PKG_DWM_CORP_CUST Mapping
  • PKG_DWM_FLT Mapping
  • PKG_DWM_FRQTFLR Mapping
  • PKG_DWM_INTRATN_RSLT Mapping
  • PKG_DWM_INTRATN_RSN Mapping
  • PKG_DWM_LEG Mapping
  • PKG_DWM_LYLTY_LVL Mapping
  • PKG_DWM_PDI_CHNL Mapping
  • PKG_DWM_SALES_CHNL Mapping
  • PKG_DWM_SEG Mapping
  • PKG_DWM_SEG_PAIR Mapping
  • PKG_DWM_SVC Mapping
  • PKG_DWM_TRAF_CATG 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
• About Data Mining in Oracle Airlines Data Model
• 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 Flop 10
  • Sales - Net Revenue Flown Channel Top 10
  • Sales - Net Revenue Flown Flop 10 Countries
  • 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
• 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

Part III 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

Index