Temporal and Spatial Data Management TSDM17

Lecturer: Michael Böhlen
Teaching language: English
Term: Fall 2017

Objectives: The course provides an in-depth understanding of the fundamentals of temporal and spatial database systems. Temporal and spatial data are present in virtually all application areas. We discuss the challenges that arise from the management of temporal and spatial data; we show solutions and limitations of current database systems; we discuss the directions of current research in the area; and we illustrate the basic principles in terms of data models, query languages, algebras and algorithms. The course is taught in odd years only.

Requirements: Please only follow the course if you have attended an introductionary database course before.

Teaching format and exam: The course consists of lectures and exercises. The exam is oral and takes place January 8, 2018 in room BIN 2.E.13.

Reading material: The literature are research papers. The papers and lecture notes for the course will become available as we progress through the semester.


Lectures The lectures take place Monday 14:00-15:45 in room BIN 2.A.01 and starts September 18. Tentative syllabus and slides:

  • SL01, New requirements, motivation temporal databases, 1up, 4up, ex1, SQL:2011
  • SL02, Time domain, granularity, calendar, now, , ,
  • SL03, Temporal data models and extensions of SQL, , ,
  • SL04, Sequenced semantics, , , , ,
  • SL05, Temporal join and aggregation, , ,
  • SL06, Spatial databases, , ,
  • SL07, Query processing in spatial network databases, ,