FI:PA152 Database System Implementation

PA152 Database System Implementation

Faculty of Informatics
Autumn 2003

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 8:00–9:50 VC311

Course Enrolment Limitations

The course is only offered to the students of the study fields the course is directly associated with.

fields of study / plans the course is directly associated with

there are 7 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, overview of a database management system. Data storage, memory hierarchy, using secondary storage efficiently. Representing data elements, objects, records, blocks, variable length data, data modification. Index structures, sequential, trees, hash tables. Multidimensional indexes, applications, hash based, tree based. Query execution, query algebra, query plan operators, algorithms. The query compiler, parsing, algebraic laws, estimating the cost, algorithms. Coping with system failures, failure modes, correct transaction execution, supporting tools. Concurrency control, serial and serializable schedules, locks, timestemps. Information integration.

Literature

H. Garcia-Molina, J.D. Ullman, and J. Widom. Database System Implementation. Prentice Hall, New Jersey, 2000

Language of instruction

Czech

Further Comments

The course is taught annually.