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