Oracle Airlines Data Model Physical Data Model

Introduction to Oracle Airlines Data Model Physical Data Model

The Physical Data Model of the Oracle Airlines Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions and Materialized Views have been added to aid performance.

Important:

Do not make changes to the schemas as such changes are not supported.

Table 3-1 shows the table name prefix conventions. When you examine the predefined physical model, keep in mind the naming conventions shown in Table 3-1 that use DW (Data Warehouse) prefixes to identify the types of tables and views.

Table 3-1 Table Name Prefix and Suffix Conventions

Prefix	Description
CB$	Materialized view of an OLAP cube. This materialized view is automatically created by the OLAP server. Note: Do not report or query against this object. Instead access the corresponding _VIEW object.
DM_	Data Mining Settings
DMV_	Materialized views used for as the source data of data mining model
DWA_	Aggregate tables
DWB_	Base transaction data (3NF) tables
DWC_	Control tables
DWD_	Derived table (including data mining result tables)
DWL_	Lookup tables
DWM_	Dimension tables in an access layer fact table (that is, for a DWD_ or a DWA_ table)
DWL_	Lookup table
DWR_	Reference data tables used as dimension tables in a foundation layer fact table (that is, for a DWB_ table)
DWV_	Relational view of time dimension
_H	"Classic" data warehouse table that is used to store both the most recent data and the historical data of a certain entity. For more information, see Oracle Airlines Data Model Implementation and Operations Guide.
_VIEW	Suffix specifies relational views of OLAP cubes, dimensions, or hierarchies.

Reference Tables

In the Oracle Airlines Data Model foundation layer, DWR_ tables (also known as reference tables) act as dimension tables to the base (DWB_ ) tables.

Table 3-2 lists the Reference tables in Oracle Airlines Data Model.

Table 3-2 Reference Tables

