Skip Headers
Oracle® Communications Data Model Reference
Release 11.3.1

Part Number E28440-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

6 Oracle Communications Data Model Partitioning

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

This chapter includes the following section:

About Oracle Communications Data Model Partitioning, Compression, and Parallelism

All base, derived, and aggregate tables are partitioned, with the (standard) compression and parallel option activated by default. These tables are partitioned due to their nature (size) for performance and scalability and to improve performance. The default partition method used is INTERVAL partitioning, which creates automatically equi-sized partitions as data arrives. For partitioning, usually, a column of data type DATE is used (DAY or MONTH level).

If Exadata is used with the Hybrid Columnar Compression option, the option is leveraged for use with Oracle Communications Data Model.

For more information, see Oracle Communications Data Model Implementation and Operations Guide.

Partitioning Strategy for Oracle Communications Data Model

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

Table 6-1 Physical Data Model Partitioning

Physical Table Name Partition Key Column Partition Level Default Tablespace Name

DWA_ACCT_DEBT_MO

DT

Quarter

TBS_MV

DWA_ACCT_PYMT_MO

DT

Quarter

TBS_MV

DWA_ACCT_PYMT_MTHD_STAT_HIST

DT

Quarter

TBS_MV

DWA_ACCT_RFND_MO

DT

Quarter

TBS_MV

DWA_ACCT_STAT_TYP

DT

Quarter

TBS_MV

DWA_ACCT_STTSTC_TYP

DT

Quarter

TBS_MV

DWA_ARPU_BASE_CUST_TYP

DT

Quarter

TBS_MV

DWA_BER_FER_ERR_RATIO_MO

DT

Quarter

TBS_MV

DWA_CALL_CNTR_CALL_MO

DT

Quarter

TBS_MV

DWA_CALL_CNTR_CASE_MO

DT

Quarter

TBS_MV

DWA_CANBLZTN_DTL_MO

DT

Quarter

TBS_MV

DWA_CELL_STTSTC_MO

DT

Quarter

TBS_MV

DWA_CMISN_MO

DT

Quarter

TBS_MV

DWA_CNCT_DSCNCT_MO

DT

Quarter

TBS_MV

DWA_CNRT_MO

DT

Quarter

TBS_MV

DWA_COST_CUST_MO

DT

Quarter

TBS_MV

DWA_COST_ORG_MO

DT

Quarter

TBS_MV

DWA_CRDT_CTGRY_MO

DT

Quarter

TBS_MV

DWA_CUST_ACQSTN_SUMM_MO

DT

Quarter

TBS_MV

DWA_CUST_DEBT_COLLCTN_MO

DT

Quarter

TBS_MV

DWA_CUST_EQPMNT_INSTLTN_MO

DT

Quarter

TBS_MV

DWA_DATA_USG_MO

DT

Quarter

TBS_MV

DWA_EXTRNL_DEBT_COLLCTN_MO

DT

Quarter

TBS_MV

DWA_GIVE_AWAY_ITEM_MO

DT

Quarter

TBS_MV

DWA_GPRS_PCU_MO

DT

Quarter

TBS_MV

DWA_GPRS_SRVCS_MO

DT

Quarter

TBS_MV

DWA_HNDST_STCK_MO

DT

Quarter

TBS_MV

DWA_HNDST_SUBSDY_MO

DT

Quarter

TBS_MV

DWA_INTRNL_DEBT_COLLCTN_MO

DT

Quarter

TBS_MV

DWA_INVC_ADJ_MO

DT

Quarter

TBS_MV

DWA_INVC_CUST_TYP

DT

Quarter

TBS_MV

DWA_IN_PLTFRM_MO

DT

Quarter

TBS_MV

DWA_LN_ACTVTN_TMNT_MO

DT

Quarter

TBS_MV

DWA_LYLTY_PROG_MO

DT

Quarter

TBS_MV

DWA_MKT_SHARE

