Index

A B C D E I L O P R S U

A

aggregate tables

physical data model, 3.5, 3.6

B

base entities.

See entities, Oracle Retail Data Model

base tables

physical data model, 3.3

C

calendar population

utility scripts, 10.1

D

data mining in Oracle Airlines Data Model See data mining models, Oracle Airlines Data Model

database sequences

physical data model, 3.8, 3.9

derived tables

physical data model, 3.4

E

entities, Oracle Airlines Data Model

logical, 2

entities, Oracle Retail Data Model

lookup, 2.2, 3.7

entity dictionary, 2.6, 2.7

I

intra-ETL, 6

DWC_OLAP_ETL_PARM table, A.2

PL/SQL mapping, 6.3, 6.3, 6.3

L

logical data model, 2.6, 2.7

reference entities, 2.1, 2.2, 2.3, 2.4, 2.5

logical data model, Oracle Airlines Data Model, 2

logical entities, Oracle Airlines Data Model, 2

logical to physical mapping

Oracle Airlines Data Model, 4

lookup entities, Oracle Retail Data Model, 2.2, 3.7

lookup tables

physical data model, 2.2, 3.7

O

OLAP cube

account debt cube, 8.2, 8.3, 8.4, 8.5, 8.6, 8.7, 8.8

ADM, 8.2, 8.3, 8.4, 8.5, 8.6, 8.7, 8.8

OLAP cube materialized views, 3.11

OLAP cube views

from oadm_sys schema, 3.11

OLAP model dimensions

Oracle Airlines Data Model, 7

Oracle Airlines Data Model, 3, 6

components summary, 1.3

intra-ETL, 6

logical data model, 2, 3

logical to physical mapping, 4

OLAP model dimensions, 7

physical data model partitioning, 5

sample reports, 11

utility scripts, 10

P

physical data model, 3

aggregate tables, 3.5, 3.6

base tables, 3.3

database sequences, 3.8, 3.9

derived tables, 3.4

lookup tables, 2.2, 3.7

OLAP cube materialized views, 3.11

partitioning, 5

reference tables, 3.2

physical data model, Oracle Airlines Data Model, 3

physical entities, Oracle Airlines Data Model

physical, 3

PL/SQL mapping for intra-ETL, 6.3, 6.3, 6.3

R

reference tables

physical data model, 3.2

S

sample reports

Oracle Airlines Data Model, 11

U

utility scripts

calendar population, 10.1

Oracle Airlines Data Model, 10