Go to main content
1/14
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
Scripting on this page enhances content navigation, but does not change the content in any way.