DT

Quarter

TBS_MV

DWA_MSC_TRFC_MO

DT

Quarter

TBS_MV

DWA_NBR_PRT_MO

DT

Quarter

TBS_MV

DWA_NTWK_AVLBLTY_MO

DT

Quarter

TBS_MV

DWA_NTWK_TCHPNT_MO

DT

Quarter

TBS_MV

DWA_PRPD_ACCT_STTSTC_SGMNT

DT

Quarter

TBS_MV

DWA_PRPD_ALWNCE_MO

DT

Quarter

TBS_MV

DWA_PRPD_CALL_SUMM_MO

DT

Quarter

TBS_MV

DWA_PRTNR_STLMNT_MO

DT

Quarter

TBS_MV

DWA_PYMT_AGNG_MO

DT

Quarter

TBS_MV

DWA_RDMPTN_MO

DT

Quarter

TBS_MV

DWA_RF_NTWK_CPCTY_MO

DT

Quarter

TBS_MV

DWA_SHARED_PKG_USG_STTSTC_MO

DT

Quarter

TBS_MV

DWA_SHOP_EFFNCY_MO

DT

Quarter

TBS_MV

DWA_SL_CMPGN_SUMM_MO

DT

Quarter

TBS_MV

DWA_SL_MO

DT

Quarter

TBS_MV

DWA_SPLMNTR_SRVC_USG_MO

DT

Quarter

TBS_MV

DWA_SUBSDY_AMT_MO

DT

Quarter

TBS_MV

DWA_VAS_SBRP_QCK_SUMM_MO

DT

Quarter

TBS_MV

DWA_VAS_USG_MO

DT

Quarter

TBS_MV

DWA_VOI_CALL_MO

DT

Quarter

TBS_MV

DWB_ACCS_MTHD_PORT_HIST

ACT_CTVR_DT

MONTH

TBS_BASE

DWB_ACCS_MTHD_STAT_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_ACCT_BAL_HIST

BAL_DT

MONTH

TBS_BASE

DWB_ACCT_COST

INCURR_DT

MONTH

TBS_BASE

DWB_ACCT_CRDT_LMT

EFF_FROM_DT

MONTH

TBS_BASE

DWB_ACCT_MNGMNT_HIST

ASGN_STRT_DT

MONTH

TBS_BASE

DWB_ACCT_PMP_PRTCPTN_HIST

RLTN_STRT_DT

MONTH

TBS_BASE

DWB_ACCT_PYMT

PYMT_DT

MONTH

TBS_BASE

DWB_ACCT_PYMT_MTHD_STAT

EFF_FROM_DT

MONTH

TBS_BASE

DWB_ACCT_RFND

PYMT_DT

MONTH

TBS_BASE

DWB_ACCT_STAT_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_APNMNT_CLNDR

DAY_KEY

DAY

TBS_BASE

DWB_BLK_LST_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_BRDBND_USG_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_BSNS_UNIT_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CELL_SITE_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CHNL_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CMPGN_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CMPGN_MSG_CRTVE

CRTN_DT

MONTH

TBS_BASE

DWB_CNCT_LST_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CNRT_APRVL

CNRT_APRVL_DT

MONTH

TBS_BASE

DWB_CNRT_STAT

EFF_FROM_DT

MONTH

TBS_BASE

DWB_CNRT_TERM_VAL

TERM_PRD_STRT_DT

MONTH

TBS_BASE

DWB_CNTNT_DLVRY_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_COST

INCURR_DT

MONTH

TBS_BASE

DWB_COST_CNTR_BDGT

EFF_FROM_DT

MONTH

TBS_BASE

DWB_CRCUT_RNTL

EFF_FROM_DT

MONTH

TBS_BASE

DWB_CRCUT_TRFC

EFF_STRT_DT

MONTH

TBS_BASE

DWB_CUST_COST

INCURR_DT

MONTH

