|
|||||||||||
This course reviews fundamental ideas and algorithms that are used in the construction of database systems. Topics to be covered include: query processing, query optimization, one-dimensional indexing, multi-dimensional indexing, performance aspects of database systems, database tuning, data layout, synchronisation, recovery. An additional purpose of this course is to give students the necessary background and tools to be able to write a MSc Thesis in the area of information systems.
(04-12-2007) The exam will be on Thursday, December 20, 2007, 2.15pm (approx. one hour), in room HG D7.2. You may bring two A4 sheets of paper (you may write on both sides) with handwritten notes (neither computer-generated content nor photocopies are allowed). No other material is allowed during the exam (e.g., no textbooks, slide printouts, electronic devices, etc.). Please bring your Legi.
(10-01-2008) Exam results (student ID, grade) can be viewed here. Access is protected through nethz logins.
| Introduction | 1 slide/page | 6 slides/page | |
| Indexing (Part 1) | 1 slide/page | 6 slides/page | |
| Indexing (Part 2) | 1 slide/page | 6 slides/page | (updated: Slide 36) |
| Multi-dimensional Indexing | 1 slide/page | 6 slides/page | |
| Query Processing (Part 1) | 1 slide/page | 6 slides/page | |
| Query Processing (Part 2) | 1 slide/page | 6 slides/page | |
| Query Optimization | 1 slide/page | 6 slides/page | |
| Recovery | 1 slide/page | 6 slides/page | |
| Concurrency Control | 1 slide/page | 6 slides/page | (updated: Slide 5) |
| Parallel Databases | 1 slide/page | 6 slides/page | (updated: Slide 34) |
| Architectural Outlook | 1 slide/page | 6 slides/page |
We will have two equal exercise sessions per week during the semester:
The exercise sheets will be put online here one or two days after the lecture, e.g. on friday or saturday - therefore you should have ample time to solve them on sunday or the following week. We will discuss the exercises in the exercise group one week later.
2V1U (Thursdays , 14-16, CAB G 56)
English
Wichtiger Hinweis:
Diese Website wird in älteren Versionen von Netscape ohne
graphische Elemente dargestellt. Die Funktionalität der
Website ist aber trotzdem gewährleistet. Wenn Sie diese
Website regelmässig benutzen, empfehlen wir Ihnen, auf
Ihrem Computer einen aktuellen Browser zu installieren. Weitere
Informationen finden Sie auf
folgender
Seite.
Important Note:
The content in this site is accessible to any browser or
Internet device, however, some graphics will display correctly
only in the newer versions of Netscape. To get the most out of
our site we suggest you upgrade to a newer browser.
More
information