Datenbanksysteme II (WS 2021/22)

Prof. Dr. Felix Naumann


Datenbanken bilden die Basis fast aller großen Anwendungen. In dieser Vorlesung lernen wir Datenbanksysteme vornehmlich aus Administrator- und Entwicklersicht kennen. Die Vorlesung schließt mit einem Vorlesungsblock zum Thema Web-scale Data Management ab. Die Vorlesung wird von einer Übung begleitet.

Einführung

Physische Speicherstrukturen

Einführung & Physische Speicherstrukturen

Date: October 27, 2021
Language: German
Duration: 01:25:14

Physische Speicherstrukturen: Effiziente Diskoperationen & Zugriffbeschleunigung

Date: November 1, 2021
Language: German
Duration: 01:26:25

Physische Speicherstrukturen: Zugriffbeschleunigung, Diskausfälle & RAID 0 - 6

Date: November 3, 2021
Language: German
Duration: 01:11:25

Physische Speicherstrukturen & Physische Repräsentation von Daten

Date: November 8, 2021
Language: German
Duration: 01:16:13

Physische Repräsentation von Daten & Indexstrukturen

Date: November 10, 2021
Language: German
Duration: 01:22:41

Indexstrukturen

Date: November 15, 2021
Language: German
Duration: 01:23:36

Indexstrukturen: B-Bäume

Date: November 17, 2021
Language: German
Duration: 01:24:22

Indexstrukturen: B-Bäume & Hash-Tabellen

Date: November 22, 2021
Language: German
Duration: 01:25:33

Indexstrukturen: Hash-Tabellen & Multidimensionale Indizes

Date: November 29, 2021
Language: German
Duration: 01:24:12

Multidimensionale Indizes

Date: December 1, 2021
Language: German
Duration: 01:17:49

Multidimensionale Indizes & Anfrageausführung

Date: December 6, 2021
Language: German
Duration: 01:30:51

Anfrageausführung

Date: December 8, 2021
Language: German
Duration: 01:19:52

Anfrageausführung: One-Pass Algorithmen, Nested Loop Join & Sort-basierte Two-Pass Algorithmen

Date: December 13, 2021
Language: German
Duration: 01:22:45

Anfrageausführung: Hash-basierte Two-Pass Algorithmen

Date: December 15, 2021
Language: German
Duration: 01:21:28

Anfrageausführung & Optimierung

Date: January 3, 2022
Language: German
Duration: 01:23:55

Optimierung: Kostenmodell

Date: January 5, 2022
Language: German
Duration: 01:13:25

Optimierung: Kostenmodell & Histogramme

Date: January 10, 2022
Language: German
Duration: 01:26:27

Optimierung: Joinreihenfolge

Date: January 12, 2022
Language: German
Duration: 01:23:55

Optimierung & Recovery

Date: January 17, 2022
Language: German
Duration: 01:25:21

Recovery: Fehlerarten & Undo Logging

Date: January 19, 2022
Language: German
Duration: 01:26:20

Recovery: Undo-Logging & Redo-Logging

Date: January 24, 2022
Language: German
Duration: 01:19:00

Recovery & Web-scale Data Management: Analytics

Date: January 26, 2022
Language: German
Duration: 01:26:48

Web-scale Data Management: Analytics

Date: January 31, 2022
Language: German
Duration: 01:24:36

Web-scale Data Management: Analytics (2)

Date: February 2, 2022
Language: German
Duration: 01:17:58

Web-scale Data Management: Transaction Management

Date: February 7, 2022
Language: German
Duration: 01:23:50