Beta Draft: 2012-07-16

Index

A  B  C  D  E  F  H  I  L  M  O  P  R  S  T  U 

Numerics

3NF, 3.3

A

architecture, 2
attributes, 3.2

B

BI tools, 2.4

C

common tasks
in data warehouses, 1.2.2
complex queries
snowflake schemas, 3.4.3

D

data layers, 2.3
data mining, 7.3
data segment compression, 4.2.3
partitioning, 4.2.3
data sources, 2.2
data warehouse
data sources, 2.2
layers, 2.3
physical design, 4.1
Data Warehouse Reference Architecture, 2
data warehouses
common tasks, 1.2.2
key characteristics of, 1.2.1
design
logical, 4.1
physical, 4.1
dimension tables, 3.5
dimensional modeling, 3.2
dimensions, 4.2.8
hierarchies, 4.2.8.1

E

ELT, 2.5
entity, 3.2
ETL, 2.5
Exadata, 5.2

F

fact tables, 3.5, 3.5.1
files
ultralarge, 4.2.2
foreign key
joins
snowflake schemas, 3.4.3

H

hierarchies
how used, 4.2.8.1
overview, 4.2.8.1

I

information access, 7

L

level relationships, 4.2.8.1
purpose, 4.2.8.1.2
levels, 4.2.8, 4.2.8.1.1
logical design, 4.1

M

modeling
logical design, 3
physical design, 3

O

OBI Enterprise Edition, 7.6
ODI, 6
OLAP, 7.4
Oracle Data Integrator, 6

P

physical design, 4.1
structures, 4.2.1

R

R Enterprise, 7.5
root level, 4.2.8.1.1

S

schemas
3NF, 3.3
snowflake, 3.2
star, 3.2
snowflake schemas, 3.4.3
complex queries, 3.4.3
star schemas
advantages, 3.4.1
defining fact tables, 3.5.1.1
dimensional model, 3.4.1
summary tables, 3.5.1

T

Third Normal Form, 3.3

U

ultralarge files, 4.2.2
unique
identifier, 3.2, 4.2