Go to main content
4/23
List of Tables
1-1 Oracle Development Tools Used with
Oracle Airlines Data Model
2-1 A to G Entity Descriptions
2-2 H to Q Entity Descriptions
2-3 R to Z Entity Descriptions
3-1 Table Name Prefix and Suffix Conventions
3-2 Database Sequences List
3-3 Metadata Tables
3-4 OLAP Cube Materialized Views in
oadm_sys
Schema
3-5 OLAP Cube Views in
oadm_sys
schema
4-1 Entity Mapping Table: Logical to Physical Mapping
5-1 Physical Data Model Partitioning
6-1 Value Lookup Values for Intra-ETL Mapping
6-2 PKG_DWA_CUST_SRVY ETL Source to Target Mapping
6-3 PKG_DWA_DLY_BKG_ ETL Source to Target Mapping
6-4 PKG_DWA_DLY_CALL_CNTR_PRFMNC ETL Source to Target Mapping
6-5 PKG_DWA_DLY_FLT_DTLS ETL Source to Target Mapping
6-6 PKG_DWA_DLY_LYALTY_ACCT_BKG ETL Source to Target Mapping
6-7 PKG_DWA_DLY_LYALTY_ACCT ETL Source to Target Mapping
6-8 PKG_DWD_ BKG_FCT ETL Source to Target Mapping
6-9 PKG_DWD_CALL_CNTR_PRFMNC ETL Source to Target Mapping
6-10 PKG_DWD_CHKIN ETL Source to Target Mapping
6-11 PKG_DWD_CUST_SRVY ETL Source to Target Mapping
6-12 PKG_DWD_FLT_DTLS ETL Source to Target Mapping
6-13 PKG_DWD_FLT_OPRN Source to Target Mapping
6-14 PKG_DWD_LYLTY_ACCT_BAL_HIST ETL Source to Target Mapping
6-15 PKG_DWD_LYLTY_ACCT_LVL_HIST ETL Source to Target Mapping
6-16 PKG_DWD_NON_RUTNE_DRVD Source to Target Mapping
6-17 PKG_ DWD_RVN_CST_DRVD ETL Source to Target Mapping
6-18 PKG_DWD_TCKT ETL Source to Target Mapping
7-1 Booking Class (BKCLS) Levels and Hierarchies
7-2 Booking Class Long Description Attribute Mapping
7-3 Booking Class Short Description Attribute Mapping
7-4 Booking Office (HBKOFC) Levels and Hierarchies
7-5 Booking Office HBKOFC Long Description Attribute Mapping
7-6 Booking Office HBKOFC Short Description Attribute Mapping
7-7 Booking Office HBKOFC Agent Status Attribute Mapping
7-8 Booking Office HBKOFC Agent Name Attribute Mapping
7-9 Booking Office HBKOFC Agent IATA Code Attribute Mapping
7-10 Booking Office HCNTYP Long Description Mapping
7-11 Booking Office HCNTYP Short Description Mapping
7-12 Booking Office HCNTYP IATA Code Attribute Mapping
7-13 Booking Office HCNTYP Agent Name Attribute Mapping
7-14 Booking Office HCNTYP Agent Status Attribute Mapping
7-15 Geography (HGEO) Levels and Hierarchies
7-16 Geography Long Description Attribute Mapping
7-17 Geography Short Description Attribute Mapping
7-18 Interaction Reason (HIRSN) Levels and Hierarchies
7-19 Interaction Reason Long Description Attribute Mapping
7-20 Interaction Reason Short Description Attribute Mapping
7-21 Loyalty Level (HLOYLY) Levels and Hierarchies
7-22 Loyalty Level Long Description Attribute Mapping
7-23 Loyalty Level Short Description Attribute Mapping
7-24 Loyalty Level Qualifying Start Points Attribute Mapping
7-25 Operating Flight (OPFLT) Levels and Hierarchies
7-26 Operating Flight Long Description Attribute Mapping
7-27 Operating Flight Short Description Attribute Mapping
7-28 Operating Segment (OPSMT) Levels and Hierarchies
7-29 Operating Segment Long Description Attribute Mapping
7-30 Operating Segment Short Description Attribute Mapping
7-31 Operating Segment Pair Attribute Mapping
7-32 Route (ROUTE) Levels and Hierarchies
7-33 Route Long Description Attribute Mapping
7-34 Route Short Description Attribute Mapping
7-35 Service (SRVC) Levels and Hierarchies
7-36 Service Long Description Attribute Mapping
7-37 Service Short Description Attribute Mapping
7-38 Time (TIME) Levels and Hierarchies
7-39 Time Long Description Attribute Mapping
7-40 Time Short Description Attribute Mapping
7-41 Time End Date Attribute Mapping
7-42 Time Span Attribute Mapping
7-43 Time Calendar Week Number in Year Attribute Mapping
7-44 Time Day of Week Number Attribute Mapping
7-45 Time Day of Week Name Attribute Mapping
8-1
Oracle Airlines Data Model
OLAP Cubes
8-2 Booking Segment Departure Fact Cube Dimensions and Load Level
8-3 Booking Segment Departure Fact Cube Aggregation Operator and Order
8-4 Booking Segment Departure Fact Cube Base Measures
8-5 Booking Segment Departure Fact Cube Derived Measures
8-6 Booking Segment Departure Fact Forecast Cube Dimensions and Load Level
8-7 Booking Segment Departure Fact Forecast Aggregation Operator and Order
8-8 Booking Segment Departure Fact Forecast Base Measures
8-9 Call Center Performance Cube Dimensions and Load Level
8-10 Call Center Performance Fact Aggregation Operator and Order
8-11 Call Center Performance Fact Base Measures
8-12 Call Center Performance Fact Cube Derived Measures
8-13 Customer Survey Daily Fact Cube Dimensions and Load Level
8-14 Customer Survey Daily Fact Cube Aggregation Operator and Order
8-15 Customer Survey Daily Fact Cube Base Measures
8-16 Customer Survey Daily Fact Cube Derived Measures
8-17 Flight Detail Daily Cube Dimensions and Load Level
8-18 Flight Detail Daily Cube Aggregation Operator and Order
8-19 Flight Detail Daily Cube Base Measures
8-20 Flight Detail Daily Cube Derived Measures
8-21 Loyalty Account Fact Cube Dimensions and Load Level
8-22 Loyalty Account Fact Cube Aggregation Operator and Order
8-23 Loyalty Account Fact Cube Base Measures
8-24 Loyalty Account Fact Cube Derived Measures
8-25 Loyalty Booking Fact Cube Dimensions and Load Level
8-26 Loyalty Booking Fact Cube Aggregation Operator and Order
8-27 Loyalty Booking Fact Cube Base Measures
8-28 Loyalty Booking Fact Cube Derived Measures
9-1
Oracle Airlines Data Model
Algorithm Types Used by Model
9-2 dwd_cust_mnng Data Mining Result Table
9-3 dwr_cust_sgmnt Data Mining Result Table
9-4 dwd_cust_lylty_dt_rules Data Mining Result Table
9-5 dwd_cust_lylty_svm_factor Data Mining Result Table
9-6 dwd_cust_ltv_dt_rules Data Mining Result Table
9-7 dwd_cust_ltv_svm_factor Data Mining Result Table
9-8 dwd_cust_lylty_svm_factor Data Mining Result Table
9-9 dwd_ffp_pred_svm_factor Data Mining Result Table
9-10 dwd_non_ffp_mnng Data Mining Result Table
9-11 Customer Segmentation Source: dmv_cust_profile_src
9-12 Frequent Flyer Passenger Prediction Source: dmv_ffp_pred_src
A-1 DWC_ETL_PARAMETER Table
A-2 ETL Parameters in the DWC_OLAP_ETL_PARM Table
A-3 DWC_INTRA_ETL_PROCESS Columns
A-4 DWC_INTRA_ETL_ACTIVITY Columns
A-5 DWC_ACTIVITY Columns
A-6 DWC_ACTIVITY_PARM Columns
A-7 DWC_ACTIVITY_PARM_TYP Columns
A-8 DWC_ERROR_LOG Columns
A-9 DWC_MESSAGE Columns
B-1 Database Users and Privileges:
OADM
_SYS and
OADM
_SAMPLE
B-2 Database Users and Privileges:
OADM
_USER
B-3 Database Users and Privileges:
OADM
_REPORT
Scripting on this page enhances content navigation, but does not change the content in any way.