index_O

O

Object Management Group (OMG), 15

Object privileges, 56

O-Cluster algorithm, 483

OLAP API, 428, 434, 449-50

defined, 434, 449

multidimensional model, 449

OLAP catalog, 434, 450-57

defined, 450

requirements, 450

OLAP DML, 433, 438-46

for aggregation, 442-43

commands, issuing, 440

custom menu creation, 445-46

defined, 438

executing, 439

for forecasting, 443-45

formulae definition, 445

power of, 442

reporting data with, 441-42

SQL and, 439

OLAP metadata, 450-57

creating, in Oracle Enterprise Manager, 451-57

cube, 450, 453-56

definition methods, 450

dimensions, 450, 452, 454

entities, 450

measure folders, 450

measures, 450, 455

OLAP Summary Advisor, 456

OLAP_TABLE function, 448-49

On-line analytical processing (OLAP), 4

calculation engine, 433

defined, 427

multidimensional (MOLAP), 427-28

queries, 13, 427

relational (ROLAP), 427-28

tools, 14

See also Oracle 9i OLAP

On-line transaction processing (OLTP), 2

E-R techniques, 5

optimal performance, 5

in Oracle applications, 18

process automation, 3

ON PREBUILT TABLE clause, 144

Operating System Backup Utility, 344

Operational data store (ODS), 9-10

Operational system keys, 223

Optimizations, 67

cost-based, 94, 95

join, 97-101

query, 94-101

rule-based, 94-95

Optimizer statistics

automated gathering, 380

collected with DBMS_STATS package, 379

gathering, 378-81

for materialized views, 276-77

for tables, 273

Oracle 9i, 11-14

database, 432-33

defined, 11

indexes, 28

parallel DML, 131

Partition Change Tracking (PCT), 155-57

preconfigured databases, 31

products, 11

RAC technology, 133-34

Release 2, 428

Summary Advisor, 196-206

Summary Management, 55, 135-207

Oracle 9i Application Server, 402-12

defined, 402

development, 402

HTTP Server, 402

Oracle Clickstream, 407-8

Personalization, 14, 407

products, 403

Oracle 9iAS Portal, 405-7

benefits, 405-6

customized pages, 406

defined, 405

integrating reports into, 412

Oracle 9i Reports integration, 406-7

Oracle 9i Backup and Recovery Manual, 347

Oracle 9i Database, 12-14

data mining functionality, 13-14

express server technology convergence, 13

features, 12

Oracle 9i OLAP, 428-29

analytical workspaces, 433, 434-38

architecture, 431-34

BI Beans, 434, 460-73

components, 431

OLAP API, 434, 449-50

OLAP calculation engine, 433

OLAP catalog, 434, 450-57

OLAP DML, 433, 438-46

Oracle 9i database, 432-33

Release 2, 432

table functions, 433-34

Oracle 9i Option, 428-29

defined, 428

Discoverer and, 429

Oracle 9i Reports, 412-25

components, 413

conditional report, 421

defined, 412

examples, 419-20

matrix report, 420

Oracle 9iAS Portal integration, 406-7

Queue Manager, 423

Report Wizard, 413-19

in Web format, 423

Oracle 9i Reports Server, 423-25

job queue, 425

output format specification, 424-25

report schedule, 425

report selection, 424

Oracle Clickstream, 407

defined, 408

information, 408

Oracle Database Configuration Assistant, 30-36

database features, 34

database storage, 35

defined, 30

file location variables, 33

initialization parameters, 32

Oracle Data Guard, 366-67

configuration, 366, 367

defined, 366

Oracle data mining, 13-14, 473-93

algorithms, 481-83

analysis steps, 485-87

APIs, 487-93

association rules, 475-76

classification, 478-81

clustering, 477-78

data preparation in, 483-84

defined, 474

installation/configuration, 484-85

lift analysis, 480-81

predicator variance, 484

problem categories, 474-75

summary, 493

table formats, 485, 486

tasks, 485-87

techniques, 474-81

using, 484-87

See also Data mining

Oracle Data Mining Suite, 474

Oracle Discoverer, 300-328

Administrator, 300

business area, 307-9

defined, 300

Desktop, 300

dynamic reports, 303

elements, 300

environment setup, 305-18

EUL, 305-6

folders, 310

hierarchies, 312-13

item classes, 313-14

item details, changing, 310-11

items, 310

items, creating, 311-12

Oracle 9i OLAP Option and, 429

Oracle Portal integration, 301

Plus, 300

report types, 301-5

security issues, 317-18

summaries, 314-16

use of, 301

Viewer, 300, 301-3

visible column restriction, 309-10

Oracle Enterprise Manager

administrator account, 333

check constraints, 48

constraints, 45

create a user, 37

creating databases with, 34-36

Cube Wizard, 453-56

dimensions, 40

dimensions for OLAP in, 452

EXPLAIN_MVIEW in, 161

foreign key, 47

index creation in, 73

indexes, 52

Job Scheduler, 338-43

Load Wizard, 227-35

in looking for stale materialized views, 274

managing with, 329-44

materialized view creation in, 141

null constraint, 46

object security, 57

OLAP metadata creation, 451-57

OLAP worksheet in, 439

schemas, 38

for summary refreshment, 150, 151

tablespaces, 39

Table Wizard, 42-43

three-tier architecture, 330

viewing constraints, 50

viewing table partitions, 270

Oracle Enterprise Manager Console, 330-33

elements, 331

illustrated, 331

launching, 330

launching applications, 343-44

Navigator tree, 332

Navigator window, 332-33

scheduling jobs, 338-43

starting, for first time, 331

Oracle Expert, 383

Oracle managed files (OMF), 393

Oracle Warehouse Builder (OWB), 8, 279-300

benefits, 280

bitmap index recommendations, 299

Client, 281-82, 283

code generation, 298

data generators, 295

data source definition, 284

data sources, 283

defined, 279

design generation/configuration, 297-300

design validation, 295-96

dimension creation, 287-88

Dimension Wizard, 287

fact table creation, 288-89

filtering data, 294

functions, 280

key lookup, 293-94

manual table definition, 286

Mapping Editor, 290-92

metadata, 280

module creation, 282-84

New Module Wizard, 282-83

physical design configuration, 299

repository, 280, 281

Repository Assistant, 280

setup, 280-81

setup steps, 281

source to target mapping definition, 290-95

table definition, 285-87

table import, 285

time dimension creation, 288

transformations, 289-90

validation progress, 296

Warehouse Fact Table Editor, 288-89

ORDER BY clause, 110-11, 124

Outlines, 384-89

creating, 384-85

defined, 384

editing, 386-89

management, 385

original, 386

revised, 388

using, 386

See also Plan stability



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