Index

A B C D E F H I J K L M N O P Q R S T U

A

access layer, 2.1

customizing, 3, 3.1

Oracle Communications Data Model, 2.1, 3

access layer of Oracle Communications Data Model

populating, 4.4.2, 4.5.2

accounts

for Oracle Communications Data Warehouse, B.1

AGGR_FLW, 4.3

aggregate tables

in Oracle Communications Data Model, 3.3

refreshing, 4.3

application adapters

for Oracle Communications Data Model, C, D

Oracle Communications Data Model, 4.2, 4.2.1, 4.5.1

As Is reports, 5.6.1

As Was reports, 5.6.1

B

Billing and Revenue Management Adapter

Oracle Communications Data Model, D

BRM Adapter for Oracle Communications Data Model, D.2.3.2

introduction to, D, D.1

populating using, D.4

schemas, D.2.2

with ODI, D.2.4

with Oracle GoldenGate, D.2.5

brm_stg schema, D.2.3

C

Churn Prediction Data Mining Model, 3.2.2.3

compression

in Oracle Communications Data Model, 2.4.2, 2.4.2.1, 2.4.2.1.1

materialized views, 3.5.4

configuring Oracle Communications Data Model warehouse, A.2

conventions

when customizing physical model, 2.2.2

cubes

adding materialized view capabilities to, 3.4.3.2

changing the dimensions of, 3.4.6

changing the measures of, 3.4.6

customizing, 3.4.4

data maintenance methods, 3.4.9

forecast, 3.4.7

in Oracle Communications Data Model, 3.4.4, 3.4.5

partitioning, 3.4.8

customizing

access layer, 3

cubes, 3.4.4

Oracle Communications Data Model, 1.2

physical data model, 2

D

dashboards, Oracle Communications Data Model, 5.2, 5.7

data governance committee, responsibilities of, 1.3.2

data mining models

customizing, 3.2.2

refreshing, 4.3

definitions added to ocdm_sys, C.4.2.2, D.2.3.2

derived tables

in Oracle Communications Data Model, 3.2

refreshing, 4.3

dimensional components, Oracle Communications Data Model, 3.4

DRVD_FLW, 4.3

E

error handling

during intra-ETL execution, 4.6

ETL for Oracle Communications Data Model, 4.1

F

fit-gap analysis for Oracle Communications Data Model, 1.5

forecast cube in Oracle Communications Data Model, 3.4.7

foundation layer

defined, 2.1

Oracle Communications Data Model, 2.1

foundation layer of Oracle Communications Data Model

common change scenarios, 2.3.1

populating, 4.4.1, 4.5.1

H

HCC, 2.4.2.1.3

hybrid columnar compression

and Oracle Communications Data Model, 2.4.2.1.3

I

implementers of Oracle Communications Data Model

prerequisite knowledge, 1.3.1

implementing

Oracle Communications Data Model, 1.2

indexes

in Oracle Communications Data Model, 2.4.6

materialized views, 3.5.2

partitioning, 2.4.6

integrity constraints

in Oracle Communications Data Model, 2.4.5

INTRA_ETL_FLW process flow, 4.3

intra-ETL

customizing, 4.3

executing, 4.4.2.1

managing errors, 4.6

monitoring execution of, 4.6.1

Oracle Communications Data Model, 4.1

recovery, 4.6.2

troubleshooting, 4.6.3

J

join performance, improving, 2.4.7.3

K

keys, surrogate

in Oracle Communications Data Model, 2.4.4

L

loading Oracle Communications Data Model data, 4.4, 4.4.2

M

materialized views, 3.5.1

compressing, 3.5.4

in Oracle Communications Data Model, 3.5

indexing, 3.5.2

partition change tracking, 3.5.3

partitioning, 3.5.3

refresh options

refreshing, 3.5.1

Metadata Dependency Manager

with Oracle Communications Data Model, 1.4.4

metadata management

repository, 1.4.2, 1.4.3

with Oracle Communications Data Model, 1.4

metadata repository, 1.4.2

browsing, 1.4.3

with Oracle Communications Data Model, 1.4.3

MINING_FLW, 4.3

N

naming conventions

for physical model of Oracle Communications Data Model, 2.2.2

NCC Adapter for Oracle Communications Data Model, C.4.2.2

components of, C.4

introduction to, C, C.1

ODI project, C.4.3

populating using, C.2

schemas, C.1.1

with ODI, C.1.2

with Oracle GoldenGate, C.1.3

NCC source schema, C.4.1

NCC_OCDM project, C.4.3

ncc_stg schema, C.4.2

Network Charging and Control Adapter

Oracle Communications Data Model, C

Network Charging and Control Adapter for Oracle Communications Data Model, 4.2.1

O

ocdm_sys schema

definitions added by BRM Adapter for Oracle Communications Data Model, D.2.3.2

definitions added by NCC Adapter for Oracle Communications Data Model, C.4.2.2

ODI

BRM Adapter for Oracle Communications Data Model, D.2.4

