FI:PA036 Database System Project - Course Information
PA036 Database System Project
Faculty of InformaticsSpring 2025
- Extent and Intensity
- 0/2/0. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
In-person direct teaching - Teacher(s)
- doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Mgr. David Procházka (assistant) - Guaranteed by
- doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics - Prerequisites
- !(SEMESTR(1)||SEMESTR(2))||OBOR(SL)
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming - Course Enrolment Limitations
- The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 80 student(s).
Current registration and enrolment status: enrolled: 0/80, only registered: 141/80, only registered with preference (fields directly associated with the programme): 139/80 - fields of study / plans the course is directly associated with
- there are 31 fields of study the course is directly associated with, display
- Course objectives
- The aim of the course is to analyze a given problem in the field of data processing, implement a solution to the problem, and run performance tests. The implementation requires the use of a contemporary database system, i.e. knowledge of SQL, and any programming language.
- Learning outcomes
- Upon completion of the course the student will be able to: - use a database storage system; - study and use advanced data processing techniques; - design and implement application performance tests.
- Syllabus
- A presentation of ideas in the tasks to be solved. Overview of approaches to optimizing SQL queries.
- Assignment and solution of specific tasks - typically within two weeks per task.
- Continuous evaluation during the solution period (approximately two times) with the possibility of getting extra points in the final solution ranking.
- Corrections to solutions based on feedback after the submission deadline - typically within one week.
- Consultation on assignments during class time.
- Evaluation of all solutions (overall ranking) and announcement of the best ones.
- Literature
- recommended literature
- SMITH, Gregory. PostgreSQL 9.0 high performance : accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down. 1st pub. Birmingham: Packt Publishing, 2010, xiii, 442. ISBN 9781849510301. info
- DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
- Teaching methods
- Introductory presentation of the concept of the course, synchronous consultations during seminars, and independent solving of assigned tasks.
- Assessment methods
- Credit will be awarded based on the successful completion of all assignments. Each assignment must be completed 100%. Assignments have interim checks before the due date and up to two corrections after the due date. Attendance at the opening and closing seminars.
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- The course is taught annually.
The course is taught: every week.
Information on course enrolment limitations: Prerekvizity jsou nastaveny jako preference pro studenty zapisující si předmět dle doporučeného průchodu. Ostatní mohou požádat o výjimku, která bude schválena v případě volné kapacity.
- Enrolment Statistics (recent)
- Permalink: https://is.muni.cz/course/fi/spring2025/PA036