Oracle® Airlines Data Model Installation Guide 11g Release 2 (11.2) Part Number E26210-01 |
|
|
PDF · Mobi · ePub |
This chapter describes how to install Oracle Airlines Data Model and other components you use to create a Oracle Airlines Data Model data warehouse:
Using the Oracle Universal Installer you can perform two types of Oracle Airlines Data Model installations:
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 a Airlines Data Model installation of Oracle Airlines Data Model, 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.
See:
For detailed information about all created objects in the OADM_SYS schema, see the Oracle Airlines Data Model Reference.There is no data in this schema. You need to populate data into the schema.
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 OBIEE server. Specifically, the installer installs:
The following files that provide 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 isoadm_sample
.oadm_sample.eif
which is a dump file containing sample data for the Oracle Airlines Data Model analytic workspace (that is, the OLAP cubes).
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 the following directories under ORACLE_HOME
/oadm
:
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 of Oracle Airlines Data Model requires the following tasks:
Read Oracle Airlines Data Model Release Notes to identify any last minute changes.
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."
Identify and perform any necessary pre-installation tasks, as described in "Pre-installation Tasks".
Install the Oracle Airlines Data Model component or the Oracle Airlines 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 post-installation tasks, as described in "Post-Installation Tasks".
Install the additional components that you need to create an Oracle Airlines Data Model data warehouse or run the sample reports, as described in Chapter 4, "Installation of Additional Components."
Note 1:
To deinstall Oracle Airlines Data Model, you do not simply run the Oracle Universal Installer in deinstall mode. To deinstall Oracle Airlines Data Model, follow the directions in Chapter 5, "Backup, Recovery, and Deinstallation of Oracle Airlines Data Model."Note 2:
You must deinstall Oracle Airlines Data Model before you re-install it over an existing version of Oracle Airlines Data Model.