CS245DatabaseSystemPrinciples-NCState.pptVIP

Chapter 17 Notes 08 Chapter 17:Coping with System Failures Integrity or correctness of data Would like data to be “accurate” or “correct” at all times EMP Integrity or consistency constraints Predicates data must satisfy Examples: - x is key of relation R - x ? y holds in R - Domain(x) = {Red, Blue, Green} - a is valid index for attribute x of R - no employee should make more than twice the average salary Definition: Consistent state: satisfies all constraints Consistent DB: DB in consistent state Observation: DB cannot be consistent always! Example: a1 + a2 +…. an = TOT (cons