Index

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

---

A

access layer, 3.1

customizing, 4, 4.1

Oracle Communications Data Model, 3.1, 4

accounts

for Oracle Communications Data Warehouse, D.1

AGGR_FLW, 5.3.1

aggregate tables

in Oracle Communications Data Model, 4.3

refreshing, 5.3.1

As Is reports, 6.6

As Was reports, 6.6

---

C

Churn Prediction Data Mining Model, 4.2.2.3

compression

hybrid columnar, A.2.2

in Oracle Communications Data Model, 3.3.2, 3.3.2.1, 3.3.2.2

materialized views, 4.5.4

configuring Oracle Communications Data Model warehouse, B.2

conventions

when customizing logical model, 2.1.2

when customizing physical model, 3.2.2

cubes

adding materialized view capabilities to, 4.4.3.2

changing the dimensions of, 4.4.6

changing the measures of, 4.4.6

customizing, 4.4.4

data maintenance methods, 4.4.9

forecast, 4.4.7

in Oracle Communications Data Model, 4.4.4, 4.4.5

partitioning, 4.4.8

customizing

access layer, 4

cubes, 4.4.4

logical model, 2.1

logical model, example, 2.3

Oracle Communications Data Model, 1.2

physical data model, 3

---

D

dashboards, Oracle Communications Data Model, 6.2, 6.7

data governance committee, responsibilities of, 1.3.2

data mining models

customizing, 4.2.2

refreshing, 5.3.1

derived tables

in Oracle Communications Data Model, 4.2

refreshing, 5.3.1

dimensional components, Oracle Communications Data Model, 4.4

DRVD_FLW, 5.3.1

---

E

error handling

during intra-ETL execution, 5.3.3

ETL for Oracle Communications Data Model, 5.1

Exadata

and Oracle Communications Data Model, A

Exadata hybrid columnar compression

and Oracle Communications Data Model, 3.3.2.1, A.2.2

---

F

fit-gap analysis for Oracle Communications Data Model, 1.5

forecast cube in Oracle Communications Data Model, 4.4.7

foundation layer

defined, 3.1

Oracle Communications Data Model, 3.1

---

H

hybrid columnar compression, A.2.2

---

I

implementing

Oracle Communications Data Model, 1.2

implementors of Oracle Communications Data Model

prerequisite knowledge, 1.3.1

indexes

in Oracle Communications Data Model, 3.3.6

materialized views, 4.5.2

partitioning, 3.3.6

integrity constraints

in Oracle Communications Data Model, 3.3.5

INTRA_ETL_FLW process flow, 5.3.1

intra-ETL

customizing, 5.3

executing, 5.3.2.1

managing errors, 5.3.3

monitoring execution of, 5.3.3.1

Oracle Communications Data Model, 5.1

recovery, 5.3.3.2

troubleshooting, 5.3.3.3

---

J

join performance, improving, 3.3.7.3

---

K

keys, surrogate

in Oracle Communications Data Model, 3.3.4

---

L

loading Oracle Communications Data Model data, 5.3.2, C

logical model of Oracle Communications Data Model

common change scenarios, 2.2

customizing, 2.1, 2.1.2

customizing example, 2.3

---

M

materialized views

compressing, 4.5.4

in Oracle Communications Data Model, 4.5

indexing, 4.5.2

partition change tracking, 4.5.3

partitioning, 4.5.3

refresh options

refreshing, 4.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, 5.3.1

---

N

naming conventions

for logical model of Oracle Communications Data Model, 2.1.2

for physical model of Oracle Communications Data Model, 3.2.2

---

O

Oracle Communications Data Model

access layer, 3.1, 4

accounts for, D.1

components of, 1.1.1

customizing, 1.2

customizing logical model, 2.1, 2.1.2

customizing physical model, 3.1, 3.2, 3.2.1, 3.2.2, 3.3

dashboards, 6.2

data governance, 1.3.2

described, 1.1

dimensional components, 4.4

ETL, 5.1

fit-gap analysis, 1.5

foundation layer, 3.1

implementing, 1.2

intra-ETL, 5.1

loading, 5.3.2

Metadata Dependency Manager, 1.4.4

metadata management, 1.4

metadata repository, 1.4.2, 1.4.3

Oracle products used by, 1.1.2

Oracle Warehouse Builder, using with, 1.4.4

physical layers of, 3.1

pre-implementation tasks, 1.3

querying, 6.3

refreshing data, C, C.1

reporting, 6.1, 6.3

source-ETL, 5.1, 5.2, 5.2.1, 5.2.2, 5.2.3, 5.2.4

staging layer, 3.1

tablespaces, design recommendations, 3.3.1

upgrading, E

user privileges, D

Oracle Communications Data Model implementors

prerequisite knowledge for, 1.3.1

Oracle Communications Data Model warehouse

configuring, B.2

sizing, B.1

Oracle data mining models

Oracle Communications Data Model, 4.2.2.1

Oracle Warehouse Builder

with Oracle Communications Data Model, 1.4.4

---

P

parallel execution

enabling for a session, 3.3.8.1

enabling for DML operations, 3.3.8.2

in Oracle Communications Data Model, 3.3.8

partition change tracking, 4.5.3

partition exchange load, 5.2.6.5

partitioned indexes in Oracle Communications Data Model, 3.3.6

partitioning

and hybrid columnar compression, A.2.2

cubes, 4.4.8

for easier data access, 3.3.7.2

for join performance, 3.3.7.3

for manageability, 3.3.7.1

for source-ETL, 5.2.6.5

indexes, 3.3.6

materialized views, 4.5.3

tables, 3.3.7

partitions, changing, 3.3.1

physical model of Oracle Communications Data Model

characteristics of, 3.1, 3.2, 3.2.1

customizing, 3.2.2

general recommendations for, 3.3

---

Q

querying Oracle Communications Data Model, 6.3

---

R

refreshing

aggregate tables, 5.3.1

data mining models, 5.3.1

derived tables, 5.3.1

Oracle Communications Data Warehouse, C, C.1

reporting

Oracle Communications Data Model, 6.1, 6.3

reports

approaches to, 6.1

As Is, 6.6

As Was, 6.6

troubleshooting performance, 6.5

reports, Oracle Communications Data Model

creating new, 6.8

---

S

sample reports

customizing

Oracle Communications Data Model, 6.2

sizing

Oracle Communications Data Model warehouse, B.1

source-ETL

exception handling, 5.2.5

jobs control, 5.2.4

loading considerations, 5.2.6

Oracle Communications Data Model, 5.1, 5.2, 5.2.1, 5.2.2, 5.2.3, 5.2.4, 5.2.6

parallel direct path load, 5.2.6.4

partitioning for, 5.2.6.5

workflow, 5.2.4

staging layer, 3.1

Oracle Communications Data Model, 3.1

star queries, optimizing, 6.4

subtypes

defining tables for, 3.3.3

physical implementation of, 3.3.3

supertypes

defining tables for, 3.3.3

physical implementation of, 3.3.3

surrogate keys

in Oracle Communications Data Model, 3.3.4

---

T

tables

aggregate, 4.3

compressing, 3.3.2, 3.3.2.1, 3.3.2.2

derived, 4.2

partitioning, 3.3.7

tablespace in Oracle Communications Data Model, 3.3.1

---

U

upgrading Oracle Communications Data Warehouse, E

user privileges in Oracle Communications Data Warehouse, D