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