Oracle Healthcare Analytics Data Integration Release Notes

Release 1.0

Part Number: E26574-02

Last revised: 04 January 2012

This document provides a complete, up-to-date description of Oracle Healthcare Analytics Data Integration (OHADI) Release 1.0. You should ensure that you have the most current version of this document, and that you have read and understand all tasks described herein before you begin your installation.

How to Use This Document

This document contains the following information about OHADI Release 1.0:

Media Pack Contents
Product Description
Implementation and User Documentation

1. Media Pack Contents

This Media Pack contains the following files required to install the physical data model portion of Oracle Healthcare Analytics Data Integration 1.0 (OHADI) and the associated documentation:

Filename	Contains
doc\ohadi_r1_0_mediapack_docs.zip	User Documentation Files
software\ohadi_metadata_config_ddl_1_0.sql	Script to create Physical Database Objects for Metadata Configuration Schema
software\ohadi_interface_grant_access_1_0.sql	Script to grant SELECT permission to metadata configuration user and HDWF user to access interface schema tables
software\ohadi_metadata_config_grant_access_1_0.sql	Script to grant SELECT permission to HDWF user to access metadata configuration schema tables
software\ohadi_etl_seed_data_scripts.zip	Contains seed data procedures and scripts

Top

2. Product Description

OHADI provides a rich platform for processing of data from diverse source systems and loading of the homogenized, consistent, complete, correct and standardized analytics ready data into HDWF.

OHADI provides the following features:

Interface tables that provide abstraction from Oracle Healthcare Data Warehouse Foundation (HDWF), serve as system of original record proxy (SORP), support versioning of data and act as persistent placeholder for incoming data from source systems.
Rules management including basic validation and integration rules that are integral part of Warehouse Integration ETL; Configurable rules that allow suspension of data to accommodate late arriving data and Pre-packaged; ready to use business rules based on variety of rule patterns.
Master data management that includes terminology standardization and validation as well as standardization of units of measure codes.
Metadata management that covers business, technical, process and operational metadata.
Exception management that includes identification of exception conditions during data validation, comprehensive exception logs with traceability to erroneous data and configurable exception messages.
Data governance via data profiling, management of data quality, metadata management, support for data lineage and impact analysis, versioning of data and support for auditing.
Comprehensive information on inter-dependency of all of the tables in HDWF that can be used for creating customized ETL packages.

Top

3. Implementation and User Documentation

The Oracle Healthcare Analytics Data Integration 1.0 Media Pack includes the following user documentation:

Oracle Healthcare Analytics Data Integration Release Notes [This document]
Oracle Healthcare Analytics Data Integration Release Content Document
Oracle Healthcare Analytics Data Integration Secure Installation and Configuration Guide

Using the Oracle Healthcare Analytics Data Integration Release Content Document

To use Oracle Healthcare Analytics Data Integration Release Content Document, navigate to the rcd folder and click rcd.htm.

Using the Oracle Healthcare Analytics Data Integration Secure Installation and Configuration Guide

To use Oracle Healthcare Analytics Data Integration Secure Installation and Configuration Guide, navigate to the iguide folder and click iguide.htm.

Top

Oracle Corporation

Trademark Information
Oracle is a registered trademark of Oracle Corporation.