Fundamentals of Database Management Systems, Second Edition

INDEX

A

abstract data types, 262–263

access-arm mechanism, 203

access methods, 207–218. See also index

file organizations and, 207–218

sequential, 207, 210, 213, 217

access path plan, 70

accessing data, problems in, 12–13

active data dictionaries, 284–286. See also passive dictionaries

attributes, 285–286

definitions, 284

distinctions, 284

entities, 285–286

relationships, 286

uses and users, 286

Advance Auto Parts, 69

aggregated data, 340

aggregation, 248, 255–256

alternate key, 110

Amazon.com, 3–4

Analytical Engine, 7

AND operator, 75–76

anomalies data, 55

anti-virus software, 301

application characteristics, 218, 220

Application Program Interface (API), 373

application servers, 318

arbitration, 288

associative entity, in M-M binary relationship, 27

asymmetric data encryption, 300

attribute, 20, 45, 108

columns, 108

creating uniqueness with, 20, 28

data normalization and, 157–158, 174

data normalization examples, 185–189

domain of values, 112, 142, 144

E-R diagrams, 158–160

inheritance of, 253–254

keys and, 109

physical database design, 97, 199–237

unique, 20

attribute names, 72, 85

ATTRIBUTES table, 283

audio clips, 373

availability, database, 374, 375–376

AVG operator, 81

B

B+−tree index, 211–214

information from, 212–213

Babbage, Charles, 7

backup, 291, 303–307

backup copies and journals, 303

importance, 303

backward recovery, 305–306

balance sheet, 6

Baptist Memorial Health care, 378–379

bartering, 5

base table, 70

basic SELECT format, 70

before and after image log, 303