FI:PA152 Database System Implementation - Course Information
PA152 Database System Implementation
Faculty of InformaticsAutumn 2007
- 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
- Thu 18:00–19:50 D2
- 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
- Applied Informatics (programme FI, N-AP)
- Information Technology Security (programme FI, N-IN)
- Bioinformatics (programme FI, N-AP)
- Information Systems (programme FI, N-IN)
- Informatics (programme FI, M-IN)
- Informatics (programme FI, N-IN)
- Mathematics with Informatics (programme PřF, N-MA)
- Parallel and Distributed Systems (programme FI, N-IN)
- Computer Graphics (programme FI, N-IN)
- Computer Networks and Communication (programme FI, N-IN)
- Computer Systems (programme FI, N-IN)
- Embedded Systems (eng.) (programme FI, N-IN)
- Theoretical Informatics (programme FI, N-IN)
- Upper Secondary School Teacher Training in Informatics (programme FI, M-SS)
- Upper Secondary School Teacher Training in Informatics (programme FI, M-TV)
- Upper Secondary School Teacher Training in Informatics (programme FI, N-SS) (2)
- Artificial Intelligence and Natural Language Processing (programme FI, N-IN)
- Image Processing (programme FI, N-AP)
- 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
- Study Materials
The course is taught annually.
- Enrolment Statistics (Autumn 2007, recent)
- Permalink: https://is.muni.cz/course/fi/autumn2007/PA152