Go to main content
1/43
Contents
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Oracle Resources
Conventions
1
Introduction to
Oracle Communications Data Model
Customization
Overview of
Oracle Communications Data Model
Components of the
Oracle Communications Data Model
Oracle Products That Make Up
Oracle Communications Data Model
Implementing an
Oracle Communications Data Model
Warehouse
Before You Begin Customizing the
Oracle Communications Data Model
Prerequisite Knowledge for Implementors
Responsibilities of a Data Warehouse Governance Committee
Performing Fit-Gap Analysis for
Oracle Communications Data Model
Data Encryption and Security for
Oracle Communications Data Model
2
Physical Model Customization
Characteristics of the Default Physical Model
Implementation Steps for
Oracle Communications Data Model
Resources and Skills Required
Feed Data to the Foundation Layer of
Oracle Communications Data Model
Customizing the
Oracle Communications Data Model
Physical Model
Questions to Answer Before You Customize the Physical Model
Conventions When Customizing the Physical Model
Foundation Layer Customization
General Recommendations When Designing Physical Structures
Tablespaces in
Oracle Communications Data Model
Data Compression in
Oracle Communications Data Model
Types of Data Compression Available
Tables for Supertype and Subtype Entities in
Oracle Communications Data Model
Surrogate Keys in the Physical Model
Integrity Constraints in
Oracle Communications Data Model
Indexes and Partitioned Indexes in
Oracle Communications Data Model
Partitioned Tables in
Oracle Communications Data Model
Specify Partitioning for Manageability
Specify Partitioning for Easier Data Access
Partitioning the
Oracle Communications Data Model
for Join Performance
Parallel Execution in
Oracle Communications Data Model
Enabling Parallel Execution for a Session
Enabling Parallel Execution of DML Operations
Enabling Parallel Execution at the Table Level
3
Access Layer Customization
Introduction to Customizing the Access Layer
Derived Tables in
Oracle Communications Data Model
Creating New Derived Tables for Calculated Data
Customizing
Oracle Communications Data Model
Data Mining Models
Creating a New Data Mining Model for
Oracle Communications Data Model
Modifying
Oracle Communications Data Model
Data Mining Models
How to Customize the Churn Prediction Model
Tutorial Prerequisites
Preparing Your Environment
Generating the Prepaid Churn Prediction Model
Checking the Result
Aggregate Tables in
Oracle Communications Data Model
Dimensional Components in
Oracle Communications Data Model
Characteristics of a Dimensional Model
Characteristics of Relational Star and Snowflake Tables
Declaring Relational Dimension Tables
Validating Relational Dimension Tables
Characteristics of the OLAP Dimensional Model
Oracle OLAP Cube Views
Cube Materialized Views
Characteristics of the OLAP Cubes
Defining New Oracle OLAP Cubes
Changing an Oracle OLAP Cube
Creating a Forecast Cube
Cube Partitioning Strategy Options
Cube Data Maintenance Methods
Materialized Views in
Oracle Communications Data Model
Types of Materialized Views and Refresh Options
Types of Indexes for Materialized Views
Options for Partitioning and Materialized Views
Considerations for Data Compression with Materialized Views
4
ETL Implementation and Customization
The Role of ETL in
Oracle Communications Data Model
ETL for the Foundation Layer of an
Oracle Communications Data Model
Warehouse
Application Adapters that Populate the Foundation Layer
Writing Your Own Source-ETL
Source-ETL Design Considerations
ETL Architecture for
Oracle Communications Data Model
Source-ETL
Understanding the Source to Target Mapping Document for Source-ETL
Understanding Plans for Rectifying Source-ETL Data Quality Problems
Understanding Source-ETL Workflow and Job Control
Understanding Source-ETL Exception Handling
Writing Source-ETL that Loads Efficiently
Customizing Intra-ETL for
Oracle Communications Data Model
Handling Lookup Values in Staging
Executing Derived Intra-ETL Programs
Refreshing Aggregate Materialized Views
Refreshing Data Mining Models
Refreshing OLAP Cubes
Executing Intra-ETL Workflow
Performing an Initial Load of an
Oracle Communications Data Model
Warehouse
Performing an Initial Load of the Foundation Layer
Performing an Initial Load of the Access Layer
Executing the Default
Oracle Communications Data Model
ntra-ETL
Refreshing the Data in an
Oracle Communications Data Model
Warehouse
Refreshing the Foundation Layer of
Oracle Communications Data Model
Warehouse
Refreshing the Access Layer of an
Oracle Communications Data Model
Warehouse
Refreshing
Oracle Communications Data Model
Derived Tables
Refreshing Oracle Communications Data Model Aggregate Materialized Views
Refreshing OLAP Cubes
Refreshing
Oracle Communications Data Model
Data Mining Models
Running Oracle Data Miner Workflows
Managing Errors During
Oracle Communications Data Model
Intra-ETL Execution
5
Report and Query Customization
Reporting Approaches in
Oracle Communications Data Model
Customizing
Oracle Communications Data Model
Sample Reports
Writing Your Own Queries and Reports
Optimizing Star Queries
Troubleshooting
Oracle Communications Data Model
Report Performance
As Is and As Was Queries
Example: As Is and As Was Queries Against
Oracle Communications Data Model
Tutorial: Creating a New Dashboard
Tutorial: Creating a New Report
6
Metadata Collection and Reports
Overview of Managing Metadata
Metadata Categories and Standards
Metadata Management Using a Metadata Repository
Browsing Metadata Reports and Dashboard
Using the Measure-Entity Tab Business Areas and Measures Attributes and Entities
Using the Entity-Measure Tab Entity to Display Measures
Using the Program-Table Tab
Using the Table-Program Tab to List Tables for Reports
Collecting and Populating Metadata
Loading LDM/PDM Metadata (Table MD_ENTY)
Loading Program (Intra-ETL) Metadata (Table MD_PRG)
Loading Reports and KPI Metadata (Table MD_KPI and MD_REF_ENTY_KPI):
7
Working with User Privileges in
Oracle Communications Data Model
Accounts Created for
Oracle Communications Data Model
When You Must Consider User Privileges in an
Oracle Communications Data Model
Granting Only Required Privileges to Database Users of OCDM_SYS
Granting Only Select Privileges to Database Users of the Sample Reports
Granting Permission Privileges for OBIEE Reports to BI Users and Roles
8
Oracle Communications Data Model
Security
Oracle Communications Data Model
Security Overview
Architecture Analysis for Security
Security by Component
Performing a Secure
Oracle Communications Data Model
Installation
Implementing Data Model Security
Security Maintenance, Monitoring and Control
Security Considerations for Developers
Dealing with Data Privacy, Data Retention, and other Data Related Rules and Laws
Database Vault on
Oracle Communications Data Model
Registering Oracle Database Vault with an Oracle Database
Verifying That Oracle Database Vault Is Configured and Enabled
Logging into Oracle Database Vault
Securing
OCDM
_SYS Schema from DBA Access
Data Masking on
Oracle Communications Data Model
Using Data Masking
Transparent Data Encryption in
Oracle Communications Data Model
Configuring a Software Keystore
Demonstration of
Oracle Communications Data Model
Working with TDE
A
Sizing and Configuring an
Oracle Communications Data Model
arehouse
Oracle Communications Data Model
Warehouse Sizing
Configuring a Balanced System for
Oracle Communications Data Model
High Throughput in an
Oracle Communications Data Model
Warehouse
I/O in an
Oracle Communications Data Model
for Bandwidth not Capacity
Growth in Your
Oracle Communications Data Model
Warehouse
Testing the I/O System Before Building the Warehouse
B
Upgrading
Oracle Communications Data Model
Considerations for Upgrading
Oracle Communications Data Model
Upgrade Paths for
Oracle Communications Data Model
Regression Testing for
Oracle Communications Data Model
C
Entity Security Levels Sensitivity
Entity Security Levels Listing
Index
Scripting on this page enhances content navigation, but does not change the content in any way.