Data Quality: The Accuracy Dimension (The Morgan Kaufmann Series in Data Management Systems)

P

partitioned tables, 207

patterns, 164

periodic checkers, 253

PL/1 INCLUDE file, 125, 144

poor-quality data

cost, 255-256

new business models and, 256

problem, 255

See also inaccurate data

poor-quality data impact, 12-14

areas, 12-13

data delivery delays, 13

lost customers, 14

lost production, 14

new system implementation costs, 13

transaction rework costs, 13

See also data quality problem; inaccurate data

post-change monitoring, 99-101

precision property, 159-160

primary keys, 176-179

defined, 176

example, 178-179, 266

functional dependency, 176, 199

as key to the table, 179

NULL, 208

violations, 208

See also keys

primary/foreign key synonyms, 185-186

analyzing, 205-206

example, 267-268

testing for, 204

primary/secondary table relationship, 207

process rules

data rules vs., 219-220, 238

defined, 219

use of, 219

projects

case for providing services to, 113-115

justification, 113

services, 75-77, 114

property lists, 148-149

defined, 148

domain definition, 155

illustrated, 149

as output, 155

See also column properties

Категории