Table Name	Description and More information
DWR_ACCT	ACCOUNT
DWR_ACCT_H	ACCOUNT HISTORY
DWR_AIP	AIRPORT
DWR_AIP_H	AIRPORT HISTORY
DWR_AWRD_VCHR	AWARD VOUCHER
DWR_AWRD_VCHR_H	AWARD VOUCHER HISTORY
DWR_BKG_CAMPN	BOOKING CAMPAIGN
DWR_BKG_CAMPN_H	BOOKING CAMPAIGN HISTORY
DWR_BKG_OFF	BOOKING OFFICE
DWR_BKG_OFF_H	BOOKING OFFICE HISTORY
DWR_BKG_OFF_USR	BOOKING OFFICE USER
DWR_BKG_OFF_USR_H	BOOKING OFFICE USER HISTORY
DWR_BKG_PAX	BOOKING PASSENGER
DWR_BKG_PAX_H	BOOKING PASSENGER HISTORY
DWR_BKG_PAX_DOC_INFO	BOOKING PASSENGER DOCUMENT INFORMATION
DWR_BKG_PAX_DOC_INFO_H	BOOKING PASSENGER DOCUMENT INFORMATION HISTORY
DWR_BKG_PROD	BOOKING PRODUCT
DWR_BKG_PROD_H	BOOKING PRODUCT HISTORY
DWR_BKG_SEAT_PREF	BOOKING SEAT PREFERENCE
DWR_BKG_SEAT_PREF_H	BOOKING SEAT PREFERENCE HISTORY
DWR_BKG_SERS	BOOKING SERIES
DWR_BKG_SERS_H	BOOKING SERIES HISTORY
DWR_BKG_SSR_BRDG	BOOKING SSR BRDG
DWR_BKG_SSR_BRDG_H	BOOKING SSR BRIDGE HISTORY
DWR_BKG_TST	BOOKING TRANSITIONAL STORE TICKET
DWR_BKG_TST_H	BOOKING TRANSITIONAL STORE TICKET HISTORY
DWR_BKG_TST_PRC	BOOKING TST PRICE
DWR_BKG_TST_PRC_H	BOOKING TRANSITIONAL STORE TICKET PRICE HISTORY
DWR_BKG_TST_SEG	BOOKING TST SEGMENT
DWR_BKG_TST_SEG_H	BOOKING TRANSITIONAL STORE TICKET SEGMENT HISTORY
DWR_BNK_CARD	BANK CARD
DWR_BNK_CARD_H	BANK CARD HISTORY
DWR_CARR	CARRIER
DWR_CARR_H	CARRIER HISTORY
DWR_CDSH	CODESHARE
DWR_CDSH_H	CODESHARE HISTORY
DWR_CDSH_BRDG	CODESHARE BRIDGE
DWR_CDSH_BRDG_H	CODESHARE BRIDGE HISTORY
DWR_CHKIN_BAG_GRP	CHECKIN BAGGAGE GROUP
DWR_CHKIN_BAG_GRP_H	CHECKING BAGGAGE GROUP HISTORY
DWR_CHKIN_INDV_BAG	CHECKIN INDIVIDUAL BAGGAGE
DWR_CHKIN_INDV_BAG_H	CHECKIN INDIVIDUAL BAGGAGE HISTORY
DWR_CUST_SGMNT	CUSTOMER SEGMENTATION
DWR_CUST_SGMNT_DTL	CUSTOMER SEGMENTATION DETAILS
DWR_FLT	FLIGHT
DWR_FLT_H	FLIGHT HISTORY
DWR_FRQTFLR	FREQUENT FLYER
DWR_FRQTFLR_H	FREQUENT FLYER HISTORY
DWR_GRPNG	GROUPING
DWR_GRPNG_H	GROUPING HISTORY
DWR_INFLT_MEAL	INFLIGHT MEAL
DWR_INFLT_MEAL_H	INFLIGHT MEAL HISTORY
DWR_LEG	LEG
DWR_LEG_H	LEG HISTORY
DWR_LYLTY_ACCT	LOYALTY ACCOUNT
DWR_LYLTY_ACCT_H	LOYALTY ACCOUNT HISTORY
DWR_LYLTY_LVL	LOYALTY LEVEL
DWR_LYLTY_LVL_H	LOYALTY LEVEL HISTORY
DWR_ODT_ACCT	ODT ACCOUNT
DWR_ODT_ACCT_H	ODT ACCOUNT HISTORY
DWR_OPTN	OPTION
DWR_OPTN_H	OPTION HISTORY
DWR_PAX_CNTCT	PASSENGER CONTACT
DWR_PAX_CNTCT_H	PASSENGER CONTACT HISTORY
DWR_PAX_CTRY_ADDR_INFO	PASSENGER COUNTRY ADDRESS INFORMATION
DWR_PAX_CTRY_ADDR_INFO_H	PASSENGER COUNTRY ADDRESS INFORMATION HISTORY
DWR_PAX_VISA_INFO	PASSENGER VISA INFORMATION
DWR_PAX_VISA_INFO_H	PASSENGER VISA INFORMATION HISTORY
DWR_PDI_CHRSTIC	PDI CHARACTERISTIC
DWR_PDI_CHRSTIC_H	PDI CHARACTERISTIC HISTORY
DWR_PNR_PARENT_CHILD_RELSHP	PNR PARENT CHILD RELATIONSHIP
DWR_PNR_PARENT_CHILD_RELSHP_H	PNR PARENT CHILD RELATIONSHIP HISTORY
DWR_POS_GDS_OFF	POINT OF SALE GDS OFFICE
DWR_POS_GDS_OFF_H	POINTOF SALE GDS OFFICE IDENTIFIER HISTORY
DWR_PRTY	PARTY
DWR_PRTY_H	PARTY HISTORY
DWR_SEAT	SEAT
DWR_SEAT_H	SEAT HISTORY
DWR_SEG	SEGMENT
DWR_SEG_H	SEGMENT HISTORY
DWR_SMS_AGNT	SMS AGENT
DWR_SMS_AGNT_H	SMS AGENT HISTORY
DWR_SMS_CUST	SMS CUSTOMER
DWR_SMS_CUST_H	SMS CUSTOMER HISTORY
DWR_STN	STATION
DWR_STN_H	STATION HISTORY
DWR_SVC	SERVICE
DWR_SVC_H	SERVICE HISTORY
DWR_TKT_CPN	TICKET COUPON
DWR_TKT_CPN_H	TICKET COUPON HISTORY
DWR_TSM	TSM
DWR_TSM_H	TSM HISTORY
DWR_TSM_PAX	TSM PASSENGER
DWR_TSM_PAX_H	TSM PASSENGER HISTORY
DWR_VHCL	VEHICLE
DWR_VHCL_H	VEHICLE HISTORY
DWR_VIP_PAX_INFO	VIP PASSENGER INFORMATION
DWR_VIP_PAX_INFO_H	VIP PASSENGER INFORMATION HISTORY

