Contents

List of Examples

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Oracle Resources
• Conventions

1 Introduction to Oracle Communications Data Model Customization

• What is the Oracle Communications Data Model?
  • Components of the Oracle Communications Data Model
  • Oracle Products That Make Up Oracle Communications Data Model
• Steps for Implementing an Oracle Communications Data Model Warehouse
• Before You Begin Customizing the Oracle Communications Data Model
  • Prerequisite Knowledge for Implementers
  • Responsibilities of a Data Warehouse Governance Committee
• Managing the Metadata for Oracle Communications Data Model
  • Metadata Categories and Standards
  • Working with a Metadata Repository
  • Browsing the Metadata Repository Supplied With Oracle Communications Data Model
  • Using Oracle Warehouse Builder with the Oracle Communications Data Model
• Performing Fit-Gap Analysis for Oracle Communications Data Model

2 Physical Model Customization

• Characteristics of the Default Physical 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
  • Common Change Scenarios
• General Recommendations When Designing Physical Structures
  • Tablespaces in the Oracle Communications Data Model
  • Data Compression in the 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 the Oracle Communications Data Model
  • Partitioned Tables in the Oracle Communications Data Model
    • Partitioning the Oracle Communications Data Model for Manageability
    • Partitioning the Oracle Communications Data Model for Easier Data Access
    • Partitioning the Oracle Communications Data Model for Join Performance
  • Parallel Execution in the 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 of Oracle Communications Data Model
• Derived Tables in the 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
    • Tutorial: Customizing the Churn Prediction Model
• Aggregate Tables in the Oracle Communications Data Model
• Dimensional Components in the 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 in Oracle Communications Data Model
  • Defining New Oracle OLAP Cubes for Oracle Communications Data Model
  • Changing an Oracle OLAP Cube in Oracle Communications Data Model
  • Creating a Forecast Cube for Oracle Communications Data Model
  • Choosing a Cube Partitioning Strategy for Oracle Communications Data Model
  • Choosing a Cube Data Maintenance Method for Oracle Communications Data Model
• Materialized Views in the Oracle Communications Data Model
  • Types of Materialized Views and Refresh options
    • Refresh Options for Materialized Views with Aggregates
    • Refresh Options for Materialized Views Containing Only Joins
    • Refresh Options for Nested Materialized Views
  • Choosing Indexes for Materialized Views
  • Partitioning and Materialized Views
  • Compressing Materialized Views

4 ETL Implementation and Customization

• The Role of ETL in the Oracle Communications Data Model
• ETL for the Foundation Layer of an Oracle Communications Data Model Warehouse
  • Using an Application Adapter to Populate the Foundation Layer
  • Writing Your Own Source-ETL
    • Source-ETL Design Considerations
    • ETL Architecture for Oracle Communications Data Model Source-ETL
    • Creating a Source to Target Mapping Document for the Source-ETL
    • Designing a Plan for Rectifying Source-ETL Data Quality Problems
    • Designing Source-ETL Workflow and Jobs Control
    • Designing Source-ETL Exception Handling
    • Writing Source-ETL that Loads Efficiently
• Customizing Intra-ETL for the Oracle Communications Data Model
• 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 Intra-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 and Aggregate Tables
    • Refreshing Oracle Communications Data Model OLAP Cubes
    • Refreshing Oracle Communications Data Model Data Mining Models
• Managing Errors During Oracle Communications Data Model Intra-ETL Execution
  • Monitoring the Execution of the Intra-ETL Process
  • Recovering an Intra ETL Process
  • Troubleshooting Intra-ETL Performance
    • Checking the Execution Plan
    • Monitoring PARALLEL DML Executions
    • Troubleshooting Data Mining Model Creation

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
• Writing As Is and As Was Queries
  • Characteristics of an As Is Query
  • Characteristics of an As Was Query
  • Examples: As Is and As Was Queries Against Oracle Communications Data Model
• Tutorial: Creating a New Oracle Communications Data Model Dashboard
• Tutorial: Creating a New Oracle Communications Data Model Report

A Sizing and Configuring an Oracle Communications Data Model Warehouse

• Sizing an Oracle Communications Data Model Warehouse
• Configuring a Balanced System for Oracle Communications Data Model
  • Maintaining High Throughput in an Oracle Communications Data Model Warehouse
  • Configuring I/O in an Oracle Communications Data Model for Bandwidth not Capacity
  • Planning for Growth of Your Oracle Communications Data Model
  • Testing the I/O System Before Building the Warehouse
  • Balanced Hardware Configuration Guidelines for Oracle Communications Data Model

B 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 Select Privileges to Users of the Sample Reports

C Using the NCC Adapter for Oracle Communications Data Model

• What is the NCC Adapter for Oracle Communications Data Model?
  • Database Schemas Used by the NCC Adapter for Oracle Communications Data Model
  • Oracle Data Integrator
  • Oracle GoldenGate
• Populating a Warehouse Using the NCC Adapter for Oracle Communications Data Model
  • Initial Loading Using the NCC Adapter for Oracle Communications Data Model
  • Refreshing the Data Using the NCC Adapter for Oracle Communications Data Model
    • Refreshing the Foundation Layer on a Scheduled Basis
    • Refreshing the Foundation Layer with Real-Time Data
• NCC Adapter for Oracle Communications Data Model Execution Flows
  • Execution Flow When Using the Adapter Oracle GoldenGate and ODI
  • Execution Flow When Using the Adapter with only ODI
• Components of the NCC Adapter for Oracle Communications Data Model
  • NCC Source Schema Objects
  • Schema Definitions Added by the NCC Adapter for Oracle Communications Data Model
    • ncc_stg Schema Objects
    • Definitions Added to the ocdm_sys Schema
  • The NCC_OCDM Project
    • SRC_STG_NONAGG Folder
    • STG_OCDM Folder
• Oracle Communications Data Model Tables and Columns Filled by NCC Adapter

D Using the Oracle Communications Billing and Revenue Management Adapter

• What is the BRM Adapter for Oracle Communications Data Model?
• Components of BRM Adapter for Oracle Communications Data Model
  • BRM Source Schema Tables
  • BRM Adapter for Oracle Communications Data Model Database Schemas
  • Schema Definitions Added for the BRM Adapter for Oracle Communications Data Model
    • BRM Adapter for Oracle Communications Data Model Staging Schema Objects
    • BRM Adapter for Oracle Communications Data Model OCDM_SYS Objects
  • Oracle Data Integrator
  • Oracle GoldenGate Replication
• BRM Adapter for Oracle Communications Data Model Execution Flows
  • Execution Flow Using BRM Adapter: ODI Pull Version (without Oracle GoldenGate)
  • Execution Flow Using BRM Adapter: with Oracle GoldenGate and ODI
• Populating a Warehouse Using the BRM Adapter for Oracle Communications Data Model
  • Initial Loading Using the BRM Adapter for Oracle Communications Data Model
  • Refreshing the Data Using the BRM Adapter for Oracle Communications Data Model (Change Data Capture: CDC)
    • Refreshing the Foundation Layer on a Scheduled Basis
    • Refreshing the Foundation Layer with Real-Time Data
  • ODI BRM_OCDM Project
    • Objects in SRC_STG_NONOGG Folder of BRM_OCDM Project
    • SRC_STG_LOAD_NON_OGG_PKG Package
    • Objects in STG_OCDM Folder of BRM_OCDM
    • STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG Package
• Oracle GoldenGate Process Checking

E 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

Index