CS 460 Database Technology (FSS 2023)
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
- Lecture: Wednesday, 12.00 – 13.30, B6 26, A104
- Exercise: Wednesday, 13.45 – 15.15, B6 26, A104
Exam Review
- The exam review for the first exam of FSS2023 will take place on Monday, August 21st, between 10:00 and 10:30 in room C1.01 (building B6, 29). Please register by mail to Bianca Lermer until Monday, August 14th.
- The exam review for the second exam of FSS2023 will take place on Friday, October 20th, between 10:00 and 10:30 in room B0.01 (building B6, 26). No registration necessary.
Administrative Details
No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.
Material and Literature
Slides and exercise materials will be posted here.
Lecture
22.02.2023: Organization (PDF, 2 MB), Introduction (PDF, 3 MB)
01.03.2023: SQL Part 1 (PDF, 3 MB)
08.03.2023: SQL Part 2 (PDF, 8 MB)
15.03.2023: Entity Relationship Models (PDF, 6 MB)
22.03.2023: Normal Forms (PDF, 4 MB)
29.03.2023: Indexing and Hashing (PDF, 16 MB)
19.04.2023: Database Architectures (PDF, 10 MB)
26.04.2023: Query Processing (PDF, 6 MB)
03.05.2023: Query Optimization (PDF, 3 MB)
10.05.2023: Transactions and Concurrency (PDF, 2 MB)
17.05.2023: Recovery (PDF, 2 MB)
24.05.2023: Application Development (PDF, 3 MB)
Exercise
22.02.2023: Introduction (PDF, 199 kB)
01.03.2023: SQL Part 1 (PDF, 228 kB)
08.03.2023: SQL Part 2 (PDF, 98 kB)
15.03.2023: ER Models (PDF, 101 kB)
22.03.2023: Normal Forms (PDF, 114 kB)
29.03.2023: Indexing and Hashing (PDF, 116 kB)
19.04.2023: Database Architectures (PDF, 260 kB)
26.04.2023: Query Processing (PDF, 186 kB)
03.05.2023: Query Optimization (PDF, 143 kB)
10.05.2023: Transactions, Concurrency (PDF, 121 kB)
17.05.2023: Recovery (PDF, 117 kB)
24.05.2023: 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 15.2. -- -- 22.2. Introduction Introduction 1.3. SQL Part 1 SQL Part 1 8.3. SQL Part 2 SQL Part 2 15.3. ER Models ER Models 22.3. Normal Forms Normal Forms 29.3. Index and Hashing Index and Hashing + Intro Easter Eggcercise 5.4. Easter Break Easter Break 12.4. Easter Break Easter Break 19.4. DB Architectures DB Architectures 26.4. Query Processing Query Processing
3.5. Query Optimization Query Optimization 10.5. Transactions and Concurrency Transactions and Concurrency 17.5. Recovery Recovery 24.5. Application Development Application Development