Base Tables

In Oracle Airlines Data Model, the base tables present the transaction data in 3NF . Base tables define atomic level transaction data. Data in the base tables support the derived and aggregate layers, and act as a source for Data Mining for advanced analysis.

Table 3-3 lists the Base tables in Oracle Airlines Data Model.

Table 3-3 Base Tables

Table Name	Description and More Information
DWB_ACCT_LVL_HIST	ACCOUNT LEVEL HISTORY
DWB_ACCT_LVL_HIST_H	ACCOUNT LEVEL HISTORY H
DWB_ACCT_XFER	ACCOUNT TRANSFER
DWB_ACCT_XFER_H	ACCOUNT TRANSFER HISTORY
DWB_AUX	AUX
DWB_BKG	BOOKING
DWB_BKG_H	BOOKING HISTORY
DWB_CHKIN	CHECKIN
DWB_CHKIN_H	CHECKIN HISTORY
DWB_CMNSTRY_ERNG	COMPENSATORY EARNING
DWB_CMNSTRY_ERNG_H	COMPENSATORY EARNING HISTORY
DWB_CMPL_ADVC	COMPLAIN ADVICE
DWB_CMPL_ADVC_H	COMPLAIN ADVICE HISTORY
DWB_CR_RNTL	CAR RENTAL
DWB_DIRCT_ERNG	DIRECT EARNING
DWB_DIRCT_ERNG_H	DIRECT EARNING HISTORY
DWB_ERNG_EVNT	EARNING EVENT
DWB_ERNG_EVNT_H	EARNING EVENT HISTORY
DWB_FLT_CHNG	FLIGHT CHANGE
DWB_FLT_CHNG_H	FLIGHT CHANGE HISTORY
DWB_FLT_SCHD	FLIGHT SCHEDULE
DWB_FLT_SCHD_H	FLIGHT SCHEDULE HISTORY
DWB_HTL_BKNG	HOTEL BOOKING
DWB_LYLTY_ACCT_BAL_HIST	LOYALTY ACCOUNT BALANCE HISTORY
DWB_LYLTY_ACCT_BAL_HIST_H	LOYALTY ACCOUNT BALANCE HISTORY H
DWB_LYLTY_ACCT_LVL_HIST	LOYALTY ACCOUNT LEVEL HISTORY
DWB_LYLTY_ACCT_LVL_HIST_H	LOYALTY ACCOUNT LEVEL HISTORY H
DWB_LYLTY_CONV	LOYALTY CONVERSION
DWB_LYLTY_CONV_H	LOYALTY CONVERSION HISTORY
DWB_LYLTY_PNTS_EXPR	LOYALTY POINTS EXPIRE
DWB_LYLTY_PNTS_EXPR_H	LOYALTY POINTS EXPIRE HISTORY
DWB_LYLTY_PRG	LOYALTY PROGRAM
DWB_LYLTY_PRG_H	LOYALTY PROGRAM HISTORY
DWB_PDI	PDI
DWB_PDI_H	PDI HISTORY
DWB_PNR	PASSENGER NAME RECORD
DWB_PNR_H	PASSENGER NAME RECORD HISTORY
DWB_PRTY_INTRATN	PARTY INTERACTION
DWB_PRTY_INTRATN_H	PARTY INTERACTION HISTORY
DWB_PRTY_INTRATN_CALL	PARTY INTERACTION CALL
DWB_PRTY_INTRATN_CALL_H	PARTY INTERACTION CALL HISTORY
DWB_PRTY_INTRATN_EML	PARTY INTERACTION EMAIL
DWB_PRTY_INTRATN_EML_H	PARTY INTERACTION EMAIL HISTORY
DWB_PRTY_INTRATN_FAX	PARTY INTERACTION FAX
DWB_PRTY_INTRATN_FAX_H	PARTY INTERACTION FAX HISTORY
DWB_PRTY_INTRATN_ITEM	PARTY INTERACTION ITEM
DWB_PRTY_INTRATN_ITEM_H	PARTY INTERACTION ITEM HISTORY
DWB_PRTY_INTRATN_LETR	PARTY INTERACTION LETTER
DWB_PRTY_INTRATN_LETR_H	PARTY INTERACTION LETTER HISTORY
DWB_PRTY_INTRATN_SMS	PARTY INTERACTION SMS
DWB_PRTY_INTRATN_SMS_H	PARTY INTERACTION SMS HISTORY
DWB_PRTY_INTRATN_THRD	PARTY INTERACTION THREAD
DWB_PRTY_INTRATN_THRD_H	PARTY INTERACTION THREAD HISTORY
DWB_PRTY_INTRATN_VST	PARTY INTERACTION VISIT
DWB_PRTY_INTRATN_VST_H	PARTY INTERACTION VISIT HISTORY
DWB_PTNR_ERNG	PARTNER EARNING
DWB_PTNR_ERNG_H	PARTNER EARNING HISTORY
DWB_SEG_SCHD	SEGMENT SCHEDULE
DWB_SEG_SCHD_H	SEGMENT SCHEDULE HISTORY
DWB_TAS	TAS
DWB_TKT	TICKET
DWB_TKT_H	TICKET HISTORY
DWB_TKT_DLVRY_ARNGMNT	TICKET DELIVERY ARRANGEMENT
DWB_TKT_DLVRY_ARNGMNT_H	TICKET DELIVERY ARANGMENT HISTORY
DWB_TOUR	TOUR
DWB_XFER_ERNG	TRANSFER EARNING
DWB_XFER_ERNG_H	TRANSFER EARNING HISTORY

