Index

A B C D E F G H I L M N O P Q R S T V W

A

adding

mapping operators, 5.4

analytic capabilities, 9.1

analytic SQL, 9.1

ARCHIVELOG mode

as a best practice, 13.2.1

ASM, 2.2.1.4

attribute properties, setting, 5.8

attributes

connecting, 5.6.1

level attributes, 4.4.1.2

setting properties, 5.8

auto binding rules, 4.4.2.2

Automatic Storage Management (ASM), 2.2.1.4

B

backup, 13.1

backup and recovery, 13.1

best practices, 13.2

best practices

ARCHIVELOG mode, 13.2.1

backup and recovery, 13.2

NOLOGGING, 13.2.4

read-only tablespaces, 13.2.3

RMAN, 13.2.2

tablespace differences, 13.2.5

binding

auto binding, rules, 4.4.2.2

C

calculating moving averages, 9.1.8

calculating relative contributions, 9.1.6

common tasks

in data warehouses, 1.2.2

connecting

attributes, 5.6.1

groups, 5.6.2

operators, 5.6

CPUs, 2.2.1.1

Create External Table Wizard, 4.3.1

creating

mappings, 5

CUBE function, 9.1.2

cubes, 4.5

dimensionality, 4.5.1.2

example, 4.5.1.3

measures, 4.5.1.1

relational implementation, 4.5.2.1

D

data compression, 11.3.1

data warehouses

common tasks, 1.2.2

key characteristics of, 1.2.1

setting up, 2.2, 2.3

tools, 1.4

data warehousing security, 14

dd utility, 2.2.2

defining

mappings, 5

schedules, 7.3

degree of parallelism (DOP), 12.3.1.2

densification, 9.2

diagrams

impact analysis, 8.3, 8.5.2

lineage, 8.3, 8.5.2

dimensions

dimension roles, 4.4.1.4

example, 4.4.1.6

hierarchies, 4.4.1.3

implementing, 4.4.2

level attributes, 4.4.1.2

level relationships, 4.4.1.5

star schema implementation, 4.4.2.1

disks

needed, 2.2.1.3

E

ETL

improving runtime performance, 6

explain plan

analyzing, 12.1.2

explain plans, 12.1.2

external tables

creating a new definition, 4.3.1

defined, 4.3

wizard for creating, 4.3.1

F

fine-grained auditing

in data warehouses, 14.5

flat files

G

group properties, 5.8

GROUPING function, 9.1.3

GROUPING SETS function, 9.1.4

groups

connecting, 5.6.2

in LIA diagrams, 8.5.1

setting properties, 5.8

H

hardware configuration, 2.2.1

verifying, 2.2.2

hierarchies

about, 4.4.1.3

hints, 12.1.3

I

impact analysis diagrams, 8.3, 8.5.2

implementing

relational cubes, 4.5.2.1

star schema, 4.4.2.1

improving runtime performance, 6

indexes, 12.2.3

optimizing, 11.2

optimizing with SQL Access Advisor, 11.2

initialization parameters

setting, 2.3.3

interrow calcuations

performing, 9.1.7

I/O, 2.2.1.4, 11.1.1.2

monitoring, 11.1.1.2

L

lineage diagrams, 8.3, 8.5.2

M

mapping operators

about, 5.1

adding, 5.4

connecting, 5.6

editing, 5.5

synchronizing with Repository objects, 5.9

types of, 5.3.1

mapping operators, setting, 5.8

mappings

about, 5.1

creating, 5

defining, 5

for Partition Exchange Loading, 6.1.2

setting properties, 5.7

materialized views, 12.2.2

memory, 2.2.1.2

memory management

parameters, 2.3.1

memory needed, 2.2.1.2

metadata

dependencies, 8

metadata dependencies, diagrams of, 8.1

Metadata Dependency Manager, 8.1

N

NOLOGGING

as a best practice, 13.2.4

O

offloading data

with rolling windows, 10.2

operator attributes, 5.6.1

operator properties

setting, 5.8

operators

connecting, 5.6

editing, 5.5

synchronizing with Repository objects, 5.9

operators, mapping, 5.1

adding, 5.4

connecting, 5.6

editing, 5.5

types of, 5.3.1

optimizer statistics, 12.1.1

Oracle Label Security, 14.4

in data warehouses, 14.3

Orion utility, 2.2.2.2

P

parallel execution, 12.3.1

how it works, 12.3.1.1

parallel query, 11.1.1.1, 12.3.1

monitoring, 11.1.1.1

parameters

initialization, 2.3.3

memory management, 2.3.1

Partition Exchange Loading (PEL), 6.1

about, 6.1.1

configuring targets for, 6.1.5

mappings for, 6.1.2

performance considerations, 6.1.4

restrictions on, 6.1.5, 6.1.6

partition outer join, 9.2

partition pruning, 12.2.1.1

partitioning, 12.2.1

partitionwise joins, 12.2.1.2

performance

using hints, 12.1.3

using query rewrite, 12.2.2

using SQL Access Advisor, 12.1.4

using SQL Tuning Advisor, 12.1.4

privileges

in data warehouse security, 14.2

properties

mapping, 5.7

setting, 5.8

Q

query rewrite, 2.3.3, 2.3.3, 4.4, 10.1.1, 12.2.2

R

RANK function, 9.1.5

read-only tablespaces

as a best practice, 13.2.3

refresh, 10.1

refreshing

data warehouse, 10.1

resource consumption, 12.2

minimizing, 12.2

Resource Manager, 11.1.2

rewrite

query, 2.3.3, 2.3.3

RMAN

as a best practice, 13.2.2

roles

dimension roles, 4.4.1.4

in data warehouse security, 14.2

rolling windows, 10.2

ROLLUP function, 9.1.1

runtime performance, improving, 6

S

schedules

creating, 7.3

defining, 7.3

using, 7.3

scheduling

about, 7.2

security

data warehouse, 14

setting

mapping properties, 5.7

sparsity, 9.2

SQL Access Advisor, 12.1.4

evaluating partitioning, 12.2.1.3

optimizing indexes, 11.2

SQL Tuning Advisor, 12.1.4

statistics

optimizer, 12.1.1

storage

optimizing, 11.3

storage management

manual, 2.2.1.4

synchronizing

operators and Repository objects, 5.9

T

tables

V

virtual private database

in data warehouses, 14.3

VPD

how it works, 14.3.1

W

wait events, 12.3.2

WITH clause, 9.3

wizards

Create External Table Wizard, 4.3.1