TBS_BASE

DWB_CUST_FLD_INSTLTN

FLD_ACTVTY_STRT_DT

MONTH

TBS_BASE

DWB_CUST_FLD_SPPRT

FLD_ACTVTY_STRT_DT

MONTH

TBS_BASE

DWB_CUST_FLD_SRVC_ACTVTY

FLD_ACTVTY_STRT_DT

MONTH

TBS_BASE

DWB_CUST_FLD_SRVC_DTL

ACTN_DT

MONTH

TBS_BASE

DWB_CUST_ORDR

ORGNL_ORDR_DT

MONTH

TBS_BASE

DWB_CUST_ORDR_LN_ITEM

ORGNL_ORDR_DT

MONTH

TBS_BASE

DWB_CUST_ORDR_LN_ITEM_ST_ASGN

ORDR_LN_ITEM_STATE_BEGIN_DT

MONTH

TBS_BASE

DWB_CUST_ORDR_PYMT

PYMT_DT

MONTH

TBS_BASE

DWB_CUST_ORDR_STATE_ASGN

ORDR_STATE_BEGIN_DT

MONTH

TBS_BASE

DWB_DATA_SRVC_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_DEBT_COLLCTN

INTRACN_THRD_STRT_DT

MONTH

TBS_BASE

DWB_DEBT_COLLCTN_ASGN

ASGN_DT

MONTH

TBS_BASE

DWB_DEBT_COLLCTN_ASGN_BTCH

ASGN_DT

MONTH

TBS_BASE

DWB_EMP_ACT_LBR_HRLY

DAY_KEY

DAY

TBS_BASE

DWB_EMP_ACT_LBR_SALARIED

DAY_KEY

DAY

TBS_BASE

DWB_EMP_COST

INCURR_DT

MONTH

TBS_BASE

DWB_EMP_TRNG_REC

TRNG_STRT_DT

MONTH

TBS_BASE

DWB_EQPMNT_CNTR_COST

INCURR_DT

MONTH

TBS_BASE

DWB_EQPMNT_INSTNC_STAT_HIST

EFF_BEGIN_DT

MONTH

TBS_BASE

DWB_EVT

STRT_DT

DAY

TBS_BASE

DWB_EVT_ACCS_MTHD_ACTVTY

STRT_DT

DAY

TBS_BASE

DWB_EVT_ACCT

STRT_DT

MONTH

TBS_BASE

DWB_EVT_ASGN

EFF_FROM_DT

DAY

TBS_BASE

DWB_EVT_COST

INCURR_DT

MONTH

TBS_BASE

DWB_EVT_CRCUT_RNTL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_EMP_PYRL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_EQPMNT_INSTNC

STRT_DT

MONTH

TBS_BASE

DWB_EVT_FINCL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_GEO

STRT_DT

MONTH

TBS_BASE

DWB_EVT_GFT_RDMPTN

STRT_DT

MONTH

TBS_BASE

DWB_EVT_INVC_DLVRY

STRT_DT

MONTH

TBS_BASE

DWB_EVT_LYLTY_PROG

STRT_DT

MONTH

TBS_BASE

DWB_EVT_LYLTY_PROG_ACMLTN

STRT_DT

MONTH

TBS_BASE

DWB_EVT_LYLTY_PROG_RDMPTN

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PROD_PKG

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRPD_MBL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_ASGN

EFF_DT

DAY

TBS_BASE

DWB_EVT_PRTY_INTRACN

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_INTRACN_CALL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_INTRACN_EML

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_INTRACN_LTTR

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_INTRACN_VST

STRT_DT

MONTH

TBS_BASE

DWB_EVT_PRTY_PRFL

STRT_DT

MONTH

TBS_BASE

DWB_EVT_SBRP

STRT_DT

MONTH

TBS_BASE

DWB_EVT_SBRP_CHNG

STRT_DT

MONTH

TBS_BASE

