Oracle9iR2 Data Warehousing

E

Easy Shopping Inc., 25-26, 36

constraint creation, 61-65

data files, 60-61

index creation, 61-65

schema, 59-67

security definition, 65-66

table creation, 61-65

tablespaces, 39, 60-61

E-business intelligence, 426

ENABLE/DISABLE clause, 44, 45

ENABLE QUERY REWRITE clause, 170

ENABLE QUERY WRITE clause, 143, 144

End-user layer (EUL), 305-6

Entity-relationship modeling, 20-21

Environment setup (Oracle Discoverer), 305-18

business area, 307-9

end-user layer, 305-6

folders, 310

hierarchies, 312-13

item classes, 313-14

item details, changing, 310

items, creating, 311-12

security, 317-18

summaries, 314-16

visible column restriction, 309-10

ETL process, 6

development difficulty, 210

extraction, 211-20

illustrated, 210

load, 225-59

tools, 277

transformation, 220-25

See also Loading data

Events, 336-38

advising users of, 338

creating, 336

naming, 336

notification schedule for, 338

selecting, 337

using, 336-38

See also Management

Exchange partitions, 370

Executive information systems (EIS), 12

EXPLAIN_MVIEW utility, 157-61

defined, 157-58

on existing materialized view, 161

functions, 158

invoking, 158

in Oracle Enterprise Manager, 161

output, 158-59

query rewrite and, 160

EXPLAIN PLAN, 95-96, 191, 192, 253

EXPLAIN_REWRITE utility, 193-96

defined, 193

results, 194

using, 194

EXTEND_WINDOW procedure, 218

External tables, 247-55

access parameters specification, 250-51

creating, 249-51

data access, 251-52

data file/log files location, 248-49

defined, 247

illustrated, 249

loading data from, 252

loading data in parallel with, 252-53

metadata specification, 249

read access, 248

See also Tables

Extracting data, 211-20

change data identification, 212-13

defined, 211

Oracle change data capture, 213-20

See also ETL process

Extraction/transformation/load. See ETL process