PA152 Database System Implementation

Faculty of Informatics
Autumn 2008
Extent and Intensity
2/0. 2 credit(s) (plus extra credits for completion). Type of Completion: zk (examination).
Teacher(s)
doc. Mgr. Pavel Rychlý, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Fri 12:00–13:50 D3
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The aim of the course is to teach students implementation principles of database systems with the emphasis on their efficiency.
Syllabus
  • Introduction
  • Data storage: memory hierarchy, using secondary storage efficiently, records, blocks.
  • Searching: index structures, sequential, trees, hash tables, multidimensional indexes.
  • Query execution: query plan, operators, algorithms, algebraic laws, estimating the cost.
  • Coping with system failures: failure modes, correct transaction execution, supporting tools.
  • Concurrency control: serial and serializable schedules, locks, timestamps, validations, MapReduce.
Literature
  • GARCIA-MOLINA, Hector, Jeffrey D. ULLMAN and Jennifer WIDOM. Database system implementation. Upper Saddle River: Prentice Hall, 2000, xv, 653 s. ISBN 0-13-040264-8. info
Assessment methods
Lectures, optional individual projects, written exam.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2002, Autumn 2003, Autumn 2004, Autumn 2005, Autumn 2006, Autumn 2007, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.
  • Enrolment Statistics (Autumn 2008, recent)
  • Permalink: https://is.muni.cz/course/fi/autumn2008/PA152