DWB_EVT_SIM_CARD

STRT_DT

MONTH

TBS_BASE

DWB_EVT_STAT

EFF_FROM_DT

DAY

TBS_BASE

DWB_EVT_WEB_RGSTRN

STRT_DT

MONTH

TBS_BASE

DWB_FIXED_LN_CALL_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_IDD_CALL_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_INTRNT_ACCS_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_INVC

BLLG_DT

MONTH

TBS_BASE

DWB_INVC_ADJ

STRT_DT

MONTH

TBS_BASE

DWB_INVC_DISC

BLLG_DT

MONTH

TBS_BASE

DWB_INVC_ITEM

BLLG_DT

MONTH

TBS_BASE

DWB_INVC_ITEM_DTL

BLLG_DT

MONTH

TBS_BASE

DWB_INVC_PYMT_ASGN

EFF_FROM_DT

MONTH

TBS_BASE

DWB_ISP_USG_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_LYLTY_PROG_PTS_BAL

EFF_FROM_DT

MONTH

TBS_BASE

DWB_MDTD_CALL_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_MEDIA_OBJ_COST

INCURR_DT

MONTH

TBS_BASE

DWB_MKT_PLN_MGMT

MNG_ACTN_DT

MONTH

TBS_BASE

DWB_MMS_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_MNT_ALLWNC

BAL_DT

MONTH

TBS_BASE

DWB_NP_RQST_HDR

APLCTN_DT

MONTH

TBS_BASE

DWB_NP_RQST_LN_ITEM

NP_STEP_STRT_DT

MONTH

TBS_BASE

DWB_NP_RQST_LN_ITEM_STATE_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_NP_RQST_STATE_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_NTWK_ELMNT_COST

INCURR_DT

MONTH

TBS_BASE

DWB_NTWK_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_NTWK_FLT

OPEN_DT

MONTH

TBS_BASE

DWB_PRMTN_COST

INCURR_DT

MONTH

TBS_BASE

DWB_PRMTN_MGMT_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_PRMTN_TERM_VAL

TERM_PRD_STRT

MONTH

TBS_BASE

DWB_PROD_COST

INCURR_DT

MONTH

TBS_BASE

DWB_PROD_MKT_PLN_COST

INCURR_DT

MONTH

TBS_BASE

DWB_PRPD_RCHRG

PYMT_DT

MONTH

TBS_BASE

DWB_PRTY_AM_PMP_ASGN_HIST

ASGN_BEGIN_DT

MONTH

TBS_BASE

DWB_PRTY_AM_PMP_ASGN_STAT

ASGN_BEGIN_DT

MONTH

TBS_BASE

DWB_PRTY_INTRACN_THRD

INTRACN_THRD_STRT_DT

MONTH

TBS_BASE

DWB_PRTY_ORDR_ASGN

EFF_FROM_DT

MONTH

TBS_BASE

DWB_PRTY_PRMTN_RESPN

RESPN_DT

MONTH

TBS_BASE

DWB_PRTY_STAT_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_PTV_FULL_CHNL_ACTVTN

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_PTV_QPI_SRVC_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_PTV_USG_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWB_SBRP_STAT_HIST

EFF_FROM_DT

MONTH

TBS_BASE

DWB_SBRP_TERM_VAL

TERM_PRD_STRT_DT

MONTH

TBS_BASE

DWB_SL_CMISN_DTL

EFF_FROM_DT

MONTH

TBS_BASE

DWB_SL_CMISN_PYRL

PAY_DT

MONTH

TBS_BASE

DWB_SMS_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_SRVC_RQST

INTRACN_THRD_STRT_DT

MONTH

TBS_BASE

DWB_UMS_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_VNDR_APNMNT

VNDR_APNMNT_DT

MONTH

TBS_BASE

DWB_VOIP_CALL_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_WRLS_CALL_EVT

EVT_BEGIN_DT

DAY

TBS_BASE