Derived Tables

In Oracle Airlines Data Model, the Derived tables are tables that have as values the result of a non-aggregate calculation. There are two types of derived tables in the Oracle Airlines Data Model:

Tables that hold the results of a calculation.
Result tables for the data mining models.

Table 3-4 lists the Derived tables in Oracle Airlines Data Model.

Table 3-4 Derived Tables

Table Name	Description and More Information
DWD_BKG_FACT	BOOKING FACT
DWD_CALL_CNTR_PRFMNC	CALL CENTER PERFORMANCE
DWD_CHKIN_FACT	CHECKIN FACT
DWD_CUST_LTV_SVM_FACTOR	CUSTOMER LIFE TIME VALUE SUPPORT VECTOR MACHINE FACTOR
DWD_CUST_LYLTY_DT_RULES	CUSTOMER LOYALTY DECISION TREE RULES
DWD_CUST_LYLTY_SVM_FACTOR	CUSTOMER LOYALTY SUPPORT VECTOR MACHINE FACTOR
DWD_CUST_MNNG	CUSTOMER MINING
DWD_CUST_RFMP_SCR	CUSTOMER RECENCY FREQUENCY MONETARY PROFITABILITY SCORE
DWD_CUST_SRVY	CUSTOMER SURVEY
DWD_FFP_PRED_DT_RULES	FREQUENT FLIER PREDICTION DECISION TREE RULES
DWD_FFP_PRED_SVM_FACTOR	FREQUENT FLIER PREDICTION SUPPORT VECTOR MACHINE FACTOR
DWD_FLT_DETLS_FACT	FLIGHT DETAILS FACT
DWD_LYLTY_ACCT_BAL_HIST	LOYALTY ACCOUNT BALANCE HISTORY
DWD_LYLTY_ACCT_LVL_HIST	LOYALTY ACCOUNT LEVEL HISTORY
DWD_LYLTY_PRG	LOYALTY PROGRAM
DWD_NON_FFP_MNNG	NON FREQUENT FLIER MINING
DWD_PNR	PASSENGER NAME RECORD
DWD_TKT	TICKET

Aggregate Tables

In Oracle Airlines Data Model, the Aggregate tables are tables that aggregate or "roll up" the data to one level higher than a base or derived table. The aggregate tables provide a view of the data similar to the view provided by a fact table in a snowflake schema while the dimensions of that table are DWM_ tables.

Table 3-5 lists the Aggregate tables in Oracle Airlines Data Model.

Table 3-5 Aggregate Tables

