This chapter provides the partitioning strategy for the Oracle Utilities Data Model physical base, derived, and aggregate tables.
This chapter includes the following section:
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 Utilities Data Model.
For more information, see Oracle Communications Data Model Implementation and Operations Guide.
Table 6-1 shows the partitioning strategy for the Oracle Utilities Data Model physical base, derived, and aggregate tables..
Note:
The partitioning type for all tables shown in Table 6-1 is RANGE
Table 6-1 Physical Data Model Partitioning
Physical Table Name | Sub partitioning Type | Partitioning Key Column | Sub partitioning Key Column | Partition Level | Default Tablespace |
---|---|---|---|---|---|
DWA_END_DVC_EVT_CUST_MO |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_AGGREGATE_TBS |
DWA_END_DVC_EVT_DVC_MO |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_AGGREGATE_TBS |
DWA_MTR_RDNG_MO |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_AGGREGATE_TBS |
DWA_MTR_RDNG_MO_ACCT |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_AGGREGATE_TBS |
DWA_MTR_RDNG_MO_CUST |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_AGGREGATE_TBS |
DWA_MTR_RDNG_MO_UP |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_AGGREGATE_TBS |
DWA_MTR_RDNG_TOU_MO |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_AGGREGATE_TBS |
DWA_OUTG_MO |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_AGGREGATE_TBS |
DWB_ACCT_BAL_ADJ |
HASH |
ADJ_DT |
ACCT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_ACCT_BAL_HIST |
HASH |
BAL_DT |
ACCT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_ACCT_BLLG_OCCRNCE |
NONE |
BLLG_DT |
N/A |
QUARTER |
OUDM_BASE_TBS |
DWB_ACCT_CRDT_LMT |
NONE |
CRDT_RTNG_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_ACCT_PYMT |
HASH |
PYMT_DT |
ACCT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_ACCT_PYMT_BAL_IMPT |
HASH |
IMPT_DT |
ACCT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_ACCT_PYMT_MTHD_STAT |
HASH |
EFF_FROM_DT |
ACCT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_ACCT_RFND |
HASH |
PYMT_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_ACCT_STAT_HIST |
NONE |
EFF_FROM_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_AGRMNT_APRVL |
HASH |
AGRMNT_APRVL_DT |
AGRMNT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_AGRMNT_STAT |
NONE |
EFF_TO_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_BLK_LST_HIST |
HASH |
EFF_FROM_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_BSNS_INTRACN |
NONE |
INTRACN_DT |
N/A |
QUARTER |
OUDM_BASE_TBS |
DWB_CMPGN_MSG_CRTVE |
NONE |
CRTN_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_COST |
NONE |
INCURR_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_CRNCY_EXCHNG_RATE |
NONE |
EXCHNG_RATE_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_CUST_ORDR |
HASH |
ORDR_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_CUST_ORDR_LI |
NONE |
ORDR_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_DEBT_COLLCTN |
NONE |
INTRACN_THRD_STRT_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_DEBT_COLLCTN_ASGN |
NONE |
ASGN_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_DEBT_COLLCTN_ASGN_BTCH |
NONE |
ASGN_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_EMP_ACT_LBR_HRLY |
NONE |
EMP_KEY |
N/A |
HUNDRED EMPLOYEES |
OUDM_BASE_TBS |
DWB_EMP_COST |
NONE |
INCURR_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_EMP_TRNG_REC |
NONE |
TRNG_STRT_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_END_DVC_EVT |
NONE |
CRTD_DT_TIME |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_EVT |
HASH |
STRT_DT |
ORG_BSNS_UNIT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_ACCT |
HASH |
STRT_DT |
ORG_BSNS_UNIT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_ASGN |
NONE |
EFF_FROM_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_EMP_PYRL |
HASH |
STRT_DT |
ORG_BSNS_UNIT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_EQPMNT_INSTNC |
HASH |
STRT_DT |
ORG_BSNS_UNIT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_GEO |
HASH |
STRT_DT |
ORG_BSNS_UNIT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_INVC_DLVRY |
HASH |
STRT_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_LYLTY_PROG |
HASH |
STRT_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_PRTY_ASGN |
NONE |
EFF_DT |
N/A |
DAY |
OUDM_BASE_TBS |
DWB_EVT_PRTY_INTRACN |
HASH |
STRT_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_PRTY_INTRACN_CALL |
HASH |
STRT_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_PRTY_INTRACN_EML |
HASH |
STRT_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_PRTY_INTRACN_LTTR |
HASH |
STRT_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_PRTY_INTRACN_VST |
HASH |
STRT_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_PRTY_PRFL |
HASH |
STRT_DT |
ORG_BSNS_UNIT_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_STAT |
NONE |
EFF_FROM_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_WEB_RGSTRTN |
HASH |
STRT_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_EVT_WEB_VST |
NONE |
STRT_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_FNL_RDNG |
HASH |
TIME_STMP |
FNL_RDNG_KEY |
WEEK |
OUDM_BASE_TBS |
DWB_INCDNT |
NONE |
CRTD_DT_TIME |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_INITIAL_RDNG |
HASH |
TIME_STMP |
INITIAL_RDNG_KEY |
WEEK |
OUDM_BASE_TBS |
DWB_INTRACN_QUES_RESPN |
NONE |
RESPN_DT |
N/A |
QUARTER |
OUDM_BASE_TBS |
DWB_INVC |
HASH |
BLLG_DT |
CUST_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_INVC_ADJ |
NONE |
STRT_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_INVC_DISC |
NONE |
BLLG_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_INVC_ITEM |
NONE |
BLLG_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_INVC_ITEM_DTL |
NONE |
BLLG_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_INVC_PYMT_ASGN |
NONE |
EFF_FROM_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_INVC_STAT_HIST |
NONE |
EFF_FROM_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_MTR_RDNG |
HASH |
STRT_DT |
MTR_RDNG_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_OUTG |
NONE |
DT_TIME |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_OUTG_REC |
NONE |
DT_TIME |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_PRICE_EVT |
NONE |
STRT_DT |
N/A |
DAY |
OUDM_BASE_TBS |
DWB_PRMTN_CLSTR_USG |
NONE |
USG_DT |
N/A |
HALF YEAR |
OUDM_BASE_TBS |
DWB_PRMTN_CNCT_LST_UTLZTN |
NONE |
USG_DT |
N/A |
HALF YEAR |
OUDM_BASE_TBS |
DWB_PRMTN_MGMT_HIST |
NONE |
EFF_FROM_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_PRTY_COST_ASGN |
NONE |
ASGN_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_PRTY_INTRACN_THRD |
NONE |
INTRACN_THRD_STRT_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_PRTY_PRMTN_RESPN |
HASH |
RESPN_DT |
PRTY_KEY |
MONTH |
OUDM_BASE_TBS |
DWB_PRTY_STAT_HIST |
NONE |
EFF_FROM_DT |
N/A |
MONTH |
OUDM_BASE_TBS |
DWB_RESRE_ORDR |
NONE |
CRTD_DT_TIME |
N/A |
QUARTER |
OUDM_BASE_TBS |
DWB_SRVC_ORDR |
NONE |
CRTD_DT_TIME |
N/A |
QUARTER |
OUDM_BASE_TBS |
DWD_ACCT_ARRER_MO |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_ACCT_BAL_MO |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_ACCT_DEBT_DAY |
HASH |
DAY_KEY |
CUST_KEY |
MONTH |
OUDM_DERIVED_TBS |
DWD_ACCT_PYMT_DAY |
HASH |
DAY_KEY |
CUST_KEY |
MONTH |
OUDM_DERIVED_TBS |
DWD_ACCT_PYMT_MTHD_STAT_HIST |
HASH |
CLNDR_MO_KEY |
CUST_KEY |
MONTH |
OUDM_DERIVED_TBS |
DWD_ACCT_STAT_MO |
NONE |
CLNDR_MO_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_CUST_DR_PROG_PROFILE |
HASH |
DEMAND_RESPN_PROG_KEY |
CUST_KEY |
ONE DEMAND RESPONSE PROGRAM |
OUDM_DERIVED_TBS |
DWD_DR_PROG_LD_RDCTN_RGN_DAY |
NONE |
DAY_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_END_DVC_EVT_CUST_DAY |
NONE |
DAY_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_END_DVC_EVT_DVC_DAY |
NONE |
DAY_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_MTR_RDNG_DAY |
NONE |
DAY_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_MTR_RDNG_HR |
NONE |
DAY_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_OUTG_DAY |
NONE |
DAY_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_OUTG_USG_PNT |
NONE |
DAY_KEY |
N/A |
MONTH |
OUDM_DERIVED_TBS |
DWD_RLBLTY_IND_CITY_MO |
NONE |
CLNDR_MO_KEY |
N/A |
YEAR |
OUDM_DERIVED_TBS |
DWD_RLBLTY_IND_FEDR_MO |
NONE |
CLNDR_MO_KEY |
N/A |
YEAR |
OUDM_DERIVED_TBS |
DWR_SRVC_QTY |
HASH |
TMSTMP |
SRVC_QTY_KEY |
MONTH |
OUDM_REFERENCE_TBS |