• Keine Ergebnisse gefunden

Relational Databases 2 Exercise Sheet 11: Recovery

N/A
N/A
Info
Herunterladen
Protected

Academic year: 2021

Aktie "Relational Databases 2 Exercise Sheet 11: Recovery"

Copied!
1
0
0

Wird geladen.... (Jetzt Volltext ansehen)

Jetzt herunterladen ( 1 Seite )

Volltext

(1)

Relational Databases 2 Exercise Sheet 11: Recovery

Exercise 1

a) What is the system log used for? What are the typical kinds of entries?

b) What are checkpoints and why are they important?

c) What are UNDO- and REDO-type log entries?

Exercise 2

a) How are buffers and caches used by recovery algorithms?

b) What is meant by transaction rollback? What is a cascading rollback? Which recovery methods do not need any rollback?

Exercise 3

a) Discuss deferred updates technique. What are the advantages and disadvantages? Why is it called no-undo/redo?

b) Briefly describe shadow paging recovery. Under which circumstances does it not need a log?

c) Describe briefly the 3 phases of ARIES.

d) What does steal/no-steal and force/no-force mean with regard to buffer management for transaction processing?

Referenzen

Jetzt herunterladen ( PDF - 1 Seite - 58.22 KB )

ÄHNLICHE DOKUMENTE

Relational Databases 2 Exercise Sheet 9: Transaction Processing

• A transaction T2 creates a new account (Kto-Nr: 180; Balance: 750) and updates the Sum of the corresponding office in the investment table?. Show a schedule where

Relational Databases 2 Exercise Sheet 10: Transaction Processing 2

Apply and visualize the timestamp ordering algorithm for both schedules.. Can the schedule

Relational Databases 2 Exercise Sheet 11: Security

Considering a large company: Would they prefer role-based access control or discretionary access control.. Please explain

Relational Databases 2 Exercise Sheet 13: Privacy

Provide an example on how perturbation-based techniques can improve statistical database

Relational Databases 2 Exercise Sheet 7: Transaction Processing 2 (until Friday 18.07.2014)

Exercises will be discussed on Friday on week after the respective lecture was given.. The handouts are optional and do not have to be

Relational Databases 2 Exercise Sheet 3: Indexing and Access Paths (until Tuesday 08.05.2011)

You may hand in your solutions on paper before the lecture or into the mailbox at the IFIS floor (Mühlenpfordtstraße 23, 2nd floor).. Please do not

Relational Databases 2 Exercise Sheet 8: Transaction Processing (until Tuesday 23.06.2012)

If the scheduler can choose which operation to execute, it chooses the operation that has been occurred earlier in

Relational Databases 2 Exercise Sheet 9: Transaction Processing 2 (until Tuesday 03.07.2012)

Exercises have to be turned in until Tuesday of each respective week and may be completed in teams of two students each.. You may hand in your solutions on paper before the lecture