Skip Headers
Oracle® Retail Data Model Installation Guide
Release 11.3.2

Part Number E20362-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

2 Introduction to Oracle Retail Data Model Installation

This chapter describes how to install Oracle Retail Data Model and other components you use to create an Oracle Retail Data Model data warehouse:

To deinstall Oracle Retail Data Model, see Chapter 5, "Backup, Recovery, and Deinstallation of Oracle Retail Data Model".

After you install Oracle Retail Data Model you can customize the data model; for instructions, see the Oracle Retail Data Model Operations Guide. The Oracle Retail Data Model Operations Guide describes other tasks that you can perform, including creating (building) mining models.

Types of Installations Provided for Oracle Retail Data Model

Using Oracle Universal Installer you can perform two types of Oracle Retail Data Model installations:

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

Retail Data Model Installation

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

  • ordm_sys which is the main schema for the Oracle Retail Data Model. This schema contains all the relational and OLAP components of the Oracle Retail Data Model, including the Oracle Retail Data Model data mining source and results tables.

See:

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

When you install Oracle Retail Data Model, there is no transactional data in the schema. The installation populates certain core tables such as lookup tables and reference entities. You need to populate fact, transactional data into the schema.

Sample Reports Installation

When you perform a Sample Reports installation of the Oracle Retail Data Model, Installer creates the Oracle Retail Data Model sample schema in the target database. Specifically, the Installer installs:

  • The following file that provides the data for the sample reports:

    • ordm_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 Retail Data Model.

      Tip:

      The default user name for the schema is ordm_sample. The default password is: password. Contact Oracle support to obtain the Oracle Retail Data Model sample schema password.
  • The following files that define and create the sample reports:

    • ordm.rpd

    • ordmwebcat.zip

    Oracle Retail Data Model includes sample schemas and reports that you may find useful when you develop your own schemas and reports. The sample schemas include the schema with data that enables you to run the sample reports. When you install the sample schemas and reports, you must perform an additional postinstallation task. For more details see "Installing RPD and WebCat for OBIEE".

    Note:

    When you deploy the rpd you need to provide an rpd password. Contact Oracle support to obtain the Oracle Retail Data Model rpd password.

Oracle Retail Data Model Home Directory Structure

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

Table 2-1 Oracle Retail Data Model Home Directory Structure

Subdirectory Description

interface

 

mining/src

Data mining scripts and related files

olap

OLAP scripts and related files

relational

Relational schema installation scripts and relational related files

relational/intra_etl

Intra-ETL Oracle Warehouse Builder dump and related files

relational/sample_schema

Sample schema and sample related files

relational/sql_scripts

Relational schema installation scripts

relational/sql_scripts/intra_etl

Intra-ETL load packages including OLAP Intra-ETL load package

utilities

Metadata generation and update related files and other utilities


Overview of the Installation Process

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

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

  2. Verify that your system is a supported platform 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 Retail Data Model component or the Oracle Retail 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 postinstallation tasks, as described in "Post-Installation Tasks".

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

Note 1:

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

Note 2:

You must deinstall Oracle Retail Data Model before you re-install it over an existing version of Oracle Retail Data Model.