Sumários

Recovery System

21 abril 2017, 09:30 Helena Galhardas

  • Failure Classification
  • Storage Structure
  • Recovery, Atomicity and Durability
  • ARIES algorithm: basic concepts.


Recovery System

21 abril 2017, 09:30 Helena Galhardas

  • Failure Classification
  • Storage Structure
  • Recovery, Atomicity and Durability
  • ARIES algorithm: basic concepts.


Database Recovery

21 abril 2017, 08:00 Bruno Emanuel Da Graça Martins

1. Revisions over Exercises from Previous Labs

2. Important Concepts on Database Recovery
2.1. Transaction Logs and Recovery in SQL Server
2.2. WAL and ARIES-like logging and recovery scheme
2.3. SQL Server Restore Recovery Models
2.4. Disaster Recovery in SQL Server
3. Experiments and Exercises on Database Recovery
3.1. Some Examples on Database Backups


Concurrency Control (cont.)

18 abril 2017, 11:00 Helena Galhardas

  • Timestamp-Based Protocols for Concurrency Control
  • Multiversion Schemes
  • Snapshot Isolation


Concurrency Control (cont.)

18 abril 2017, 11:00 Helena Galhardas

  • Timestamp-Based Protocols for Concurrency Control
  • Multiversion Schemes
  • Snapshot Isolation