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:

Types of Installations Provided for Oracle Retail Data Model
Oracle Retail Data Model Home Directory Structure
Overview of the Installation Process

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:

Installation of the Oracle Retail Data Model component, itself. You must install this component to create an Oracle Retail 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.

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:

report which contains the sample report files required for the Oracle Retail 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 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:

Read Oracle Retail Data Model Release Notes to identify any last minute changes.
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."
Identify and perform any necessary pre-installation tasks, as described in "Pre-installation Tasks".
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.
Identify and perform any necessary postinstallation tasks, as described in "Post-Installation Tasks".
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.