6 Oracle Utilities Data Model Partitioning

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

This chapter includes the following section:

About Oracle Utilities 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 Utilities Data Model.

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

Partitioning Strategy for Oracle Utilities Data Model

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