Physical Database Design

411

Index

All-beneficial sites method, 362–66

allocation decision, 365–66

defined, 362

example, 362–65

illustrated, 366

Amdahl’s Law, 269–71

background, 270–71

defined, 269

ANDing

block ID, 150

block ID and RID, 150

index, 134, 136

Application-controlled multicast, 290–

91

Artificial intelligence (AI), 226

ATM, 115, 116

Automated memory tuning, 298–301

DB2, 300–301

obstacles addressed by, 298

Oracle, 300–301

Automated physical database design,

223–62

data sampling, 240–42

experimental results, 248–53

exploration between test/produc-

tion systems, 247–48

features, 229–40

index selection, 254

judgment and testing, 261

materialized view selection, 254–

56

MDC experimental results, 252

multidimensional clustering selec-

tion, 256–58

range partitioning, 260

“relaxation” notation, 254 ...