Table Name	Description and More Information
DWA_BKG_DLY_INVT_SNPST	BOOKING DAILY INVENTORY SNAPSHOT
DWA_CHKIN_DLY_FACT	CHECKIN DAILY FACT
DWA_CUST_SRVY	CUSTOMER SURVEY
DWA_DLY_BKG_FACT	DAILY BOOKING FACT
DWA_DLY_CALL_CNTR_PRFMNC	DAILY CALL CENTER PERFORMANCE
DWA_DLY_FLT_DETLS	DAILY FLIGHT DETAILS
DWA_DLY_LYLTY_ACCT	DAILY LOYALTY ACCOUNT
DWA_DLY_LYLTY_ACCT_BKG	DAILY LOYALTY ACCOUNT BOOKING

Dimension Tables

In Oracle Airlines Data Model, the dimension (DWM_ ) tables typically represent dimensions which contain a business hierarchy and are present in the form of snowflake entities containing a table for each level of the hierarchy. This allows you to attach the appropriate set of reference tables for the multiple subject area and fact entities composed of differing granularity. For example, you can use the time dimension table DWM_CLNDR to query against a DAY level Passenger Name Record ( PNR) data such as DWD_PNR.

Table 3-6 lists the Dimension tables in Oracle Airlines Data Model.

Table 3-6 Dimension Tables

Table Name	Description and More Information
DWM_ACCT	ACCOUNT
DWM_ACFT_TYP	AIRCRAFT TYPE
DWM_ACFT_VER	AIRCRAFT VERSION
DWM_AIP	AIRPORT
DWM_BKG_CLS_TYP	BOOKING CLASS TYPE
DWM_BKG_OFF	BOOKING OFFICE
DWM_BKG_PAX	BOOKING PASSENGER
DWM_BKG_SSR	BOOKING SSR BRDG
DWM_BKG_TST	BOOKING TST
DWM_CARR	CARRIER
DWM_CITYPAIRS	CITYPAIRS
DWM_CLNDR	CALENDAR
DWM_CORP_CUST	CORPORATE CUSTOMER
DWM_CRCY	CURRENCY
DWM_CTRY	COUNTRY
DWM_FARE_TYP	FARE TYPE
DWM_FLT	FLIGHT
DWM_FRQTFLR	FREQUENT FLYER
DWM_GEOAREAS	GEOAREAS
DWM_GEOGRY	GEOGRAPHY
DWM_INTRATN_RSLT	INTERACTION RESULT
DWM_INTRATN_RSN	INTERACTION REASON
DWM_LEG	LEG
DWM_LYLTY_LVL	LOYALTY LEVEL
DWM_MKTAREAS	MARKETAREAS
DWM_PDI_CHNL	PDI CHANNEL
DWM_ROUTEPAIRS	ROUTEPAIRS
DWM_ROUTES	ROUTES
DWM_SALES_CHNL	SALES CHANNEL
DWM_SEG	SEGMENT
DWM_SEG_PAIR	SEGMENT PAIR
DWM_SSR	SPECIAL SERVICE REQUEST
DWM_SVC	SERVICE
DWM_TM	TIME
DWM_TRAF_CATG	TRAFFIC CATEGORY

Lookup Tables

In Oracle Airlines Data Model lookup tables contain the relatively static or descriptive data in the data warehouse. Lookup tables hold the descriptions for frequently used attributes. Using lookup entities saves space, as the referring fact table holds only a small key or code and foreign key, and Oracle Airlines Data Model stores the space consuming description in a lookup table and does not repeat the description in each transaction row in which it is referenced.

Table 3-7 lists the Lookup tables in Oracle Airlines Data Model.

Table 3-7 Lookup Tables

