日志类型与恢复.pptxVIP

主要内容数据库的一致性事务的状态及原语操作数据库系统故障分析Undo日志Redo日志Undo/Redo日志Checkpoint一、数据库的一致性Integrity or consistency constraintsPredicates data must satisfyExamples:- x is key of relation R- x ? y holds in R- Domain(x) = {Red, Blue, Green}一、数据库的一致性Consistent state: satisfies all integrity constraintsConsistent DB: DB in consistent state.....2......100010001100TOTState 3: consistentState 2: “inconsistent”State 1: consistent一、数据库的一致性DB will not always satisfy constraints Example: a1 + a2 +…. an = TOT (constraint)Transaction: Deposit $100 in a2: a2 ? a2 + 100 TOT ? TOT + 100Consistent DBConsistent DB’T