Datenbanksysteme II (WS 2014/15)

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.

Predecessor of this series: Datenbanksysteme II (WS 2010/11)

Einführung

Organisatorisches und Einführung

Date: October 13, 2014
Language: German
Duration: 01:22:18

Speicherung

Speicherhierarchie und Disks

Date: October 15, 2014
Language: German
Duration: 01:22:56

Effiziente Diskoperationen und Zugriffsbeschleunigung

Date: October 20, 2014
Language: German
Duration: 01:24:57

Diskausfälle

Date: October 22, 2014
Language: German
Duration: 01:08:31

RAID 5 - 6

Date: October 27, 2014
Language: German
Duration: 00:28:05

Physische Repräsentation von Daten

Physische Repräsentation von Daten I

Date: October 27, 2014
Language: German
Duration: 00:33:07

Physische Repräsentation von Daten II

Date: October 29, 2014
Language: German
Duration: 00:31:57

Indexstrukturen

Indizes auf sequenziellen Dateien

Date: October 29, 2014
Language: German
Duration: 00:55:00

Sekundärindizes auf nicht-sequenziellen Dateien

Date: November 10, 2014
Language: German
Duration: 01:29:35

B-Bäume und Hash-Tabellen

Date: November 12, 2014
Language: German
Duration: 01:26:57

Erweiterbare und Lineare Hashtabellen

Date: November 17, 2014
Language: German
Duration: 00:33:32

Multidimensionale Indizes

Anwendung und Grid Files

Date: November 17, 2014
Language: German
Duration: 00:57:31

Partitioniertes Hashing und Baumstrukturen

Date: November 19, 2014
Language: German
Duration: 01:12:13

Anfrageausführung

Einführung Anfrageausführung

Date: November 19, 2014
Language: German
Duration: 00:13:17

Iteratoren und Operatoren

Date: November 24, 2014
Language: German
Duration: 01:28:27

Hash-basierte Two-Pass Algorithmen

Date: December 3, 2014
Language: German
Duration: 01:24:40

Index-basierte Algorithmen & Optimierung

Date: December 10, 2014
Language: German
Duration: 01:28:59

Optimierung

Kostenschätzungen

Date: December 15, 2014
Language: German
Duration: 01:31:14

Dynamische Programmierung

Date: December 17, 2014
Language: German
Duration: 01:35:55

Recovery

Undo-Logging

Date: January 7, 2015
Language: German
Duration: 01:29:27

Redo Logging & Undo/Redo Logging

Date: January 12, 2015
Language: German
Duration: 01:23:25

Web-scale Data Management

WDM for analytic databases (2)

Date: January 21, 2015
Language: German
Duration: 01:19:20

WDM Transaction Management (1)

Date: January 26, 2015
Language: German
Duration: 01:23:59

WDM Transaction Management (2)

Date: January 28, 2015
Language: German
Duration: 01:30:19

WDM, cloud and services

Date: February 2, 2015
Language: German
Duration: 01:30:58