5 Oracle Airlines Data Model Partitioning

This chapter provides the partitioning strategy for the Oracle Airlines Data Model physical base, derived, and aggregate tables.

This chapter includes the following section:

Partitioning Strategy for Oracle Airlines Data Model

Partitioning Strategy for Oracle Airlines Data Model

Table 5-1 shows the partitioning strategy for the Oracle Airlines Data Model physical base, derived, and aggregate tables.

Table 5-1 Physical Data Model Partitioning

Physical Table Name	Partition Key Column	Partition Level	Default Tablespace Name
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