Table Name	Description and More Information
DWL_ACCT_LVL	ACCOUNT LEVEL
DWL_ACCT_LVL_H	ACCOUNT LEVEL HISTORY
DWL_ACCT_TYP	ACCOUNT TYPE
DWL_ACCT_TYP_H	ACCOUNT TYPE HISTORY
DWL_ACCT_XFER_RSN	ACCOUNT TRANSFER REASON
DWL_ACCT_XFER_RSN_H	ACCOUNT TRANSFER REASON HISTORY
DWL_ACFT_TYP	AIRCRAFT TYPE
DWL_ACFT_TYP_H	AIRCRAFT TYPE HISTORY
DWL_ACV	AIRCRAFT VERSION
DWL_ACV_H	AIRCRAFT VERSION HISTORY
DWL_BKG_CLS	BOOKING CLASS
DWL_BKG_CLS_H	BOOKING CLASS HISTORY
DWL_BKG_OTR_SVC	BOOKING OTHER SERVICE
DWL_BKG_OTR_SVC_H	BOOKING OTHER SERVICE HISTORY
DWL_BKG_RMRK	BOOKING REMARK
DWL_BKG_RMRK_H	BOOKING REMARK HISTORY
DWL_BKG_SSR	BOOKING SPECIAL SERVICE REQUEST
DWL_BKG_SSR_H	BOOKING SPECIAL SERVICE REQUEST HISTORY
DWL_BNK_CARD_TYP	BANK CARD TYPE
DWL_BNK_CARD_TYP_H	BANK CARD TYPE HISTORY
DWL_CARR_TYP	CARRIER TYPE
DWL_CARR_TYP_H	CARRIER TYPE HISTORY
DWL_CMNSTRY_RSN	COMPENSATORY REASON
DWL_CMNSTRY_RSN_H	COMPENSATORY REASON HISTORY
DWL_CMPL_CLS	COMPLAIN CLASS
DWL_CMPL_CLS_H	COMPLAIN CLASS HISTORY
DWL_CMPL_TYP	COMPLAIN TYPE
DWL_CMPL_TYP_H	COMPLAIN TYPE HISTORY
DWL_FARE_ELEM	FARE ELEMENT
DWL_FARE_ELEM_H	FARE ELEMENT HISTORY
DWL_INTRATN_RSLT	INTERACTION RESULT
DWL_INTRATN_RSLT_H	INTERACTION RESULT HISTORY
DWL_INTRATN_RSN	INTERACTION REASON
DWL_INTRATN_RSN_H	INTERACTION REASON HISTORY
DWL_LETR_TYP	LETTER TYPE
DWL_LETR_TYP_H	LETTER TYPE HISTORY
DWL_PDI_CHNL	PDI CHANNEL
DWL_PDI_CHNL_H	PDI CHANNEL HISTORY
DWL_PNR_TYP	PASSENGER NAME RECORD TYPE
DWL_PNR_TYP_H	PASSENGER NAME RECORD TYPE HISTORY
DWL_PRTY_INTRATN_ITEM_STS	PARTY INTERACTION ITEM STATUS
DWL_PRTY_INTRATN_ITEM_STS_H	PARTY INTERACTION ITEM STATUS HISTORY
DWL_PRTY_STS	PARTY STATUS
DWL_PRTY_STS_H	PARTY STATUS HISTORY
DWL_SALES_CHNL	SALES CHANNEL
DWL_SALES_CHNL_H	SALES CHANNEL HISTORY
DWL_TKT_DLVRY_ARNGMNT	TICKET DELIVERY ARRANGEMENT
DWL_TKT_DLVRY_ARNGMNT_H	TICKET DELIVERY ARRANGEMENT HISTORY
DWL_TRAF_CATG	TRAFFIC CATEGORY
DWL_TRAF_CATG_H	TRAFFIC CATEGORY HISTORY
DWL_TSM_MCO	TSM MCO
DWL_TSM_MCO_H	TSM MCO HISTORY
DWL_TSM_PRC	TSM PRICE
DWL_TSM_PRC_H	TSM PRICE HISTORY
DWL_TSM_ROUTE	TSM ROUTE
DWL_TSM_ROUTE_H	TSM ROUTE HISTORY
DWL_TSM_SVC	TSM SERVICE
DWL_TSM_SVC_H	TSM SERVICE HISTORY
DWL_TSM_XSB	TSM EXCESS BAGGAGE
DWL_TSM_XSB_H	TSM EXCESS BAGGAGE HISTORY

Mining Tables

Table 3-8 lists the Data Mining control and Data Mining settings tables in Oracle Airlines Data Model.

Table 3-8 Data Mining and Data Mining Settings Tables

