Provides information about the physical data model of Oracle Airlines Data Model.
oadm_sys schema.Parent topic: Logical and Physical Data Model
Describes the Physical Data Model. The Physical Data Model of Oracle Airlines Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints).
Note:
Do not make changes to the schemas as such changes are not supported.
The following table shows the table name prefix conventions. When you examine the predefined physical model, keep in mind the naming conventions 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 |
|
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 |
|
_VIEW |
Suffix specifies relational views of OLAP cubes, dimensions, or hierarchies. |
Parent topic: Oracle Airlines Data Model Physical Data Model
Lists the reference tables in Oracle Airlines Data Model.
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.
DWR_ACCT
DWR_ACCT_DIM
DWR_ADDR_LOC
DWR_ADDR_LOC_STAT_HIST
DWR_ADDR_RLTD
DWR_AGNCY
DWR_ALTVE_ITEM
DWR_ARCFT
DWR_ARCFT_TYP
DWR_ARCFT_VRSN
DWR_ARCFT_VRSN_DIM
DWR_ARPRT
DWR_ARPRT_DIM
DWR_BASE_DAY
DWR_BKG_CLS
DWR_BKG_CLS_TYP
DWR_BKG_CUST_REF
DWR_BKG_OFFC
DWR_BKG_OFFC_DIM
DWR_BKG_OFFC_USER
DWR_BKG_PROD
DWR_BKG_PROD_DTL
DWR_BKG_PAX
DWR_BKG_PAX_DIM
DWR_BKG_PAX_DOC_INFO
DWR_BKG_SEAT
DWR_BKG_SEAT_PREF
DWR_BKG_SRIS
DWR_BKG_SVNG_AMT
DWR_BKG_TST_DIM
DWR_BLK_LST_HIST
DWR_BNK
DWR_BNK_CARD
DWR_BSNS_HLF_MO
DWR_BSNS_HLF_YR
DWR_BSNS_MO
DWR_BSNS_MO_DIM
DWR_BSNS_QTR
DWR_BSNS_TEN_DAYS_CYCL
DWR_BSNS_UNIT_JB_RL
DWR_BSNS_UNIT_SHFT
DWR_BSNS_YR
DWR_CALL_CNTR
DWR_CALL_CNTR_AGNT
DWR_CALL_CNTR_SRVC_CAPBLTY
DWR_CARRIER
DWR_CARRIER_DIM
DWR_CARRIER_TYP
DWR_CAR_PROD
DWR_CAR_RNTL_MDL
DWR_CDSHR
DWR_CHKIN_BAG_GRP
DWR_CHKIN_INDVL_BAG
DWR_CHNL
DWR_CLNDR
DWR_CLNDR_HLF_MO
DWR_CLNDR_HLF_YR
DWR_CLNDR_QTR
DWR_CLNDR_MO
DWR_CLNDR_WK
DWR_CLNDR_YR
DWR_CMPGN
DWR_CMPGN_MEDIA_SLNG_ITEM
DWR_CMPGN_MGMT_HIST
DWR_CMPGN_MSG
DWR_CMPTR
DWR_CMPTR_INTLGNCE
DWR_CMPTR_INTLGNCE_PRTY_RL
DWR_CMPTR_MKT_SEG_ASGN
DWR_CMPTR_MKT_SEG_SWOT
DWR_CMPTR_PROD_CRLTN
DWR_CMPTR_SWOT
DWR_CMPTR_TIER_ASGN
DWR_CMPTVE_TIER
DWR_CNTRS
DWR_COMP_INTL_CHR
DWR_COMP_INTL_CHR_VAL
DWR_COMP_INTL_MKT_SEG
DWR_COMP_PROD_CRRL_CHR_ASGN
DWR_COMP_PROD_CRRL_CHR_VAL
DWR_CRDT_SCR_PRVDR
DWR_CRPRT_BSNS_TYP
DWR_CRPRT_CUST
DWR_CRTFCT
DWR_CST_CNTR
DWR_CUST
DWR_CUST_INDVL
DWR_CUST_OCCSN
DWR_CUST_ORG
DWR_CUST_RSTRCT_INFO
DWR_CUST_RVN_BND_ASGN
DWR_CUST_SCR
DWR_CUST_SEG
DWR_CUST_SEGTN_MDL
DWR_CUST_SRC
DWR_DAY
DWR_DAY_ACT_CNDTN
DWR_DAY_TODATE_TRANS
DWR_DAY_TRANS
DWR_DEMOG_ATRIB
DWR_DEMOG_GRP
DWR_DEPT
DWR_DISC_GRP
DWR_DLR
DWR_DOC
DWR_DRVR_VAL
DWR_EDU
DWR_EML_ADDR
DWR_EMP
DWR_EMP_DISC_GRP_ASGN
DWR_EMP_JB_RL_ASGN
DWR_EMP_LANG_CAPBLTY
DWR_EMP_RSTRCT_INFO
DWR_EMP_SCHL
DWR_EXTRNL_CRDT_PRFL
DWR_EXTRNL_CRDT_PRFL_ASGN
DWR_FARE_ELMNT
DWR_FARE_TYP
DWR_FLT
DWR_FLT_DIM
DWR_FLET_HDRS
DWR_FLT_INV
DWR_FLT_INV_NBR_OF_UNITS
DWR_FLT_INV_OPRN
DWR_FLT_INV_SCHL_ASGN
DWR_FLT_INV_STAT
DWR_FLT_LEG_INV
DWR_FLT_LEG_INV_CBN
DWR_FLT_LEG_INV_CBN_ACV_CONFIG
DWR_FLT_LEG_INV_CBN_BLCKSPC
DWR_FLT_LEG_INV_CBN_RMS
DWR_FLT_LEG_INV_CBN_SLCONFIG
DWR_FLT_LEG_INV_SSR
DWR_FLT_LEG_INV_SSR_OPTN
DWR_FLT_LEG_INV_STAT
DWR_FLT_LEGINV_CBN_SLCNFG_CHR
DWR_FLT_SEG_INV
DWR_FLT_SEG_INVCBN_BRDG_FIGDCS
DWR_FLT_SEG_INV_CBN
DWR_FLT_SEG_INV_CBN_CDSHR
DWR_FLT_SEG_INV_CDSHR
DWR_FLT_SEG_INV_STAT
DWR_FLT_SEG_INV_TRFC_RSTRCT
DWR_FLTSEG_INCBBK_CLS_CSBRDRDC
DWR_FLTSEG_INVCBNBKG_SBC_CNTRS
DWR_FLTSEG_INVCBNBKG_SBC_DTFLG
DWR_FLTSEG_INVCBN_BKGCLS_CSRDC
DWR_FLTSEG_INVCNBKG_SBC_AVLBTY
DWR_FLTSEG_INV_CBNBKG_CLS
DWR_FLTSEG_INV_CBNBKG_CLS_STAT
DWR_FLTSEG_INV_CBNBKG_SBC
DWR_FLTSEG_INV_CBNBKG_SBC_NEGO
DWR_FLTSEG_INV_CBN_BKG_SBC_FLG
DWR_FLTSEG_INV_CBN_BKG_SBC_YLD
DWR_FLTSEG_IVCN_BGCS_BDFIG_DCS
DWR_FLTSEG_IVCN_CDSR_BLKSC_CTR
DWR_FORM_OF_PYMT
DWR_FREQ_FLYR
DWR_FREQ_FLYR_DIM
DWR_FREQ_FLYR_PREF
DWR_FSCL_HLF_MO
DWR_FSCL_HLF_YR
DWR_FSCL_MO
DWR_FSCL_QTR
DWR_FSCL_WK
DWR_FSCL_YR
DWR_GEO
DWR_GEO_DEMOG_ATRIB
DWR_GEO_DEMOG_GRP
DWR_GEO_DEMOG_VAL
DWR_GEO_ENT
DWR_GEO_HRCHY
DWR_GEO_HRCHY_LVL
DWR_GEO_HRCHY_LVL_ASGN
DWR_GEO_HRCHY_VRSN
DWR_GEO_LVL
DWR_GEO_LVL_ATRIB
DWR_GEO_LVL_ATRIB_VAL
DWR_GNDR
DWR_HLF_HR
DWR_HLF_MO_TODATE_TRANS
DWR_HLF_MO_TRANS
DWR_HLF_YR_TODATE_TRANS
DWR_HLF_YR_TRANS
DWR_HR
DWR_HSHLD
DWR_HTL_BKG
DWR_HTL_BKG_BILLBL_INFO
DWR_HTL_BKG_CNCT
DWR_HTL_BKG_FORM_OF_PYMT
DWR_HTL_BKG_MISC_RMRK
DWR_HTL_BKG_OPTN_TXT
DWR_HTL_BKG_STAT
DWR_HTL_FCLTY
DWR_HTL_PROD
DWR_HTL_PROD_AMNTY
DWR_HTL_PYMT
DWR_HTL_RM
DWR_HTL_TRF
DWR_HTL_TRF_CHRG
DWR_INDVL_DEMOG_VAL
DWR_INDVL_NAME
DWR_INFLT_MEAL
DWR_INTRACN_RSLT
DWR_INTRACN_RSLT_DIM
DWR_INTRACN_RSN
DWR_INTRACN_RSN_DIM
DWR_INTRACN_RSN_H
DWR_ITEM
DWR_ITEM_SEASON
DWR_JB
DWR_JB_RL
DWR_LANG_DILCT
DWR_LCL_TAX_AUTHRTY
DWR_LEG
DWR_LEG_DIM
DWR_LOT_NBR
DWR_LYLTY_ACCT
DWR_LYLTY_LVL
DWR_LYLTY_LVL_DIM
DWR_LYLTY_PROG
DWR_LYLTY_PROG_DIM
DWR_MBRSHIP_ACCT
DWR_MEDIA_OBJ
DWR_MEL
DWR_MFG_PART_NBR
DWR_MISCLNS_RMRK
DWR_MKT_AREA
DWR_MKT_AREA_DIM
DWR_MKT_AREA_LVL
DWR_MKT_SEG
DWR_MKT_SEG_CHR
DWR_MKT_SEG_CHR_VAL
DWR_MKT_STTSTC
DWR_MKT_STTSTC_INCLSN
DWR_MO_TODATE_TRANS
DWR_MO_TRANS
DWR_MR_EFCTVTY_DTLS
DWR_MRO_RESRE
DWR_MSTR_CNFGRTN_HDR
DWR_MTL_MNFCTR
DWR_ODT_ACCT
DWR_OPTN
DWR_ORG
DWR_ORG_AREA
DWR_ORG_BNR
DWR_ORG_BSNS_ENT
DWR_ORG_BSNS_UNIT
DWR_ORG_CHAIN
DWR_ORG_CMPNY
DWR_ORG_CRPRT
DWR_ORG_DSTRCT
DWR_ORG_HRCHY
DWR_ORG_HRCHY_LVL
DWR_ORG_HRCHY_LVL_ASGN
DWR_ORG_HRCHY_VRSN
DWR_ORG_LVL
DWR_ORG_LVL_ATRIB
DWR_ORG_LVL_ATRIB_VAL
DWR_ORG_MKT_DATA
DWR_ORG_NAME
DWR_ORG_RGN
DWR_ORG_SRVC_WBSITE
DWR_ORG_WRHS
DWR_ORGNTL_DEMOG_VAL
DWR_OTHR_INDVL
DWR_PART_LOC
DWR_PASPRT
DWR_PAX_CNCT
DWR_PAX_CPN_DATA
DWR_PAX_INVC_HDR
DWR_PDI_CHR
DWR_PDI_CHNL
DWR_PDI_CHNL_DIM
DWR_PHS
DWR_PLNG_QTR
DWR_PLNG_SEASON
DWR_PLNG_WK
DWR_PLNG_YR
DWR_PNR
DWR_PNR_DIM
DWR_PNR_TYP
DWR_POS_DEPT
DWR_POS_GDS_OFFC
DWR_POS_ID
DWR_POSTCD
DWR_PRC_DRVTN_RULE
DWR_PRD_TODATE_TRANS
DWR_PRD_TRANS
DWR_PREF_TYP
DWR_PRFL_SRC
DWR_PRMTN
DWR_PRMTN_ITEM
DWR_PRMTN_MSG_RNDRNG
DWR_PRMTN_PROD_OFRNG_ASGN
DWR_PRMTN_SLNG_ITEM
DWR_PROD_ENT
DWR_PROD_OFRNG
DWR_PRSPCT
DWR_PRSPCT_INDVL
DWR_PRSPCT_ORG
DWR_PRTNR_PRMTN_PROG
DWR_PRTY
DWR_PRTY_ACCT_ASGN
DWR_PRTY_ADDR_LOC_ASGN
DWR_PRTY_ASGN
DWR_PRTY_CNCT_INFO
DWR_PRTY_CNCT_LST_PRTCPTN
DWR_PRTY_DEMOG
DWR_PRTY_DEMOG_VAL
DWR_PRTY_GEO_ENT_ASGN
DWR_PRTY_ID
DWR_PRTY_INTRACN_STAT
DWR_PRTY_LANG_CAPBLTY
DWR_PRTY_NAME
DWR_PRTY_RL
DWR_PRTY_RL_ASGN
DWR_PRTY_SKILL
DWR_PRTY_STAT
DWR_PRTY_STAT_DIM
DWR_QTR_TODATE_TRANS
DWR_QTR_TRANS
DWR_QLTY_PLN
DWR_RLGN
DWR_RL_HRCHY
DWR_ROUTEPAIRS
DWR_ROUTES
DWR_RPR_CTGRS
DWR_RTL_SEASON
DWR_RTL_STORE
DWR_SCND
DWR_SEG
DWR_SEG_CRTRA
DWR_SEG_DIM
DWR_SEG_PAIR
DWR_SKU_ITEM
DWR_SL_CHNL
DWR_SL_CHNL_RPRSTV
DWR_SL_FRCST_ITEM_ORG_HRCHY_WK
DWR_SL_OR_RETRN_ACTN
DWR_SL_PLN_ITEM_ORG_HRCHY_WK
DWR_SL_RSTRCT
DWR_SLNG_LOC
DWR_SOC_JB
DWR_SRC_SYS
DWR_SRC_SYS_KEY_MAPNG
DWR_SRVC
DWR_SRVC_COVRG_AREA
DWR_SRVC_COVRG_GEO_DTL
DWR_SRVC_DIM
DWR_SSR
DWR_SUPLIR
DWR_TAXBL_GRP
DWR_TIME
DWR_TIME_DIM
DWR_TIME_STNDRD_BY_DAY
DWR_TIME_STNDRD_BY_WK
DWR_TIME_TOT
DWR_TIME_ZN
DWR_TRFC_CTGRY
DWR_TRFC_CTGRY_DIM
DWR_TRGT_ACCS_MTHD
DWR_TRGT_ACCT
DWR_TRGT_GEO_AREA
DWR_TRML
DWR_TSK_ASGN
DWR_TSM_PAX
DWR_TSM_EXCSS_BAG
DWR_TSM_MCO
DWR_TSM_PRC
DWR_TSM_ROUTE
DWR_TSM_SRVC
DWR_UNIT_ACMPLSHMNTS
DWR_UNIT_CNFGRTN_HDR
DWR_UNIT_CNFGRTN_HIST
DWR_UNIT_DFRLS
DWR_UNIT_MNTNCE_PLN
DWR_UNIT_MNTNCE_PLN_CNTR_HIST
DWR_UNT_MNTNC_PLN_THSLD_RLE
DWR_USER
DWR_VHCL
DWR_VRTL_TEAM
DWR_WKDAY
DWR_WK_TODATE_TRANS
DWR_WK_TRANS
DWR_WO_OPRN
DWR_WRNTY_ENTLMNTS
Related Topics
Parent topic: Oracle Airlines Data Model Physical Data Model
Lists the base tables in Oracle Airlines Data Model.
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.
DWB_ACCT_LVL_HIST
DWB_ACCT_PYMT
DWB_AWRD_VCHR
DWB_ACCT_TRNSFR
DWB_ARCFT_DSPTCH
DWB_ARCFT_TRN_ARND
DWB_ASSET_DATA_DRFT
DWB_BKG
DWB_BKG_AGNT_OPT_LN
DWB_BKG_BLLG
DWB_BKG_CMPGN_ASGN
DWB_BKG_OTHR_SRVC
DWB_BKG_RMRK
DWB_BKG_SSR
DWB_BKG_SSR_BRDG
DWB_BKG_STAT_CHNG_HIST
DWB_BKG_TST
DWB_BKG_TST_FARE_DATA
DWB_BKG_TST_PFC_TAX_AMT
DWB_BKG_TST_PRC
DWB_BKG_TST_SEG
DWB_BKG_TST_TAX
DWB_BLLG_ANLYS_HDR
DWB_BLLG_ANLYS_TOT_CRNCY
DWB_BLLG_OFFC_HDR
DWB_BLLG_OFFC_SBTOT_TRX_CRNCY
DWB_BLLG_OFFC_TOT_CRNCY
DWB_BLLG_TRX_AGNCY_ARLN_INFO
DWB_BLLG_TRX_CMPLT_FORMOF_PYMT
DWB_BLLG_TRX_CMPLT_TCKT_DOC
DWB_BLLG_TRX_CPN_ADDL_PRINT_LN
DWB_BLLG_TRX_DOC_AMT
DWB_BLLG_TRX_ELCTRNC_TRX
DWB_BLLG_TRX_EMD_CPN_DTL
DWB_BLLG_TRX_EMD_RMRK
DWB_BLLG_TRX_FARE_CALC
DWB_BLLG_TRX_FL_TOT_CRNCY
DWB_BLLG_TRX_FORM_OF_PYMT
DWB_BLLG_TRX_HDR
DWB_BLLG_TRX_MD_ADDL_INFO
DWB_BLLG_TRX_MD_INFO_AMT
DWB_BLLG_TRX_MD_ISSNCE_RSN
DWB_BLLG_TRX_NETNG_VAL
DWB_BLLG_TRX_PYMT_ATHRZTN
DWB_BLLG_TRX_RLTD_TCKT
DWB_BLLG_TRX_TCKT
DWB_BLLG_TRX_TCKT_AMT
DWB_BLLG_TRX_TCKT_CMISN
DWB_BLLG_TRX_TCKT_FORM_OF_PYMT
DWB_BLLG_TRX_TCKT_PAX
DWB_BLLG_TRX_TCKT_TAX_ON_CMISN
DWB_BLLG_TRX_TCKT_VAT_INFO
DWB_BRRW_TRNS
DWB_BT_PRPD_TCKT_ADC_SPNSR_INF
DWB_BT_TCKT_ITNRY_DATA_SEG
DWB_BT_TCKT_MISCLNSADDL_PRNTLN
DWB_BT_TCKT_QLFYNG_ISSUE_INFO
DWB_CAR_RNTL
DWB_CAR_RNTL_ADDL_RT_CD_INFO
DWB_CAR_RNTL_CHRG_PRD
DWB_CAR_RNTL_ESTM_DISTNC
DWB_CAR_RNTL_FOP
DWB_CAR_RNTL_LOC
DWB_CAR_RNTL_OTHR_RT_RULE
DWB_CAR_RNTL_OTHR_RT_RULE_DT
DWB_CAR_RNTL_PREF_TYP
DWB_CAR_RNTL_RMRK
DWB_CAR_RNTL_SRCHRG_RPD
DWB_CAR_RNTL_SRCHRG_RPD_TRFC
DWB_CAR_RNTL_TRFC
DWB_CAR_RNTL_TRFC_CHRG
DWB_CDSHR_BRDG
DWB_CHKIN
DWB_CMNSTRY_ERNG
DWB_CMPLN_ADVC
DWB_CST
DWB_CUST_ORDR
DWB_CUST_ORDR_LN_ITEM
DWB_DELAY_AND_CNCL
DWB_DRCT_ERNG
DWB_DSPSTNS
DWB_EMP_ACT_LBR_HRLY
DWB_EMP_ACT_LBR_SLRED
DWB_EMP_TRNG_REC
DWB_ERNG_EVT
DWB_EVT
DWB_EVT_PRTY_ASGN
DWB_EVT_PRTY_INTRACN
DWB_FLET_UNIT_ASSOCT
DWB_FLT_CHNG
DWB_FLT_DATA_DRFT
DWB_FLT_GTE_OPRN
DWB_FLT_SCHL
DWB_GRPNG
DWB_HOT_FL_HDR
DWB_HTL_BKG_CMISN
DWB_LEG_SCHL
DWB_LG_BK
DWB_LYLTY_ACCT_BAL_HIST
DWB_LYLTY_ACCT_LVL_HIST
DWB_LYLTY_CNVRSN
DWB_LYLTY_PTS_EXP
DWB_MEL_CDL_PROC
DWB_MIN_CNCTNG_TMS
DWB_MNTNCE_REQRMNT
DWB_MNTNCE_VST
DWB_MNTNCE_VST_TSK
DWB_MR_EFCTVTY
DWB_MR_INTRVL
DWB_MTRL_TRNS
DWB_NON_RUTNE
DWB_OPRN
DWB_OPRN_MTRL
DWB_OPRN_RESRE
DWB_OUTSD_PRCSNG_ORDR
DWB_PART
DWB_PART_CHNG
DWB_PART_SRL_NBR
DWB_PAX_CNTRY_ADDR_INFO
DWB_PAX_TRNSFR
DWB_PAX_VISA_INFO
DWB_PDH_H
DWB_PNR_GDS_INFO
DWB_PNR_PRNT_CHILD_RLTN
DWB_PNR_RLTN
DWB_PRC_MDFCTN_LN_ITEM
DWB_PCHSE_ORDR
DWB_PRMTN_CLSTR_USG
DWB_PRMTN_MGMT_HIST
DWB_PROJ
DWB_PROJ_ALL
DWB_PRTNR_ERNG
DWB_PRTY_CST_ASGN
DWB_PRTY_INTRACN
DWB_PRTY_INTRACN_CALL
DWB_PRTY_INTRACN_EML
DWB_PRTY_INTRACN_FAX
DWB_PRTY_INTRACN_ITEM
DWB_PRTY_INTRACN_LTTR
DWB_PRTY_INTRACN_SMS
DWB_PRTY_INTRACN_THRD
DWB_PRTY_INTRACN_VST
DWB_PRTY_ORDR_ASGN
DWB_PRTY_PRMTN_RESPN
DWB_PRTY_STAT_HIST
DWB_QLTY_RSLT
DWB_RTL_CST_TRX
DWB_RTL_SL_RETRN_LN_ITEM
DWB_RTL_TRX
DWB_RTL_TRX_LN_ITEM
DWB_RUTNE
DWB_RVN_CST_TRX
DWB_SCRP_VAL
DWB_SHOP_FNDNGS
DWB_SEG_SCHL
DWB_TAX_LN_ITEM
DWB_TCKT
DWB_TCKT_CPN
DWB_TCKT_DLVRY_ARNGMNT
DWB_TCKT_PRC
DWB_TCKT_PRCNG_DISC
DWB_TCKT_PRCNG_DISC_DTLS
DWB_TCKTNG_FORM_OF_PYMT
DWB_TRCKD_ITEM
DWB_TSK_EFCTVTY
DWB_TSK_LST
DWB_TSM
DWB_TOUR
DWB_TRNSFR_ERNG
DWB_TSM_DOC
DWB_TSM_MCO_FARES
DWB_TSM_MCO_TAX
DWB_TSM_PYMT
DWB_TSM_RFI
DWB_TSM_XSB_RT
DWB_UNIT_EFCTVTS
DWB_UNIT_SCHL
DWB_WEATHR
DWB_WO
Related Topics
Parent topic: Oracle Airlines Data Model Physical Data Model
Lists the derived tables in Oracle Airlines Data Model.
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 Oracle Airlines Data Model:
Tables that hold the results of a calculation.
Result tables for the data mining models.
DWD_BKG_FCT
DWD_CALL_CNTR_PRFMNC
DWD_CHKIN
DWD_CUST_LTV_SVM_FACTOR
DWD_CUST_LYLTY_DT_RULES
DWD_CUST_LYLTY_SVM_FACTOR
DWD_CUST_MNNG
DWD_CUST_RFMP_SCR
DWD_CUST_SRVY
DWD_FFP_PRED_DT_RULES
DWD_FFP_PRED_SVM_FACTOR
DWD_FLT_DTLS
DWD_FLT_OPRN
DWD_LYLTY_ACCT_BAL_HIST
DWD_LYLTY_ACCT_LVL_HIST
DWD_NON_FFP_MNNG
DWD_NON_RUTNE
DWD_PNR
DWD_RVN_CST
DWD_TCKT
Related Topics
Parent topic: Oracle Airlines Data Model Physical Data Model
Lists the aggregate tables in Oracle Airlines Data Model.
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 a derived table. The aggregate tables provide a view of the data similar to the view provided by a fact table in a snowflake schema.
DWA_BKG_DLY_INV_SNPST
DWA_CDSHR_BRDG
DWA_CHKIN_DLY
DWA_CUST_SRVY
DWA_DLY_BKG
DWA_DLY_CALL_CNTR_PRFMNC
DWA_DLY_LYLTY_ACCT
DWA_DLY_LYLTY_ACCT_BKG
Related Topics
Parent topic: Oracle Airlines Data Model Physical Data Model
Lists the lookup tables in Oracle Airlines Data Model
Lookup Tables List
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.
DWL_ACCT_LVL
DWL_ACCT_TRNSFR_RSN
DWL_ACCT_TYP
DWL_ADDR_TYP
DWL_AMT_TYP
DWL_ATA_CHPTR
DWL_BKG_PROD_TYP
DWL_BKG_STAT_CHNG_RSN
DWL_BNK_CARD_TYP
DWL_BNNING_RSN
DWL_BSNS_LEGAL_STAT
DWL_CMNSTRY_RSN
DWL_CMPGN_STAT
DWL_CMPGN_TYP
DWL_CMPLN_CLS
DWL_CMPLN_TYP
DWL_CRNCY
DWL_CUST_OCCSN_TYP
DWL_CUST_RVN_BND
DWL_CUST_RVN_TYP
DWL_CUST_TYP
DWL_DELAY_CAUSE
DWL_DFCT_STAT
DWL_EMP_DESIG
DWL_EMP_TYP
DWL_EXTRNL_ORG_TYP
DWL_FLET
DWL_FLT_CNCL_RSN
DWL_FLT_INV_OPRN_TYP
DWL_INTTV_RSLT_TYP
DWL_INTTV_TYP
DWL_LANG
DWL_LCL_AUTHRTY_TYP
DWL_LEG_TYP
DWL_LTTR_TYP
DWL_MEL_ATTR
DWL_MNTNCE_TYP
DWL_MRTL_STAT
DWL_NTNLTY
DWL_ORG_BSNS_UNIT_TYP
DWL_PRMTN_TYP
DWL_PRTY_CNCT_INFO_TYP
DWL_PRTY_ID_TYP
DWL_PRTY_STAT_CHNG_RSN
DWL_PRTY_STAT_TYP
DWL_PRTY_TYP
DWL_RCTFCATN_INTRVL
DWL_RVN_CST_ELMNT
DWL_RVN_CST_ELMNT_CTGRY
DWL_RVN_CST_ELMNT_GRP
DWL_SEASON
DWL_SKILL_TYP
DWL_SLNG_LOC_TYP
DWL_SWOT_TYP
DWL_TIME_PRD
DWL_TRGT_TYP
DWL_TRVL_CLS
DWL_TRX_TYP
DWL_VAL_TYP
Related Topics
Parent topic: Oracle Airlines Data Model Physical Data Model
Lists the Data Mining control and Data Mining settings tables in Oracle Airlines Data Model.
Data Mining and Data Mining Settings Tables
DM_STNG_CUST_LTY_DT
DM_STNG_CUST_LTY_SVM
DM_STNG_PROFILE_KMEANS
DM_STNG_USER_ALL
DMV_BKG_FACT_APPLY
DMV_BKG_FACT_SRC
DMV_CUST_LOYALTY_APPLY
DMV_CUST_LOYALTY_SRC
DMV_CUST_LTV_APPLY
DMV_CUST_LTV_SRC
DMV_CUST_PROFILE_APPLY
DMV_CUST_PROFILE_SRC
DMV_FFP_PRED_APPLY
DMV_FFP_PRED_SRC
DMV_LYLTY_ACCT_BAL_APPLY
DMV_LYLTY_ACCT_BAL_SRC
Related Topics
Parent topic: Oracle Airlines Data Model Physical Data Model
Lists the Sequence Names in Oracle Airlines Data Model.
Table 3-2 Database Sequences List
| 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 |
Parent topic: Oracle Airlines Data Model Physical Data Model
Lists the Metadata tables in Oracle Airlines Data Model.
Table 3-3 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. |
Parent topic: Oracle Airlines Data Model Physical Data Model
Lists the cube materialized views in the oadm_sys schema.
The following table shows the OLAP materialized views in oadm_sys schema:
Table 3-4 OLAP Cube Materialized Views in oadm_sys Schema
| Cube Materialized View Name | OLAP Object Name | OLAP Object Type |
|---|---|---|
|
CB$BKCLS_HBKCLS |
BKCLS_HBKCLS |
Dimension_Hierarchy |
|
CB$BKOFC_HCNTYP |
BKOFC_HCNTYP |
Dimension_Hierarchy |
|
CB$BKOFC_HBKOFC |
BKOFC_HBKOFC |
Dimension_Hierarchy |
|
CB$BSDF |
BSDF |
Cube |
|
CB$BSDF_F |
BSDF_F |
Cube |
|
CB$CCPF |
CCPF |
Cube |
|
CB$CSDF |
CSDF |
Cube |
|
CB$FDDF |
FDDF |
Cube |
|
CB$GEO_HGEO |
GEO_HGEO |
Dimension_Hierarchy |
|
CB$IRSN_HIRSN |
IRSN_HIRSN |
Dimension_Hierarchy |
|
CB$LOYLV_HLOYLY |
LOYLV_HLOYLY |
Dimension_Hierarchy |
|
CB$LYAF |
LYAF |
Cube |
|
CB$LYBF |
LYBF |
Cube |
|
CB$OPFLT_HOPFLT |
OPFLT_HOPFLT |
Dimension_Hierarchy |
|
CB$OPSMT_HOPSMT |
OPSMT_HOPSMT |
Dimension_Hierarchy |
|
CB$ROUTE_HROUTE |
ROUTE_HROUTE |
Dimension_Hierarchy |
|
CB$SRVC_HSRVC |
SRVC |
Dimension_Hierarchy |
|
CB$TIME_HTIME |
TIME_HTIME |
Dimension_Hierarchy |
|
CB$TIME_HWEEK |
TIME_HWEEK |
Dimension_Hierarchy |
The following table shows the OLAP cube views in oadm_sys schema:
Table 3-5 OLAP Cube Views in oadm_sys schema
| Cube View Name | OLAP Object Name | OLAP Object Type |
|---|---|---|
|
BKCLS_HBKCLS_VIEW |
BKCLS_HBKCLS |
Hierarchy |
|
BKCLS_VIEW |
BKCLS |
Dimension |
|
BKOFC_HCNTYP_VIEW |
BKOFC_HCNTYP |
Hierarchy |
|
BKOFC_HBKOFC_VIEW |
BKOFC_HBKOFC |
Hierarchy |
|
BKOFC_VIEW |
BKOFC |
Dimension |
|
BSDF_VIEW |
BSDF |
Cube |
|
BSDF_F_VIEW |
BSDF_F |
Cube |
|
CCPF_VIEW |
CCPF |
Cube |
|
CSDF_VIEW |
CSDF |
Cube |
|
FDDF_VIEW |
FDDF |
Cube |
|
GEO_HGEO_VIEW |
GEO_HGEO |
Hierarchy |
|
GEO_VIEW |
GEO |
Dimension |
|
IRSN_HIRSN_VIEW |
IRSN_HIRSN |
Hierarchy |
|
IRSN_VIEW |
IRSN |
Dimension |
|
LOYLV_HLOYLY_VIEW |
LOYLV_HLOYLY |
Hierarchy |
|
LOYLV_VIEW |
LOYLV |
Dimension |
|
LYAF_VIEW |
LYAF |
Cube |
|
LYBF_VIEW |
LYBF |
Cube |
|
OPFLT_HOPFLT_VIEW |
OPFLT_HOPFLT |
Hierarchy |
|
OPFLT_VIEW |
OPFLT |
Dimension |
|
OPSMT_HOPSMT_VIEW |
OPSMT_HOPSMT |
Hierarchy |
|
OPSMT_VIEW |
OPSMT |
Dimension |
|
ROUTE_HROUTE_VIEW |
ROUTE_HROUTE |
Hierarchy |
|
ROUTE_VIEW |
ROUTE |
Dimension |
|
SRVC_HSRVC_VIEW |
SRVC |
Hierarchy |
|
SRVC_VIEW |
SRVC |
Dimension |
|
TIME_HTIME_VIEW |
TIME_HTIME |
Hierarchy |
|
TIME_HWEEK_VIEW |
TIME_HWEEK |
Hierarchy |
|
TIME_VIEW |
TIME |
Dimension |
Parent topic: Oracle Airlines Data Model Physical Data Model