index_D

D

Data

access, external tables, 251–52

aggregating, 442–43

change, 212–20

cleansing, 221–22, 261–62

compression, 92–94

deriving, 222, 261–62

drilling on, 304, 325

extracting, 211–20

filtered, 174–76, 294

generators, 295

integrating, 221

loading, 209–78

moving, 258, 268–73

multidimensional, SQL access to, 448–49

operational, 7

partitioning, 53–54, 76–91

publishing, 277

purchasing, 8

structure specification, 488

transforming, 7, 220–25

unstructured, 16

validating, 262

volume, increasing, 16

Database Configuration Assistant (DBCA), 484

Databases

backing up, 277

creating, with Oracle Enterprise Manager, 34–36

features, 34

file location, 33

naming, 31

Oracle 9i, 432–33

preconfigured, 31

restoring, 361–64

selecting, 349

single vs. many decision, 29–30

standby, 366

storage, 35

virtual private, 390–92

Data-driven formatting, 466–68

illustrated, 467

rules specification, 467

Data files

adding, 38–41

Easy Shopping Inc., 60–61

location, 38

location specification, 248–49

Data file (SQL*Loader), 230

Data marts, 8–11

data warehouse vs., 25

dependent, 10, 11

independent, 9

Data mining, 493

algorithms, 474

defined, 13, 473

Oracle, 13–14, 473–92

statistical and machine learning techniques, 473

table formats, 485, 486

uses, 474

Data warehouse design, 19–66

aggregation decision, 20

constraints, 43–51

database number decision, 29–30

data files and tablespaces, 38–41

dimensional modeling, 21–22

dimension table, 23

dimension table creation, 41–43

Easy Shopping example, 25–26

entity-relationship modeling and, 20–21

fact table, 22

fact table creation, 41–43

fundamental flaw, 368

generating/configuring, 297–300

implementing, 29–58, 297

inclusion decision, 20

indexes, 51–52

introduction, 19–20

for management, 26–28

materialized views, 55

naming conventions, 30

normalization, 24–25

Oracle Database Configuration Assistant and, 30–36

partitioning, 53–54

for performance, 28–29

schemas, 36–38

security, 56–57

testing, 59

validating, 295–96

warehouse keys, 23–24

Data warehouses

application types, 17

automatic memory management, 101–2

availability, 16–17

challenges, 14–16

database design and, 4–5

data marts vs., 25

data volume, 16

defined, 1

e-business intelligence and, 426

enterprise, 11

evolution as separate systems, 5–8

features, 67–133

for finding information, 4

future, 17–18

historical perspective, 2–11

incrementally building, 10

indexing, 68–76

loading data into, 209–78

managing, 14–15, 329–98

multiple subjects, 8

need for, 1–2

normalizing, 24–25

from operational systems, 6–8

optimizations, 67

Oracle software for, 401–2

partitioning, 76–91

real-time, 17–18

refreshing, 378

reorganizing, 368–78

rise of, 3–5

schemas, 26

tuning, 382–89

users/performance, 17

Web and, 399–425

See also Warehousing tools

DBMS_AW package, 447–48

DBMS_MVIEW refresh procedures, 149–51

DBMS_OLAP package, 200–206

DBMS_STATS, 66, 154

statistics collection with, 379

use of, 154

Decision-support applications, 67

Decision support systems (DSS), 4

DENSE_RANK() function, 110

Deriving data, 222, 261–62

Dimensional modeling, 21–22

defined, 21

illustrates, 22

Dimensions, 139, 162–69, 435–36

ATTRIBUTE clause in, 179–80

choosing, 453

choosing (Presentation Wizard), 462

creating, 162–63

creating (OWB), 287–88

defining, 441

defining, with attributes, 165–66

defining, with multiple hierarchies, 164–65

defining, with normalized tables, 166–67

geography, 162–63

joining with fact tables, 454

level-based, 435–36

loading, 253–55

member selection, 463

normalized, 166

OLAP metadata, 450

relationship definitions, 162

relationships declared by, 178

rewrite with, 177–80

time, 164, 178

time, creating (OWB), 288

validating, 167–69

validating data with, 262

value, 435

variables and, 440–41

verifying, 273

See also Summary Management

Dimension tables

creating, 41–43

defined, 23

Easy Shopping Inc., 61–65

fact table vs., 23

loading, 225–26

Dimension Wizard, 287

Directed learning, 475

Direct path insert

defined, 272

moving data between tables with, 272

Direct path load

defined, 230

parallel, 241–43

of single partition, 237–41

using, 235–36

See also SQL*Loader

DISABLE QUERY WRITE clause, 143

Disaster recovery, 365–68

defined, 365

Enterprise, 367–68

Oracle Data Guard, 366–67

plan, 366

See also Recovery

Discoverer Administrator

automatic joins, 308

business area access, 317

business area illustration, 318

business area naming, 309

business area setup, 309

calculated item creation, 312

changing item details, 311

defined, 300

first-time start, 305

hierarchy definition, 313

item class, 314

join definition, 311

schema selection, 307

summary creation, 315

summary refreshment, 316

Summary Wizard, 315, 316

tables/views selection, 308

task list, 306

See also Oracle Discoverer

Discoverer Desktop, 300

Discoverer Plus, 318–28

data display selection, 320

defined, 300

defining totals, 323

drilling up/down, 325

Export Wizard, 411

format headings, 322

graph of monthly sales, 327

Graph Wizard, 326

launching, 318–19

list of databases for connection, 319

month-level report, 326

report customization, 324

report illustration, 323

report using conditions, 328

sorting data, 322

specific data selection, 328

SQL Inspector, 324–25

table layout, 321

using, 409–10

with workbook, 320

See also Oracle Discoverer

Discoverer Viewer

advantages, 301

category sales, 302

defined, 300

presentation options (screen 1), 303

presentation options (screen 2), 304

presentation options (screen 3), 305

query execution, 302

querying with, 301–3

report criteria specification, 410

report from browser, 409

starting, 301

using, 409–10

See also Oracle Discoverer

Dynamic sampling, 381