Zur Seitennavigation oder mit Tastenkombination für den accesskey-Taste und Taste 1 
Zum Seiteninhalt oder mit Tastenkombination für den accesskey und Taste 2 
Startseite    Anmelden     
Logout in [min] [minutetext]

Database System Architecture and Implementation - Einzelansicht

Grunddaten
Veranstaltungsart Vorlesung/Übung Kurztext
Veranstaltungsnummer INF-12950-20132 Rhythmus jedes 2. Semester
Semester WS 2013/14 Studienjahr
Erwartete Teilnehmer/-innen 25 Max. Teilnehmer/-innen 45
SWS 4 Sprache englisch
Credits 6
Hyperlink http://www.informatik.uni-konstanz.de/grossniklaus/education/dbmsinternals/
Belegungsfrist
Termine: Vorlesung iCalendar Export
  Tag Zeit Rhythmus Dauer Raum Raum-
plan
Lehrperson Status Bemerkung fällt aus am Max. Teilnehmer/-innen
Einzeltermine anzeigen
iCalendar Export
Mo. 15:15 bis 16:45 wöchentl. 21.10.2013 bis 10.02.2014  E - E 402       45
Einzeltermine anzeigen
iCalendar Export
Mi. 10:00 bis 11:30 wöchentl. 23.10.2013 bis 11.02.2014  R - R 512       45
Vorlesung:
 


Zugeordnete Lehrpersonen
Zugeordnete Lehrpersonen Zuständigkeit
Grossniklaus, Michael, Prof. Dr. verantwortlich
Weiler, Andreas, Dr. begleitend
StudIS-Prüfungen / Module
Prüfungsnummer Prüfungstext
INF-12950 Database System Architecture and Implementation
StudIS-Prüfungsorganisationssätze
Semester Termin Prüfer/-in Datum Beginn Dauer Raum Bemerkung Leistungsanmeldung Rücktritt bis StudIS-
Status
WS 2013/14 01 Grossniklaus, Michael , Juniorprof. Dr. 20.02.2014 11:30 A 701 21.10.2013 bis
29.11.2013
31.01.2014 StudIS-Prüfungsanmeldung beendet
WS 2013/14 02 Grossniklaus, Michael , Juniorprof. Dr. 16.04.2014 14:00 A 702 Nicht/noch nicht für die StudIS-Prüfungsanmeldung freigeschaltet
_______________
Nicht/noch nicht für die StudIS-Prüfungsanmeldung freigeschaltetNicht/noch nicht für die StudIS-Prüfungsanmeldung freigeschaltet
Für die StudIS-Prüfungsanmeldung freigeschaltet - Prüfungsanmeldung läuft noch nichtFür die StudIS-Prüfungsanmeldung freigeschaltet - Prüfungsanmeldung läuft noch nicht
Für die StudIS-Prüfungsanmeldung freigeschaltet - Prüfungsanmeldung läuft derzeitFür die StudIS-Prüfungsanmeldung freigeschaltet - Prüfungsanmeldung läuft derzeit
Anmeldezeitraum abgelaufen - Rücktritt noch möglichAnmeldezeitraum abgelaufen - Rücktritt noch möglich
StudIS-Prüfungsanmeldung beendetStudIS-Prüfungsanmeldung beendet
Zuordnung zu Einrichtungen
FB Informatik und Informationswissenschaft
AG Scholl (Database and Information Systems)
Inhalt
Literatur

The following study materials are relevant for this course.

  • Textbook: Raghu Ramakrishnan and Johannes GehrkeDatabase Management Systems (3rd Edition), McGraw-Hill, 2002
  • Course slides: Copies of the slide decks used in the course will be made available online
  • Reading list: A bibliography of the references used in the course as well as further readings will be available on the course website
Voraussetzungen

The following skills, knowledge and courses are mandatory prerequisites to attend and successfully complete this course.

  • Basics of database systems: database design, query languages, database application programming, etc. (INF-12040 or equivalent)
  • Principles of database systems: relational model, relational algebra, normal forms, etc. (INF-12040 or equivalent)
  • Computer systems: computer architecture, operating systems, networks, etc. (INF-11740, INF-11880, or equivalent)
  • System programming: students must have the ability to program in a language appropriate for system implementation, such as C/C++, C# or Java. (INF-11930 or equivalent)
  • Key competences: Subversion, LaTeX, etc. (INF-10175 or equivalent)
Leistungsnachweis

The final exam of this course will be conducted as a 2-hour written exam. The exam will be weighted 50% in the final grade of this course with exercises and project work contributing another 50% of the grade.

Lerninhalte

Modern database systems use advanced data structures and algorithms to manage and process data. Building on the basic database system course, this course looks at the internals of database systems in terms of their architecture and implementation. The lectures are structured according to the levels of a general layered software architecture for database systems, which is introduced at the beginning of the course. The course starts at the lowest level with the I/O system and the management of buffers and storage, i.e., disk and file management. Moving up a level of the architecture, the course then introduces different kinds of index structures, such as tree-based and hash-based indexes. Continuing from this groundwork, the course then focuses on query processing in terms of query execution and optimization. Finally, the course will teach how benchmarks can be used to qualitatively and quantitatively assess the performance of different database systems. Gathering and understanding results of database system benchmarks is the basis for selecting and tuning a database system for a given application. Throughout the course, students have a chance to get first-hand practical experience with the presented techniques and implementation concepts through a series of mandatory programming exercises.

Zielgruppe

The course targets the following groups of students.

  • Advanced Bachelor students in Computer Science or Information Engineering, who are close to graduation and meet the mandatory minimum requirements for this course
  • Master students in Information Engineering, who meet the mandatory minimum requirements
  • All students, who meet the minimum requirements for this course and who plan to specialize in the area of databases and information systems by conducting a project or attending a practical course on this topic
Lernziel

In this course, students will learn to understand and apply the data structures and algorithms that are used to realize the storage, indexing, and query processing functionality of contemporary relational database systems. In doing so, students will acquire the ability to differentiate between operating and database system functionality. Finally, the course imparts the knowledge required to assess the qualitative and quantitative differences between different relational database systems. Therefore, the course syllabus will enable students to make informed choices when selecting or tuning a database system for a given application.

Arbeitsaufwand

180 hours, of which ca. 60 hours are spent in class and another 120 hours are spent on exercises and project work.


Strukturbaum
Keine Einordnung ins Vorlesungsverzeichnis vorhanden. Veranstaltung ist aus dem Semester WS 2013/14 , Aktuelles Semester: WS 2017/18
STUDIS    Anzahl aktueller Nutzer/-innen: 42 Haben Sie Anregungen, Fragen, Lob oder Kritik zum LSF?
Dann schreiben Sie uns!
Impressum
Datenschutzerklärung