Skip Headers
Oracle® Airlines Data Model Implementation and Operations Guide
11g Release 2 (11.2)

E26211-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  C  D  E  F  H  I  J  K  L  M  N  O  P  Q  R  S  T 

A

access layer, 2.1
customizing, 3, 3.1
Oracle Airlines Data Model, 2.1, 3
aggregate tables
in Oracle Airlines Data Model, 3.4
As Is reports, 5.6.1
As Was reports, 5.6.1

C

compression
in Oracle Airlines Data Model, 2.4.2, 2.4.2.1, 2.4.2.1.1
materialized views, 3.6.4
configuring Oracle Airlines Data Model warehouse, A.2
conventions
when customizing physical model, 2.2.2
cubes
adding materialized view capabilities to, 3.5.3.2
changing the dimensions of, 3.5.6
changing the measures of, 3.5.6
customizing, 3.5.4
data maintenance methods, 3.5.9
forecast, 3.5.7
in Oracle Airlines Data Model, 3.5.4, 3.5.5
partitioning, 3.5.8
customizing
access layer, 3
cubes, 3.5.4
Oracle Airlines Data Model, 1.2
physical data model, 2

D

dashboards, Oracle Airlines Data Model, 5.2
data governance committee, responsibilities of, 1.3.2
data mining models
customizing, 3.3.2
derived tables
in Oracle Airlines Data Model, 3.3
dimensional components, Oracle Airlines Data Model, 3.5

E

error handling
during intra-ETL execution, 4.6
ETL for Oracle Airlines Data Model, 4.1

F

fit-gap analysis for Oracle Airlines Data Model, 1.5
forecast cube in Oracle Airlines Data Model, 3.5.7
foundation layer
defined, 2.1
Oracle Airlines Data Model, 2.1

H

HCC, 2.4.2.1.3
hybrid columnar compression
and Oracle Airlines Data Model, 2.4.2.1.3

I

implementers of Oracle Airlines Data Model
prerequisite knowledge, 1.3.1
implementing
Oracle Airlines Data Model, 1.2
indexes
in Oracle Airlines Data Model, 2.4.6
materialized views, 3.6.2
partitioning, 2.4.6
integrity constraints
in Oracle Airlines Data Model, 2.4.5
intra-ETL
customizing, 4.3
managing errors, 4.6
monitoring execution of, 4.6.1
Oracle Airlines Data Model, 4.1
recovery, 4.6.2
troubleshooting, 4.6.3

J

join performance, improving, 2.4.7.3

K

keys, surrogate
in Oracle Airlines Data Model, 2.4.4

L

loading Oracle Airlines Data Model data, 4.4, 4.4.2

M

materialized views
compressing, 3.6.4
in Oracle Airlines Data Model, 3.6
indexing, 3.6.2
partition change tracking, 3.6.3
partitioning, 3.6.3
refresh options
refreshing, 3.6.1
metadata management
repository, 1.4.2, 1.4.3
with Oracle Airlines Data Model, 1.4
metadata repository, 1.4.2
browsing, 1.4.3
with Oracle Airlines Data Model, 1.4.3

N

naming conventions
for physical model of Oracle Airlines Data Model, 2.2.2.1

O

Oracle Airlines Data Model
access layer, 2.1, 3
components of, 1.1.1
customizing, 1.2
customizing physical model, 2.1, 2.2, 2.2.1, 2.2.2, 2.4
dashboards, 5.2
data governance, 1.3.2
described, 1.1
dimensional components, 3.5
ETL, 4.1
fit-gap analysis, 1.5
foundation layer, 2.1
implementing, 1.2
intra-ETL, 4.1
loading, 4.4, 4.4.2
metadata management, 1.4
metadata repository, 1.4.2, 1.4.3
Oracle products used by, 1.1.2
physical layers of, 2.1
pre-implementation tasks, 1.3
querying, 5.3
refreshing data, 4.5
reporting, 5.1, 5.3
sample reports, 5.2
source-ETL, 4.1, 4.2, 4.2.2, 4.2.3, 4.2.4, 4.2.5
staging layer, 2.1
tablespaces, design recommendations, 2.4.1
Oracle Airlines Data Model implementers
prerequisite knowledge for, 1.3.1
Oracle Airlines Data Model warehouse
configuring, A.2
sizing, A.1
Oracle data mining models
Oracle Airlines Data Model, 3.3.2.1

P

parallel execution
enabling for a session, 2.4.8.1
enabling for DML operations, 2.4.8.2
in Oracle Airlines Data Model, 2.4.8
partition change tracking, 3.6.3
partition exchange load, 4.2.7.5
partitioned indexes in Oracle Airlines Data Model, 2.4.6
partitioning
cubes, 3.5.8
for easier data access, 2.4.7.2
for join performance, 2.4.7.3
for manageability, 2.4.7.1
for source-ETL, 4.2.7.5
indexes, 2.4.6
materialized views, 3.6.3
tables, 2.4.7
partitions, changing, 2.4.1
physical model of Oracle Airlines Data Model
characteristics of, 2.1, 2.2, 2.2.1
customizing, 2.2.2
general recommendations for, 2.4

Q

querying Oracle Airlines Data Model, 5.3

R

refreshing
Oracle Airlines Data Warehouse, 4.5
reporting
Oracle Airlines Data Model, 5.1, 5.3
reports
approaches to, 5.1
As Is, 5.6.1
As Was, 5.6.1
troubleshooting performance, 5.5
reports, Oracle Airlines Data Model
creating new, 5.8

S

sample reports
customizing, 5.2
sizing
Oracle Airlines Data Model warehouse, A.1
source-ETL
exception handling, 4.2.6
jobs control, 4.2.5
loading considerations, 4.2.7
Oracle Airlines Data Model, 4.1, 4.2, 4.2.2, 4.2.3, 4.2.4, 4.2.5, 4.2.7
parallel direct path load, 4.2.7.4
partitioning for, 4.2.7.5
workflow, 4.2.5
staging layer, 2.1
Oracle Airlines Data Model, 2.1
star queries, optimizing, 5.4
subtypes
defining tables for, 2.4.3
physical implementation of, 2.4.3
supertypes
defining tables for, 2.4.3
physical implementation of, 2.4.3
surrogate keys
in Oracle Airlines Data Model, 2.4.4

T

tables
aggregate, 3.4
compressing, 2.4.2, 2.4.2.1, 2.4.2.1.1
derived, 3.3
partitioning, 2.4.7
tablespace in Oracle Airlines Data Model, 2.4.1