Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Related Oracle Resources
• Conventions

1 Introduction to Oracle Communications Data Model Customization

• What is the Oracle Communications Data Model?
  • Components of 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 Implementers
  • 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 the Oracle Communications Data Model
  • Data Compression in the Oracle Communications Data Model
    • Basic and Standard Compression
    • OLTP Compression
    • Hybrid Columnar Compression
  • 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
    • Specify Partitioning for Manageability
    • Specify Partitioning for Easier Data Access
    • Oracle Communications Data Model Partitioning 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

• 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
    • 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 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
  • 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 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
  • 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 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 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
• How to Create a New Oracle Communications Data Model Dashboard
• How to Create 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 Communications 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 Communication 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 Warehouse

• 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
  • Balanced Hardware Configuration Guidelines for Oracle Communications Data Model

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