Table Name	Description
DM_STNG_CUST_LTY_DT	SETTING CUSTOMER DECISION TREE
DM_STNG_CUST_LTY_SVM	SETTING CUSTOMER SUPPORT VECTOR MACHINE
DM_STNG_PROFILE_KMEANS	SETTING PROFILE KMEANS
DM_STNG_USER_ALL	SETTING USER ALL
DMV_BKG_FACT_APPLY	FREQUENT FLIER BOOKING FACT APPLY
DMV_BKG_FACT_SRC	FREQUENT FLIER BOOKING FACT SOURCE
DMV_CUST_LOYALTY_APPLY	FREQUENT FLIER CUSTOMER LOYALTY APPLY
DMV_CUST_LOYALTY_SRC	FREQUENT FLIER CUSTOMER LOYALTY SOURCE
DMV_CUST_LTV_APPLY	FREQUENT FLIER CUSTOMER LIFE TIME VALUE APPLY
DMV_CUST_LTV_SRC	FREQUENT FLIER CUSTOMER LIFE TIME VALUE SOURCE
DMV_CUST_PROFILE_APPLY	FREQUENT FLIER CUSTOMER PROFILE APPLY
DMV_CUST_PROFILE_SRC	FREQUENT FLIER CUSTOMER PROFILE SOURCE
DMV_FFP_PRED_APPLY	FREQUENT FLIER PREDICTION APPLY
DMV_FFP_PRED_SRC	FREQUENT FLIER PREDICTION SOURCE
DMV_LYLTY_ACCT_BAL_APPLY	FREQUENT FLIER LOYALTY ACCOUNT BALANCE APPLY
DMV_LYLTY_ACCT_BAL_SRC	FREQUENT FLIER LOYALTY ACCOUNT BALANCE SOURCE

Database Sequences

Table 3-9 lists the Sequence Names in Oracle Airlines Data Model.

Table 3-9 Database Sequences

Generates the Physical Key for Table Name	Sequence Name
DWA_CUST_SRVY	SEQ_DWA_CUST_SRVY
DWA_DLY_BKG_FACT	SEQ_DWA_DLY_BKG_FACT
DWA_DLY_CALL_CNTR_PERFM	SEQ_DWA_DLY_CALL_CNTR_PERFM
DWA_DLY_FLT_DETLS	SEQ_DWA_DLY_FLT_DETLS
DWA_DLY_LYLTY_ACCT	SEQ_DWA_DLY_LYLTY_ACCT
DWA_DLY_LYLTY_ACCT_BKG	SEQ_DWA_DLY_LYLTY_ACCT_BKG
DWD_CHKIN_FACT	SEQ_DWD_CHKIN_FACT
DWD_FLT_DETLS_FACT	SEQ_DWD_FLT_DETLS_FACT
DWM_SALES_CHNL	SEQ_DWM_SALES_CHNL

Metadata Tables

Table 3-10 lists the Metadata tables in Oracle Airlines Data Model.

Table 3-10 Metadata Tables

Table Name	Description
MD_ENTY	Stores data about logical data model entities, attributes, descriptions, and physical table names.
MD_KPI	Contains distinct presentation columns (KPI_NAME), dashboard folder name as subject area and computation logic for the KPI and subject area used in the RPD.
MD_PRG	Store all the information of the programs. Programs may be Packages used to store the data in Derived and Mining tables, Reports, Cubes or MV's, and so on.
MD_REF_ENTY_KPI	This table contains physical tables and columns used for the particular KPIs along with other columns used in KPI calculations.

Oracle Airlines Data Model OLAP Cube MV, Cube View

Table 3-11 shows the cube materialized views in oadm_sys schema.

Table 3-11 OLAP Cube Materialized Views in oadm_sys Schema

