IT-Universitetet i København
 
  Tilbage Kursusoversigt
Kursusbeskrivelse
Kursusnavn (dansk):Database Tuning Project 
Kursusnavn (engelsk):Database Tuning Project 
Semester:Forår 2011 
Udbydes under:cand.it., softwareudvikling og -teknologi (sdt) 
Omfang i ECTS:7,50 
Kursussprog:Engelsk 
Kursushjemmeside:https://learnit.itu.dk 
Min. antal deltagere:12 
Forventet antal deltagere:60 
Maks. antal deltagere:70 
Formelle forudsætninger:In order to participate at this course you must have completed the course Database Systems (DBS). or have achieved equivalent competencies elsewhere.
-----
Information about the course of study
This course is part of a specialization on the Master of Science in IT, study programme Software Development and Technology. See a description of specializations on SDT here:
Kandidat Software Development Technology 
Læringsmål:After the course the student should be able to:

  • Analyze the performance impact of design choices within a database system (indexing, query optimization, concurrency control and recovery)

  • Analyze and Compare the characteristics of different data models (relational, sequence, array)

  • Analyze and Compare the characteristics of distributed and parallel data management architectures (e.g., database management system, column store, cluster/grid data processing)

  • Design and execute experiments to evaluate a data management system performance

 
Fagligt indhold:After decades of development, the software behind relational databases (RDBMSs) makes it possible to design, in a technically relatively simple way, robust software systems that work correctly even in demanding environments with many users, system breakdowns, etc. Often, uses of database systems put high demands on the speed and throughput of the system: Long waiting times are not acceptable, certain types of maintenance and data analysis must run overnight, etc. The goal of this course is to provide students with conceptual and practical tools for improving the performance of relational databases (perform "tuning").

Successful candidates will acquire a thorough understanding of the internals of data management systems; they will be able to choose a data management system that matches given needs and they will be able to tune a data management system for performance.

Reasoning about the performance of a database system requires (a) understanding the internal workings of the database system, and (b) the ability to experiment to either troubleshoot a performance problem or expose the performance characteristics of a given system.

This course contains an integrated project. It will give students a unique opportunity to get a hands-on experience tuning a database system for a given application. 
Læringsaktiviteter:14 ugers undervisning bestående af forelæsninger, øvelser og vejledning

Teaching consists of project supervision.
-----
NB!! Course restriction!!
Please note that there is a course restriction between this course and the SDT courses Database Tuning, Scientific Data Management and Advanced Data Management.
That means that you cannot take this course, if you have already taken Database Tuning, Advanced Data Management and Scientific Data Management, and that you cannot take Scientific Data Management if you take this course.

In order to complete the Database specialization on SDT, you need to take the course Database Tuning I.
-----
Scheduling information
This course runs twice a week for 8 weeks in continuation of the course Database Tuning I.

The schedule will be available shortly before the beginning of the term.
See the schedule here:
link to the time table 

Eksamensform og -beskrivelse:X. experimental examination form (7-scale; external exam), 7-trins-skala, Ekstern prøve

 

Litteratur udover forskningsartikler:The course uses the following textbook:

Database Tuning. Principles, Experiments, and Troubleshooting Techniques, by Dennis Shasha and Philippe Bonnet, Morgan Kaufmann, 2003. ISBN: 1558607536.

In addition, a number of surveys and research papers will be covered. 
 
Afholdelse (tid og sted)
Kurset afholdes på følgende tid og sted:
UgedagTidspunktForelæsning/ØvelserStedLokale
Tirsdag 08.00-10.00 Forelæsning ITU Aud 3
Tirsdag 10.00-12.00 Øvelser ITU Aud 3
Torsdag 08.00-10.00 Forelæsning ITU Aud 3
Torsdag 10.00-12.00 Øvelser ITU Aud 3

Eksamen afholdes på følgende tid og sted:
EksamensdatoTidspunktEksamenstypeStedLokale
2011-05-25 No later than 3 PM Eksamensopgave 1 ITU The Examination Office