CS 460 Database Technology (FSS 2022)
Important: This course is open only to MMDS students!
Course Description
The course provides an introduction to relational database systems. The course will cover the following topics:
- Principles of data storage
- Database query languages (SQL)
- Relational modeling
- Keys and normal forms
- Hash and index structures
- Transactions and concurrency
Lecturers
Dates and Times
At the moment, we assume that the course can be held in presence, but we are closely monitoring the pandemic situation, and we are prepared to switch to an online or hybrid setting.
- Lecture: Wednesday, 12.00 – 13.30, B6 26, A104
- Exercise: Wednesday, 13.45 – 15.15, B6 26, A104
For students who cannot attend the classes in presence (e.g., due to visa or quarantine issues), we provide lecture recordings from the past year.
Exam Review
- The exam review for the first exam of FSS2022 will take place on Thursday, August 25th, between 10:00 and 10:30 in room C1.01 (building B6, 29). You do not need to register.
- The exam review for the second exam of FSS2022 will take place on Wednesday, November 9th, between at 14:00 in room C1.01 (building B6, 29). You do not need to register.
Administrative Details
No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.
Material and Literature
Slides:
- 16.02.: Organization (PDF, 640 kB), Introduction (PDF, 2 MB)
- 23.02.: SQL Part 1 (PDF, 2 MB)
- 02.03.: SQL Part 2 (PDF, 2 MB)
- 09.03.: Entity Relationship Models (PDF, 3 MB)
- 16.03.: Normal Forms (PDF, 1 MB)
- 23.03.: Indexing and Hashing (PDF, 4 MB)
- 30.03.: Database Architectures (PDF, 3 MB) (video only, no live lecture!)
- 06.04.: Query Processing (PDF, 1 MB) (video only, no live lecture!)
- 27.04.: Query Optimization (PDF, 1 MB)
- 04.05.: Transactions and Concurrency (PDF, 2 MB)
- 11.05.: Recovery (PDF, 1 MB)
- 18.05.: Database Applications (PDF, 2 MB)
Exercises:
- 16.02.: Introduction (PDF, 199 kB)
- 23.02.: SQL 1 (PDF, 228 kB)
- 02.03.: SQL 2 (PDF, 98 kB)
- 09.03.: ER Models (PDF, 101 kB)
- 16.03.: Normal Forms (PDF, 114 kB)
- 23.03.: Indexing and Hashing (PDF, 116 kB)
- 30.03.: Database Architectures (PDF, 260 kB)
- 06.04.: Query Processing (PDF, 186 kB) , Easter Eggcercise (PDF, 82 kB)
- 27.04.: Query Optimization (PDF, 143 kB)
- 04.05.: Transactions and Concurrency (PDF, 121 kB)
- 11.05.: Recovery (PDF, 117 kB)
- 18.05.: Application Development (PDF, 104 kB)
Video recordings, exercise solutions and additional materials will be made available in the corresponding ILIAS group.
The course will be based on the book Database System Concepts by Silberschatz et al.
Outline
Date Lecture Exercise 16.2. Introduction Introduction 23.2. SQL Part 1 SQL Part 1 2.3. SQL Part 2 SQL Part 2 9.3. ER Models ER Models 16.3. Normal Forms Normal Forms 23.3. Index and Hashing Index and Hashing 30.3. DB Architectures DB Architectures 6.4. Query Processing Query Processing + Intro Easter Eggcercise
13.4. Easter Break Easter Break 20.4. Easter Break Easter Break 27.4. Query Optimization Query Optimization 4.5. Transactions and Concurrency Transactions and Concurrency 11.5. Recovery Recovery 18.5. Application Development Application Development 25.5. -- Wrap up and Q&A The exam will take place on Friday, June 17th, time and location tba.