Nonstandard Database Systems NDBS14

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.

Teaching format and exam: The course consists of lectures and exercises. The exam is oral and takes place January 16, 2015 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 Friday 14:00-15:45 in room BIN 2.A.10 and start September 19. Please note that the November 7 lecture takes place in room BIN 1.D.07. Bring your laptops. Tentative syllabus and slides:

• SL01, New requirements, motivation temporal databases, sl01.pdf, sl01-2x2.pdf, ex01.pdf, ex01.sql
• SL02, Time domain, granularity, calendar, now, sl02.pdf, sl02-2x2.pdf, ex02.pdf
• SL03, Abstract and concrete temporal data models, sl03.pdf, sl03-2x2.pdf, ex03.pdf, JSS93.pdf
• SL04, Temporal Extensions of SQL, sl04.pdf, sl04-2x2.pdf, ex04.pdf, ex04.sql, BJ03.pdf, DBG12.pdf
• SL05, Temporal join and aggregation, sl05.pdf, sl05-2x2.pdf, ex05.pdf
• SL06, Spatial databases, sl06.pdf, sl06-2x2.pdf, Gut94.pdf, ex06.pdf
• SL07, Query processing in spatial network databases, sl07.pdf, sl07-2x2.pdf, PZMT03.pdf
• Summary and Exam IMPORTANT EXAM INFORMATION here (PDF, 47 KB)