Cube Materialized View Name	OLAP Object Name	OLAP Object Type	More Information
CB$BKCLS_HBKCLS	BKCLS_HBKCLS	Dimension_Hierarchy	Booking Class: BKCLS
CB$BKOFC_HCNTYP	BKOFC_HCNTYP	Dimension_Hierarchy	Booking Office: BKOFC
CB$BKOFC_HBKOFC	BKOFC_HBKOFC	Dimension_Hierarchy	Booking Office: BKOFC
CB$BSDF	BSDF	Cube	Booking Segment Departure Fact Forecast Cube: BSDF_F
CB$BSDF_F	BSDF_F	Cube	Booking Segment Departure Fact Forecast Cube: BSDF_F
CB$CCPF	CCPF	Cube	Call Center Performance Fact Cube: CCPF
CB$CSDF	CSDF	Cube	Customer Survey Daily Fact Cube: CSDF
CB$FDDF	FDDF	Cube	Flight Detail Daily Fact Cube: FDDF
CB$GEO_HGEO	GEO_HGEO	Dimension_Hierarchy	Geography: GEO
CB$IRSN_HIRSN	IRSN_HIRSN	Dimension_Hierarchy	Interaction Reason: IRSN
CB$LOYLV_HLOYLY	LOYLV_HLOYLY	Dimension_Hierarchy	Loyalty Level: LOYLV
CB$LYAF	LYAF	Cube	Loyalty Account Fact Cube: LYAF
CB$LYBF	LYBF	Cube	Loyalty Booking Fact Cube: LYBF
CB$OPFLT_HOPFLT	OPFLT_HOPFLT	Dimension_Hierarchy	Operating Flight: OPFLT
CB$OPSMT_HOPSMT	OPSMT_HOPSMT	Dimension_Hierarchy	Operating Segment: OPSMT
CB$ROUTE_HROUTE	ROUTE_HROUTE	Dimension_Hierarchy	Route: ROUTE
CB$SRVC_HSRVC	SRVC	Dimension_Hierarchy	Service: SRVC
CB$TIME_HTIME	TIME_HTIME	Dimension_Hierarchy	Time: TIME
CB$TIME_HWEEK	TIME_HWEEK	Dimension_Hierarchy	Time: TIME

Table 3-12 shows the OLAP cube views in oadm_sys schema.

Table 3-12 OLAP Cube Views in oadm_sys schema

Cube View Name	OLAP Object Name	OLAP Object Type	More Information
BKCLS_HBKCLS_VIEW	BKCLS_HBKCLS	Hierarchy	Booking Class: BKCLS
BKCLS_VIEW	BKCLS	Dimension	Booking Class: BKCLS
BKOFC_HCNTYP_VIEW	BKOFC_HCNTYP	Hierarchy	Booking Office: BKOFC
BKOFC_HBKOFC_VIEW	BKOFC_HBKOFC	Hierarchy	Booking Office: BKOFC
BKOFC_VIEW	BKOFC	Dimension	Booking Office: BKOFC
BSDF_VIEW	BSDF	Cube	Booking Segment Departure Fact Cube: BSDF
BSDF_F_VIEW	BSDF_F	Cube	Booking Segment Departure Fact Forecast Cube: BSDF_F
CCPF_VIEW	CCPF	Cube	Call Center Performance Fact Cube: CCPF
CSDF_VIEW	CSDF	Cube	Customer Survey Daily Fact Cube: CSDF
FDDF_VIEW	FDDF	Cube	Flight Detail Daily Fact Cube: FDDF
GEO_HGEO_VIEW	GEO_HGEO	Hierarchy	Geography: GEO
GEO_VIEW	GEO	Dimension	Geography: GEO
IRSN_HIRSN_VIEW	IRSN_HIRSN	Hierarchy	Interaction Reason: IRSN
IRSN_VIEW	IRSN	Dimension	Interaction Reason: IRSN
LOYLV_HLOYLY_VIEW	LOYLV_HLOYLY	Hierarchy	Loyalty Level: LOYLV
LOYLV_VIEW	LOYLV	Dimension	Loyalty Level: LOYLV
LYAF_VIEW	LYAF	Cube	Loyalty Account Fact Cube: LYAF
LYBF_VIEW	LYBF	Cube	Loyalty Booking Fact Cube: LYBF
OPFLT_HOPFLT_VIEW	OPFLT_HOPFLT	Hierarchy	Operating Flight: OPFLT
OPFLT_VIEW	OPFLT	Dimension	Operating Flight: OPFLT
OPSMT_HOPSMT_VIEW	OPSMT_HOPSMT	Hierarchy	Operating Segment: OPSMT
OPSMT_VIEW	OPSMT	Dimension	Operating Segment: OPSMT
ROUTE_HROUTE_VIEW	ROUTE_HROUTE	Hierarchy	Route: ROUTE
ROUTE_VIEW	ROUTE	Dimension	Route: ROUTE
SRVC_HSRVC_VIEW	SRVC	Hierarchy	Service: SRVC
SRVC_VIEW	SRVC	Dimension	Service: SRVC
TIME_HTIME_VIEW	TIME_HTIME	Hierarchy	Time: TIME
TIME_HWEEK_VIEW	TIME_HWEEK	Hierarchy	Time: TIME
TIME_VIEW	TIME	Dimension	Time: TIME

3 Oracle Airlines Data Model Physical Data Model