1 Introduction to Oracle Airlines Data Model Installation

Describes how to install Oracle Airlines Data Model and the sample reports for Oracle Airlines Data Model.

Use the installer to create an Oracle Airlines Data Model data warehouse:

Types of Installations Provided for Oracle Airlines Data Model

Specifies details for the Airlines Data Model installation type and the Sample Reports installation type.

Using the Oracle Universal Installer you can perform two types of Oracle Airlines Data Model installation:

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

Airlines Data Model Installation

When you perform an Airlines Data Model installation, the Oracle Universal Installer installs the Oracle Airlines Data Model component without data. Specifically, the installer creates the following schema in the target database:

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

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

Sample Reports Installation

When you perform a Sample Reports installation of the Oracle Airlines Data Model, the installer creates the Oracle Airlines Data Model sample schema in the target database, and copies and configures all the sample reports to your Oracle Business Intelligence Suite Extended Edition server. Specifically, the installer installs:

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

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

      Tip:

      The default user name for the schema is oadm_sample.

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

    • oadm.rpd

    • oadmwebcat.zip

Oracle Airlines Data Model Home Directory Structure

The installation image contains directories that are installed under the path ORACLE_HOME/oadm.

The installation includes the following directories:

  • report: which contains the sample report files for Oracle Airlines Data Model installation.

  • pdm: which contains the physical schema dump, creation scripts, and lookup value population scripts, as listed in the following table:


Subdirectory Description

metadata

Metadata creation and population scripts

mining

Data mining scripts and related files

olap

OLAP scripts and related files

relational

Relational schema installation scripts and relational related files

relational/ddl

Relational schema installation scripts and related scripts

relational/ddl/calendar

Calendar and time data population scripts

relational/ddl/intra_etl

Intra-ETL scripts

relational/ddl/lookup_value

Lookup data population scripts

relational/sample_schema

Physical sample schema


Installation Checklist

Provides a checklist of the steps involved to install Oracle Airlines Data Model.

Installation Checklist for Oracle Airlines Data Model

  • Release notes: Read Oracle Airlines Data Model Release Notes to identify any changes for the installation.

  • Hardware and Software: Verify Hardware and Software Requirements

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

  • Preinstallation Steps: Perform Preinstallation Tasks Identify and perform any necessary pre-installation tasks, as described in "Pre-installation Tasks".

  • Installation and Postinstallation Steps Run Installer and perform Postinstallation Tasks

  • Add Additional Components:

    Perform Installation Steps for Additional Components

    Install the additional components that you need as described in "Installation of Additional Components".

Note:

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

To deinstall Oracle Oracle Airlines Data Model, you do not run the Oracle Universal Installer in deinstall mode. To deinstall Oracle Airlines Data Model, follow the directions in Backup, Recovery, and Deinstallation of Oracle Airlines Data Model