Index

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

---

A

aggregate tables

physical data model, 3.5

---

B

base entities.

See entities, Oracle Airlines 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.7, 3.8

derived tables

physical data model, 3.4

---

E

entities, Oracle Airlines Data Model

logical, 2

lookup, 2.2, 3.6

entity dictionary, 2.6

---

I

intra-ETL, 6

DWC_OLAP_ETL_PARM table, A.2

PL/SQL mapping, 6.3, 6.3

---

L

logical data model, 2.6

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 Airlines Data Model, 2.2, 3.6

lookup tables

physical data model, 2.2, 3.6

---

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.10

OLAP cube views

from oadm_sys schema, 3.10

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

base tables, 3.3

database sequences, 3.7, 3.8

derived tables, 3.4

lookup tables, 2.2, 3.6

OLAP cube materialized views, 3.10

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

---

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