Video
1
26
58
60
138
139
140
142
143
173
202
226
227
228
229
262
352
355
359
360
361
362
363
374
508
529
694
711
748
750
964
1018
1039
1101
1163
1336
1539
1556
1645
1848
2332
2446
2666
2712
2742
2743
2906
3026
3063
3117
3197
3235
3238
3283
3286
3470
3483
3614
3694
3812
3842
3856
3858
3916
4116
4206
Lecture Structure
- Überblick (00:00:01)
- LOQ Datensätze (00:00:27)
- o Wird nach einem WRITE geschrieben (nicht erst nach einem OUTPUT) (00:00:27)
- o Transaction Manager muss sicherstellen dass T keinen Effekt auf Disk (00:00:27)
- Puffermanager Strafegie) (00:00:27)
- COMMITT Transaktion T ist beendet und wird nichts mehr ändern (00:00:27)
- Lcgdatei ebenfalls in Blöcke organisiert (00:00:27)
- Regein des Llndo Logging (00:00:58)
- Regeln des Undo Logging (00:02:17)
- Log Manager (00:02:18)
- Transaktionsmanager OUTPUT Befehl Weist Puffermanager an (00:02:18)
- Log Manager Flush og Befehl Weist Puffermanageran alle Log (00:02:18)
- Undc Logging Ursprünge (00:02:19)
- Undo Loggir Beispie (00:02:21)
- P I E ität V0l l T 8l lS (ti0 e (00:02:22)
- Recovery mittels Undo Logging (00:02:51)
- Egal was aktueller Weft ist (00:02:51)
- Schreibe alten Wert v für Element gemäß Update Datensatz (00:02:51)
- Atomizität nicht erfüllt (00:02:51)
- Recovery mittels Unclo Logging Beispiel (00:03:45)
- K0mp i atii0r Syst mfehle während Recovery (00:03:47)
- Wiederholte Anwendung entspricht einfacher Anwendung (00:03:47)
- Recovery Schritte sind idempotent (00:03:47)
- Checkpointing (00:03:48)
- Idee 1 Sowie man ein COMMIT sieht abbrechen (00:03:48)
- Problem Recovery zwingt das gesamte Log zu lesen (00:03:48)
- Komplikatiion Syst mfehler während Recovery (00:03:49)
- Checkpointing (00:05:05)
- Checkpointing Beispiel (00:05:54)
- Nicht blockierencles Checkpointing (00:05:55)
- Nicht blockierencles Checkpointing Recovery (00:05:59)
- Schnell durch geeignete Pointerstrukturin der Log (00:05:59)
- frühesten Transaktionen aus T1 Tk (00:05:59)
- Recovery weiter rückwä ts aber nur bis zum Start der (00:05:59)
- Nicht blockierendes Checkpointing Beispiele (00:06:00)
- Nicht blockierencles Checkpointing Beispiele (00:06:01)
- 5 START CKPT (T1 TZ) (00:06:01)
- Checkpo nt (00:06:01)
- CRASH (00:06:02)
- S START CKPT (T1 T2) (00:06:02)
- Überblick (00:06:03)
- Redo Logging Regeln (00:08:25)
- hreiben (00:08:25)
- 2 COMMIT Log Datensatz auf Disk schreiben (00:08:28)
- Log Datensatz T X v (00:08:28)
- Undo VS REC O Logging (00:08:49)
- Redo Logging Beispiel (00:11:41)
- Redo Loggir Recovery (00:13:57)
- Redo Loggi Recovery Beispiel (00:16:51)
- Redo Logging Recovery Beispiel (00:19:15)
- Redo Loggir Checkpointing (00:19:23)
- Puffermanagerrnuss dirty Puffer kennen (00:19:23)
- Beschränkung auf aktive Transaktionen genügt nicht (00:19:23)
- 1 die Im Puffer verändert (00:22:16)
- 1 Schreibe START CKPT (T1 Tk) in Lc g (00:22:16)
- Redo Loggir Checkpointing Beispiel (00:25:39)
- 12 COMMITT3 (00:27:24)
- 11 COMMITT2 (00:27:24)
- 1O END CKPT (00:27:24)
- 6 STARTCKPT (T2) (00:27:24)
- 4 COMMITT1 (00:27:24)
- Redo Loggir Checkpointing Recovery (00:27:25)
- Rückwärtsverlinkung im Log hilft (00:27:25)
- Log ein START oder ein END ist (00:27:25)
- Rückwärtssuche zum nächsten END CKPT und dann weiter rückwärts (00:32:29)
- s ART CKPT (T1 i) (00:32:29)
- Es genügt Betrachtung ab dem frühesten START Ti (00:32:29)
- Alle Transaktionen die vor dem zugehörigen START CKPT (T1 (00:32:29)
- Redo Logging Checkpointing Recovery Beispiel (00:38:52)
- Redo Loggir Checkpointing Recovery Beispiel (00:40:46)
- Überblick (00:45:12)
- BGSÜ of both WOl C S (00:45:43)
- Uncio Redo Regel (00:48:26)
- Reminder U1 Falls Transaktion T Element verändert muss T (00:48:26)
- D esg Bed ngung W rd von Undo und Redo gemäß vor ger Regeln (00:48:26)
- Undo Reclo Regel (00:50:29)
- Undo Redo Beispiel (00:51:47)
- Undo Reclo Recovery (00:51:57)
- Undo Redo Recovery Beispiel (00:53:17)
- MemA MemB DiskA DiskB Log (00:53:17)
- OUTP 16 16 (00:53:55)
- READ(B r) (00:53:55)
- Akti m 5 (00:53:55)
- Recbvery sze b de x s her dbfnöt g cÄd 5Üf ET (00:54:43)
- Undo Redo Recovery Checkpointing (00:54:46)
- Abort und Dirty Data (00:58:02)
- Also solche d e ertes Element enthalten (00:58:02)
- Ti sind alle aktiven Transaktionen (00:58:02)
- Dirty Data trotz Serialisierbarkeit (00:58:03)
- Problem Abort und Dirty Data (00:58:03)
- 1 Schreibe START CKPT (T1 (00:58:03)
- Undo Redo Recovery Checkpointing Beispiel (01:00:14)
- 12 COMMITT3 (01:00:14)
- 11 COMMITT2 (01:00:14)
- 10 END CKPT (01:00:14)
- Z B auch T1 A 4 5 falls (01:00:14)
- Wie alle dirty Blocks (01:00:14)
- Wird aber sowieso auf Disk (01:00:14)
- 4 COMMITT1 (01:00:14)
- 3 STARTT2 (01:00:14)
- T2 B 9 10 eventuell schon (01:00:14)
- Undo Reclo Recovery Checkpointing Beispiel (01:01:34)
- Undo Redo Recovery Checkpointing Beispiel (01:04:02)
- Zusammenfassung Recovery (01:04:16)
- Undo Reclo Recovery Checkpointing Beispiel (01:04:18)
- Zusammenfassung Recovery (01:05:16)
- W rte auf Disk wandern (01:05:16)
- Logging (01:05:16)
- Rede Loggmg (01:05:16)
- Log Datensatze d es (01:08:36)
- (inkrementel an) durnp (01:08:36)
- Erspart Betrachtung des (01:08:36)
- Nur Änderungen werden kopiert (01:08:36)
- Checkpointing (01:08:36)
- 1 Äeginn mit full du p (01:10:06)
- Backup w hy nd Datenbank (01:10:06)
- N c t blockierendes Checkpointing (01:10:06)
- Alte Log Teile können gelöscht (01:10:06)
Links added to this content
No links have been added to this content so far.
Tags added to this content
No tags have been added to this content so far.
Tags added to the series of this content:algorithmen (1); backup (1); Datenbanken (1); dbms (1); festplatte (1); performance (1); Persistenz (1); recovery (1); Speicherhierarchie (1); ssd (1); test (1); vorlesung (1);
Create Note
Dear user,
with the manuscript function you'll be able to create your own digital lecture manuscript.
However, in order to link all your notes with your user profile it is required that you
login to the tele-TASK portal to use this functionality.
If you don't have an account yet, you may register for a tele-TASK account here.
with the manuscript function you'll be able to create your own digital lecture manuscript.
However, in order to link all your notes with your user profile it is required that you
login to the tele-TASK portal to use this functionality.
If you don't have an account yet, you may register for a tele-TASK account here.
Place a Marker
Dear user,
with the marker function you'll be able to create your own digital time markers.
However, in order to link all your markers with your user profile it is required that you
login to the tele-TASK portal to use this functionality.
If you don't have an account yet, you may register for a tele-TASK account here.
with the marker function you'll be able to create your own digital time markers.
However, in order to link all your markers with your user profile it is required that you
login to the tele-TASK portal to use this functionality.
If you don't have an account yet, you may register for a tele-TASK account here.
Please enable javascript to use this function.
Keyword
Please enable javascript to use this function.
Zu meinen Videolisten hinzufügen
Dear user,
with the playlist function you'll be able to create your own lecture video playlists.
However, in order to link all your playlists with your user profile it is required that you
login to the tele-TASK portal to use this functionality.
If you don't have an account yet, you may register for a tele-TASK account here.
with the playlist function you'll be able to create your own lecture video playlists.
However, in order to link all your playlists with your user profile it is required that you
login to the tele-TASK portal to use this functionality.
If you don't have an account yet, you may register for a tele-TASK account here.
Playlists
This content is not used in any playlist.