NCC Adapter for Oracle Communications Data Model, C.1.2

ODI project

NCC Adapter for Oracle Communications Data Model, C.4.3

Oracle Communications Data Model

access layer, 2.1, 3

accounts for, B.1

application adapters, 4.2, 4.2.1, 4.5.1

Billing and Revenue Management Adapter, D

components of, 1.1.1

customizing, 1.2

customizing physical model, 2.1, 2.2, 2.2.1, 2.2.2, 2.4

dashboards, 5.2

data governance, 1.3.2

described, 1.1

dimensional components, 3.4

ETL, 4.1

fit-gap analysis, 1.5

foundation layer, 2.1

implementing, 1.2

intra-ETL, 4.1

loading, 4.4, 4.4.2

Metadata Dependency Manager, 1.4.4

metadata management, 1.4

metadata repository, 1.4.2, 1.4.3

Network Charging and Control Adapter, C

Oracle products used by, 1.1.2

Oracle Warehouse Builder, using with, 1.4.4

physical layers of, 2.1

populating using BRM Adapter for Oracle Communications Data Model, D.4

populating using NCC Adapter for Oracle Communications Data Model, C.2

pre-implementation tasks, 1.3

querying, 5.3

refreshing data, 4.5

refreshing with real-time data, C.2.2, C.3.1, D.4.2

refreshing with real-time data for BRM Adapter, D.3.2

reporting, 5.1, 5.3

source-ETL, 4.1, 4.2, 4.2.2.2, 4.2.2.3, 4.2.2.4, 4.2.2.5

staging layer, 2.1

tablespaces, design recommendations, 2.4.1

upgrading, E

user privileges, B

Oracle Communications Data Model implementers

prerequisite knowledge for, 1.3.1

Oracle Communications Data Model warehouse

configuring, A.2

sizing, A.1

Oracle data mining models

Oracle Communications Data Model, 3.2.2.1

Oracle GoldenGate

BRM Adapter for Oracle Communications Data Model, D.2.5

NCC Adapter for Oracle Communications Data Model, C.1.3

Oracle Warehouse Builder

with Oracle Communications Data Model, 1.4.4

P

parallel execution

enabling for a session, 2.4.8.1

enabling for DML operations, 2.4.8.2

in Oracle Communications Data Model, 2.4.8

partition change tracking, 3.5.3

partition exchange load, 4.2.2.7.5

partitioned indexes in Oracle Communications Data Model, 2.4.6

partitioning

cubes, 3.4.8

for easier data access, 2.4.7.2

for join performance, 2.4.7.3

for manageability, 2.4.7.1

for source-ETL, 4.2.2.7.5

indexes, 2.4.6

materialized views, 3.5.3

tables, 2.4.7

partitions, changing, 2.4.1

physical model of Oracle Communications Data Model

characteristics of, 2.1, 2.2, 2.2.1

customizing, 2.2.2

general recommendations for, 2.4

Q

querying Oracle Communications Data Model, 5.3

R

real-time data

populating with, C.2.2, C.3.1, D.4.2

populating with for BRM Adapter, D.3.2

refreshing

aggregate tables, 4.3

data mining models, 4.3

derived tables, 4.3

Oracle Communications Data Warehouse, 4.5

reporting

Oracle Communications Data Model, 5.1, 5.3

reports

approaches to, 5.1

As Is, 5.6.1

As Was, 5.6.1

troubleshooting performance, 5.5

reports, Oracle Communications Data Model

creating new, 5.8

S

sample reports, 5.2

customizing

Oracle Communications Data Model, 5.2

schemas

BRM source, D.2.2

brm_stg, D.2.2, D.2.3

NCC source, C.1.1, C.4.1

ncc_stg, C.1.1, C.4.2

ocdm_sys, C.1.1, D.2.2

staging, C.4.2, C.4.2.1, D.2.3

sizing

Oracle Communications Data Model warehouse, A.1

source-ETL

exception handling, 4.2.2.6

jobs control, 4.2.2.5

loading considerations, 4.2.2.7

Oracle Communications Data Model, 4.1, 4.2, 4.2.2.2, 4.2.2.3, 4.2.2.4, 4.2.2.5, 4.2.2.7

parallel direct path load, 4.2.2.7.4

partitioning for, 4.2.2.7.5

using application adapter to create, 4.2, 4.2.1, 4.5.1

workflow, 4.2.2.5

staging layer, 2.1

Oracle Communications Data Model, 2.1

star queries, optimizing, 5.4

subtypes

defining tables for, 2.4.3

physical implementation of, 2.4.3

supertypes

defining tables for, 2.4.3

physical implementation of, 2.4.3

surrogate keys

in Oracle Communications Data Model, 2.4.4

T

tables

aggregate, 3.3

compressing, 2.4.2, 2.4.2.1, 2.4.2.1.1

derived, 3.2

partitioning, 2.4.7

tablespace in Oracle Communications Data Model, 2.4.1

U

upgrading Oracle Communications Data Warehouse, E

user privileges in Oracle Communications Data Warehouse, B