4 Oracle Airlines Data Model Logical to Physical Mapping

This chapter provides a table listing the Oracle Airlines Data Model entities in the logical data model, and the physical database tables or views to which the logical entities have been implemented or "physicalized".

This chapter includes the following section:

Logical to Physical Mappings for Oracle Airlines Data Model

Logical to Physical Mappings for Oracle Airlines Data Model

Table 4-1 lists the Oracle Airlines Data Model entities in the logical data model, and the physical database tables or views to which the logical entities have been implemented or "physicalized".

Table 4-1 Entity Mapping Table: Logical to Physical Mapping

Entity	Table or View
ACCOUNT	DWM_ACCT
ACCOUNT	DWR_ACCT
ACCOUNT LEVEL	DWL_ACCT_LVL
ACCOUNT LEVEL HISTORY	DWB_ACCT_LVL_HIST
ACCOUNT TRANSFER	DWB_ACCT_XFER
ACCOUNT TRANSFER REASON	DWL_ACCT_XFER_RSN
ACCOUNT TYPE	DWL_ACCT_TYP
AIRCRAFT TYPE	DWL_ACFT_TYP
AIRCRAFT TYPE	DWM_ACFT_TYP
AIRCRAFT VERSION	DWL_ACV
AIRCRAFT VERSION	DWM_ACFT_VER
AIRPORT	DWR_AIP
AIRPORT	DWM_AIP
AUX	DWB_AUX
AWARD VOUCHER	DWR_AWRD_VCHR
BANK CARD	DWR_BNK_CARD
BANK CARD TYPE	DWL_BNK_CARD_TYP
BOOKING	DWB_BKG
BOOKING CAMPAIGN	DWR_BKG_CAMPN
BOOKING CLASS	DWL_BKG_CLS
BOOKING CLASS TYPE	DWM_BKG_CLS_TYP
BOOKING DAILY INVENTORY SNAPSHOT	DWA_BKG_DLY_INVT_SNPST
BOOKING FACT	DWD_BKG_FACT
BOOKING OFFICE	DWR_BKG_OFF
BOOKING OFFICE	DWM_BKG_OFF
BOOKING OFFICE USER	DWR_BKG_OFF_USR
BOOKING OTHER SERVICE	DWL_BKG_OTR_SVC
BOOKING PASSENGER	DWR_BKG_PAX
BOOKING PASSENGER	DWM_BKG_PAX
BOOKING PASSENGER DOCUMENT INFORMATION	DWR_BKG_PAX_DOC_INFO
BOOKING PRODUCT	DWR_BKG_PROD
BOOKING REMARK	DWL_BKG_RMRK
BOOKING SEAT PREFERENCE	DWR_BKG_SEAT_PREF
BOOKING SERIES	DWR_BKG_SERS
BOOKING SPECIAL SERVICE REQUEST	DWL_BKG_SSR
BOOKING SSR BRDG	DWR_BKG_SSR_BRDG
BOOKING SSR BRDG	DWM_BKG_SSR_BRDG
BOOKING TST	DWM_BKG_TST
BOOKING TRANSITIONAL STORE TICKET	DWR_BKG_TST
BOOKING TST PRICE	DWR_BKG_TST_PRC
BOOKING TST SEGMENT	DWR_BKG_TST_SEG
CALENDAR	DWM_CLNDR
CALL CENTER PERFORMANCE	DWD_CALL_CNTR_PRFMNC
CAR RENTAL	DWB_CR_RNTL
CARRIER	DWR_CARR
CARRIER	DWM_CARR
CARRIER TYPE	DWL_CARR_TYP
CHECKIN	DWB_CHKIN
CHECKIN BAGGAGE GROUP	DWR_CHKIN_BAG_GRP
CHECKIN DAILY FACT	DWA_CHKIN_DLY_FACT
CHECKIN FACT	DWD_CHKIN_FACT
CHECKIN INDIVIDUAL BAGGAGE	DWR_CHKIN_INDV_BAG
CITYPAIRS	DWM_CITYPAIRS
CODESHARE	DWR_CDSH
CODESHARE BRIDGE	DWR_CDSH_BRDG
COMPENSATORY EARNING	DWB_CMNSTRY_ERNG
COMPENSATORY REASON	DWL_CMNSTRY_RSN
COMPLAIN ADVICE	DWB_CMPL_ADVC
COMPLAIN CLASS	DWL_CMPL_CLS
COMPLAIN TYPE	DWL_CMPL_TYP
CORPORATE CUSTOMER	DWM_CORP_CUST
COUNTRY	DWM_CTRY
CURRENCY	DWM_CRCY
CUSTOMER LIFE TIME VALUE SUPPORT VECTOR MACHINE FACTOR	DWD_CUST_LTV_SVM_FACTOR
CUSTOMER LOYALTY DECISION TREE RULES	DWD_CUST_LYLTY_DT_RULES
CUSTOMER LOYALTY SUPPORT VECTOR MACHINE FACTOR	DWD_CUST_LYLTY_SVM_FACTOR
CUSTOMER MINING	DWD_CUST_MNNG
CUSTOMER RECENCY FREQUENCY MONETARY PROFITABILITY SCORE	DWD_CUST_RFMP_SCR
CUSTOMER SEGMENTATION	DWR_CUST_SGMNT
CUSTOMER SEGMENTATION DETAILS	DWR_CUST_SGMNT_DTL
CUSTOMER SURVEY	DWD_CUST_SRVY
CUSTOMER SURVEY	DWA_CUST_SRVY
DAILY BOOKING FACT	DWA_DLY_BKG_FACT
DAILY CALL CENTER PERFORMANCE	DWA_DLY_CALL_CNTR_PRFMNC
DAILY FLIGHT DETAILS	DWA_DLY_FLT_DETLS
DAILY LOYALTY ACCOUNT	DWA_DLY_LYLTY_ACCT
DAILY LOYALTY ACCOUNT BOOKING	DWA_DLY_LYLTY_ACCT_BKG
DIRECT EARNING	DWB_DIRCT_ERNG
EARNING EVENT	DWB_ERNG_EVNT
FARE ELEMENT	DWL_FARE_ELEM
FARE TYPE	DWM_FARE_TYP
FLIGHT	DWR_FLT
FLIGHT	DWM_FLT
FLIGHT CHANGE	DWB_FLT_CHNG
FLIGHT DETAILS FACT	DWD_FLT_DETLS_FACT
FLIGHT SCHEDULE	DWB_FLT_SCHD
FREQUENT FLIER BOOKING FACT APPLY	DMV_BKG_FACT_APPLY
FREQUENT FLIER BOOKING FACT SOURCE	DMV_BKG_FACT_SRC
FREQUENT FLIER CUSTOMER LIFE TIME VALUE APPLY	DMV_CUST_LTV_APPLY
FREQUENT FLIER CUSTOMER LIFE TIME VALUE SOURCE	DMV_CUST_LTV_SRC
FREQUENT FLIER CUSTOMER LOYALTY APPLY	DMV_CUST_LOYALTY_APPLY
FREQUENT FLIER CUSTOMER LOYALTY SOURCE	DMV_CUST_LOYALTY_SRC
FREQUENT FLIER CUSTOMER PROFILE APPLY	DMV_CUST_PROFILE_APPLY
FREQUENT FLIER CUSTOMER PROFILE SOURCE	DMV_CUST_PROFILE_SRC
FREQUENT FLIER LOYALTY ACCOUNT BALANCE APPLY	DMV_LYLTY_ACCT_BAL_APPLY
FREQUENT FLIER LOYALTY ACCOUNT BALANCE SOURCE	DMV_LYLTY_ACCT_BAL_SRC
FREQUENT FLIER PREDICTION APPLY	DMV_FFP_PRED_APPLY
FREQUENT FLIER PREDICTION DECISION TREE RULES	DWD_FFP_PRED_DT_RULES
FREQUENT FLIER PREDICTION SOURCE	DMV_FFP_PRED_SRC
FREQUENT FLIER PREDICTION SUPPORT VECTOR MACHINE FACTOR	DWD_FFP_PRED_SVM_FACTOR
FREQUENT FLYER	DWR_FRQTFLR
FREQUENT FLYER	DWM_FRQTFLR
GEOAREAS	DWM_GEOAREAS
GEOGRAPHY	DWM_GEOGRY
GROUPING	DWR_GRPNG
HOTEL BOOKING	DWB_HTL_BKNG
INFLIGHT MEAL	DWR_INFLT_MEAL
INTERACTION REASON	DWL_INTRATN_RSN
INTERACTION REASON	DWM_INTRATN_RSN
INTERACTION RESULT	DWL_INTRATN_RSLT
INTERACTION RESULT	DWM_INTRATN_RSLT
LEG	DWR_LEG
LEG	DWM_LEG
LETTER TYPE	DWL_LETR_TYP
LOYALTY ACCOUNT	DWR_LYLTY_ACCT
LOYALTY ACCOUNT BALANCE HISTORY	DWD_LYLTY_ACCT_BAL_HIST
LOYALTY ACCOUNT BALANCE HISTORY	DWB_LYLTY_ACCT_BAL_HIST
LOYALTY ACCOUNT LEVEL HISTORY	DWD_LYLTY_ACCT_LVL_HIST
LOYALTY ACCOUNT LEVEL HISTORY	DWB_LYLTY_ACCT_LVL_HIST
LOYALTY CONVERSION	DWB_LYLTY_CONV
LOYALTY LEVEL	DWM_LYLTY_LVL
LOYALTY LEVEL	DWR_LYLTY_LVL
LOYALTY POINTS EXPIRE	DWB_LYLTY_PNTS_EXPR
LOYALTY PROGRAM	DWD_LYLTY_PRG
LOYALTY PROGRAM	DWB_LYLTY_PRG
MARKETAREAS	DWM_MKTAREAS
NON FREQUENT FLIER MINING	DWD_NON_FFP_MNNG
ODT ACCOUNT	DWR_ODT_ACCT
OPTION	DWR_OPTN
PARTNER EARNING	DWB_PTNR_ERNG
PARTY	DWR_PRTY
PARTY INTERACTION	DWB_PRTY_INTRATN
PARTY INTERACTION CALL	DWB_PRTY_INTRATN_CALL
PARTY INTERACTION EMAIL	DWB_PRTY_INTRATN_EML
PARTY INTERACTION FAX	DWB_PRTY_INTRATN_FAX
PARTY INTERACTION ITEM	DWB_PRTY_INTRATN_ITEM
PARTY INTERACTION ITEM STATUS	DWL_PRTY_INTRATN_ITEM_STS
PARTY INTERACTION LETTER	DWB_PRTY_INTRATN_LETR
PARTY INTERACTION SMS	DWB_PRTY_INTRATN_SMS
PARTY INTERACTION THREAD	DWB_PRTY_INTRATN_THRD
PARTY INTERACTION VISIT	DWB_PRTY_INTRATN_VST
PARTY STATUS	DWL_PRTY_STS
PASSENGER CONTACT	DWR_PAX_CNTCT
PASSENGER COUNTRY ADDRESS INFORMATION	DWR_PAX_CTRY_ADDR_INFO
PASSENGER NAME RECORD	DWB_PNR
PASSENGER NAME RECORD	DWD_PNR
PASSENGER NAME RECORD TYPE	DWL_PNR_TYP
PASSENGER VISA INFORMATION	DWR_PAX_VISA_INFO
PDI	DWB_PDI
PDI CHANNEL	DWL_PDI_CHNL
PDI CHANNEL	DWM_PDI_CHNL
PDI CHARACTERISTIC	DWR_PDI_CHRSTIC
PNR PARENT CHILD RELATIONSHIP	DWR_PNR_PARENT_CHILD_RELSHP
POINT OF SALE GDS OFFICE	DWR_POS_GDS_OFF
ROUTEPAIRS	DWM_ROUTEPAIRS
ROUTES	DWM_ROUTES
SALES CHANNEL	DWM_SALES_CHNL
SALES CHANNEL	DWL_SALES_CHNL
SEAT	DWR_SEAT
SEGMENT	DWR_SEG
SEGMENT	DWM_SEG
SEGMENT PAIR	DWM_SEG_PAIR
SEGMENT SCHEDULE	DWB_SEG_SCHD
SERVICE	DWR_SVC
SERVICE	DWM_SVC
SETTING CUSTOMER DECISION TREE	DM_STNG_CUST_LTY_DT
SETTING CUSTOMER SUPPORT VECTOR MACHINE	DM_STNG_CUST_LTY_SVM
SETTING PROFILE KMEANS	DM_STNG_PROFILE_KMEANS
SETTING USER ALL	DM_STNG_USER_ALL
SMS AGENT	DWR_SMS_AGNT
SMS CUSTOMER	DWR_SMS_CUST
SPECIAL SERVICE REQUEST	DWM_SSR
STATION	DWR_STN
TAS	DWB_TAS
TICKET	DWB_TKT
TICKET	DWD_TKT
TICKET COUPON	DWR_TKT_CPN
TICKET DELIVERY ARRANGEMENT	DWL_TKT_DLVRY_ARNGMNT
TICKET DELIVERY ARRANGEMENT	DWB_TKT_DLVRY_ARNGMNT
TIME	DWM_TM
TOUR	DWB_TOUR
TRAFFIC CATEGORY	DWL_TRAF_CATG
TRAFFIC CATEGORY	DWM_TRAF_CATG
TRANSFER EARNING	DWB_XFER_ERNG
TSM	DWR_TSM
TSM EXCESS BAGGAGE	DWL_TSM_XSB
TSM MCO	DWL_TSM_MCO
TSM PASSENGER	DWR_TSM_PAX
TSM PRICE	DWL_TSM_PRC
TSM ROUTE	DWL_TSM_ROUTE
TSM SERVICE	DWL_TSM_SVC
VEHICLE	DWR_VHCL
VIP PASSENGER INFORMATION	DWR_VIP_PAX_INFO