Temporal and Spatial Data Management TSDM19

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 a closed-book exam, no notes are allowed.

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 16. Tentative syllabus and slides:

• SL01, New requirements, motivation temporal databases, sl01 (1up, 4up, ann), ex01, coal.sql
• SL02, Time domain, now, granularity, calendar, sl02 (1up, 4up, ann), ex01
• SL03, Sequenced Semantics, sl03 (1up, 4up, ann), ex03, align.sql, DBGJ16
• SL04, Temporal data models and extensions of SQL, sl04 (1up, 4up, ann), ex04, BJ03, KM12
• SL05, Spatial databases, sl05 (1up, 4up, ann), ex05, Gue94
• SL06, Query processing in spatial network databases, sl06 (1up, 4up, ann), ex05, PZMT03
• SL07, Summary and exam, sl07, exm17