Transcript PPT - Systems Group

Data Modelling and Databases
Donald Kossmann
Systems Group
ETH Zürich
www.systems.ethz.ch
1
Schedule
• Lectures
– Mondays:
10:00 – 12:00
– Wednesdays: 8:00 – 10:00
– Held in German (English slides)
• Exercise Groups (Start March 4)
– Tuesdays:
8:00 – 10:00
– Fridays:
8:00 - 10:00
– Held in English and German
• Please, register during the break on Wednesday:
– lists at the front desk of lecture room
2
Literature
• Kemper, Eickler: Datenbanksysteme: Eine
Einführung. Oldenbourg Verlag, 7. Auflage,
2009.
or
• Garcia-Molina, Ullman, Widom: Database
Systems: The Complete Book. Pearson, 2.
Auflage, 2008.
3
Overview
• How to use a database system?
– Data modelling (ER, UML, theory)
– Database programming (SQL)
• How to build a database system?
– Query optimization
– Transaction management
• What next?
– Object-orientierted, object-relational databases
– Big Data: Data Warehousing, Data Mining
– XML & WWW
4
Detailed Schedule
Week No.
Date (Mo)
Topic Lecture
Topic Exercises
1
17.2.2014 Introduction
---
2
24.2.2014 ER, UML
---
3
3.3.2014 Relational Model
ER
4
10.3.2014 SQL I
Start project
5
17.3.2014 (Exam), SQL II
Relational Model
6
24.3.2014 Integrity Constraints
SQL
7
31.3.2014 Normal Forms I
---
8
9
7.4.2014 Normal forms II, (Exam)
SQL
14.4.2014 Query Processing I
IC, Project: Part I
10
21.4.2014 ---
Normal forms
11
28.4.2014 Query Processing II
Normal forms, Proj.
12
5.5.2014 Transactions
Query Processing
13
12.5.2014 Synchronization
Transactions
14
19.5.2014 Security, (Exam)
Synchronization
15
26.5.2014 Object-relational Databases
End Project: Part 2
5
Exercises & Exams
• Exercise Sheets
– Handout in the week before it is discussed
– Not graded
– Please, do them before they are discussed!
• Project
– Part 1: Build an App; Part 2: Build a DB
– Groups of three students
– Graded: 20 % weight (10 + 10)
• Written Exams – all closed book!
– 3 x during the semester (30 min): 30 % weight
– Sessionsprüfung (90 min): 50% weight
6
Teaching Philosophy
• Formally my role is …
– define the curriculum
– define the material (textbook, supplementary…)
– organize exercises and exams
• My real role…
– take away “scare”
– lead by example
• (if I am not passionate, why would you be?)
– put things into context: say what is not in textbook
– have fun, be different
7
Teaching Philosophy (ctd.)
• Learning by doing
– homework, tests, projects, exams
– constant feedback: you know where you are
• Reverse classroom
– puts you into the center of attention
– you progress at your speed (not mine)
– use lecture & exercises to ask questions
8
Intensity over Time
work
time
9