| Oracle® Airlines Data Modelリファレンス 11gリリース2 (11.2) B72453-01 |
|
 前 |
 次 |
この章では、Oracle Airlines Data Modelの物理実表、導出表および集計表のパーティション戦略を示します。
この章では、次の項目について説明します。
表5-1に、Oracle Airlines Data Modelの物理実表、導出表および集計表のパーティション戦略を示します。
表5-1 物理データ・モデルのパーティション
| 物理表名 | パーティション・キー列 | パーティション・レベル | デフォルトの表領域名 |
|---|---|---|---|
|
DWA_BKG_DLY_INVT_SNPST |
BKG_DT_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_CHKIN_DLY_FACT |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_CUST_SRVY |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_BKG_FACT |
BKG_DT_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_CALL_CNTR_PRFMNC |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_FLT_DETLS |
FLT_DT_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_LYLTY_ACCT |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWA_DLY_LYLTY_ACCT_BKG |
CLNDR_KEY |
QUARTER |
TBS_AGGREGATE |
|
DWB_ACCT_LVL_HIST |
VLD_DT |
MONTH |
TBS_BASE |
|
DWB_ACCT_XFER |
XFER_DT |
MONTH |
TBS_BASE |
|
DWB_BKG |
BKG_CREN_DTTM |
MONTH |
TBS_BASE |
|
DWB_CHKIN |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_CMNSTRY_ERNG |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_CMPL_ADVC |
ACPT_DT |
MONTH |
TBS_BASE |
|
DWB_CMPL_ADVC_H |
ACPT_DT |
MONTH |
TBS_BASE |
|
DWB_DIRCT_ERNG |
FLT_DT |
MONTH |
TBS_BASE |
|
DWB_ERNG_EVNT |
ERNG_EVNT_DT_TM |
MONTH |
TBS_BASE |
|
DWB_FLT_CHNG |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_FLT_CHNG_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_FLT_SCHD |
FLT_DT |
MONTH |
TBS_BASE |
|
DWB_LYLTY_ACCT_BAL_HIST |
BAL_DT |
MONTH |
TBS_BASE |
|
DWB_LYLTY_ACCT_LVL_HIST |
VLD_DT |
MONTH |
TBS_BASE |
|
DWB_LYLTY_CONV |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_LYLTY_PNTS_EXPR_H |
EXPIRE_EVNT_DT |
MONTH |
TBS_BASE |
|
DWB_LYLTY_PRG |
LYLTY_PRG_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_PDI |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PNR |
PNR_CRE_DTTM |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN |
INTRATN_EVNT_DT_AND_TM |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_CALL |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_CALL_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_EML |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_EML_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_FAX |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_FAX_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_H |
INTRATN_EVNT_DT_AND_TM |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_ITEM |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_ITEM_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_LETR |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_LETR_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_SMS |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_THRD |
INTRATN_THREAD_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_THRD_H |
INTRATN_THREAD_STRT_DT |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_VISIT |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PRTY_INTRATN_VISIT_H |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_PTNR_ERNG |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWB_SEG_SCHD |
SCHD_SEG_ARVL_DT_TM_LCL |
MONTH |
TBS_BASE |
|
DWB_SEG_SCHD_H |
SCHD_SEG_ARVL_DT_TM_LCL |
MONTH |
TBS_BASE |
|
DWB_TKT |
TKT_ISNG_DT |
MONTH |
TBS_BASE |
|
DWB_XFER_ERNG |
SRC_SYS_CRE_TMSTMP |
MONTH |
TBS_BASE |
|
DWD_BKG_FACT |
OPRTNG_SEG_DEPTR_LCL_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_CALL_CNTR_PRFMNC |
INTRATN_EVNT_DTTM_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_CHKIN_FACT |
CLNDR_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_CUST_SRVY |
INTRATN_THREAD_STRT_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_FLT_DETLS_FACT |
ARVL_LCL_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_LYLTY_ACCT_BAL_HIST |
CREATE_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_LYLTY_ACCT_LVL_HIST |
VLD_DT_KEY |
QUARTER |
TBS_DERIVED |
|
DWD_LYLTY_PRG |
LYLTY_PRG_STRT_DT |
MONTH |
TBS_DERIVED |
|
DWD_PNR |
PNR_CRE_DTTM |
MONTH |
TBS_DERIVED |
|
DWD_TKT |
DT_OF_ISS |
MONTH |
TBS_DERIVED |
