Database Systems Lecture (winter term 20/21)

Dormant Last read 3 days ago · last published 6 years ago · next check scheduled
Read 3 days ago and current, but nothing has been published for 6 years.

Written by

This blog elsewhere

Latest videos

Saves to your Watch queue, to pick up on another day or another device.

Recap: The Core of Database Technology in "only" 200 Slides

Feb 3, 2021 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Multiversion Concurrency Control (MVCC)

Jan 27, 2021 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Elasticity or: How to NOT build a Teaching Platform

Jan 20, 2021 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Crash Recovery: logging, ARIES, disk-based vs main-memory recovery

Jan 13, 2021 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Query Optimization (Part 2), operator models, blocking, push vs pull, late materialization

Jan 6, 2021 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Database Systems: Query Optimization (Part 1), rule- vs cost-based, join graph, interesting orders

Dec 16, 2020 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Database Systems: Query Processing, Join Algorithms, External Merge Sort, Early Aggregation

Dec 9, 2020 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Database Systems: Indexing (Part 2), Bitmaps, Blook Filters, Logical and Physical Indexes

Dec 2, 2020 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Database Systems: Indexing (Part 1), B-Trees, Bulkloading, Read-Optimized Trees

Nov 25, 2020 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Database Systems: Data Layouts, Row, Column, and Hybrid Layouts, Compression

Nov 18, 2020 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Database Systems: Storage, Storage Hierarchy, pulling data up and down, caching, DB buffer, RAID

Nov 11, 2020 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play

Database Systems: Intro and Admin

Nov 4, 2020 · Prof. Dr. Jens Dittrich, Big Data Analytics

Play