index_R

R

RAID technology, 92

Range partitioning, 77–79

defined, 77

in EASYDW schema, 77–79

illustrated, 78

partition keys, 86–88

See also Partitioning

RANK() function, 110, 112, 124

Ranking functions, 110–15

CUME_DIST(), 113

defined, 109, 110

examples, 118, 119, 120

NTITLE(), 114–15

PERCENT_RANK(), 113

RANK(), 110, 112

WIDTH_BUCKET(), 115

See also SQL functions

RATIO_TO_REPORT function, 119–20

Real application clusters (RAC), 16–17

buffer cache sharing, 134

defined, 134

technology, 133–34

Real-time data warehouses, 17–18

Recommendations, 198–200

graph, 198

implementing, 199–200

materialized views, 202

view/modify, 199

See also Summary Advisor

Recovery

configuration, 363

disaster, 365–68

log, 364

Recovery catalog, 356–57

creating, 357

database placement, 357

database registration with, 359

illustrated, 357

Recovery Manager (RMAN), 329, 344

back contents, 360

backups, 356

Recovery Wizard, 361–63

report files needing backup, 361

running, 358

schema report, 360

Recovery Wizard, 361–63

configuration, 363

location of data files, 363

starting, 362

Refreshing, 137–38

complete, 138

defined, 137

incremental, 138

materialized view, 142–43

options, 275

with Oracle Enterprise Manager, 150–51

warehouses, 378

See also Summary tables

Refresh operation, 149–57

DBMS_MVIEW procedures, 149–51

defined, 149

fast, 152–57

of multiple materialized views, 150

ON COMMIT, 142–43

ON DEMAND, 143, 149

PCT, 155, 157

policy, 149

Relational OLAP (ROLAP)

defined, 427

MOLAP vs., 427–28

See also On-line analytical processing (OLAP)

Relations, 436

RELY clause, 45, 182

Reorganizing, 368–78

index changes, 377–78

partition maintenance, 369–77

reasons for, 368–69

REPORT command, 359, 441

Reporting aggregates, 109, 118–20

MAX, 118

RATIO_TO_REPORT, 119–20

SUM, 118, 119

See also SQL functions

Reports

changing, 325

column widths, 418

conditional, 420–21

with conditions, 328

creating, with Presentation Wizard, 461–66

creating, with Report Wizard, 413–19

customizing, 324

data source, 414

defining, 412

Discoverer Plus, 323

Discoverer Viewer, 409, 410

distributing, to Web, 410–12

dynamic, with graphs, 303

fields, selecting, 417

formats, 423

grouping levels, 416

illustrated, 419

integrated from Discoverer into Oracle 9iAS Portal, 412

layout, 418

matrix, 420

medium, selecting, 413

month-level, 326

output format, 424

run-time format, 423

scheduling, 425

selecting, 424

style, selecting, 414

Summary Advisor, 202–4

total calculations, 417

for Web, 421–25

in workbook, 318

REPORT SCHEMA command, 359

Report Wizard, 413–19

column widths specification, 418

data source selection, 414

grouping levels specification, 416

Query Builder setting, 416

report field selection, 417

reporting medium selection, 413

report style selection, 414

SQL query specification, 415

totals calculation, 417

See also Oracle 9i Reports

Repository, 280

location, 281

tablespace, 281

Repository Assistant, 280

Restoring, 361–64

concerns, 361

with Recovery Wizard, 362–64

type, selecting, 362

Resumable statements, 394–95

status, 395

suspended, 394, 395

REVOKE command, 389

Roles, 56–57

allocating, 390, 391

creating, 390

EASY_USER, 389

Rolling window operations

adding/dropping partitions to perform, 369–70

defined, 369

ROLLUP function, 102, 103–4

defined, 102, 103

groupings determination, 14

output comparison, 104

with supported aggregates, 103

See also SQL functions

Rule-based optimizer, 94–95



Oracle9iR2 Data Warehousing
Oracle9iR2 Data Warehousing
ISBN: 1555582877
EAN: 2147483647
Year: 2005
Pages: 91

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net