Oracle9iR2 Data Warehousing

M

Management, 329–98

design for, 26–28

events and, 336–38

groups and, 334–35

issues, 395–98

job scheduling and, 338–43

launching applications and, 343–44

methods, 329

with OEM, 329–44

outline, 385

parallel, tasks, 381–82

partitions facilitate, 376–77

security, 389–92

space-use monitoring, 392–95

summary, 135–207, 398

tasks, 26

tasks, evaluating/practice, 397

Mapping Editor, 290–92

illustrated, 291

with joins, 292

opening, 290–91

Mappings

defining, 290–95

source to target, 290–91

See also Oracle Warehouse Builder

Market-basket analysis, 475

Massively parallel processor (MPP) systems, 133

Materialized views

contents specification, 143–44

creating, 139–48

creating, with PREBUILT clause, 145

creating in Oracle Enterprise Manager, 141

for data replication, 139

defined, 138, 139

definition parts, 140

enabling, for query write, 143

fast refresh and, 152

indexing, 147

monitoring use, 205–6

multiple, query rewrite with, 191–93

ON COMMIT refresh, 142–43

ON DEMAND refresh, 143, 149

optimizer statistics, 276–77

partitioning, 146–47

physical storage, 141

population with data, 141–42

recommending, 202

refreshing, 274–76

refreshment method, 142

security of, 147–48

size, estimating, 206

stale, looking for, 274

Matrix report, 420

MAX function, 118

Measure folders, 450

Measures

choosing (Presentation Wizard), 462

defined, 434, 450

specifying, 455

See also OLAP metadata

MERGE statement, 254, 255, 298

Merging partitions, 371–73

illustrated, 372

index partitions and, 372

See also Partitions

Metadata

defined, 15

exporting, 258–59

importing, 259–60

OLAP, 450–555

OWB, 280

role of, 15

specifying, 249

Modeling, 430

dimensional, 21–22

E-R, 20–21

Models

applying, 490–93

building, 487–90

OLAP API multidimensional, 449

Modules

creating, 282–84

defined, 281

Moving data, 268–73

with exchange partition, 270–71

between tables with direct path insert, 272

Moving partitions, 376

Moving window aggregate functions, 109, 115–18

Multicolumn partition keys, 86–88

Multidimensional (MOLAP)

defined, 427

products, 428

ROLAP vs., 427–28

See also On-line analytical processing (OLAP)

Multitable insert, 266