4 Oracle Airlines Data Modelの論理から物理へのマッピング

この章では、Oracle Airlines Data Modelの論理データ・モデルのエンティティ、および論理エンティティが実装または物理化された物理データベース表またはビューを示します。

この章では、次の項目について説明します。

• Oracle Airlines Data Modelの論理から物理へのマッピング

Oracle Airlines Data Modelの論理から物理へのマッピング

表4-1に、Oracle Airlines Data Modelの論理データ・モデルのエンティティ、および論理エンティティが実装または物理化された物理データベース表またはビューを示します。

表4-1 エンティティのマッピング表: 論理から物理へのマッピング

エンティティ	表またはビュー
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