DWB_WRLS_CNTNT_DNLDG_EVT

EVT_BEGIN_DT

MONTH

TBS_BASE

DWD_ACCT_DEBT_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_PYMT_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_PYMT_MTHD_STAT_HIST

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_RFND_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_STAT

MO_KEY

MONTH

TBS_DERIVED

DWD_ACCT_STTSTC

MO_KEY

MONTH

TBS_DERIVED

DWD_ARPU_BASE

MO_KEY

MONTH

TBS_DERIVED

DWD_BER_FER_ERR_RATIO_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CALL_CNTR_CALL_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CALL_CNTR_CASE_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CANBLZTN_DTL_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CELL_STTSTC_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CHRN_PRDCT_SRC

MO_KEY

MONTH

TBS_DERIVED

DWD_CMISN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CNCT_DSCNCT_DAY

DAY_KEY

DAY

TBS_DERIVED

DWD_CNRT

MO_KEY

MONTH

TBS_DERIVED

DWD_CNRT_CHNG

MO_KEY

MONTH

TBS_DERIVED

DWD_COST_CUST

MO_KEY

MONTH

TBS_DERIVED

DWD_COST_ORG

MO_KEY

MONTH

TBS_DERIVED

DWD_CRDT_CTGRY

MO_KEY

MONTH

TBS_DERIVED

DWD_CUST_ACQSTN_SUMM_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_CUST_DEBT_COLLCTN

MO_KEY

MONTH

TBS_DERIVED

DWD_CUST_EQPMNT_INSTLTN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_DATA_USG_DAY

DAY_KEY

DAY

TBS_DERIVED

DWD_EXTRNL_DEBT_COLLCTN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_GIVE_AWAY_ITEM_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_GPRS_PCU_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_GPRS_SRVCS_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_HNDST_STCK_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_HNDST_SUBSDY_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_INTRNL_DEBT_COLLCTN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_INVC

MO_KEY

MONTH

TBS_DERIVED

DWD_INVC_ADJ

MO_KEY

MONTH

TBS_DERIVED

DWD_IN_PLTFRM_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_LN_ACTVTN_TMNT_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_LYLTY_PROG_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_MKT_OPRTR_PRTNG

MO_KEY

MONTH

TBS_DERIVED

DWD_MKT_SHARE

MO_KEY

MONTH

TBS_DERIVED

DWD_MSC_TRFC_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_NBR_PRT_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_NTWK_AVLBLTY_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_NTWK_TCHPNT

MO_KEY

MONTH

TBS_DERIVED

DWD_PRPD_ACCT_STTSTC

MO_KEY

MONTH

TBS_DERIVED

DWD_PRPD_ALWNCE_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_PRPD_CALL_SUMM_DAY

DAY_KEY

DAY

TBS_DERIVED

DWD_PRTNR_STLMNT

MO_KEY

MONTH

TBS_DERIVED

DWD_PYMT_AGNG_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_RDMPTN_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_RF_NTWK_CPCTY_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SBCRBR_CHRN_STTSTC

MO_KEY

MONTH

TBS_DERIVED

DWD_SHARED_PKG_USG_STTSTC_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SHOP_EFFNCY_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SL_CMPGN_SUMM_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SL_DAY

MO_KEY

MONTH

TBS_DERIVED

DWD_SL_RPRSTV_STTSTC

MO_KEY

MONTH

TBS_DERIVED

DWD_SPLMNTR_SRVC_USG

MO_KEY

MONTH

TBS_DERIVED

DWD_SUBSDY_AMT

MO_KEY

MONTH

TBS_DERIVED

DWD_VAS_SBRP_QCK_SUMM

MO_KEY

MONTH

TBS_DERIVED

DWD_VAS_USG_DAY

DAY_KEY

DAY

TBS_DERIVED

DWD_VOI_CALL_DAY

DAY_KEY

DAY

TBS_DERIVED