FI:PA152 Database System Implementation

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

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

there are 19 fields of study the course is directly associated with, display

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.