PA036 Database System Project

Faculty of Informatics
Spring 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: 0/80, only registered with preference (fields directly associated with the programme): 0/80
fields of study / plans the course is directly associated with
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.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, 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.
  • Enrolment Statistics (Spring 2025, recent)
  • Permalink: https://is.muni.cz/course/fi/spring2025/PA036