Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Oracle Resources
• Conventions

1 Introduction to Oracle Utilities Data Model Customization

• What is the Oracle Utilities Data Model?
  • Components of Oracle Utilities Data Model
  • Oracle Products That Make Up Oracle Utilities Data Model
• Implementing an Oracle Utilities Data Model Warehouse
• Before You Begin Customizing Oracle Utilities Data Model
  • Prerequisite Knowledge for Implementors
  • Responsibilities of a Data Warehouse Governance Committee
• Performing Fit-Gap Analysis for Oracle Utilities Data Model
• Data Encryption and Security for Oracle Utilities Data Model

2 Physical Model Customization

• Characteristics of the Default Physical Model
• Customizing the Oracle Utilities 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 Oracle Utilities Data Model
  • Data Compression in Oracle Utilities Data Model
    • Types of Data Compression Available
  • Tables for Supertype and Subtype Entities in Oracle Utilities Data Model
  • Surrogate Keys in the Physical Model
  • Integrity Constraints in Oracle Utilities Data Model
  • Indexes and Partitioned Indexes in Oracle Utilities Data Model
  • Partitioned Tables in Oracle Utilities Data Model
    • Partitioning the Oracle Utilities Data Model for Manageability
    • Partitioning the Oracle Utilities Data Model for Easier Data Access
    • Partitioning the Oracle Utilities Data Model for Join Performance
  • Parallel Execution in Oracle Utilities 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 Utilities Data Model
• Derived Tables in Oracle Utilities Data Model
  • Creating New Derived Tables for Calculated Data
  • Customizing Oracle Utilities Data Model Data Mining Models
    • Creating a New Data Mining Model for Oracle Utilities Data Model
    • Modifying Oracle Utilities Data Model Data Mining Models
• Aggregate Tables in Oracle Utilities Data Model
• Dimensional Components in Oracle Utilities 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 Utilities Data Model
  • Defining New Oracle OLAP Cubes for Oracle Utilities Data Model
  • Changing an Oracle OLAP Cube in Oracle Utilities Data Model
  • Creating a Forecast Cube for Oracle Utilities Data Model
  • Choosing a Cube Partitioning Strategy for Oracle Utilities Data Model
  • Choosing a Cube Data Maintenance Method for Oracle Utilities Data Model
• Materialized Views in Oracle Utilities Data Model
  • Types of Materialized Views and Refresh Options
  • Choosing Indexes for Materialized Views
  • Partitioning and Materialized Views
  • Compressing Materialized Views

4 ETL Implementation and Customization

• The Role of ETL in Oracle Utilities Data Model
• ETL for the Foundation Layer of an Oracle Utilities Data Model Warehouse
  • Writing Your Own Source-ETL
  • Source-ETL Design Considerations
  • ETL Architecture for Oracle Utilities 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
    • Using a Staging Area for Flat Files
    • Preparing Raw Data Files for Source-ETL
    • Source-ETL Data Loading Options
    • Parallel Direct Path Load Source-ETL
    • Partition Exchange Load for Oracle Utilities Data Model Source-ETL
• Customizing Intra-ETL for Oracle Utilities Data Model
  • Executing Derived Intra-ETL Programs
  • Refreshing Aggregate Materialized Views
  • Refreshing OLAP Cubes
  • Executing Intra-ETL Workflow
• Performing an Initial Load of an Oracle Utilities Data Model Warehouse
  • Performing an Initial Load of the Foundation Layer
  • Performing an Initial Load of the Access Layer
  • Executing the Default Oracle Utilities Data Model Intra-ETL
• Refreshing the Data in an Oracle Utilities Data Model Warehouse
  • Refreshing the Foundation Layer of Oracle Utilities Data Model Warehouse
  • Refreshing the Access Layer of an Oracle Utilities Data Model Warehouse
  • Refreshing Oracle Utilities Data Model Derived Tables
  • Refreshing Oracle Utilities Data Model Aggregate Materialized Views
  • Refreshing Oracle Utilities Data Model OLAP Cubes
  • Refreshing Oracle Utilities Data Model Data Mining Models
• Managing Errors During Oracle Utilities Data Model Intra-ETL Execution
  • Monitoring the Execution of the Intra-ETL Process
  • Recovering an Intra ETL Process

5 Report and Query Customization

• Reporting Approaches in Oracle Utilities Data Model
• Customizing Oracle Utilities Data Model Sample Reports
• Writing Your Own Queries and Reports
• Optimizing Star Queries
• Troubleshooting Oracle Utilities 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 Utilities Data Model
• Tutorial: Creating a New Oracle Utilities Data Model Dashboard
• Tutorial: Creating a New Oracle Utilities Data Model Report

6 Metadata Collection and Reports

• Overview of Managing Metadata for Oracle Utilities Data Model
  • Metadata Categories and Standards
  • Working with 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 Attribute Measures
  • Using the Program-Table Tab
  • Using the Table-Program Tab
• Collecting and Populating Metadata
  • Load LDM/PDM Metadata (Table MD_ENTY)
    • GIVE_ABBRV
    • MD_DM_ALL_ENT_ATTR
    • PL/SQL Program to Update Column Name
    • PL/SQL program to insert initial data into MD_OIDM_ATTR_COL_NAM
    • PL/SQL program to load data into MD_ENTY
  • Load Program (Intra-ETL) Metadata (Table MD_PRG)
  • Load Reports and KPI Metadata (Table MD_KPI and MD_REF_ENTY_KPI):

7 Working with User Roles and Privileges in Oracle Utilities Data Model

• Accounts Created for Oracle Utilities Data Model
• Roles and Privileges in Oracle Utilities Data Model
• When You Must Consider User Privileges in an Oracle Utilities Data Model
  • Granting Only Required Privileges to Database Users of OUDM_SYS
  • Granting Permission Privileges for Oracle Business Intelligence Suite Extended Edition Reports to Users and Roles

8 Oracle Utilities Data Model Security

• Oracle Utilities Data Model Security Overview
• Architecture Analysis for Security
• Security by Component
• Performing a Secure Oracle Utilities 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 Utilities 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 OUDM_SYS Schema from DBA Access
• Data Masking on Oracle Utilities Data Model
  • Using Data Masking
• Transparent Data Encryption in Oracle Utilities Data Model
  • Configuring a Software Keystore
  • Demonstration of Oracle Utilities Data Model Working with TDE

A Sizing and Configuring an Oracle Utilities Data Model Warehouse

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

Index