Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Oracle Healthcare Data Model

• What is Oracle Healthcare Data Model?
• Oracle Healthcare Data Model Logical and Physical Models
  • Logical Model
    • Supported Oracle Healthcare Data Model Categories and Subject Areas
    • Common Patterns of Subject Areas
  • Physical Model
• Oracle Products That Make Up the Oracle Healthcare Data Model
• Where Oracle Healthcare Data Model Fits in a Data Warehousing Project
• Prerequisite Knowledge for Customizers

2 Customizing the Oracle Healthcare Data Model

• Overview: Customization Steps
• Performing Fit-Gap Analysis
• Discovering the Oracle Healthcare Data Model Metadata
  • Measure-Entity tab
  • Entity-Measure tab
  • Program-Table tab
  • Table-Program tab
• Modifying the Oracle Healthcare Data Model Metadata

3 Populating an Oracle Healthcare Data Model Warehouse

• Pre-population Tasks
• Overview: The ETL for an Oracle Healthcare Data Model Warehouse
• Source-ETL for Oracle Healthcare Data Model
• Intra-ETL for Oracle Healthcare Data Model
• Steps: Populating a Oracle Healthcare Data Model Warehouse
• Managing Errors During 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
• Modifying the ETL to Change the Code Names

4 Working with an Oracle Healthcare Data Model Warehouse

• Customizing the Reports Delivered with Oracle Healthcare Data Model
  • Tools for Customizing Reports
  • Troubleshooting Reporting Performance
• Writing Your Own Queries and Reports
• Creating New OLAP Cubes
• Working with the Oracle Healthcare Data Model Data Mining Model
  • Modifying the Data Mining Model
  • Refreshing the Data Model
• Improving Performance
  • Adding b-tree Indexes
  • Altering Parallelization
    • Enabling Parallel Execution for a Session
    • Enabling Parallel Execution of DML Operations
    • Enabling Parallel Execution at the Table Level
  • Adding Partitions
  • Changing the Tablespaces and Partitions Used by Tables
    • Diverting Partitions into New Tablespaces
    • Changing an Existing Tablespace
• Working with Compression
• Working with User Privileges

Index