Welcome to the M.Sc. course Advanced Database Systems. In this course you will learn what it takes to be a Database Administrator, analysing and improving the performance of databases. You will also learn in detail how transactions are handled by database management systems. The course has a little bit of everything: ordinary lectures, a little practicum, and a small project about handling sensor data. We hope to see you Thursday September 3rd, at 10.45h. in CR-3D.
Mena Badieh Habib Morgan, Maurice van Keulen, and Djoerd Hiemstra.
More info at: http://blackboard.utwente.nl (access still restricted 🙁 )
The best project results of the course Advanced Database Systems will be presented on Friday 7 November 2008, 13.45h. – 15.30h. in room HO-B1220. In the projects, students built or analyzed applications of Geographic Information Systems (GIS). We will have the following presentations:
- Study of the Design of a GIS application by Haihan Yin, Rabah Khilfeh, and Ravi Khadka
- Betonning & Peiling by Menno Tammens and Steven ten Brinke
- ReBata: Replaying the Batavierenrace by Michiel Hakvoort, Gido Hakvoort, and Ronald Peterson
Maurice van Keulen will give the final lecture on On-Line Analytical Processing & Data Warehouses on Wednesday 22 October, 1/2h. in HO-B1228. Maurice is one of the Database Group members, and teaches the follow-up course Data warehousing & data mining (232020).
Two days later, on Friday 24 October, is the dead line for sending in the report (subproject A) or the software install package (subproject B). The report or software should be accompanied by a prepared presentations (including e.g. a Powerpoint slide show) of about half an hour. At the written exam on 5 November, I will announce the lucky winners that will be asked to give the presentation to all of us on Friday 7 November 5/6h.
More on TeleTOP
In the Archive section on TeleTOP, you find a small report containing the actions I did on the Mini Practicum database to solve the practical assignment. For each action I explain the behaviour of PostgreSQL. Its purpose is to give some insight in what you should have done, and why.
The mini practical assignment is finished. This week the project started. Please, form groups of two persons, read the project description in the Archive section on TeleTOP, and choose one of the subprojects Send the following to Djoerd Hiemstra (dead-line 1 October)
- what people form the group?
- subproject A or subproject B?
The mini practical assignment for Advanced Database Systems takes place next Friday 19 September 7/8 h. in ZI-C4. The practicum description and data can be downloaded from the Archive section on TeleTOP. The assignment can be done in groups of two persons. Deadline for handing in results: 24 September.
Because the room Vrijhof 6 offers insufficient space in weeks 37-43 the course on Wednesday 1st and 2nd hour will be given in room HO B1228.
More information on TeleTOP (access restricted)
Welcome to ADS! This course will have a little bit of everything: traditional lectures, home work assignments (on a voluntary basis), a small (half a day) practicum assignment, a small project, and a written exam. The course consist of two parts. In the first part, you are going to learn how relational databases work in practice: what happens inside the system when an SQL query is executed? In the 2nd part of the course, we are going to discuss applications for which relational databases do not provide a perfect solution: object-oriented data, semi-structured data, distributed data and online analytical processing.
More info on TeleTOP
I finished correcting the exams for Advanced Database Systems. You will be notified of the project grade, exam grade and final grade via the usual little grade form. The solutions to the exam can be found in the Archive section on TeleTOP.
When: 26 October 2007, 15.45 h. – 17.30 h.
15.45 h. – 16.15 h. : Tools for GIS applications by Tim Klifman & Niels Werensteijn
16.15 h. – 16.35 h. : CSI Twente: Algemeen Delictensysteem by Jonathan Brugge & Eelco Eerenberg
16.35 h. – 16.50 h. : break
16.50 h. – 17.10 h. : Indicating the Shortest Path (in Kalimantan) by Robert Markovics & Pythia Sulistyo
17.10 h. – 17.30 h. : CrisGIS: simulation of crisises on geo data by Tijn van Hofwegen & Jorrit Schippers
NB the first presenters will have about 30 minutes (project A). The others (project B) have about 20 minutes.