Sumários

Recovery Management (cont.)

23 abril 2021, 09:30 Helena Galhardas

  • Recovery, Atomicity and Durability 
  • Recovery based on Log 
  • Aries algorithm: detailed description of the three phases of the algorithm - analysis, redo and undo.


Recovery Management (cont.)

23 abril 2021, 09:30 Helena Galhardas

  • Recovery, Atomicity and Durability 
  • Recovery based on Log 
  • Aries algorithm: detailed description of the three phases of the algorithm - analysis, redo and undo.


Lab 5: Transactions and Concurrency Control (aula online)

23 abril 2021, 08:00 Carlota de Oliveira Lopes Dias

Lab Guide 5:

  • Exercise 2.1 (SQL Server): Benchmarking to test transaction isolation levels 
  • Exercise 2.2.1 (pencil & paper): Serializability, precedence graphs, 2PL protocol.
  • Exercise 2.2.2 (pencil & paper): 2PL protocol and deadlocks.


Lab 5: Transactions and Concurrency Control (online class)

20 abril 2021, 12:30 João Tiago Aparício

Lab Guide 5:

  • Exercise 2.1 (SQL Server): Benchmarking to test transaction isolation levels 
  • Exercise 2.2.1 (pencil & paper): Serializability, precedence graphs, 2PL protocol.
  • Exercise 2.2.2 (pencil & paper): 2PL protocol and deadlocks.


Concurrency Control (cont.) and Recovery Management

20 abril 2021, 11:00 Helena Galhardas

Concurrency control:

  • Multiversion schemes: Multiversion timestamp ordering
  • Snapshot isolation:
    • First-committer-wins rule
    • First-updater-wins rule
    • Skew write.
Recovery management:
  • Failure Classification 
  • Storage Structure 
  • Recovery, Atomicity and Durability 
  • Recovery based on Log: brief introduction.