IT-Universitetet i København
 
  Tilbage Kursusoversigt
Kursusbeskrivelse
Kursusnavn (dansk):Databasetuning 
Kursusnavn (engelsk):Database Tuning 
Semester:Forår 2010 
Udbydes under:cand.it., softwareudvikling og -teknologi (sdt) 
Omfang i ECTS:15,00 
Kursussprog:Engelsk 
Kursushjemmeside:https://learnit.itu.dk 
Min. antal deltagere:12 
Forventet antal deltagere:20 
Maks. antal deltagere:50 
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.

 
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.

The course deals with the following major topics:
  • Architectures: GAMMA, c-store, bigtable/h-base
  • Data models: relational, array-based, sequence
  • Physical Data Organization and Indexing
  • Transaction management: Concurrency Control and recovery
  • Query optimization
  • Operating System services


This course contains an integrated project. It will give students a unique opportunity to get a hands-on experience with the Amazon Web Services (cloud computing) infrastructure, thanks to a grant from IBM and Amazon.
 
Læringsaktiviteter:14 ugers undervisning bestående af forelæsninger, øvelser og vejledning

Teaching consists of a mix of lectures, exercises, and project supervision. The exercises are in the form of tuning experiments. The project, comprising approximately half of the course, consists of a case study on the Amazon Web Services cloud computing platform (thanks to a grant from IBM and Amazon).

The first half of the course will focus on lectures and exercises, while the second half will be dedicated to the project. The oral exam will be based on the project report.

 

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

 

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.30-10.30 Forelæsning ITU Auditorium 3 (2A56)
Tirsdag 10.45-12.45 Øvelser ITU Auditorium 3 (2A56)
Torsdag 08.30-10.30 Forelæsning ITU Auditorium 4 (4A60)
Torsdag 10.45-12.45 Øvelser ITU Auditorium 4 (4A60)

Eksamen afholdes på følgende tid og sted:
EksamensdatoTidspunktEksamenstypeStedLokale
2010-05-25 No later than 3 PM Skriftlige arbejder ITU The Examination Office
2010-06-16 Please contact the course manager Mundtlig eksamen ITU 3A08
2010-06-17 Please contact the course manager Mundtlig eksamen ITU 3A08
2010-06-18 Please contact the course manager Mundtlig eksamen ITU 3A08
2010-08-20 Mulig dag for reeksamen /Possible date for re-exam Mundtlig eksamen ITU Eksamensform kan blive ændret / Examination form may be altered
2010-08-23 Mulig dag for reeksamen /Possible date for re-exam Mundtlig eksamen ITU Eksamensform kan blive ændret / Examination form may be altered
2010-08-25 Mulig dag for reeksamen /Possible date for re-exam Mundtlig eksamen ITU Eksamensform kan blive ændret / Examination form may be altered