2 Introduction to Oracle Healthcare Data Model Installation

This chapter describes how to install Oracle Healthcare Data Model (11.2.3) and other components you use to create an Oracle Healthcare Data Model data warehouse:

• Types of Installations Provided for Oracle Healthcare Data Model

• Overview of the Installation Process

Types of Installations Provided for Oracle Healthcare Data Model

Using the Oracle Installer you can perform two types of Oracle Healthcare Data Model installations:

• Installation of the Oracle Healthcare Data Model component, itself. You must install this component to create an Oracle Healthcare Data Model data warehouse.

• Installation of sample reports (and schemas) that you can use for ideas about how to design your own reports. Installing these samples is optional.

  Note:

  The reports and dashboards that are used in examples and delivered with the Oracle Healthcare Data Model are provided only for demonstration purposes. They are not supported by Oracle.

Different items are installed depending on whether you install the database objects or the sample reports and schemas.

Healthcare Data Model Installation

When you perform a Healthcare Data Model installation of the Oracle Healthcare Data Model, Installer installs the Oracle Healthcare Data Model component without data. Specifically, Installer creates the following schemas in the target database:

• ohdm_sys which is the main schema for the Oracle Healthcare Data Model. This schema contains all the relational and OLAP components of the Oracle Healthcare Data Model, including the Oracle Healthcare Data Model data mining results tables. This also includes Mining Source Tables, Mining Result Tables, and Mining Support tables and the Mining Model Package.

See:

For detailed information about all created objects in the OHDM_SYS schema, see the Oracle Healthcare Data Model Reference.

There is no data in the schema. You need to populate data into the schema.

Sample Reports Installation

When you perform a Sample Reports installation of the Oracle Healthcare Data Model, Installer creates the Oracle Healthcare Data Model sample schema in the target database, and copies and configures all the sample reports to your OBIEE server. Specifically, the Installer installs:

• The following files that provide the data for the sample reports:

  • ohdm_sample.dmp.zip which is a dump file of the schemas that contain the sample data for the relational, OLAP, and data mining components of Oracle Healthcare Data Model.

    Tip:

    The default user name for the schema is ohdm_sample_sys. The default password is: password.

• The following files that define and create the sample reports:

  • ohdm.rpd

  • ohdmwebcat.zip

Oracle Healthcare Data Model Home Directory Structure

The installation image contains the following directories under ORACLE_HOME/ohdm:

• bin which contains the install configuration script.

• report which contains the sample report files required for the Oracle Healthcare Data Model installation.

• pdm which contains the physical schema dump, creation script, and lookup value population as listed in Table 2-1.

Table 2-1 Oracle Healthcare Data Model Home Directory Structure

Subdirectory	Description
relational	Relational schema installation scripts and relational related files
relational/ddl	Relational schema installation scripts
relational/ddl/kpi_pkg	KPI data population packages
relational/ddl/metadata	Metadata table creation and data population scripts
intra_etl/owb	Intra-ETL Oracle Warehouse Builder workflow
relational/fk_disable	Constraints disable/enable scripts
sample_schema	Physical sample schema
mining	Data mining scripts and related files
olap	OLAP scripts and related files

Overview of the Installation Process

Installation of the Oracle Healthcare Data Model requires the following tasks:

1. Read Oracle Healthcare Data Model Release Notes to identify any last minute changes.

2. Verify that your system is one of the supported platforms and that it satisfies the hardware and software requirements as described in Chapter 1, "Hardware and Software Requirements."

3. Identify and perform any necessary pre-installation tasks, as described in "Pre-installation Tasks".

4. Install the Oracle Healthcare Data Model component or the Oracle Healthcare Data Model sample reports, as described in "Installer Execution".

   Tip:

   you can also perform a silent installation, see "Silent Installation" for more information.

5. Identify and perform any necessary post-installation tasks, as described in "Post-Installation Tasks".

6. Install the additional components that you need to create an Oracle Healthcare Data Model data warehouse or run the sample reports, as described in Chapter 4, "Installation of Additional Components."

Note:

To deinstall Oracle Healthcare Data Model, follow the directions in Chapter 5, "Backup, Recovery, and Deinstallation of Oracle Healthcare Data Model." You must deinstall Oracle Healthcare Data Model before you re-install it.