Database Systems

Core Lecture - Winter Term 2017/2018

Patterns in Data Management Book

The Patterns in Data Management book is available on amazon! Both the ebook and the paperback (with color graphics!) are now available at amazon: Patterns in Data Management: A Flipped Textbook (English Edition). The videos that were used in this class are summarized in this book. A previous version of the book was distributed to my students of this class. Thanks for your positive feedback!

Overview

We are flooded with data be it data on the Web (html pages, twitter, facebook, map services, ...), structured data in databases (your money on bank accounts, addresses, cell phone data, school and uni grades, flight information, taxes, medical records, ...), or data in scientific applications (gene data in bioinformatics, telescope data in astronomy, collider data in physics, measurements of seismic activity in geology, ...).

DBMS Core Lecture
The way we access, manage, and process that data has tremendous impact on:

  1. performance. Though we sometimes think that a performance problem is due to particular algorithm requiring too much CPU time, it is often the data access patterns and retrieval times that slow down a program. The reason for bad performance may be that data cannot be accessed and shipped fast enough to the CPU. For instance you may be using unsuitable access methods to retrieve a single piece of information from a large data repository. Or you might be using an inefficient data layout ignoring the memory hierarchy and hardware capabilities of modern processors. In addition, even if the data was efficiently retrieved, performance may suffer due to picking the wrong analytical algorithms or not scaling your system correctly.

  2. reliability. What happens if your hard disk fails or your data center is flooded with water? How do you make sure that a consistent version of your data is accessible at all times? Can you afford to lose all data? How do you exploit multi-threading for accessing data without corrupting you data repository?

If you are interested in these questions, this might be the right lecture for you.

In this core lecture you will learn how to answer these questions. You will learn fundamental data managing algorithms and techniques which are used to build (not only) database systems but also search engines (Google), file systems, data warehouses, publish/subscribe systems (like Twitter), streaming systems, map services (google maps), or Amazon's Cloud (EC2), etc.

These techniques and algorithms will allow you to design, plan, and build (almost) any kind of data managing system.

Administrative / Organisation

When: Thursday 10:15-12:00 and Tuesday 14:15-16:00 (E1 3, HS 002)
First Lecture: Thursday, October 19.
Administrative Details
Course Management System

Topics

  • data managing architectures (DBMS, file systems)
  • storage media and hierarchies (disk, flash, main memory, caches, NUMA)
  • storage management (DB-file systems, raw devices, write-strategies, differential files, buffer management, RAID, COW, MOW, virtual memory)
  • data layouts (horizontal and vertical partitioning, row stores, columns stores, hybrid mappings, PAX; fractal design, compression, defragmentation)
  • indexing (one- and multidimensional, tree-structured, hash-, partition-based, B-trees, bulk-loading and external sorting, differential indexing, read- and write-optimized indexing, main-memory indexes, covering, composite, sparse and dense, direct and indirect, clustered and unclustered, main memory versus disk and/or flash-based, bitmaps)
  • query processing algorithms (join algorithms for relational, and spatial data, grouping and early aggregation, co-grouping, filtering, external sorting and partitioning)
  • query optimization (query rewrite, cost models, cost-based optimization, join order, plan enumeration)
  • query processing models (operator, interpreted, vectorized, compiled, anti-projection, tuple reconstruction)
  • data recovery (single versus multiple instance, logging, main-memory vs disk, ARIES)
  • concurrency control (MVCC)
  • parallelization of data and queries (horizontal and vertical partitioning, shared-nothing, replication, NoSQL, MapReduce and Hadoop)

Teaching Assistants