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.1
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
See also flat files

F

fine-grained auditing
in data warehouses, 14.5
flat files
See also external tables

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

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
See also external tables
tools
for data warehouses, 1.4
transparent data encryption
in data warehouses, 14.6

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